Файл: public_html/tablik_besp.sql
Строк: 463
-- phpMyAdmin SQL Dump
-- version 4.0.5
-- http://www.phpmyadmin.net
--
--
Хост: 127.0.0.1:3306
-- Время создания: Янв 06 2015
г., 23:20
-- Версия сервера: 5.1.71-community-log
--
Версия PHP: 5.4.17
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 */;
--
-- База данных: `pro`
--
--
--------------------------------------------------------
--
--
Структура таблицы `arena`
--
CREATE TABLE IF NOT EXISTS
`arena` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`time` int(11)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=15 ;
--
-- Дамп данных
таблицы `arena`
--
INSERT INTO `arena` (`id`, `user`, `opponent`,
`time`) VALUES
(1, 1, 2, 1420399712),
(2, 2, 1, 1420325245),
(3, 3, 2,
1420404707),
(4, 7, 5, 1420459424),
(5, 8, 4, 1420459564),
(6, 9, 5,
1420459647),
(7, 10, 6, 0),
(8, 11, 7, 0),
(9, 12, 6, 1420460232),
(10, 14,
4, 0),
(11, 15, 5, 1420460864),
(12, 16, 11, 1420462263),
(13, 17, 3,
1420462444),
(14, 21, 20, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `ban`
--
CREATE TABLE IF NOT EXISTS
`ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `block`
--
CREATE TABLE IF NOT EXISTS
`block` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`ip` text,
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `boss`
--
CREATE TABLE IF NOT EXISTS
`boss` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lvl` int(11) NOT
NULL,
`sila` int(11) NOT NULL,
`health` int(11) NOT NULL,
`lovk`
int(11) NOT NULL,
`zashit` int(11) NOT NULL,
`gold` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`image` varchar(20) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1 AUTO_INCREMENT=47 ;
--
-- Дамп данных
таблицы `boss`
--
INSERT INTO `boss` (`id`, `name`, `lvl`, `sila`,
`health`, `lovk`, `zashit`, `gold`, `exp`, `image`) VALUES
(31,
'Огненный пес', 1, 340, 450, 250, 200, 1, 60, '1'),
(33, '
Горлум', 35, 5357, 5462, 5547, 5297, 8, 560, '9'),
(34, 'Рыцырь
смерти', 5, 750, 800, 650, 700, 2, 100, '2'),
(35, 'Палач', 10,
950, 1050, 960, 950, 3, 200, '3'),
(36, 'Горгулья', 15, 1650, 1731,
1550, 1700, 4, 280, '4'),
(37, 'Змей', 20, 3050, 3500, 2520, 2510, 5,
360, '5'),
(38, 'Минотавр', 25, 3500, 3850, 3550, 3600, 6, 420,
'6'),
(39, 'Повелитель огня', 30, 4520, 4071, 4347, 4254, 7,
480, '7'),
(40, 'Варлорд', 40, 6463, 6724, 6645, 6754, 10, 1000,
'10');
-- --------------------------------------------------------
--
--
Структура таблицы `cave`
--
CREATE TABLE IF NOT EXISTS
`cave` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`dawn` enum('0','1') NOT NULL DEFAULT '0',
`res_1` int(11)
NOT NULL DEFAULT '0',
`res_1_chanse` int(11) NOT NULL DEFAULT '0',
`res_2` int(11) NOT NULL DEFAULT '0',
`res_2_chanse` int(11) NOT NULL
DEFAULT '0',
`res_3` int(11) NOT NULL DEFAULT '0',
`res_3_chanse`
int(11) NOT NULL DEFAULT '0',
`gather` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;
--
-- Дамп данных
таблицы `cave`
--
INSERT INTO `cave` (`id`, `user`, `dawn`,
`res_1`, `res_1_chanse`, `res_2`, `res_2_chanse`, `res_3`, `res_3_chanse`,
`gather`, `time`) VALUES
(1, 1, '1', 0, 22, 0, 2, 0, 11, 0,
1420464031),
(2, 3, '1', 8, 14, 9, 9, 3, 17, 0, 1420414831),
(3, 4, '1', 0,
0, 0, 0, 0, 0, 0, 1420449437);
--
--------------------------------------------------------
--
--
Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS
`chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`to` int(11) NOT NULL DEFAULT '0',
`text` text,
`time`
int(11) NOT NULL DEFAULT '0',
`read` enum('0','1') NOT NULL DEFAULT '0',
`clan` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;
--
-- Дамп данных
таблицы `chat`
--
INSERT INTO `chat` (`id`, `user`, `to`, `text`,
`time`, `read`, `clan`) VALUES
(2, 1, 0, '1', 1420391733, '0', 1),
(3, 1,
0, '1', 1420391741, '0', 0);
--
--------------------------------------------------------
--
--
Структура таблицы `clans`
--
CREATE TABLE IF NOT EXISTS
`clans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100)
DEFAULT NULL,
`gerb` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT
NULL DEFAULT '1',
`exp` int(11) NOT NULL DEFAULT '0',
`g` int(11) NOT
NULL DEFAULT '0',
`s` int(11) NOT NULL DEFAULT '0',
`r` enum('0','1')
NOT NULL DEFAULT '0',
`rank_for_invite` enum('0','1','2','3','4') NOT
NULL DEFAULT '0',
`rank_for_delete` enum('0','1','2','3','4') NOT NULL
DEFAULT '0',
`built_1` int(11) NOT NULL DEFAULT '0',
`built_2` int(11)
NOT NULL DEFAULT '0',
`built_2_time` int(11) NOT NULL DEFAULT '0',
`built_3` int(11) NOT NULL DEFAULT '0',
`built_3_time` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы
`clans`
--
INSERT INTO `clans` (`id`, `name`, `gerb`, `level`, `exp`, `g`,
`s`, `r`, `rank_for_invite`, `rank_for_delete`, `built_1`, `built_2`,
`built_2_time`, `built_3`, `built_3_time`) VALUES
(1, 'Цитадель
Сатаны', 0, 7, 0, 98199, 220000, '0', '2', '0', 7, 0, 0, 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `clan_invite`
--
CREATE TABLE IF NOT
EXISTS `clan_invite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan`
int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3
;
--
-- Дамп данных таблицы `clan_invite`
--
INSERT INTO
`clan_invite` (`id`, `clan`, `user`) VALUES
(1, 1, 2),
(2, 1, 16);
--
--------------------------------------------------------
--
--
Структура таблицы `clan_memb`
--
CREATE TABLE IF NOT
EXISTS `clan_memb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan`
int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
`rank` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`g` int(11) NOT
NULL DEFAULT '0',
`s` int(11) NOT NULL DEFAULT '0',
`exp` int(11) NOT
NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`last_update`
int(11) NOT NULL DEFAULT '0',
`v` int(11) NOT NULL DEFAULT '0',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2
;
--
-- Дамп данных таблицы `clan_memb`
--
INSERT INTO
`clan_memb` (`id`, `clan`, `user`, `rank`, `g`, `s`, `exp`, `time`,
`last_update`, `v`) VALUES
(1, 1, 1, '4', 0, 0, 1943, 1418940650,
1420495850, 51);
--
--------------------------------------------------------
--
--
Структура таблицы `clan_msg`
--
CREATE TABLE IF NOT EXISTS
`clan_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan` int(11) NOT
NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
`text` text,
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Дамп данных
таблицы `clan_msg`
--
INSERT INTO `clan_msg` (`id`, `clan`, `user`,
`text`, `time`) VALUES
(1, 1, 1, 'Тест', 1420394080);
--
--------------------------------------------------------
--
--
Структура таблицы `clan_msg_read`
--
CREATE TABLE IF NOT
EXISTS `clan_msg_read` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg`
int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2
;
--
-- Дамп данных таблицы `clan_msg_read`
--
INSERT
INTO `clan_msg_read` (`id`, `msg`, `user`) VALUES
(1, 1, 1);
--
--------------------------------------------------------
--
--
Структура таблицы `coliseum`
--
CREATE TABLE IF NOT EXISTS
`coliseum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`start`
enum('0','1') NOT NULL DEFAULT '0',
`end` enum('0','1') NOT NULL DEFAULT
'0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Дамп
данных таблицы `coliseum`
--
INSERT INTO `coliseum` (`id`,
`start`, `end`, `time`) VALUES
(1, '0', '0', 1420389994);
--
--------------------------------------------------------
--
--
Структура таблицы `coliseum_log`
--
CREATE TABLE IF NOT
EXISTS `coliseum_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`battle`
int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
`text` text,
`show` int(11) NOT NULL DEFAULT '0',
`object` int(11) NOT
NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `coliseum_member`
--
CREATE TABLE IF NOT
EXISTS `coliseum_member` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`battle` int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT
'0',
`object` int(11) NOT NULL DEFAULT '0',
`kills` int(11) NOT NULL
DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`exit` enum('0','1')
NOT NULL DEFAULT '0',
`dead` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2
;
--
-- Дамп данных таблицы `coliseum_member`
--
INSERT
INTO `coliseum_member` (`id`, `battle`, `user`, `object`, `kills`, `time`,
`exit`, `dead`) VALUES
(1, 1, 1, 0, 0, 1419261209, '0', '0');
--
--------------------------------------------------------
--
--
Структура таблицы `complects`
--
CREATE TABLE IF NOT
EXISTS `complects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`name`
varchar(100) DEFAULT NULL,
`w_1` int(11) NOT NULL DEFAULT '0',
`w_2`
int(11) NOT NULL DEFAULT '0',
`w_3` int(11) NOT NULL DEFAULT '0',
`w_4`
int(11) NOT NULL DEFAULT '0',
`w_5` int(11) NOT NULL DEFAULT '0',
`w_6`
int(11) NOT NULL DEFAULT '0',
`w_7` int(11) NOT NULL DEFAULT '0',
`w_8`
int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=54 ;
--
-- Дамп данных
таблицы `complects`
--
INSERT INTO `complects` (`id`, `quality`,
`name`, `w_1`, `w_2`, `w_3`, `w_4`, `w_5`, `w_6`, `w_7`, `w_8`) VALUES
(1,
'1', 'Старый', 1, 2, 3, 4, 5, 6, 7, 8),
(2, '0', '', 0, 0, 0, 0, 0,
0, 0, 0),
(3, '3', '', 0, 0, 0, 0, 0, 0, 0, 0),
(4, '0', '', 0, 0, 0, 0, 0,
0, 0, 0),
(35, '3', '', 81, 82, 83, 84, 85, 86, 87, 88),
(32, '0', '', 0,
0, 0, 0, 0, 0, 0, 0),
(33, '3', '', 57, 58, 59, 60, 61, 62, 63, 64),
(30,
'0', '', 0, 0, 0, 0, 0, 0, 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `contacts`
--
CREATE TABLE IF NOT EXISTS
`contacts` (
`user` int(11) NOT NULL DEFAULT '0',
`ho` int(11) NOT NULL
DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
--
-- Дамп данных таблицы
`contacts`
--
INSERT INTO `contacts` (`user`, `ho`, `time`) VALUES
(2, 1,
1420325210);
--
--------------------------------------------------------
--
--
Структура таблицы `duel`
--
CREATE TABLE IF NOT EXISTS
`duel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`time` int(11)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=3 ;
--
-- Дамп данных
таблицы `duel`
--
INSERT INTO `duel` (`id`, `user`, `opponent`,
`time`) VALUES
(1, 1, 12, 1420344591),
(2, 3, 2, 1420413348);
--
--------------------------------------------------------
--
--
Структура таблицы `farm`
--
CREATE TABLE IF NOT EXISTS
`farm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`h` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы
`farm`
--
INSERT INTO `farm` (`id`, `user`, `h`, `time`) VALUES
(1, 1, 0,
0);
-- --------------------------------------------------------
--
--
Структура таблицы `farm2`
--
CREATE TABLE IF NOT EXISTS
`farm2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`h` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы
`farm2`
--
INSERT INTO `farm2` (`id`, `user`, `h`, `time`) VALUES
(1, 1,
5, 1420387587);
--
--------------------------------------------------------
--
--
Структура таблицы `forum_comments`
--
CREATE TABLE IF NOT
EXISTS `forum_comments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`topic`
int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
`to`
int(11) NOT NULL DEFAULT '0',
`text` text,
`time` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_sub`
--
CREATE TABLE IF NOT
EXISTS `forum_sub` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(100) DEFAULT NULL,
`access` enum('0','1','2') NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=20 ;
--
-- Дамп данных таблицы
`forum_sub`
--
INSERT INTO `forum_sub` (`id`, `name`, `access`)
VALUES
(18, 'Вопросы по оплате', '0'),
(17,
'Творчество', '0'),
(16, 'Общение', '0'),
(15,
'Помощь по игре', '0'),
(1, 'Новости', '2');
--
--------------------------------------------------------
--
--
Структура таблицы `forum_topic`
--
CREATE TABLE IF NOT
EXISTS `forum_topic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sub`
int(11) NOT NULL DEFAULT '0',
`close` enum('0','1') NOT NULL DEFAULT
'0',
`stick` enum('0','1') NOT NULL DEFAULT '0',
`user` int(11) NOT
NULL DEFAULT '0',
`name` varchar(100) DEFAULT NULL,
`text` text,
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;
--
-- Дамп данных
таблицы `forum_topic`
--
INSERT INTO `forum_topic` (`id`, `sub`,
`close`, `stick`, `user`, `name`, `text`, `time`) VALUES
(1, 1, '1', '0',
1, 'ЗБТ игры!', 'Идет Закрытое Бета
Тестирование игры!', 1419008089),
(2, 1, '0', '0', 1,
'ОБТ!', 'Игра переходит на стадию
Открытого бета-теста! )', 1420471807);
--
--------------------------------------------------------
--
--
Структура таблицы `inv`
--
CREATE TABLE IF NOT EXISTS
`inv` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`item` int(11) NOT NULL DEFAULT '0',
`quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`bonus` int(11)
NOT NULL DEFAULT '0',
`smith` int(11) NOT NULL DEFAULT '0',
`equip`
enum('0','1') NOT NULL DEFAULT '0',
`new` enum('0','1') NOT NULL DEFAULT
'0',
`rune` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
`_str`
int(11) NOT NULL DEFAULT '0',
`_vit` int(11) NOT NULL DEFAULT '0',
`_agi` int(11) NOT NULL DEFAULT '0',
`_def` int(11) NOT NULL DEFAULT
'0',
`place` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=14 ;
--
-- Дамп
данных таблицы `inv`
--
INSERT INTO `inv` (`id`, `user`,
`item`, `quality`, `bonus`, `smith`, `equip`, `new`, `rune`, `_str`,
`_vit`, `_agi`, `_def`, `place`) VALUES
(1, 1, 2, '1', 5, 0, '1', '1', '3',
31, 281, 31, 31, '0'),
(2, 1, 4, '1', 5, 0, '1', '1', '0', 31, 31, 31, 31,
'0'),
(3, 3, 5, '1', 5, 0, '1', '0', '0', 31, 31, 31, 31, '0'),
(4, 7, 32,
'1', 5, 0, '0', '1', '0', 31, 31, 31, 31, '0'),
(5, 7, 26, '1', 5, 0, '0',
'0', '0', 31, 31, 31, 31, '0'),
(6, 16, 76, '2', 10, 0, '0', '1', '0', 45,
45, 45, 45, '0'),
(7, 16, 0, '', 0, 0, '0', '1', '0', 0, 0, 0, 0, '0'),
(8,
16, 0, '', 0, 0, '0', '1', '0', 0, 0, 0, 0, '0'),
(9, 16, 1, '1', 5, 0,
'1', '1', '0', 31, 31, 31, 31, '0'),
(10, 16, 5, '1', 5, 0, '1', '1', '0',
31, 31, 31, 31, '0'),
(11, 16, 3, '1', 5, 0, '1', '1', '0', 31, 31, 31, 31,
'0'),
(12, 17, 7, '1', 5, 0, '1', '1', '0', 31, 31, 31, 31, '0'),
(13, 17,
1, '1', 5, 0, '1', '1', '0', 31, 31, 31, 31, '0');
--
--------------------------------------------------------
--
--
Структура таблицы `items`
--
CREATE TABLE IF NOT EXISTS
`items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`w`
enum('1','2','3','4','5','6','7','8') NOT NULL DEFAULT '1',
`name`
varchar(100) DEFAULT NULL,
`quality` enum('0','1','2','3','4','5','6')
NOT NULL DEFAULT '0',
`skill` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=314 ;
--
--
Дамп данных таблицы `items`
--
INSERT INTO `items` (`id`,
`w`, `name`, `quality`, `skill`) VALUES
(1, '1', 'Старые очки',
'1', 1),
(2, '2', 'Старая бандана', '1', 1),
(3, '3',
'Старая футболка', '1', 1),
(4, '4', 'Старый
кулон', '1', 1),
(5, '5', 'Удочка', '1', 1),
(6, '6',
'Палка', '1', 1),
(7, '7', 'Трусы', '1', 1),
(8, '8',
'Тапки', '1', 1);
--
--------------------------------------------------------
--
--
Структура таблицы `mail`
--
CREATE TABLE IF NOT EXISTS
`mail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` int(11) NOT NULL
DEFAULT '0',
`to` int(11) NOT NULL DEFAULT '0',
`text` text,
`time`
int(11) NOT NULL DEFAULT '0',
`read` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы
`mail`
--
INSERT INTO `mail` (`id`, `from`, `to`, `text`, `time`, `read`)
VALUES
(1, 1, 2, 'Добро пожаловать в игру
Наследие древних! Добавь в закладки наш
сайт игры http://uhero.ru. А также прочти
правила. <br>\r\n1. Нельзя просить у
Администрации что либо (золото, серебро,
мд и администрацию.) <br>\r\n2. Нельзя
рекламировать сторонние игры.<br>\r\n3.
Запрещено продавать персонажа.
<br>\r\nАдминистрация игры несет за
собой право заблокировать персонажа
НАВСЕГДА!<br>\r\nУдачной игры!\r\n', 1420325210,
'0');
-- --------------------------------------------------------
--
--
Структура таблицы `maneken`
--
CREATE TABLE IF NOT EXISTS
`maneken` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL DEFAULT '0',
`w_1` int(11) NOT NULL DEFAULT '0',
`w_2` int(11) NOT
NULL DEFAULT '0',
`w_3` int(11) NOT NULL DEFAULT '0',
`w_4` int(11) NOT
NULL DEFAULT '0',
`w_5` int(11) NOT NULL DEFAULT '0',
`w_6` int(11) NOT
NULL DEFAULT '0',
`w_7` int(11) NOT NULL DEFAULT '0',
`w_8` int(11) NOT
NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT
NULL,
`text` varchar(228) NOT NULL,
`user` int(11) NOT NULL,
`time`
int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_comm`
--
CREATE TABLE IF NOT
EXISTS `news_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text
NOT NULL,
`user` int(11) NOT NULL,
`time` int(20) NOT NULL,
`news`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_status`
--
CREATE TABLE IF NOT
EXISTS `news_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user`
int(11) NOT NULL,
`news` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_status_read`
--
CREATE TABLE IF
NOT EXISTS `news_status_read` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `premium`
--
CREATE TABLE IF NOT EXISTS
`premium` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT
NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
--
Дамп данных таблицы `premium`
--
INSERT INTO `premium`
(`id`, `user`, `time`) VALUES
(1, 1, 1421596565);
--
--------------------------------------------------------
--
--
Структура таблицы `ref`
--
CREATE TABLE IF NOT EXISTS
`ref` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`ho` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `sack`
--
CREATE TABLE IF NOT EXISTS
`sack` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL
DEFAULT '0',
`1` int(11) NOT NULL DEFAULT '0',
`2` int(11) NOT NULL
DEFAULT '0',
`3` int(11) NOT NULL DEFAULT '0',
`4` int(11) NOT NULL
DEFAULT '0',
`5` int(11) NOT NULL DEFAULT '0',
`6` int(11) NOT NULL
DEFAULT '0',
`7` int(11) NOT NULL DEFAULT '0',
`8` int(11) NOT NULL
DEFAULT '0',
`9` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;
--
-- Дамп
данных таблицы `sack`
--
INSERT INTO `sack` (`id`, `user`,
`1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`) VALUES
(1, 1, 2, 0, 1, 0, 0,
0, 1, 5, 0),
(2, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 4, 0, 0, 0, 0, 0, 0, 0,
0, 0);
-- --------------------------------------------------------
--
--
Структура таблицы `shop`
--
CREATE TABLE IF NOT EXISTS
`shop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`bonus` int(11)
NOT NULL DEFAULT '0',
`cost` int(11) NOT NULL DEFAULT '0',
`_str`
int(11) NOT NULL DEFAULT '0',
`_vit` int(11) NOT NULL DEFAULT '0',
`_agi` int(11) NOT NULL DEFAULT '0',
`_def` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=218 ;
--
-- Дамп данных таблицы
`shop`
--
INSERT INTO `shop` (`id`, `quality`, `bonus`, `cost`, `_str`,
`_vit`, `_agi`, `_def`) VALUES
(1, '1', 5, 10, 31, 31, 31, 31),
(2, '1', 5,
10, 31, 31, 31, 31),
(3, '1', 5, 10, 31, 31, 31, 31),
(4, '1', 5, 10, 31,
31, 31, 31),
(5, '1', 5, 10, 31, 31, 31, 31),
(6, '1', 5, 10, 31, 31, 31,
31),
(7, '1', 5, 10, 31, 31, 31, 31),
(8, '1', 5, 10, 31, 31, 31,
31),
(198, '5', 10, 2000, 120, 120, 120, 120),
(199, '5', 10, 2000, 120,
120, 120, 120),
(17, '1', 5, 10, 31, 31, 31, 31),
(18, '1', 5, 10, 31, 31,
31, 31),
(19, '1', 5, 10, 31, 31, 31, 31),
(20, '1', 5, 10, 31, 31, 31,
31),
(21, '1', 5, 10, 31, 31, 31, 31),
(22, '1', 5, 10, 31, 31, 31,
31),
(23, '1', 5, 10, 31, 31, 31, 31),
(24, '1', 5, 10, 31, 31, 31,
31),
(25, '1', 5, 10, 31, 31, 31, 31),
(26, '1', 5, 10, 31, 31, 31,
31),
(27, '1', 5, 10, 31, 31, 31, 31),
(28, '1', 5, 10, 31, 31, 31,
31),
(29, '1', 5, 10, 31, 31, 31, 31),
(30, '1', 5, 10, 31, 31, 31,
31),
(31, '1', 5, 10, 31, 31, 31, 31),
(32, '1', 5, 10, 31, 31, 31,
31),
(33, '2', 10, 30, 45, 45, 45, 45),
(34, '2', 10, 30, 45, 45, 45,
45),
(35, '2', 10, 30, 45, 45, 45, 45),
(36, '2', 10, 30, 45, 45, 45,
45),
(37, '2', 10, 30, 45, 45, 45, 45),
(38, '2', 10, 30, 45, 45, 45,
45),
(39, '2', 10, 30, 45, 45, 45, 45),
(40, '2', 10, 30, 45, 45, 45,
45),
(65, '2', 10, 30, 45, 45, 45, 45),
(66, '2', 10, 30, 45, 45, 45,
45),
(67, '2', 10, 30, 45, 45, 45, 45),
(68, '2', 10, 30, 45, 45, 45,
45),
(69, '2', 10, 30, 45, 45, 45, 45),
(70, '2', 10, 30, 45, 45, 45,
45),
(71, '2', 10, 30, 45, 45, 45, 45),
(72, '2', 10, 30, 45, 45, 45,
45),
(73, '2', 10, 30, 45, 45, 45, 45),
(74, '2', 10, 30, 45, 45, 45,
45),
(75, '2', 10, 30, 45, 45, 45, 45),
(76, '2', 10, 30, 45, 45, 45,
45),
(77, '2', 10, 30, 45, 45, 45, 45),
(78, '2', 10, 30, 45, 45, 45,
45),
(79, '2', 10, 30, 45, 45, 45, 45),
(80, '2', 10, 30, 45, 45, 45,
45),
(41, '3', 10, 60, 52, 52, 52, 52),
(42, '3', 10, 60, 52, 52, 52,
52),
(43, '3', 10, 60, 52, 52, 52, 52),
(44, '3', 10, 60, 52, 52, 52,
52),
(45, '3', 10, 60, 52, 52, 52, 52),
(46, '3', 10, 60, 52, 52, 52,
52),
(47, '3', 10, 60, 52, 52, 52, 52),
(48, '3', 10, 60, 52, 52, 52,
52),
(49, '3', 10, 60, 52, 52, 52, 52),
(50, '3', 10, 60, 52, 52, 52,
52),
(51, '3', 10, 60, 52, 52, 52, 52),
(52, '3', 10, 60, 52, 52, 52,
52),
(53, '3', 10, 60, 52, 52, 52, 52),
(54, '3', 10, 60, 52, 52, 52,
52),
(55, '3', 10, 60, 52, 52, 52, 52),
(56, '3', 10, 60, 52, 52, 52,
52),
(57, '3', 10, 60, 52, 52, 52, 52),
(58, '3', 10, 60, 52, 52, 52,
52),
(59, '3', 10, 60, 52, 52, 52, 52),
(60, '3', 10, 60, 52, 52, 52,
52),
(61, '3', 10, 60, 52, 52, 52, 52),
(62, '3', 10, 60, 52, 52, 52,
52),
(63, '3', 10, 60, 52, 52, 52, 52),
(64, '3', 10, 60, 52, 52, 52,
52),
(81, '3', 10, 60, 52, 52, 52, 52),
(82, '3', 10, 60, 52, 52, 52,
52),
(83, '3', 10, 60, 52, 52, 52, 52),
(84, '3', 10, 60, 52, 52, 52,
52),
(85, '3', 10, 60, 52, 52, 52, 52),
(86, '3', 10, 60, 52, 52, 52,
52),
(87, '3', 10, 60, 52, 52, 52, 52),
(88, '3', 10, 60, 52, 52, 52,
52),
(105, '3', 10, 60, 52, 52, 52, 52),
(106, '3', 10, 60, 52, 52, 52,
52),
(107, '3', 10, 60, 52, 52, 52, 52),
(108, '3', 10, 60, 52, 52, 52,
52),
(109, '3', 10, 60, 52, 52, 52, 52),
(110, '3', 10, 60, 52, 52, 52,
52),
(111, '3', 10, 60, 52, 52, 52, 52),
(112, '3', 10, 60, 52, 52, 52,
52),
(113, '3', 10, 60, 52, 52, 52, 52),
(114, '3', 10, 60, 52, 52, 52,
52),
(115, '3', 10, 60, 52, 52, 52, 52),
(116, '3', 10, 60, 52, 52, 52,
52),
(117, '3', 10, 60, 52, 52, 52, 52),
(118, '3', 10, 60, 52, 52, 52,
52),
(119, '3', 10, 60, 52, 52, 52, 52),
(120, '3', 10, 60, 52, 52, 52,
52),
(89, '4', 10, 200, 60, 60, 60, 60),
(90, '4', 10, 200, 60, 60, 60,
60),
(91, '4', 10, 200, 60, 60, 60, 60),
(92, '4', 10, 200, 60, 60, 60,
60),
(93, '4', 10, 200, 60, 60, 60, 60),
(94, '4', 10, 200, 60, 60, 60,
60),
(95, '4', 10, 200, 60, 60, 60, 60),
(96, '4', 10, 200, 60, 60, 60,
60),
(97, '4', 10, 200, 60, 60, 60, 60),
(98, '4', 10, 200, 60, 60, 60,
60),
(99, '4', 10, 200, 60, 60, 60, 60),
(100, '4', 10, 200, 60, 60, 60,
60),
(101, '4', 10, 200, 60, 60, 60, 60),
(102, '4', 10, 200, 60, 60, 60,
60),
(103, '4', 10, 200, 60, 60, 60, 60),
(104, '4', 10, 200, 60, 60, 60,
60),
(121, '4', 10, 200, 60, 60, 60, 60),
(122, '4', 10, 200, 60, 60, 60,
60),
(123, '4', 10, 200, 60, 60, 60, 60),
(124, '4', 10, 200, 60, 60, 60,
60),
(125, '4', 10, 200, 60, 60, 60, 60),
(126, '4', 10, 200, 60, 60, 60,
60),
(127, '4', 10, 200, 60, 60, 60, 60),
(128, '4', 10, 200, 60, 60, 60,
60),
(129, '4', 10, 200, 60, 60, 60, 60),
(130, '4', 10, 200, 60, 60, 60,
60),
(131, '4', 10, 200, 60, 60, 60, 60),
(132, '4', 10, 200, 60, 60, 60,
60),
(133, '4', 10, 200, 60, 60, 60, 60),
(134, '4', 10, 200, 60, 60, 60,
60),
(135, '4', 10, 200, 60, 60, 60, 60),
(136, '4', 10, 200, 60, 60, 60,
60),
(202, '5', 10, 2000, 120, 120, 120, 120),
(203, '5', 10, 2000, 120,
120, 120, 120),
(204, '5', 10, 2000, 120, 120, 120, 120),
(205, '5', 10,
2000, 120, 120, 120, 120),
(206, '5', 10, 2000, 120, 120, 120, 120),
(207,
'5', 10, 2000, 120, 120, 120, 120),
(208, '5', 10, 2000, 120, 120, 120,
120),
(209, '5', 10, 2000, 120, 120, 120, 120),
(186, '5', 10, 2000, 120,
120, 120, 120),
(187, '5', 10, 2000, 120, 120, 120, 120),
(188, '5', 10,
2000, 120, 120, 120, 120),
(189, '5', 10, 2000, 120, 120, 120, 120),
(190,
'5', 10, 2000, 120, 120, 120, 120),
(191, '5', 10, 2000, 120, 120, 120,
120),
(192, '5', 10, 2000, 120, 120, 120, 120),
(193, '5', 10, 2000, 120,
120, 120, 120),
(194, '5', 10, 2000, 120, 120, 120, 120),
(195, '5', 10,
2000, 120, 120, 120, 120),
(196, '5', 10, 2000, 120, 120, 120, 120),
(197,
'5', 10, 2000, 120, 120, 120, 120),
(200, '5', 10, 2000, 120, 120, 120,
120),
(201, '5', 10, 2000, 120, 120, 120, 120),
(178, '5', 10, 2000, 120,
120, 120, 120),
(179, '5', 10, 2000, 120, 120, 120, 120),
(180, '5', 10,
2000, 120, 120, 120, 120),
(181, '5', 10, 2000, 120, 120, 120, 120),
(182,
'5', 10, 2000, 120, 120, 120, 120),
(183, '5', 10, 2000, 120, 120, 120,
120),
(184, '5', 10, 2000, 120, 120, 120, 120),
(185, '5', 10, 2000, 120,
120, 120, 120),
(137, '4', 10, 200, 60, 60, 60, 60),
(138, '4', 10, 200,
60, 60, 60, 60),
(139, '4', 10, 200, 60, 60, 60, 60),
(140, '4', 10, 200,
60, 60, 60, 60),
(141, '4', 10, 200, 60, 60, 60, 60),
(142, '4', 10, 200,
60, 60, 60, 60),
(143, '4', 10, 200, 60, 60, 60, 60),
(144, '4', 10, 200,
60, 60, 60, 60),
(145, '4', 10, 200, 60, 60, 60, 60),
(146, '4', 10, 200,
60, 60, 60, 60),
(147, '4', 10, 200, 60, 60, 60, 60),
(148, '4', 10, 200,
60, 60, 60, 60),
(149, '4', 10, 200, 60, 60, 60, 60),
(150, '4', 10, 200,
60, 60, 60, 60),
(151, '4', 10, 200, 60, 60, 60, 60),
(152, '4', 10, 200,
60, 60, 60, 60),
(161, '4', 10, 200, 60, 60, 60, 60),
(162, '4', 10, 200,
60, 60, 60, 60),
(163, '4', 10, 200, 60, 60, 60, 60),
(164, '4', 10, 200,
60, 60, 60, 60),
(165, '4', 10, 200, 60, 60, 60, 60),
(166, '4', 10, 200,
60, 60, 60, 60),
(167, '4', 10, 200, 60, 60, 60, 60),
(168, '4', 10, 200,
60, 60, 60, 60),
(210, '5', 10, 2000, 120, 120, 120, 120),
(211, '5', 10,
2000, 120, 120, 120, 120),
(212, '5', 10, 2000, 120, 120, 120, 120),
(213,
'5', 10, 2000, 120, 120, 120, 120),
(214, '5', 10, 2000, 120, 120, 120,
120),
(215, '5', 10, 2000, 120, 120, 120, 120),
(216, '5', 10, 2000, 120,
120, 120, 120),
(217, '5', 10, 2000, 120, 120, 120, 120);
--
--------------------------------------------------------
--
--
Структура таблицы `undying`
--
CREATE TABLE IF NOT EXISTS
`undying` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT
NULL DEFAULT '0',
`end` enum('0','1') NOT NULL DEFAULT '0',
`start`
enum('0','1') NOT NULL DEFAULT '0',
`opponents` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=9 ;
--
-- Дамп данных таблицы
`undying`
--
INSERT INTO `undying` (`id`, `time`, `end`, `start`,
`opponents`) VALUES
(1, 1418968675, '0', '1', 0),
(2, 1419008416, '0', '1',
0),
(3, 1419261461, '0', '1', 0),
(4, 1420301995, '1', '1', 0),
(5,
1420318899, '1', '1', 2),
(6, 1420390275, '1', '1', 0),
(7, 1420461315,
'1', '1', 0),
(8, 1420471867, '0', '0', 4);
--
--------------------------------------------------------
--
--
Структура таблицы `undying_member`
--
CREATE TABLE IF NOT
EXISTS `undying_member` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`battle` int(11) NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT
'0',
`dead` enum('0','1') NOT NULL DEFAULT '0',
`exit` enum('0','1')
NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`kills`
int(11) NOT NULL DEFAULT '0',
`dmg` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=6
;
--
-- Дамп данных таблицы `undying_member`
--
INSERT
INTO `undying_member` (`id`, `battle`, `user`, `dead`, `exit`, `time`,
`kills`, `dmg`) VALUES
(1, 4, 1, '0', '1', 1420301760, 1, 138),
(2, 5, 1,
'0', '1', 1420318640, 0, 102),
(3, 6, 1, '0', '1', 1420390123, 3,
1094),
(4, 7, 1, '0', '1', 1420461075, 5, 2028),
(5, 8, 1, '0', '0',
1420461080, 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `unitpay_payments`
--
CREATE TABLE IF
NOT EXISTS `unitpay_payments` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`unitpayId` varchar(255) NOT NULL,
`account` varchar(255) NOT NULL,
`sum` float NOT NULL,
`itemsCount` int(11) NOT NULL DEFAULT '1',
`dateCreate` datetime NOT NULL,
`dateComplete` datetime DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS
`users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(100)
DEFAULT NULL,
`password` varchar(100) DEFAULT NULL,
`sex` enum('0','1')
NOT NULL DEFAULT '0',
`online` int(11) NOT NULL DEFAULT '0',
`last_update` int(11) NOT NULL DEFAULT '0',
`access` enum('0','1','2')
NOT NULL DEFAULT '0',
`r` enum('0','1') NOT NULL DEFAULT '0',
`level`
int(11) NOT NULL DEFAULT '1',
`hp` int(11) NOT NULL DEFAULT '0',
`mp`
int(11) NOT NULL DEFAULT '0',
`exp` int(11) NOT NULL DEFAULT '0',
`g`
int(11) NOT NULL DEFAULT '0',
`s` int(11) NOT NULL DEFAULT '0',
`skill`
int(11) NOT NULL DEFAULT '0',
`str` int(11) NOT NULL DEFAULT '10',
`_str` int(11) NOT NULL DEFAULT '0',
`vit` int(11) NOT NULL DEFAULT
'10',
`_vit` int(11) NOT NULL DEFAULT '0',
`agi` int(11) NOT NULL
DEFAULT '10',
`_agi` int(11) NOT NULL DEFAULT '0',
`def` int(11) NOT
NULL DEFAULT '10',
`_def` int(11) NOT NULL DEFAULT '0',
`mana` int(11)
NOT NULL DEFAULT '1000',
`_mana` int(11) NOT NULL DEFAULT '0',
`w_1`
int(11) NOT NULL DEFAULT '0',
`w_2` int(11) NOT NULL DEFAULT '0',
`w_3`
int(11) NOT NULL DEFAULT '0',
`w_4` int(11) NOT NULL DEFAULT '0',
`w_5`
int(11) NOT NULL DEFAULT '0',
`w_6` int(11) NOT NULL DEFAULT '0',
`w_7`
int(11) NOT NULL DEFAULT '0',
`w_8` int(11) NOT NULL DEFAULT '0',
`save` enum('0','1') NOT NULL DEFAULT '0',
`duel_rating` int(11) NOT NULL
DEFAULT '0',
`duel_fights` int(11) NOT NULL DEFAULT '0',
`duel_last_update` int(11) NOT NULL DEFAULT '0',
`duel_changes` int(11)
NOT NULL DEFAULT '0',
`ip` text,
`ua` text,
`coliseum_rating` int(11)
NOT NULL DEFAULT '0',
`self` text,
`ability_1` int(11) NOT NULL DEFAULT
'0',
`ability_1_quality` enum('0','1','2','3','4','5','6') NOT NULL
DEFAULT '0',
`ability_2` int(11) NOT NULL DEFAULT '0',
`ability_2_quality` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT
'0',
`ability_3` int(11) NOT NULL DEFAULT '0',
`ability_3_quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`ability_4`
int(11) NOT NULL DEFAULT '0',
`ability_4_quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`ability_5`
int(11) NOT NULL DEFAULT '0',
`ability_5_quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`bg`
enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`chest` enum('0','1') NOT
NULL DEFAULT '0',
`duel_trophy` int(11) NOT NULL DEFAULT '0',
`arena_opponent` int(11) NOT NULL DEFAULT '0',
`arena_time` int(11) NOT
NULL DEFAULT '0',
`res_1` int(11) NOT NULL DEFAULT '0',
`res_2` int(11)
NOT NULL DEFAULT '0',
`res_3` int(11) NOT NULL DEFAULT '0',
`res_4`
int(11) NOT NULL DEFAULT '0',
`res_5` int(11) NOT NULL DEFAULT '0',
`res_6` int(11) NOT NULL DEFAULT '0',
`res_7` int(11) NOT NULL DEFAULT
'0',
`res_8` int(11) NOT NULL DEFAULT '0',
`res_9` int(11) NOT NULL
DEFAULT '0',
`kods` varchar(32) NOT NULL,
`mail_closed` varchar(32) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=23 ;
--
-- Дамп данных таблицы
`users`
--
INSERT INTO `users` (`id`, `login`, `password`, `sex`,
`online`, `last_update`, `access`, `r`, `level`, `hp`, `mp`, `exp`, `g`,
`s`, `skill`, `str`, `_str`, `vit`, `_vit`, `agi`, `_agi`, `def`, `_def`,
`mana`, `_mana`, `w_1`, `w_2`, `w_3`, `w_4`, `w_5`, `w_6`, `w_7`, `w_8`,
`save`, `duel_rating`, `duel_fights`, `duel_last_update`, `duel_changes`,
`ip`, `ua`, `coliseum_rating`, `self`, `ability_1`, `ability_1_quality`,
`ability_2`, `ability_2_quality`, `ability_3`, `ability_3_quality`,
`ability_4`, `ability_4_quality`, `ability_5`, `ability_5_quality`, `bg`,
`chest`, `duel_trophy`, `arena_opponent`, `arena_time`, `res_1`, `res_2`,
`res_3`, `res_4`, `res_5`, `res_6`, `res_7`, `res_8`, `res_9`, `kods`,
`mail_closed`) VALUES
(1, 'Admin', 'qqqwww3', '0', 1420474360, 1420474360,
'2', '0', 20, 3708, 1010, 1943, 76664, 13398, 222, 1604, 61, 1854, 61, 599,
56, 585, 42, 1010, 2, 0, 1, 0, 2, 0, 0, 0, 0, '1', 24, 11, 1420474190, 11,
'127.0.0.1', 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36', 0, '/index.php', 1,
'0', 1, '0', 1, '0', 1, '0', 1, '0', '0', '1', 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 'EFStgr34re', '');
/*!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 */;