Re: [hlds] Who plays HLDMS
[ Converted text/html to text/plain ] I used Microsoft Visual FoxPro. I found a csv with ip to country listings, imported into a database, took all of my logs, imported them into another database, stripped out all non-connect entries, leaving just the entries that showed the players ip address. Stripped out all non-ip data from each entry, and created a unique list of ip addresses. Wrote a quick and dirty ip (xxx.xxx.xxx.xxx) to ip (9) program (because on table had ips in xxx.xxx.xxx.xxx format, where the other had them in numeric format), and then created a simple query that created an output list that would sum the total number of unique ips per country. The code is crude, and a lot of the work is done at the command line. It would take more time then it's worth to actually take all of this and put it into a distributable module that others could take and use :( And when I lived in Saudi, gas was 30 cents a gallon :P Tony Paloma wrote: I was mostly interested in the process of doing a country lookup on all those IP addresses. If I have a bunch of IPs myself, how do I turn them into a list like that? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Ottalini Sent: Wednesday, May 09, 2007 2:38 PM To: [EMAIL PROTECTED] Subject: Re: [hlds] Who plays HLDMS These are generated from the server logs by extracting the player's connect IP address, stripping out duplicates and then doing a country lookup. There are always a few bogus extra IP counts due to dynamic IP addresses, but not that many (a percent of the total or so). I cross verify the total count against the total number of unique SteamIDs during the same period of time just to make sure something weird isn't happening. There will always be more IP addresses then SteamIDs since there will always be connections that never actually enter the server. Doing a detailed SteamID VS IP address correlation is more difficult since the event times can vary and no one log line carries both pieces of information (WON logs had this but not Steam). There is at least one Server Stats program that will prepare a list like this automatically (I'm not sure which, might be superhebbe). - Original Message - From: "Tony Paloma" To: [4] Sent: Tuesday, May 08, 2007 8:06 PM Subject: RE: [hlds] Who plays HLDMS How did you generate these lists? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ook Sent: Sunday, May 06, 2007 8:54 PM To: [EMAIL PROTECTED] Subject: Re: [hlds] Who plays HLDMS Here is mine. Very interesting. If I did the math right, I had 7547 players from the US, and 17,648 from the rest of the world. Assuming each unique IP = a player. I could have matched IP to Steam ID to eliminate duplicates caused by players with dynamic IP and/or those that play from different places, might make a bit of a difference. 7547 UNITED STATES 2433 GERMANY 2424 RUSSIAN FEDERATION 1697 UNITED KINGDOM 1621 FRANCE 1132 CANADA 720 SPAIN 601 AUSTRALIA 582 SWEDEN 492 POLAND 457 BELGIUM 451 BRAZIL 432 TAIWAN PROVINCE OF CHINA 394 DENMARK 332 NETHERLANDS 329 FINLAND 306 NORWAY 243 TURKEY 231 SWITZERLAND 203 EUROPEAN UNION 187 PORTUGAL 171 ITALY 156 CZECH REPUBLIC 141 JAPAN 136 AUSTRIA 135 HUNGARY 134 UKRAINE 123 NEW ZEALAND 100 ESTONIA 97 Not Found 89 ROMANIA 84 IRELAND 82 THAILAND 65 SOUTH AFRICA 63 ISRAEL 62 HONG KONG 58 SINGAPORE 53 PAKISTAN 52 GREECE 47 KOREA REPUBLIC OF 39 MEXICO 39 SLOVAKIA (Slovak Republic 35 KAZAKHSTAN 34 SLOVENIA 33 BULGARIA 33 SAUDI ARABIA 32 LATVIA 32 MALAYSIA 19 BELARUS 19 ICELAND 14 QATAR 14 Serbia and Montenegro (Fo 13 LITHUANIA 13 PERU 13 UNITED ARAB EMIRATES 12 PUERTO RICO 11 CHILE 11 PHILIPPINES 11 RESERVED 10 CROATIA (local name: Hrva 10 INDIA 10 LUXEMBOURG 9 CHINA 9 FAROE ISLANDS 6 ARGENTINA 5 KUWAIT 4 MALTA 3 BAHRAIN 3 COLOMBIA 3 FRENCH POLYNESIA 3 GIBRALTAR 3 GUAM 3 MOROCCO 2 ANDORRA 2 CYPRUS 2 GUATEMALA 2 SRI LANKA 2 VENEZUELA 2 VIET NAM 1 ALBANIA 1 ALGERIA 1 BOLIVIA 1 BOSNIA AND HERZEGOWINA 1 COSTA RICA 1 DOMINICAN REPUBLIC 1 HONDURAS 1 MACEDONIA THE FORMER YUGO 1 MOLDOVA REPUBLIC OF 1 NEW CALEDONIA 1 NICARAGUA 1 PANAMA 1 TRINIDAD AND TOBAGO - Original Message - From: "Kevin Ottalini" To: [8] Sent: Sunday, May 06, 2007 4:38 AM Subject: Re: [hlds] Who plays HLDMS I use 255 on my servers, with HLDM:S there just aren't enough servers to make any difference, virtually all players will visit all servers looking for a good game. I just scanned my 2006 connection records for HLDM:S (52,531 unique IP addresses) and here is the list of countries that players joined from: 17354 US UNITED STATES 5346 DE GERMANY 3656 RU RUSSIAN FEDERATION 3511 FR FRANCE 3341 GB UNITED KINGDOM 2469 CA CANADA 1566 AU AUSTRALIA 1496 ES SPAIN 1276 SE SWEDEN 1038 BR BRAZIL 1003 TW TAIWAN PROVINCE OF CHINA 854 BE BELGIUM 740 NL NETHERLANDS 671 FI F
Re: [hlds] CPU selection
-- [ Picked text/plain from multipart/alternative ] Core2Duo's are probably the fastest now Xeons based on the core2duos maybe faster, but they will also be very expensive compared to regular core2duos and AMD's. On 5/11/07, Drew Hostetler <[EMAIL PROTECTED]> wrote: > > So I'm putting a new machine together to replace an older one that is > quite aged. The plan is to run 2 boosted 100 tick 12 or 13 man > private servers, one on each core. I'd have to upgrade the motherboard > and ram as well. > > I'm just curious if there is much importance as to what kind of chip I > get? X2? Core 2 Duo? Xeon? Opteron? I've been looking at an X2 5600+ > from AMD, but maybe there's something better out there for not too > much of a price difference. > > Does anyone have any suggestions? > > ___ > To unsubscribe, edit your list preferences, or view the list archives, > please visit: > http://list.valvesoftware.com/mailman/listinfo/hlds > -- ___ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds
[hlds] CPU selection
So I'm putting a new machine together to replace an older one that is quite aged. The plan is to run 2 boosted 100 tick 12 or 13 man private servers, one on each core. I'd have to upgrade the motherboard and ram as well. I'm just curious if there is much importance as to what kind of chip I get? X2? Core 2 Duo? Xeon? Opteron? I've been looking at an X2 5600+ from AMD, but maybe there's something better out there for not too much of a price difference. Does anyone have any suggestions? ___ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds
Re: [hlds] Who plays HLDMS
Tony, I don't know how Ooks did his but I wrote a set of scripts and small programs to do this, nothing that can be given out unfortunately. One of these days I'll convert them into a single c++ or c# program but I'm too busy to work on it right now. - Original Message - From: "Tony Paloma" To: Sent: Wednesday, May 09, 2007 9:59 PM Subject: RE: [hlds] Who plays HLDMS I was mostly interested in the process of doing a country lookup on all those IP addresses. If I have a bunch of IPs myself, how do I turn them into a list like that? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Ottalini Sent: Wednesday, May 09, 2007 2:38 PM To: hlds@list.valvesoftware.com Subject: Re: [hlds] Who plays HLDMS These are generated from the server logs by extracting the player's connect IP address, stripping out duplicates and then doing a country lookup. There are always a few bogus extra IP counts due to dynamic IP addresses, but not that many (a percent of the total or so). I cross verify the total count against the total number of unique SteamIDs during the same period of time just to make sure something weird isn't happening. There will always be more IP addresses then SteamIDs since there will always be connections that never actually enter the server. Doing a detailed SteamID VS IP address correlation is more difficult since the event times can vary and no one log line carries both pieces of information (WON logs had this but not Steam). There is at least one Server Stats program that will prepare a list like this automatically (I'm not sure which, might be superhebbe). - Original Message - From: "Tony Paloma" To: Sent: Tuesday, May 08, 2007 8:06 PM Subject: RE: [hlds] Who plays HLDMS How did you generate these lists? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ook Sent: Sunday, May 06, 2007 8:54 PM To: hlds@list.valvesoftware.com Subject: Re: [hlds] Who plays HLDMS Here is mine. Very interesting. If I did the math right, I had 7547 players from the US, and 17,648 from the rest of the world. Assuming each unique IP = a player. I could have matched IP to Steam ID to eliminate duplicates caused by players with dynamic IP and/or those that play from different places, might make a bit of a difference. 7547 UNITED STATES 2433 GERMANY 2424 RUSSIAN FEDERATION 1697 UNITED KINGDOM 1621 FRANCE 1132 CANADA 720 SPAIN 601 AUSTRALIA 582 SWEDEN 492 POLAND 457 BELGIUM 451 BRAZIL 432 TAIWAN PROVINCE OF CHINA 394 DENMARK 332 NETHERLANDS 329 FINLAND 306 NORWAY 243 TURKEY 231 SWITZERLAND 203 EUROPEAN UNION 187 PORTUGAL 171 ITALY 156 CZECH REPUBLIC 141 JAPAN 136 AUSTRIA 135 HUNGARY 134 UKRAINE 123 NEW ZEALAND 100 ESTONIA 97 Not Found 89 ROMANIA 84 IRELAND 82 THAILAND 65 SOUTH AFRICA 63 ISRAEL 62 HONG KONG 58 SINGAPORE 53 PAKISTAN 52 GREECE 47 KOREA REPUBLIC OF 39 MEXICO 39 SLOVAKIA (Slovak Republic 35 KAZAKHSTAN 34 SLOVENIA 33 BULGARIA 33 SAUDI ARABIA 32 LATVIA 32 MALAYSIA 19 BELARUS 19 ICELAND 14 QATAR 14 Serbia and Montenegro (Fo 13 LITHUANIA 13 PERU 13 UNITED ARAB EMIRATES 12 PUERTO RICO 11 CHILE 11 PHILIPPINES 11 RESERVED 10 CROATIA (local name: Hrva 10 INDIA 10 LUXEMBOURG 9 CHINA 9 FAROE ISLANDS 6 ARGENTINA 5 KUWAIT 4 MALTA 3 BAHRAIN 3 COLOMBIA 3 FRENCH POLYNESIA 3 GIBRALTAR 3 GUAM 3 MOROCCO 2 ANDORRA 2 CYPRUS 2 GUATEMALA 2 SRI LANKA 2 VENEZUELA 2 VIET NAM 1 ALBANIA 1 ALGERIA 1 BOLIVIA 1 BOSNIA AND HERZEGOWINA 1 COSTA RICA 1 DOMINICAN REPUBLIC 1 HONDURAS 1 MACEDONIA THE FORMER YUGO 1 MOLDOVA REPUBLIC OF 1 NEW CALEDONIA 1 NICARAGUA 1 PANAMA 1 TRINIDAD AND TOBAGO - Original Message - From: "Kevin Ottalini" To: Sent: Sunday, May 06, 2007 4:38 AM Subject: Re: [hlds] Who plays HLDMS I use 255 on my servers, with HLDM:S there just aren't enough servers to make any difference, virtually all players will visit all servers looking for a good game. I just scanned my 2006 connection records for HLDM:S (52,531 unique IP addresses) and here is the list of countries that players joined from: 17354 US UNITED STATES 5346 DE GERMANY 3656 RU RUSSIAN FEDERATION 3511 FR FRANCE 3341 GB UNITED KINGDOM 2469 CA CANADA 1566 AU AUSTRALIA 1496 ES SPAIN 1276 SE SWEDEN 1038 BR BRAZIL 1003 TW TAIWAN PROVINCE OF CHINA 854 BE BELGIUM 740 NL NETHERLANDS 671 FI FINLAND 651 DK DENMARK 632 NO NORWAY 617 PL POLAND 480 CH SWITZERLAND 478 EU EUROPEAN UNION 423 IT ITALY 397 PT PORTUGAL 371 AT AUSTRIA 350 EE ESTONIA 321 TR TURKEY 314 JP JAPAN 283 HU HUNGARY 254 NZ NEW ZEALAND 239 CZ CZECH REPUBLIC 177 TH THAILAND 172 IE IRELAND 146 SG SINGAPORE 139 IL ISRAEL 133 HK HONG KONG 131 KR KOREA REPUBLIC OF 130 UA UKRAINE 115 ZA SOUTH AFRICA 112 RO ROMANIA 95 GR GREECE 78 MX MEXICO 65 SI SLOVENIA 62 SA SAUDI ARABIA 55 SK SLOVAKIA (Slovak Republic) 54 KZ KAZAKHSTAN
Re: [hlds] [Fwd: [Fwd: NO GAS ON 15TH]](SPAM)
Agh, I can't really not respond publically to that, can I? Sorry for yet another post. I really hope we can stop this soon: UN rankings: http://hdr.undp.org/ (look for HDI index in the HD Reports) I don't live in the UK (though I've lived also there for about half a year). Look at my mail address - I am Norwegian. Cheers, Einar Luke Lewis wrote: > Calm down children. Now the UN rates places to live etc? I would love to see > that reference. But just my little tidbit of information, the United States > in ranked 10th in the GDP scale of countries. Topped by Ireland, Cayman > Islands, Guernsey, Norway, United Arab Emirates, Equatorial Guinea, > Luxemburg and Bermuda being #1. I believe earlier you precluded to live in > the U.K. which ranks 28th on that list. Best thing to-do is get your facts > before bragging. While the U.S. doesn't have the highest GDP we are up > pretty high on the list, with the average person making $43,500 a year vs. > the U.K. at $31,400. > > Linky: https://www.cia.gov/cia/publications/factbook/rankorder/2004rank.html > > Imagine that statements backed by a government website > > -BeNt- > /sorry just figured I would kick that in there since we are studying that in > my business classes now. > > > **Long winded replies edited.** > > > ___ > To unsubscribe, edit your list preferences, or view the list archives, please > visit: > http://list.valvesoftware.com/mailman/listinfo/hlds > ___ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds
RE: [hlds] [Fwd: [Fwd: NO GAS ON 15TH]](SPAM)
Calm down children. Now the UN rates places to live etc? I would love to see that reference. But just my little tidbit of information, the United States in ranked 10th in the GDP scale of countries. Topped by Ireland, Cayman Islands, Guernsey, Norway, United Arab Emirates, Equatorial Guinea, Luxemburg and Bermuda being #1. I believe earlier you precluded to live in the U.K. which ranks 28th on that list. Best thing to-do is get your facts before bragging. While the U.S. doesn't have the highest GDP we are up pretty high on the list, with the average person making $43,500 a year vs. the U.K. at $31,400. Linky: https://www.cia.gov/cia/publications/factbook/rankorder/2004rank.html Imagine that statements backed by a government website -BeNt- /sorry just figured I would kick that in there since we are studying that in my business classes now. **Long winded replies edited.** ___ To unsubscribe, edit your list preferences, or view the list archives, please visit: http://list.valvesoftware.com/mailman/listinfo/hlds
