[Elit59]

nice!

[nkSid]

Plugin crashes if I restart the server.

[ 2013 ] Lost connection to MySQL server at 'reading initial communication packet', system error: 111

[Hectik17]

do you think you could add somthing for PUGS? like when your team wins 1 point is added to a win tally?

like after 15 rounds,

idk i need to think about the way to doing a bit better but the map is restarted for the 2nd half after 15 then players swap teams and trey to beat the other teams score T6 CT8 maps rs and they swap teams so that means the T side have to beat 8 wins on the 2nd half, it would be good to somehow detect a match win and all players on that team get 1 point on the /rank

[FR0NTLINE]

Is this hectik from Australia ?

[ralze]

I've been using this plugin on my CS1.6 server and it works perfectly! The only "changes" I made was that I setup a trigger that anytime a record is updated in the csstats table it writes to a new table I setup called csstats_player_names. This way I can keep track of all the alias' a player uses. If you are interested in using, here is the mysql.

BEGIN
	IF EXISTS (SELECT 1 FROM `csstats_player_names` WHERE `player_id` = NEW.`id` AND `name` = NEW.`name`)
	THEN
		UPDATE `csstats_player_names` SET
			`last_used` = NOW(),
            `times_used` = `times_used` + 1
		WHERE `player_id` = NEW.`id` AND `name` = NEW.`name`;
	ELSE
		INSERT INTO `csstats_player_names` (
			`player_id`,
			`name`,
			`last_used`,
            `times_used`
		) VALUES (
			NEW.`id`,
			NEW.`name`,
            NOW(),
            1
		);
	END IF;
END

Would this work with the Natural Selection 1 module with some tweaks? We have a group of us who still play and I would love to be able to keep stats for that as well (quick googling has no produced any good results).

[GordonFreeman (RU)]

Originally Posted by ralze I've been using this plugin on my CS1.6 server and it works perfectly!

Hi there!

Originally Posted by ralze This way I can keep track of all the alias' a player uses. If you are interested in using, here is the mysql.

Thank you for sql script. Can you also post create table query for csstats_player_names? This may will be useful for someone.

I was planning total gameME stats replacement with one plugin, but just lost interest in cs 1.6 lyl

Originally Posted by ralze Would this work with the Natural Selection 1 module with some tweaks? We have a group of us who still play and I would love to be able to keep stats for that as well (quick googling has no produced any good results).

This plugin counts stats by itself, you need to rewrite stats hooks for NS.

Some info you need to know:

• weapon information
• Call Stats_* functions from your hooks.
• This one is used for round stats.

[ralze]

Originally Posted by GordonFreeman (RU) Thank you for sql script. Can you also post create table query for csstats_player_names? This may will be useful for someone. I was planning total gameME stats replacement with one plugin, but just lost interest in cs 1.6 lyl

Here you go!

CREATE TABLE `csstats_player_names` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `player_id` int(11) NOT NULL,
 `name` varchar(200) NOT NULL,
 `last_used` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `times_used` int(11) NOT NULL DEFAULT '1',
 PRIMARY KEY (`id`),
 KEY `player_id` (`player_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1

Originally Posted by GordonFreeman (RU) This plugin counts stats by itself, you need to rewrite stats hooks for NS. Some info you need to know: weapon information Call Stats_* functions from your hooks. This one is used for round stats.

Thanks, so I'll have to figure out the hooks for NS somehow. The fact this counts stats by itself really adds the value of this plugin. If I get more time I might try to port it to other modules as well (if that if alright with you).

[Hack1]

Hello, with the value csstats_sql_update "-1" and csstats_sql_cachetime "-1", when you kill the last person in one of the commands, the server hangs for a few seconds. With the value csstats_sql_update "0" and csstats_sql_cachetime "0", hangs occur only in the first round. What could be the problem?
Installed with the replacement module CSX
The value of csstats_mysql_forwards "1"

[GordonFreeman (RU)]

Originally Posted by Hack1 Hello, with the value csstats_sql_update "-1" and csstats_sql_cachetime "-1", when you kill the last person in one of the commands, the server hangs for a few seconds. With the value csstats_sql_update "0" and csstats_sql_cachetime "0", hangs occur only in the first round. What could be the problem? Installed with the replacement module CSX The value of csstats_mysql_forwards "1"

Its may cause by top15 plugins or any other plugins which using get_stats function.
Like stats marquee or etc.

Which of your plugins is using get_stats function (search in source files) ?

[jonatat]

Can add command to turn off and tur on this plugin? Like example csstats_ enable 1 and csstats_enable 0. Why? Becouse if user use this plugin in pug mod and pug have warmup dont save player stats until live... Thanks!