[HSFighter]

Nice Plugin! Great Work

Add to the next relase of Sourcemod-Webadmin.

Thx

[HSFighter]

I found a smal Bug:

PHP Code: CREATE TABLE player_tracker (     id int(11) auto_increment not null,     steamid varchar(255) not null,     playerip varchar(255) not null,     servertype varchar(255) not null,     serverip varchar(255) not null,     PRIMARY KEY (id),     UNIQUE steamid (steamid) );

your missing the 'status' column in your SQL-Dump! ( status varchar(255) not null )

[tracker.smx] SQL Error: Unknown column 'status' in 'field list'

Else nice work



Request:
Any chance to log players Name?

[msleeper]

Okay I have fixed the SQL on the first page, thanks for catching that.

As I have said before, I have no real need to track player name but adding support for it would not be difficult at all. I'll see if I can make the small addition to track name.

[msleeper]

I updated the plugin to 1.2. I added name tracking due to popular request. The plugin will now update player name instead of player IP on duplicate entry.

[vertexshader]

CREATE TABLE `player_tracker` ( `id` int(11) NOT NULL auto_increment, `steamid` varchar(255) NOT NULL, `playername` varchar(255) NOT NULL, `playerip` varchar(255) NOT NULL, `servertype` varchar(255) NOT NULL, `serverip` varchar(255) NOT NULL, `status` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `steamid` (`steamid`), KEY `playername` (`playername`), KEY `playerip` (`playerip`), KEY `servertype` (`servertype`), KEY `serverip` (`serverip`), KEY `status` (`status`), );

Got this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 16

[fnaskari]

PHP Code:

CREATE TABLE `player_tracker` (
  `id` int(11) NOT NULL auto_increment,
  `steamid` varchar(255) NOT NULL,
  `playername` varchar(255) NOT NULL,
  `playerip` varchar(255) NOT NULL,
  `servertype` varchar(255) NOT NULL,
  `serverip` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `steamid` (`steamid`),
  KEY `playername` (`playername`),
  KEY `playerip` (`playerip`),
  KEY `servertype` (`servertype`),
  KEY `serverip` (`serverip`),
  KEY `status` (`status`)
); 


commas in wrong spot

[msleeper]

Doh, thanks. First post fixed.

[vertexshader]

msleeper, can you release version which checks in GeoIP and adds country and the city of player in the table too ?

[msleeper]

I can look into that. I don't know if I can do city, but I think I can do country. I've never really worked with GeoIP stuff before.

[msleeper]

Well that was pretty easy. New version is updated. Also it looks like I forgot to update the plugin to 1.3, so here is the changelog for both 1.3 and 1.4 (current).

-- 1.3 (6/16/10)
 . Removed duplicate error messaging.
 . Increased MySQL query sizes for instances where the string would be
   longer than expected (that's what she said).

-- 1.4 (7/14/10)
 . Added GeoIP Country field to table, and added new cvar to control how the
   country name is stored.
 . Changed INSERT statement to update all possible fields (name, player IP,
   game type, server IP and GeoIP country) when a duplicate entry is found.
 . Added query to properly handle UTF8 player names.

Here is the SQL you can run to modify an existing table with the new GeoIP Country field:

PHP Code:

    ALTER  TABLE  `player_tracker`  ADD  `geoipcountry` VARCHAR( 255  )  NOT  NULL  AFTER  `serverip` ; 


And lastly, here is the new cvar. I recommend simply deleting your config file and letting the plugin generate a new one.

sm_tracker_geoiptype - Add player's GeoIP country to the database. 0 = Disabled, 1 = 2 letter Country Code, 2 = 3 letter Country Code, 3 = full Country Name.