October 19, 2022 at 6:02 AM
pcper.com
Gamecampus.com
vkmonline.com
neo24.pl
Akibatan.com
chronicle.com
globalreach.eu.com
pcper.com (118k)
Gamecampus.com (400k)
forums.vkmonline.com (800k)
neo24.pl (780k)
Akibatan.com (800k)
chronicle.com (3.4ml)
globalreach.eu.com (900k)
Gamecampus.com
vkmonline.com
neo24.pl
Akibatan.com
chronicle.com
globalreach.eu.com
pcper.com (118k)
sampleSpoiler
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentemail` varchar(50) NOT NULL DEFAULT '',
`homepage` varchar(100) NOT NULL DEFAULT '',
`icq` varchar(20) NOT NULL DEFAULT '',
`aim` varchar(20) NOT NULL DEFAULT '',
`yahoo` varchar(32) NOT NULL DEFAULT '',
`usertitle` varchar(250) NOT NULL DEFAULT '',
`customtitle` smallint(6) NOT NULL DEFAULT '0',
`joindate` int(10) unsigned NOT NULL DEFAULT '0',
`daysprune` smallint(6) NOT NULL DEFAULT '0',
`lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`posts` int(10) unsigned NOT NULL DEFAULT '0',
`timezoneoffset` varchar(4) NOT NULL DEFAULT '',
`avatarid` smallint(6) NOT NULL DEFAULT '0',
`options` int(10) unsigned NOT NULL DEFAULT '33570831',
`birthday` varchar(10) NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT '-1',
`startofweek` smallint(6) NOT NULL DEFAULT '1',
`ipaddress` varchar(15) NOT NULL DEFAULT '',
`referrerid` int(10) unsigned NOT NULL DEFAULT '0',
`pmpopup` smallint(6) NOT NULL DEFAULT '0',
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`salt` char(30) NOT NULL DEFAULT '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
`msn` varchar(100) NOT NULL DEFAULT '',
`avatarrevision` int(10) unsigned NOT NULL DEFAULT '0',
`membergroupids` varchar(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1',
`languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
`threadedmode` smallint(5) unsigned NOT NULL DEFAULT '0',
`emailstamp` int(10) unsigned NOT NULL DEFAULT '0',
`autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
`birthday_search` date NOT NULL DEFAULT '0000-00-00',
`profilepicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
`skype` varchar(32) NOT NULL DEFAULT '',
`adminoptions` int(10) unsigned NOT NULL DEFAULT '0',
`lastpostid` int(10) unsigned NOT NULL DEFAULT '0',
`sigpicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`ipoints` int(10) unsigned NOT NULL DEFAULT '0',
`infractions` int(10) unsigned NOT NULL DEFAULT '0',
`warnings` int(10) unsigned NOT NULL DEFAULT '0',
`infractiongroupids` varchar(255) NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`genpermoverride` int(10) unsigned NOT NULL DEFAULT '536870911',
`adminignore` varchar(250) NOT NULL DEFAULT '',
`itrader_total` smallint(5) NOT NULL DEFAULT '0',
`itrader_pcnt` tinyint(3) NOT NULL DEFAULT '0',
`itrader_buy` varchar(100) NOT NULL DEFAULT 'nothing at the moment',
`itrader_sell` varchar(100) NOT NULL DEFAULT 'nothing at the moment',
`profilevisits` int(10) unsigned NOT NULL DEFAULT '0',
`friendcount` int(10) unsigned NOT NULL DEFAULT '0',
`friendreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupinvitecount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`gmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`assetposthash` varchar(32) NOT NULL DEFAULT '',
`fbuserid` varchar(255) NOT NULL,
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) NOT NULL,
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`fbaccesstoken` varchar(255) NOT NULL,
`newrepcount` smallint(5) unsigned NOT NULL DEFAULT '0',
`bloggroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`showblogcss` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`userid`),
KEY `username` (`username`),
KEY `usergroupid` (`usergroupid`),
KEY `birthday_search` (`birthday_search`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `lastactivity` (`lastactivity`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=128349 DEFAULT CHARSET=latin1;
INSERT INTO `user` VALUES ('9150', '2', 'JRH', '8fc0d8e5d685a0bf7ccb8c665cdab354', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968212800', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', '$a6', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9151', '2', 'mr_oh_so_ice', '894c2e6ec1fdea60e9ab22179ea0b59a', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968212800', '0', '1109612368', '1110501995', '1011825180', '23', '-5', '0', '45108567', '', '-1', '1', '154.5.109.205', '0', '0', '0', '0', '0000-00-00', '*cX', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9152', '2', 'Atom7', '257845d7169201ab61181a4ecf059d5f', '[email protected]', '0', '', 'http://atom7.cjb.net', '', '', '', 'Registered User', '0', '968212800', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', '27L', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9153', '2', 'johnyjunkhead', '248abaa46b064887fd2f4e0ae6987848', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', '#=z', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9154', '2', 'CodeWzrd', '4dab7b85ac8bd36b68dec5a902ce4ea0', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '1121689324', '1125514062', '1121275674', '7', '-5', '0', '45108823', '', '-1', '1', '', '0', '0', '0', '0', '2004-11-19', '$T=', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9155', '2', 'drake', 'd18518bd1b951f9ce0e4e171b920c2fc', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108807', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', 'v|2', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9156', '2', 'JohnnyRotten', 'c807f98e3828f836ee82c0957876f52b', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', 'd$]', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9158', '2', 'Fuze', '524f32725f97b9f7cc2c448bb20ae006', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968385600', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108807', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', 'G1H', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentemail` varchar(50) NOT NULL DEFAULT '',
`homepage` varchar(100) NOT NULL DEFAULT '',
`icq` varchar(20) NOT NULL DEFAULT '',
`aim` varchar(20) NOT NULL DEFAULT '',
`yahoo` varchar(32) NOT NULL DEFAULT '',
`usertitle` varchar(250) NOT NULL DEFAULT '',
`customtitle` smallint(6) NOT NULL DEFAULT '0',
`joindate` int(10) unsigned NOT NULL DEFAULT '0',
`daysprune` smallint(6) NOT NULL DEFAULT '0',
`lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`lastpost` int(10) unsigned NOT NULL DEFAULT '0',
`posts` int(10) unsigned NOT NULL DEFAULT '0',
`timezoneoffset` varchar(4) NOT NULL DEFAULT '',
`avatarid` smallint(6) NOT NULL DEFAULT '0',
`options` int(10) unsigned NOT NULL DEFAULT '33570831',
`birthday` varchar(10) NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT '-1',
`startofweek` smallint(6) NOT NULL DEFAULT '1',
`ipaddress` varchar(15) NOT NULL DEFAULT '',
`referrerid` int(10) unsigned NOT NULL DEFAULT '0',
`pmpopup` smallint(6) NOT NULL DEFAULT '0',
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`salt` char(30) NOT NULL DEFAULT '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
`msn` varchar(100) NOT NULL DEFAULT '',
`avatarrevision` int(10) unsigned NOT NULL DEFAULT '0',
`membergroupids` varchar(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1',
`languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
`threadedmode` smallint(5) unsigned NOT NULL DEFAULT '0',
`emailstamp` int(10) unsigned NOT NULL DEFAULT '0',
`autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
`birthday_search` date NOT NULL DEFAULT '0000-00-00',
`profilepicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
`skype` varchar(32) NOT NULL DEFAULT '',
`adminoptions` int(10) unsigned NOT NULL DEFAULT '0',
`lastpostid` int(10) unsigned NOT NULL DEFAULT '0',
`sigpicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`ipoints` int(10) unsigned NOT NULL DEFAULT '0',
`infractions` int(10) unsigned NOT NULL DEFAULT '0',
`warnings` int(10) unsigned NOT NULL DEFAULT '0',
`infractiongroupids` varchar(255) NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`genpermoverride` int(10) unsigned NOT NULL DEFAULT '536870911',
`adminignore` varchar(250) NOT NULL DEFAULT '',
`itrader_total` smallint(5) NOT NULL DEFAULT '0',
`itrader_pcnt` tinyint(3) NOT NULL DEFAULT '0',
`itrader_buy` varchar(100) NOT NULL DEFAULT 'nothing at the moment',
`itrader_sell` varchar(100) NOT NULL DEFAULT 'nothing at the moment',
`profilevisits` int(10) unsigned NOT NULL DEFAULT '0',
`friendcount` int(10) unsigned NOT NULL DEFAULT '0',
`friendreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`vmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupinvitecount` int(10) unsigned NOT NULL DEFAULT '0',
`socgroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcunreadcount` int(10) unsigned NOT NULL DEFAULT '0',
`pcmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`gmmoderatedcount` int(10) unsigned NOT NULL DEFAULT '0',
`assetposthash` varchar(32) NOT NULL DEFAULT '',
`fbuserid` varchar(255) NOT NULL,
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) NOT NULL,
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`fbaccesstoken` varchar(255) NOT NULL,
`newrepcount` smallint(5) unsigned NOT NULL DEFAULT '0',
`bloggroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`showblogcss` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`userid`),
KEY `username` (`username`),
KEY `usergroupid` (`usergroupid`),
KEY `birthday_search` (`birthday_search`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `lastactivity` (`lastactivity`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=128349 DEFAULT CHARSET=latin1;
INSERT INTO `user` VALUES ('9150', '2', 'JRH', '8fc0d8e5d685a0bf7ccb8c665cdab354', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968212800', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', '$a6', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9151', '2', 'mr_oh_so_ice', '894c2e6ec1fdea60e9ab22179ea0b59a', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968212800', '0', '1109612368', '1110501995', '1011825180', '23', '-5', '0', '45108567', '', '-1', '1', '154.5.109.205', '0', '0', '0', '0', '0000-00-00', '*cX', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9152', '2', 'Atom7', '257845d7169201ab61181a4ecf059d5f', '[email protected]', '0', '', 'http://atom7.cjb.net', '', '', '', 'Registered User', '0', '968212800', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', '27L', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9153', '2', 'johnyjunkhead', '248abaa46b064887fd2f4e0ae6987848', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', '#=z', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9154', '2', 'CodeWzrd', '4dab7b85ac8bd36b68dec5a902ce4ea0', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '1121689324', '1125514062', '1121275674', '7', '-5', '0', '45108823', '', '-1', '1', '', '0', '0', '0', '0', '2004-11-19', '$T=', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9155', '2', 'drake', 'd18518bd1b951f9ce0e4e171b920c2fc', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108807', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', 'v|2', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9156', '2', 'JohnnyRotten', 'c807f98e3828f836ee82c0957876f52b', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968299200', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108567', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', 'd$]', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
INSERT INTO `user` VALUES ('9158', '2', 'Fuze', '524f32725f97b9f7cc2c448bb20ae006', '[email protected]', '0', '', 'http://', '', '', '', 'Registered User', '0', '968385600', '0', '978118996', '978118996', '0', '0', '-5', '0', '45108807', '', '-1', '1', '', '0', '0', '0', '0', '0000-00-00', 'G1H', '1', '', '0', '', '0', '10', '0', '0', '0', '0', '1', '0000-00-00', '0', '2', '', '0', '0', '0', '0', '0', '0', '', '0', '536870911', '', '0', '0', 'nothing at the moment', 'nothing at the moment', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', '0', '0', '1');
Gamecampus.com (400k)
sampleSpoiler
#
# phpBB Backup Script
# Dump of tables for forum_
# DATE : 02-01-2013 12:52:30 GMT
#
# Table: forum_users
DROP TABLE IF EXISTS forum_users;
CREATE TABLE `forum_users` (
`user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`user_type` tinyint(2) NOT NULL DEFAULT '0',
`group_id` mediumint(8) unsigned NOT NULL DEFAULT '3',
`user_permissions` mediumtext COLLATE utf8_bin NOT NULL,
`user_perm_from` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_regdate` int(11) unsigned NOT NULL DEFAULT '0',
`username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`username_clean` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_password` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_passchg` int(11) unsigned NOT NULL DEFAULT '0',
`user_pass_convert` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_email_hash` bigint(20) NOT NULL DEFAULT '0',
`user_birthday` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_lastvisit` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastmark` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastpost_time` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastpage` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_last_confirm_key` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_last_search` int(11) unsigned NOT NULL DEFAULT '0',
`user_warnings` tinyint(4) NOT NULL DEFAULT '0',
`user_last_warning` int(11) unsigned NOT NULL DEFAULT '0',
`user_login_attempts` tinyint(4) NOT NULL DEFAULT '0',
`user_inactive_reason` tinyint(2) NOT NULL DEFAULT '0',
`user_inactive_time` int(11) unsigned NOT NULL DEFAULT '0',
`user_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_lang` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_timezone` decimal(5,2) NOT NULL DEFAULT '0.00',
`user_dst` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_dateformat` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
`user_style` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_new_privmsg` int(4) NOT NULL DEFAULT '0',
`user_unread_privmsg` int(4) NOT NULL DEFAULT '0',
`user_last_privmsg` int(11) unsigned NOT NULL DEFAULT '0',
`user_message_rules` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_full_folder` int(11) NOT NULL DEFAULT '-3',
`user_emailtime` int(11) unsigned NOT NULL DEFAULT '0',
`user_topic_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_topic_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
`user_topic_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'd',
`user_post_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_post_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
`user_post_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'a',
`user_notify` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_notify_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_notify_type` tinyint(4) NOT NULL DEFAULT '0',
`user_allow_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_viewonline` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_viewemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_massemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_options` int(11) unsigned NOT NULL DEFAULT '895',
`user_avatar` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_avatar_type` tinyint(2) NOT NULL DEFAULT '0',
`user_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_sig` mediumtext COLLATE utf8_bin NOT NULL,
`user_sig_bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_sig_bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_from` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_icq` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_aim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_yim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_msnm` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_jabber` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_website` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_occ` text COLLATE utf8_bin NOT NULL,
`user_interests` text COLLATE utf8_bin NOT NULL,
`user_actkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_newpasswd` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_form_salt` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`user_id`),
KEY `user_birthday` (`user_birthday`),
KEY `user_email_hash` (`user_email_hash`),
KEY `user_type` (`user_type`),
KEY `username_clean` (`username_clean`),
KEY `user_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=407407 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
62, 0, 2, '', 0, '', 1193711973, 'Administrator', 'administrator', '$H$9assIHjO5qfQDvGs6giMsejeQbjM9z1', 0, 1, '[email protected]', 80866255525, ' 0- 0- 0', 1207007600, 1207007600, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2pbfl25m', '0', '', '', '', '', '', '', '', '', '', '', '', ''
65, 0, 2, '', 0, '', 1193876016, 'ForumAdmin', 'forumadmin', '$H$9hLkAJSwptaC5OvSokG7uqLFzprvIn/', 0, 1, '[email protected]', 146881125921, ' 0- 0- 0', 1207007865, 1207007865, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1edelefx', '0', '', '', '', '', '', '', '', '', '', '', '', ''
101, 0, 2, '', 0, '', 0, 'onnet', 'onnet', '$H$9BjOJ/vGc4WOh7M9drkcfbt.Fqni/0.', 0, 1, '[email protected]', 75943929019, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'oufcafrv', '0', '', '', '', '', '', '', '', '', '', '', '', ''
102, 0, 2, '', 0, '', 0, 'MangaFighterTeam', 'mangafighterteam', '$H$9aSC5PLOU5jiC3D86hTmXFceqTBycs1', 0, 1, '[email protected]', -25934459725, ' 0- 0- 0', 1253588064, 1207023385, 0, 'viewtopic.php?f=56&t=44023', '', 0, 0, 0, 3, 0, 0, 1, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 1, 1, 1255426762, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '33cjp76w', '0', '', '', '', '', '', '', '', '', '', '', '', '9bf82b15ecb383c2'
103, 0, 2, '', 0, '', 0, 'Raife', 'raife', '$H$9DYJf3XwVdjCsBoWoFBd/fCxV2bRsY.', 0, 1, '[email protected]', -161148208929, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'wmhsxpax', '0', '', '', '', '', '', '', '', '', '', '', '', ''
104, 0, 2, '', 0, '', 0, 'bulltooth', 'bulltooth', '$H$9AshJ.VGW6SBl56axO3WjSs4UuIyw0.', 0, 1, '[email protected]', 183749312419, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1698sblg', '0', '', '', '', '', '', '', '', '', '', '', '', ''
105, 0, 2, '', 0, '', 0, 'withcoffee', 'withcoffee', '$H$9SQoRm8jZIFYU4AOj9W2M.auxYuEMx.', 0, 1, '[email protected]', 179254283917, ' 0- 0- 0', 1304644376, 1206795406, 0, 'viewforum.php?f=56', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1mtnciph', '0', '', '', '', '', '', '', '', '', '', '', '', 'adc2b180eddfa906'
106, 0, 2, '', 0, '', 0, 'Alna', 'alna', '$H$9X26xBxfx3kWyD3PA1TVY/mOAjQdXr/', 0, 1, '[email protected]', 201475266219, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '38eub24b', '0', '', '', '', '', '', '', '', '', '', '', '', ''
107, 0, 2, '', 0, '', 0, 'SeniorFrog', 'seniorfrog', '$H$9a4J2iM1wzdA5biFXByZq4dUzBwsnx1', 0, 1, '[email protected]', 131932305118, ' 0- 0- 0', 1203802845, 1203802845, 0, '', '', 0, 0, 0, 0, 0, 0, 2, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'mvnysoqu', '0', '', '', '', '', '', '', '', '', '', '', '', ''
108, 0, 2, '', 0, '', 0, 'superadmin', 'superadmin', '$H$9J21F4fXFht0CdaZbPYGt9FunLP1k7.', 0, 1, '[email protected]', -99272490218, ' 0- 0- 0', 1261018336, 1205913318, 0, 'viewforum.php?f=196', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 1, 1, 1205913318, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '3myher2g', '0', '', '', '', '', '', '', '', '', '', '', '', 'aa43ac9d538d980c'
109, 0, 2, '', 0, '', 0, 'jolly73', 'jolly73', '$H$9P92WgCr0y9Fh2YuTrlgfDkGvjXQx40', 0, 1, '[email protected]', 174427585517, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2fwlgar7', '0', '', '', '', '', '', '', '', '', '', '', '', ''
110, 0, 2, '', 0, '', 0, 'jdubb888', 'jdubb888', '$H$9JU4tR2Zqfygh5NzzBMXRssyZu6PEU/', 0, 1, '[email protected]', 18913419420, ' 0- 0- 0', 1305203225, 1199055469, 1305203218, 'viewtopic.php?f=56&t=81316&p=609898', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'y6cjgzki', '0', '', '', '', '', '', '', '', '', '', '', '', 'cb9abd86e0a329e9'
111, 0, 2, '', 0, '', 0, 'Deedle', 'deedle', '$H$9nj2vwQsd1QssYNrpvA2/1G7FjkSh.0', 0, 1, '[email protected]', 97874171621, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1gas33qx', '0', '', '', '', '', '', '', '', '', '', '', '', ''
112, 0, 2, '', 0, '', 0, 'Swizz', 'swizz', '$H$9h5Poqw7.4OOOEhAoXFS2UH4DloxOl0', 0, 1, '[email protected]', -26203387924, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '3b2w62mw', '0', '', '', '', '', '', '', '', '', '', '', '', ''
113, 0, 2, '', 0, '', 0, 'Lexar4', 'lexar4', '$H$9AY1.kYppJuTUZWbOaPdP2GswEguCF/', 0, 1, '[email protected]', -39890557420, ' 0- 0- 0', 1309751017, 1206121797, 0, 'viewtopic.php?f=26&t=79295&hilit=theurgia', '', 1309750946, 0, 0, 0, 0, 0, 5, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2t0d6rp0', '0', '', '', '', '', '', '', '', '', '', '', '', 'b25d78b7500289dd'
114, 0, 2, '', 0, '', 0, 'SnoWhite', 'snowhite', '$H$9bpuC7vNCI7AcsTWK2K.0zc6QBQrHc.', 0, 1, '[email protected]', 55464704919, ' 0- 0- 0', 1336266826, 1206827880, 0, 'viewforum.php?f=182', '', 1335485868, 0, 0, 0, 0, 0, 6, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1v8wy6rg', '0', '', '', '', '', '', '', '', '', '', '', '', 'b091b7ebf10c2a3c'
115, 0, 2, '', 0, '', 0, 'bluedragon1', 'bluedragon1', '$H$9sSD.WJNPlOYgXOq8uig9qjfYrXlqr/', 0, 1, '[email protected]', -20303614019, ' 0- 0- 0', 1306676962, 0, 0, 'viewtopic.php?f=465&t=82323', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2x6247jh', '0', '', '', '', '', '', '', '', '', '', '', '', 'bc89da1381183027'
116, 0, 2, '', 0, '', 0, 'Tinman', 'tinman', '$H$9PNs9dMoHEa4J3yKmu891xYwocuuLx0', 0, 1, '[email protected]', 50494562028, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 2, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'upcx1dxy', '0', '', '', '', '', '', '', '', '', '', '', '', ''
# phpBB Backup Script
# Dump of tables for forum_
# DATE : 02-01-2013 12:52:30 GMT
#
# Table: forum_users
DROP TABLE IF EXISTS forum_users;
CREATE TABLE `forum_users` (
`user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`user_type` tinyint(2) NOT NULL DEFAULT '0',
`group_id` mediumint(8) unsigned NOT NULL DEFAULT '3',
`user_permissions` mediumtext COLLATE utf8_bin NOT NULL,
`user_perm_from` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_regdate` int(11) unsigned NOT NULL DEFAULT '0',
`username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`username_clean` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_password` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_passchg` int(11) unsigned NOT NULL DEFAULT '0',
`user_pass_convert` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_email_hash` bigint(20) NOT NULL DEFAULT '0',
`user_birthday` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_lastvisit` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastmark` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastpost_time` int(11) unsigned NOT NULL DEFAULT '0',
`user_lastpage` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_last_confirm_key` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_last_search` int(11) unsigned NOT NULL DEFAULT '0',
`user_warnings` tinyint(4) NOT NULL DEFAULT '0',
`user_last_warning` int(11) unsigned NOT NULL DEFAULT '0',
`user_login_attempts` tinyint(4) NOT NULL DEFAULT '0',
`user_inactive_reason` tinyint(2) NOT NULL DEFAULT '0',
`user_inactive_time` int(11) unsigned NOT NULL DEFAULT '0',
`user_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_lang` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_timezone` decimal(5,2) NOT NULL DEFAULT '0.00',
`user_dst` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_dateformat` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
`user_style` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
`user_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_new_privmsg` int(4) NOT NULL DEFAULT '0',
`user_unread_privmsg` int(4) NOT NULL DEFAULT '0',
`user_last_privmsg` int(11) unsigned NOT NULL DEFAULT '0',
`user_message_rules` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_full_folder` int(11) NOT NULL DEFAULT '-3',
`user_emailtime` int(11) unsigned NOT NULL DEFAULT '0',
`user_topic_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_topic_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
`user_topic_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'd',
`user_post_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_post_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
`user_post_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'a',
`user_notify` tinyint(1) unsigned NOT NULL DEFAULT '0',
`user_notify_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_notify_type` tinyint(4) NOT NULL DEFAULT '0',
`user_allow_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_viewonline` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_viewemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_allow_massemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
`user_options` int(11) unsigned NOT NULL DEFAULT '895',
`user_avatar` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_avatar_type` tinyint(2) NOT NULL DEFAULT '0',
`user_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
`user_sig` mediumtext COLLATE utf8_bin NOT NULL,
`user_sig_bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_sig_bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_from` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_icq` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_aim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_yim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_msnm` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_jabber` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_website` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_occ` text COLLATE utf8_bin NOT NULL,
`user_interests` text COLLATE utf8_bin NOT NULL,
`user_actkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_newpasswd` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`user_form_salt` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`user_id`),
KEY `user_birthday` (`user_birthday`),
KEY `user_email_hash` (`user_email_hash`),
KEY `user_type` (`user_type`),
KEY `username_clean` (`username_clean`),
KEY `user_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=407407 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
62, 0, 2, '', 0, '', 1193711973, 'Administrator', 'administrator', '$H$9assIHjO5qfQDvGs6giMsejeQbjM9z1', 0, 1, '[email protected]', 80866255525, ' 0- 0- 0', 1207007600, 1207007600, 0, '', '', 0, 0, 0, 1, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2pbfl25m', '0', '', '', '', '', '', '', '', '', '', '', '', ''
65, 0, 2, '', 0, '', 1193876016, 'ForumAdmin', 'forumadmin', '$H$9hLkAJSwptaC5OvSokG7uqLFzprvIn/', 0, 1, '[email protected]', 146881125921, ' 0- 0- 0', 1207007865, 1207007865, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1edelefx', '0', '', '', '', '', '', '', '', '', '', '', '', ''
101, 0, 2, '', 0, '', 0, 'onnet', 'onnet', '$H$9BjOJ/vGc4WOh7M9drkcfbt.Fqni/0.', 0, 1, '[email protected]', 75943929019, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'oufcafrv', '0', '', '', '', '', '', '', '', '', '', '', '', ''
102, 0, 2, '', 0, '', 0, 'MangaFighterTeam', 'mangafighterteam', '$H$9aSC5PLOU5jiC3D86hTmXFceqTBycs1', 0, 1, '[email protected]', -25934459725, ' 0- 0- 0', 1253588064, 1207023385, 0, 'viewtopic.php?f=56&t=44023', '', 0, 0, 0, 3, 0, 0, 1, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 1, 1, 1255426762, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '33cjp76w', '0', '', '', '', '', '', '', '', '', '', '', '', '9bf82b15ecb383c2'
103, 0, 2, '', 0, '', 0, 'Raife', 'raife', '$H$9DYJf3XwVdjCsBoWoFBd/fCxV2bRsY.', 0, 1, '[email protected]', -161148208929, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'wmhsxpax', '0', '', '', '', '', '', '', '', '', '', '', '', ''
104, 0, 2, '', 0, '', 0, 'bulltooth', 'bulltooth', '$H$9AshJ.VGW6SBl56axO3WjSs4UuIyw0.', 0, 1, '[email protected]', 183749312419, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1698sblg', '0', '', '', '', '', '', '', '', '', '', '', '', ''
105, 0, 2, '', 0, '', 0, 'withcoffee', 'withcoffee', '$H$9SQoRm8jZIFYU4AOj9W2M.auxYuEMx.', 0, 1, '[email protected]', 179254283917, ' 0- 0- 0', 1304644376, 1206795406, 0, 'viewforum.php?f=56', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1mtnciph', '0', '', '', '', '', '', '', '', '', '', '', '', 'adc2b180eddfa906'
106, 0, 2, '', 0, '', 0, 'Alna', 'alna', '$H$9X26xBxfx3kWyD3PA1TVY/mOAjQdXr/', 0, 1, '[email protected]', 201475266219, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '38eub24b', '0', '', '', '', '', '', '', '', '', '', '', '', ''
107, 0, 2, '', 0, '', 0, 'SeniorFrog', 'seniorfrog', '$H$9a4J2iM1wzdA5biFXByZq4dUzBwsnx1', 0, 1, '[email protected]', 131932305118, ' 0- 0- 0', 1203802845, 1203802845, 0, '', '', 0, 0, 0, 0, 0, 0, 2, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'mvnysoqu', '0', '', '', '', '', '', '', '', '', '', '', '', ''
108, 0, 2, '', 0, '', 0, 'superadmin', 'superadmin', '$H$9J21F4fXFht0CdaZbPYGt9FunLP1k7.', 0, 1, '[email protected]', -99272490218, ' 0- 0- 0', 1261018336, 1205913318, 0, 'viewforum.php?f=196', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 1, 1, 1205913318, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '3myher2g', '0', '', '', '', '', '', '', '', '', '', '', '', 'aa43ac9d538d980c'
109, 0, 2, '', 0, '', 0, 'jolly73', 'jolly73', '$H$9P92WgCr0y9Fh2YuTrlgfDkGvjXQx40', 0, 1, '[email protected]', 174427585517, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2fwlgar7', '0', '', '', '', '', '', '', '', '', '', '', '', ''
110, 0, 2, '', 0, '', 0, 'jdubb888', 'jdubb888', '$H$9JU4tR2Zqfygh5NzzBMXRssyZu6PEU/', 0, 1, '[email protected]', 18913419420, ' 0- 0- 0', 1305203225, 1199055469, 1305203218, 'viewtopic.php?f=56&t=81316&p=609898', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'y6cjgzki', '0', '', '', '', '', '', '', '', '', '', '', '', 'cb9abd86e0a329e9'
111, 0, 2, '', 0, '', 0, 'Deedle', 'deedle', '$H$9nj2vwQsd1QssYNrpvA2/1G7FjkSh.0', 0, 1, '[email protected]', 97874171621, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1gas33qx', '0', '', '', '', '', '', '', '', '', '', '', '', ''
112, 0, 2, '', 0, '', 0, 'Swizz', 'swizz', '$H$9h5Poqw7.4OOOEhAoXFS2UH4DloxOl0', 0, 1, '[email protected]', -26203387924, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '3b2w62mw', '0', '', '', '', '', '', '', '', '', '', '', '', ''
113, 0, 2, '', 0, '', 0, 'Lexar4', 'lexar4', '$H$9AY1.kYppJuTUZWbOaPdP2GswEguCF/', 0, 1, '[email protected]', -39890557420, ' 0- 0- 0', 1309751017, 1206121797, 0, 'viewtopic.php?f=26&t=79295&hilit=theurgia', '', 1309750946, 0, 0, 0, 0, 0, 5, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2t0d6rp0', '0', '', '', '', '', '', '', '', '', '', '', '', 'b25d78b7500289dd'
114, 0, 2, '', 0, '', 0, 'SnoWhite', 'snowhite', '$H$9bpuC7vNCI7AcsTWK2K.0zc6QBQrHc.', 0, 1, '[email protected]', 55464704919, ' 0- 0- 0', 1336266826, 1206827880, 0, 'viewforum.php?f=182', '', 1335485868, 0, 0, 0, 0, 0, 6, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '1v8wy6rg', '0', '', '', '', '', '', '', '', '', '', '', '', 'b091b7ebf10c2a3c'
115, 0, 2, '', 0, '', 0, 'bluedragon1', 'bluedragon1', '$H$9sSD.WJNPlOYgXOq8uig9qjfYrXlqr/', 0, 1, '[email protected]', -20303614019, ' 0- 0- 0', 1306676962, 0, 0, 'viewtopic.php?f=465&t=82323', '', 0, 0, 0, 0, 0, 0, 0, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', '2x6247jh', '0', '', '', '', '', '', '', '', '', '', '', '', 'bc89da1381183027'
116, 0, 2, '', 0, '', 0, 'Tinman', 'tinman', '$H$9PNs9dMoHEa4J3yKmu891xYwocuuLx0', 0, 1, '[email protected]', 50494562028, ' 0- 0- 0', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 2, 'en', '-8.00', 0, 'D M d, Y g:i a', 57, 0, '', 0, 0, 0, 0, -3, 0, 0, 't', 'd', 0, 't', 'a', 1, 0, 0, 1, 1, 0, 1, 831, '', 0, 0, 0, '', 'upcx1dxy', '0', '', '', '', '', '', '', '', '', '', '', '', ''
forums.vkmonline.com (800k)
sampleSpoiler
[email protected] гФСЭ ЗбгдКПм 06b52155cdf529cd1748e0d17e683896 dґ_ 24.14.133.89
[email protected] ЗбХЮС 0e3a9d44d6800d15248117407c239ec8 ~ 212.26.19.158
гСЗЮИ гдКПм бндЯУ 5a00270a83943fe81be4f30dc62dfd68 ¬i 24.14.133.91
[email protected] Montada System 099a21afa050b26ef1b13979b923f90c jQj
дЗЖИ гФСЭ ЗбгдКПм 2a54b3758a75d73fdde602731a4dc2b0 +{h=<KU'*#wOXJlv_P.}m+4CC|A4$+ 207.241.180.162
[email protected] forumaster 53c12224510cc8172cc2cd1c6aca42a2 9$[O`Ah(C9a/)VKJ?H]Y5fo.{t5_Q; 194.216.55.50
[email protected] org911 b5566e0c5f6717b395bed4b423fdec54 ^™ 212.26.19.153
[email protected] Bader f94fcc85df085b671ed754572f0f4e42 В?= 212.26.19.153
[email protected] talall_tu ecfab3d3afe608947299fa12b67de343 ѕеY 212.31.117.6
[email protected] ГИж СЗгЬЬЬЬЗ e0fd8073909f57a9b536f785ca53b401 ъ?= 212.26.19.156
[email protected] Nemesis 4f20224950f32eaefbf2ae2ab85f8f00 W+ї 212.72.7.194
[email protected] ИЬЗКЬСнжК 83df253f004eb0207d9f2eea950102c7 O«« 212.26.19.158
[email protected] The Rapier beb28c9379861bb16f7b743e22be117f я|A 212.26.19.156
[email protected] ahmed 7cb291749bf3247b4a07fca6c96df5eb <q\ 212.26.19.158
[email protected] saviour ab1045c3da02552d25dc263e8438bd29 Д І 212.26.19.153
[email protected] Ponadora a5d4ee9616b22b7fe45701a26ffa428e
[email protected] azar e04e96e5d264c81b2bc73b2fa2266ad4 ј9Ч 212.138.47.12
[email protected] ЗбХЮС 0e3a9d44d6800d15248117407c239ec8 ~ 212.26.19.158
гСЗЮИ гдКПм бндЯУ 5a00270a83943fe81be4f30dc62dfd68 ¬i 24.14.133.91
[email protected] Montada System 099a21afa050b26ef1b13979b923f90c jQj
дЗЖИ гФСЭ ЗбгдКПм 2a54b3758a75d73fdde602731a4dc2b0 +{h=<KU'*#wOXJlv_P.}m+4CC|A4$+ 207.241.180.162
[email protected] forumaster 53c12224510cc8172cc2cd1c6aca42a2 9$[O`Ah(C9a/)VKJ?H]Y5fo.{t5_Q; 194.216.55.50
[email protected] org911 b5566e0c5f6717b395bed4b423fdec54 ^™ 212.26.19.153
[email protected] Bader f94fcc85df085b671ed754572f0f4e42 В?= 212.26.19.153
[email protected] talall_tu ecfab3d3afe608947299fa12b67de343 ѕеY 212.31.117.6
[email protected] ГИж СЗгЬЬЬЬЗ e0fd8073909f57a9b536f785ca53b401 ъ?= 212.26.19.156
[email protected] Nemesis 4f20224950f32eaefbf2ae2ab85f8f00 W+ї 212.72.7.194
[email protected] ИЬЗКЬСнжК 83df253f004eb0207d9f2eea950102c7 O«« 212.26.19.158
[email protected] The Rapier beb28c9379861bb16f7b743e22be117f я|A 212.26.19.156
[email protected] ahmed 7cb291749bf3247b4a07fca6c96df5eb <q\ 212.26.19.158
[email protected] saviour ab1045c3da02552d25dc263e8438bd29 Д І 212.26.19.153
[email protected] Ponadora a5d4ee9616b22b7fe45701a26ffa428e
[email protected] azar e04e96e5d264c81b2bc73b2fa2266ad4 ј9Ч 212.138.47.12
neo24.pl (780k)
sampleSpoiler
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
CREATE TABLE `cscart_users` (
`id` int(10) NOT NULL,
`email` varchar(128) DEFAULT NULL,
`user_login` varchar(255) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`salt` varchar(10) DEFAULT NULL,
`firstname` varchar(128) DEFAULT NULL,
`lastname` varchar(128) DEFAULT NULL,
`phone` varchar(32) DEFAULT NULL,
`fax` varchar(32) DEFAULT NULL,
`url` varchar(128) DEFAULT NULL,
`last_passwords` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `cscart_users` VALUES
(1, '[email protected]', 'admin', 'f944dcfb85a2e332048bae0de0c3bf59', 'yjYzPLOp9z', 'Administrator', 'Serwisu', '500 600700', '666 66 66 66', '', ''),
(2, '[email protected]', 'user_2', '4e170862514caffb9cd3927875aa289d', '#~Z8]W}Z/v', 'Imie', 'Nazwisko', '071 500600700', '501602703', '', ''),
(3, '[email protected]', '[email protected]', '83a082a21845d74bee959f9e337ae617', ']W}\'{qr[X6', 'Maciej', 'Laska', '608896765', '608896765', '', ''),
(4, '[email protected]', '[email protected]', 'd0023ae91c011d9bfedfe063ac1abbae', '', 'Zefiryn', 'Tora', '666', '', '', ''),
(5, '[email protected]', '[email protected]', '48bfadc5e492ef077b058668d08e9d48', '', 'Andrzej', 'Szunert', '508171793', '', '', ''),
(6, '[email protected]', '[email protected]', '6c2d7285b1fd72de10387a2cbf201f1f', '', 'Max', 'Payne', '300200100', '', '', ''),
(7, '[email protected]', '[email protected]', '3ce515ef7c2fb17763bba68b06cb3616', '', 'Max', 'Payne', '300200100', '', '', ''),
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
CREATE TABLE `cscart_users` (
`id` int(10) NOT NULL,
`email` varchar(128) DEFAULT NULL,
`user_login` varchar(255) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`salt` varchar(10) DEFAULT NULL,
`firstname` varchar(128) DEFAULT NULL,
`lastname` varchar(128) DEFAULT NULL,
`phone` varchar(32) DEFAULT NULL,
`fax` varchar(32) DEFAULT NULL,
`url` varchar(128) DEFAULT NULL,
`last_passwords` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `cscart_users` VALUES
(1, '[email protected]', 'admin', 'f944dcfb85a2e332048bae0de0c3bf59', 'yjYzPLOp9z', 'Administrator', 'Serwisu', '500 600700', '666 66 66 66', '', ''),
(2, '[email protected]', 'user_2', '4e170862514caffb9cd3927875aa289d', '#~Z8]W}Z/v', 'Imie', 'Nazwisko', '071 500600700', '501602703', '', ''),
(3, '[email protected]', '[email protected]', '83a082a21845d74bee959f9e337ae617', ']W}\'{qr[X6', 'Maciej', 'Laska', '608896765', '608896765', '', ''),
(4, '[email protected]', '[email protected]', 'd0023ae91c011d9bfedfe063ac1abbae', '', 'Zefiryn', 'Tora', '666', '', '', ''),
(5, '[email protected]', '[email protected]', '48bfadc5e492ef077b058668d08e9d48', '', 'Andrzej', 'Szunert', '508171793', '', '', ''),
(6, '[email protected]', '[email protected]', '6c2d7285b1fd72de10387a2cbf201f1f', '', 'Max', 'Payne', '300200100', '', '', ''),
(7, '[email protected]', '[email protected]', '3ce515ef7c2fb17763bba68b06cb3616', '', 'Max', 'Payne', '300200100', '', '', ''),
Akibatan.com (800k)
sampleSpoiler
-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--akibatan.com
-- Host: localhost
-- Generation Time: Jun 10, 2019 at 12:42 PM
-- Server version: 5.5.41-MariaDB
-- PHP Version: 7.3.1
-- Database: `akibatan_db`
-- --------------------------------------------------------
CREATE TABLE `wp_comments` (
`comment_ID` bigint(20) UNSIGNED NOT NULL,
`comment_post_ID` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
`comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comment_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
`comment_karma` int(11) NOT NULL DEFAULT '0',
`comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `wp_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES
(3, 37, '[P]', '[email protected]', '', '58.9.253.40', '2008-10-14 00:43:17', '2008-10-13 17:43:17', 'เล่นเก่งใช้ได้เลยแฮะ', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(5, 160, '[P]', '[email protected]', '', '58.9.8.101', '2008-10-19 11:07:39', '2008-10-19 04:07:39', '=3=\' ดูแอบจิตยังไงไม่รู้', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(6, 180, '_on', '[email protected]', 'http://www.thresident.com/', '124.120.38.211', '2008-10-19 12:38:02', '2008-10-19 05:38:02', 'ฟรีได้ม่ะ อิอิ', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.17) Gecko/20080829 Firefox/2.0.0.17', '', 0, 0),
(7, 160, 'saviola', '', '', '124.121.76.171', '2008-10-24 00:25:41', '2008-10-23 17:25:41', 'อยากนอน หนุนตักอ่ะ
โรคจิตน่าดู หุหุ', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3', '', 0, 0),
(8, 253, '[P]', '[email protected]', '', '58.9.6.246', '2008-10-26 23:16:44', '2008-10-26 16:16:44', 'นับถือคนไปถ่ายรูปของจริงมาแฮะ ถ่ายได้ตรงกะรูปในการ์ตูนเป๊ะเลย', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(9, 253, 'พี่เมี้ยวใจร้าย', '[email protected]', 'http://rh.gamer-gate.net/blog/', '124.120.161.55', '2008-10-27 12:03:29', '2008-10-27 05:03:29', 'ร่มรื่นเขียนผิดนะครับ ไม่ใช่ล่มรื่น
เว็บน่าสนใจดีครับ เอาใจช่วย', 0, '1', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_4; en-us) AppleWebKit/525.18 (KHTML, like Gecko) Version/3.1.2 Safari/525.20.1', '', 0, 0),
(10, 253, 'baew-kun', '[email protected]', 'http://www.akibatan.com', '119.63.79.78', '2008-10-27 12:31:16', '2008-10-27 05:31:16', 'ง่า ขอบคุณที่บอกจะแก้เลย', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3', '', 0, 1),
(11, 180, '= \' \' = \"', '', '', '58.8.204.219', '2008-10-27 23:04:35', '2008-10-27 16:04:35', 'ดัดแปลงให้มันกลายเป็นเกมลามกได้มะ แบ้ว', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3', '', 0, 0),
(18, 37, 'งานเข้า', '', '', '124.120.134.205', '2008-11-21 20:26:56', '2008-11-21 13:26:56', 'ผู้หญิงที่ไหนนิ้วจะใหญ่ขนาดนั้น แต่เล่นได้แจ่มดี', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/0.3.154.9 Safari/525.19', '', 0, 0),
(21, 37, 'ว้าว', '', '', '118.173.10.98', '2008-12-18 22:31:57', '2008-12-18 15:31:57', 'เย้ยย เล่นเก่งนะเนี้ย', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5', '', 0, 0),
(22, 500, '[P]', '', '', '58.9.10.12', '2008-12-20 01:40:37', '2008-12-19 18:40:37', 'ดูหื่นๆไงไม่รู้นะ = =\'', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(24, 520, 'อิอิ', '', '', '118.173.14.53', '2008-12-21 18:31:07', '2008-12-21 11:31:07', 'ขอบคุณครับ ผมเป็นสาวกเธอคนนี้เลยล่ะ ุหุห', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; th-TH; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5', '', 0, 0),
(26, 549, 'Benzaa', '', '', '202.28.45.15', '2008-12-25 09:04:13', '2008-12-25 02:04:13', 'ครั้งต่อไป ผมขอซีอิ้ว น้ำปลา กะปิ แบบโมเอะด้วยนะครับผม', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/2.0.0.8;MEGAUPLOAD 1.0', '', 0, 0),
(103086, 48971, 'Excel D. Thunder', '[email protected]', '', '125.25.244.212', '2011-08-21 19:05:37', '2011-08-21 12:05:37', 'ริสจัง otanjoubi omedeto', 0, '1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari/535.1', '', 0, 3815),
-- version 4.8.5
-- https://www.phpmyadmin.net/
--akibatan.com
-- Host: localhost
-- Generation Time: Jun 10, 2019 at 12:42 PM
-- Server version: 5.5.41-MariaDB
-- PHP Version: 7.3.1
-- Database: `akibatan_db`
-- --------------------------------------------------------
CREATE TABLE `wp_comments` (
`comment_ID` bigint(20) UNSIGNED NOT NULL,
`comment_post_ID` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`comment_author` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
`comment_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_author_url` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comment_content` text COLLATE utf8mb4_unicode_ci NOT NULL,
`comment_karma` int(11) NOT NULL DEFAULT '0',
`comment_approved` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
`comment_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`comment_parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
INSERT INTO `wp_comments` (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES
(3, 37, '[P]', '[email protected]', '', '58.9.253.40', '2008-10-14 00:43:17', '2008-10-13 17:43:17', 'เล่นเก่งใช้ได้เลยแฮะ', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(5, 160, '[P]', '[email protected]', '', '58.9.8.101', '2008-10-19 11:07:39', '2008-10-19 04:07:39', '=3=\' ดูแอบจิตยังไงไม่รู้', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(6, 180, '_on', '[email protected]', 'http://www.thresident.com/', '124.120.38.211', '2008-10-19 12:38:02', '2008-10-19 05:38:02', 'ฟรีได้ม่ะ อิอิ', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.17) Gecko/20080829 Firefox/2.0.0.17', '', 0, 0),
(7, 160, 'saviola', '', '', '124.121.76.171', '2008-10-24 00:25:41', '2008-10-23 17:25:41', 'อยากนอน หนุนตักอ่ะ
โรคจิตน่าดู หุหุ', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3', '', 0, 0),
(8, 253, '[P]', '[email protected]', '', '58.9.6.246', '2008-10-26 23:16:44', '2008-10-26 16:16:44', 'นับถือคนไปถ่ายรูปของจริงมาแฮะ ถ่ายได้ตรงกะรูปในการ์ตูนเป๊ะเลย', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(9, 253, 'พี่เมี้ยวใจร้าย', '[email protected]', 'http://rh.gamer-gate.net/blog/', '124.120.161.55', '2008-10-27 12:03:29', '2008-10-27 05:03:29', 'ร่มรื่นเขียนผิดนะครับ ไม่ใช่ล่มรื่น
เว็บน่าสนใจดีครับ เอาใจช่วย', 0, '1', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_4; en-us) AppleWebKit/525.18 (KHTML, like Gecko) Version/3.1.2 Safari/525.20.1', '', 0, 0),
(10, 253, 'baew-kun', '[email protected]', 'http://www.akibatan.com', '119.63.79.78', '2008-10-27 12:31:16', '2008-10-27 05:31:16', 'ง่า ขอบคุณที่บอกจะแก้เลย', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3', '', 0, 1),
(11, 180, '= \' \' = \"', '', '', '58.8.204.219', '2008-10-27 23:04:35', '2008-10-27 16:04:35', 'ดัดแปลงให้มันกลายเป็นเกมลามกได้มะ แบ้ว', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3', '', 0, 0),
(18, 37, 'งานเข้า', '', '', '124.120.134.205', '2008-11-21 20:26:56', '2008-11-21 13:26:56', 'ผู้หญิงที่ไหนนิ้วจะใหญ่ขนาดนั้น แต่เล่นได้แจ่มดี', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/0.3.154.9 Safari/525.19', '', 0, 0),
(21, 37, 'ว้าว', '', '', '118.173.10.98', '2008-12-18 22:31:57', '2008-12-18 15:31:57', 'เย้ยย เล่นเก่งนะเนี้ย', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5', '', 0, 0),
(22, 500, '[P]', '', '', '58.9.10.12', '2008-12-20 01:40:37', '2008-12-19 18:40:37', 'ดูหื่นๆไงไม่รู้นะ = =\'', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/2.0.0.13;MEGAUPLOAD 1.0', '', 0, 0),
(24, 520, 'อิอิ', '', '', '118.173.14.53', '2008-12-21 18:31:07', '2008-12-21 11:31:07', 'ขอบคุณครับ ผมเป็นสาวกเธอคนนี้เลยล่ะ ุหุห', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; th-TH; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5', '', 0, 0),
(26, 549, 'Benzaa', '', '', '202.28.45.15', '2008-12-25 09:04:13', '2008-12-25 02:04:13', 'ครั้งต่อไป ผมขอซีอิ้ว น้ำปลา กะปิ แบบโมเอะด้วยนะครับผม', 0, '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/2.0.0.8;MEGAUPLOAD 1.0', '', 0, 0),
(103086, 48971, 'Excel D. Thunder', '[email protected]', '', '125.25.244.212', '2011-08-21 19:05:37', '2011-08-21 12:05:37', 'ริสจัง otanjoubi omedeto', 0, '1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari/535.1', '', 0, 3815),
chronicle.com (3.4ml)
sampleSpoiler
CREATE TABLE `users` (
`userID` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(25) NOT NULL DEFAULT '',
`password` varchar(255) DEFAULT NULL,
`paper` varchar(4) NOT NULL DEFAULT '',
`kableID` int(8) DEFAULT NULL,
`prefix` char(3) DEFAULT NULL,
`firstName` varchar(30) DEFAULT '',
`middle` char(1) DEFAULT NULL,
`lastName` varchar(30) DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`confirmedFlag` char(1) NOT NULL DEFAULT '',
`hasAutoGeneratedUsername` tinyint(1) NOT NULL DEFAULT '0',
`lastlogin` datetime DEFAULT NULL,
`dateAdded` datetime DEFAULT NULL,
`lastEspRefresh` datetime DEFAULT NULL,
`eloquaId` int(11) DEFAULT NULL,
`eloqua_timestamp` datetime DEFAULT NULL,
`modified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`userID`),
UNIQUE KEY `username` (`username`,`paper`)
) ENGINE=InnoDB AUTO_INCREMENT=5169491 DEFAULT CHARSET=latin1;
INSERT INTO `users` (`userID`, `username`, `password`, `paper`, `kableID`, `prefix`, `firstName`, `middle`, `lastName`, `email`, `confirmedFlag`, `hasAutoGeneratedUsername`, `lastlogin`, `dateAdded`, `lastEspRefresh`, `eloquaId`, `eloqua_timestamp`, `modified_at`) VALUES
(2, 'joelcooper', '$1$jz0yAlJQ$8jCxZbT4kiQXlI2pMcvvu/', 'TCED', 22198250, NULL, NULL, NULL, NULL, '[email protected]', NULL, 0, '2003-01-15 00:00:00', NULL, '2016-09-17 03:31:26', NULL, NULL, '0000-00-00 00:00:00'),
(3, 'grandsoult', 'aRj7CY9X8yCVM', 'TCED', NULL, NULL, 'Francis', NULL, 'Leach', '[email protected]', 'Y', 0, '2006-08-31 11:40:55', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(4, 'tgrecic', 'aRJ3pwkdFdPls', 'TCED', NULL, NULL, 'Tatiana', 'G', 'Dutoit', '[email protected]', 'Y', 0, '2012-05-09 17:35:27', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(5, 'alkipta', 'YDwDHNRh9pBH2', 'TCED', NULL, NULL, 'ALLISON', NULL, 'KIPTA', '[email protected]', 'Y', 0, '2005-08-14 19:53:05', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(6, 'k19e69g', 'aRdrp5SvJA.EI', 'TCED', NULL, NULL, 'Kyle', NULL, 'Graham', '[email protected]', 'Y', 0, '2006-03-08 10:23:48', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(7, 'jgserafino', 'aRdJlqdhhppTg', 'TCED', NULL, NULL, 'JACQUIE', NULL, 'SERAFINO', '[email protected]', NULL, 0, '2004-12-02 07:37:05', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(8, 'bidmeaj', 'SiZtnb3ngVAEQ', 'TCED', 11215821, NULL, 'Julye', NULL, 'Bidmead', '[email protected]', NULL, 0, '2007-05-13 20:07:35', NULL, '2016-09-17 03:31:25', NULL, NULL, '0000-00-00 00:00:00'),
(9, 'emriordan', 'kNTHJprHjbFVU', 'TCED', NULL, NULL, NULL, NULL, NULL, '[email protected]', NULL, 0, '2007-08-23 15:37:58',
`userID` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(25) NOT NULL DEFAULT '',
`password` varchar(255) DEFAULT NULL,
`paper` varchar(4) NOT NULL DEFAULT '',
`kableID` int(8) DEFAULT NULL,
`prefix` char(3) DEFAULT NULL,
`firstName` varchar(30) DEFAULT '',
`middle` char(1) DEFAULT NULL,
`lastName` varchar(30) DEFAULT '',
`email` varchar(50) NOT NULL DEFAULT '',
`confirmedFlag` char(1) NOT NULL DEFAULT '',
`hasAutoGeneratedUsername` tinyint(1) NOT NULL DEFAULT '0',
`lastlogin` datetime DEFAULT NULL,
`dateAdded` datetime DEFAULT NULL,
`lastEspRefresh` datetime DEFAULT NULL,
`eloquaId` int(11) DEFAULT NULL,
`eloqua_timestamp` datetime DEFAULT NULL,
`modified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`userID`),
UNIQUE KEY `username` (`username`,`paper`)
) ENGINE=InnoDB AUTO_INCREMENT=5169491 DEFAULT CHARSET=latin1;
INSERT INTO `users` (`userID`, `username`, `password`, `paper`, `kableID`, `prefix`, `firstName`, `middle`, `lastName`, `email`, `confirmedFlag`, `hasAutoGeneratedUsername`, `lastlogin`, `dateAdded`, `lastEspRefresh`, `eloquaId`, `eloqua_timestamp`, `modified_at`) VALUES
(2, 'joelcooper', '$1$jz0yAlJQ$8jCxZbT4kiQXlI2pMcvvu/', 'TCED', 22198250, NULL, NULL, NULL, NULL, '[email protected]', NULL, 0, '2003-01-15 00:00:00', NULL, '2016-09-17 03:31:26', NULL, NULL, '0000-00-00 00:00:00'),
(3, 'grandsoult', 'aRj7CY9X8yCVM', 'TCED', NULL, NULL, 'Francis', NULL, 'Leach', '[email protected]', 'Y', 0, '2006-08-31 11:40:55', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(4, 'tgrecic', 'aRJ3pwkdFdPls', 'TCED', NULL, NULL, 'Tatiana', 'G', 'Dutoit', '[email protected]', 'Y', 0, '2012-05-09 17:35:27', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(5, 'alkipta', 'YDwDHNRh9pBH2', 'TCED', NULL, NULL, 'ALLISON', NULL, 'KIPTA', '[email protected]', 'Y', 0, '2005-08-14 19:53:05', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(6, 'k19e69g', 'aRdrp5SvJA.EI', 'TCED', NULL, NULL, 'Kyle', NULL, 'Graham', '[email protected]', 'Y', 0, '2006-03-08 10:23:48', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(7, 'jgserafino', 'aRdJlqdhhppTg', 'TCED', NULL, NULL, 'JACQUIE', NULL, 'SERAFINO', '[email protected]', NULL, 0, '2004-12-02 07:37:05', NULL, NULL, NULL, NULL, '2019-04-05 08:05:35'),
(8, 'bidmeaj', 'SiZtnb3ngVAEQ', 'TCED', 11215821, NULL, 'Julye', NULL, 'Bidmead', '[email protected]', NULL, 0, '2007-05-13 20:07:35', NULL, '2016-09-17 03:31:25', NULL, NULL, '0000-00-00 00:00:00'),
(9, 'emriordan', 'kNTHJprHjbFVU', 'TCED', NULL, NULL, NULL, NULL, NULL, '[email protected]', NULL, 0, '2007-08-23 15:37:58',
globalreach.eu.com (900k)
sampleSpoiler
{
"_id": 528,
"login": "[email protected]",
"password": "63122FDDE2FA9C0035F729C5D31B05DCCA08303A1FC5ECAF5626E06A14CE7238",
"userEntity": {
"firstName": "",
"lastName": "",
"role": 0,
"allowPasswordChange": false,
"enableGA": false,
"method": 0,
"userAge": 0,
"birthday": " ",
"userGender": 0,
"needChangePassword": false,
"devicesLimitEnabled": false,
"devicesLimit": 0,
"isOneTimeLogin": false,
"privateKeyPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"importPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"attributesSerialized": "[]",
"timeZone": 0,
"adminLocale": 0,
"voucherValidityTime": 0,
"permissionLevel": 0,
"realmId": 0
},
"enabled": true,
"organization_id": 24,
"countOfFiledLogins": 0,
"created": {
"sec": 1388905193,
"usec": 0
},
"login_ci": "[email protected]"
}
{
"_id": 536,
"login": "[email protected]",
"password": "E3B34F4A2E18E97B7CDBBFB455FA24E6",
"userEntity": {
"firstName": "Fernanda",
"lastName": "Manika",
"role": 0,
"allowPasswordChange": false,
"enableGA": false,
"method": 0,
"userAge": 0,
"birthday": " ",
"userGender": 0,
"needChangePassword": false,
"devicesLimitEnabled": false,
"devicesLimit": 0,
"isOneTimeLogin": false,
"privateKeyPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"importPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"attributesSerialized": "[]",
"timeZone": 0,
"adminLocale": 0,
"voucherValidityTime": 0,
"permissionLevel": 0,
"realmId": 0
},
"enabled": true,
"organization_id": 24,
"countOfFiledLogins": 0,
"created": {
"sec": 1388905865,
"usec": 0
},
"login_ci": "[email protected]"
}
{
"_id": 538,
"login": "[email protected]",
"password": "097AF707F27FAEF6A69EBD5F1995C9FD",
"userEntity": {
"firstName": "Ida",
"lastName": "Strømmen",
"role": 0,
"allowPasswordChange": false,
"enableGA": false,
"method": 0,
"userAge": 0,
"birthday": " ",
"userGender": 0,
"needChangePassword": false,
"devicesLimitEnabled": false,
"devicesLimit": 0,
"isOneTimeLogin": false,
"privateKeyPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"importPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"attributesSerialized": "[]",
"timeZone": 0,
"adminLocale": 0,
"voucherValidityTime": 0,
"permissionLevel": 0,
"realmId": 0,
"cloudPortalUsers": []
"_id": 528,
"login": "[email protected]",
"password": "63122FDDE2FA9C0035F729C5D31B05DCCA08303A1FC5ECAF5626E06A14CE7238",
"userEntity": {
"firstName": "",
"lastName": "",
"role": 0,
"allowPasswordChange": false,
"enableGA": false,
"method": 0,
"userAge": 0,
"birthday": " ",
"userGender": 0,
"needChangePassword": false,
"devicesLimitEnabled": false,
"devicesLimit": 0,
"isOneTimeLogin": false,
"privateKeyPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"importPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"attributesSerialized": "[]",
"timeZone": 0,
"adminLocale": 0,
"voucherValidityTime": 0,
"permissionLevel": 0,
"realmId": 0
},
"enabled": true,
"organization_id": 24,
"countOfFiledLogins": 0,
"created": {
"sec": 1388905193,
"usec": 0
},
"login_ci": "[email protected]"
}
{
"_id": 536,
"login": "[email protected]",
"password": "E3B34F4A2E18E97B7CDBBFB455FA24E6",
"userEntity": {
"firstName": "Fernanda",
"lastName": "Manika",
"role": 0,
"allowPasswordChange": false,
"enableGA": false,
"method": 0,
"userAge": 0,
"birthday": " ",
"userGender": 0,
"needChangePassword": false,
"devicesLimitEnabled": false,
"devicesLimit": 0,
"isOneTimeLogin": false,
"privateKeyPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"importPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"attributesSerialized": "[]",
"timeZone": 0,
"adminLocale": 0,
"voucherValidityTime": 0,
"permissionLevel": 0,
"realmId": 0
},
"enabled": true,
"organization_id": 24,
"countOfFiledLogins": 0,
"created": {
"sec": 1388905865,
"usec": 0
},
"login_ci": "[email protected]"
}
{
"_id": 538,
"login": "[email protected]",
"password": "097AF707F27FAEF6A69EBD5F1995C9FD",
"userEntity": {
"firstName": "Ida",
"lastName": "Strømmen",
"role": 0,
"allowPasswordChange": false,
"enableGA": false,
"method": 0,
"userAge": 0,
"birthday": " ",
"userGender": 0,
"needChangePassword": false,
"devicesLimitEnabled": false,
"devicesLimit": 0,
"isOneTimeLogin": false,
"privateKeyPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"importPwd": "72249CA1BF4E08CC6A2222EA4CAAC3DA",
"attributesSerialized": "[]",
"timeZone": 0,
"adminLocale": 0,
"voucherValidityTime": 0,
"permissionLevel": 0,
"realmId": 0,
"cloudPortalUsers": []

