HLStats 1.63. Missing table

Kommentieren Jul 24 2012

 

If you get an error about a missing database table, here is the SQL statement to create it:

DROP TABLE IF EXISTS #DB_PREFIX#_Events_PlayerAttackedPlayer;

CREATE TABLE #DB_PREFIX#_Events_PlayerAttackedPlayer (

 `id` int(11) NOT NULL AUTO_INCREMENT,

 `eventTime` datetime DEFAULT NULL,

 `serverId` int(10) DEFAULT NULL,

 `map` varchar(64) DEFAULT NULL,

 `playerId` int(10) DEFAULT NULL,

 `weapon` varchar(64) DEFAULT NULL,

 `victimId` int(10) DEFAULT NULL,

 `damage` int(10) DEFAULT NULL,

 `armor` int(10) DEFAULT NULL,

 `health` int(10) DEFAULT NULL,

 `hitgroup` varchar(32) DEFAULT NULL,

 `damage_armor` int(10) DEFAULT NULL,

 PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Please remember to replace the #DB_PREFIX# with your DB prefix.

Thank you for your time, and sorry about this.