Oops, an error was introduced when I modified the db connection code
before posting:
c = db.cursor(...
should be
cursor = db.cursor(...
Cheers,
Einar
Einar S. Idsø wrote:
> Seems attachments don't work. Here's the text from the script. Make sure
> to fix the indentation and line-breaks before tr
Seems attachments don't work. Here's the text from the script. Make sure
to fix the indentation and line-breaks before trying it out:
#!/usr/bin/env python
import sys
import os
import MySQLdb
import re
db = MySQLdb.connect(host, user, password, database)
c = db.cursor(MySQLdb.cursors.DictCursor
This is a multi-part message in MIME format.
--
Attached is a quick and dirty implementation for Python. It's hideously
slow since it makes a select-query for each IP. It uses the GeoLite csv
file imported into a MySQL database:
http://www.maxmind.com/app/geoip_country
Be sure to change the logDir
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 ar
---
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
, 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 dynam
t 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
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
OLDOVA REPUBLIC OF
1 NEW CALEDONIA
1 NICARAGUA
1 PANAMA
1 TRINIDAD AND TOBAGO
- Original Message -
From: "Kevin Ottalini" <[EMAIL PROTECTED]>
To:
Sent: Sunday, May 06, 2007 4:38 AM
Subject: Re: [hlds] Who plays HLDMS
>I use 255 on my servers, with HLDM:S
o:
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 HLD
AIJAN
- Original Message -
From: "Ook"
To:
Sent: Saturday, May 05, 2007 8:40 AM
Subject: [hlds] Who plays HLDMS
I'm looking at my server, Half-Life DeathMatch Source, and not one player
from is from the USA:
UK - 1
Turkey - 2
Russia - 3
Poland - 1
Austria - 1
This
;
To:
Sent: Saturday, May 05, 2007 11:41 AM
Subject: Re: [hlds] Who plays HLDMS
Try one of the US:
US eastcoast - sv_region 0
US westcoast - sv_region 1
south america - sv_region 2
europe - sv_region 3
asia - sv_region 4
australia - sv_region 5
middle east - sv_region 6
africa - sv_region 7
wo
255" ( def. "-1" )
- Original Message -
From: "Ronny Schedel" <[EMAIL PROTECTED]>
To:
Sent: Saturday, May 05, 2007 10:21 AM
Subject: Re: [hlds] Who plays HLDMS
Try setting sv_region to the correct value.
Best regards
Ronny
I'm looking at my serv
0:59:11 "sv_region" = "255" ( def. "-1" )
- Original Message -
From: "Ronny Schedel" <[EMAIL PROTECTED]>
To:
Sent: Saturday, May 05, 2007 10:21 AM
Subject: Re: [hlds] Who plays HLDMS
Try setting sv_region to the correct value.
Best r
Try setting sv_region to the correct value.
Best regards
Ronny
I'm looking at my server, Half-Life DeathMatch Source, and not one player
from is from the USA:
UK - 1
Turkey - 2
Russia - 3
Poland - 1
Austria - 1
This seems to be a fairly consistent pattern, I seem to get more players
from Eur
I'm looking at my server, Half-Life DeathMatch Source, and not one player
from is from the USA:
UK - 1
Turkey - 2
Russia - 3
Poland - 1
Austria - 1
This seems to be a fairly consistent pattern, I seem to get more players
from Europe the the USA. I'm wondering if my lackluster ISP (Centel), which
16 matches
Mail list logo