View Single Post
Lightokun
Member
Join Date: Oct 2009
Old 04-22-2011 , 13:50   Re: uq_jumpstats v2.38
Reply With Quote #382

You need only mysql module.
Check cvar by entering amx_cvar kz_uq_sql ingame (if you are admin) or kz_uq_sql in server console. You need to restart a map after cvars are changed. Also don't forget to change cvars in config file.

Here is the sql structure of the tables.

Code:
CREATE TABLE IF NOT EXISTS `uq_block_tops` (
  `pid` int(11) NOT NULL,
  `type` varchar(32) NOT NULL,
  `distance` int(10) NOT NULL,
  `jumpoff` int(10) NOT NULL,
  `block` varchar(5) NOT NULL,
  `pspeed` int(3) NOT NULL,
  `wpn` varchar(32) NOT NULL,
  KEY `pid` (`pid`,`type`,`distance`,`jumpoff`,`pspeed`,`wpn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `uq_jumps` (
  `pid` int(11) NOT NULL,
  `type` varchar(32) NOT NULL,
  `distance` int(10) NOT NULL,
  `maxspeed` int(10) NOT NULL,
  `prestrafe` int(10) NOT NULL,
  `strafes` int(2) NOT NULL,
  `sync` int(3) NOT NULL,
  `ddbh` int(3) NOT NULL DEFAULT '0',
  `pspeed` int(3) NOT NULL,
  `wpn` varchar(32) NOT NULL,
  KEY `pid` (`pid`,`type`,`distance`,`maxspeed`,`prestrafe`,`strafes`,`sync`,`ddbh`,`pspeed`,`wpn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `uq_players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `ip` varchar(39) NOT NULL,
  `authid` varchar(35) NOT NULL,
  `lastseen` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`,`authid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
__________________
Lightokun is offline