Tremulous Forum

General => Official Servers => Topic started by: Lakitu7 on March 27, 2011, 10:48:02 PM

Title: US1 user location stats
Post by: Lakitu7 on March 27, 2011, 10:48:02 PM
Stats compiled for this phase so far, on US1. Each unique GUID is counted once. EU1 will get these stats eventually after various things are finished and approved.

There are some small bugs in this (like 2 people getting a country code of "Reno") but those are in the free geoip database and not my fault :)

Countries

  1200 United States
   184 Canada
   145 Poland
   138 France
   123 Australia
    87 Germany
    74 Philippines
    73 United Kingdom
    72 Brazil
    59 Russian Federation
    53 Peru
    52 Finland
    47 Italy
    36 Hong Kong
    34 New Zealand
    33 Singapore
    31 Mexico
    31 Belgium
    30 Czech Republic
    27 Sweden
    27 Netherlands
    26 Spain
    22 Hungary
    18 Israel
    16 Ukraine
    16 Taiwan
    15 Switzerland
    14 South Africa
    14 Portugal
    14 Japan
    14 Argentina
    13 Malaysia
    12 Romania
    10 Venezuela
     9 Korea, Republic of
     9 India
     9 China
     9 Chile
     8 Colombia
     7 Austria
     6 Slovakia
     6 Ireland
     6 Denmark
     5 Panama
     4 Vietnam
     4 Norway
     4 Kuwait
     4 Greece
     4 Estonia
     4 Croatia
     4 Costa Rica
     3 Turkey
     3 Iran, Islamic Republic of
     3 Indonesia
     2 United Arab Emirates
     2 Reno
     2 Lithuania
     2 Hillsboro
     2 Belarus
     1 South Richmond Hill
     1 Sosnowiec
     1 Slovenia
     1 San Giorgio A Cremano
     1 Quebec
     1 Prairieville
     1 Poznan
     1 Pittsburgh
     1 Perris
     1 Paraguay
     1 Palm Bay
     1 North Hollywood
     1 Neuostheim
     1 Morocco
     1 Macau
     1 Luxembourg
     1 Libyan Arab Jamahiriya
     1 Jordan
     1 Iceland
     1 Guatemala
     1 French Guiana
     1 Espoo
     1 El Salvador
     1 Ecuador
     1 Ebermannstadt
     1 Dominican Republic
     1 Bulgaria
     1 Bielefeld
     1 Bangladesh
     1 Anonymous Proxy
Title: Re: US1 user location stats
Post by: Lakitu7 on March 27, 2011, 10:50:44 PM
States and Canadian Provinces
     236 CA
     80 NY
     67 TX
     64 WA
     61 ON
     49 QC
     45 FL
     43 NJ
     40 MI
     40 IL
     39 PA
     37 VA
     37 OH
     28 UT
     24 OR
     24 MD
     24 KS
     24 BC
     23 MA
     23 AZ
     22 GA
     22 CO
     21 MB
     21 AK
     20 ME
     19 TN
     18 NC
     18 MN
     18 IN
     17 WI
     14 NV
     14 MO
     14 ID
     12 AB
     10 LA
      9 WY
      9 NS
      8 CT
      7 OK
      6 SK
      6 SC
      6 HI
      6 AL
      5 KY
      4 WV
      4 VT
      4 IA
      4 AR
      3 NM
      3 NH
      3 MS
      3 DE
      2 NE
      2 MT
      2 DC
      1 SD
      1 RI
      1 NL
      1 ND
      1 NB
      1 AE
