[Rebell]

Hi,

prune players would be great.
So players that didnt connect for xxx days will be deleted of the db.

cya

[FrostbyteX]

Since there is some interest for better MySQL support, a web interface and pruning, those will all be in the next update. "topdeath" and "topkill" and "topkd" may be released as a separate plugin, so as to keep the base plugin as simple as possible.

Expect an update by the end of this week.

Steve

[Jezternz]

awesome! thats what I wanna hear Frostbyte!

[spacedkadet]

This plugin works fine as is but im trying to get it running with mysql remote host on my webserver. I have the database.cfg set correctly and the plugin can connect to it, however it cant make the tables. I edited the line in the sodstats.sp as posted by Jezternz on page 14 and then it made some of the tables but not all (see the error logs below). I believe its because the only remote db i can make on my host is mysql version5.
I would love if someone with more smarts than me could make me (and others that would need it) a sp or smx that works on mysql 5 so i can call it to a website

I have a couple of questions too:
Does there have to be a minimum number of players connected to the server before stats start logging?
and
i get this errors in my sourcemod log:

L 06/29/2008 - 15:52:37: [sodstats.smx] [SoD-Stats] SQL_LoadPlayerCallback failure: Unknown column 'headshots' in 'field list'
L 06/29/2008 - 15:54:07: [sodstats.smx] [SoD-Stats] SQL_LoadPlayerCallback failure: Unknown column 'headshots' in 'field list'
L 06/29/2008 - 15:54:44: [sodstats.smx] [SoD-Stats] SQL_LoadPlayerCallback failure: Unknown column 'headshots' in 'field list'
L 06/29/2008 - 15:54:45: [sodstats.smx] [SoD-Stats] SQL_LoadPlayerCallback failure: Unknown column 'headshots' in 'field list'
L 06/29/2008 - 15:58:01: [sodstats.smx] [SoD-Stats] SQL_LoadPlayerCallback failure: Unknown column 'headshots' in 'field list'
L 06/29/2008 - 16:07:08: [sodstats.smx] [SoD-Stats] SQL_LoadPlayerCallback failure: Unknown column 'headshots' in 'field list'

ty, lee.

[FrostbyteX]

The database schema has changed since 1.09. A new column, "headshots," was added. Use this instead:

CREATE TABLE `gamecent_gcnz`.`players` (
`rank` INT NOT NULL AUTO_INCREMENT ,
`score` INT( 12 ) NOT NULL DEFAULT '0',
`steamid` VARCHAR( 255 ) NOT NULL ,
`kills` INT( 12 ) NOT NULL DEFAULT '0',
`deaths` INT( 12 ) NOT NULL DEFAULT '0',
`shots` INT( 12 ) NOT NULL DEFAULT '0',
`hits` INT( 12 ) NOT NULL DEFAULT '0',
`name` VARCHAR( 255 ) NOT NULL ,
`active_badge` VARCHAR( 255 ) NOT NULL DEFAULT '0',
`time_played` VARCHAR( 11 ) NOT NULL DEFAULT '0',
`headshots` INT( 12 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( `rank` )
)

[Sgt-Mess]

Is it possible to have the players/clients rank displayed in a module like it is in tf2 for counter strike source.

[FrostbyteX]

Originally Posted by Sgt-Mess Is it possible to have the players/clients rank displayed in a module like it is in tf2 for counter strike source.

I'm not exactly sure what you mean. Do you have a picture?

[ompster]

is there anyway to count npc kills and deaths from npc's beacuse the mod im hosting is Zombie Master and you kill NPC's not other players and also die by npc's if you get what i mean, is there anyway to do this with sodstats.

[FrostbyteX]

Originally Posted by ompster is there anyway to count npc kills and deaths from npc's beacuse the mod im hosting is Zombie Master and you kill NPC's not other players and also die by npc's if you get what i mean, is there anyway to do this with sodstats.

That is very simple to change. I'll put that into next release.

sm_stats_botstats [1|0]

[FrostbyteX]

Originally Posted by Sgt-Mess Well in tf2 when a player types rank it shows it to just you in a menu kinda like an admin menu. But in counter-strike source it shows you it in text and to everyone.

I'll add displaying rank in menu to the next release.

Steve