Simcountry is a multiplayer Internet game in which you are the president, commander in chief, and industrial leader. You have to make the tough decisions about cutting or raising taxes, how to allocate the federal budget, what kind of infrastructure you want, etc..
  Enter the Game

Detailed Country Search (White Giant)

Topics: General: Detailed Country Search (White Giant)

RagingPencil (White Giant)

Sunday, December 18, 2011 - 01:17 pm Click here to edit this post
Country Search (WG only and country data isn't being updated for now)

Current options are,

CountryID
Country Name
Score
Health Care Index
Transportation Index
Education Index
Social Security Index
Employment Index
Finance Index
Assets Index
Business Index
Welfare Index
Defensive Index
Offensive Index
Strategic Index
Defense Index
Immigration Index
War Index
vCarea
vCneighborNW
vCneighborNE
vCneighborE
vCneighborSE
vCneighborSW
vCneighborW
vCEastLongitude
vCSouthLattitude
vCWestLongitude
vCNorthLattitude
vCCountryWithCoastLine
vContinentNumber
vRegionNumber
vCIsMemberOfFederation
vCmainTotalPopulation
Common Market Score
Total Corporate Value
Total Employed
Total Unemployed
Total Income
Employed Officers
Employed Soldiers
Employed Army
Active Wars
Country Secured Assets
Total Production Value

With operators

Equal To
Greater Then
Equal To or Greater Then
Lesser Then
Equal To or Lesser Then
Contains

For example

Country Name, Contains, "raging"

Would output The Raging Pencil Empire

Plans are to:
- List all countries (later on, CEO's too) that meet the search in a table with all data shown. Currently only country name and a link are displayed)

- Have multiple searches. For example

Finance Index, Greater Then, "150"
vContinentNumber, Equal To, "5"
Defensive Index, Lower Then, "20"
Country Secured Assets, Equal To, "0"

- Change all unreadable stuff (vContinentNumber, vRegionNumber, 0 (false), 1 (true) etc) to the actual names.

Too bad more data like War level isn't shown :(
Secret Data remains secret!

What yall think, useful at all? Ideas?

RagingPencil (White Giant)

Sunday, December 18, 2011 - 01:22 pm Click here to edit this post
Oh and president Name, nukes etc can be added.

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 02:24 am Click here to edit this post
Pencil guy/gal, I could love you right now

Slade (Little Upsilon)

Monday, December 19, 2011 - 03:44 am Click here to edit this post
Wow impressive

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 10:25 am Click here to edit this post
Okay. There are a few things I noticed right away.

A world Filter Could be added.

War Level. Filter

Inactive By Week, Month, Inactive - Filter

You're quickly becoming a celebrity with these tools. Have you ever done any consultation with w3c? They would do well to give you their ear for a moment or so.

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 10:29 am Click here to edit this post
Country Secured Assets needs fixed. I tried countries with greater than or equal too 100T and also used 50T and no countries pop up. But if I change the operator to less than or equal too just about every one showed up.

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 10:31 am Click here to edit this post
Also getting this on some searches.

Warning: Invalid argument supplied for foreach() in /home/suncoas1/public_html/sc/country-search.php on line 223

Warning: Invalid argument supplied for foreach() in /home/suncoas1/public_html/sc/country-search.php on line 172

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 10:36 am Click here to edit this post
Upon further inspection quite a few of the values are not bringing up the correct countries. It fetches the same list regardless of what criteria I use or it pulls up nothing at all. A little tweaking, but I'm excited for an update.

RagingPencil (Little Upsilon)

Monday, December 19, 2011 - 10:44 am Click here to edit this post
All worlds working
Data updated every 4 hours
5 search criteria available (5 enough?)

RagingPencil (Little Upsilon)

Monday, December 19, 2011 - 10:48 am Click here to edit this post
Thanks WitchyPoo.

The warnings are because I have yet to add any validation checks.

I've started now. If your search returns nothing, it should tell you.

RagingPencil (Little Upsilon)

Monday, December 19, 2011 - 10:52 am Click here to edit this post

Quote:

Country Secured Assets needs fixed. I tried countries with greater than or equal too 100T and also used 50T and no countries pop up. But if I change the operator to less than or equal too just about every one showed up.




Country Secured Assets options are actually 1 or 0.

1 = True. Meaning the country is in secure mode
0 = Not secure

RagingPencil (Little Upsilon)

Monday, December 19, 2011 - 10:53 am Click here to edit this post
All this data is pulled from the CSV in "My Downloads" section. (Not my fault for the wording! Although I can go through and rename things when i get more time)

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 11:24 am Click here to edit this post
Ph ok. I misunderstood some things then. I see. Maybe I need to recheck. Will you a war level and Search by World filter

RagingPencil (White Giant)

Monday, December 19, 2011 - 11:31 am Click here to edit this post
War level is unfortunately not found in any of the downloadable excel data that i can see. I'll see if there is a way.

What did u mean Search by World filter?

At present u can only search each world. Did u mean all worlds at once?

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 11:46 am Click here to edit this post
Search by world. The results bring up just country name and there is no way to tell if they are from which planet. This could be simplified so that I don't have to look through the results of whatever I search. For example if I could search through LU I wouldn't need to endlessly sift through the top results to find the LU countries.

Similar to the way you can choose to look at products by world. And compare World VS World.

An example would be: Input-World + Input-Value + Input-Operator = Output-World/Value/Operator and you would get your result specific to whatever world you input.

RagingPencil (White Giant)

Monday, December 19, 2011 - 11:57 am Click here to edit this post
The results should be filtered by world.

You can select what world down the bottom or by changing the link "http://sc.suncoastcomputers.com.au/country-search.php?w=wg" (w=lu or fb etc)

The default world is wg if none is selected.

Let me know if that isn't what you mean.

WitchyPoo (Golden Rainbow)

Monday, December 19, 2011 - 12:15 pm Click here to edit this post
Ah yeah ok.. I think my browser is not acting right. I didn't see a world filter. The news bar isn't working in my countries atm,I think I need to clear my cache. Yup I see now. WG countries were coming up since I didn't put anything in. Well, you know that it is working right. I appreciate this tool.

Jo Salkilld (White Giant)

Monday, December 19, 2011 - 02:45 pm Click here to edit this post
Awesome work, Raging Pencil!

Thankyou :)

Hugs and respect

Jo

Rick (Golden Rainbow)

Wednesday, December 21, 2011 - 05:59 am Click here to edit this post
Great set of tools, very helpful!

Thanks much


Add a Message