Файл: tje4_moto.sql
Строк: 617
-- phpMyAdmin SQL Dump
-- version 4.2.11
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Дек 22 2014 г., 19:02
-- Server
version: 5.5.40-36.1-log
-- PHP Version: 5.3.29
SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
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
utf8 */;
--
-- Database: `tje4_moto`
--
--
--------------------------------------------------------
--
--
Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS
`chat` (
`id` int(255) NOT NULL,
`id_user` int(11) NOT NULL,
`msg`
varchar(455) NOT NULL,
`time` int(255) NOT NULL
) ENGINE=MyISAM
AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `chat`
--
INSERT INTO `chat` (`id`, `id_user`, `msg`,
`time`) VALUES
(1, 1, ':01::01:', 1419155618),
(2, 1, 'Убрал
огранку', 1419155623),
(3, 9, 'Хрень:08:', 1419155685),
(4, 12,
':08:', 1419156538),
(5, 12, ':08::09:', 1419156621),
(6, 12, ':01::07:',
1419156892),
(7, 12, ':07:', 1419156905),
(8, 15, ':06:', 1419158127),
(9,
12, ':06::06::06::06::07::08:', 1419159422),
(10, 12, ':01:',
1419160499),
(11, 12, ':01:', 1419161155),
(12, 19, ':01:',
1419161483),
(13, 1, 'Ебать лохи :01:', 1419164929),
(14, 1,
':06::06::06:', 1419168780),
(15, 25, 'нубас пришол:08:',
1419177522),
(16, 1, ':03:', 1419178766),
(17, 25, ':01:',
1419179095),
(18, 25, ':09:', 1419180608),
(19, 25, ':06:',
1419187622),
(20, 20, ':06:', 1419190564),
(21, 25, ':03::03::03:',
1419190619),
(22, 25, ':06::06:', 1419190625),
(23, 28, ':08:',
1419190694),
(24, 25, ':06:', 1419191763),
(25, 25, ':07::07:',
1419191783),
(26, 10, 'выиграл в лотерею
супермотик, нет его в гараже', 1419195987),
(27, 42,
'jhjm', 1419201198),
(28, 1, 'http://prntscr.com/5jle1n Щас
выиграл', 1419229371),
(29, 1, 'http://prntscr . com/5jle1n',
1419229376),
(30, 1, 'Добавлены гонки /race',
1419244341),
(31, 53, ':01::01::02::03::04::05::06::07::08::09:',
1419250235),
(32, 54, 'Fdg', 1419251954),
(33, 60, ':07:',
1419263459),
(34, 60, 'куку', 1419263469),
(35, 60, ':09:',
1419263475),
(36, 1, 'парвп', 1419263738);
--
--------------------------------------------------------
--
--
Структура таблицы `garage`
--
CREATE TABLE IF NOT EXISTS
`garage` (
`id` int(255) NOT NULL,
`id_user` int(255) NOT NULL,
`moto_id` int(245) NOT NULL,
`moto_name` varchar(155) NOT NULL,
`moto_img` varchar(355) NOT NULL,
`class` set('A','B','C','D','E') NOT
NULL,
`power` int(11) NOT NULL,
`use` enum('0','1') NOT NULL,
`shina`
int(11) NOT NULL,
`tran` int(11) NOT NULL,
`porshni` int(11) NOT NULL,
`tormoza` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT
CHARSET=utf8;
--
-- Дамп данных таблицы
`garage`
--
INSERT INTO `garage` (`id`, `id_user`, `moto_id`, `moto_name`,
`moto_img`, `class`, `power`, `use`, `shina`, `tran`, `porshni`, `tormoza`)
VALUES
(1, 1, 2, 'Honda Transalp XL',
'/style/moto/Honda_Transalp_XL700V.png', 'D', 184, '0', 0, 0, 0, 0),
(2, 1,
1, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 'D', 179, '0', 0, 0,
0, 0),
(3, 25, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 380, '0', 5, 5, 5, 5),
(4, 25,
1, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 'D', 179, '0', 0, 0,
0, 0),
(5, 25, 2, 'Honda Transalp XL',
'/style/moto/Honda_Transalp_XL700V.png', 'D', 184, '0', 0, 0, 0, 0),
(6,
26, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(7, 27, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(8, 28,
0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png', 'D',
125, '1', 0, 0, 0, 0),
(9, 29, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(10,
30, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(11, 31, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(12,
32, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 1254, '1', 0, 0, 0, 0),
(13, 33, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(14,
20, 1, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 'D', 179, '0', 0,
0, 0, 0),
(15, 20, 2, 'Honda Transalp XL',
'/style/moto/Honda_Transalp_XL700V.png', 'D', 439, '1', 5, 5, 5, 5),
(16,
34, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(17, 18, 1, 'Kawasaki ZL',
'/style/moto/Kawasaki_ZL1000.png', 'D', 201, '1', 0, 0, 2, 1),
(18, 35, 0,
'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png', 'D', 125,
'1', 0, 0, 0, 0),
(19, 36, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '0', 0, 0, 0, 0),
(20,
36, 1, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 'D', 434, '1', 5,
5, 5, 5),
(21, 37, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(22,
38, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(23, 39, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(24,
10, 99, 'Honda Concept', '/style/moto/Honda_Concept.png', 'A', 769, '0', 0,
0, 0, 0),
(25, 40, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(26,
41, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(27, 42, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '0', 0, 0, 0, 0),
(28,
42, 2, 'Honda Transalp XL', '/style/moto/Honda_Transalp_XL700V.png', 'D',
184, '1', 0, 0, 0, 0),
(29, 42, 99, 'Honda Concept',
'/style/moto/Honda_Concept.png', 'A', 769, '0', 0, 0, 0, 0),
(30, 43, 0,
'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png', 'D', 171,
'1', 2, 3, 1, 1),
(31, 44, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(32,
14, 1, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 'D', 179, '1', 0,
0, 0, 0),
(33, 45, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '0', 0, 0, 0, 0),
(34,
45, 1, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 'D', 179, '1', 0,
0, 0, 0),
(35, 46, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(36, 1,
99, 'Honda Concept', '/style/moto/Honda_Concept.png', 'A', 769, '0', 0, 0,
0, 0),
(37, 47, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '0', 0, 0, 0, 0),
(38,
47, 1, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 'D', 179, '1', 0,
0, 0, 0),
(39, 48, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(40,
49, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(41, 50, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(42,
51, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '0', 0, 0, 0, 0),
(43, 51, 2, 'Honda Transalp XL',
'/style/moto/Honda_Transalp_XL700V.png', 'D', 184, '1', 0, 0, 0, 0),
(44,
52, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(45, 1, 9, 'Honda Concept',
'/style/moto/Honda_Concept.png', 'B', 777, '1', 0, 0, 0, 0),
(46, 53, 0,
'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png', 'D', 125,
'1', 0, 0, 0, 0),
(47, 54, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '0', 0, 0, 0, 0),
(48,
54, 9, 'Honda Concept', '/style/moto/Honda_Concept.png', 'B', 828, '1', 2,
2, 2, 2),
(49, 55, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0),
(50,
56, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '0', 0, 0, 0, 0),
(51, 56, 9, 'Honda Concept',
'/style/moto/Honda_Concept.png', 'B', 828, '1', 5, 2, 1, 0),
(52, 57, 0,
'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png', 'D', 125,
'0', 0, 0, 0, 0),
(53, 57, 99, 'Honda Concept',
'/style/moto/Honda_Concept.png', 'A', 806, '1', 3, 2, 1, 1),
(54, 57, 9,
'Honda Concept', '/style/moto/Honda_Concept.png', 'B', 777, '0', 0, 0, 0,
0),
(55, 58, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '0', 0, 0, 0, 0),
(56,
59, 0, 'Suzuki Street VanVan', '/style/moto/Suzuki_Street_VanVan.png',
'D', 125, '1', 0, 0, 0, 0),
(57, 58, 99, 'Honda Concept',
'/style/moto/Honda_Concept.png', 'A', 769, '1', 0, 0, 0, 0),
(58, 25, 9,
'Honda Concept', '/style/moto/Honda_Concept.png', 'B', 777, '1', 0, 0, 0,
0),
(59, 60, 0, 'Suzuki Street VanVan',
'/style/moto/Suzuki_Street_VanVan.png', 'D', 125, '1', 0, 0, 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `motorcykle`
--
CREATE TABLE IF NOT
EXISTS `motorcykle` (
`id` int(255) NOT NULL,
`moto_name` varchar(100)
CHARACTER SET utf8 NOT NULL,
`moto_img` varchar(150) CHARACTER SET utf8
NOT NULL,
`power` int(11) NOT NULL,
`price` int(11) NOT NULL,
`class`
set('A','B','C','D','E') CHARACTER SET utf8 NOT NULL,
`level` int(11) NOT
NULL,
`type` set('ex','default') NOT NULL,
`ogran` int(255) NOT NULL
COMMENT 'Если type = ex, то выставляем
ограничение '
) ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT
CHARSET=latin1;
--
-- Дамп данных таблицы
`motorcykle`
--
INSERT INTO `motorcykle` (`id`, `moto_name`, `moto_img`,
`power`, `price`, `class`, `level`, `type`, `ogran`) VALUES
(1, 'Kawasaki
ZL', '/style/moto/Kawasaki_ZL1000.png', 179, 4500, 'D', 1, 'default',
0),
(2, 'Honda Transalp XL', '/style/moto/Honda_Transalp_XL700V.png', 184,
5000, 'D', 1, 'default', 0),
(3, 'Ducati Monster 400',
'/style/moto/Ducati_Monster_400.png', 190, 6000, 'D', 2, 'default', 0),
(4,
'Honda FURY', '/style/moto/Honda_FURY.png', 199, 6100, 'D', 2, 'default',
0),
(5, 'Yamaha FZ6-S S2', '/style/moto/Yamaha_FZ6-N.png', 212, 7000, 'D',
3, 'default', 0),
(6, 'Yamaha XV1900A Midnight Star',
'/style/moto/Yamaha_XV1900A_Midnight_Star.png', 211, 8300, 'D', 3,
'default', 0),
(7, 'Suzuki Street Gladius',
'/style/moto/Suzuki_Street_Gladius.png', 238, 10000, 'C', 4, 'default',
0),
(8, 'Kawasaki Ninja 250R', '/style/moto/Kawasaki_Ninja_250R.png', 246,
11900, 'C', 4, 'default', 0),
(9, 'Honda Concept',
'/style/moto/Honda_Concept.png', 777, 0, 'B', 1, 'ex', 8);
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(255) NOT NULL,
`msg` text NOT NULL,
`time` int(255)
NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
--
--
Дамп данных таблицы `news`
--
INSERT INTO `news` (`id`,
`msg`, `time`) VALUES
(1, '', 0),
(2, '', 0),
(3, '', 0),
(4, ':01:',
1419169623),
(5, ':01:', 1419169626),
(6, ':01::01:', 1419169667),
(7,
'Добавлены новости короче, че
:09::08::08::08::08:', 1419170024),
(8, 'Добавлены гонки
/race:01::02:', 1419244363);
--
--------------------------------------------------------
--
--
Структура таблицы `race`
--
CREATE TABLE IF NOT EXISTS
`race` (
`id` int(255) NOT NULL,
`id_racer` int(255) NOT NULL,
`id_user` int(255) NOT NULL,
`time` int(255) NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;
--
-- Дамп данных
таблицы `race`
--
INSERT INTO `race` (`id`, `id_racer`, `id_user`,
`time`) VALUES
(1, 41, 1, 1419251695),
(2, 41, 1, 1419251696),
(3, 41, 1,
1419251697),
(4, 36, 1, 1419251699),
(5, 43, 54, 1419251753),
(6, 24, 54,
1419251757),
(7, 24, 54, 1419251758),
(8, 24, 54, 1419251759),
(9, 12, 54,
1419251763),
(10, 12, 54, 1419251765),
(11, 12, 54, 1419251766),
(12, 42,
54, 1419251769),
(13, 3, 54, 1419251772),
(14, 3, 54, 1419251773),
(15, 52,
1, 1419253175),
(16, 16, 56, 1419256150),
(17, 16, 56, 1419256153),
(18,
16, 56, 1419256154),
(19, 35, 56, 1419256160),
(20, 40, 56,
1419256161),
(21, 40, 56, 1419256162),
(22, 40, 56, 1419256163),
(23, 46,
56, 1419256169),
(24, 46, 56, 1419256170),
(25, 46, 56, 1419256171),
(26,
15, 57, 1419257654),
(27, 15, 57, 1419257660),
(28, 15, 57,
1419257666),
(29, 45, 57, 1419257673),
(30, 45, 57, 1419257679),
(31, 45,
57, 1419257683),
(32, 46, 57, 1419257691),
(33, 46, 57, 1419257694),
(34,
46, 57, 1419257696),
(35, 7, 57, 1419257709),
(36, 3, 45, 1419259444),
(37,
3, 45, 1419259456),
(38, 3, 45, 1419259460),
(39, 53, 58, 1419260525),
(40,
11, 58, 1419260595),
(41, 11, 58, 1419260597),
(42, 11, 58,
1419260598),
(43, 17, 58, 1419260606),
(44, 17, 58, 1419260607),
(45, 17,
58, 1419260608),
(46, 24, 58, 1419260615),
(47, 24, 58, 1419260616),
(48,
24, 58, 1419260617),
(49, 6, 58, 1419260622),
(50, 5, 25, 1419261483),
(51,
5, 25, 1419261488),
(52, 5, 25, 1419261491),
(53, 29, 25, 1419261498),
(54,
29, 25, 1419261501),
(55, 29, 25, 1419261503),
(56, 19, 25,
1419261508),
(57, 19, 25, 1419261511),
(58, 19, 25, 1419261513),
(59, 52,
60, 1419261965),
(60, 52, 60, 1419261970),
(61, 52, 60, 1419261973),
(62,
57, 60, 1419261978),
(63, 57, 60, 1419261981),
(64, 57, 60,
1419261983),
(65, 40, 25, 1419262465);
--
--------------------------------------------------------
--
--
Структура таблицы `report`
--
CREATE TABLE IF NOT EXISTS
`report` (
`id` int(11) NOT NULL,
`id_user` int(255) NOT NULL,
`time`
int(255) NOT NULL,
`moto_name` varchar(155) NOT NULL,
`moto_img`
varchar(155) NOT NULL,
`power` int(11) NOT NULL,
`class` varchar(15)
NOT NULL,
`type` set('ex','default') NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
--
-- Дамп данных
таблицы `report`
--
INSERT INTO `report` (`id`, `id_user`, `time`,
`moto_name`, `moto_img`, `power`, `class`, `type`) VALUES
(1, 1,
1419173566, 'Honda Concept', '/style/moto/Honda_Concept.png', 777, 'B',
'ex'),
(2, 1, 1419174909, 'Honda Transalp XL',
'/style/moto/Honda_Transalp_XL700V.png', 184, 'D', 'ex'),
(3, 1,
1419174912, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 179, 'D',
'default'),
(4, 25, 1419180284, 'Kawasaki ZL',
'/style/moto/Kawasaki_ZL1000.png', 179, 'D', 'default'),
(5, 25,
1419180301, 'Honda Transalp XL', '/style/moto/Honda_Transalp_XL700V.png',
184, 'D', 'default'),
(6, 20, 1419190161, 'Kawasaki ZL',
'/style/moto/Kawasaki_ZL1000.png', 179, 'D', 'default'),
(7, 20,
1419190170, 'Honda Transalp XL', '/style/moto/Honda_Transalp_XL700V.png',
184, 'D', 'default'),
(8, 18, 1419190880, 'Kawasaki ZL',
'/style/moto/Kawasaki_ZL1000.png', 179, 'D', 'default'),
(9, 36,
1419192184, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 179, 'D',
'default'),
(10, 42, 1419201181, 'Honda Transalp XL',
'/style/moto/Honda_Transalp_XL700V.png', 184, 'D', 'default'),
(11, 14,
1419222030, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 179, 'D',
'default'),
(12, 45, 1419227845, 'Kawasaki ZL',
'/style/moto/Kawasaki_ZL1000.png', 179, 'D', 'default'),
(13, 47,
1419231266, 'Kawasaki ZL', '/style/moto/Kawasaki_ZL1000.png', 179, 'D',
'default'),
(14, 51, 1419241449, 'Honda Transalp XL',
'/style/moto/Honda_Transalp_XL700V.png', 184, 'D', 'default'),
(15, 1,
1419245512, 'Honda Concept', '/style/moto/Honda_Concept.png', 777, 'B',
''),
(16, 54, 1419251789, 'Honda Concept', '/style/moto/Honda_Concept.png',
777, 'B', ''),
(17, 56, 1419256191, 'Honda Concept',
'/style/moto/Honda_Concept.png', 777, 'B', ''),
(18, 57, 1419257512, 'Honda
Concept', '/style/moto/Honda_Concept.png', 777, 'B', ''),
(19, 25,
1419261540, 'Honda Concept', '/style/moto/Honda_Concept.png', 777, 'B',
'');
-- --------------------------------------------------------
--
--
Структура таблицы `user`
--
CREATE TABLE IF NOT EXISTS
`user` (
`id` int(255) NOT NULL,
`nick` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`prava` set('1','2','3','4') NOT NULL,
`money` int(255) NOT NULL,
`turnirochki` int(255) NOT NULL,
`opit`
int(255) NOT NULL,
`raiting` int(255) NOT NULL,
`level` int(11) NOT
NULL,
`fuel` int(11) NOT NULL,
`bar_banned` set('0','1') NOT NULL,
`online` int(255) NOT NULL,
`place` int(11) NOT NULL,
`avatar`
varchar(155) NOT NULL,
`mail` varchar(155) NOT NULL,
`jobs_time`
int(255) NOT NULL,
`jobs_money` int(255) NOT NULL,
`identityq`
varchar(100) DEFAULT NULL,
`type_regq` varchar(100) DEFAULT NULL
)
ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
--
-- Дамп
данных таблицы `user`
--
INSERT INTO `user` (`id`, `nick`,
`password`, `prava`, `money`, `turnirochki`, `opit`, `raiting`, `level`,
`fuel`, `bar_banned`, `online`, `place`, `avatar`, `mail`, `jobs_time`,
`jobs_money`, `identityq`, `type_regq`) VALUES
(1, 'TJersy',
'7a12a47984333222320df4510947fbdd', '4', 228232, 210, 382, 959, 4, 9300,
'', 1419264032, 17, '/style/img/no_avatar.png', '', 0, 4000, NULL,
NULL),
(2, 'TJersy2', '030da2a82020255e2f466d39061d52bb', '1', 16400, 0, 0,
0, 1, 100, '', 1416395305, 9, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(3, 'GT Racer', '056aaa8d81e3549efbb23bb472b00c19', '1', 200, 0, 0,
0, 1, 100, '', 1419234968, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(4, 'Asadal', '6bb017c5ca9a1da355db81db6c62bfc0', '1', 13000, 0, 0,
0, 1, 100, '', 1419205353, 4, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(5, 'HukotuH', '93279e3308bdbbeed946fc965017f67a', '1', 0, 0, 0, 0,
1, 100, '', 1419155089, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(7, 'Tolya', '96e79218965eb72c92a549dd5a330112', '1', 0, 0, 0, 0, 1,
100, '', 1419253392, 4, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(6, 'славик', '2b273b48d465b2fc3b3e67d344bd4ebd', '1', 15000,
0, 0, 0, 1, 100, '', 1419224325, 3, '/style/img/no_avatar.png', '', 0, 0,
NULL, NULL),
(8, 'lol', '343b1c4a3ea721b2d640fc8700db0f36', '1', 15000, 0,
0, 0, 1, 100, '', 1419155489, 3, '/style/img/no_avatar.png', '', 0, 0,
NULL, NULL),
(9, 'Antares', 'ee7ae1de1c81626bf66f6adda4e66170', '1', 15000,
0, 0, 0, 1, 100, '', 1419156597, 3, '/style/img/no_avatar.png', '', 0, 0,
NULL, NULL),
(10, 'tester', 'f5d1278e8109edd94e1e4197e04873b9', '1', 29562,
0, 0, 0, 1, 100, '', 1419196034, 4, '/style/img/no_avatar.png', '', 0, 0,
NULL, NULL),
(11, 'elfi', '4297f44b13955235245b2497399d7a93', '1', 18000,
0, 0, 0, 1, 100, '', 1419189527, 3, '/style/img/no_avatar.png', '', 0, 0,
NULL, NULL),
(12, 'kingster', 'e10adc3949ba59abbe56e057f20f883e', '1',
16307, 0, 0, 0, 1, 100, '', 1419161171, 5, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(13, 'viktor', 'fc7fc678608590b123692867f176fe63', '1',
10000, 0, 0, 0, 1, 100, '', 1419156556, 3, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(14, 'Turk', '7627cb9027e713e301e83a8f13057055', '1',
15500, 0, 0, 0, 1, 100, '', 1419222042, 3, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(15, 'ByCoder', '1c53b67b7383473fd09d472e7209ef5f', '1',
15000, 0, 0, 0, 1, 100, '', 1419158127, 3, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(16, 'Дима Белов',
'5b4b3e2e2ab030da3c002a091eaf37c9', '1', 15000, 0, 0, 0, 1, 100, '',
1419158019, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(17,
'Workout', '3f3ee42f7b10f8690165255c8aed8391', '1', 10000, 0, 0, 0, 1, 100,
'', 1419192728, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(18,
'Eclipse', 'e346f8a3f9472faa727714816e72cf84', '1', 1800, 0, 0, 0, 1, 100,
'', 1419205156, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(19,
'gggfyyfxd', '2421051ce66858cf39bd91b5509a944d', '1', 15000, 0, 0, 0, 1,
100, '', 1419161524, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(20, 'Lari', 'd8578edf8458ce06fbc5bb76a58c5ca4', '1', 700, 0, 0, 0,
1, 100, '', 1419207713, 4, '/style/img/no_avatar.png', '', 1419219042,
12000, NULL, NULL),
(21, 'ghudd143g', '920b7320f1d059163f09bd0d08d26f62',
'1', 15000, 0, 0, 0, 1, 100, '', 1419162083, 3, '/style/img/no_avatar.png',
'', 0, 0, NULL, NULL),
(22, 'серон',
'e10adc3949ba59abbe56e057f20f883e', '1', 15000, 0, 0, 0, 1, 100, '',
1419164664, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(23,
'InstalScript', '52a186e5f5207e7b66723b2a21590924', '1', 15000, 0, 0, 0, 1,
100, '', 1419220818, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(24, 'ruslan', 'efe6398127928f1b2e9ef3207fb82663', '1', 5200, 0, 0,
0, 1, 100, '', 1419165503, 10, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(25, 'admin1', 'e10adc3949ba59abbe56e057f20f883e', '1', 650600, 0,
50, 30, 1, 0, '', 1419262468, 18, '/style/img/no_avatar.png', '', 0, 0,
NULL, NULL),
(26, 'DumBass', 'a756bf4c73b83fc6193951ebe6280d3c', '1',
15000, 0, 0, 0, 1, 100, '', 1419182377, 3, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(27, 'дима', 'e10adc3949ba59abbe56e057f20f883e',
'1', 15000, 0, 0, 0, 1, 100, '', 1419182800, 3, '/style/img/no_avatar.png',
'', 0, 0, NULL, NULL),
(28, 'TJersyс', 'b7aad2c8336c6295767ee2c78078b954',
'1', 25000, 0, 0, 0, 1, 100, '', 1419190835, 3, '/style/img/no_avatar.png',
'', 1419216766, 12000, NULL, NULL),
(29, 'david',
'3fc0a7acf087f549ac2b266baf94b8b1', '1', 15000, 0, 0, 0, 1, 100, '',
1419188563, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(30,
'AdMiPaJI', 'd3a0a54161e7a9346e71c5d4864a0641', '1', 35000, 0, 0, 0, 1,
100, '', 1419188675, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(31, 'йцуйцу', '4297f44b13955235245b2497399d7a93', '1', 15000,
0, 0, 0, 1, 100, '', 1419188953, 3, '/style/img/no_avatar.png', '', 0, 0,
NULL, NULL),
(32, 'апроста', '96e79218965eb72c92a549dd5a330112',
'1', 15000, 0, 0, 0, 1, 100, '', 1419188953, 3, '/style/img/no_avatar.png',
'', 0, 0, NULL, NULL),
(33, 'mir007', '05c6e08059c383a74ca10751d96fc92c',
'1', 15000, 0, 0, 0, 1, 100, '', 1419189735, 3, '/style/img/no_avatar.png',
'', 1419193176, 1000, NULL, NULL),
(34, 'link',
'e10adc3949ba59abbe56e057f20f883e', '1', 15000, 0, 0, 0, 1, 100, '',
1419190398, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(35,
'djston', '7ffe7113e626549cd7c13cc93245ed67', '1', 14200, 0, 0, 0, 1, 100,
'', 1419192234, 4, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(36,
'121212', '93279e3308bdbbeed946fc965017f67a', '1', 500, 0, 0, 0, 1, 100,
'', 1419192460, 4, '/style/img/no_avatar.png', '', 1419195866, 1000, NULL,
NULL),
(37, 'dsadas', 'e10adc3949ba59abbe56e057f20f883e', '1', 15000, 0, 0,
0, 1, 100, '', 1419192473, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(38, 'Qwerty', 'd8578edf8458ce06fbc5bb76a58c5ca4', '1', 15000, 0, 0,
0, 1, 100, '', 1419251724, 3, '/style/img/no_avatar.png', '', 1419196089,
1000, NULL, NULL),
(39, 'лиза', 'f379eaf3c831b04de153469d1bec345e',
'1', 15000, 0, 0, 0, 1, 100, '', 1419193963, 3, '/style/img/no_avatar.png',
'', 1419208352, 4000, NULL, NULL),
(40, 'adjaga',
'243aef8dd8f147e7dcc824fa94d7efc7', '1', 15000, 0, 0, 0, 1, 100, '',
1419197270, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(41,
'Steam', 'd8578edf8458ce06fbc5bb76a58c5ca4', '1', 15000, 0, 0, 0, 1, 100,
'', 1419201126, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(42,
'Razz', '4297f44b13955235245b2497399d7a93', '1', 2800, 0, 0, 0, 1, 100, '',
1419201317, 6, '/style/img/no_avatar.png', '', 1419204917, 1000, NULL,
NULL),
(43, 'rrrr', 'ff2f24f8b6d253bb5a8bc55728ca7372', '1', 2600, 0, 0, 0,
1, 100, '', 1419211321, 4, '/style/img/no_avatar.png', '', 1419214710,
1000, NULL, NULL),
(44, 'komer', '5b1b68a9abf4d2cd155c81a9225fd158', '1',
9000, 0, 0, 0, 1, 100, '', 1419213914, 3, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(45, 'turok', '3a715498b51a468e87e07820b3e72734', '1',
12000, 0, 15, 9, 1, 70, '', 1419259467, 3, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(46, 'javatk', '6cf0c7bcc90a984a1fd84c57b68a6839', '1',
15000, 0, 0, 0, 1, 100, '', 1419228989, 3, '/style/img/no_avatar.png', '',
0, 0, NULL, NULL),
(47, 'ewane', '1f0ded86ba62a3742aa99fac87d0b2e2', '1',
9700, 0, 0, 0, 1, 100, '', 1419231273, 4, '/style/img/no_avatar.png', '',
1419234873, 1000, NULL, NULL),
(48, 'dggdgr',
'd8578edf8458ce06fbc5bb76a58c5ca4', '1', 15000, 0, 0, 0, 1, 100, '',
1419231821, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(49,
'Апсу Жан', '3f36e57a14dc76bc476c5a0828440e47', '1', 15000, 0, 0, 0,
1, 100, '', 1419237828, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(50, 'retr', '907f333c9693695608c77110df027743', '1', 15000, 0, 0,
0, 1, 100, '', 1419238592, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(51, 'Admin', 'd0970714757783e6cf17b26fb8e2298f', '1', 10500, 0, 5,
3, 1, 90, '', 1419241508, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(52, 'Boss', '7adaa756553ba9eb6a235080f6263b5b', '1', 15000, 0, 0,
0, 1, 100, '', 1419241789, 3, '/style/img/no_avatar.png', '', 0, 0, NULL,
NULL),
(53, 'Gamet', 'd8578edf8458ce06fbc5bb76a58c5ca4', '1', 15000, 0, 0,
0, 1, 100, '', 1419250344, 3, '/style/img/no_avatar.png', '', 1419279143,
12000, NULL, NULL),
(54, 'qwertyy', 'd8578edf8458ce06fbc5bb76a58c5ca4',
'1', 56720, 0, 42, 22, 1, 0, '', 1419253199, 3, '/style/img/no_avatar.png',
'', 0, 0, NULL, NULL),
(55, 'Wizard', 'cb1e42b018ff5b96a8378382c8e22bf9',
'1', 15000, 0, 0, 0, 1, 100, '', 1419254930, 3, '/style/img/no_avatar.png',
'', 1419258430, 1000, NULL, NULL),
(56, 'Qwadro',
'e10adc3949ba59abbe56e057f20f883e', '1', 200, 0, 50, 30, 1, 0, '',
1419256288, 4, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(57,
'fantom', '4297f44b13955235245b2497399d7a93', '1', 900, 0, 50, 30, 1, 0,
'', 1419257844, 6, '/style/img/no_avatar.png', '', 1419261375, 1000, NULL,
NULL),
(58, 'optimist', 'bfbb8a09028c62e1a516f7c40aba4e35', '1', 500, 0,
55, 33, 1, 0, '', 1419260744, 7, '/style/img/no_avatar.png', '',
1419289310, 12000, NULL, NULL),
(59, 'тстстс',
'd0970714757783e6cf17b26fb8e2298f', '1', 15000, 0, 0, 0, 1, 100, '',
1419260425, 3, '/style/img/no_avatar.png', '', 0, 0, NULL, NULL),
(60,
'Navi|1hp[TGK]', '9d9d89e213217c08c7d634a0fc23dd04', '1', 17100, 0, 18, 6,
1, 40, '', 1419263596, 3, '/style/img/no_avatar.png', '', 1419290750,
12000, NULL, NULL);
--
--------------------------------------------------------
--
--
Структура таблицы `worldkassa`
--
CREATE TABLE IF NOT
EXISTS `worldkassa` (
`id` int(11) unsigned NOT NULL COMMENT 'ID
платежа (Внутренний ID)',
`id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned
NOT NULL COMMENT 'ID платежа в Worldkassa',
`time` int(11)
unsigned NOT NULL COMMENT 'Время инициализации
платежа',
`time_oplata` int(11) unsigned DEFAULT '0' COMMENT
'Время оплаты',
`summa` decimal(11,2) NOT NULL DEFAULT '0.00'
COMMENT 'Сумма'
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=utf8
COMMENT='Статистика платежей через
WorldKassa';
--
-- Дамп данных таблицы
`worldkassa`
--
INSERT INTO `worldkassa` (`id`, `id_user`, `id_bill`,
`time`, `time_oplata`, `summa`) VALUES
(1, 1, 40249, 1419172445, 0,
'10.00'),
(2, 1, 40251, 1419172543, 0, '50.00'),
(3, 1, 40252, 1419172629,
1419172630, '10.00'),
(4, 1, 40253, 1419172635, 1419172636, '1000.00'),
(5,
1, 40254, 1419172713, 1419172714, '10.00'),
(6, 1, 40256, 1419172764,
1419172765, '250.00'),
(7, 1, 40259, 1419172894, 1419172895, '500.00'),
(8,
25, 40279, 1419177261, 1419177293, '10.00'),
(9, 25, 40280, 1419177304,
1419177307, '1000.00'),
(10, 25, 40281, 1419177314, 1419177317,
'1000.00'),
(11, 25, 40282, 1419177324, 1419177328, '1000.00'),
(12, 25,
40283, 1419177336, 1419177340, '1000.00'),
(13, 25, 40285, 1419177357,
1419177359, '1000.00'),
(14, 25, 40286, 1419177543, 1419177552,
'1000.00'),
(15, 25, 40287, 1419177562, 0, '10.00'),
(16, 25, 40288,
1419177563, 0, '10.00'),
(17, 25, 40289, 1419177563, 0, '10.00'),
(18, 25,
40290, 1419177563, 0, '10.00'),
(19, 25, 40291, 1419177564, 1419177573,
'10.00'),
(20, 25, 40292, 1419177583, 0, '1000.00'),
(21, 25, 40293,
1419177583, 0, '1000.00'),
(22, 25, 40294, 1419177583, 1419177590,
'1000.00'),
(23, 25, 40295, 1419177583, 0, '1000.00'),
(24, 25, 40296,
1419177583, 0, '1000.00'),
(25, 25, 40307, 1419180206, 1419180212,
'1000.00'),
(26, 25, 40315, 1419181082, 0, '1000.00'),
(27, 25, 40356,
1419183681, 1419183685, '1000.00'),
(28, 25, 40406, 1419187638, 1419190582,
'1000.00'),
(29, 30, 40410, 1419188665, 1419188667, '1000.00'),
(30, 30,
40411, 1419188671, 1419188674, '1000.00'),
(31, 11, 40414, 1419189500,
1419189502, '1000.00'),
(32, 20, 40416, 1419190095, 0, '500.00'),
(33, 20,
40417, 1419190098, 1419190106, '1000.00'),
(34, 20, 40419, 1419190266,
1419190457, '1000.00'),
(35, 28, 40421, 1419190705, 1419190706,
'1000.00'),
(36, 25, 40428, 1419191801, 1419191805, '1000.00'),
(37, 36,
40431, 1419192278, 1419192281, '1000.00'),
(38, 36, 40432, 1419192313,
1419192322, '1000.00'),
(39, 36, 40433, 1419192327, 1419192328,
'1000.00'),
(40, 36, 40434, 1419192348, 1419192357, '1000.00'),
(41, 36,
40435, 1419192362, 0, '1000.00'),
(42, 36, 40436, 1419192363, 0,
'1000.00'),
(43, 36, 40437, 1419192364, 0, '1000.00'),
(44, 36, 40438,
1419192364, 0, '1000.00'),
(45, 36, 40439, 1419192364, 0, '1000.00'),
(46,
36, 40440, 1419192365, 0, '1000.00'),
(47, 36, 40441, 1419192366, 0,
'1000.00'),
(48, 36, 40442, 1419192366, 0, '1000.00'),
(49, 36, 40443,
1419192367, 0, '1000.00'),
(50, 36, 40444, 1419192367, 0, '1000.00'),
(51,
36, 40445, 1419192368, 0, '1000.00'),
(52, 36, 40446, 1419192368, 0,
'1000.00'),
(53, 36, 40447, 1419192368, 0, '1000.00'),
(54, 36, 40448,
1419192369, 1419192370, '1000.00'),
(55, 36, 40449, 1419192374, 1419192376,
'1000.00'),
(56, 23, 40508, 1419220792, 0, '1000.00'),
(57, 14, 40511,
1419222002, 1419222007, '500.00'),
(58, 1, 40560, 1419244470, 1419244472,
'1000.00'),
(59, 1, 40561, 1419244791, 1419244877, '500.00'),
(60, 54,
40598, 1419251883, 0, '1000.00'),
(61, 25, 40694, 1419261554, 0,
'1000.00');
--
-- Indexes for dumped tables
--
--
-- Indexes for table
`chat`
--
ALTER TABLE `chat`
ADD PRIMARY KEY (`id`);
--
-- Indexes for
table `garage`
--
ALTER TABLE `garage`
ADD PRIMARY KEY (`id`);
--
--
Indexes for table `motorcykle`
--
ALTER TABLE `motorcykle`
ADD PRIMARY KEY
(`id`);
--
-- Indexes for table `news`
--
ALTER TABLE `news`
ADD PRIMARY
KEY (`id`);
--
-- Indexes for table `race`
--
ALTER TABLE `race`
ADD
PRIMARY KEY (`id`);
--
-- Indexes for table `report`
--
ALTER TABLE
`report`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user`
--
ALTER
TABLE `user`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table
`worldkassa`
--
ALTER TABLE `worldkassa`
ADD PRIMARY KEY (`id`);
--
--
AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table
`chat`
--
ALTER TABLE `chat`
MODIFY `id` int(255) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT for table
`garage`
--
ALTER TABLE `garage`
MODIFY `id` int(255) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=60;
--
-- AUTO_INCREMENT for table
`motorcykle`
--
ALTER TABLE `motorcykle`
MODIFY `id` int(255) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=314;
--
-- AUTO_INCREMENT for table
`news`
--
ALTER TABLE `news`
MODIFY `id` int(255) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table
`race`
--
ALTER TABLE `race`
MODIFY `id` int(255) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=66;
--
-- AUTO_INCREMENT for table
`report`
--
ALTER TABLE `report`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table
`user`
--
ALTER TABLE `user`
MODIFY `id` int(255) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=61;
--
-- AUTO_INCREMENT for table
`worldkassa`
--
ALTER TABLE `worldkassa`
MODIFY `id` int(11) unsigned NOT
NULL AUTO_INCREMENT COMMENT 'ID платежа (Внутренний
ID)',AUTO_INCREMENT=62;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;