JkNhZZCQ

1// Database Queries
2new const String:DBQueries[4][] =
3{
4	"CREATE TABLE IF NOT EXISTS `adminwatch` (`id` INT(10) NOT NULL AUTO_INCREMENT, `steam` VARCHAR(50) NOT NULL, `name` VARCHAR(50) NOT NULL, `total` INT(11) NOT NULL DEFAULT '0', `played` INT(11) NOT NULL DEFAULT '0', `last_played` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`)) COLLATE='latin1_swedish_ci' ENGINE=MyISAM;",
5	"SELECT * FROM `adminwatch` WHERE `steam` = '%s'",
6	"UPDATE `adminwatch` SET `total` = '%i', `played` = '%i', `last_played` = '%i' WHERE `steam` = '%s'",
7	"INSERT INTO `adminwatch` (`steam`, `name`, `total`, `played`, `last_played`) VALUES ('%s', '%s', '0', '0', '')"
8};
9
10new const String:DBQueriesLogs[2][] =
11{
12	"CREATE TABLE IF NOT EXISTS `adminwatch_logs` (`id` INT(10) NOT NULL AUTO_INCREMENT, `hostname` VARCHAR(50) NOT NULL, `name` VARCHAR(50) NOT NULL, `steam` VARCHAR(50) NOT NULL, `command` VARCHAR(100) NOT NULL, `time` VARCHAR(50) NOT NULL, PRIMARY KEY (`id`)) COLLATE='latin1_swedish_ci' ENGINE=MyISAM;",
13	"INSERT INTO `adminwatch_logs` (`hostname`, `steam`, `name`, `command`, `time`) VALUES ('%s', '%s', '%s', '%s', '%i')"
14};