· 8 years ago · May 21, 2018, 05:22 PM
1[05-21-2018 05:12:00 PM] ~ [FAIL] No Connection
2[05-21-2018 05:12:00 PM] ~ [FAIL] No Connection
3[05-21-2018 05:12:04 PM] ~ [FAIL] No Connection
4[05-21-2018 05:12:23 PM] ~ [FAIL] No Connection
5[05-21-2018 05:12:43 PM] ~ [FAIL] No Connection
6[05-21-2018 05:12:45 PM] ~ [FAIL] No Connection
7[05-21-2018 05:12:45 PM] ~ [FAIL] -
8 - Query: SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
9[05-21-2018 05:12:45 PM] ~ [QUERY] - DROP TABLE IF EXISTS `kload_users`
10[05-21-2018 05:12:45 PM] ~ [QUERY] - DROP TABLE IF EXISTS `kload_settings`
11[05-21-2018 05:12:45 PM] ~ [QUERY] - DROP TABLE IF EXISTS `kload_sessions`
12[05-21-2018 05:12:45 PM] ~ [QUERY] - CREATE TABLE IF NOT EXISTS kload_users (
13 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
14 name VARCHAR(32) NULL COMMENT 'steam name',
15 steamid BIGINT(20) NOT NULL COMMENT 'steamid, e.g. 76561198296852117',
16 steamid2 VARCHAR(20) NOT NULL COMMENT 'steam2 id, e.g. STEAM_...',
17 steamid3 VARCHAR(20) NOT NULL COMMENT 'steam3 id, e.g. [U:1:...',
18 admin TINYINT(1) DEFAULT 0 COMMENT 'is the user an admin?',
19 perms TEXT NULL COMMENT 'list of perms, inactive when admin = 0',
20 settings TEXT NULL COMMENT 'user settings in JSON',
21 custom_css VARCHAR(500) NULL COMMENT 'user css for styling',
22 banned TINYINT(1) DEFAULT 0 COMMENT 'is the user banned?',
23 registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'date when joined'
24 ) DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci
25[05-21-2018 05:12:45 PM] ~ [QUERY] - CREATE UNIQUE INDEX kload_users_index ON kload_users(steamid, steamid2, steamid3)
26[05-21-2018 05:12:45 PM] ~ [QUERY] - CREATE TABLE IF NOT EXISTS kload_settings (
27 name VARCHAR(50) NOT NULL UNIQUE,
28 value TEXT NOT NULL
29 ) DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci
30[05-21-2018 05:12:45 PM] ~ [QUERY] - CREATE TABLE IF NOT EXISTS kload_sessions (
31 steamid BIGINT(20) NOT NULL UNIQUE COMMENT 'steamid, e.g. 76561198296852117',
32 token VARCHAR(64) NOT NULL UNIQUE COMMENT 'csrf token',
33 expires TIMESTAMP NULL COMMENT 'date at which token is invalid'
34 ) DEFAULT CHARSET=utf8mb4
35[05-21-2018 05:12:45 PM] ~ [QUERY] - CREATE TRIGGER csrf_fix_insert BEFORE INSERT ON `kload_sessions` FOR EACH ROW SET NEW.expires = TIMESTAMPADD(DAY,1,CURRENT_TIMESTAMP)
36[05-21-2018 05:12:45 PM] ~ [QUERY] - CREATE TRIGGER csrf_fix_update BEFORE UPDATE ON `kload_sessions` FOR EACH ROW SET NEW.expires = TIMESTAMPADD(DAY,1,CURRENT_TIMESTAMP)
37[05-21-2018 05:12:45 PM] ~ [QUERY] - INSERT INTO `kload_settings` (`name`, `value`) VALUES('version','0.0.1'),('gms_ver','19180'),('community_name','K-Load'),('backgrounds','[]'),('description','Sample description'),('messages','[]'),('rules','[]'),('staff','[]'),('youtube','[]'),('test','76561198296852117')
38[05-21-2018 05:12:45 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
39[05-21-2018 05:12:45 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.0.2' WHERE `name` = 'version'
40[05-21-2018 05:12:45 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
41[05-21-2018 05:12:45 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.0.3' WHERE `name` = 'version'
42[05-21-2018 05:12:45 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
43[05-21-2018 05:12:45 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.0' WHERE `name` = 'version'
44[05-21-2018 05:12:45 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
45[05-21-2018 05:12:45 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.1' WHERE `name` = 'version'
46[05-21-2018 05:12:45 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
47[05-21-2018 05:12:45 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.2' WHERE `name` = 'version'
48[05-21-2018 05:12:45 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
49[05-21-2018 05:12:46 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.3' WHERE `name` = 'version'
50[05-21-2018 05:12:46 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
51[05-21-2018 05:12:50 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.4' WHERE `name` = 'version'
52[05-21-2018 05:12:50 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
53[05-21-2018 05:12:50 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.5' WHERE `name` = 'version'
54[05-21-2018 05:12:50 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
55[05-21-2018 05:12:50 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.6' WHERE `name` = 'version'
56[05-21-2018 05:12:50 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
57[05-21-2018 05:12:50 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.7' WHERE `name` = 'version'
58[05-21-2018 05:12:50 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
59[05-21-2018 05:12:50 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.8' WHERE `name` = 'version'
60[05-21-2018 05:12:50 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
61[05-21-2018 05:12:50 PM] ~ [QUERY] - INSERT IGNORE INTO `kload_users` (`name`, `steamid`, `steamid2`, `steamid3`, `perms`, `settings`) VALUES('jakoblarsenesbjerg','76561198296852117','STEAM_1:1:168293194','[U:1:336586389]','[]','{\"theme\":\"default\",\"backgrounds\":{\"enable\":1,\"random\":0,\"duration\":5000,\"fade\":750},\"youtube\":{\"enable\":0,\"random\":0,\"list\":[]}}')
62[05-21-2018 05:12:51 PM] ~ [QUERY] - UPDATE `kload_users` SET `name` = 'jakoblarsenesbjerg' WHERE `steamid` = '76561198296852117'
63[05-21-2018 05:12:51 PM] ~ [QUERY] - SELECT `admin` FROM `kload_users` WHERE `steamid` = '76561198296852117'
64[05-21-2018 05:12:51 PM] ~ [QUERY] - SELECT `id`, `name`, `steamid`, `steamid2`, `steamid3`, `settings`, `custom_css` AS `css`, `admin`, `perms`,`banned`, DATE_FORMAT(`registered`, '%m/%d/%Y %r') AS `registered` FROM `kload_users` WHERE `steamid` = '76561198072086712'
65[05-21-2018 05:12:51 PM] ~ [QUERY] - INSERT INTO `kload_sessions` (`steamid`, `token`) VALUES('76561198296852117','7a958c79a7e30106463cfee73d258afa9cfe638de721a17f291e3e07722a3ddb') ON DUPLICATE KEY UPDATE `token` = '7a958c79a7e30106463cfee73d258afa9cfe638de721a17f291e3e07722a3ddb'