The War Z Database
thewarz.com
320,507
Global
34.03 MB
153.58 MB
1
The War Z database leak in 2012 was a major cybersecurity breach that exposed sensitive information about players of the popular online game War Z. On December 18, 2012, a hacker dumped 320,507 records from the games database onto the internet, revealing a treasure trove of personal information about the games players.
The leaked data included user IDs, passwords, email addresses, IP addresses, and other identifying information. It also included details about player behavior, such as the levels they had reached, the weapons they had unlocked, and the points they had earned. Additionally, the leak exposed the games internal scoreboards, which listed the top-scoring players in various categories.
The hackers gained access to the database by exploiting a vulnerability in the games web-based interface. Once inside, they downloaded the entire database and published it online. The breach was significant not just because of the volume of data exposed, but also because it revealed the games internal workings and the level of detail the games developers had collected about their players.
The leak had serious consequences for the games developers, OP Productions, and its publisher, Hamzi(lengthilyventure(sic). The incident led to a loss of player trust, a decline in game sales, and a wave of negative publicity for the company.
We have loaded this breach into our database.
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`membergroupids` char(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`email` char(100) NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentemail` char(50) NOT NULL DEFAULT '',
`homepage` char(100) NOT NULL DEFAULT '',
`icq` char(20) NOT NULL DEFAULT '',
`aim` char(20) NOT NULL DEFAULT '',
`yahoo` char(32) NOT NULL DEFAULT '',
`msn` char(100) NOT NULL DEFAULT '',
`skype` char(32) NOT NULL DEFAULT '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
`usertitle` char(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',
`lastpostid` 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` char(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',
`profilepicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`sigpicrevision` int(10) unsigned NOT NULL DEFAULT '0',
`options` int(10) unsigned NOT NULL DEFAULT '33570831',
`birthday` char(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` char(15) NOT NULL DEFAULT '',
`referrerid` int(10) unsigned NOT NULL DEFAULT '0',
`languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
`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 '',
`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',
`adminoptions` int(10) 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 DEFAULT '',
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) NOT NULL DEFAULT '',
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`fbaccesstoken` varchar(255) NOT NULL DEFAULT '',
`newrepcount` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=320892 DEFAULT CHARSET=latin1;
INSERT INTO `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`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `newrepcount`) VALUES
(1, 6, NULL, 0, 'WaZForumAdmin', '6922dd7963abb50bdb00c0c84f141014', '2012-07-25', '[email protected]', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 2, 'Administrator', 0, 1343243940, 0, 1354637208, 1354637217, 0, 2, 0, 10, 5, 0, 0, 0, 0, 0, 0, 11552855, '01-12-1989', '1989-01-12', -1, 1, NULL, 0, 0, 0, 0, -1, 64, 64, '50Vqp7.&(BsQQpOpK\\)dA8vIn2c&:|', 0, 0, 0, NULL, 0, 0, 1164, 0, 10, 1, 0, 0, 0, 0, 0, 0, NULL, 553177262, 1344459114, 'Kevin Peek', 'vb', '376566132411701|4b52d56a824a518d291b9af7d554432a', 0)
,(2, 6, 14, 0, 'sergeytitov', 'ad31ea1e0310d43582b2c59ba2bc6123', '2012-11-28', '[email protected]', 3, NULL, 'http://www.thewarz.com', NULL, NULL, NULL, NULL, NULL, 1, 0, 'Administrator', 0, 1343251080, -1, 1356236711, 1356237896, 1356237752, 1277858, 558, 1317, 15, -8, 1, 0, 0, 0, 0, 45238359, '01-01-1973', '1973-01-01', 100, 1, NULL, 0, 0, 0, 0, 2, 15, 2, 'K9hx&fkR4,I\\2QX.;Iqljtbdw(%3f5', 0, 0, 0, NULL, 0, 0, 172555, 1, 633, 601, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, NULL, 'vb', 'AAAFWfCKOjTUBAHbFmali7dQl6r2525005xXr2nQxETHUWRCH2jeYnT6ciDcZAfZC5dxESCwvbHKjC8wfhwe4NZCtr4pqcPjDbAyOVDjSgZDZD', 2)
,(3, 6, NULL, 6, 'Kewk', 'e924922cfff72fcca62d63afd64e0cd2', '2012-07-26', NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Community Manager', 1, 1343327700, -1, 1356221030, 1356236284, 1356242509, 1278292, 10000748, 101061, 15, -8, 0, 0, 3, 0, 0, 45632599, NULL, '0000-00-00', 40, 1, NULL, 0, 0, 0, 0, -1, 2242, 1175, 'Q;|`p$Qmy2HiDI$!9\"5N1];`6R)U!F', 0, 0, 0, NULL, 0, 0, 53167, 408, 5, 18, 0, 0, 0, 0, 0, 0, NULL, 547849407, 1343413639, 'Patrick Bowman', 'vb', 'AAAFWfCKOjTUBACH7ZBovwYU5hhf9xBcsQanBHdJ9wtuzHmHHAQGkG9Kr22RQMFQq2RuuJwXa8LybpAanc0Rqgox2a1ZCLoguVzDQ8FbQZDZD', 2)
,(4, 6, NULL, 0, 'WebDesign', 'ff54a3334e36b3872540491fd063f72e', '2012-07-26', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Administrator', 0, 1343327760, -1, 1356165531, 1356191993, 0, 0, 0, 10, 5, 0, 0, 0, 0, 0, 0, 45108311, NULL, '0000-00-00', -1, -1, NULL, 0, 0, 0, 0, -1, 12, 12, '\\;DtUz|vr;eK!DrB{m,}2bc/`[?5r_', 0, 0, 0, NULL, 0, 0, 420, 0, 4, 3, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, NULL, 'vb', NULL, 0)
,(6, 15, 14, 0, 'Cias13', 'e3d2d1ec0694a3128626b355bbdda137', '2012-07-30', '[email protected]', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 'Zombie Executioner', 0, 1343708080, 0, 1354679554, 1355866848, 1350672056, 608985, 1150, 129, 10, -5, 1, 0, 4, 0, 0, 45112407, '03-10-1986', '1986-03-10', -1, 1, '71.187.56.5', 0, 0, 1349750588, 0, -1, 80, 0, '5{d\',*BkJ/8+9A:}2Egt=QSk4J{0~D', 0, 0, 0, NULL, 0, 0, 434, 4, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, NULL, 'vb', NULL, 0)
,(7, 15, 14, 0, 'ObsidianZ', '7913d1082378f1a060d56551c7699a1d', '2012-07-30', '[email protected]', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, 'Retired Moderator', 1, 1343708100, 0, 1356247291, 1356249699, 1356246624, 1278626, 1007, 840, 14, -8, 0, 0, 5, 3, 0, 43535447, '12-15-1989', '1989-12-15', 40, 1, '96.26.39.174', 0, 0, 1356087687, 0, -1, 26, 0, 'rS/;nl4IBrir2\'