· 5 years ago · Nov 05, 2020, 11:28 PM
1CREATE TABLE IF NOT EXISTS `968173290_users` (
2 `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `username` varchar(120) NOT NULL DEFAULT '',
4 `password` varchar(120) NOT NULL DEFAULT '',
5 `salt` varchar(10) NOT NULL DEFAULT '',
6 `loginkey` varchar(50) NOT NULL DEFAULT '',
7 `email` varchar(220) NOT NULL DEFAULT '',
8 `postnum` int(10) NOT NULL DEFAULT '0',
9 `awards` int(10) NOT NULL DEFAULT '0',
10 `avatar` varchar(200) NOT NULL DEFAULT '',
11 `avatardimensions` varchar(10) NOT NULL DEFAULT '',
12 `avatartype` varchar(10) NOT NULL DEFAULT '0',
13 `usergroup` smallint(5) unsigned NOT NULL DEFAULT '0',
14 `additionalgroups` varchar(200) NOT NULL DEFAULT '',
15 `displaygroup` smallint(5) unsigned NOT NULL DEFAULT '0',
16 `usertitle` varchar(250) NOT NULL DEFAULT '',
17 `regdate` bigint(30) NOT NULL DEFAULT '0',
18 `lastactive` bigint(30) NOT NULL DEFAULT '0',
19 `lastvisit` bigint(30) NOT NULL DEFAULT '0',
20 `lastpost` bigint(30) NOT NULL DEFAULT '0',
21 `website` varchar(200) NOT NULL DEFAULT '',
22 `icq` varchar(10) NOT NULL DEFAULT '',
23 `aim` varchar(50) NOT NULL DEFAULT '',
24 `yahoo` varchar(50) NOT NULL DEFAULT '',
25 `msn` varchar(75) NOT NULL DEFAULT '',
26 `birthday` varchar(15) NOT NULL DEFAULT '',
27 `birthdayprivacy` varchar(4) NOT NULL DEFAULT 'all',
28 `signature` text NOT NULL,
29 `allownotices` int(1) NOT NULL DEFAULT '0',
30 `hideemail` int(1) NOT NULL DEFAULT '0',
31 `subscriptionmethod` int(1) NOT NULL DEFAULT '0',
32 `invisible` int(1) NOT NULL DEFAULT '0',
33 `receivepms` int(1) NOT NULL DEFAULT '0',
34 `receivefrombuddy` int(1) NOT NULL DEFAULT '0',
35 `pmnotice` int(1) NOT NULL DEFAULT '0',
36 `pmnotify` int(1) NOT NULL DEFAULT '0',
37 `threadmode` varchar(8) NOT NULL DEFAULT '',
38 `showsigs` int(1) NOT NULL DEFAULT '0',
39 `showavatars` int(1) NOT NULL DEFAULT '0',
40 `showquickreply` int(1) NOT NULL DEFAULT '0',
41 `showredirect` int(1) NOT NULL DEFAULT '0',
42 `ppp` smallint(6) NOT NULL DEFAULT '0',
43 `tpp` smallint(6) NOT NULL DEFAULT '0',
44 `daysprune` smallint(6) NOT NULL DEFAULT '0',
45 `dateformat` varchar(4) NOT NULL DEFAULT '',
46 `timeformat` varchar(4) NOT NULL DEFAULT '',
47 `timezone` varchar(4) NOT NULL DEFAULT '',
48 `dst` int(1) NOT NULL DEFAULT '0',
49 `dstcorrection` int(1) NOT NULL DEFAULT '0',
50 `buddylist` text NOT NULL,
51 `ignorelist` text NOT NULL,
52 `style` smallint(5) unsigned NOT NULL DEFAULT '0',
53 `away` int(1) NOT NULL DEFAULT '0',
54 `awaydate` int(10) unsigned NOT NULL DEFAULT '0',
55 `returndate` varchar(15) NOT NULL DEFAULT '',
56 `awayreason` varchar(200) NOT NULL DEFAULT '',
57 `pmfolders` text NOT NULL,
58 `notepad` text NOT NULL,
59 `referrer` int(10) unsigned NOT NULL DEFAULT '0',
60 `referrals` int(10) unsigned NOT NULL DEFAULT '0',
61 `reputation` bigint(30) NOT NULL DEFAULT '0',
62 `regip` varchar(50) NOT NULL DEFAULT '',
63 `lastip` varchar(50) NOT NULL DEFAULT '',
64 `longregip` int(11) NOT NULL DEFAULT '0',
65 `longlastip` int(11) NOT NULL DEFAULT '0',
66 `language` varchar(50) NOT NULL DEFAULT '',
67 `timeonline` bigint(30) NOT NULL DEFAULT '0',
68 `showcodebuttons` int(1) NOT NULL DEFAULT '1',
69 `totalpms` int(10) NOT NULL DEFAULT '0',
70 `unreadpms` int(10) NOT NULL DEFAULT '0',
71 `warningpoints` int(3) NOT NULL DEFAULT '0',
72 `moderateposts` int(1) NOT NULL DEFAULT '0',
73 `moderationtime` bigint(30) NOT NULL DEFAULT '0',
74 `suspendposting` int(1) NOT NULL DEFAULT '0',
75 `suspensiontime` bigint(30) NOT NULL DEFAULT '0',
76 `suspendsignature` int(1) NOT NULL DEFAULT '0',
77 `suspendsigtime` bigint(30) NOT NULL DEFAULT '0',
78 `coppauser` int(1) NOT NULL DEFAULT '0',
79 `classicpostbit` int(1) NOT NULL DEFAULT '0',
80 `loginattempts` tinyint(2) NOT NULL DEFAULT '1',
81 `failedlogin` bigint(30) NOT NULL DEFAULT '0',
82 `usernotes` text NOT NULL,
83 `default_tab` text NOT NULL,
84 `passwordconvert` text,
85 `passwordconverttype` text,
86 `passwordconvertsalt` text,
87 `myncnotify` int(1) NOT NULL DEFAULT '0',
88 `myncnotice` int(1) NOT NULL DEFAULT '0',
89 `myncprivacy` int(1) NOT NULL DEFAULT '0',
90 `newpoints` decimal(16,2) NOT NULL DEFAULT '0.00',
91 `newpoints_items` text NOT NULL,
92 `newcomments` int(10) NOT NULL DEFAULT '0',
93 `commentnotify` int(10) NOT NULL DEFAULT '0',
94 `commentsfilter` int(10) NOT NULL DEFAULT '0',
95 PRIMARY KEY (`uid`),
96 UNIQUE KEY `username` (`username`),
97 KEY `usergroup` (`usergroup`),
98 KEY `birthday` (`birthday`),
99 KEY `longregip` (`longregip`),
100 KEY `longlastip` (`longlastip`)
101) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35428 ;
102
103--
104-- Dumping data for table `968173290_users`
105--
106
107INSERT INTO `968173290_users` (`uid`, `username`, `password`, `salt`, `loginkey`, `email`, `postnum`, `awards`, `avatar`, `avatardimensions`, `avatartype`, `usergroup`, `additionalgroups`, `displaygroup`, `usertitle`, `regdate`, `lastactive`, `lastvisit`, `lastpost`, `website`, `icq`, `aim`, `yahoo`, `msn`, `birthday`, `birthdayprivacy`, `signature`, `allownotices`, `hideemail`, `subscriptionmethod`, `invisible`, `receivepms`, `receivefrombuddy`, `pmnotice`, `pmnotify`, `threadmode`, `showsigs`, `showavatars`, `showquickreply`, `showredirect`, `ppp`, `tpp`, `daysprune`, `dateformat`, `timeformat`, `timezone`, `dst`, `dstcorrection`, `buddylist`, `ignorelist`, `style`, `away`, `awaydate`, `returndate`, `awayreason`, `pmfolders`, `notepad`, `referrer`, `referrals`, `reputation`, `regip`, `lastip`, `longregip`, `longlastip`, `language`, `timeonline`, `showcodebuttons`, `totalpms`, `unreadpms`, `warningpoints`, `moderateposts`, `moderationtime`, `suspendposting`, `suspensiontime`, `suspendsignature`, `suspendsigtime`, `coppauser`, `classicpostbit`, `loginattempts`, `failedlogin`, `usernotes`, `default_tab`, `passwordconvert`, `passwordconverttype`, `passwordconvertsalt`, `myncnotify`, `myncnotice`, `myncprivacy`, `newpoints`, `newpoints_items`, `newcomments`, `commentnotify`, `commentsfilter`) VALUES
108(1, 'ANONYMOUS', '0c154dfbd3476f2f061ee8d149eaada7', 'xhrTxK1A', 'EWBJFKLELd8cSpPK14aqhoOXVAu9n1xxyDFVIVsBtwUGpFhHl9', 'trololol@vdgdfdf.net', 5121, 3, './uploads/avatars/avatar_1.png?dateline=1411412375', '100|100', 'upload', 248, '', 248, 'I don''t give a fuck. I''m free.', 1341701136, 1417999798, 1417999798, 1417993177, '', '0', '', '', '', '', 'none', '[align=center]\n\n[IMG]http://i.imgur.com/jLAHyKC.gif[/IMG]\n[/align]\n', 1, 1, 0, 1, 1, 0, 2, 1, 'linear', 1, 1, 1, 1, 0, 0, 0, '0', '0', '-4', 1, 2, '2717,1265,239,13555,4481,2376,4933,12650,19900', '', 63, 0, 0, '0', '', '1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can', 'http://i.imgur.com/2nnLthX.png\n\nhttp://prntscr.com/3ntvyx', 0, 103, 254, '24.201.122.121', '65.93.124.47', 415857273, 1096645679, '', -8595411092, 1, 27270, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, '', '', '', '', '', 0, 0, 0, '191437.00', 'a:1:{i:0;s:1:"1";}', 0, 0, 0),