SC4 Devotion Forum Archives

SimCity 4 General Discussion and Tutorials => SimCity 4 General Discussion => General Custom Content Discussion => Topic started by: justinrpg on May 31, 2011, 05:20:58 PM

Title: custom query data?
Post by: justinrpg on May 31, 2011, 05:20:58 PM
Is it possible to have a custom query data for B.A.T.s and/or lots? what I mean is for example, if you query the Zoo it will have 'escaped animals' as info... for airport you will see 'lost luggage' and the private school you will see 'noogies given'

is there any way to make my own custom query data (or info) for B.A.T.s or lots that i create? I have a few parks and other stuff I made that I want to personalize with my own query info...
Title: Re: custom query data?
Post by: RebaLynnTS on May 31, 2011, 06:15:40 PM
Yes, it can be done. I'll try to give you more info later.
Title: Re: custom query data?
Post by: justinrpg on May 31, 2011, 07:12:35 PM
how long is later? I'm on pins and needles
Title: Re: custom query data?
Post by: joelyboy911 on May 31, 2011, 09:33:48 PM
It is very possible indeed.

Here's what RippleJet told me, when I wanted advice on a project of my own.

Quote from: RippleJet on March 16, 2010, 01:47:44 PM

That requires the property Goofy Stat Response Curve.
E.g, if you want "Engines Repaired" to be, say somewhere between 0 and 10,
you could give the Goofy Response Curve the following four values:

-100, 0, 0, 2, 50, 5, 100, 10

Mathematically that would first generate a random number between -100 and 100,
which would then be mapped to a number between 0 and 10 with the following chances:


  • 50% chance for a number between 0 and 2
  • 25% chance for a number between 2 and 5
  • 25% chance for a number between 5 and 10

That mapped number can then be referred to in a query with the id=0x0000106b

So essentially you mod your query, quite easy to add the text, then add the ID above (or use a query that already has a goofy stat indicator, and add the goofy stat response curve property to your building exemplar.

Hope this has helped.
Title: Re: custom query data?
Post by: justinrpg on May 31, 2011, 10:15:30 PM
can you show me with images and also what program(s) do you need?

for example how would i have something like...
Cats found: highest value
kittens found : i would want a number lower than cats found but higher than birds found (see next)
Birds found: lowest number of the three

here is an example of what could possibly come out
Cats Found: 10
Kittens Found: 5
Birds Found: 1


as you see here, I would like the best chance for 'cats found' to have a high number, an average 'kittens found' chance and 'birds found' doesn't have a very good chance to gain query data stats...

this is just an example, i may not use these exact query data, but it gives an idea of what i'm trying to do...


in order to do this, what program(s) do i need, and i would need the logic of the mathematics so i can accurately do this, a few lots i want to do this with alrady exist is some cities, will it take effect on those once edited?


images would be nice since i don't get what you are explaining
Title: Re: custom query data?
Post by: catty on June 01, 2011, 11:30:30 AM

This may help

http://www.simtropolis.com/forum/files/file/2511-its-a-custom-query-tutorial/

:)
Title: Re: custom query data?
Post by: justinrpg on June 01, 2011, 01:51:40 PM
I am stuck...
Number 1:
it says to open simcity_1.dat and look for UI file???
but that isn't coming up in that file...
it is full of S3D files, Exemplar Files, Cohort Files, and INI files...

but there isn't one UI files


Number 2:
this tutorial looks like it is just for custom text and background... not custom query data that I am trying to do there no mention of the 'Goofy Stat Response Curve' as mentioned by joelyboy911


for number 1, what am i doing wrong or is something else wrong? why isn't this UI file as the tutorial explains there...


for number 2: is there a different tutorial for what I am actually trying to achieve?
Title: Re: custom query data?
Post by: justinrpg on June 01, 2011, 02:18:30 PM
what is a custom XA file and how do I add one?
Title: Re: custom query data?
Post by: jmyers2043 on June 01, 2011, 08:36:47 PM
This topic should probably go in the modding help thread as it hasn't anything to do with batting.

@ Justin ... you're opening up a can of worms. The modification of queries that you're trying to do is not for the faint of heart. The skill set you're going to need is akin to intermidiate level or higher. Definitely not for beginners - else - you'll be asking for help every step of the way.

