· 8 years ago · Mar 08, 2018, 11:58 PM
1L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlConnect] Connection was successful!
2L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.CreateTables] Polls Query: CREATE TABLE IF NOT EXISTS `mvotes_polls` ( `id` int(11) NOT NULL AUTO_INCREMENT, `status` tinyint(1) NOT NULL, `title` varchar(64) NOT NULL, `created` int(11) NOT NULL, `expire` int(11) NOT NULL, `admin` varchar(24) NOT NULL, `ip` varchar(18) NOT NULL, `port` int(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY (`title`, `created`) ) ENGINE=InnoDB CHARSET=utf8mb4;
3L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.CreateTables] Options Query: CREATE TABLE IF NOT EXISTS `mvotes_options` ( `id` int(11) NOT NULL AUTO_INCREMENT, `poll` int(11) NOT NULL, `option` varchar(32) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY (`poll`, `option`) ) ENGINE=InnoDB CHARSET=utf8mb4;
4L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.CreateTables] Votes Query: CREATE TABLE IF NOT EXISTS `mvotes_votes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `time` int(11) NOT NULL, `poll` int(11) NOT NULL, `option` int(11) NOT NULL, `communityid` varchar(24) NOT NULL, `name` varchar(128) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY (`poll`, `option`, `communityid`) ) ENGINE=InnoDB CHARSET=utf8mb4;
5L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlCreateTables] Table: 1, g_iCreateTables: 1
6L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlCreateTables] Table: 2, g_iCreateTables: 2
7L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlCreateTables] Table: 3, g_iCreateTables: 3
8L 03/09/2018 - 00:56:34: [mvotes.smx] [CreateTables.LoadPolls] Polls Query: SELECT id, status, title, created, expire FROM mvotes_polls WHERE status = 1;
9L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadPolls] HasResults: 1 RowCount: 2
10L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadPolls.Cache] iPoll: 34, bStatus: 1, iCreated: 1520553359, iExpire: 1520553659, sTitle: Test Vote
11L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadPolls.Cache] iPoll: 35, bStatus: 1, iCreated: 1520553379, iExpire: 1520553679, sTitle: Test Vote 2
12L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadOptions] HasResults: 1 RowCount: 2
13L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadOptions.Cache] iOptionID: 28, iPoll: 34, sOption: No
14L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadOptions.Cache] iOptionID: 27, iPoll: 34, sOption: Yes
15L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadOptions] HasResults: 1 RowCount: 2
16L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadOptions.Cache] iOptionID: 30, iPoll: 35, sOption: No
17L 03/09/2018 - 00:56:34: [mvotes.smx] [MVotes.sqlLoadOptions.Cache] iOptionID: 29, iPoll: 35, sOption: Yes
18L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.CreatePoll] Poll "Test Vote 3" (Length: 5) will be created...
19L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.CreatePoll] Poll "Test Vote 3", Admin: CONSOLE
20L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.CreatePoll] Insert Query: INSERT INTO `mvotes_polls` (`status`, `title`, `created`, `expire`, `admin`, `ip`, `port`) VALUES (1, "Test Vote 3", 1520553397, 1520553697, "CONSOLE", "78.31.67.4", 27025);
21L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlInsertPoll] PollID: 36 Title: Test Vote 3, Created: 1520553397, Expire: 1520553697, Options: 17432798, Options.Length: 2
22L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlInsertPoll.Cache] iPoll: 36, bStatus: 1, iCreated: 1520553397, iExpire: 1520553697, sTitle: Test Vote 3
23L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlInsertPoll] Poll: 36, Option: Yes
24L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlInsertPoll] Insert Query: INSERT INTO `mvotes_options` (`poll`, `option`) VALUES (36, "Yes");
25L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlInsertPoll] Poll: 36, Option: No
26L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlInsertPoll] Insert Query: INSERT INTO `mvotes_options` (`poll`, `option`) VALUES (36, "No");
27L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlLoadOptions] PollID: 36 Title: Test Vote 3, sOption: Yes, iOption: 31
28L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlLoadOptions.Cache] iOptionID: 31, iPoll: 36, sOption: Yes
29L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlLoadOptions] PollID: 36 Title: Test Vote 3, sOption: No, iOption: 32
30L 03/09/2018 - 00:56:37: [mvotes.smx] [MVotes.sqlLoadOptions.Cache] iOptionID: 32, iPoll: 36, sOption: No