· 8 years ago · May 04, 2018, 04:52 PM
105-04-2018 07:31:28 PM] ~ [FAIL] No Connection
2[05-04-2018 07:31:28 PM] ~ [FAIL] No Connection
3[05-04-2018 07:32:58 PM] ~ [FAIL] No Connection
4[05-04-2018 07:32:58 PM] ~ [FAIL] No Connection
5[05-04-2018 07:33:23 PM] ~ [FAIL] No Connection
6[05-04-2018 07:33:26 PM] ~ [FAIL] No Connection
7[05-04-2018 07:33:26 PM] ~ [FAIL] No Connection
8[05-04-2018 07:36:57 PM] ~ [FAIL] No Connection
9[05-04-2018 07:37:12 PM] ~ [FAIL] No Connection
10[05-04-2018 07:37:16 PM] ~ [FAIL] No Connection
11[05-04-2018 07:37:16 PM] ~ [FAIL] -
12 - Query: SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
13[05-04-2018 07:37:16 PM] ~ [QUERY] - DROP TABLE IF EXISTS `kload_users`
14[05-04-2018 07:37:16 PM] ~ [QUERY] - DROP TABLE IF EXISTS `kload_settings`
15[05-04-2018 07:37:16 PM] ~ [QUERY] - DROP TABLE IF EXISTS `kload_sessions`
16[05-04-2018 07:37:17 PM] ~ [QUERY] - CREATE TABLE IF NOT EXISTS kload_users (
17 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
18 name VARCHAR(32) NULL COMMENT 'steam name',
19 steamid BIGINT(20) NOT NULL COMMENT 'steamid, e.g. 76561198142346653',
20 steamid2 VARCHAR(20) NOT NULL COMMENT 'steam2 id, e.g. STEAM_...',
21 steamid3 VARCHAR(20) NOT NULL COMMENT 'steam3 id, e.g. [U:1:...',
22 admin TINYINT(1) DEFAULT 0 COMMENT 'is the user an admin?',
23 perms TEXT NULL COMMENT 'list of perms, inactive when admin = 0',
24 settings TEXT NULL COMMENT 'user settings in JSON',
25 custom_css VARCHAR(500) NULL COMMENT 'user css for styling',
26 banned TINYINT(1) DEFAULT 0 COMMENT 'is the user banned?',
27 registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT 'date when joined'
28 ) DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci
29[05-04-2018 07:37:17 PM] ~ [QUERY] - CREATE UNIQUE INDEX kload_users_index ON kload_users(steamid, steamid2, steamid3)
30[05-04-2018 07:37:17 PM] ~ [QUERY] - CREATE TABLE IF NOT EXISTS kload_settings (
31 name VARCHAR(50) NOT NULL UNIQUE,
32 value TEXT NOT NULL
33 ) DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci
34[05-04-2018 07:37:18 PM] ~ [QUERY] - CREATE TABLE IF NOT EXISTS kload_sessions (
35 steamid BIGINT(20) NOT NULL UNIQUE COMMENT 'steamid, e.g. 76561198142346653',
36 token VARCHAR(64) NOT NULL UNIQUE COMMENT 'csrf token',
37 expires TIMESTAMP NULL COMMENT 'date at which token is invalid'
38 ) DEFAULT CHARSET=utf8mb4
39[05-04-2018 07:37:18 PM] ~ [QUERY] - CREATE TRIGGER csrf_fix_insert BEFORE INSERT ON `kload_sessions` FOR EACH ROW SET NEW.expires = TIMESTAMPADD(DAY,1,CURRENT_TIMESTAMP)
40[05-04-2018 07:37:18 PM] ~ [QUERY] - CREATE TRIGGER csrf_fix_update BEFORE UPDATE ON `kload_sessions` FOR EACH ROW SET NEW.expires = TIMESTAMPADD(DAY,1,CURRENT_TIMESTAMP)
41[05-04-2018 07:37:18 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','76561198142346653')
42[05-04-2018 07:37:18 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
43[05-04-2018 07:37:18 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.0.2' WHERE `name` = 'version'
44[05-04-2018 07:37:18 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
45[05-04-2018 07:37:18 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.0.3' WHERE `name` = 'version'
46[05-04-2018 07:37:18 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
47[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.0' WHERE `name` = 'version'
48[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
49[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.1' WHERE `name` = 'version'
50[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
51[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.2' WHERE `name` = 'version'
52[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
53[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.3' WHERE `name` = 'version'
54[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
55[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.4' WHERE `name` = 'version'
56[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
57[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.5' WHERE `name` = 'version'
58[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
59[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.6' WHERE `name` = 'version'
60[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
61[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.7' WHERE `name` = 'version'
62[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
63[05-04-2018 07:37:19 PM] ~ [QUERY] - UPDATE `kload_settings` SET `value` = '0.1.8' WHERE `name` = 'version'
64[05-04-2018 07:37:19 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
65[05-04-2018 07:37:20 PM] ~ [QUERY] - INSERT IGNORE INTO `kload_users` (`name`, `steamid`, `steamid2`, `steamid3`, `perms`, `settings`) VALUES('..::☣ĿǾáºÇ¿âˆªÄµÇ¿Ä¿Ã☣::','76561198142346653','STEAM_0:1:91040462','[U:1:182080925]','[]','{\"theme\":\"default\",\"backgrounds\":{\"enable\":1,\"random\":0,\"duration\":5000,\"fade\":750},\"youtube\":{\"enable\":0,\"random\":0,\"list\":[]}}')
66[05-04-2018 07:37:21 PM] ~ [QUERY] - UPDATE `kload_users` SET `name` = '..::☣ĿǾáºÇ¿âˆªÄµÇ¿Ä¿Ã☣::' WHERE `steamid` = '76561198142346653'
67[05-04-2018 07:37:21 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` = '76561198142346653'
68[05-04-2018 07:37:21 PM] ~ [QUERY] - INSERT INTO `kload_sessions` (`steamid`, `token`) VALUES('76561198142346653','6bc99f0e43733b07aed13148e635fdd2c36ac80ee6a9e1e8a97b321d69a603a7') ON DUPLICATE KEY UPDATE `token` = '6bc99f0e43733b07aed13148e635fdd2c36ac80ee6a9e1e8a97b321d69a603a7'
69[05-04-2018 07:37:25 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
70[05-04-2018 07:38:00 PM] ~ [QUERY] - SELECT `name`,`value` FROM `kload_settings` WHERE `name` = 'backgrounds' OR `name` = 'community_name' OR `name` = 'description' OR `name` = 'messages' OR `name` = 'rules' OR `name` = 'staff' OR `name` = 'youtube' ORDER BY `name` ASC
71[05-04-2018 07:39:51 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
72[05-04-2018 07:40:01 PM] ~ [QUERY] - INSERT IGNORE INTO `kload_users` (`name`, `steamid`, `steamid2`, `steamid3`, `perms`, `settings`) VALUES('..::☣ĿǾáºÇ¿âˆªÄµÇ¿Ä¿Ã☣::','76561198142346653','STEAM_0:1:91040462','[U:1:182080925]','[]','{\"theme\":\"default\",\"backgrounds\":{\"enable\":1,\"random\":0,\"duration\":5000,\"fade\":750},\"youtube\":{\"enable\":0,\"random\":0,\"list\":[]}}')
73[05-04-2018 07:40:01 PM] ~ [QUERY] - UPDATE `kload_users` SET `name` = '..::☣ĿǾáºÇ¿âˆªÄµÇ¿Ä¿Ã☣::' WHERE `steamid` = '76561198142346653'
74[05-04-2018 07:40:01 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` = '76561198142346653'
75[05-04-2018 07:40:01 PM] ~ [QUERY] - INSERT INTO `kload_sessions` (`steamid`, `token`) VALUES('76561198142346653','00ba5e9b865c0f126bbba4f7982eb5113ee5a080bf0106e01dadec46e60c2aa0') ON DUPLICATE KEY UPDATE `token` = '00ba5e9b865c0f126bbba4f7982eb5113ee5a080bf0106e01dadec46e60c2aa0'
76[05-04-2018 07:40:01 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
77[05-04-2018 07:40:01 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
78[05-04-2018 07:40:01 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
79[05-04-2018 07:40:10 PM] ~ [QUERY] - SELECT `id`, `name`, `steamid`, `steamid2`, `steamid3`, `settings`, `admin`, `banned`, DATE_FORMAT(`registered`, '%m/%d/%Y %r') AS `registered` FROM `kload_users` WHERE `steamid` = '76561198142346653'
80[05-04-2018 07:40:12 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
81[05-04-2018 07:40:12 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
82[05-04-2018 07:40:12 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
83[05-04-2018 07:40:32 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
84[05-04-2018 07:40:32 PM] ~ [QUERY] - SELECT (`steamid` = '76561198142346653' AND `token` = '00ba5e9b865c0f126bbba4f7982eb5113ee5a080bf0106e01dadec46e60c2aa0' AND CURRENT_TIMESTAMP < `expires`) AS `valid` FROM `kload_sessions`
85[05-04-2018 07:40:33 PM] ~ [QUERY] - INSERT INTO `kload_sessions` (`steamid`, `token`) VALUES('76561198142346653','af246234afe2eedbc6d52b378b08267e0ee9f7b174fe3ddd26cdd865cd70004c') ON DUPLICATE KEY UPDATE `token` = 'af246234afe2eedbc6d52b378b08267e0ee9f7b174fe3ddd26cdd865cd70004c'
86[05-04-2018 07:40:35 PM] ~ [QUERY] - UPDATE `kload_users` SET `settings` = '{\"theme\":\"magnus\",\"backgrounds\":{\"enable\":1,\"duration\":5000,\"fade\":750,\"random\":0},\"youtube\":{\"volume\":15,\"enable\":0,\"random\":0,\"list\":[]}}', `custom_css` = '' WHERE `steamid` = '76561198142346653'
87[05-04-2018 07:40:36 PM] ~ [QUERY] - UPDATE `kload_users` SET `name` = '..::☣ĿǾáºÇ¿âˆªÄµÇ¿Ä¿Ã☣::' WHERE `steamid` = '76561198142346653'
88[05-04-2018 07:40:36 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` = '76561198142346653'
89[05-04-2018 07:40:36 PM] ~ [QUERY] - INSERT INTO `kload_sessions` (`steamid`, `token`) VALUES('76561198142346653','ec1a20b5aee60fa32e957a1ca529219f83f7548c4e566cd24664f0d0e96d20fe') ON DUPLICATE KEY UPDATE `token` = 'ec1a20b5aee60fa32e957a1ca529219f83f7548c4e566cd24664f0d0e96d20fe'
90[05-04-2018 07:40:36 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
91[05-04-2018 07:40:36 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
92[05-04-2018 07:41:11 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
93[05-04-2018 07:41:11 PM] ~ [QUERY] - SELECT COUNT(*) FROM `kload_users`
94[05-04-2018 07:41:11 PM] ~ [QUERY] - SELECT `name`, `steamid`, `admin`, `perms`, `banned` FROM `kload_users` LIMIT 0, 16
95[05-04-2018 07:41:11 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
96[05-04-2018 07:41:11 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
97[05-04-2018 07:41:12 PM] ~ [QUERY] - SELECT `id`, `name`, `steamid`, `steamid2`, `steamid3`, `settings`, `admin`, `banned`, DATE_FORMAT(`registered`, '%m/%d/%Y %r') AS `registered` FROM `kload_users` WHERE `steamid` = '76561198142346653'
98[05-04-2018 07:41:18 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
99[05-04-2018 07:41:18 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
100[05-04-2018 07:41:18 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
101[05-04-2018 07:41:30 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
102[05-04-2018 07:41:30 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
103[05-04-2018 07:41:30 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
104[05-04-2018 07:41:34 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
105[05-04-2018 07:41:34 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
106[05-04-2018 07:41:34 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
107[05-04-2018 07:41:41 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
108[05-04-2018 07:41:41 PM] ~ [QUERY] - SELECT `name`,`value` FROM `kload_settings` WHERE `name` = 'backgrounds' OR `name` = 'community_name' OR `name` = 'description' OR `name` = 'youtube' ORDER BY `name` ASC
109[05-04-2018 07:41:41 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
110[05-04-2018 07:41:41 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'
111[05-04-2018 07:42:04 PM] ~ [QUERY] - SELECT `value` FROM `kload_settings` WHERE `name` = 'version'
112[05-04-2018 07:42:04 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
113[05-04-2018 07:42:04 PM] ~ [QUERY] - SELECT `name`,`value` FROM `kload_settings` WHERE `name` = 'messages' ORDER BY `name` ASC
114[05-04-2018 07:42:04 PM] ~ [QUERY] - SELECT `perms` FROM `kload_users` WHERE `steamid` = '76561198142346653'
115[05-04-2018 07:42:04 PM] ~ [QUERY] - SELECT `token` FROM `kload_sessions` WHERE `steamid` = '76561198142346653'