The best advice I'll give is for you to grab a lot with a query that has different types of goofy remarks and study it like crazy. Knowledge of iLives 'reader' and iLives 'LE prop' are a must.



- Jim

Title: Re: custom query data?
Post by: JBSimio on June 01, 2011, 09:26:23 PM
Quote from: jmyers2043 on June 01, 2011, 08:36:47 PM
Knowledge of iLives 'reader' and iLives 'LE prop' are a must.

iLive's UI Editor would be a great help here too.  My first forray into custom content was through custom queries.  I can certainly help if need be.  If you can't figure it out then let me know  ;)
Title: Re: custom query data?
Post by: RebaLynnTS on June 02, 2011, 06:55:38 AM
Check out one of my Modular Motel's they have custom queries that work like you want to do.
Title: Re: custom query data?
Post by: justinrpg on June 02, 2011, 08:02:05 AM
Quote from: jmyers2043 on June 01, 2011, 08:36:47 PM
This topic should probably go in the modding help thread as it hasn't anything to do with batting.

@ Justin ... you're opening up a can of worms. The modification of queries that you're trying to do is not for the faint of heart. The skill set you're going to need is akin to intermidiate level or higher. Definitely not for beginners - else - you'll be asking for help every step of the way.

The best advice I'll give is for you to grab a lot with a query that has different types of goofy remarks and study it like crazy. Knowledge of iLives 'reader' and iLives 'LE prop' are a must.



- Jim




If Ilives reader and modding isn't for beginners, how in the world is it possible to get intermediate? the first time ANYONE uses that, I can probably say they were a beginner... if Ilives is a intermediate/advance tool, no one would be able to use it (except probable the people who created it) my logic would be that it would impossible for anybody new to become intermediate/advanced... I have fixed a lot of people's computers, Installed operating systems for people, and cleaned several people's computers of malware. so, I am very computer savvy, and I cannot figure this out... so it isn't being computer savvy and using Ilives together that gets people to the Intermediate/advanced level.
Title: Re: custom query data?
Post by: jmyers2043 on June 02, 2011, 10:55:57 AM
Hey Justin

Quote from: justinrpg on June 02, 2011, 08:02:05 AM
so, I am very computer savvy,

good for you.

Quote from: jmyers2043 on June 01, 2011, 08:36:47 PM
The best advice I'll give is for you to grab a lot with a query that has different types of goofy remarks and study it like crazy.

As I said yesterday

Quote from: RebaLynnTS on June 02, 2011, 06:55:38 AM
Check out one of my Modular Motel's they have custom queries that work like you want to do.

There you go. Grab Reba's lot and study it. I'm sure the parts to the puzzle will fall into place.


Good Luck

- Jim

Title: Re: custom query data?
Post by: justinrpg on June 02, 2011, 12:23:34 PM
Quote from: RebaLynnTS on June 02, 2011, 06:55:38 AM
Check out one of my Modular Motel's they have custom queries that work like you want to do.
um, can you link me?
Title: Re: custom query data?
Post by: RebaLynnTS on June 02, 2011, 06:36:50 PM
Sure.

http://www.simpeg.com/forum/index.php?action=downloads;sa=view;down=572 (http://www.simpeg.com/forum/index.php?action=downloads;sa=view;down=572)
Title: Re: custom query data?
Post by: justinrpg on June 08, 2011, 03:48:10 PM
Quote from: RebaLynnTS on June 02, 2011, 06:36:50 PM
Sure.

http://www.simpeg.com/forum/index.php?action=downloads;sa=view;down=572 (http://www.simpeg.com/forum/index.php?action=downloads;sa=view;down=572)
I opened the .dat with the reader and there is nothing in there about that kind of queries!!!! is it because it is dat packed and I don't have access to the .sc4lot... or is this protected is some sort of way?
Title: Re: custom query data?
Post by: Lowkee33 on June 08, 2011, 06:13:28 PM
You will need the resource file (http://www.simpeg.com/forum/index.php?action=downloads;sa=view;down=570), not the lots.

The UI, PNG, and Unknown entries are the query.  Not too sure about queries myself, but this looks like a good example for what you want to do.