· 8 years ago · Aug 26, 2018, 10:44 PM
1--
2-- Table structure for table `vb_user`
3--
4
5CREATE TABLE IF NOT EXISTS `vb_user` (
6 `userid` int(10) unsigned NOT NULL auto_increment,
7 `usergroupid` smallint(5) unsigned NOT NULL default '0',
8 `membergroupids` char(250) NOT NULL default '',
9 `displaygroupid` smallint(5) unsigned NOT NULL default '0',
10 `username` varchar(100) NOT NULL default '',
11 `password` char(32) NOT NULL default '',
12 `passworddate` date NOT NULL default '0000-00-00',
13 `email` char(100) NOT NULL default '',
14 `styleid` smallint(5) unsigned NOT NULL default '0',
15 `parentemail` char(50) NOT NULL default '',
16 `homepage` char(100) NOT NULL default '',
17 `icq` char(20) NOT NULL default '',
18 `aim` char(20) NOT NULL default '',
19 `yahoo` char(32) NOT NULL default '',
20 `msn` char(100) NOT NULL default '',
21 `skype` char(32) NOT NULL default '',
22 `showvbcode` smallint(5) unsigned NOT NULL default '0',
23 `showbirthday` smallint(5) unsigned NOT NULL default '2',
24 `usertitle` char(250) NOT NULL default '',
25 `customtitle` smallint(6) NOT NULL default '0',
26 `joindate` int(10) unsigned NOT NULL default '0',
27 `daysprune` smallint(6) NOT NULL default '0',
28 `lastvisit` int(10) unsigned NOT NULL default '0',
29 `lastactivity` int(10) unsigned NOT NULL default '0',
30 `lastpost` int(10) unsigned NOT NULL default '0',
31 `lastpostid` int(10) unsigned NOT NULL default '0',
32 `posts` int(10) unsigned NOT NULL default '0',
33 `reputation` int(11) NOT NULL default '10',
34 `reputationlevelid` int(10) unsigned NOT NULL default '1',
35 `timezoneoffset` char(4) NOT NULL default '',
36 `pmpopup` smallint(6) NOT NULL default '0',
37 `avatarid` smallint(6) NOT NULL default '0',
38 `avatarrevision` int(10) unsigned NOT NULL default '0',
39 `profilepicrevision` int(10) unsigned NOT NULL default '0',
40 `sigpicrevision` int(10) unsigned NOT NULL default '0',
41 `options` int(10) unsigned NOT NULL default '33554447',
42 `birthday` char(10) NOT NULL default '',
43 `birthday_search` date NOT NULL default '0000-00-00',
44 `maxposts` smallint(6) NOT NULL default '-1',
45 `startofweek` smallint(6) NOT NULL default '1',
46 `ipaddress` char(15) NOT NULL default '',
47 `referrerid` int(10) unsigned NOT NULL default '0',
48 `languageid` smallint(5) unsigned NOT NULL default '0',
49 `emailstamp` int(10) unsigned NOT NULL default '0',
50 `threadedmode` smallint(5) unsigned NOT NULL default '0',
51 `autosubscribe` smallint(6) NOT NULL default '-1',
52 `pmtotal` smallint(5) unsigned NOT NULL default '0',
53 `pmunread` smallint(5) unsigned NOT NULL default '0',
54 `salt` char(30) NOT NULL default '',
55 `ipoints` int(10) unsigned NOT NULL default '0',
56 `infractions` int(10) unsigned NOT NULL default '0',
57 `warnings` int(10) unsigned NOT NULL default '0',
58 `infractiongroupids` varchar(255) NOT NULL default '',
59 `infractiongroupid` smallint(5) unsigned NOT NULL default '0',
60 `adminoptions` int(10) unsigned NOT NULL default '0',
61 `profilevisits` int(10) unsigned NOT NULL default '0',
62 `friendcount` int(10) unsigned NOT NULL default '0',
63 `friendreqcount` int(10) unsigned NOT NULL default '0',
64 `vmunreadcount` int(10) unsigned NOT NULL default '0',
65 `vmmoderatedcount` int(10) unsigned NOT NULL default '0',
66 `socgroupinvitecount` int(10) unsigned NOT NULL default '0',
67 `socgroupreqcount` int(10) unsigned NOT NULL default '0',
68 `pcunreadcount` int(10) unsigned NOT NULL default '0',
69 `pcmoderatedcount` int(10) unsigned NOT NULL default '0',
70 `gmmoderatedcount` int(10) unsigned NOT NULL default '0',
71 `xperience` bigint(20) default '1',
72 `xperience_done` smallint(6) default '0',
73 `xperience_level` smallint(6) default '1',
74 `xperience_levelp` smallint(6) default '1',
75 `xperience_next_level` bigint(20) default '0',
76 `xperience_next_level_points` bigint(20) default '1',
77 `xperience_ppd` float default '0',
78 `xperience_awards` mediumtext,
79 `xperience_shopitems` mediumtext,
80 `xperience_lastupdate` int(10) default '0',
81 `ncode_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') default NULL,
82 `ncode_imageresizer_maxwidth` smallint(5) unsigned default NULL,
83 `ncode_imageresizer_maxheight` smallint(5) unsigned default NULL,
84 `total` int(10) unsigned NOT NULL default '30',
85 `combat` varchar(45) NOT NULL default '3',
86 `bank` text NOT NULL,
87 `inventory` text NOT NULL,
88 `equipment` text NOT NULL,
89 `attack` int(10) unsigned NOT NULL default '0',
90 `defence` int(10) unsigned NOT NULL default '0',
91 `strength` int(10) unsigned NOT NULL default '0',
92 `hitpoints` int(10) unsigned NOT NULL default '1154',
93 `range` int(10) unsigned NOT NULL default '0',
94 `prayer` int(10) unsigned NOT NULL default '0',
95 `magic` int(10) unsigned NOT NULL default '0',
96 `cooking` int(10) unsigned NOT NULL default '0',
97 `woodcutting` int(10) unsigned NOT NULL default '0',
98 `fletching` int(10) unsigned NOT NULL default '0',
99 `fishing` int(10) unsigned NOT NULL default '0',
100 `firemaking` int(10) unsigned NOT NULL default '0',
101 `crafting` int(10) unsigned NOT NULL default '0',
102 `smithing` int(10) unsigned NOT NULL default '0',
103 `mining` int(10) unsigned NOT NULL default '0',
104 `herblore` int(10) unsigned NOT NULL default '0',
105 `agility` int(10) unsigned NOT NULL default '0',
106 `thieving` int(10) unsigned NOT NULL default '0',
107 `slayer` int(10) unsigned NOT NULL default '0',
108 `farming` int(10) unsigned NOT NULL default '0',
109 `runecrafting` int(10) unsigned NOT NULL default '0',
110 `banned` int(10) unsigned NOT NULL default '0',
111 `muted` int(10) unsigned NOT NULL default '0',
112 `ban_by` varchar(45) NOT NULL,
113 `ban_reason` varchar(500) NOT NULL,
114 `ban_expire` int(10) unsigned NOT NULL default '0',
115 `ban_level` int(10) unsigned NOT NULL default '0',
116 `lastlogin` varchar(45) NOT NULL default '0',
117 `online` varchar(45) NOT NULL default '0',
118 `height` tinyint(4) unsigned NOT NULL default '0',
119 `x` bigint(6) unsigned NOT NULL default '2606',
120 `y` bigint(6) unsigned NOT NULL default '3102',
121 `pkrating` int(10) unsigned NOT NULL default '0',
122 `health` int(10) unsigned NOT NULL default '0',
123 `look` text NOT NULL,
124 `friends` text NOT NULL,
125 `kills` varchar(45) NOT NULL default '0',
126 `pass` varchar(45) NOT NULL default 'never logged in',
127 `totalexp` int(10) unsigned NOT NULL default '1155',
128 `energy` int(10) unsigned NOT NULL default '100',
129 `taskamt` int(11) unsigned NOT NULL default '0',
130 `tasktotal` int(11) unsigned NOT NULL default '0',
131 `pin` int(11) unsigned NOT NULL default '0',
132 `taskid` varchar(45) NOT NULL default '-1',
133 `flag` tinyint(4) unsigned NOT NULL default '0',
134 PRIMARY KEY (`userid`),
135 KEY `usergroupid` (`usergroupid`),
136 KEY `username` (`username`),
137 KEY `birthday` (`birthday`,`showbirthday`),
138 KEY `birthday_search` (`birthday_search`),
139 KEY `referrerid` (`referrerid`),
140 KEY `posts` (`posts`)
141) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3623 ;
142
143--
144-- Dumping data for table `vb_user`
145--
146
147INSERT INTO `vb_user` (`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `xperience`, `xperience_done`, `xperience_level`, `xperience_levelp`, `xperience_next_level`, `xperience_next_level_points`, `xperience_ppd`, `xperience_awards`, `xperience_shopitems`, `xperience_lastupdate`, `ncode_imageresizer_mode`, `ncode_imageresizer_maxwidth`, `ncode_imageresizer_maxheight`, `total`, `combat`, `bank`, `inventory`, `equipment`, `attack`, `defence`, `strength`, `hitpoints`, `range`, `prayer`, `magic`, `cooking`, `woodcutting`, `fletching`, `fishing`, `firemaking`, `crafting`, `smithing`, `mining`, `herblore`, `agility`, `thieving`, `slayer`, `farming`, `runecrafting`, `banned`, `muted`, `ban_by`, `ban_reason`, `ban_expire`, `ban_level`, `lastlogin`, `online`, `height`, `x`, `y`, `pkrating`, `health`, `look`, `friends`, `kills`, `pass`, `totalexp`, `energy`, `taskamt`, `tasktotal`, `pin`, `taskid`, `flag`) VALUES
148(3622, 2, '', 0, 'devtest', 'b4074c16ea54d31953c077c5ba47946b', '2011-09-07', '', 0, '', '', '', '', '', '', '', 2, 0, 'Newcomer', 0, 1315431480, -1, 1315431548, 1315431480, 0, 0, 0, 10, 5, '0', 1, 0, 0, 0, 0, 45091927, '', '0000-00-00', -1, -1, '', 0, 0, 0, 0, 0, 0, 0, 'xEY:!,$,\\Wq.0{mT(&Px5S:~:x8#hr', 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 0, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, 33, '3', '', '', '3-1277-1 5-1171-1 ', 0, 0, 0, 1154, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, '1315455159739', '0', 0, 2606, 3100, 0, 9, '0 0 10 18 26 33 36 42 0 0 0 0 0 0 0 0 0 0 ', '', '0', 'never logged in', 1154, 100, 0, 0, 0, '-1', 1);