SQL Simcityforum.com

[tudos]

SQL Dump of the users table of Simcityforum.com from the raid
24044 records
дата :29/10/2020

Спойлер: что внутри?

-- MySQL Table Dump
-- Host: localhost Database: sv004748_8025SimCityForum Table: user
-- -----------------------------------------------------
-- Server Version: 5.7.32
-- Dumped on: October 29, 2020, 5:54 pm

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`membergroupids` varchar(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`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 '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
`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',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1',
`timezoneoffset` varchar(4) NOT NULL DEFAULT '',
`pmpopup` smallint(6) NOT NULL DEFAULT '0',
`avatarid` smallint(6) NOT NULL DEFAULT '0',
`avatarrevision` int(10) unsigned NOT NULL DEFAULT '0',
`options` int(10) unsigned NOT NULL DEFAULT '33570831',
`birthday` varchar(10) NOT NULL DEFAULT '',
`birthday_search` date 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',
`languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
`msn` varchar(100) NOT NULL DEFAULT '',
`emailstamp` int(10) unsigned NOT NULL DEFAULT '0',
`threadedmode` smallint(5) unsigned NOT NULL DEFAULT '0',
`autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
`salt` char(30) NOT NULL DEFAULT '',
`user_sort` varchar(15) NOT NULL DEFAULT '0',
`user_order` varchar(4) NOT NULL DEFAULT '0',
`user_g_pp` mediumint(8) NOT NULL DEFAULT '0',
`user_s_pp` mediumint(8) NOT NULL DEFAULT '0',
`def_g_cat` mediumint(8) NOT NULL DEFAULT '0',
`game_skin` tinyint(1) NOT NULL DEFAULT '0',
`arcade_mod_privs` text NOT NULL,
`name_color` text NOT NULL,
`name_glow` text NOT NULL,
`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',
`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 `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday_search` (`birthday_search`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `email` (`email`),
KEY `lastactivity` (`lastactivity`)
) ENGINE=MyISAM AUTO_INCREMENT=24867 DEFAULT CHARSET=latin1;

Спойлер: пример

('1', '7', '', '0', 'Paul', '8e23670d1d3a33e9b5bb8f892a7a1658', '2004-11-15', 'admin@scriptinstallation.ca', '0', '', '', '', '', '', '0', 'City Advisor (Member #1!)', '2', '1100538000', '0', '1590289832', '1590289832', '1549482955', '122', '29', '5', '-5', '0', '0', '1', '45108311', '10-22-0000', '0000-10-22', '-1', '1', '', '0', '0', '', '0', '0', '-1', '8', '0', '@SQ', '0', '0', '0', '0', '0', '0', '', '', '', '0', '0', '', '1', '12742', '0', '0', '0', '0', '', '0', '660', '1', '0', '0', '0', '0', '0', '0', '0', '0', 'ae53af4e037296e12834037eb9333dcd', '', '0', '', 'vb', '', '0', '0', '1');

sql.gg — simcityforum.com_24044_users.zip

simcityforum.com_24044_users.zip

sql.gg