Прошу не разводить флуд а просто выложить всех спамеров с ваших сайтов.
Приступаю:
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; DROP TABLE IF EXISTS `cms_banlist`; CREATE TABLE IF NOT EXISTS `cms_banlist` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `ip` varchar(15) NOT NULL, `bandate` datetime NOT NULL, `int_num` int(11) NOT NULL, `int_period` varchar(20) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '1', `autodelete` tinyint(1) NOT NULL DEFAULT '0', ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ; INSERT INTO `cms_banlist` (`id`, `user_id`, `ip`, `bandate`, `int_num`, `int_period`, `status`, `autodelete`) VALUES (1, 22, '89.28.71.14', '2013-06-22 22:04:34', 0, 'MINUTE', 1, 0), (2, 22, '89.28.71.14', '2013-06-22 22:04:48', 0, 'MINUTE', 1, 0), (3, 22, '89.28.71.14', '2013-06-22 22:05:02', 0, 'MINUTE', 1, 0), (4, 22, '89.28.71.14', '2013-06-22 22:05:17', 0, 'MINUTE', 1, 0), (5, 4, '88.85.178.221', '2013-06-22 22:05:38', 0, 'MINUTE', 1, 0), (6, 5, '109.108.41.99', '2013-06-22 22:05:58', 0, 'MINUTE', 1, 0), (7, 6, '5.248.84.197', '2013-06-22 22:06:15', 0, 'MINUTE', 1, 0), (8, 7, '89.28.71.14', '2013-06-22 22:08:16', 0, 'MINUTE', 1, 0), (9, 8, '89.28.71.14', '2013-06-22 22:12:09', 0, 'MINUTE', 1, 0), (10, 13, '109.108.41.73', '2013-06-22 22:16:15', 0, 'MINUTE', 1, 0), (11, 12, '176.119.0.182', '2013-06-22 22:17:37', 0, 'MINUTE', 1, 0), (12, 14, '89.28.71.14', '2013-06-22 22:22:28', 0, 'MINUTE', 1, 0), (13, 19, '212.73.146.168', '2013-06-22 22:22:43', 0, 'MINUTE', 1, 0), (14, 18, '176.119.0.182', '2013-06-22 22:24:07', 0, 'MINUTE', 1, 0), (15, 17, '83.99.139.223', '2013-06-22 22:24:20', 0, 'MINUTE', 1, 0), (16, 16, '83.99.139.223', '2013-06-22 22:24:36', 0, 'MINUTE', 1, 0), (17, 15, '213.242.32.182', '2013-06-22 22:24:50', 0, 'MINUTE', 1, 0); DROP TABLE IF EXISTS `cms_users`; CREATE TABLE IF NOT EXISTS `cms_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL DEFAULT '1', `login` varchar(100) NOT NULL, `nickname` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `icq` varchar(15) NOT NULL, `regdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `logdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `is_locked` tinyint(1) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `is_logged_once` tinyint(1) NOT NULL DEFAULT '0', `rating` int(11) NOT NULL, `points` int(11) NOT NULL, `last_ip` varchar(15) NOT NULL, `status` varchar(255) NOT NULL, `status_date` datetime NOT NULL, `invited_by` int(11) DEFAULT NULL, `invdate` datetime DEFAULT NULL, `openid` varchar(250) DEFAULT NULL, ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=23 ; INSERT INTO `cms_users` (`id`, `group_id`, `login`, `nickname`, `password`, `email`, `icq`, `regdate`, `logdate`, `birthdate`, `is_locked`, `is_deleted`, `is_logged_once`, `rating`, `points`, `last_ip`, `status`, `status_date`, `invited_by`, `invdate`, `openid`) VALUES (4, 1, 'AlekSArem', 'AlekSArem', 'b85ef0e4c02070289a093cf0f86d4f73', 'ale96kswhiodw@yandex.ru', '', '2013-05-09 22:13:46', '2013-06-04 01:22:13', '1996-07-14', 0, 0, 1, 0, 0, '88.85.178.221', '', '0000-00-00 00:00:00', 0, NULL, NULL), (5, 1, 'Goganrax', 'Goganrax', 'b85ef0e4c02070289a093cf0f86d4f73', 'goganradaevrs@yandex.ru', '', '2013-05-21 01:19:36', '2013-05-21 20:12:51', '1996-07-14', 0, 0, 1, 0, 0, '109.108.41.99', '', '0000-00-00 00:00:00', 0, NULL, NULL), (6, 1, 'Vikuljastad', 'Vikuljastad', '8a2217fb8994163de50d6713f5ac6316', 'vikuljastad@hotmail.com', '342211318', '2013-05-26 22:59:24', '2013-05-31 15:27:00', '1950-01-01', 0, 0, 1, 0, 0, '5.248.84.197', '', '0000-00-00 00:00:00', 0, NULL, NULL), (7, 1, 'batishtacraz', 'Иван Николаевич', '31dde30dcb9c442aada755559824786f', 'batishtacraz@yandex.com', '4770551625', '2013-05-28 12:40:44', '2013-05-29 17:13:43', '1950-01-01', 0, 0, 1, 0, 0, '89.28.71.14', '', '0000-00-00 00:00:00', 0, NULL, NULL), (8, 1, 'karinatiji', 'Карина Тижякова', '31dde30dcb9c442aada755559824786f', 'karinatiji@yandex.ru', '3694242845', '2013-05-30 10:07:51', '2013-05-31 11:46:33', '1950-01-01', 0, 0, 1, 0, 0, '89.28.71.14', '', '0000-00-00 00:00:00', 0, NULL, NULL), (9, 1, 'Vladatimser', 'Vladatimser', '770a06e30626c771c38b12468213d7f3', 'vladatimser@hotmail.com', '342211318', '2013-05-31 17:53:17', '2013-06-22 22:25:28', '1950-01-01', 0, 0, 1, 0, 0, '176.8.88.137', '', '0000-00-00 00:00:00', 0, NULL, NULL), (10, 1, 'voislithense', 'voislithense 89196qwa', '78c4e6b88ca565661e80489d1a633c71', '89196qwa@amnesia.in.ua', '', '2013-06-06 23:05:23', '2013-06-06 23:05:51', '0000-00-00', 0, 0, 1, 0, 0, '46.150.103.139', '', '0000-00-00 00:00:00', 0, NULL, NULL), (11, 1, 'rendisupo', 'rendisupo 19tk', '2c2c2551dd185e0a99d11d55db8d87a7', '19tk@amnesia.in.ua', '', '2013-06-07 04:44:31', '2013-06-07 04:44:59', '0000-00-00', 0, 0, 1, 0, 0, '46.150.103.139', '', '0000-00-00 00:00:00', 0, NULL, NULL), (12, 1, 'plattermranca', 'plattermranca', '8990ee5868399474a9e347aeb4f503be', '0osln@amnesia.in.ua', '', '2013-06-07 21:13:20', '2013-06-22 18:50:47', '0000-00-00', 0, 0, 1, 0, 0, '176.119.0.182', '', '0000-00-00 00:00:00', 0, NULL, NULL), (13, 1, 'GenaFArem', 'GenaFArem', 'b85ef0e4c02070289a093cf0f86d4f73', 'genafswhiodw@yandex.ru', '', '2013-06-08 18:17:10', '2013-06-11 20:23:42', '1996-07-14', 0, 0, 1, 0, 0, '109.108.41.73', '', '0000-00-00 00:00:00', 0, NULL, NULL), (14, 1, 'arinaivashko', 'Ивашко Арина', '31dde30dcb9c442aada755559824786f', 'arinaivashko@yandex.com', '3226491162', '2013-06-11 11:51:08', '2013-06-12 23:57:50', '1950-01-01', 0, 0, 1, 0, 0, '89.28.71.14', '', '0000-00-00 00:00:00', 0, NULL, NULL), (15, 1, 'WolfEXEhogy', 'WolfEXEhogy', '2712d8de09a5ed0f5936ef52d21caee4', 'olli4s6o3d8dw@yandex.ru', '6556565656', '2013-06-11 16:19:16', '2013-06-11 16:19:16', '1996-07-14', 0, 0, 1, 0, 0, '213.242.32.182', '', '0000-00-00 00:00:00', 0, NULL, NULL), (16, 1, 'UncoomNor', 'UncoomNorGQ', 'ed66b83c359e2d94669d0d6fbbda16c4', 'deenialem@mail.ru', '157636257', '2013-06-12 14:05:45', '2013-06-22 22:19:11', '1996-07-14', 0, 0, 1, 0, 0, '83.99.139.223', '', '0000-00-00 00:00:00', 0, NULL, NULL), (17, 1, 'poenueHus', 'poenueHusPI', '8dd3eb514f43a5ef0220fe34c143822f', 'usexsnimi@hotmail.com', '385681866', '2013-06-12 23:58:10', '2013-06-15 23:54:41', '1996-07-14', 0, 0, 1, 0, 0, '83.99.139.223'