Membership by country ( country flag)

Hercules · April 30, 2003, 09:11

I thought I'd try this membership search by country (country flag) on this new server.

And it works. I couldn't get the search to work on the previous server or it was taking too long that I gave up.

The idea was to explore the possibility of national championships, or national/country teams pbem games; in my partcular interest SMAC/X.

An Apolyton Olympics so to speak. (I realise you can be a national team within Civ, but this was different).

I am glad the search works and it is interesting to see membership stats by nationality? ( I know/ think you can designate your own flag of allegience so not necessarily accurate to residency).

It even gives you some idea how current national members are.

If this capability was present on the previous server but just was inoperable or very very very slow, let me know.

If it is just my ancient computer it is useful to know that too.

I am not sure if I could rustle up an Irish team as was my original reason for exploring but a Irish/British Isles team could be a possibility.

On the otherhand 'Poly is so international in ethos, this may not be in keeping with the proper spirit of things.

Jamski · April 30, 2003, 09:14

It must have been your old compy, Herc. I've used this feature before. Could I join a Irish team - I have no Irish blood, but I had an Irish g/f once - does that count?

I like Guiness and Paddy Whiskey too

-Jam

Hercules · April 30, 2003, 09:37

Blast! I thought I was providing an information service to the community here.

Update: looking for detail list of United Kingdom and United States members throws up ' Bad request' message. Also for the Vatican city membership.

So the Pope plays Civ. That 's why he visits all those countries and post edicts. He wants to reach Deity

OK War of Art edited.

Yes Clicking on flags works for US and others I presume

FrustratedPoet · April 30, 2003, 09:39

Just click on a flag icon to view all the members who have that flag selected.

The list is sorted by post count and allows us to see that Hercules has the highest post count of anyone with the Irish flag, and is the only King. Dan Magaha from Firaxis is third on the list.

Jamski · April 30, 2003, 09:41

Vacation City eh? I think I went there for a holiday once

I'm pretty sure the problem with the UK and USA is that there are sooooo many posters from those countrys. The other problem is because of all the pope's Double Logins

-Jam

Dauphin · April 30, 2003, 10:26

It would make a good poll to see how many people actually live in or have citizenship in the country whose flag they use.

I for one don't, but my excuse is that I'm just lost.

Immortal Wombat · April 30, 2003, 11:07

My situation and excuse is the same as yours.

Dauphin · April 30, 2003, 11:10

I've never heard of a Gibraltar triangle.

Immortal Wombat · April 30, 2003, 12:35

I'd advise you to stay away from here then. Do you think I'd be stuck here if I'd heard of it beforehand?

Alex · April 30, 2003, 16:21

Originally posted by Immortal Wombat
I'd advise you to stay away from here then. Do you think I'd be stuck here if I'd heard of it beforehand?

Well, I actually am from Brazil and I live in Brazil.

Skanky Burns · April 30, 2003, 17:27

I have the flag of the country that I live in. I tried to be interesting before, but apparently Markos doesn't like the country of "Darlek"s.

Tuberski · April 30, 2003, 17:38

Originally posted by Skanky Burns
I have the flag of the country that I live in. I tried to be interesting before, but apparently Markos doesn't like the country of "Darlek"s.

I'm glad you stopped trying to be interesting.

ACK!

DrSpike · April 30, 2003, 17:46

:badpunwarning:

Now he's just interested in being trying.

Ben Kenobi · April 30, 2003, 20:39

Obviously a tried and true habit.

I'm a Canuck. Seriously, the Apolyton olympics sounds like an interesting idea if we can round up enough non-Americans to participate.

Straybow · May 1, 2003, 01:43

Or Americans who've chosen odd flags 'coz of some political thingy or the flag looks cool.

Free East Timor!!

Straybow · May 1, 2003, 01:46

See, it works, too!

Urban Ranger · May 2, 2003, 00:17

Originally posted by Hercules
Blast! I thought I was providing an information service to the community here.

Thanks for the try, though, even I had discovered it way before you did.

Jaguar · May 2, 2003, 02:27

I use the Israeli flag because I'm Jewish, and I think a number of people do the same. (panag?)

Jamski · May 2, 2003, 02:30

I think he uses it to wind people up who are Jewish. Like ironically aping the Americanism "Have a nive day" to wind up Americans. He's one funny man, when you analyse what he's up to.

-Jam

Chilean President™ · May 2, 2003, 02:51

I use the Israeli flag because I'm Jewish, and I think a number of people do the same. (panag?)

I thought panag lived in Tel Aviv

RGBVideo · May 2, 2003, 11:06

No, wasn't panag from Belgium?

Spiffor · May 2, 2003, 12:53

Panag told us once he traveled much in the surroundings of Belgium (Northern Germany, norhtern France etc.).
With Trip, we came to the conclusion Panag was an about 50 years old Belgian lady

Alex · May 2, 2003, 17:06

Originally posted by Spiffor

With Trip, we came to the conclusion Panag was an about 50 years old Belgian lady

That would explain the "have a nice day" thing.

Panag · May 3, 2003, 10:08

Originally posted by Jaguar Warrior
I use the Israeli flag because I'm Jewish, and I think a number of people do the same. (panag?)

hi ,

cause i am Jewish and Israeli , .....

and proud the fly the blue and white

have a nice day

Panag · May 3, 2003, 10:10

Originally posted by Spiffor
Panag told us once he traveled much in the surroundings of Belgium (Northern Germany, norhtern France etc.).
With Trip, we came to the conclusion Panag was an about 50 years old Belgian lady

hi ,

, that would explain why he was asking me out on a date , .....

have a nice day

the first part is true , the second , ....

and now back to topic please

P.S. > every Jew has the right of Israeli citizenship , but not every Israeli is a Jew , ......

yaroslav · May 3, 2003, 17:06

I don't believe that the flags are a good way for guessing the nationality of a poster... I, for example, switch constantly between the Spanish, the European and the Israelian...

Returning to topic, What about the Olimpics Games of Apolyton suggested in this thread? Are more people, besides Hercules, willing to set-up teams for Civ2 or Civ3?

Gramphos · May 3, 2003, 17:11

Originally posted by Hercules
I thought I'd try this membership search by country (country flag) on this new server.

And it works. I couldn't get the search to work on the previous server or it was taking too long that I gave up.

It was not the old server, but the old querry-solution. I suggested I shange in the code to make it 'a little' faster. It shall have been able to use it since the civgroups got public. (Maybe some time before that too.)

I don't have the exact figures on time saved here, but I did check the change in number of querries and page generation time somewhere...

Gramphos · May 3, 2003, 17:54

I found the figures:
The old code before I got my hands on the memberlist code for adding civgroups:

Page generated in 245.7268190 seconds (0.10% PHP - 99.90% MySQL) with 331 queries

The current code (on the old server and some other old code I guess (11 queries instead of 9 that it's now))

Page generated in 0.7286299 seconds (10.84% PHP - 89.16% MySQL) with 11 queries

And now:

Page generated in 0.3243 seconds (16.30% PHP - 83.70% MySQL) with 9 queries

Ben Kenobi · May 3, 2003, 19:45

Returning to topic, What about the Olimpics Games of Apolyton suggested in this thread? Are more people, besides Hercules, willing to set-up teams for Civ2 or Civ3?

That's three recommendations.
Any others?