Title: Re: US1 user location stats
Post by: Lakitu7 on March 27, 2011, 10:51:41 PM
Cities with > 1 person (Note that this is very biased as what "city" an ip number shows up as can be very fragmented.
     52 Brentwood
     23 Moscow
     22 Warsaw
      7 North Hollywood
      7 New York
      5 Willowbrook
      5 Milwaukee
      4 Spanaway
      4 Ottawa
      4 Kuwait
      4 Glasgow
      3 Stewartstown
      3 Rzesz?w
      3 Piotrk?w Trybunalski
      3 Kowloon
      3 Hayward
      3 Clearwater
      3 Caldwell
      3 Braunschweig
      2 Wroclaw
      2 Wahiawa
      2 Twickenham
      2 Tonawanda
      2 Przezmierowo
      2 Oswiecim
      2 Newcastle
      2 New Albin
      2 Morristown
      2 Lewiston
      2 Lawrenceville
      2 Lawrence
      2 Kwai Chung
      2 Kelowna
      2 Brownsburg
Title: Re: US1 user location stats
Post by: CreatureofHell on March 27, 2011, 10:54:58 PM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
      1 Anonymous Proxy
Win.
Title: Re: US1 user location stats
Post by: Pazuzu on March 27, 2011, 11:24:23 PM
Quote from: Lakitu7 on March 27, 2011, 10:50:44 PM
      4 VT
Yeah! Green Mountain State represent! ;D
Title: Re: US1 user location stats
Post by: Lakitu7 on March 27, 2011, 11:29:23 PM
Might be a more accurate way to do cities:
Here's it as cities, regioncodes/states, country triplets:

Brentwood,CA,United States|51
Lima,15,Peru|51
Poznan,86,Poland|37
Singapore,00,Singapore|32
Bremerton,WA,United States|31
Los Angeles,CA,United States|24
Moscow,48,Russian Federation|23
Montreal,QC,Canada|22
Warsaw,78,Poland|22
Winnipeg,MB,Canada|21
Central District,00,Hong Kong|19
Pasig,50,Philippines|19
Wichita,KS,United States|18
Sydney,02,Australia|16
,,Poland|15
Anchorage,AK,United States|15
Auckland,E7,New Zealand|15
Perth,08,Australia|15
,,United States|14
Brisbane,04,Australia|14
Toronto,ON,Canada|14
Chicago,IL,United States|12
Houston,TX,United States|12
S�o Paulo,27,Brazil|12
,,Russian Federation|11
Drummondville,QC,Canada|11
Helsinki,13,Finland|11
London,H9,United Kingdom|11
Budapest,05,Hungary|10
Las Vegas,NV,United States|10
Melbourne,07,Australia|10
Mexico,09,Mexico|10
Portland,OR,United States|10
Quezon City,F2,Philippines|10
Red Bank,NJ,United States|10
Seattle,WA,United States|10
Buenos Aires,07,Argentina|9
Christchurch,E9,New Zealand|9
North Hollywood,CA,United States|9
Sacramento,CA,United States|9
Taipei,03,Taiwan|9
Valenzuela,53,Philippines|9
,,Ukraine|8
Edmonton,AB,Canada|8
Manila,D9,Philippines|8
Rochester,NY,United States|8
Salt Lake City,UT,United States|8
,,Brazil|7
,,France|7
Adelaide,05,Australia|7


Turns out almost all of the Brentwoods are from one IP; probably one guy that just changes guids every day or whatever.
Title: Re: US1 user location stats
Post by: Pazuzu on March 27, 2011, 11:36:32 PM
Some of the triplets are missing data, like all the Polish players are apparently getting lumped into one region.
Quote from: Lakitu7 on March 27, 2011, 11:29:23 PM
Anchorage,AK,United States|15
Surprising... Do they have the whole Palin family playing or something?
Title: Re: US1 user location stats
Post by: Qrntz on March 27, 2011, 11:39:32 PM
Quote from: Lakitu7 on March 27, 2011, 11:29:23 PM
,,Ukraine|8
This is a lie. We have no , nor we do have . >:(
But seriously, your geolocation database is incomplete (I guess).
Title: Re: US1 user location stats
Post by: Lakitu7 on March 27, 2011, 11:44:17 PM
Yeah, it's a free database ( http://geolite.maxmind.com/download/geoip/database/ ); not the best / most complete, unsurprisingly.

Only 6 unique IPs from the Anchorage folks and they're probably the same guy too.
Title: Re: US1 user location stats
Post by: janev on March 28, 2011, 01:36:53 AM
I'm guessing there is an epic troll in Brentwood?
Title: Re: US1 user location stats
Post by: Menace13 on March 28, 2011, 02:03:55 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PMCountries
  1200 United States

Exactly 1200? lolwut

Let's try for 1337! :D
Title: Re: US1 user location stats
Post by: SlackerLinux on March 28, 2011, 02:45:12 AM
wow didn't expect us1 would have had 123 aussies interesting stats keep em coming latiku7
Title: Re: US1 user location stats
Post by: Meisseli on March 28, 2011, 08:06:34 AM
Hah, nice country that one, "Espoo (http://en.wikipedia.org/wiki/Espoo)".
Title: Re: US1 user location stats
Post by: gimhael on March 28, 2011, 08:43:58 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Bielefeld

OMG, THEY (http://en.wikipedia.org/wiki/Bielefeld_Conspiracy) have infiltrated tremulous !! :o
Title: Re: US1 user location stats
Post by: Nux on March 28, 2011, 04:39:06 PM
Quote from: gimhael on March 28, 2011, 08:43:58 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Bielefeld

OMG, THEY (http://en.wikipedia.org/wiki/Bielefeld_Conspiracy) have infiltrated tremulous !! :o

The fact that the alleged city is in a list of nations such as Belgium and the great nation of Anonymous Proxy only furthers suspicion.
Title: Re: US1 user location stats
Post by: OhaiReapd on March 28, 2011, 11:38:25 PM
Quote from: Lakitu7 on March 27, 2011, 10:50:44 PM
40 IL

Too bad none of those kids are active other than me.
Title: Re: US1 user location stats
Post by: swamp-cecil on March 29, 2011, 02:57:24 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Quebec
Quebec isnt a serperate country. Its part of canada.
Title: Re: US1 user location stats
Post by: mooseberry on March 29, 2011, 04:53:36 AM
Quote from: swamp-cecil on March 29, 2011, 02:57:24 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Quebec
Quebec isnt a serperate country. Its part of canada.

Yes, and that isn't the only imperfection of the data. It has been said several times it is not perfect.
Title: Re: US1 user location stats
Post by: kharnov on March 29, 2011, 05:07:12 AM
Quote from: swamp-cecil on March 29, 2011, 02:57:24 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
     1 Quebec
Quebec isnt a serperate country. Its part of canada.

You try to tell that to a Quebecois nationalist.
Title: Re: US1 user location stats
Post by: A Spork on March 29, 2011, 05:29:57 AM
Quote from: kharnov on March 29, 2011, 05:07:12 AM
Quote from: swamp-cecil on March 29, 2011, 02:57:24 AM
Quote from: Lakitu7 on March 27, 2011, 10:48:02 PM
      1 Quebec
Quebec isnt a serperate country. Its part of canada.

You try to tell that to a Quebecois nationalist.
yeah...

also, from wikipedia:
Quote from: WikipediaIn 2006, the Canadian House of Commons passed a symbolic motion recognizing the "Québécois as a nation within a united Canada."
Title: Re: US1 user location stats
Post by: swamp-cecil on March 29, 2011, 10:36:13 PM
I guess so. Besides, thers much contreversy in Quebec whether it should become a seperate country.
Also: I think i know who that Québéquois is.....Warlock?
Title: Re: US1 user location stats
Post by: A Spork on April 01, 2011, 02:25:00 AM
Likely. I know hes french Canadian, so chances are Quebec is his land.
Title: Re: US1 user location stats
Post by: CorSair on April 01, 2011, 07:37:17 PM
Quote from: Meisseli on March 28, 2011, 08:06:34 AM
Hah, nice country that one, "Espoo (http://en.wikipedia.org/wiki/Espoo)".
Rofl, probably someone managed to install some brand new hardware to turn Espoo into a country. :laugh:
Title: Re: US1 user location stats
Post by: Pazuzu on April 01, 2011, 08:53:59 PM
"Primary Export: Children Of Bodom (http://en.wikipedia.org/wiki/Children_of_Bodom)"
Title: Re: US1 user location stats
Post by: swamp-cecil on April 04, 2011, 01:27:02 AM
Quote from: A Spork on April 01, 2011, 02:25:00 AM
Likely. I know hes french Canadian, so chances are Quebec is his land.
So, the only french canadian place IS quebec and i remember him saying hes from there.
UNLESS he was lying and lives in yellowknife (artic)
Title: Re: US1 user location stats
Post by: A Spork on April 04, 2011, 01:59:11 AM
Quote from: swamp-cecil on April 04, 2011, 01:27:02 AM
Quote from: A Spork on April 01, 2011, 02:25:00 AM
Likely. I know hes french Canadian, so chances are Quebec is his land.
So, the only french canadian place IS quebec and i remember him saying hes from there.
UNLESS he was lying and lives in yellowknife (artic)
No, its just the only large predominately french area. Theres smaller places where french is the primary language, but generally not a large area outside Quebec