· 10 years ago · Sep 06, 2016, 08:56 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Sep 06, 2016 at 10:53 PM
7-- Server version: 10.1.16-MariaDB
8-- PHP Version: 5.4.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `mcvergec_saucebang`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `nl1_addons`
27--
28
29CREATE TABLE IF NOT EXISTS `nl1_addons` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `enabled` tinyint(4) NOT NULL DEFAULT '0',
32 `name` varchar(64) NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
35
36--
37-- Dumping data for table `nl1_addons`
38--
39
40INSERT INTO `nl1_addons` (`id`, `enabled`, `name`) VALUES
41(1, 0, 'Donate'),
42(2, 1, 'Members'),
43(3, 0, 'Vote'),
44(4, 1, 'Infractions'),
45(5, 1, 'BanAppeal');
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `nl1_alerts`
51--
52
53CREATE TABLE IF NOT EXISTS `nl1_alerts` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `user_id` int(11) NOT NULL,
56 `type` varchar(64) NOT NULL,
57 `url` varchar(255) NOT NULL,
58 `content` varchar(255) NOT NULL,
59 `read` tinyint(1) NOT NULL DEFAULT '0',
60 `created` int(11) NOT NULL,
61 PRIMARY KEY (`id`)
62) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
63
64--
65-- Dumping data for table `nl1_alerts`
66--
67
68INSERT INTO `nl1_alerts` (`id`, `user_id`, `type`, `url`, `content`, `read`, `created`) VALUES
69(1, 4, 'User Tag', '/forum/view_topic/?tid=7&pid=9', 'You have been tagged in a post. Click <a href="/forum/view_topic/?tid=7&pid=9">here</a> to view.', 0, 1456959453),
70(2, 1, 'Report', '/mod/reports/?rid=1', 'New report submitted by admin regarding user saucebang', 1, 1461532111),
71(3, 4, 'Report', '/mod/reports/?rid=1', 'New report submitted by admin regarding user saucebang', 0, 1461532111),
72(4, 7, 'Report', '/mod/reports/?rid=1', 'New report submitted by admin regarding user saucebang', 0, 1461532111),
73(5, 6, 'Report', '/mod/reports/?rid=1', 'New report submitted by admin regarding user saucebang', 0, 1461532111),
74(6, 5, 'Report', '/mod/reports/?rid=1', 'New report submitted by admin regarding user saucebang', 1, 1461532111),
75(7, 1, 'Report', '/mod/reports/?rid=2', 'New report submitted by admin regarding user saucebang', 1, 1461533278),
76(8, 4, 'Report', '/mod/reports/?rid=2', 'New report submitted by admin regarding user saucebang', 0, 1461533278),
77(9, 7, 'Report', '/mod/reports/?rid=2', 'New report submitted by admin regarding user saucebang', 0, 1461533278),
78(10, 6, 'Report', '/mod/reports/?rid=2', 'New report submitted by admin regarding user saucebang', 0, 1461533278),
79(11, 5, 'Report', '/mod/reports/?rid=2', 'New report submitted by admin regarding user saucebang', 1, 1461533278),
80(12, 1, 'Ban Appeal', '/mod/banappeal/?app=1', 'New Ban Appeal submitted by saquan', 1, 1470149167),
81(13, 4, 'Ban Appeal', '/mod/banappeal/?app=1', 'New Ban Appeal submitted by saquan', 0, 1470149167),
82(14, 7, 'Ban Appeal', '/mod/banappeal/?app=1', 'New Ban Appeal submitted by saquan', 0, 1470149167),
83(15, 20, 'Ban Appeal', '/mod/banappeal/?app=1', 'New Ban Appeal submitted by saquan', 1, 1470149167),
84(16, 17, 'Ban Appeal', '/mod/banappeal/?app=1', 'New Ban Appeal submitted by saquan', 1, 1470149167),
85(17, 5, 'Ban Appeal', '/mod/banappeal/?app=1', 'New Ban Appeal submitted by saquan', 0, 1470149167),
86(18, 9, 'tag', '/forum/view_topic/?tid=21&pid=31', 'You have been tagged in a post. Click <a href="/forum/view_topic/?tid=21&pid=31">here</a> to view.', 0, 1471999723);
87
88-- --------------------------------------------------------
89
90--
91-- Table structure for table `nl1_banappeal_comments`
92--
93
94CREATE TABLE IF NOT EXISTS `nl1_banappeal_comments` (
95 `id` int(11) NOT NULL AUTO_INCREMENT,
96 `aid` int(11) NOT NULL,
97 `uid` int(11) NOT NULL,
98 `time` int(11) NOT NULL,
99 `content` mediumtext NOT NULL,
100 PRIMARY KEY (`id`)
101) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
102
103--
104-- Dumping data for table `nl1_banappeal_comments`
105--
106
107INSERT INTO `nl1_banappeal_comments` (`id`, `aid`, `uid`, `time`, `content`) VALUES
108(1, 1, 17, 1471281810, 'Declined');
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `nl1_banappeal_questions`
114--
115
116CREATE TABLE IF NOT EXISTS `nl1_banappeal_questions` (
117 `id` int(11) NOT NULL AUTO_INCREMENT,
118 `type` int(11) NOT NULL,
119 `name` varchar(16) NOT NULL,
120 `question` varchar(256) NOT NULL,
121 `options` text NOT NULL,
122 PRIMARY KEY (`id`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
124
125--
126-- Dumping data for table `nl1_banappeal_questions`
127--
128
129INSERT INTO `nl1_banappeal_questions` (`id`, `type`, `name`, `question`, `options`) VALUES
130(1, 3, 'IGN', 'What is your in-game name?', ''),
131(2, 3, 'Who banned you?', 'Which staff member banned you?', ''),
132(3, 3, 'Why?', 'What did you get banned for?', ''),
133(4, 3, 'Ok', 'When did you get banned?', ''),
134(5, 3, 'Alright', 'Were you falsely accused? If so, please state why.', ''),
135(6, 3, 'How', 'How can you reassure us that you will not do what you''ve done again?', '');
136
137-- --------------------------------------------------------
138
139--
140-- Table structure for table `nl1_banappeal_replies`
141--
142
143CREATE TABLE IF NOT EXISTS `nl1_banappeal_replies` (
144 `id` int(11) NOT NULL AUTO_INCREMENT,
145 `uid` int(11) NOT NULL,
146 `time` int(11) NOT NULL,
147 `content` mediumtext NOT NULL,
148 `status` int(11) NOT NULL DEFAULT '0',
149 PRIMARY KEY (`id`)
150) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
151
152--
153-- Dumping data for table `nl1_banappeal_replies`
154--
155
156INSERT INTO `nl1_banappeal_replies` (`id`, `uid`, `time`, `content`, `status`) VALUES
157(1, 1, 1470149167, '[[1,"saquan"],[2,"me"],[3,"cuas im awesome"],[4,"test"],[5,"test"],[6,"test"]]', 0);
158
159-- --------------------------------------------------------
160
161--
162-- Table structure for table `nl1_core_modules`
163--
164
165CREATE TABLE IF NOT EXISTS `nl1_core_modules` (
166 `id` int(11) NOT NULL AUTO_INCREMENT,
167 `name` varchar(64) NOT NULL,
168 `enabled` tinyint(4) NOT NULL DEFAULT '0',
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
171
172--
173-- Dumping data for table `nl1_core_modules`
174--
175
176INSERT INTO `nl1_core_modules` (`id`, `name`, `enabled`) VALUES
177(1, 'Google_Analytics', 0),
178(2, 'Social_Media', 1),
179(3, 'Registration', 1),
180(4, 'Voice_Server_Module', 0),
181(5, 'Staff_Applications', 0);
182
183-- --------------------------------------------------------
184
185--
186-- Table structure for table `nl1_custom_pages`
187--
188
189CREATE TABLE IF NOT EXISTS `nl1_custom_pages` (
190 `id` int(11) NOT NULL AUTO_INCREMENT,
191 `url` varchar(20) NOT NULL,
192 `title` varchar(30) NOT NULL,
193 `content` mediumtext NOT NULL,
194 `link_location` tinyint(1) NOT NULL DEFAULT '1',
195 PRIMARY KEY (`id`)
196) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
197
198--
199-- Dumping data for table `nl1_custom_pages`
200--
201
202INSERT INTO `nl1_custom_pages` (`id`, `url`, `title`, `content`, `link_location`) VALUES
203(2, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 3),
204(3, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 1),
205(4, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 1),
206(5, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 1),
207(6, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 1),
208(7, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 1),
209(8, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 1),
210(9, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 3),
211(10, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 3),
212(11, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 3),
213(12, '/help/', 'Help', 'Default help page. Customise in the admin panel.', 3);
214
215-- --------------------------------------------------------
216
217--
218-- Table structure for table `nl1_forums`
219--
220
221CREATE TABLE IF NOT EXISTS `nl1_forums` (
222 `id` int(11) NOT NULL AUTO_INCREMENT,
223 `forum_title` varchar(150) NOT NULL,
224 `forum_description` varchar(255) NOT NULL,
225 `last_post_date` datetime DEFAULT NULL,
226 `last_user_posted` int(11) DEFAULT NULL,
227 `last_topic_posted` int(11) DEFAULT NULL,
228 `parent` int(11) NOT NULL DEFAULT '0',
229 `forum_order` int(11) NOT NULL,
230 `news` tinyint(1) NOT NULL DEFAULT '0',
231 PRIMARY KEY (`id`)
232) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
233
234--
235-- Dumping data for table `nl1_forums`
236--
237
238INSERT INTO `nl1_forums` (`id`, `forum_title`, `forum_description`, `last_post_date`, `last_user_posted`, `last_topic_posted`, `parent`, `forum_order`, `news`) VALUES
239(1, 'MCVerge', 'Announcements', NULL, NULL, NULL, 0, 1, 0),
240(2, 'Announcements', 'Official News provided by the MCVerge staff.', '2016-08-24 01:48:43', 1, 21, 1, 2, 0),
241(3, 'Server Feedback', 'Feedback on the server', '2016-08-09 03:51:03', 1, 20, 1, 3, 0),
242(4, 'Community', 'COMMUNITY', NULL, NULL, NULL, 0, 4, 0),
243(5, 'Introductions', 'Introductions', NULL, NULL, NULL, 4, 5, 0),
244(6, 'Other Games', 'Other Games', NULL, NULL, NULL, 4, 6, 0),
245(7, 'General Discussion', 'afefadfeafe', NULL, NULL, NULL, 4, 7, 0),
246(8, 'Gamemodes', 'Test thingale', '2016-05-07 22:22:06', 1, 13, 4, 8, 0),
247(11, 'Maps', 'Maps r cool', NULL, NULL, NULL, 0, 11, 0),
248(12, 'Map Development', 'Maps r still cool', '2016-03-02 22:57:33', 1, 7, 11, 12, 0),
249(13, 'Map Submissions', 'Maps r cool', '2016-01-11 00:37:14', 1, 1, 11, 13, 0),
250(14, 'Events', 'Events ', NULL, NULL, NULL, 0, 14, 0),
251(15, 'Information', 'faefaef', '2016-05-07 19:47:33', 1, 12, 14, 15, 0),
252(16, 'PVP Strategies', 'eafefa', NULL, NULL, NULL, 14, 16, 0),
253(17, 'Code of Conduct', 'Dayum', NULL, NULL, NULL, 0, 17, 0),
254(18, 'Player Reports', 'Report those fuckers', '2016-05-08 16:38:01', 1, 14, 17, 18, 0),
255(19, 'Player Appeals', 'Dayum dawg', NULL, NULL, NULL, 17, 19, 0),
256(20, 'Development', 'Development nerdz', '2016-07-24 21:59:47', 1, 18, 1, 20, 0),
257(21, 'Fractious Staff', 'unruly dudes', '2016-04-03 03:57:38', 1, 10, 17, 21, 0);
258
259-- --------------------------------------------------------
260
261--
262-- Table structure for table `nl1_forums_permissions`
263--
264
265CREATE TABLE IF NOT EXISTS `nl1_forums_permissions` (
266 `id` int(11) NOT NULL AUTO_INCREMENT,
267 `group_id` int(11) NOT NULL,
268 `forum_id` int(11) NOT NULL,
269 `view` tinyint(1) NOT NULL DEFAULT '1',
270 `create_topic` tinyint(1) NOT NULL DEFAULT '1',
271 `create_post` tinyint(1) NOT NULL DEFAULT '1',
272 PRIMARY KEY (`id`)
273) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=106 ;
274
275--
276-- Dumping data for table `nl1_forums_permissions`
277--
278
279INSERT INTO `nl1_forums_permissions` (`id`, `group_id`, `forum_id`, `view`, `create_topic`, `create_post`) VALUES
280(1, 0, 1, 1, 0, 0),
281(2, 1, 1, 1, 0, 0),
282(3, 2, 1, 1, 0, 0),
283(4, 3, 1, 1, 0, 0),
284(5, 0, 2, 1, 0, 0),
285(6, 1, 2, 1, 0, 1),
286(7, 2, 2, 1, 1, 1),
287(8, 3, 2, 1, 0, 1),
288(9, 0, 3, 1, 0, 0),
289(10, 1, 3, 1, 1, 1),
290(11, 2, 3, 1, 1, 1),
291(12, 3, 3, 1, 1, 1),
292(13, 0, 4, 1, 0, 0),
293(14, 1, 4, 1, 0, 0),
294(15, 2, 4, 1, 0, 0),
295(16, 3, 4, 1, 0, 0),
296(17, 0, 5, 1, 0, 0),
297(18, 1, 5, 1, 1, 1),
298(19, 2, 5, 1, 1, 1),
299(20, 3, 5, 1, 1, 1),
300(21, 0, 6, 1, 0, 0),
301(22, 1, 6, 1, 1, 1),
302(23, 2, 6, 1, 1, 1),
303(24, 3, 6, 1, 1, 1),
304(25, 0, 7, 1, 0, 0),
305(26, 1, 7, 1, 1, 1),
306(27, 2, 7, 1, 1, 1),
307(28, 3, 7, 1, 1, 1),
308(29, 0, 8, 1, 0, 0),
309(30, 1, 8, 1, 1, 1),
310(31, 2, 8, 1, 1, 1),
311(32, 3, 8, 1, 1, 1),
312(41, 0, 11, 1, 0, 0),
313(42, 1, 11, 1, 0, 0),
314(43, 2, 11, 1, 0, 0),
315(44, 3, 11, 1, 0, 0),
316(45, 0, 12, 1, 0, 0),
317(46, 1, 12, 1, 1, 1),
318(47, 2, 12, 1, 1, 1),
319(48, 3, 12, 1, 1, 1),
320(49, 0, 13, 1, 0, 0),
321(50, 1, 13, 1, 1, 1),
322(51, 2, 13, 1, 1, 1),
323(52, 3, 13, 1, 1, 1),
324(53, 0, 14, 1, 0, 0),
325(54, 1, 14, 1, 0, 0),
326(55, 2, 14, 1, 0, 0),
327(56, 3, 14, 1, 0, 0),
328(57, 0, 15, 1, 0, 0),
329(58, 1, 15, 1, 1, 1),
330(59, 2, 15, 1, 1, 1),
331(60, 3, 15, 1, 1, 1),
332(61, 0, 16, 1, 0, 0),
333(62, 1, 16, 1, 1, 1),
334(63, 2, 16, 1, 1, 1),
335(64, 3, 16, 1, 1, 1),
336(65, 0, 17, 1, 0, 0),
337(66, 1, 17, 1, 0, 0),
338(67, 2, 17, 1, 0, 0),
339(68, 3, 17, 1, 0, 0),
340(69, 0, 18, 1, 0, 0),
341(70, 1, 18, 1, 1, 1),
342(71, 2, 18, 1, 1, 1),
343(72, 3, 18, 1, 1, 1),
344(73, 0, 19, 1, 0, 0),
345(74, 1, 19, 1, 1, 1),
346(75, 2, 19, 1, 1, 1),
347(76, 3, 19, 1, 1, 1),
348(77, 0, 20, 1, 0, 0),
349(78, 1, 20, 1, 0, 1),
350(79, 2, 20, 1, 1, 1),
351(80, 3, 20, 1, 0, 1),
352(81, 4, 1, 1, 0, 0),
353(82, 4, 2, 1, 1, 1),
354(83, 4, 3, 1, 1, 1),
355(84, 4, 5, 1, 1, 1),
356(85, 4, 6, 1, 1, 1),
357(86, 4, 7, 1, 1, 1),
358(87, 4, 8, 1, 1, 1),
359(90, 4, 11, 1, 0, 0),
360(91, 4, 12, 1, 1, 1),
361(92, 4, 15, 1, 1, 1),
362(93, 4, 13, 1, 1, 1),
363(94, 4, 14, 1, 0, 0),
364(95, 4, 20, 1, 0, 1),
365(96, 4, 19, 1, 1, 1),
366(97, 4, 18, 1, 1, 1),
367(98, 4, 17, 1, 0, 0),
368(99, 4, 16, 1, 1, 1),
369(100, 0, 21, 1, 0, 0),
370(101, 1, 21, 1, 1, 1),
371(102, 2, 21, 1, 1, 1),
372(103, 3, 21, 1, 1, 1),
373(104, 4, 21, 1, 1, 1),
374(105, 4, 4, 0, 0, 0);
375
376-- --------------------------------------------------------
377
378--
379-- Table structure for table `nl1_forums_topic_labels`
380--
381
382CREATE TABLE IF NOT EXISTS `nl1_forums_topic_labels` (
383 `id` int(11) NOT NULL AUTO_INCREMENT,
384 `fids` varchar(32) NOT NULL,
385 `name` varchar(32) NOT NULL,
386 `label` varchar(20) NOT NULL,
387 PRIMARY KEY (`id`)
388) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
389
390--
391-- Dumping data for table `nl1_forums_topic_labels`
392--
393
394INSERT INTO `nl1_forums_topic_labels` (`id`, `fids`, `name`, `label`) VALUES
395(1, '13', 'Accepted', 'success'),
396(2, '13', 'Rejected', 'danger'),
397(3, '13', 'Pending', 'warning'),
398(4, '', 'Info', 'info'),
399(5, '12', 'DTM', 'default'),
400(6, '12', 'TDM', 'default'),
401(7, '12', 'Arcade', 'default'),
402(8, '18', 'README', 'warning');
403
404-- --------------------------------------------------------
405
406--
407-- Table structure for table `nl1_friends`
408--
409
410CREATE TABLE IF NOT EXISTS `nl1_friends` (
411 `id` int(11) NOT NULL AUTO_INCREMENT,
412 `user_id` int(11) NOT NULL,
413 `friend_id` int(11) NOT NULL,
414 PRIMARY KEY (`id`)
415) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
416
417--
418-- Dumping data for table `nl1_friends`
419--
420
421INSERT INTO `nl1_friends` (`id`, `user_id`, `friend_id`) VALUES
422(1, 1, 7),
423(2, 7, 1),
424(3, 1, 5),
425(4, 5, 1),
426(5, 1, 4),
427(6, 4, 1),
428(8, 1, 9),
429(9, 27, 1);
430
431-- --------------------------------------------------------
432
433--
434-- Table structure for table `nl1_groups`
435--
436
437CREATE TABLE IF NOT EXISTS `nl1_groups` (
438 `id` int(11) NOT NULL AUTO_INCREMENT,
439 `name` varchar(20) NOT NULL,
440 `buycraft_id` varchar(64) DEFAULT NULL,
441 `group_html` varchar(1024) NOT NULL,
442 `group_html_lg` varchar(1024) NOT NULL,
443 `mod_cp` tinyint(1) NOT NULL DEFAULT '0',
444 `admin_cp` tinyint(1) NOT NULL DEFAULT '0',
445 `staff` tinyint(1) NOT NULL DEFAULT '0',
446 `staff_apps` tinyint(1) NOT NULL DEFAULT '0',
447 `accept_staff_apps` tinyint(1) NOT NULL DEFAULT '0',
448 `banappeal` tinyint(1) NOT NULL DEFAULT '0',
449 `accept_banappeal` tinyint(1) NOT NULL DEFAULT '0',
450 PRIMARY KEY (`id`)
451) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
452
453--
454-- Dumping data for table `nl1_groups`
455--
456
457INSERT INTO `nl1_groups` (`id`, `name`, `buycraft_id`, `group_html`, `group_html_lg`, `mod_cp`, `admin_cp`, `staff`, `staff_apps`, `accept_staff_apps`, `banappeal`, `accept_banappeal`) VALUES
458(1, 'Member', '', '<span class="label label-success"></span>', '<span style="margin-left:2.1cm;" class="label label-success">User</span>', 0, 0, 0, 0, 0, 0, 0),
459(2, 'Operator', '', '<a href="/staff"><span class="label label-warning"><i class="fa fa-shield" aria-hidden="true"></i> Operator</span></a>', '<span style="margin-left:2.1cm;" class="label label-warning">Operator</span>', 1, 1, 1, 0, 0, 1, 1),
460(3, 'Moderator', '', '<span class="label label-primary"><i class="fa fa-shield" aria-hidden="true"></i> Moderator</span>', '<span style="margin-left:2.1cm;" class="label label-primary">Moderator</span>', 1, 0, 1, 0, 0, 1, 1),
461(4, 'Coordinator', '', '<span class="label label-info"><i class="fa fa-map-o" aria-hidden="true"></i> Coordinator</span>', '<span style="margin-left:2.1cm;" class="label label-info">Coordinator</span>', 1, 0, 1, 0, 0, 1, 1),
462(5, 'OP/DEV', '', '<a href="/staff"><span class="label label-warning"><i class="fa fa-shield" aria-hidden="true"></i> Operator</span></a> <a href="/staff"><span class="label label-primary"><i class="fa fa-shield" aria-hidden="true"></i> Developer</span></a>', '<span style="margin-left:2.1cm;" class="label label-warning">Operator</span>', 1, 1, 1, 0, 0, 0, 0);
463
464-- --------------------------------------------------------
465
466--
467-- Table structure for table `nl1_infractions`
468--
469
470CREATE TABLE IF NOT EXISTS `nl1_infractions` (
471 `id` int(11) NOT NULL AUTO_INCREMENT,
472 `type` int(11) NOT NULL,
473 `punished` int(11) NOT NULL,
474 `staff` int(11) NOT NULL,
475 `reason` text NOT NULL,
476 `infraction_date` datetime NOT NULL,
477 `acknowledged` tinyint(1) NOT NULL,
478 PRIMARY KEY (`id`)
479) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
480
481-- --------------------------------------------------------
482
483--
484-- Table structure for table `nl1_infractions_settings`
485--
486
487CREATE TABLE IF NOT EXISTS `nl1_infractions_settings` (
488 `id` int(11) NOT NULL AUTO_INCREMENT,
489 `name` varchar(32) NOT NULL,
490 `value` varchar(128) NOT NULL,
491 PRIMARY KEY (`id`)
492) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
493
494--
495-- Dumping data for table `nl1_infractions_settings`
496--
497
498INSERT INTO `nl1_infractions_settings` (`id`, `name`, `value`) VALUES
499(1, 'plugin_type', 'bat');
500
501-- --------------------------------------------------------
502
503--
504-- Table structure for table `nl1_language`
505--
506
507CREATE TABLE IF NOT EXISTS `nl1_language` (
508 `id` int(11) NOT NULL AUTO_INCREMENT,
509 `name` varchar(16) NOT NULL,
510 `enabled` tinyint(4) NOT NULL DEFAULT '0',
511 PRIMARY KEY (`id`)
512) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
513
514-- --------------------------------------------------------
515
516--
517-- Table structure for table `nl1_mc_servers`
518--
519
520CREATE TABLE IF NOT EXISTS `nl1_mc_servers` (
521 `id` int(11) NOT NULL AUTO_INCREMENT,
522 `ip` varchar(64) NOT NULL,
523 `query_ip` varchar(64) NOT NULL,
524 `name` varchar(20) NOT NULL,
525 `is_default` tinyint(1) NOT NULL DEFAULT '0',
526 `display` tinyint(1) NOT NULL DEFAULT '1',
527 `pre` tinyint(1) NOT NULL DEFAULT '0',
528 `player_list` tinyint(1) NOT NULL DEFAULT '1',
529 PRIMARY KEY (`id`)
530) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
531
532--
533-- Dumping data for table `nl1_mc_servers`
534--
535
536INSERT INTO `nl1_mc_servers` (`id`, `ip`, `query_ip`, `name`, `is_default`, `display`, `pre`, `player_list`) VALUES
537(1, '158.69.242.233:25568', '158.69.242.233:25568', 'Main', 0, 0, 0, 1),
538(2, '167.114.210.171:25710', '167.114.210.171:25710', 'Main Lobby', 1, 1, 0, 1),
539(4, '108.61.21.227:25567', '108.61.21.227:25567', 'Janus', 0, 1, 0, 1);
540
541-- --------------------------------------------------------
542
543--
544-- Table structure for table `nl1_posts`
545--
546
547CREATE TABLE IF NOT EXISTS `nl1_posts` (
548 `id` int(11) NOT NULL AUTO_INCREMENT,
549 `forum_id` int(11) NOT NULL,
550 `topic_id` int(11) NOT NULL,
551 `post_creator` int(11) NOT NULL,
552 `post_content` mediumtext NOT NULL,
553 `post_date` datetime NOT NULL,
554 PRIMARY KEY (`id`)
555) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
556
557--
558-- Dumping data for table `nl1_posts`
559--
560
561INSERT INTO `nl1_posts` (`id`, `forum_id`, `topic_id`, `post_creator`, `post_content`, `post_date`) VALUES
562(1, 13, 1, 1, '<p>Hello,</p>\r\n\r\n<p>While we greatly appreciate your contribution to MCVerge, we will not always accept every map submitted to us. This depends on what needs to be added/removed etc. There&#39;s always room for improvement, and if your map is rejected, reasons will be stated prior to the thread lock.</p>\r\n\r\n<p><strong>We will not tolerate plagiarized maps, all maps must be created by you.</strong></p>\r\n\r\n<p>Please follow the given format when submitting a map:</p>\r\n\r\n<ul>\r\n <li>Map name:</li>\r\n <li>Map photos (upload to imgur please):</li>\r\n <li>Map download</li>\r\n</ul>\r\n\r\n<p>Thanks!</p>\r\n\r\n<p>Adobes</p>\r\n', '2016-01-11 00:37:14'),
563(2, 2, 2, 1, '<p style="text-align:center"><img alt="The Verge" src="https://pbs.twimg.com/profile_images/631612873362440192/yl0WHIqZ_400x400.png" /></p>\r\n\r\n<p>On December of 2014, I made a difficult&nbsp;decision to begin development and create Minecraft Verge. Obviously this task was soon proven to be tedious. In April of 2015, I released the first version of our (now) most primative game, Nimbus. I tested it with a few friends later that month, and it worked almost flawlessly. Whilst I had the opportunity to release the server at its current stage, I decided to refuse and work on the minigame more until I was&nbsp;positive it would be stable, and gameplay would be smooth.</p>\r\n\r\n<p>We are entering our final months in terms of&nbsp;pushing changes to&nbsp;what we find primative to the growth and stability of our network. This isn&#39;t the end of the road for development, rather a checkpoint to where we are able to resume in the near future. We&#39;ll be doing bug-testing throughout the week, ensuring our network is bug-free. If you stumble across something that doesn&#39;t seem right, please make a thread on our forum, and we&#39;ll take whatever steps are&nbsp;necessary.</p>\r\n\r\n<p>Thanks, and stay tuned for future updates!</p>\r\n', '2016-01-12 01:29:31'),
564(5, 20, 4, 1, '<p>Recently we&#39;ve encountered players griefing each other, or the opposing team was griefing another. This is not the point of any of our servers. As soon as this was pointed out, we released a patch that stops players from griefing each other&#39;s spawn/base. Spawn killing is yet to be fixed. As previously stated, the rule of &quot;no spawn killing&quot; has been implemented and enforced.</p>\r\n', '2016-01-22 02:09:07'),
565(6, 20, 4, 1, '<p>We&#39;ve just wrapped up our weekend updates. Below is an overview:</p>\r\n\r\n<p><strong>Nimbus</strong></p>\r\n\r\n<ul>\r\n <li>Tab list is more organized.</li>\r\n <li>Block lag&nbsp;<em>should</em>&nbsp;be clear.</li>\r\n <li>Entities despawn after 60 seconds. (We&#39;ve gotten multiple reports of it causing lag client side).</li>\r\n <li>All Nimbus servers are located in New Jersey.</li>\r\n</ul>\r\n\r\n<p><strong>Website</strong></p>\r\n\r\n<ul>\r\n <li>Play page has been redesigned a bit.</li>\r\n <li>User profiles are beginning to seem more intact (see user&#39;s content)&nbsp;</li>\r\n</ul>\r\n\r\n<p>&nbsp; &nbsp; &nbsp;&nbsp;<strong>WIP</strong></p>\r\n\r\n<ul>\r\n <li><s>Interrogating player statistics to user profiles&nbsp;</s><span style="color:#008000"><strong>Completed</strong></span></li>\r\n <li>Interrogating user&#39;s infractions&nbsp;<span style="color:#FF0000"><strong>Haven&#39;t touched</strong></span></li>\r\n <li>Leaderboard&nbsp;<span style="color:#DAA520"><strong>Almost Complete</strong></span></li>\r\n <li>Teams&nbsp;<span style="color:#FF0000"><strong>Haven&#39;t touched</strong></span></li>\r\n</ul>\r\n\r\n<p><s>*We&#39;re finalizing a new addition to MCVerge. I&#39;ve been hard at work adding &quot;Duels&quot; you will soon be able to fight one another whether it&#39;s a 1v1, 2v2, or split your party into 2 teams and brawl away! This update will be just around the corner :).</s></p>\r\n\r\n<p><strong><em>Completed on 3/6/2016</em></strong></p>\r\n\r\n<p>&nbsp;</p>\r\n', '2016-01-31 21:41:19'),
566(7, 3, 5, 1, '<p>As a way for us to increase community engagement, we opened this section to allow our players to voice their opinions. We're all about constructive criticism, and deeply rely on it to improve our network. We also enjoy hearing great comments by our community. MCVerge is central to it, and we'd like to keep it that way.</p>\r\n\r\n<p>However, there are some things we highly discourage under this forum.:</p>\r\n\r\n<ul>\r\n <li>Aim to openly start an argument against a staff member <em>(Contact an operator privately if you see them doing anything wrong)</em></li>\r\n <li>Complain about your fellow opponents.</li>\r\n <li>Creating offtopic discussion</li>\r\n <li>Going on a rant due to an infraction awarded to you.</li>\r\n</ul>\r\n\r\n<p>Failure to correspond may cause your forum account to be compromised.</p>\r\n\r\n<p> </p>\r\n\r\n<p> </p>\r\n', '2016-02-07 17:20:27'),
567(10, 20, 8, 1, '<p>Hello,</p>\r\n\r\n<p>This is just a brief announcement: I&#39;ve recently implemented a network-wide change that has just been taken affect a couple hours ago. Below is a changelog:</p>\r\n\r\n<ul>\r\n <li>Network-Wide statistics are now visible on your scoreboard when you enter the server lobby. (Credits/Total Kills)</li>\r\n <li>Your personal statistics can now be viewed on your profile.</li>\r\n <li>Your profile displays who has recently killed you as well (not on what gamemode yet). It also keeps track of your KDR, how long you&#39;ve been playing (in days), total kills/deaths, and more!</li>\r\n</ul>\r\n\r\n<p><strong>Edit</strong>: I forgot to mention, statistics are updated in a cycle (not instantly). It&#39;ll display the updated number of kills/deaths within seconds of it happening, it just takes a few hours to render the skin/name of the person that you killed, or you were killed by. Considering global stats has already been implemented, I will also be adding per-game statistics as well, which looks clean for this weekend (3/19).</p>\r\n', '2016-03-09 02:20:01'),
568(12, 21, 10, 1, '<p>We do our best to have some of the best-behaved and well-deserving players on our staff team. Unfortunately this will not be true all the time. I expect that there will be times were staff may "abuse" their privileges. To prevent them from causing any sort of downfall on our network, I decided to open this section to allow players to express there feelings on a particular staff member(s). Now, this section may be heavily moderated. Below is a list of things that you may <strong>not</strong> use this section for:</p>\r\n\r\n<ul>\r\n <li>Blatantly complaining about a staff member without sufficient details on what they did wrong.</li>\r\n <li>Stating how you did not deserve a "well-deserved" infraction.</li>\r\n <li>Personally attacking a staff member.</li>\r\n</ul>\r\n\r\n<p>Please also consider messaging an Operator (me) if you have personal issues with a staff member(s).</p>\r\n\r\n<p>*<strong>Note: This forum is in trial and may/may not be deleted. Depending on the number of issues this section may be permanently archived. Our intent is to ensure that our community isn't suffering from ill-spirited staff members.</strong></p>\r\n', '2016-04-03 03:57:38'),
569(16, 20, 11, 1, '<p>If you didn&#39;t know already, we are currently using the bootstrap framework. I pushed an update just last night which improves our mobile flexibility. Only some things were mobile friendly before the update. Everything is mobile friendly now.</p>\r\n\r\n<p>I have also made some adjustments to our backend system hosting our webserver. These optimizations&nbsp;have proven to be effective as the website is much faster than it has been.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2016-04-18 16:13:27'),
570(18, 8, 13, 1, '<p>Before you make a thread here concerning any of our gamemodes, please be sure you've already checked out our (new) support page, featuring several articles on how things work. To check out our support guide for Gamemodes, please go <a href="http://mcverge.com/support/gamemodes">here</a> or by clicking on the <strong>Help</strong> button on the navbar and selecting the "Gamemodes" icon in the portal.</p>\r\n\r\n<p><em>If </em>and <strong>only if</strong> you cannot find the solution to your problem there, should you create a thread here.</p>\r\n\r\n<p>We are promoting our efforts to provide more useful resources in terms of our network as a whole.</p>\r\n', '2016-05-07 22:22:06'),
571(20, 2, 15, 1, '<p>1.9 has been out for several months now, and 1.10 was released about a week or so ago. I decided that we will no longer hang on hosting our servers on 1.8.</p>\r\n\r\n<p>The update will be simple, yet a bit of a tedious task. We will still allow 1.8-1.9 clients to connect as we will be disabling the combat portion of the update as a whole. Essentially it will be 1.8 pvp on 1.9, as I dislike the combat update myself.</p>\r\n\r\n<p>We will be working on this update throughout this week, so the server will be updated very soon.</p>\r\n\r\n<p>Thanks,</p>\r\n\r\n<p>saucebang</p>\r\n', '2016-06-19 15:17:03'),
572(21, 2, 16, 1, '<p>Hello,</p>\r\n\r\n<p>This is just a short/quick announcment, I've reinstating 1.8 support, 1.7 has been causing clients to crash, and I am in the process of fixing it. 1.7 support isn't much of a priority as we now support 1.8 whcih contain some of 1.7's combat mechanics. However, we do support blockhitting in 1.9/1.10, it's just a bit different.</p>\r\n\r\n<p>Thanks</p>\r\n', '2016-07-19 15:52:21'),
573(22, 2, 17, 1, '<p>Hello,</p>\r\n\r\n<p>I just wanted a quick announcement, we will begin beta testing tomorrow (7/23) at 12pm EST. The network will be up afterwards&nbsp;<img alt="smiley" src="http://mcverge.com/core/assets/js/plugins/smiley/images/regular_smile.png" />.</p>\r\n\r\n<p>Thanks to the members of the Overcast community that have been supportive of this project!</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Edit:&nbsp;</strong>Forum registration will be unlocked by then.</p>\r\n', '2016-07-23 01:18:14'),
574(23, 2, 17, 16, '<p>I am on the server right now, when is the beta test?</p>\r\n', '2016-07-24 00:21:36'),
575(24, 2, 17, 1, '<blockquote><small><a href="/forum/view_topic/?tid=17&pid=23">vYuri said:</a> </small>\r\n<p><small>I am on the server right now, when is the beta test?</small></p>\r\n</blockquote>\r\n\r\n<p>Hey, the beta test went on at 12pm today. I've been able to gather most of the issues all together. Whilst the beta test is now over, the server will be released tomorrow at 2pm EST. </p>\r\n', '2016-07-24 00:31:29'),
576(25, 2, 17, 16, '<blockquote><small><a href="/forum/view_topic/?tid=17&pid=24">saquan said:</a> </small>\r\n<blockquote><small><small><a href="/forum/view_topic/?tid=17&pid=23">vYuri said:</a> </small></small>\r\n<p><small><small>I am on the server right now, when is the beta test?</small></small></p>\r\n</blockquote>\r\n\r\n<p><small>Hey, the beta test went on at 12pm today. I've been able to gather most of the issues all together. Whilst the beta test is now over, the server will be released tomorrow at 2pm EST. </small></p>\r\n</blockquote>\r\n\r\n<p> </p>\r\n\r\n<p><small>Oh! Lol I didn't join on the server because my time zone is GMT lol</small></p>\r\n\r\n<p> </p>\r\n', '2016-07-24 01:00:51'),
577(26, 20, 18, 1, '<p>Hello,</p>\r\n\r\n<p>For those of you that do not know, <a href="http://mcverge.com/support/gamemodes">Nimbus</a> is the name of our game manager which is designed to manage multiple gamemodes at once. Considering we have a fair amount of OCN members waiting&nbsp;to try us out, and with a majority favoring 1.8 over 1.9/1.10 I&#39;ve decided to modify our existing manager and base it on 1.8, yet still allow 1.9/1.10 clients to connect. Additionally, we are also trying to have our game manager closely resemble that of Overcast&#39;s.</p>\r\n\r\n<p>You will still be able to connect to servers based on 1.10 even if you&#39;re using&nbsp;1.8 Minecraft. Due to the amount of bugs 1.8 players will encounter on a 1.10-based server, we recommend that you use our 1.8 version if on 1.8.</p>\r\n\r\n<p>Eventually these bugs will be fixed, however only time will tell. I initially said that&#39;d we&#39;d officially release today, however I&#39;ve decided to postpone that to Wednesday. Depending on how quickly we are able to get things done, we may even be able to push it up to Tuesday.</p>\r\n\r\n<hr />\r\n<p><strong>Map Developers on OCN:</strong> If you are reading this, and have interest in this project, please shoot me a PM, I&#39;d love to port some of your maps to Nimbus (obviously with your permission)</p>\r\n\r\n<p>Thanks guys for your continued support!&nbsp;</p>\r\n', '2016-07-24 21:59:47'),
578(27, 2, 19, 1, '<p>Hi,</p>\r\n\r\n<p>Some of you may already know, we will be released to the public on Wednesday (7/27). The time of the release will be put up on our twitter: https://twitter.com/mc_verge. The Beta test we had a few days ago went well. This announcement is rather important, and I'd hope you'd be willing to take a few minutes out of your day and read all of it.</p>\r\n\r\n<p>I've decided to scratch at my initial plan before, where I was going to setup a separate server that is based on 1.8. Unfortunately we will not be doing this as there are just way to many problems that have rosen from it. The server will be based on 1.10 and support 1.8-1.10 clients all together.</p>\r\n\r\n<p>On a personal level, <strong>I recommend trying us out on 1.9/1.10</strong>, we've been able to incorporate block-hitting, whilst it's a bit different. We've been able to improve 1.9/1.10 PvP If you absolutely hate it (also understandable, as everyone's preferences differ) you are also welcome to use 1.8. Work on reinstating 1.7.X support has been halted for now until further notice.</p>\r\n\r\n<hr />\r\n<h3><strong>Current unsolvable issues with 1.8</strong></h3>\r\n\r\n<ul>\r\n <li>Half the objectives displayed on scoreboard</li>\r\n <li>Bow draw backs are not displayed</li>\r\n <li>Bossbar not displayed</li>\r\n</ul>\r\n\r\n<p>*These issues have been resolved in 1.9/1.10 (part of the reason why I'd prefer if you connect with those versions)</p>\r\n\r\n<hr />\r\n<p>I'd also like to clear things up with claims made by a few people that we are using CardinalPGM. <strong>We are NOT using it (and never will). </strong>The game manager that we use was developed ground-up by me. However, I can see why players question it, and I'll gladly explain everything.</p>\r\n\r\n<p>The purpose of Cardinal was to provide OCN players with private scrimmage servers, and to allow map developers to test their maps. Cardinal follows OCN's documentation, and it wasn't made to "work" as a plugin for minigame networks, nor was it the author's intent.</p>\r\n\r\n<p>Nimbus, believe it or not, is completely different. A lot of components within our game manager were different than how it appears now. A lot of our game manager's (Nimbus) features were inspired by OCN's PGM, which is why a few things on it look similar to Cardinal (which is a mock of PGM). Maps that Nimbus reads are written in YAML (not XML), and the documentation is being written as we speak. Recently, the goal of MCVerge has become to be a smooth transition for the OCN community, and to allow them to continue playing the games they've loved whilst cherishing their moments from OCN. To allow this transition to be smooth as possible.</p>\r\n\r\n<p><em>tl;dr We do not use Cardinal, and it would never work with our framework.</em></p>\r\n\r\n<p>I hope this clears up the confusion, and I also hope you guys are excited for the release which will be held tomorrow!</p>\r\n', '2016-07-27 03:02:15'),
579(28, 2, 19, 21, '<p>Neat</p>\r\n', '2016-07-31 04:34:59'),
580(29, 3, 20, 1, '<p>Hi everyone,</p>\r\n\r\n<p>As (hopefully all of you) some of you may know, we've released a few hours ago to the public with 2 playable servers available (Janus and Agarus). We had a much better turnout than I had initially expected, considering we were able to maintain a constant 7-15 playerbase for a couple hours. However, we reached over 100 joins in the span of just 6 hours. We have larger plans in terms of advertisement to help us get off the ground even further as well.</p>\r\n\r\n<p>In addition to Nimbus, we will also be offering a couple new minigames in the upcoming months. Information on these "new minigames" will be released later this year (some time in November).</p>\r\n\r\n<p>I've also pushed a couple new changes/fixes. One of the more obvious ones is that you can now easily switch servers using the Enchanted Book provided to you in your 9th inventory slot. We've also fixed the faulty credits system which wasn't doing such a good job. A cosmetic shop will soon be open to where you will be able to buy kits for Nimbus using your credits (on maps that offer selectable kits).</p>\r\n\r\n<p>With all this being said, I'd like to hear some feedback on MCVerge (such as things you like/dislike, etc.).</p>\r\n\r\n<p>Thanks!</p>\r\n', '2016-08-09 03:51:03'),
581(31, 2, 21, 1, '<p>Hi everyone,</p>\r\n\r\n<p>I&#39;ve recently pushed an update which optimizes the compalbility of allowing multiple client versions to connect. 1 of our Nimbus servers is 1.10 based yet allows 1.8-1.9 to connect (although it&#39;s extremely buggy for 1.8 users and isn&#39;t recommended). We also have 2 other Nimbus servers that are 1.8-based yet allow 1.9/1.10 players to connect perfectly fine as well.</p>\r\n\r\n<p>I&#39;ve also taken the courtesy and implemented our long-awaited anti-cheat system. Obviously it&#39;s not 100% perfect, however it&#39;s tough and can handle most hacks (for now at least), and supports all versions, 1.8-1.10.</p>\r\n\r\n<p>The forums have also gotten a bit of an update. We now have an Infractions page which logs all infractions given to players upon a staff member&#39;s decision. Forum replies/topics are also formatted&nbsp;a bit differently now, thanks to&nbsp;<a href="/profile/Samerton">@Samerton</a>!</p>\r\n\r\n<p>We&#39;re still working on our advertisement, and also porting maps that have generously been given to us by some of the Map-Makers over on OCN to support Nimbus. I&#39;m hoping we can work something out in terms of advertisement very soon, however the server is up (and has been up) and is playable/available to the Minecraft community.</p>\r\n\r\n<p>Thanks for all the support thus far!</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n', '2016-08-24 01:48:43');
582
583-- --------------------------------------------------------
584
585--
586-- Table structure for table `nl1_private_messages`
587--
588
589CREATE TABLE IF NOT EXISTS `nl1_private_messages` (
590 `id` int(11) NOT NULL AUTO_INCREMENT,
591 `author_id` int(11) NOT NULL,
592 `title` varchar(128) NOT NULL,
593 `content` mediumtext NOT NULL,
594 `sent_date` datetime NOT NULL,
595 `updated` int(11) NOT NULL,
596 PRIMARY KEY (`id`)
597) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
598
599--
600-- Dumping data for table `nl1_private_messages`
601--
602
603INSERT INTO `nl1_private_messages` (`id`, `author_id`, `title`, `content`, `sent_date`, `updated`) VALUES
604(1, 1, 'Test', '<p>Hello, this is just a test.</p>\r\n', '2016-01-22 02:05:14', 0),
605(3, 8, 'Hi', '<p>Testing this u lil bitch</p>\r\n', '2016-04-24 22:27:22', 0),
606(4, 16, 'Online users', '<p>Hello saquan, I saw that you use profile images in the &quot;Online users&quot; section below the forum table, may I ask what do you use for that? if $mcname or something like that?&nbsp;</p>\r\n', '2016-07-24 01:19:21', 0),
607(6, 16, 'RE: Online users', '<p>I can&#39;t get it working... :( can you share the code?</p>\r\n', '2016-07-24 23:13:59', 0),
608(8, 1, 'Test', '<p>Hi,</p>\r\n\r\n<p>This is a quick test.</p>\r\n', '2016-08-02 15:38:36', 0),
609(9, 1, 'RE: Test', '<p>see what happens now</p>\r\n', '2016-08-02 15:38:54', 0),
610(10, 1, 'Test', '', '0000-00-00 00:00:00', 1471206203);
611
612-- --------------------------------------------------------
613
614--
615-- Table structure for table `nl1_private_messages_replies`
616--
617
618CREATE TABLE IF NOT EXISTS `nl1_private_messages_replies` (
619 `id` int(11) NOT NULL AUTO_INCREMENT,
620 `pm_id` int(11) NOT NULL,
621 `content` mediumtext NOT NULL,
622 `user_id` int(11) NOT NULL,
623 `created` int(11) NOT NULL,
624 PRIMARY KEY (`id`)
625) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
626
627--
628-- Dumping data for table `nl1_private_messages_replies`
629--
630
631INSERT INTO `nl1_private_messages_replies` (`id`, `pm_id`, `content`, `user_id`, `created`) VALUES
632(1, 10, '<p>Bruh</p>\r\n', 1, 1471206170),
633(2, 10, '<p>fight me bro</p>\r\n', 19, 1471206203);
634
635-- --------------------------------------------------------
636
637--
638-- Table structure for table `nl1_private_messages_users`
639--
640
641CREATE TABLE IF NOT EXISTS `nl1_private_messages_users` (
642 `id` int(11) NOT NULL AUTO_INCREMENT,
643 `pm_id` int(11) NOT NULL,
644 `user_id` int(11) NOT NULL,
645 `read` tinyint(1) NOT NULL DEFAULT '0',
646 PRIMARY KEY (`id`)
647) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
648
649--
650-- Dumping data for table `nl1_private_messages_users`
651--
652
653INSERT INTO `nl1_private_messages_users` (`id`, `pm_id`, `user_id`, `read`) VALUES
654(1, 1, 2, 0),
655(3, 3, 1, 1),
656(8, 6, 16, 1),
657(11, 8, 8, 0),
658(12, 9, 8, 0),
659(13, 9, 1, 1),
660(14, 10, 19, 1),
661(15, 10, 1, 1);
662
663-- --------------------------------------------------------
664
665--
666-- Table structure for table `nl1_query_errors`
667--
668
669CREATE TABLE IF NOT EXISTS `nl1_query_errors` (
670 `id` int(11) NOT NULL AUTO_INCREMENT,
671 `date` int(11) NOT NULL,
672 `error` varchar(2048) NOT NULL,
673 `ip` varchar(64) NOT NULL,
674 `port` int(6) NOT NULL,
675 PRIMARY KEY (`id`)
676) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1169 ;
677
678--
679-- Dumping data for table `nl1_query_errors`
680--
681
682INSERT INTO `nl1_query_errors` (`id`, `date`, `error`, `ip`, `port`) VALUES
683(1015, 1471226329, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
684(1016, 1471226563, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
685(1017, 1471231716, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
686(1018, 1471231721, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
687(1019, 1471231746, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
688(1020, 1471235893, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
689(1021, 1471235906, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
690(1022, 1471236989, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
691(1023, 1471237009, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
692(1024, 1471237024, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
693(1025, 1471239912, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
694(1026, 1471266152, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
695(1027, 1471272047, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
696(1028, 1471272163, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
697(1029, 1471278512, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
698(1030, 1471279904, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
699(1031, 1471280079, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
700(1032, 1471280653, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
701(1033, 1471281712, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
702(1034, 1471281746, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
703(1035, 1471281772, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
704(1036, 1471281834, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
705(1037, 1471281886, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
706(1038, 1471283840, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
707(1039, 1471286786, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
708(1040, 1471288031, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
709(1041, 1471288046, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
710(1042, 1471288205, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
711(1043, 1471290294, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
712(1044, 1471304683, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
713(1045, 1471304684, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
714(1046, 1471349547, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
715(1047, 1471349548, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
716(1048, 1471366263, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
717(1049, 1471366264, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
718(1050, 1471397137, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
719(1051, 1471397138, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
720(1052, 1471512784, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
721(1053, 1471512785, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
722(1054, 1471692497, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
723(1055, 1471692498, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
724(1056, 1471692498, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
725(1057, 1471692498, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
726(1058, 1471692499, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
727(1059, 1471692499, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
728(1060, 1471722972, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
729(1061, 1471722974, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
730(1062, 1471729582, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
731(1063, 1471729583, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
732(1064, 1471850473, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
733(1065, 1471850474, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
734(1066, 1471850475, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
735(1067, 1471850477, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
736(1068, 1471880660, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
737(1069, 1471880661, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
738(1070, 1471952800, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
739(1071, 1471952801, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
740(1072, 1472068484, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
741(1073, 1472068485, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
742(1074, 1472078613, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
743(1075, 1472078614, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
744(1076, 1472097769, 'Failed to connect or create a socket: 111 (Connection refused)', '158.69.242.233', 25568),
745(1077, 1472097960, 'Failed to connect or create a socket: 111 (Connection refused)', '158.69.242.233', 25568),
746(1078, 1472121898, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
747(1079, 1472121899, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
748(1080, 1472152747, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
749(1081, 1472152748, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
750(1082, 1472152751, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
751(1083, 1472152752, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
752(1084, 1472171148, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
753(1085, 1472171149, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
754(1086, 1472184355, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
755(1087, 1472184356, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
756(1088, 1472184357, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
757(1089, 1472184358, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
758(1090, 1472193813, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
759(1091, 1472193814, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
760(1092, 1472201273, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
761(1093, 1472201274, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
762(1094, 1472215851, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
763(1095, 1472216773, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
764(1096, 1472217713, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
765(1097, 1472220500, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
766(1098, 1472220505, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
767(1099, 1472224578, 'Failed to connect or create a socket: 110 (Connection timed out)', '158.69.242.233', 25568),
768(1100, 1472303031, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
769(1101, 1472303032, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
770(1102, 1472303538, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
771(1103, 1472303539, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
772(1104, 1472303539, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
773(1105, 1472303540, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
774(1106, 1472303540, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
775(1107, 1472303542, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
776(1108, 1472480546, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
777(1109, 1472480547, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
778(1110, 1472485999, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
779(1111, 1472486000, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
780(1112, 1472489687, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
781(1113, 1472489688, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
782(1114, 1472501846, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
783(1115, 1472501847, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
784(1116, 1472533606, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
785(1117, 1472533607, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
786(1118, 1472577401, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
787(1119, 1472577402, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
788(1120, 1472587035, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
789(1121, 1472587036, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
790(1122, 1472587401, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
791(1123, 1472587402, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
792(1124, 1472621072, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
793(1125, 1472621073, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
794(1126, 1472621075, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
795(1127, 1472621076, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
796(1128, 1472667281, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
797(1129, 1472667282, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
798(1130, 1472876438, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
799(1131, 1472876439, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
800(1132, 1472915398, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
801(1133, 1472915398, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
802(1134, 1472915398, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
803(1135, 1472915399, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
804(1136, 1472915399, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
805(1137, 1472915399, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
806(1138, 1472957329, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
807(1139, 1472957330, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
808(1140, 1473039801, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
809(1141, 1473039802, 'Failed to connect or create a socket: 110 (Connection timed out)', '108.61.21.227', 25567),
810(1142, 1473087543, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
811(1143, 1473088160, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
812(1144, 1473088161, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
813(1145, 1473097564, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
814(1146, 1473097580, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
815(1147, 1473101286, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
816(1148, 1473101429, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
817(1149, 1473124960, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
818(1150, 1473145337, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
819(1151, 1473145337, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
820(1152, 1473146371, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
821(1153, 1473154147, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
822(1154, 1473154147, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
823(1155, 1473154157, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
824(1156, 1473154161, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
825(1157, 1473154165, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
826(1158, 1473171386, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
827(1159, 1473180121, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
828(1160, 1473180676, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
829(1161, 1473181705, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
830(1162, 1473193213, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
831(1163, 1473193220, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
832(1164, 1473193227, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
833(1165, 1473193560, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
834(1166, 1473193585, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
835(1167, 1473194417, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710),
836(1168, 1473194422, 'Failed to connect or create a socket: 110 (Connection timed out)', '167.114.210.171', 25710);
837
838-- --------------------------------------------------------
839
840--
841-- Table structure for table `nl1_reports`
842--
843
844CREATE TABLE IF NOT EXISTS `nl1_reports` (
845 `id` int(11) NOT NULL AUTO_INCREMENT,
846 `type` tinyint(1) NOT NULL,
847 `reporter_id` int(11) NOT NULL,
848 `reported_id` int(11) NOT NULL,
849 `status` tinyint(1) NOT NULL,
850 `date_reported` datetime NOT NULL,
851 `date_updated` datetime NOT NULL,
852 `report_reason` varchar(255) NOT NULL,
853 `updated_by` int(11) NOT NULL,
854 `reported_post` int(11) NOT NULL,
855 `reported_post_topic` int(11) NOT NULL,
856 PRIMARY KEY (`id`)
857) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
858
859--
860-- Dumping data for table `nl1_reports`
861--
862
863INSERT INTO `nl1_reports` (`id`, `type`, `reporter_id`, `reported_id`, `status`, `date_reported`, `date_updated`, `report_reason`, `updated_by`, `reported_post`, `reported_post_topic`) VALUES
864(1, 0, 8, 1, 1, '2016-04-24 22:08:31', '2016-04-24 22:09:20', 'Testing out reports system', 1, 12, 10),
865(2, 0, 8, 1, 0, '2016-04-24 22:27:58', '2016-04-24 22:27:58', 'u is gay', 8, 4, 4);
866
867-- --------------------------------------------------------
868
869--
870-- Table structure for table `nl1_reports_comments`
871--
872
873CREATE TABLE IF NOT EXISTS `nl1_reports_comments` (
874 `id` int(11) NOT NULL AUTO_INCREMENT,
875 `report_id` int(11) NOT NULL,
876 `commenter_id` int(11) NOT NULL,
877 `comment_date` datetime NOT NULL,
878 `comment_content` varchar(255) NOT NULL,
879 PRIMARY KEY (`id`)
880) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
881
882-- --------------------------------------------------------
883
884--
885-- Table structure for table `nl1_reputation`
886--
887
888CREATE TABLE IF NOT EXISTS `nl1_reputation` (
889 `id` int(11) NOT NULL AUTO_INCREMENT,
890 `user_received` int(11) NOT NULL,
891 `post_id` int(11) NOT NULL,
892 `topic_id` int(11) NOT NULL,
893 `user_given` int(11) NOT NULL,
894 `time_given` datetime NOT NULL,
895 PRIMARY KEY (`id`)
896) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
897
898--
899-- Dumping data for table `nl1_reputation`
900--
901
902INSERT INTO `nl1_reputation` (`id`, `user_received`, `post_id`, `topic_id`, `user_given`, `time_given`) VALUES
903(1, 1, 15, 10, 8, '2016-04-17 16:50:32'),
904(2, 1, 12, 10, 8, '2016-04-17 16:50:39'),
905(3, 1, 22, 17, 16, '2016-07-24 00:21:09'),
906(4, 16, 25, 17, 1, '2016-07-24 01:10:15'),
907(5, 21, 28, 19, 1, '2016-07-31 13:35:33');
908
909-- --------------------------------------------------------
910
911--
912-- Table structure for table `nl1_settings`
913--
914
915CREATE TABLE IF NOT EXISTS `nl1_settings` (
916 `id` int(11) NOT NULL AUTO_INCREMENT,
917 `name` varchar(64) NOT NULL,
918 `value` varchar(2048) NOT NULL,
919 PRIMARY KEY (`id`)
920) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=221 ;
921
922--
923-- Dumping data for table `nl1_settings`
924--
925
926INSERT INTO `nl1_settings` (`id`, `name`, `value`) VALUES
927(1, 'sitename', 'The Verge'),
928(2, 'maintenance', 'false'),
929(3, 'outgoing_email', 'staff@mcverge.com'),
930(4, 'incoming_email', 'staff@mcverge.com'),
931(5, 'youtube_url', 'null'),
932(6, 'twitter_url', 'https://twitter.com/mc_verge'),
933(7, 'gplus_url', 'null'),
934(8, 'fb_url', 'null'),
935(9, 'twitter_feed_id', '606256293989498880'),
936(10, 'recaptcha', 'false'),
937(11, 'recaptcha_key', 'null'),
938(12, 't_and_c', 'By registering on our website, you agree to the following:<p>This website uses "Nameless" website software. The "Nameless" software creators will not be held responsible for any content that may be experienced whilst browsing this site, nor are they responsible for any loss of data which may come about, for example a hacking attempt. The website is run independently from the software creators, and any content is the responsibility of the website administration.</p>'),
939(13, 't_and_c_site', '<p>You agree to be bound by our website rules and any laws which may apply to this website and your participation.</p><p>The website administration have the right to terminate your account at any time, delete any content you may have posted, and your IP address and any data you input to the website is recorded to assist the site staff with their moderation duties.</p><p>The site administration have the right to change these terms and conditions, and any site rules, at any point without warning. Whilst you may be informed of any changes, it is your responsibility to check these terms and the rules at any point.</p>'),
940(14, 'displaynames', 'false'),
941(15, 'ga_script', 'null'),
942(16, 'avatar_api', 'cravatar'),
943(17, 'language', 'EnglishUK'),
944(18, 'forum_layout', '1'),
945(19, 'error_reporting', '0'),
946(20, 'inverse_navbar', '0'),
947(21, 'unique_id', 'FvE82abdHPjO1UfJQICRVwcrlN9BYu6MyAKqpGX0kgDxTZ4em3ohinzWS7Ls5t'),
948(22, 'uuid_linking', '1'),
949(23, 'user_avatars', '0'),
950(24, 'use_plugin', '1'),
951(25, 'external_query', 'false'),
952(26, 'phpmailer', '0'),
953(27, 'phpmailer_type', 'smtp'),
954(28, 'mc_api_key', 'RDA65v74iBJjhsZHMNFeXVnbqIUGQrzx'),
955(29, 'version', '1.0.9'),
956(30, 'version_checked', '1472694836'),
957(31, 'version_update', 'true'),
958(32, 'query_update', 'false'),
959(33, 'sitename', 'The Verge'),
960(34, 'maintenance', 'false'),
961(35, 'outgoing_email', 'staff@mcverge.com'),
962(36, 'incoming_email', 'staff@mcverge.com'),
963(37, 'youtube_url', 'null'),
964(38, 'twitter_url', 'https://twitter.com/mc_verge'),
965(39, 'gplus_url', 'null'),
966(40, 'fb_url', 'null'),
967(41, 'twitter_feed_id', '606256293989498880'),
968(42, 'recaptcha', 'false'),
969(43, 'recaptcha_key', 'null'),
970(44, 't_and_c', 'By registering on our website, you agree to the following:<p>This website uses "Nameless" website software. The "Nameless" software creators will not be held responsible for any content that may be experienced whilst browsing this site, nor are they responsible for any loss of data which may come about, for example a hacking attempt. The website is run independently from the software creators, and any content is the responsibility of the website administration.</p>'),
971(45, 't_and_c_site', '<p>You agree to be bound by our website rules and any laws which may apply to this website and your participation.</p><p>The website administration have the right to terminate your account at any time, delete any content you may have posted, and your IP address and any data you input to the website is recorded to assist the site staff with their moderation duties.</p><p>The site administration have the right to change these terms and conditions, and any site rules, at any point without warning. Whilst you may be informed of any changes, it is your responsibility to check these terms and the rules at any point.</p>'),
972(46, 'displaynames', 'false'),
973(47, 'ga_script', 'null'),
974(48, 'avatar_api', 'cravatar'),
975(49, 'language', 'EnglishUK'),
976(50, 'forum_layout', '1'),
977(51, 'error_reporting', '0'),
978(52, 'inverse_navbar', '0'),
979(53, 'unique_id', 'kq5B4jPyt9Ez0LogamHRVXcWseG8x2OMb7lfYNKdCThSZAvp6DruJQU1iwn3IF'),
980(54, 'uuid_linking', '1'),
981(55, 'user_avatars', '0'),
982(56, 'use_plugin', '0'),
983(57, 'external_query', 'false'),
984(58, 'phpmailer', '0'),
985(59, 'phpmailer_type', 'smtp'),
986(60, 'mc_api_key', 'dE2WkqK36ZB18rsmzhFPY5QIjy7nMXDf'),
987(61, 'version', '1.0.0'),
988(62, 'version_checked', '1452117855'),
989(63, 'version_update', 'false'),
990(64, 'query_update', 'false'),
991(65, 'sitename', 'MCVerge'),
992(66, 'maintenance', 'false'),
993(67, 'outgoing_email', 'support@mcverge.com'),
994(68, 'incoming_email', 'support@mcverge.com'),
995(69, 'youtube_url', 'null'),
996(70, 'twitter_url', 'https://twitter.com/mc_verge'),
997(71, 'gplus_url', 'null'),
998(72, 'fb_url', 'null'),
999(73, 'twitter_feed_id', '606256293989498880'),
1000(74, 'recaptcha', 'false'),
1001(75, 'recaptcha_key', 'null'),
1002(76, 't_and_c', 'By registering on our website, you agree to the following:<p>This website uses "Nameless" website software. The "Nameless" software creators will not be held responsible for any content that may be experienced whilst browsing this site, nor are they responsible for any loss of data which may come about, for example a hacking attempt. The website is run independently from the software creators, and any content is the responsibility of the website administration.</p>'),
1003(77, 't_and_c_site', '<p>You agree to be bound by our website rules and any laws which may apply to this website and your participation.</p><p>The website administration have the right to terminate your account at any time, delete any content you may have posted, and your IP address and any data you input to the website is recorded to assist the site staff with their moderation duties.</p><p>The site administration have the right to change these terms and conditions, and any site rules, at any point without warning. Whilst you may be informed of any changes, it is your responsibility to check these terms and the rules at any point.</p>'),
1004(78, 'displaynames', 'false'),
1005(79, 'ga_script', 'null'),
1006(80, 'avatar_api', 'cravatar'),
1007(81, 'language', 'EnglishUK'),
1008(82, 'forum_layout', '1'),
1009(83, 'error_reporting', '0'),
1010(84, 'inverse_navbar', '0'),
1011(85, 'unique_id', 'uygA9q02JGzxj1NlrhCBkQSF3IdZRVK86fwvETo4mpWHib7nYLsc5PUDetXaMO'),
1012(86, 'uuid_linking', '1'),
1013(87, 'user_avatars', '0'),
1014(88, 'use_plugin', '0'),
1015(89, 'external_query', 'false'),
1016(90, 'phpmailer', '0'),
1017(91, 'phpmailer_type', 'smtp'),
1018(92, 'mc_api_key', '5XOs71FfJE6qyGI43YvBtlUgiVNkapPu'),
1019(93, 'version', '1.0.3'),
1020(94, 'version_checked', '1453513045'),
1021(95, 'version_update', 'false'),
1022(96, 'query_update', 'false'),
1023(97, 'mc_status_module', 'true'),
1024(98, 'recaptcha_secret', 'null'),
1025(99, 'email_verification', '0'),
1026(100, 'sitename', 'MCVerge'),
1027(101, 'maintenance', 'false'),
1028(102, 'outgoing_email', 'staff@mcverge.com'),
1029(103, 'incoming_email', 'staff@mcverge.com'),
1030(104, 'youtube_url', 'null'),
1031(105, 'twitter_url', 'https://twitter.com/mc_verge'),
1032(106, 'gplus_url', 'null'),
1033(107, 'fb_url', 'null'),
1034(108, 'twitter_feed_id', '606256293989498880'),
1035(109, 'recaptcha', 'false'),
1036(110, 'recaptcha_key', 'null'),
1037(111, 't_and_c', 'By registering on our website, you agree to the following:<p>This website uses "Nameless" website software. The "Nameless" software creators will not be held responsible for any content that may be experienced whilst browsing this site, nor are they responsible for any loss of data which may come about, for example a hacking attempt. The website is run independently from the software creators, and any content is the responsibility of the website administration.</p>'),
1038(112, 't_and_c_site', '<p>You agree to be bound by our website rules and any laws which may apply to this website and your participation.</p><p>The website administration have the right to terminate your account at any time, delete any content you may have posted, and your IP address and any data you input to the website is recorded to assist the site staff with their moderation duties.</p><p>The site administration have the right to change these terms and conditions, and any site rules, at any point without warning. Whilst you may be informed of any changes, it is your responsibility to check these terms and the rules at any point.</p>'),
1039(113, 'displaynames', 'false'),
1040(114, 'ga_script', 'null'),
1041(115, 'avatar_api', 'cravatar'),
1042(116, 'language', 'EnglishUK'),
1043(117, 'forum_layout', '1'),
1044(118, 'error_reporting', '0'),
1045(119, 'inverse_navbar', '0'),
1046(120, 'unique_id', 'ezAVcHdbj5Wlk1nfCmZK8PNqY9LioMwsgXOBJTxrGhyv7F0IaEt3S42puR6UQD'),
1047(121, 'uuid_linking', '1'),
1048(122, 'user_avatars', '0'),
1049(123, 'use_plugin', '0'),
1050(124, 'external_query', 'false'),
1051(125, 'phpmailer', '0'),
1052(126, 'phpmailer_type', 'smtp'),
1053(127, 'mc_api_key', 'yvikLZPSzpuAj9gb36owaJnCrOf2RKGD'),
1054(128, 'version', '1.0.7'),
1055(129, 'version_checked', '1459973638'),
1056(130, 'version_update', 'false'),
1057(131, 'query_update', 'false'),
1058(132, 'mc_status_module', 'false'),
1059(133, 'recaptcha_secret', 'null'),
1060(134, 'email_verification', '1'),
1061(135, 'play_page_enabled', '1'),
1062(136, 'followers', '0'),
1063(137, 'mc_status_module', 'false'),
1064(138, 'recaptcha_secret', 'null'),
1065(139, 'email_verification', '1'),
1066(140, 'play_page_enabled', '1'),
1067(141, 'followers', '0'),
1068(142, 'discord', '0'),
1069(143, 'sitename', 'MCVerge'),
1070(144, 'maintenance', 'false'),
1071(145, 'outgoing_email', 'staff@mcverge.com'),
1072(146, 'incoming_email', 'staff@mcverge.com'),
1073(147, 'youtube_url', 'null'),
1074(148, 'twitter_url', 'https://twitter.com/mc_verge'),
1075(149, 'gplus_url', 'null'),
1076(150, 'fb_url', 'null'),
1077(151, 'twitter_feed_id', '606256293989498880'),
1078(152, 'recaptcha', 'false'),
1079(153, 'recaptcha_key', 'null'),
1080(154, 't_and_c', 'By registering on our website, you agree to the following:<p>This website uses "Nameless" website software. The "Nameless" software creators will not be held responsible for any content that may be experienced whilst browsing this site, nor are they responsible for any loss of data which may come about, for example a hacking attempt. The website is run independently from the software creators, and any content is the responsibility of the website administration.</p>'),
1081(155, 't_and_c_site', '<p>You agree to be bound by our website rules and any laws which may apply to this website and your participation.</p><p>The website administration have the right to terminate your account at any time, delete any content you may have posted, and your IP address and any data you input to the website is recorded to assist the site staff with their moderation duties.</p><p>The site administration have the right to change these terms and conditions, and any site rules, at any point without warning. Whilst you may be informed of any changes, it is your responsibility to check these terms and the rules at any point.</p>'),
1082(156, 'displaynames', 'false'),
1083(157, 'ga_script', 'null'),
1084(158, 'avatar_api', 'cravatar'),
1085(159, 'language', 'EnglishUK'),
1086(160, 'forum_layout', '1'),
1087(161, 'error_reporting', '0'),
1088(162, 'inverse_navbar', '0'),
1089(163, 'unique_id', 'Seb12WtE7sn9NIUzB4ZP5ouKqmHFxfpVhXcyQiC3DGAv8wklMgOj06LTdraJYR'),
1090(164, 'uuid_linking', '1'),
1091(165, 'user_avatars', '0'),
1092(166, 'use_plugin', '0'),
1093(167, 'external_query', 'false'),
1094(168, 'phpmailer', '0'),
1095(169, 'phpmailer_type', 'smtp'),
1096(170, 'mc_api_key', 'moVLKNHqTRcGE3fp18XQibySUwYuCIzM'),
1097(171, 'version', '1.0.11'),
1098(172, 'version_checked', '1470950847'),
1099(173, 'version_update', 'false'),
1100(174, 'query_update', 'false'),
1101(175, 'mc_status_module', 'false'),
1102(176, 'recaptcha_secret', 'null'),
1103(177, 'email_verification', '1'),
1104(178, 'play_page_enabled', '1'),
1105(179, 'followers', '0'),
1106(180, 'discord', '0'),
1107(181, 'avatar_type', 'helmavatar'),
1108(182, 'sitename', 'MCVerge'),
1109(183, 'maintenance', 'false'),
1110(184, 'outgoing_email', 'staff@mcverge.com'),
1111(185, 'incoming_email', 'staff@mcverge.com'),
1112(186, 'youtube_url', 'null'),
1113(187, 'twitter_url', 'https://twitter.com/mc_verge'),
1114(188, 'gplus_url', 'null'),
1115(189, 'fb_url', 'null'),
1116(190, 'twitter_feed_id', '606256293989498880'),
1117(191, 'recaptcha', 'false'),
1118(192, 'recaptcha_key', 'null'),
1119(193, 't_and_c', 'By registering on our website, you agree to the following:<p>This website uses "Nameless" website software. The "Nameless" software creators will not be held responsible for any content that may be experienced whilst browsing this site, nor are they responsible for any loss of data which may come about, for example a hacking attempt. The website is run independently from the software creators, and any content is the responsibility of the website administration.</p>'),
1120(194, 't_and_c_site', '<p>You agree to be bound by our website rules and any laws which may apply to this website and your participation.</p><p>The website administration have the right to terminate your account at any time, delete any content you may have posted, and your IP address and any data you input to the website is recorded to assist the site staff with their moderation duties.</p><p>The site administration have the right to change these terms and conditions, and any site rules, at any point without warning. Whilst you may be informed of any changes, it is your responsibility to check these terms and the rules at any point.</p>'),
1121(195, 'displaynames', 'false'),
1122(196, 'ga_script', 'null'),
1123(197, 'avatar_api', 'cravatar'),
1124(198, 'language', 'EnglishUK'),
1125(199, 'forum_layout', '1'),
1126(200, 'error_reporting', '0'),
1127(201, 'inverse_navbar', '0'),
1128(202, 'unique_id', 'oewzGSCO247xjlhm6LBZDyaIpniUkKvTXV0FfNcdYqgWRQr8P1AE5u9sbHtMJ3'),
1129(203, 'uuid_linking', '1'),
1130(204, 'user_avatars', '0'),
1131(205, 'use_plugin', '0'),
1132(206, 'external_query', 'false'),
1133(207, 'phpmailer', '0'),
1134(208, 'phpmailer_type', 'smtp'),
1135(209, 'mc_api_key', 'ZILNXzjeBC5KvU74wnpG3md8AYQtyP9k'),
1136(210, 'version', '1.0.11'),
1137(211, 'version_checked', '1470955231'),
1138(212, 'version_update', 'false'),
1139(213, 'query_update', 'false'),
1140(214, 'mc_status_module', 'false'),
1141(215, 'recaptcha_secret', 'null'),
1142(216, 'email_verification', '1'),
1143(217, 'play_page_enabled', '1'),
1144(218, 'followers', '0'),
1145(219, 'discord', '0'),
1146(220, 'avatar_type', 'helmavatar');
1147
1148-- --------------------------------------------------------
1149
1150--
1151-- Table structure for table `nl1_staff_apps_comments`
1152--
1153
1154CREATE TABLE IF NOT EXISTS `nl1_staff_apps_comments` (
1155 `id` int(11) NOT NULL AUTO_INCREMENT,
1156 `aid` int(11) NOT NULL,
1157 `uid` int(11) NOT NULL,
1158 `time` int(11) NOT NULL,
1159 `content` mediumtext NOT NULL,
1160 PRIMARY KEY (`id`)
1161) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1162
1163-- --------------------------------------------------------
1164
1165--
1166-- Table structure for table `nl1_staff_apps_questions`
1167--
1168
1169CREATE TABLE IF NOT EXISTS `nl1_staff_apps_questions` (
1170 `id` int(11) NOT NULL AUTO_INCREMENT,
1171 `type` int(11) NOT NULL,
1172 `name` varchar(16) NOT NULL,
1173 `question` varchar(256) NOT NULL,
1174 `options` text NOT NULL,
1175 PRIMARY KEY (`id`)
1176) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1177
1178-- --------------------------------------------------------
1179
1180--
1181-- Table structure for table `nl1_staff_apps_replies`
1182--
1183
1184CREATE TABLE IF NOT EXISTS `nl1_staff_apps_replies` (
1185 `id` int(11) NOT NULL AUTO_INCREMENT,
1186 `uid` int(11) NOT NULL,
1187 `time` int(11) NOT NULL,
1188 `content` mediumtext NOT NULL,
1189 `status` int(11) NOT NULL DEFAULT '0',
1190 PRIMARY KEY (`id`)
1191) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1192
1193-- --------------------------------------------------------
1194
1195--
1196-- Table structure for table `nl1_templates`
1197--
1198
1199CREATE TABLE IF NOT EXISTS `nl1_templates` (
1200 `id` int(11) NOT NULL AUTO_INCREMENT,
1201 `enabled` tinyint(1) NOT NULL DEFAULT '0',
1202 `name` varchar(64) NOT NULL,
1203 PRIMARY KEY (`id`)
1204) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
1205
1206--
1207-- Dumping data for table `nl1_templates`
1208--
1209
1210INSERT INTO `nl1_templates` (`id`, `enabled`, `name`) VALUES
1211(4, 0, 'Default'),
1212(6, 0, 'Adobes'),
1213(7, 0, 'email'),
1214(8, 1, 'styles'),
1215(10, 0, 'Master'),
1216(11, 0, 'cartels'),
1217(12, 1, 'Default'),
1218(13, 1, 'Default');
1219
1220-- --------------------------------------------------------
1221
1222--
1223-- Table structure for table `nl1_themes`
1224--
1225
1226CREATE TABLE IF NOT EXISTS `nl1_themes` (
1227 `id` int(11) NOT NULL AUTO_INCREMENT,
1228 `enabled` tinyint(1) NOT NULL DEFAULT '0',
1229 `name` varchar(64) NOT NULL,
1230 PRIMARY KEY (`id`)
1231) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
1232
1233--
1234-- Dumping data for table `nl1_themes`
1235--
1236
1237INSERT INTO `nl1_themes` (`id`, `enabled`, `name`) VALUES
1238(1, 0, 'Bootstrap'),
1239(2, 0, 'Cerulean'),
1240(3, 0, 'Cosmo'),
1241(4, 0, 'Cyborg'),
1242(5, 0, 'Darkly'),
1243(6, 0, 'Flatly'),
1244(7, 0, 'Journal'),
1245(8, 0, 'Lumen'),
1246(9, 1, 'Paper'),
1247(10, 0, 'Readable'),
1248(11, 0, 'Sandstone'),
1249(12, 0, 'Simplex'),
1250(13, 0, 'Slate'),
1251(14, 0, 'Spacelab'),
1252(15, 0, 'Superhero'),
1253(16, 0, 'United'),
1254(17, 0, 'Yeti');
1255
1256-- --------------------------------------------------------
1257
1258--
1259-- Table structure for table `nl1_topics`
1260--
1261
1262CREATE TABLE IF NOT EXISTS `nl1_topics` (
1263 `id` int(11) NOT NULL AUTO_INCREMENT,
1264 `forum_id` int(11) NOT NULL,
1265 `topic_title` varchar(150) NOT NULL,
1266 `topic_creator` int(11) NOT NULL,
1267 `topic_last_user` int(11) NOT NULL,
1268 `topic_date` int(11) NOT NULL,
1269 `topic_reply_date` int(11) NOT NULL,
1270 `topic_views` int(11) NOT NULL DEFAULT '0',
1271 `locked` tinyint(1) NOT NULL DEFAULT '0',
1272 `sticky` tinyint(1) NOT NULL DEFAULT '0',
1273 `label` int(11) DEFAULT NULL,
1274 PRIMARY KEY (`id`)
1275) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
1276
1277--
1278-- Dumping data for table `nl1_topics`
1279--
1280
1281INSERT INTO `nl1_topics` (`id`, `forum_id`, `topic_title`, `topic_creator`, `topic_last_user`, `topic_date`, `topic_reply_date`, `topic_views`, `locked`, `sticky`, `label`) VALUES
1282(1, 13, 'Guidelines to submitting a map', 1, 1, 1452472634, 1452472634, 107, 1, 1, 0),
1283(2, 2, 'MCVerge to be released!', 1, 1, 1452562171, 1452562171, 233, 0, 0, 0),
1284(5, 3, 'The Premise of this Section', 1, 1, 1454865627, 1454865627, 115, 1, 1, 0),
1285(8, 20, 'Network-Wide Statistics', 1, 1, 1457490001, 1457490001, 150, 1, 0, 0),
1286(10, 21, 'What this section is/isn''t for', 1, 1, 1459652258, 1459652258, 139, 1, 1, 0),
1287(11, 20, 'Mobile Friendly', 1, 1, 1460992407, 1460992407, 119, 0, 0, 0),
1288(13, 8, 'Before creating a thread here...', 1, 1, 1462656126, 1462656126, 110, 1, 1, 8),
1289(15, 2, 'We''re upgrading to 1.10', 1, 1, 1466345823, 1466345823, 82, 0, 0, 0),
1290(16, 2, 'Reinstating 1.8 (possibly 1.7) support', 1, 1, 1468939941, 1468939941, 104, 0, 0, 0),
1291(17, 2, 'Beta Testing (7/23)', 1, 16, 1469233094, 1469318451, 132, 0, 0, 0),
1292(18, 20, '1.8 version of Nimbus', 1, 1, 1469393987, 1469393987, 46, 0, 0, 0),
1293(19, 2, 'Release + GM info', 1, 21, 1469584935, 1469936099, 138, 1, 0, 0),
1294(20, 3, 'What a day!', 1, 1, 1470711063, 1470711063, 58, 0, 0, 0),
1295(21, 2, 'Full 1.8-1.10 Update', 1, 1, 1471999723, 1471999723, 16, 0, 0, 0);
1296
1297-- --------------------------------------------------------
1298
1299--
1300-- Table structure for table `nl1_users`
1301--
1302
1303CREATE TABLE IF NOT EXISTS `nl1_users` (
1304 `id` int(11) NOT NULL AUTO_INCREMENT,
1305 `username` varchar(20) NOT NULL,
1306 `password` varchar(255) NOT NULL,
1307 `pass_method` varchar(12) NOT NULL DEFAULT 'default',
1308 `mcname` varchar(20) NOT NULL,
1309 `uuid` varchar(32) NOT NULL,
1310 `joined` int(11) NOT NULL,
1311 `group_id` int(11) NOT NULL,
1312 `email` varchar(64) NOT NULL,
1313 `isbanned` tinyint(4) NOT NULL DEFAULT '0',
1314 `lastip` varchar(45) NOT NULL,
1315 `active` tinyint(4) NOT NULL DEFAULT '0',
1316 `signature` varchar(1024) DEFAULT NULL,
1317 `reputation` int(11) NOT NULL DEFAULT '0',
1318 `reset_code` varchar(60) DEFAULT NULL,
1319 `has_avatar` tinyint(4) NOT NULL DEFAULT '0',
1320 `gravatar` tinyint(1) NOT NULL DEFAULT '0',
1321 `last_online` int(11) DEFAULT NULL,
1322 `last_username_update` int(11) DEFAULT '0',
1323 `user_title` varchar(64) DEFAULT NULL,
1324 `birthday` date DEFAULT NULL,
1325 `location` varchar(128) DEFAULT NULL,
1326 `display_age` tinyint(1) NOT NULL DEFAULT '1',
1327 `tfa_enabled` tinyint(1) NOT NULL DEFAULT '0',
1328 `tfa_type` int(11) NOT NULL DEFAULT '0',
1329 `tfa_secret` varchar(256) DEFAULT NULL,
1330 `tfa_complete` tinyint(1) NOT NULL DEFAULT '0',
1331 PRIMARY KEY (`id`)
1332) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
1333
1334--
1335-- Dumping data for table `nl1_users`
1336--
1337
1338INSERT INTO `nl1_users` (`id`, `username`, `password`, `pass_method`, `mcname`, `uuid`, `joined`, `group_id`, `email`, `isbanned`, `lastip`, `active`, `signature`, `reputation`, `reset_code`, `has_avatar`, `gravatar`, `last_online`, `last_username_update`, `user_title`, `birthday`, `location`, `display_age`, `tfa_enabled`, `tfa_type`, `tfa_secret`, `tfa_complete`) VALUES
1339(1, 'evilsauce', '$2y$13$tWIS5/IJ5GxVqssFj06Rlugd.QhsSuk.hNR/XQfb212fbXK8bUJOa', 'default', 'evilsauce', '23183f6d9aea401a931ca4ef022256c5', 1452110858, 2, 'me@adobes.pw', 0, '184.90.160.48', 1, '', 3, NULL, 0, 0, 1473092258, 1471708527, NULL, '1998-12-29', 'Orlando, Florida', 0, 0, 0, NULL, 0),
1340(2, 'TestAcc', '$2y$13$L2jpawzn4SZ7f7YFMYgeoOjNjtaYhR.E8CAvQXlceMEmUJja/KjnK', 'default', 'TestAcc', '02f5b08d6d23469d812b116fc47011b3', 1452117884, 1, 'acharige@cubition.net', 0, '', 1, '', 0, NULL, 0, 0, 1452474339, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1341(3, 'ImAverage', '$2y$13$p.69xdNlP602fhgk08S43.UXcuuc0uPkBOlJ9d8ZKPNjCcHaESyie', 'default', 'ImAverage', 'ba04b9fde9e84dccb8dd97a5bfcf5a88', 1453326283, 1, 'greenkick1613@gmail.com', 0, '', 1, '', 0, NULL, 0, 0, 1453328963, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1342(4, 'SpartanBlaze', '$2y$13$bH4E4p6SgTWpep3ERiMMPefVvdxz8xrrh8DKJnr4N8FFVucBB0C.y', 'default', 'SpartanBlaze', 'cce801d84e904923b6ea969952a4dccc', 1453513073, 2, 'spartanblaze@gmail.com', 0, '', 1, NULL, 0, NULL, 0, 0, 1453513083, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1343(5, 'Will', '$2y$13$yuNbe5Tc.FWrFk7aqc3d0uvF1rvR2LPzgNdm8nFepvLUEkmS/nNYO', 'default', 'Will', '2be060b90768496aadc61d1f658efafd', 1454288430, 4, 'thefrozenfishie@gmail.com', 0, '45.49.233.37', 1, '', 0, '', 0, 0, 1466814556, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1344(6, 'Naid7', '$2y$13$QpBvidGKcpULnYyidPS0dejAy5/0SrxdQjIXwEm8w0H8BFHJ7L5N6', 'default', 'Naid7', 'f8380eb9846340ad91332e4bab46e146', 1454344152, 1, 'nerveshn7@icloud.com', 0, '', 1, '', 0, '', 0, 0, 1454344338, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1345(7, 'enderchicken101', '$2y$13$AhDuhihXTST.zJCPwqyrO.UHh1qTdVPee1aPFf5X1FSNjrOs8oFR.', 'default', 'enderchicken101', 'c0bea551c99b4d38903c0096018e901e', 1457796458, 5, 'vikramawesome123@gmail.com', 0, '', 1, '', 0, '', 0, 0, 1457796560, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1346(8, 'admin', '$2y$13$34iXeoPEvIojOAoaTr3N2uO7ifE0AVER5Kdi0fQApQjgZMZ/w5mie', 'default', 'admin', 'f680df9bac5c4d3f9bac75bc0e316afa', 1459973654, 1, 'acharige.sakun@gmail.com', 0, '184.90.160.48', 1, '', 0, 'ERt8qCm7M6gX2a1xdsk0UPZfbNcuQFDypITniOJohSAHGL3BWvjr4zVYK95l', 0, 0, 1469209997, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1347(9, 'Samerton', '$2y$13$muJ05v1l0f9MKjuRiRsihOyCR1ndRMP/eam7zyWvMkyU5dQYz8ria', 'default', 'Samerton', '2f778755502c4fb7ae96493d6429e8f3', 1461793480, 1, 'timmy437@hotmail.co.uk', 0, '138.253.132.113', 1, '', 0, '', 0, 0, 1463521869, 0, NULL, '1997-07-29', 'Wales, UK', 1, 0, 0, NULL, 0),
1348(10, 'KyloCode', '$2a$10$388.nbNjj9DdJ9u7jW6H5e5cSaeLRARtDO50Xez9KptVb9hHLb0Wu', 'default', 'KyloCode', '751ac74c45304607bd466e9c6595c5a4', 1463853197, 1, 'enderhobo@gmail.com', 0, '184.90.160.48', 1, NULL, 0, NULL, 0, 0, 1472153218, 1472152373, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1349(11, 'AGK47ball', '$2a$10$AczTYtxYdUWWYj35WhcPOeGFaLxoJpzMHiG54bO8v3XT8jFqsGRK2', 'default', 'AGK47ball', '5ff62fd8b2e74cbebaae13ea3711ffb1', 1465602324, 1, 'agk47ball@gmail.com', 0, '71.121.227.153', 1, NULL, 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1350(12, 'DTP_Etskuni', '$2a$10$Ha.w6uVEN8GLPdlwoXg7d.jXQp13kX5ru6EDyqk0aoWDmlv8xK422', 'default', 'DTP_Etskuni', 'e76a699c43894a928cb7561a3517b5e7', 1469290217, 1, 'dr.thalia185@gmail.com', 0, '83.33.94.85', 1, NULL, 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1351(13, 'DTP_UntilDawn', '$2a$10$Wrx1hvYr./iO.04NhnScuO5OGnaOFRoMYZx/XlG0zjRDfjTXHaRmS', 'default', 'DTP_UntilDawn', '1b83159e55864a788a9cabb86645d57a', 1469290390, 1, 'paydilucagranda@gmail.com', 0, '83.45.8.91', 1, NULL, 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1352(14, '2000thehecf1', '$2a$10$/YzTOhj.ecKbx.bCp//ewOcUv.VW65nhFp.vrMMT4eOEE135.vPXG', 'default', '2000thehecf1', '408267c4c74943128e288a29113c1329', 1469290889, 1, 'produccionesups@gmail.com', 0, '83.51.1.68', 1, NULL, 0, NULL, 0, 0, 1470838304, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1353(15, 'TiTo_418', '$2a$10$Nzw8yRNrp3s9yUfw8zzo7OVqCbg4WI7dGlvd9axxwTCIi0kIejctK', 'default', 'TiTo_418', '8d02e48666d546bf8e6b81e18ef9e6c7', 1469304597, 1, 'tito418mc@gmail.com', 0, '181.171.27.225', 1, NULL, 0, NULL, 0, 0, 1469304851, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1354(16, 'vYuri', '$2a$10$LwvKmAuwhEfZbTbnkehGaeqPc7VlP1VRTqkkw0wWhnHdz3NTDjl0q', 'default', 'vYuri', '8d07127429844ff3aa3a17aba7e40887', 1469316009, 1, 'yuriyuribenapres@gmail.com', 0, '201.178.7.88', 1, NULL, 1, NULL, 0, 0, 1469517630, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1355(17, 'Aisak', '$2a$10$SGoXnYQrac3IoFLWG/mXVeSdXf.gudWEDtEWi/jlb.eXmdWPtn3pK', 'default', 'Aisak', '86a53ac511db4435b672ea3773c31082', 1469336920, 2, 'isaacnv7227@gmail.com', 0, '186.46.205.212', 1, '', 0, NULL, 0, 0, 1472794324, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1356(18, 'Sarcrys', '$2a$10$ZHyAPYcUKQlOh11kCGMdE.Vbt0qIM8KCVXjtL/D2P3sb5EymWYYh6', 'default', 'Sarcrys', 'afcf078a6ab94576bb41bac508e53550', 1469406348, 1, 'yitzjak.mc@gmail.com', 0, '181.56.59.173', 1, NULL, 0, NULL, 0, 0, 1469406455, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1357(19, 'ThomasBreen', '$2a$10$O8tnuBMg3W/rmUUIF3vtGOkBp22wjYdgTUXNuZ5mLloXLK1MVukl6', 'default', 'ThomasBreen', '4b3479074b454a4bb07587259780f5bf', 1469826643, 1, 'endergicken@gmail.com', 0, '184.90.160.48', 1, NULL, 0, NULL, 0, 0, 1471225750, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1358(20, 'e_is_cool', '$2a$10$viSYG9.NE3bDxRK05GBuw.UwQPena3NaoWw/u9LNlT2BHu6cInog6', 'default', 'e_is_cool', '540599f65df64a04852b1cbc78ac7175', 1469883552, 2, 'zacharyip1@gmail.com', 0, '97.102.10.244', 1, '', 0, NULL, 0, 0, 1472324229, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1359(21, 'Crazy_', '$2a$10$SY66oaSxqmTu/FpiYq8qb.KqMh/UWWmLfu1aVJtuLPi8T3nKZPfeq', 'default', 'Crazy_', 'a9f11454beac4cc3a1381780802c8794', 1469936012, 1, 'dylan.b.thomson@gmail.com', 0, '184.151.70.119', 1, NULL, 1, NULL, 0, 0, 1469936241, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1360(22, 'Yoryk', '$2a$10$VPNeJawwiEqNH4SMmeUo.uXg8eM7iYV/FSAVUJnolINVbHYnSaBNG', 'default', 'Yoryk', 'ecad5326dfc03ee490809cb91e2bbdfd', 1470658715, 1, 'fbalmaceda1512@gmail.com', 0, '81.203.162.5', 1, NULL, 0, NULL, 0, 0, 1471040819, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1361(23, 'WhoCares4This', '$2a$10$Kc8phjbJi9ZqNvTMCsaM5uJlmBsTsPweS/O2.eNYKwQJi3S5gFgj2', 'default', 'WhoCares4This', 'b69cbc064d8e4bb1b4247c1b5e6d44cf', 1470688255, 1, 'solidified0@gmail.com', 0, '86.169.80.235', 1, NULL, 0, NULL, 0, 0, 1470690868, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1362(24, 'HeroDinneR', '$2a$10$vJ5Z8C3e5TyoSOdttE.sCOOpI3kh9K4EwWmWp6WBf8nj1bhL2yDSG', 'default', 'HeroDinneR', '01e1d2ed1d163df194499ad27ce11dd5', 1470670649, 1, 'pingpong1970@live.co.uk', 0, '108.61.21.227', 1, NULL, 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1363(25, 'Yoryk', '$2a$10$SNcJMn7vw/BHYJRrteGd7OhcsGclT0SaNKcCM2GT03JwZ9XuVoASC', 'default', 'Yoryk', '5ad0470ebd21456aa0edfac30fde84e4', 1470697637, 1, 'asdasd@gmail.com', 0, '81.203.162.5', 1, NULL, 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1364(26, 'evilsauce', '$2y$13$cHyw4ou3l16NS3BPaVgNUuttSgm.m2MP5LtHzwvvCPhDSj0nOdsgC', 'default', 'evilsauce', '23183f6d9aea401a931ca4ef022256c5', 1470950875, 2, 'acharige.sakun@gmail.com', 0, '184.90.160.48', 1, NULL, 0, NULL, 0, 0, 1471821303, 1471798992, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1365(27, 'OreCloud', '$2a$10$BMCgb.YMjc2J6xsFUdWX2OydChMfptYQqfDtCyJqUAFGKnyl4vY/S', 'default', 'OreCloud', 'fc657c752db442d394c1f8631c4aa411', 1471295928, 1, 'python.ity@gmail.com', 0, '173.48.140.38', 1, NULL, 0, NULL, 0, 0, 1471464857, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1366(28, 'FireDragonKnight', '$2a$10$RGioFtRUsjm2T9ENvLxf..MpNYISzp3ZMh0AjmddD5aPUYi3nF.rS', 'default', 'FireDragonKnight', '80b08b41afe748b6b2e42ac7d8ea1dc1', 1471332095, 1, 'ariyu3833@gmail.com', 0, '61.239.137.151', 1, NULL, 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0),
1367(29, 'FrogIsPresident', '$2a$10$BnAZnv6wEhkHGJsUS9Qt.ujNWtY6phjqEwXzniw2rLto3f8WGlGWq', 'default', 'FrogIsPresident', 'd9b9cd9cf9384b0087e1ae609ceafaab', 1472115197, 1, 'lucam511@icloud.com', 0, '86.8.17.51', 1, NULL, 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, 1, 0, 0, NULL, 0);
1368
1369-- --------------------------------------------------------
1370
1371--
1372-- Table structure for table `nl1_users_admin_session`
1373--
1374
1375CREATE TABLE IF NOT EXISTS `nl1_users_admin_session` (
1376 `id` int(11) NOT NULL AUTO_INCREMENT,
1377 `user_id` int(11) NOT NULL,
1378 `hash` varchar(64) NOT NULL,
1379 PRIMARY KEY (`id`)
1380) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
1381
1382--
1383-- Dumping data for table `nl1_users_admin_session`
1384--
1385
1386INSERT INTO `nl1_users_admin_session` (`id`, `user_id`, `hash`) VALUES
1387(5, 9, '4f944594fd278b3e53a49d0dbb3612a0935b098a3fb54c4948b9ae1023580cfe'),
1388(8, 20, '370432c66115a22b3be5e889c063d923e7fe27ab0b994e4065e4222e54480a89'),
1389(13, 1, 'd524b31c8aa5f32e001887d9e1b8a09ff8c15d456b675d787c57efc0eb71862b'),
1390(14, 17, '22c473ef036a4e7008c4b4896b331978d24196b880ff50cecbf21eb9b3252eaa');
1391
1392-- --------------------------------------------------------
1393
1394--
1395-- Table structure for table `nl1_users_session`
1396--
1397
1398CREATE TABLE IF NOT EXISTS `nl1_users_session` (
1399 `id` int(11) NOT NULL AUTO_INCREMENT,
1400 `user_id` int(11) NOT NULL,
1401 `hash` varchar(64) NOT NULL,
1402 PRIMARY KEY (`id`)
1403) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
1404
1405--
1406-- Dumping data for table `nl1_users_session`
1407--
1408
1409INSERT INTO `nl1_users_session` (`id`, `user_id`, `hash`) VALUES
1410(1, 4, '70b4b2bbae8c6ef05b7ef7fbd84d4a606561278b658fb7b5a664a691ed165daf'),
1411(2, 5, '179f5fb6cb9d5268cf4241f70dfb8dd5fceb3b1d846ad176ab28c4bcb1bed218'),
1412(5, 9, '0689fd1af64daa0466fb13798bc9522179ebd047ebb2a3377bd3672514f00c6d'),
1413(6, 14, 'a9bc1bb4ed00eacf4e588dee80e069526d66db0d2a5e5f284a313bbe1d41e1bf'),
1414(7, 15, 'ea2c984d4ec9a33868f44ae7fc8834c5fd917fdb7f709bc0893242d7eab177ed'),
1415(8, 17, '24addd7a8be19e1482211d3d0599e32b881c8ecc2a6d1e0fec996e7713e6b4f4'),
1416(9, 20, 'd3a70e7e124441e3ed66b18072e15a232325d063d9d589cc5e4ac99c45f44aeb'),
1417(11, 23, 'da1cf41d08d2942ee9c7a504dd33ab2b9e1358c0b47a292bd406b3a597f776f4'),
1418(13, 27, '0357fc977521c1737c6f07b746fa275490dbb9318d443af810613745228eada0');
1419
1420-- --------------------------------------------------------
1421
1422--
1423-- Table structure for table `nl1_user_profile_wall_posts`
1424--
1425
1426CREATE TABLE IF NOT EXISTS `nl1_user_profile_wall_posts` (
1427 `id` int(11) NOT NULL AUTO_INCREMENT,
1428 `user_id` int(11) NOT NULL,
1429 `author_id` int(11) NOT NULL,
1430 `time` int(11) NOT NULL,
1431 `content` mediumtext NOT NULL,
1432 PRIMARY KEY (`id`)
1433) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
1434
1435--
1436-- Dumping data for table `nl1_user_profile_wall_posts`
1437--
1438
1439INSERT INTO `nl1_user_profile_wall_posts` (`id`, `user_id`, `author_id`, `time`, `content`) VALUES
1440(4, 1, 1, 1461879581, 'Awesome forum update, courtesy of Samerton!'),
1441(5, 18, 18, 1469406448, 'if mcverge have CTW , mcverge are the best xdddd'),
1442(7, 27, 27, 1471295809, 'Yolo :) hope you just enjoy the server and have fun!');
1443
1444-- --------------------------------------------------------
1445
1446--
1447-- Table structure for table `nl1_user_profile_wall_posts_likes`
1448--
1449
1450CREATE TABLE IF NOT EXISTS `nl1_user_profile_wall_posts_likes` (
1451 `id` int(11) NOT NULL AUTO_INCREMENT,
1452 `post_id` int(11) NOT NULL,
1453 `user_id` int(11) NOT NULL,
1454 PRIMARY KEY (`id`)
1455) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
1456
1457-- --------------------------------------------------------
1458
1459--
1460-- Table structure for table `nl1_user_profile_wall_posts_replies`
1461--
1462
1463CREATE TABLE IF NOT EXISTS `nl1_user_profile_wall_posts_replies` (
1464 `id` int(11) NOT NULL AUTO_INCREMENT,
1465 `post_id` int(11) NOT NULL,
1466 `author_id` int(11) NOT NULL,
1467 `time` int(11) NOT NULL,
1468 `content` mediumtext NOT NULL,
1469 PRIMARY KEY (`id`)
1470) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1471
1472-- --------------------------------------------------------
1473
1474--
1475-- Table structure for table `nl1_uuid_cache`
1476--
1477
1478CREATE TABLE IF NOT EXISTS `nl1_uuid_cache` (
1479 `id` int(11) NOT NULL AUTO_INCREMENT,
1480 `mcname` varchar(20) NOT NULL,
1481 `uuid` varchar(64) NOT NULL,
1482 PRIMARY KEY (`id`)
1483) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
1484
1485--
1486-- Dumping data for table `nl1_uuid_cache`
1487--
1488
1489INSERT INTO `nl1_uuid_cache` (`id`, `mcname`, `uuid`) VALUES
1490(1, 'lol', '8c3efcffd60046e1a339379b7858a9be'),
1491(2, 'enderchicken101', 'c0bea551c99b4d38903c0096018e901e'),
1492(3, 'samerton', '2f778755502c4fb7ae96493d6429e8f3'),
1493(4, 'GhostPvp__', '0abc0ea7d3514ec2963f8e1b09eb0bc7'),
1494(5, '_Axiom_', '39a9542c626e432c8913dd564645ce77'),
1495(6, '100GB', '38107842bf8045d79beacf79f2a6dfee'),
1496(7, 'CaptainYoshi8815', 'ab9217f0ddc14546bb9f580701fb4815'),
1497(8, 'Falkoneye', 'a3339524746e44369a1ef81a6a4619e6'),
1498(9, 'Aldermite', '4b3479074b454a4bb07587259780f5bf'),
1499(10, 'DuskZeDragon', '1550b8619d22419483c8c5246ffff21d'),
1500(11, 'Spartanblaze', 'cce801d84e904923b6ea969952a4dccc'),
1501(12, 'MC_Major_Ed', '2de0fea455c947d2b35b9bb85f545225'),
1502(13, 'MrWisdoman', '1438bbdb475444e4b20a08721d84333f'),
1503(14, 'Luke199', '654c9bb9d2c64d1eb73c08a5d4b31de2'),
1504(15, 'md_5', 'af74a02d19cb445bb07f6866a861f783'),
1505(16, 'msnbc', 'da42fb4a90a74acaba3e07be521347e4'),
1506(17, 'Game_Killer450', '84edd6ec2fd34fd59a5c2053c330a0a9'),
1507(18, 'notch', '069a79f444e94726a5befca90e38aaf5'),
1508(19, 'pi2', 'b0430cd622dd48d3b55595e7cf670551'),
1509(20, 'adobes', 'cc0f31285cd843ca9c7a7d25d62e25bb'),
1510(21, 'mousetortoise', '3774c74cdc5c4e42937efe71123ef099'),
1511(22, 'e_is_cool', '540599f65df64a04852b1cbc78ac7175'),
1512(23, 'claushbang', 'd5776851a169404fbff547bd09014e87'),
1513(24, 'MoneyLord', 'fd99474c1a6641c38e260e3624c5c408'),
1514(25, 'Taqo', 'cecccc864db246088a030fc6b0efc368'),
1515(26, 'clublife', 'fd85de438855466898f49e081c7fecd1'),
1516(27, '2000thehecf1', '408267c4c74943128e288a29113c1329'),
1517(28, 'GreenLettuceMan', '3774c74cdc5c4e42937efe71123ef099'),
1518(29, '', ''),
1519(30, '', ''),
1520(31, '', ''),
1521(32, '', ''),
1522(33, '', ''),
1523(34, '', ''),
1524(35, '', ''),
1525(36, '', ''),
1526(37, 'ButterBros721', '175fe8eb96254ad2bd22c2b8e2bb0555'),
1527(38, '', ''),
1528(39, '', ''),
1529(40, '', ''),
1530(41, '', ''),
1531(42, '', ''),
1532(43, 'Rober_', '9a44eb408e704aaca7c0d046e76841b5'),
1533(44, 'Speedy17_', 'a8cbef458d7e4961bf839cb825999079'),
1534(45, 'Scooney', '3327eb1e934145529b85f7e500dccd79'),
1535(46, 'Rlygudprayer', '6aa21cffe396422fbd62ea00195ca44c'),
1536(47, 'parapenguin', '44df6b20168f4389b7ac434518207c2f'),
1537(48, 'users', 'ea04954d63d245f3a152fd5118ef9c1f'),
1538(49, 'kadirgarib', '4b3479074b454a4bb07587259780f5bf'),
1539(50, 'AlvinZhao', '3774c74cdc5c4e42937efe71123ef099'),
1540(51, 'olliegamerz', '08724344a5af428399fa5a7bfb39b137');
1541
1542/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1543/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1544/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;