search

thecannons / Insurgency-dy-sourcemod

Updated folder structure
31 stars 21 forks source link

Added function for ranking and statistics (need SQL Server) #7

Closed naong closed 8 years ago

naong commented 8 years ago

- MySQL Query:

CREATE TABLE ins_rank( rank_id int(64) NOT NULL auto_increment, steamId varchar(32) NOT NULL default '', nick varchar(128) NOT NULL default '', score int(12) NOT NULL default '0', kills int(12) NOT NULL default '0', deaths int(12) NOT NULL default '0', headshots int(12) NOT NULL default '0', sucsides int(12) NOT NULL default '0', revives int(12) NOT NULL default '0', heals int(12) NOT NULL default '0', last_active int(12) NOT NULL default '0', played_time int(12) NOT NULL default '0', PRIMARY KEY (rank_id)) ENGINE=INNODB DEFAULT CHARSET=utf8;

- sourcemod/configs/databases.cfg

"insrank"
{
    "driver"            "default"
    "host"              "127.0.0.1"
    "database"          "database_name"
    "user"              "database_user"
    "pass"              "PASSWORD"
    //"timeout"         "0"
    "port"          "3306"
}