Thread: CSstatsX SQL
View Single Post
ralze
New Member
Join Date: Mar 2017
Old 03-20-2017 , 10:03   Re: CSstatsX SQL
Reply With Quote #47

Quote:
Originally Posted by GordonFreeman (RU) View Post
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!
Code:
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
Quote:
Originally Posted by GordonFreeman (RU) View Post
This plugin counts stats by itself, you need to rewrite stats hooks for NS.

Some info you need to know:
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).
ralze is offline