Вход Регистрация
Просмотр архива Братва
Файл: MySQL-Base.sql
Строк: 1428
-- phpMyAdmin SQL Dump -- version 3.4.10.1 --
http://www.phpmyadmin.net -- -- Хост: localhost -- Время
создания: Авг 26 2012 г., 20:11 -- Версия сервера:
5.1.63 -- Версия PHP: 5.2.6 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 */; -- -- База данных: `dima7653_bratki` -- --
-------------------------------------------------------- -- --
Структура таблицы `arena` -- CREATE TABLE IF NOT EXISTS
`arena` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `enemy` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `xod` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip` varchar(15)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ltime` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `block` int(30) NOT
NULL, `udar` int(30) NOT NULL, `mag` int(11) NOT NULL, `pk`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ; --
-------------------------------------------------------- -- --
Структура таблицы `arena_wait` -- CREATE TABLE IF NOT
EXISTS `arena_wait` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `enemy`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `wait`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lvl_ot`
int(11) NOT NULL, `lvl_do` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82 ; --
-------------------------------------------------------- -- --
Структура таблицы `asasins` -- CREATE TABLE IF NOT EXISTS
`asasins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50)
COLLATE utf8_unicode_ci NOT NULL, `img` varchar(50) COLLATE
utf8_unicode_ci NOT NULL, `status` varchar(10) COLLATE utf8_unicode_ci
NOT NULL, `cena` int(11) NOT NULL, `lvl` int(11) NOT NULL, `min`
int(11) NOT NULL, `city` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`hp` int(11) NOT NULL, `hpall` int(11) NOT NULL, `umin` int(11) NOT
NULL, `umax` int(11) NOT NULL, `pgolova` int(11) NOT NULL, `pbody`
int(11) NOT NULL, `pnogi` int(11) NOT NULL, `krit` int(11) NOT NULL,
`ukrit` int(11) NOT NULL, `antikrit` int(11) NOT NULL, `lovk` int(11)
NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ; -- -- Дамп данных
таблицы `asasins` -- INSERT INTO `asasins` (`id`, `name`, `img`,
`status`, `cena`, `lvl`, `min`, `city`, `hp`, `hpall`, `umin`, `umax`,
`pgolova`, `pbody`, `pnogi`, `krit`, `ukrit`, `antikrit`, `lovk`)
VALUES (1, 'Giga', 'pers.png', 'on', 1, 1, 1, 'lave', 30, 30, 3, 7, 5, 4,
4, 6, 7, 8, 3), (2, 'Bee Sidy', 'pers.png', 'on', 20, 1, 1, 'lave', 30, 30,
3, 7, 5, 4, 4, 6, 7, 8, 3); --
-------------------------------------------------------- -- --
Структура таблицы `asasins_active` -- CREATE TABLE IF NOT
EXISTS `asasins_active` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr`
varchar(10) COLLATE utf8_unicode_ci NOT NULL, `asasin` int(11) NOT NULL,
`kol` int(11) NOT NULL, `ltime` varchar(25) COLLATE utf8_unicode_ci NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ; --
-------------------------------------------------------- -- --
Структура таблицы `asasin_info` -- CREATE TABLE IF NOT
EXISTS `asasin_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `asasin`
int(11) NOT NULL, `info` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=16 ; -- -- Дамп данных таблицы
`asasin_info` -- INSERT INTO `asasin_info` (`id`, `asasin`, `info`)
VALUES (1, 1, 'Giga - опытный боец. Только он
хорошо знает Las Vegas!'), (15, 2, 'Bee Sidy - опытный
стрелок. Только он хорошо знает Las Vegas!'); --
-------------------------------------------------------- -- --
Структура таблицы `aurs` -- CREATE TABLE IF NOT EXISTS
`aurs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `actimer` varchar(25) COLLATE
utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- Дамп
данных таблицы `aurs` -- INSERT INTO `aurs` (`id`, `usr`,
`actimer`) VALUES (2, 'test', '1346000914'); --
-------------------------------------------------------- -- --
Структура таблицы `ban` -- CREATE TABLE IF NOT EXISTS
`ban` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10) COLLATE
utf8_unicode_ci NOT NULL, `ban_time` varchar(25) COLLATE utf8_unicode_ci
NOT NULL, `text` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `bank` -- CREATE TABLE IF NOT EXISTS
`bank` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `money` int(11) NOT
NULL, `ltime` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `bazar` -- CREATE TABLE IF NOT EXISTS
`bazar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `baz_tip`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name`
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lat_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `cena` int(11) NOT NULL, `mycena` int(11) NOT NULL, `umin`
int(11) NOT NULL, `umax` int(11) NOT NULL, `pgolova` int(11) NOT NULL,
`pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL, `hp` int(11) NOT
NULL, `mp` int(11) NOT NULL, `krit` int(11) NOT NULL, `ukrit` int(11)
NOT NULL, `antikrit` int(11) NOT NULL, `sila` int(11) NOT NULL,
`lovk` int(11) NOT NULL, `um` int(11) NOT NULL, `prot` int(11) NOT
NULL, `klas` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `nsila` int(11) NOT NULL, `nlovk` int(11) NOT NULL, `num`
int(11) NOT NULL, `nlvl` int(11) NOT NULL, `what` varchar(25) CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, `give` varchar(25) CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, `kol` int(11) NOT NULL,
`rasa` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `citys` -- CREATE TABLE IF NOT EXISTS
`citys` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `x` int(11) NOT
NULL, `y` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=4 ; -- -- Дамп данных
таблицы `citys` -- INSERT INTO `citys` (`id`, `name`, `city`, `x`,
`y`) VALUES (1, 'Las Vegas', 'lave', 0, 0); --
-------------------------------------------------------- -- --
Структура таблицы `clan` -- CREATE TABLE IF NOT EXISTS
`clan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lider` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `money` int(11) NOT
NULL, `emblema` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL, `desk` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `site` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `set_m` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ; --
-------------------------------------------------------- -- --
Структура таблицы `clanchat` -- CREATE TABLE IF NOT EXISTS
`clanchat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `clan` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `msg` text CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, `usr` text CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `clanlog` -- CREATE TABLE IF NOT EXISTS
`clanlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `clan` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `msg` text CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `clanwar` -- CREATE TABLE IF NOT EXISTS
`clanwar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `clan` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `timeout` varchar(25) COLLATE
utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `domination` -- CREATE TABLE IF NOT
EXISTS `domination` ( `id` int(11) NOT NULL AUTO_INCREMENT, `white`
int(11) NOT NULL, `black` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `drops` -- CREATE TABLE IF NOT EXISTS
`drops` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tip` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `drops` varchar(250) COLLATE
utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ; -- -- Дамп
данных таблицы `drops` -- INSERT INTO `drops` (`id`, `tip`,
`drops`) VALUES (1, '1', '1,2,13,14,16'), (2, '2',
'1,2,13,14,16,15,8'), (3, '3', '5,7,13,14,16,15,8,9,10,3,4'), (4, '4',
'5,7,13,14,16,15,8,9,10,3,4,6'), (5, 's1', '11'), (6, 's2', '17'); --
-------------------------------------------------------- -- --
Структура таблицы `forum_cats` -- CREATE TABLE IF NOT
EXISTS `forum_cats` ( `id` int(3) NOT NULL AUTO_INCREMENT, `id_cat`
int(3) NOT NULL, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- Дамп
данных таблицы `forum_cats` -- INSERT INTO `forum_cats`
(`id`, `id_cat`, `name`) VALUES (1, 0, 'Новости игры'), (2, 0,
'Общение'), (3, 0, 'Предложения'), (4, 0,
'Торговля'), (5, 0, 'Вопросы'), (6, 0, 'Кланы'), (7, 0,
'Ошибки и баги'), (8, 0, 'Объявления'); --
-------------------------------------------------------- -- --
Структура таблицы `forum_msg` -- CREATE TABLE IF NOT
EXISTS `forum_msg` ( `id` int(6) NOT NULL AUTO_INCREMENT, `id_cat`
int(3) NOT NULL, `id_topic` int(5) NOT NULL, `text` text NOT NULL,
`login` varchar(20) DEFAULT NULL, `time` varchar(10) NOT NULL,
`edit_login` varchar(20) NOT NULL, `edit_time` varchar(10) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `forum_topics` -- CREATE TABLE IF NOT
EXISTS `forum_topics` ( `id` int(5) NOT NULL AUTO_INCREMENT, `id_cat`
int(3) NOT NULL, `title` varchar(50) DEFAULT NULL, `authour`
varchar(20) NOT NULL, `time` varchar(10) NOT NULL, `closed` int(1) NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `guards` -- CREATE TABLE IF NOT EXISTS
`guards` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30)
COLLATE utf8_unicode_ci NOT NULL, `name` varchar(100) COLLATE
utf8_unicode_ci NOT NULL, `lvl` int(11) NOT NULL, `hp` int(11) NOT
NULL, `hpall` int(11) NOT NULL, `umin` int(11) NOT NULL, `umax`
int(11) NOT NULL, `pgolova` int(11) NOT NULL, `pbody` int(11) NOT
NULL, `pnogi` int(11) NOT NULL, `pmag` int(11) NOT NULL, `krit`
int(11) NOT NULL, `ukrit` int(11) NOT NULL, `antikrit` int(11) NOT
NULL, `lovk` int(11) NOT NULL, `sm` int(11) NOT NULL, `money` int(11)
NOT NULL, `exp` int(11) NOT NULL, `tip` varchar(30) COLLATE
utf8_unicode_ci NOT NULL, `status` varchar(10) COLLATE utf8_unicode_ci
NOT NULL, `time` int(11) NOT NULL, `oponent` varchar(32) COLLATE
utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ; -- -- Дамп
данных таблицы `guards` -- INSERT INTO `guards` (`id`,
`city`, `name`, `lvl`, `hp`, `hpall`, `umin`, `umax`, `pgolova`, `pbody`,
`pnogi`, `pmag`, `krit`, `ukrit`, `antikrit`, `lovk`, `sm`, `money`, `exp`,
`tip`, `status`, `time`, `oponent`) VALUES (1, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'), (2, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'), (3, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'), (4, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'), (5, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'), (6, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'), (7, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'), (8, 'fornost', 'Стражник
Форноста', 15, 50, 50, 20, 50, 40, 40, 42, 50, 50, 100, 25, 12, 3,
50, 29, 'guard', 'on', 900, 'not'); --
-------------------------------------------------------- -- --
Структура таблицы `invite` -- CREATE TABLE IF NOT EXISTS
`invite` ( `id` int(11) NOT NULL AUTO_INCREMENT, `clan` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `text` text
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=16 ; --
-------------------------------------------------------- -- --
Структура таблицы `item` -- CREATE TABLE IF NOT EXISTS
`item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cena` int(11) NOT
NULL, `umin` int(11) NOT NULL, `umax` int(11) NOT NULL, `pgolova`
int(11) NOT NULL, `pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL,
`hp` int(11) NOT NULL, `mp` int(11) NOT NULL, `krit` int(11) NOT NULL,
`ukrit` int(11) NOT NULL, `antikrit` int(11) NOT NULL, `sila` int(11)
NOT NULL, `lovk` int(11) NOT NULL, `um` int(11) NOT NULL, `prot`
int(11) NOT NULL, `klas` varchar(10) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL, `nsila` int(11) NOT NULL, `num` int(11) NOT
NULL, `nlovk` int(11) NOT NULL, `nlvl` int(11) NOT NULL, `image`
varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- --
Дамп данных таблицы `item` -- INSERT INTO `item` (`id`,
`usr`, `tip`, `name`, `cena`, `umin`, `umax`, `pgolova`, `pbody`, `pnogi`,
`hp`, `mp`, `krit`, `ukrit`, `antikrit`, `sila`, `lovk`, `um`, `prot`,
`klas`, `nsila`, `num`, `nlovk`, `nlvl`, `image`) VALUES (10, 'test',
'body', 'Рваная рубаха', 8, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 'not', 1, 0, 0, 0, 'not'), (9, 'test', 'weapon',
'Старенький ПМ', 8, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
'not', 1, 0, 0, 0, 'not'); --
-------------------------------------------------------- -- --
Структура таблицы `item_aura` -- CREATE TABLE IF NOT
EXISTS `item_aura` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr`
varchar(10) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(100) COLLATE
utf8_unicode_ci NOT NULL, `lat_name` varchar(100) COLLATE utf8_unicode_ci
NOT NULL, `cena` int(11) NOT NULL, `umin` int(11) NOT NULL, `umax`
int(11) NOT NULL, `protect` int(11) NOT NULL, `hp` int(11) NOT NULL,
`mp` int(11) NOT NULL, `krit` int(11) NOT NULL, `ukrit` int(11) NOT
NULL, `antikrit` int(11) NOT NULL, `klas` varchar(15) COLLATE
utf8_unicode_ci NOT NULL, `nsila` int(11) NOT NULL, `num` int(11) NOT
NULL, `nlovk` int(11) NOT NULL, `nlvl` int(11) NOT NULL, `actime`
int(32) NOT NULL, `kol` int(11) NOT NULL, `status` int(11) NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ; -- -- Дамп данных
таблицы `item_aura` -- INSERT INTO `item_aura` (`id`, `usr`,
`name`, `lat_name`, `cena`, `umin`, `umax`, `protect`, `hp`, `mp`, `krit`,
`ukrit`, `antikrit`, `klas`, `nsila`, `num`, `nlovk`, `nlvl`, `actime`,
`kol`, `status`) VALUES (5, 'test', 'Усилитель новичка',
'min_aura_shok', 15, 2, 7, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 1800, 1,
1); -- -------------------------------------------------------- -- --
Структура таблицы `karma` -- CREATE TABLE IF NOT EXISTS
`karma` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `from` varchar(10) COLLATE
utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `komentarai` -- CREATE TABLE IF NOT
EXISTS `komentarai` ( `id` int(15) NOT NULL AUTO_INCREMENT, `nick`
varchar(30) COLLATE utf8_unicode_ci NOT NULL, `komentaras` text COLLATE
utf8_unicode_ci NOT NULL, `kada` varchar(15) COLLATE utf8_unicode_ci NOT
NULL, `time` varchar(15) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `log` -- CREATE TABLE IF NOT EXISTS
`log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10) COLLATE
utf8_unicode_ci NOT NULL, `text` text COLLATE utf8_unicode_ci NOT NULL,
`kto` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `place` varchar(25)
COLLATE utf8_unicode_ci NOT NULL, `timer` varchar(25) COLLATE
utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=89 ; -- -- Дамп
данных таблицы `log` -- INSERT INTO `log` (`id`, `usr`,
`text`, `kto`, `place`, `timer`) VALUES (78, 'Dima7ik', 'Модный
тип сильно бьёт по туловищу! -1', 'enemy', 'battle',
'1345995163'), (79, 'Dima7ik', 'Модный тип блокировал
твой удар!', 'user', 'battle', '1345995164'), (80, 'Dima7ik', 'Ты
увернулся от удара!', 'enemy', 'battle',
'1345995164'), (81, 'Dima7ik', 'Модный тип увернулся от
твоего удара!', 'user', 'battle', '1345995165'), (82, 'Dima7ik',
'Ты пригнулся от удара!', 'enemy', 'battle',
'1345995165'), (83, 'Dima7ik', 'Модный тип пригнулся от
твоего удара!', 'user', 'battle', '1345995166'), (84, 'Dima7ik',
'Ты пригнулся от удара!', 'enemy', 'battle',
'1345995166'), (85, 'Dima7ik', 'Модный тип блокировал
твой удар!', 'user', 'battle', '1345995168'), (86, 'Dima7ik', 'Ты
пригнулся от удара!', 'enemy', 'battle',
'1345995168'), (87, 'Dima7ik', 'Ты бьёшь Модный тип в
голову! -3', 'user', 'battle', '1345995170'), (88, 'Dima7ik',
'Модный тип сильно бьёт по туловищу! -2',
'enemy', 'battle', '1345995170'); --
-------------------------------------------------------- -- --
Структура таблицы `mag` -- CREATE TABLE IF NOT EXISTS
`mag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lat_name`
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip`
varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `klas`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `uron`
varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `mp`
varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `hp`
varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`plushp` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`cena` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lvl` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Дамп данных таблицы
`mag` -- INSERT INTO `mag` (`id`, `usr`, `name`, `lat_name`, `tip`,
`klas`, `uron`, `mp`, `hp`, `plushp`, `cena`, `lvl`) VALUES (1, 'test',
'Патроны', 'mag_strela', 'atack', 'wizard',
'13|15|18|21|24|27|30|33|37|40', '9|10|12|13|14|15|16|17|18|19',
'0|0|0|0|0|0|0|0|0|0', '0|0|0|0|0|0|0|0|0|0',
'50|100|200|380|540|800|1124|1800|2600', 1); --
-------------------------------------------------------- -- --
Структура таблицы `mdrop` -- CREATE TABLE IF NOT EXISTS
`mdrop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lat_name`
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `what`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `give`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cena`
int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=18 ; -- -- Дамп данных
таблицы `mdrop` -- INSERT INTO `mdrop` (`id`, `name`, `lat_name`,
`tip`, `what`, `give`, `cena`) VALUES (1, 'HP-5', 'HP-5', 'elexir', 'hp',
'5', 15), (2, 'MP-5', 'MP-5', 'elexir', 'mp', '5', 15), (3, 'Свиток
слабой заточки', 'scroll_min_weapon', 'scroll',
'scroll_weapon', '1|2', 30), (4, 'Свиток слабой защиты',
'scroll_min_armor', 'scroll', 'scroll_armor', '2', 30), (5, 'HP-10',
'HP-10', 'elexir', 'hp', '10', 25), (6, 'Свиток заточки',
'scroll_weapon', 'scroll', 'scroll_weapon', '2|4', 60), (7, 'MP-10',
'MP-10', 'elexir', 'mp', '10', 25), (8, 'Серебро', 'serebro', 'res',
'res', '0', 30), (9, 'Нефрит', 'nefrit', 'res', 'res', '0', 30), (10,
'Обсидиан', 'obsidian', 'res', 'res', '0', 30), (11, 'Лунный
кристал', 'luniy_kristal', 'res', 'res', '0', 120), (13,
'Камень', 'kamen', 'res', 'res', '0', 6), (14, 'Дерево',
'derevo', 'res', 'res', '0', 9), (15, 'Железо', 'jelezo', 'res',
'res', '0', 9), (16, 'Кожа', 'koja', 'res', 'res', '0', 9), (17,
'Элемент Огня', 'fire_element', 'res', 'res', '0', 60); --
-------------------------------------------------------- -- --
Структура таблицы `mesto` -- CREATE TABLE IF NOT EXISTS
`mesto` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `place` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `city` int(11) NOT
NULL, `x` int(3) NOT NULL, `y` int(3) NOT NULL, `towers` int(11) NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=6 ; -- -- Дамп данных таблицы
`mesto` -- INSERT INTO `mesto` (`id`, `usr`, `place`, `city`, `x`, `y`,
`towers`) VALUES (1, 'Администра', 'npc', 0, 0, 0, 0), (2,
'Dima7ik', 'shop', 0, 0, 0, 1), (3, 'Test', 'msg', 0, 0, 0, 0), (4,
'Dima7ik', 'main', 0, 0, 0, 1), (5, 'test', 'main', 0, 0, 0, 0); --
-------------------------------------------------------- -- --
Структура таблицы `mob` -- CREATE TABLE IF NOT EXISTS
`mob` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lvl` int(11) NOT
NULL, `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `hp` int(11) NOT NULL, `hpall` int(11) NOT NULL, `umin` int(11)
NOT NULL, `umax` int(11) NOT NULL, `pgolova` int(11) NOT NULL,
`pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL, `pmag` int(11) NOT
NULL, `krit` int(11) NOT NULL, `ukrit` int(11) NOT NULL, `antikrit`
int(11) NOT NULL, `lovk` int(11) NOT NULL, `sd` int(11) NOT NULL,
`drop` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`ss` int(11) NOT NULL, `shems` varchar(250) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL, `sm` int(11) NOT NULL, `money` int(11) NOT
NULL, `exp` int(11) NOT NULL, `tip` varchar(25) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, `status` varchar(10) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, `time` int(25) NOT NULL, `oponent`
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `quest`
int(11) NOT NULL, `x` int(11) NOT NULL, `y` int(11) NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=766
; -- -- Дамп данных таблицы `mob` -- INSERT INTO `mob`
(`id`, `name`, `lvl`, `city`, `hp`, `hpall`, `umin`, `umax`, `pgolova`,
`pbody`, `pnogi`, `pmag`, `krit`, `ukrit`, `antikrit`, `lovk`, `sd`,
`drop`, `ss`, `shems`, `sm`, `money`, `exp`, `tip`, `status`, `time`,
`oponent`, `quest`, `x`, `y`) VALUES (760, 'Модный тип', 1,
'lave', 7, 7, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, '1', 0, '', 100, 3, 10,
'life', 'on', 10, 'not', 0, 0, 0), (761, 'Модный тип', 1, 'lave',
7, 7, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 100, '1', 0, '', 100, 3, 10, 'life',
'on', 10, 'not', 0, 0, 0), (762, 'Модный тип', 1, 'lave', 7, 7, 1,
2, 0, 0, 0, 0, 0, 0, 0, 0, 100, '1', 0, '', 100, 3, 10, 'life', 'on', 10,
'not', 0, 0, 0), (763, 'Модный тип', 1, 'lave', 7, 7, 1, 2, 0, 0,
0, 0, 0, 0, 0, 0, 100, '1', 0, '', 100, 3, 10, 'life', 'on', 10, 'not', 0,
0, 0), (764, 'Модный тип', 1, 'lave', 7, 7, 1, 2, 0, 0, 0, 0, 0,
0, 0, 0, 100, '1', 0, '', 100, 3, 10, 'life', 'on', 10, 'not', 0, 0,
0), (765, 'Модный тип', 1, 'lave', 7, 7, 1, 2, 0, 0, 0, 0, 0, 0,
0, 0, 100, '1', 0, '', 100, 3, 10, 'life', 'on', 10, 'not', 0, 0, 0); --
-------------------------------------------------------- -- --
Структура таблицы `msg_i` -- CREATE TABLE IF NOT EXISTS
`msg_i` ( `id` int(20) NOT NULL AUTO_INCREMENT, `user_from` varchar(25)
NOT NULL, `user_to` varchar(25) DEFAULT NULL, `time` varchar(25)
DEFAULT NULL, `mail_msg` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ; -- -- Дамп данных
таблицы `msg_i` -- INSERT INTO `msg_i` (`id`, `user_from`,
`user_to`, `time`, `mail_msg`) VALUES (1, 'test', 'test', '20:10 26.08.12',
'test'); --
-------------------------------------------------------- -- --
Структура таблицы `msg_r` -- CREATE TABLE IF NOT EXISTS
`msg_r` ( `id` int(20) NOT NULL AUTO_INCREMENT, `user_from` varchar(25)
NOT NULL, `user_to` varchar(25) DEFAULT NULL, `time` varchar(25)
DEFAULT NULL, `read` tinyint(1) DEFAULT NULL, `mail_msg` text,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=7
; -- -- Дамп данных таблицы `msg_r` -- INSERT INTO
`msg_r` (`id`, `user_from`, `user_to`, `time`, `read`, `mail_msg`)
VALUES (1, 'Dimasik', 'Администра', '02:41 11.08.12', 1,
'Добро пожаловать в игру Война миров!
Этот мир ждёт тебя, путешествуй, сражайся
и просто отдыхай! Советуем прочитать
библиотеку перед игрой! Администрацию
беспокоить только насчёт найденых
ошибок, недочётов и с предложениями!
Приятной игры!'), (2, 'Dimasik', 'Dima7ik', '14:54 26.08.12',
0, 'Добро пожаловать в игру Война миров!
Этот мир ждёт тебя, путешествуй, сражайся
и просто отдыхай! Советуем прочитать
библиотеку перед игрой! Администрацию
беспокоить только насчёт найденых
ошибок, недочётов и с предложениями!
Приятной игры!'), (3, 'System', 'Test', '17:09 26.08.12', 0,
'Добро пожаловать в игру Братки! Этот мир
ждёт тебя, путешествуй, сражайся и просто
отдыхай!'), (4, 'System', 'Dima7ik', '17:17 26.08.12', 0,
'Добро пожаловать в игру Братки! Этот мир
ждёт тебя, путешествуй, сражайся и просто
отдыхай!'), (5, 'System', 'test', '20:08 26.08.12', 0, 'Добро
пожаловать в игру Братки! Этот мир ждёт
тебя, путешествуй, сражайся и просто
отдыхай!'), (6, 'test', 'test', '20:10 26.08.12', 1, 'test'); --
-------------------------------------------------------- -- --
Структура таблицы `msg_users` -- CREATE TABLE IF NOT
EXISTS `msg_users` ( `user_id` int(10) NOT NULL, `contact` varchar(255)
NOT NULL, `time` varchar(25) NOT NULL, PRIMARY KEY
(`user_id`,`contact`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; --
-------------------------------------------------------- -- --
Структура таблицы `mshems` -- CREATE TABLE IF NOT EXISTS
`mshems` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100)
COLLATE utf8_unicode_ci NOT NULL, `name_item` varchar(100) COLLATE
utf8_unicode_ci NOT NULL, `lat_name` varchar(100) COLLATE utf8_unicode_ci
NOT NULL, `nead_res` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`unknow` int(11) NOT NULL, `tip` varchar(30) COLLATE utf8_unicode_ci NOT
NULL, `cena` int(11) NOT NULL, `scena` int(11) NOT NULL, `umin`
int(11) NOT NULL, `umax` int(11) NOT NULL, `pgolova` int(11) NOT NULL,
`pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL, `hp` int(11) NOT
NULL, `mp` int(11) NOT NULL, `krit` int(11) NOT NULL, `ukrit` int(11)
NOT NULL, `antikrit` int(11) NOT NULL, `sila` int(11) NOT NULL,
`lovk` int(11) NOT NULL, `um` int(11) NOT NULL, `prot` int(11) NOT
NULL, `klas` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `nsila`
int(11) NOT NULL, `num` int(11) NOT NULL, `nlovk` int(11) NOT NULL,
`nlvl` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ; -- -- Дамп
данных таблицы `mshems` -- INSERT INTO `mshems` (`id`,
`name`, `name_item`, `lat_name`, `nead_res`, `unknow`, `tip`, `cena`,
`scena`, `umin`, `umax`, `pgolova`, `pbody`, `pnogi`, `hp`, `mp`, `krit`,
`ukrit`, `antikrit`, `sila`, `lovk`, `um`, `prot`, `klas`, `nsila`, `num`,
`nlovk`, `nlvl`) VALUES (1, 'Щит гоблинов', 'Щит
гоблинов', 'shit_goblinov', 'derevo,10|jelezo,7', 0, 'shit', 250,
60, 0, 0, 8, 12, 4, 0, 0, 0, 0, 0, 1, 1, 0, 0, 'not', 6, 3, 5, 3), (2,
'Доспех Быка', 'Доспех Быка', 'body_bik',
'jelezo,20|derevo,5|luniy_kristal,15|nefrit,5|obsidian,5', 0, 'body', 300,
200, 0, 0, 10, 48, 12, 10, 0, 0, 0, 10, 4, 0, 0, 0, 'fighert', 24, 10, 16,
12), (3, 'Сапоги Молнии', 'Сапоги Молнии',
'nogi_molnii', 'jelezo,10|derevo,15|luniy_kristal,1|nefrit,5|koja,20', 0,
'nogi', 250, 220, 0, 0, 0, 0, 36, 0, 0, 0, 0, 0, 5, 0, 0, 0, 'not', 10, 16,
18, 7), (4, 'Клинок гоблинов', 'Клинок
гоблинов', 'weapon_goblins', 'jelezo,30|derevo,5', 0, 'weapon',
120, 100, 7, 17, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 4, 2, 5,
2), (5, 'Цеп', 'Крюк', 'weapon_cep', 'jelezo,14', 0, 'weapon', 120,
130, 11, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 4, 2, 5, 3), (6,
'Адский клинок', 'Адский клинок', 'weapon_cep',
'jelezo,15|fire_element,10', 0, 'weapon', 120, 130, 12, 34, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 'not', 4, 10, 8, 4), (7, 'Топорик',
'Топорик', 'weapon_topor', 'jelezo,10|derevo,15', 0, 'weapon', 9,
180, 1, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 4, 10, 8, 4), (8,
'Плащ шута', 'Плащ шута', 'plash_shuta', 'koja,7', 0,
'plash', 9, 120, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 1, 1, 1,
0); -- -------------------------------------------------------- -- --
Структура таблицы `news` -- CREATE TABLE IF NOT EXISTS
`news` ( `id` int(3) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT
NULL, `text` text NOT NULL, `nick` varchar(20) NOT NULL, `time`
varchar(25) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `npc` -- CREATE TABLE IF NOT EXISTS
`npc` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `img` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `quest` varchar(50)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- Дамп
данных таблицы `npc` -- INSERT INTO `npc` (`id`, `name`,
`city`, `img`, `quest`) VALUES (1, 'Гаральд', 'fornost',
'guard.gif', '1,2,3,8'), (3, 'Наставник Кель', 'fornost',
'mag.gif', '4,5,6'), (8, 'Харим', 'izmud', 'guard.gif', '17'), (5,
'Морган', 'amnos', 'guard.gif', '1,2,3,8'), (6, 'Наставник
Гозард', 'amnos', 'mag.gif', '4,5,6'); --
-------------------------------------------------------- -- --
Структура таблицы `npc_speack` -- CREATE TABLE IF NOT
EXISTS `npc_speack` ( `id` int(11) NOT NULL AUTO_INCREMENT, `npc`
int(11) NOT NULL, `dialog` varchar(30) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL, `text` text CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL, `quest` int(11) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `online` -- CREATE TABLE IF NOT EXISTS
`online` ( `usr` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `laikas`
int(20) DEFAULT NULL, `lvl` int(11) NOT NULL, PRIMARY KEY (`usr`),
KEY `laikas` (`laikas`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci; -- -- Дамп данных таблицы
`online` -- INSERT INTO `online` (`usr`, `laikas`, `lvl`) VALUES ('test',
1345997455, 0); --
-------------------------------------------------------- -- --
Структура таблицы `out` -- CREATE TABLE IF NOT EXISTS
`out` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10) COLLATE
utf8_unicode_ci NOT NULL, `timeout` varchar(25) COLLATE utf8_unicode_ci
NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ; --
-------------------------------------------------------- -- --
Структура таблицы `pit` -- CREATE TABLE IF NOT EXISTS
`pit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lord` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `status` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `rasa` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pol` varchar(5)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lvl` int(11) NOT
NULL, `lasteda` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL, `sec` int(11) NOT NULL, `dies` int(11) NOT NULL, `skill`
int(11) NOT NULL, `hp` int(11) NOT NULL, `hpall` int(11) NOT NULL,
`exp` int(11) NOT NULL, `sila` int(11) NOT NULL, `prot` int(11) NOT
NULL, `pgolova` int(11) NOT NULL, `pbody` int(11) NOT NULL, `pnogi`
int(11) NOT NULL, `antikrit` int(11) NOT NULL, `krit` int(11) NOT
NULL, `ukrit` int(11) NOT NULL, `lovk` int(11) NOT NULL, `umin`
int(11) NOT NULL, `umax` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=21 ; -- -- Дамп
данных таблицы `pit` -- INSERT INTO `pit` (`id`, `usr`,
`lord`, `name`, `status`, `rasa`, `pol`, `lvl`, `lasteda`, `sec`, `dies`,
`skill`, `hp`, `hpall`, `exp`, `sila`, `prot`, `pgolova`, `pbody`, `pnogi`,
`antikrit`, `krit`, `ukrit`, `lovk`, `umin`, `umax`) VALUES (1, 'Siavik8',
'Siavik8', 'КруШиТель', 'off', 'wolf', 'm', 7, '1293205811', 3600,
5, 0, 25, 25, 3579, 9, 9, 0, 0, 0, 10, 7, 10, 6, 9, 18), (2, 'Admin',
'Admin', 'Джек', 'off', 'wolf', 'm', 10, '1295040137', 2286, 4, 1, 30,
30, 18, 3, 2, 0, 0, 0, 10, 7, 10, 3, 4, 9), (3, 'bymer', 'bymer', '_ReX_',
'die', 'wolf', 'm', 11, '1294770252', 43200, 8, 0, 0, 30, 32657, 14, 14,
13, 16, 16, 10, 7, 10, 3, 20, 37), (4, 'Zuzo', 'Zuzo', 'Beretta', 'off',
'wolf', 'w', 7, '1294987867', 3600, 4, 0, 25, 25, 3810, 11, 10, 26, 32, 32,
10, 7, 10, 3, 28, 51), (5, 'MerztUA', 'MerztUA', 'Tyzik', 'off', 'wolf',
'm', 0, '1293530225', 3382, 0, 0, 4, 25, 26, 4, 3, 0, 0, 0, 10, 7, 10, 3,
4, 9), (6, 'Svet2', 'Vaxa', 'Мухтар', 'die', 'wolf', 'm', 3,
'1294987724', 3600, 3, 3, 0, 40, 357, 5, 2, 7, 8, 6, 10, 7, 10, 3, 7,
15), (7, 'Kentavr', 'Kentavr', 'Kentavrik', 'off', 'wolf', 'm', 0,
'1293624731', 3600, 0, 2, 25, 25, 0, 3, 2, 0, 0, 0, 10, 7, 10, 3, 4,
9), (8, 'rex1l', 'rex1l', 'Хати', 'off', 'wolf', 'm', 2, '1293651600',
2603, 0, 2, 17, 25, 100, 4, 4, 0, 0, 0, 10, 7, 10, 4, 7, 15), (10,
'FANTOM', 'FANTOM', 'PrIzRaK', 'off', 'wolf', 'm', 4, '1295030997', 4683,
0, 1, 25, 30, 548, 7, 6, 15, 13, 21, 10, 7, 10, 3, 15, 29), (12, 'JusT',
'JusT', 'АкамарУ', 'die', 'wolf', 'm', 2, '1294836096', 3600, 1, 0,
-5, 30, 194, 6, 3, 9, 9, 7, 10, 7, 10, 4, 7, 15), (13, 'Kolyancheg',
'Kolyancheg', 'HVOST', 'die', 'wolf', 'w', 5, '1295038730', 10800, 4, 0, 0,
35, 1032, 8, 4, 33, 37, 23, 10, 7, 10, 6, 20, 38), (14, 'SEXYBABY',
'Azirael', 'СветВоТьме', 'off', 'wolf', 'w', 4, '1295008262',
1524, 0, 0, 11, 30, 440, 6, 6, 16, 13, 13, 10, 7, 10, 5, 10, 21), (15,
'FaKToP', 'FaKToP', 'Чарли', 'off', 'wolf', 'm', 0, '1294653158',
6361, 0, 1, 11, 25, 24, 3, 3, 2, 1, 1, 10, 7, 10, 3, 4, 9), (16, 'Kardin',
'Kardin', 'Bad', 'die', 'dog', 'm', 6, '1294749213', 3600, 4, 4, 0, 40,
1750, 5, 6, 21, 25, 23, 11, 6, 15, 5, 19, 36), (17, 'retr44', 'retr44',
'лол', 'die', 'wolf', 'm', 3, '1294958434', 3600, 1, 0, 0, 30, 349, 7,
4, 20, 21, 17, 10, 7, 10, 4, 12, 24), (18, 'sobr', 'sobr', 'хвост',
'on', 'wolf', 'm', 4, '1294749840', 3600, 1, 8, 33, 35, 426, 3, 2, 9, 9, 7,
10, 7, 10, 3, 7, 15), (19, 'Karsar', 'Karsar', 'Лютоволк', 'off',
'wolf', 'm', 2, '1295011913', 2711, 0, 4, 11, 30, 190, 4, 2, 2, 9, 7, 10,
7, 10, 3, 4, 9), (20, 'Darck', 'JusT', 'Тёмненький', 'off',
'wolf', 'm', 2, '1295089171', 12181, 0, 6, 21, 25, 197, 3, 2, 2, 1, 1, 10,
7, 10, 3, 4, 9); --
-------------------------------------------------------- -- --
Структура таблицы `pitomec` -- CREATE TABLE IF NOT EXISTS
`pitomec` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(40)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `rasa` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `hp` int(11) NOT
NULL, `hpall` int(11) NOT NULL, `sila` int(11) NOT NULL, `prot`
int(11) NOT NULL, `pgolova` int(11) NOT NULL, `pbody` int(11) NOT
NULL, `pnogi` int(11) NOT NULL, `antikrit` int(11) NOT NULL, `krit`
int(11) NOT NULL, `ukrit` int(11) NOT NULL, `lovk` int(11) NOT NULL,
`umin` int(11) NOT NULL, `umax` int(11) NOT NULL, `cena` int(11) NOT
NULL, `lvl` int(11) NOT NULL, `klas` varchar(10) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ; -- -- Дамп данных
таблицы `pitomec` -- INSERT INTO `pitomec` (`id`, `city`, `name`,
`rasa`, `hp`, `hpall`, `sila`, `prot`, `pgolova`, `pbody`, `pnogi`,
`antikrit`, `krit`, `ukrit`, `lovk`, `umin`, `umax`, `cena`, `lvl`, `klas`)
VALUES (1, 'fornost', 'Волк', 'wolf', 25, 25, 3, 2, 2, 1, 1, 10, 7, 10,
3, 4, 9, 400, 5, 'not'), (2, 'fornost', 'Собака', 'dog', 20, 20, 2,
4, 1, 1, 1, 11, 6, 15, 4, 3, 7, 350, 5, 'not'), (3, 'amnos', 'Волк',
'wolf', 25, 25, 3, 2, 2, 1, 1, 10, 7, 10, 3, 4, 9, 400, 5, 'not'), (4,
'amnos', 'Собака', 'dog', 20, 20, 2, 4, 1, 1, 1, 11, 6, 15, 4, 3, 7,
350, 5, 'not'); --
-------------------------------------------------------- -- --
Структура таблицы `pit_item` -- CREATE TABLE IF NOT EXISTS
`pit_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pit` int(11) NOT
NULL, `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `cena` int(11) NOT NULL, `umin` int(11) NOT NULL, `umax`
int(11) NOT NULL, `pgolova` int(11) NOT NULL, `pbody` int(11) NOT
NULL, `pnogi` int(11) NOT NULL, `hp` int(11) NOT NULL, `krit` int(11)
NOT NULL, `ukrit` int(11) NOT NULL, `antikrit` int(11) NOT NULL,
`sila` int(11) NOT NULL, `lovk` int(11) NOT NULL, `rasa` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `nlvl` int(11) NOT
NULL, `image` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `pit_shop` -- CREATE TABLE IF NOT EXISTS
`pit_shop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(40)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cena` int(11) NOT
NULL, `umin` int(11) NOT NULL, `umax` int(11) NOT NULL, `pgolova`
int(11) NOT NULL, `pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL,
`hp` int(11) NOT NULL, `krit` int(11) NOT NULL, `ukrit` int(11) NOT
NULL, `antikrit` int(11) NOT NULL, `sila` int(11) NOT NULL, `lovk`
int(11) NOT NULL, `rasa` varchar(25) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL, `nlvl` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ; -- -- Дамп
данных таблицы `pit_shop` -- INSERT INTO `pit_shop` (`id`,
`city`, `tip`, `name`, `cena`, `umin`, `umax`, `pgolova`, `pbody`, `pnogi`,
`hp`, `krit`, `ukrit`, `antikrit`, `sila`, `lovk`, `rasa`, `nlvl`)
VALUES (1, 'lave', 'weapon', 'Деревяные когти', 100, 3, 6, 0,
0, 0, 0, 0, 0, 0, 0, 0, 'not', 1), (2, 'lave', 'weapon', 'Железные
когти', 323, 5, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 3), (3, 'lave',
'weapon', 'Железные боевые когти', 444, 7, 12, 0, 0, 0,
0, 0, 0, 0, 0, 0, 'not', 5), (4, 'lave', 'golova', 'Деревяный
шлем', 40, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 1), (5, 'lave',
'golova', 'Железный шлем', 80, 0, 0, 11, 0, 0, 0, 0, 0, 0, 0,
0, 'not', 3), (6, 'lave', 'golova', 'Железный шипастый
шлем', 160, 1, 2, 13, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 3), (7, 'lave',
'body', 'Кожаный доспех', 45, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0,
'not', 2), (8, 'lave', 'body', 'Плетённый кожаный
доспех', 90, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0, 0, 'not', 3), (9, 'lave',
'body', 'Железный нагрудник', 120, 0, 0, 0, 16, 0, 0, 0,
0, 0, 0, 0, 'not', 5), (10, 'lave', 'nogi', 'Плетённые
сапоги', 30, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 'not', 1), (11, 'lave',
'nogi', 'Меховые сапоги', 60, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0,
0, 'not', 2), (12, 'lave', 'nogi', 'Волчьи сапоги', 120, 0, 0,
0, 0, 16, 0, 0, 0, 0, 0, 0, 'not', 4); --
-------------------------------------------------------- -- --
Структура таблицы `pk` -- CREATE TABLE IF NOT EXISTS `pk`
( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL, `enemy` varchar(10) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL, `napal` int(11) NOT NULL, `xod`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ltime`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `block`
int(11) NOT NULL, `udar` int(11) NOT NULL, `mag` int(11) NOT NULL,
`pk` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=617 ; -- -- Дамп данных таблицы
`pk` -- INSERT INTO `pk` (`id`, `usr`, `enemy`, `napal`, `xod`, `tip`,
`ltime`, `block`, `udar`, `mag`, `pk`) VALUES (11, 'Bass', 'Bymer', 0,
'wait', 'mag', '1292847559', 0, 0, 76, 'lose'), (139, 'okc', 'Hooligan', 0,
'wait', 'ataka', '1294334145', 2, 3, 0, 'win'), (150, 'webmaster',
'Hooligan', 0, 'not', 'ataka', '1294335293', 1, 1, 294, 'lose'), (212,
'ANDRISNEG', 'Danpil', 0, 'wait', 'ataka', '1294404219', 1, 1, 0,
'lose'), (240, 'Cristo', 'JusT', 0, 'not', '', '1294416838', 0, 0, 0,
''), (551, 'Vlados', 'Dreiks', 1, 'not', 'ataka', '1295020697', 1, 2, 0,
''), (242, 'Favorit', 'JusT', 0, 'not', '', '1294417940', 0, 0, 0,
''), (282, 'Darg1', 'Dedad', 0, 'not', '', '1294505254', 0, 0, 0,
'lose'), (302, 'Drakyla', 'UraN', 0, 'not', '', '1294519148', 0, 0, 0,
''), (310, 'Arhangel', 'STAFF', 0, 'not', '', '1294521832', 0, 0, 0,
'lose'), (338, 'Blackguard', 'FaKToP', 0, 'not', '', '1294572511', 0, 0, 0,
''), (458, 'DeadFates', 'Vaxa', 0, 'not', '', '1294699183', 0, 0, 0,
''), (554, 'nicecat', 'Joy', 0, 'not', '', '1295021357', 0, 0, 0,
''), (538, 'messer', 'Darck', 0, 'not', '', '1295002810', 0, 0, 0,
''), (609, 'Edyapd', 'IMPERATOR', 1, 'wait', 'ataka', '1295079160', 1, 1,
0, ''), (600, 'OOH', 'Xmaster', 0, 'not', '', '1295051674', 0, 0, 0,
''), (580, 'Dakilla', 'Aziat', 0, 'not', '', '1295039140', 0, 0, 0,
''), (574, 'zevs', 'Psix', 0, 'not', '', '1295038483', 0, 0, 0, ''), (610,
'IMPERATOR', 'Edyapd', 0, 'not', '', '1295079125', 0, 0, 0, ''), (611,
'secret', 'Rengen', 1, 'wait', 'mag', '1306831132', 0, 0, 493, ''), (612,
'Rengen', 'secret', 0, 'not', '', '1306831106', 0, 0, 0, ''); --
-------------------------------------------------------- -- --
Структура таблицы `portal` -- CREATE TABLE IF NOT EXISTS
`portal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `incity` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `money` int(11) NOT
NULL, `lvl` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8 ; -- -- Дамп данных
таблицы `portal` -- INSERT INTO `portal` (`id`, `name`, `city`,
`incity`, `money`, `lvl`) VALUES (1, 'Измуд', 'izmud', 'fornost1',
100, 6), (3, 'Земли Форноста', '', 'fornost', 0, 0), (5,
'Гундабад', 'gundabad', 'fornost1', 100, 6), (6, 'Форност',
'fornost', 'gundabad', 50, 0), (7, 'Форност', 'fornost', 'izmud',
50, 0); -- -------------------------------------------------------- -- --
Структура таблицы `quest_res` -- CREATE TABLE IF NOT
EXISTS `quest_res` ( `id` int(11) NOT NULL AUTO_INCREMENT, `quest`
int(11) NOT NULL, `name` varchar(40) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL, `lat_name` varchar(40) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, `tip` varchar(30) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, `what` varchar(25) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, `give` varchar(40) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL, `kol` int(11) NOT NULL, `cena`
int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=2 ; -- -- Дамп данных
таблицы `quest_res` -- INSERT INTO `quest_res` (`id`, `quest`,
`name`, `lat_name`, `tip`, `what`, `give`, `kol`, `cena`) VALUES (1, 1,
'MP-10', 'MP-10', 'elexir', 'mp', '10', 2, 25); --
-------------------------------------------------------- -- --
Структура таблицы `regenerator` -- CREATE TABLE IF NOT
EXISTS `regenerator` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `last`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=548
; -- -- Дамп данных таблицы `regenerator` -- INSERT INTO
`regenerator` (`id`, `usr`, `last`) VALUES (1, 'Admin', '1345978448'), (2,
'Bymer', '1295079308'), (3, 'chester', '1292758451'), (4, 'DarkAngel',
'1293539115'), (5, 'CENTR', '1294657446'), (6, 'Bymer', '1295013818'), (7,
'HeMeCuC', '1293649494'), (8, 'Paladin', '1295038361'), (9, 'SHEPERD',
'1295071819'), (10, 'Angelus', '1294342808'), (11, 'Kalf',
'1292764435'), (12, 'Tufi4', '1294856365'), (13, 'Zajka111',
'1292869608'), (14, 'Siavik8', '1295022745'), (15, '05DAG',
'1292795252'), (16, 'WaT', '1307393156'), (17, 'WARLOK',
'1293467644'), (18, 'Malik', '1292859568'), (19, 'MortalDoG',
'1292841015'), (20, 'Zuzo', '1295045715'), (21, 'PARKURIST',
'1292768556'), (22, 'COHHbIU', '1292768483'), (23, 'escander',
'1292911671'), (24, 'Player161m', '1292768585'), (25, 'Player61mk',
'1292768795'), (26, 'PrInC_ZuKo', '1292964229'), (27, 'Fight_cat',
'1292830887'), (28, 'ImbaCodeR', '1292769364'), (29, 'mult',
'1292909537'), (30, 'CBAPKA', '1292769657'), (31, 'Squeez',
'1292769655'), (32, 'Skarabey', '1295041255'), (33, 'DamageBlow',
'1292769760'), (34, 'Destroyer', '1292769822'), (35, 'Greed',
'1293177731'), (36, 'Dark_BouH', '1292913275'), (37, 'tutan',
'1292772139'), (38, 'CTALEB', '1295072588'), (39, 'Morgan',
'1295062127'), (40, 'Schikamaru', '1292852694'), (41, 'Nekrommant',
'1292773084'), (42, 'Edyapd', '1295079116'), (43, 'pimka',
'1292773788'), (44, 'AR4ER', '1292775384'), (45, 'Aristarh',
'1293165250'), (46, 'Akhenaton', '1292946638'), (47, 'Buldozer',
'1292849321'), (48, 'Rasmus', '1292827415'), (49, 'NiberiaN',
'1293407453'), (50, 'AR4ER2', '1292776387'), (51, 'Kipr2',
'1293565540'), (52, 'KORSHUN', '1293517995'), (53, 'ELESEI',
'1292781771'), (54, 'Innot', '1292776343'), (55, 'ar4er3',
'1292777129'), (56, 'JIegolaS', '1292935399'), (57, 'Danker',
'1293031608'), (58, 'Iceman', '1292777876'), (59, 'Kotik',
'1292779993'), (60, 'ColleR', '1292778062'), (61, 'BOJIKODAB',
'1292782955'), (62, 'RAN95', '1293268309'), (63, 'Sneg',
'1292783740'), (64, 'Diablo', '1294671577'), (65, 'JlOPD',
'1295010235'), (66, 'Pegas', '1292927840'), (67, 'Jasper',
'1293261053'), (68, 'Werwolf', '1295014898'), (69, 'Seriu',
'1294918809'), (70, 'KatastrOFF', '1292808957'), (71, 'Shrastr',
'1292882583'), (72, 'XEDIN', '1295005869'), (73, 'player',
'1292827467'), (74, 'enekin', '1292837484'), (75, 'maksimys',
'1292841583'), (76, 'Bass', '1292847533'), (77, 'Maho', '1292854623'), (78,
'TerrorBlad', '1292855121'), (79, 'Dimarik', '1292856500'), (80, 'Pagyra',
'1292860686'), (81, 'gyvi', '1292862587'), (82, 'MerztUA',
'1293656254'), (83, 'Dievka', '1292914377'), (84, 'nikneim',
'1292918427'), (85, 'Kentavr', '1294597383'), (86, 'Dead',
'1292929970'), (87, 'Lich', '1293690216'), (88, 'Hats', '1292946993'), (89,
'AXILES', '1292950904'), (90, 'Builder', '1293369454'), (91, 'nightboy',
'1292989104'), (92, 'Gladiator9', '1293084694'), (93, 'Ruy',
'1293001769'), (94, 'dominik', '1293010160'), (95, 'ArSide',
'1293027350'), (96, 'Luchian', '1293027498'), (97, 'GambiT',
'1293082992'), (98, '4yna', '1293211236'), (99, 'DanteVers',
'1293211461'), (100, 'Gman', '1293212374'), (101, 'super3',
'1293214491'), (102, 'Tomas', '1293218310'), (103, 'serenya',
'1293228670'), (104, 'kakula', '1293216443'), (105, 'cRAyZic',
'1293217987'), (106, 'VAXA', '1295047927'), (107, '1997',
'1293217583'), (108, 'Sanya', '1294907854'), (109, 'tetso',
'1293218668'), (110, 'car', '1293220830'), (111, 'Kitty',
'1293229433'), (112, 'float', '1293254603'), (113, 'Gargulja',
'1293258740'), (114, 'Aural', '1295025400'), (115, 'CatcheR',
'1293256562'), (116, 'admin94', '1293258173'), (117, 'Skinface',
'1293258454'), (118, 'Ruslanrap', '1293269160'), (119, 'Rex1L',
'1294989122'), (120, 'Svet21', '1293260076'), (121, 'golum',
'1293260269'), (122, 'Neptun1981', '1293262265'), (123, 'Dryid',
'1295071422'), (124, 'karakym', '1293261304'), (125, 'Odessit',
'1293294212'), (126, 'WowaA', '1293262560'), (127, 'foxxx',
'1293645985'), (128, '66666', '1293262738'), (129, 'DevilMak',
'1293263621'), (130, 'samyel', '1293263489'), (131, 'daniel',
'1293263570'), (132, 'Ayanami', '1293263940'), (133, 'Svetlui29',
'1294376315'), (134, 'troll', '1293264739'), (135, 'Dorosh',
'1293264178'), (136, 'Demon', '1293278036'), (137, 'Lican',
'1293449121'), (138, 'Noshpa', '1293269009'), (139, 'qwe',
'1293270412'), (140, 'Rolsen', '1293273488'), (141, 'POMAH',
'1293373244'), (142, 'Upitus', '1293273705'), (143, 'Noiseless',
'1294413251'), (144, 'konan', '1293281815'), (145, 'Gasoff',
'1293287527'), (146, 'FANTOM', '1295079613'), (147, 'Blackguard',
'1294572455'), (148, 'UQALOVNIK', '1293302460'), (149, 'fesk',
'1293293733'), (150, 'Neo', '1294996783'), (151, 'Pycc',
'1293297086'), (152, 'Tiran', '1293297518'), (153, 'Dreiks',
'1295055883'), (154, 'doktor', '1295012954'), (155, 'shevaekb',
'1293339456'), (156, 'Mondragon', '1293341831'), (157, 'Avtor',
'1293575797'), (158, 'Laskovina', '1294704972'), (159, 'GammeR',
'1293361712'), (160, 'Shashka', '1293364106'), (161, 'Deran',
'1293364477'), (162, 'kronus', '1293364578'), (163, 'xxx',
'1294922837'), (164, 'Aliccca', '1294323841'), (165, 'tilad',
'1293379182'), (166, 'GanibalL', '1293536658'), (167, 'ORMAGEDON',
'1293379757'), (168, 'avatarka', '1293382337'), (169, 'Nekit',
'1293389035'), (170, 'liliana', '1294344552'), (171, 'Xatab',
'1293391975'), (172, 'kosenko', '1293397233'), (173, 'Fanatka',
'1293406792'), (174, 'VinnyOpux', '1293412002'), (175, 'Bogiinjaaa',
'1293464738'), (176, 'Orel', '1293446797'), (177, 'VIP',
'1293453285'), (178, 'zoorik', '1294406305'), (179, 'STEFF',
'1295079817'), (180, 'Tay', '1293448357'), (181, 'SkoRoST',
'1293447994'), (182, 'Gorthar', '1294667360'), (183, 'kertinor',
'1293460905'), (184, 'Steelsam', '1293449735'), (185, 'Swas',
'1293448986'), (186, 'Bodi', '1294386419'), (187, 'kamatin',
'1293454153'), (188, 'amarelle', '1293449960'), (189, 'ARGUS',
'1293450263'), (190, 'Solopan7', '1293452790'), (191, 'DarkMaster',
'1293454239'), (192, 'dark', '1293454286'), (193, 'kashax',
'1293454795'), (194, 'i7cux', '1293456880'), (195, 'Beretta',
'1294689627'), (196, 'Leseinok', '1293601790'), (197, 'Mechta',
'1293465807'), (198, 'CATBLAK', '1293465944'), (199, 'CATBLAKK',
'1293466219'), (200, 'Konstantin', '1293471808'), (201, 'Magelan',
'1295012407'), (202, 'messer', '1295002663'), (203, 'leto',
'1293474684'), (204, 'icewar', '1293479679'), (205, 'megatron',
'1293477281'), (206, 'bboytwist', '1293537480'), (207, 'tester',
'1293477293'), (208, 'Pudge', '1293476019'), (209, 'Misterio',
'1293479153'), (210, 'GatMan', '1293477278'), (211, 'barsik',
'1293619461'), (212, 'fantast', '1293479979'), (213, '111',
'1293480777'), (214, 'Alex', '1293482648'), (215, 'Frantix',
'1293484085'), (216, 'Brinn', '1293604772'), (217, 'Karlajl',
'1294528436'), (218, 'Alter', '1295028279'), (219, 'jok',
'1293546185'), (220, 'Bolk', '1293549111'), (221, 'ivan_',
'1293547891'), (222, 'dania', '1293568070'), (223, 'staf',
'1293548805'), (224, 'MAxy47', '1293586368'), (225, 'mixecb',
'1307238316'), (226, 'agranom', '1293588663'), (227, 'Serjo',
'1293553921'), (228, 'maxbot', '1293550668'), (229, 'FrOzeN',
'1293550737'), (230, 'Windows', '1293552624'), (231, 'Sne[G]',
'1293551380'), (232, 'Kaly4ij', '1293556527'), (233, 'YxTbl',
'1293556664'), (234, 'Svarog', '1293638705'), (235, 'angel_tech',
'1294411920'), (236, 'RAKOT', '1293556719'), (237, 'malekula',
'1293557057'), (238, 'Osvald', '1293558209'), (239, 'SSorry',
'1293582490'), (240, 'Darkrico', '1293557399'), (241, 'Bacma4',
'1294887029'), (242, 'sobr', '1294747794'), (243, 'STERIAN',
'1293557348'), (244, '_BAX', '1294416616'), (245, 'Devochka',
'1293562860'), (246, 'shamannn', '1293640583'), (247, 'Kolyancheg',
'1295067389'), (248, 'Alexgop', '1293560582'), (249, 'gotka',
'1293560925'), (250, 'woron', '1293559769'), (251, 'gloinm',
'1293560237'), (252, 'GAUCH', '1295034385'), (253, 'DragonGirl',
'1294680889'), (254, 'Koketka', '1293621521'), (255, 'soven',
'1293564451'), (256, 'japotai', '1293570803'), (257, 'Arahnidik',
'1293571608'), (258, 'nomad', '1293610868'), (259, 'Fess',
'1294978226'), (260, 'Derek', '1294980213'), (261, 'Skif',
'1295078345'), (262, 'kola11', '1293612706'), (263, 'Sauron',
'1293613379'), (264, 'Svet2', '1295007798'), (265, 'Volter',
'1293623031'), (266, '777TbMA777', '1293626448'), (267, 'I_V_A_N',
'1293626049'), (268, 'retr', '1294499793'), (269, 'Retr44',
'1294979238'), (270, 'warcrafr', '1293635376'), (271, 'S_H_O_K',
'1293636519'), (272, 'Artemka', '1293648542'), (273, 'ioan',
'1293646057'), (274, 'MegaMage', '1293648198'), (275, 'Erion',
'1293683856'), (276, 'Gop', '1294747732'), (277, 'Death',
'1294326290'), (278, 'Alarion', '1293697339'), (279, 'trest',
'1294055838'), (280, 'frenk', '1294060996'), (281, 'googk',
'1294321776'), (282, 'Azirael', '1295076707'), (283, 'BartSMP',
'1294329150'), (284, 'okc', '1294334043'), (285, 'Hooligan',
'1294378645'), (286, 'VikO', '1294337765'), (287, 'webmaster',
'1294335103'), (288, 'VikkI', '1294396710'), (289, 'Danika',
'1294341846'), (290, 'UraN', '1295048247'), (291, 'ElfStas',
'1294345700'), (292, 'Dante', '1294953104'), (293, 'DeadFate',
'1294438171'), (294, 'JusT', '1295047858'), (295, 'DeadFates',
'1294699085'), (296, 'svist', '1294377077'), (297, 'Svetlui',
'1294377803'), (298, 'HOBOMOCKOB', '1294382402'), (299, 'Hobomockob',
'1294382579'), (300, 'Stribog', '1294511941'), (301, 'kaban',
'1294830344'), (302, 'Hobomockob', '1294403171'), (303, 'Danpil',
'1294442356'), (304, 'ANDRISNEG', '1294404060'), (305, 'Skill',
'1294405127'), (306, 'SyRoK', '1294405047'), (307, 'Valakas',
'1294405109'), (308, 'Antonio', '1294473410'), (309, 'BiZkViT',
'1294407330'), (310, 'AlexeyM', '1294409026'), (311, 'borman',
'1294412430'), (312, 'angeltech', '1294578488'), (313, 'Cristo',
'1294416838'), (314, 'Luba', '1294415598'), (315, 'sex',
'1295012779'), (316, 'Zizo_IIida', '1294416397'), (317, 'Zizo_raHdo',
'1294416524'), (318, 'Admin_bLl9', '1294416706'), (319, 'Zizo_yebaH',
'1294417463'), (320, 'Favorit', '1294417872'), (321, 'Bymer_lox',
'1294417654'), (322, 'Bymer_IIeT', '1294417654'), (323, 'KiskaSveta',
'1294432049'), (324, 'AdiosAmigo', '1294442153'), (325, 'Versache',
'1294442989'), (326, 'Tork', '1294455485'), (327, 'Faust',
'1294992382'), (328, 'Inferno', '1295056522'), (329, 'FaKToP',
'1294757265'), (330, 'Gadya', '1294493526'), (331, 'artemka47',
'1294495271'), (332, 'Fallen_Ang', '1294495824'), (333, 'Dark_Angel',
'1294497319'), (334, 'orexokol', '1294501580'), (335, 'Armer',
'1294502132'), (336, 'Dedad', '1294506453'), (337, 'Darg1',
'1294505250'), (338, 'Demomiks', '1295074704'), (339, 'JOLOCHKA',
'1294956139'), (340, 'BOBOLIK', '1294510428'), (341, 'Leschiy',
'1294962286'), (342, 'Goove', '1294512624'), (343, 'Drakyla',
'1294518997'), (344, 'CaTaHa', '1294519193'), (345, 'geg',
'1294519828'), (346, 'Arhangel', '1294521816'), (347, 'STAFF',
'1294522032'), (348, 'Merlin', '1294560555'), (349, 'LoraBlood',
'1294985624'), (350, 'ForesTWalk', '1294530921'), (351, 'Angel',
'1294561918'), (352, 'Aleksandr', '1294572323'), (353, 'Game0ver',
'1294565988'), (354, 'firemystan', '1294568906'), (355, 'Night_lord',
'1294911788'), (356, 'flipp', '1294576407'), (357, 'triceraton',
'1294578162'), (358, 'FLAGMAN', '1294594383'), (359, 'zlo777',
'1294579977'), (360, 'Sergius', '1294581622'), (361, 'ben11',
'1294582126'), (362, 'Grafikk', '1295070587'), (363, 'krest',
'1294651655'), (364, 'Kardin', '1295076787'), (365, '_The_BesT_',
'1294583976'), (366, 'VIDOQ', '1294584993'), (367, 'ForsakeN',
'1294585093'), (368, 'eLkz0r', '1294588741'), (369, 'BOPC',
'1294585129'), (370, 'Kenny', '1294588531'), (371, 'dengt',
'1294632211'), (372, 'alexs', '1294601832'), (373, 'blkc',
'1294600318'), (374, 'Mishanya', '1307286722'), (375, 'Karsar',
'1307264856'), (376, 'DZEDAY', '1294674611'), (377, 'Amoon',
'1294607967'), (378, 'XDDD', '1294620870'), (379, 'Crazy',
'1294628607'), (380, 'StenLee', '1294659695'), (381, 'ViPeX',
'1294660201'), (382, 'Kin', '1294665740'), (383, 'alexz',
'1294684472'), (384, 'ranger', '1294695316'), (385, 'mercs',
'1294697847'), (386, 'Freiheit', '1294704317'), (387, 'SEXYBABY',
'1295079207'), (388, 'Kopcap', '1294992626'), (389, 'groznaya',
'1294732856'), (390, 'groza', '1294754151'), (391, 'xxx',
'1294922811'), (392, 'Larn', '1294749938'), (393, 'Aragorn',
'1294757426'), (394, 'Anarchist', '1295079864'), (395, 'x2so4',
'1295077182'), (396, 'Dessar', '1294894061'), (397, 'dwe',
'1294839973'), (398, 'Dragon', '1294844875'), (399, 'Zver_77z',
'1294901501'), (400, 'Fantagira', '1295070262'), (401, 'stefx',
'1295078854'), (402, 'Alkagolik', '1294857757'), (403, 'Altair_201',
'1294891210'), (404, 'SerG', '1294952437'), (405, 'reee',
'1294952140'), (406, 'dasse', '1294953895'), (407, 'Sanja111',
'1294982763'), (408, 'Xpert', '1295079837'), (409, 'Dereks',
'1295074556'), (410, 'Darck', '1295079854'), (411, 'novoros',
'1295022668'), (412, 'Joy', '1295038692'), (413, 'Vlados',
'1295020606'), (414, 'nicecat', '1295021350'), (415, 'Glef',
'1295030941'), (416, 'Tores', '1295030853'), (417, 'big4781159',
'1295027862'), (418, 'andrey', '1295028799'), (419, 'Rambo',
'1295029066'), (420, 'STARKILLER', '1295070545'), (421, 'Bibol',
'1295038345'), (422, 'Spayk', '1295029274'), (423, 'DUDEC',
'1295048869'), (424, 'vovaxn', '1295029992'), (425, 'jaguar',
'1295030515'), (426, 'Dblmok', '1295030802'), (427, 'Scorpion',
'1295032036'), (428, 'jaguar13', '1295036175'), (429, 'neviper',
'1295033500'), (430, 'Firefoxy', '1295033693'), (431, 'RASSIA360',
'1295037742'), (432, 'Greench', '1295036296'), (433, 'ferb',
'1295036764'), (434, 'Psix', '1295039152'), (435, 'Winston',
'1295048275'), (436, 'zevs', '1295038421'), (437, 'JOKER',
'1295036967'), (438, '4eJI', '1295037664'), (439, 'Schokk',
'1295038080'), (440, 'The_Straw', '1295037518'), (441, 'Maestro',
'1295040518'), (442, 'Vetalik', '1295062658'), (443, 'Aziat',
'1295041520'), (444, 'Dakilla', '1295039137'), (445, 'LocDevil',
'1295045275'), (446, 'OOH', '1295051672'), (447, 'Fcdk',
'1295059873'), (448, 'Xmaster', '1295052165'), (449, 'Infinity',
'1295053303'), (450, 'IMPERATOR9', '1295059113'), (451, 'Diabolo',
'1295063483'), (452, 'IMPERATOR', '1295079028'), (453, 'GLOBAL',
'1306762513'), (454, 'pidorok', '1307292437'), (455, 'mdmdmd',
'1306763906'), (456, 'maitre', '1307112516'), (457, 'mah',
'1306765173'), (458, 'adada', '1306765234'), (459, 'Admin1',
'1306765549'), (460, 'qawsed', '1306765994'), (461, 'MaZaFaKa',
'1306766329'), (462, 'xfth', '1306766440'), (463, 'ipman',
'1306767303'), (464, 'dotoni', '1306784936'), (465, 'Apec',
'1306777128'), (466, 'PavluxXxa', '1306777035'), (467, 'sssaaa',
'1306779309'), (468, 'test', '1345997455'), (469, 'yanm',
'1306781630'), (470, 'qqqqq', '1306780695'), (471, 'masdjkasdb',
'1306780914'), (472, 'Sefan', '1306887495'), (473, 'test08',
'1306786548'), (474, 'veve', '1306787924'), (475, 'Fear',
'1306844633'), (476, 'Jadson', '1306795873'), (477, 'Amnesia',
'1306848513'), (478, 'Kefir', '1306796293'), (479, 'Maximys',
'1306816484'), (480, 'Aidzawa', '1306811466'), (481, 'kleker',
'1306828238'), (482, 'bylsd', '1306829299'), (483, 'secret',
'1306831106'), (484, 'Rengen', '1306831042'), (485, 'Reflesh',
'1306833884'), (486, '45455', '1306835747'), (487, 'AlexN',
'1306837040'), (488, 'Chechen', '1306839570'), (489, 'rimmus',
'1306840798'), (490, 'Weebl', '1306842749'), (491, 'AristokraT',
'1307346844'), (492, 'omeha3', '1306849936'), (493, 'rastoman',
'1306852811'), (494, 'Svershok', '1306851672'), (495, 'asdasd',
'1306855584'), (496, 'Kubik', '1306870168'), (497, 'kazbek',
'1306871132'), (498, 'acult', '1306876445'), (499, 'kolobok',
'1306878969'), (500, 'DeadKing', '1306882878'), (501, 'den973',
'1306919200'), (502, 'LogaN', '1306906487'), (503, 'Qvest',
'1306915523'), (504, 'tato', '1306931062'), (505, 'kes',
'1306944220'), (506, 'Arksi', '1306944616'), (507, 'Vlad',
'1306947624'), (508, 'Get', '1306949880'), (509, 'AsQuaD',
'1307174940'), (510, 'VAMPIRE', '1307004863'), (511, 'qwer',
'1307421215'), (512, 'Reaktor', '1307007952'), (513, 'YRAN',
'1307012559'), (514, 'fgdfgdfg', '1307024208'), (515, 'fgsdgfsdfd',
'1307025290'), (516, 'dadada', '1307102317'), (517, 'Aristokra2',
'1307031937'), (518, 'zolotojkol', '1307039283'), (519, 'XTREME',
'1307204546'), (520, 'azad', '1307040840'), (521, 'Mjolner',
'1307111856'), (522, '121212', '1307112937'), (523, 'Admiralik',
'1307204645'), (524, 'cretozzz', '1307119775'), (525, 'Cijey',
'1307165032'), (526, 'doctor', '1307175530'), (527, 'Japan',
'1307216840'), (528, 'Adamka', '1307203359'), (529, 'Timon',
'1307217209'), (530, 'Win4esteR', '1307221953'), (531, 'Sheva',
'1307226101'), (532, 'Yaropoloff', '1307249784'), (533, 'FacelesS',
'1307267967'), (534, 'jek2010', '1307300935'), (535, 'fffffff',
'1307355125'), (536, 'spawnleg', '1307367966'), (537, 'qwerasd',
'1307381442'), (538, 'peresvet', '1307427718'), (539, 'LVI32',
'1307401821'), (540, 'Merzkii', '1307412079'), (541, 'olimp',
'1307427719'), (542, 'affko', '1307444348'), (543, 'Администра',
'1344638487'), (544, 'Dima7ik', '1345997259'), (545, 'Test',
'1345986558'), (546, 'Dima7ik', '1345994870'), (547, 'test',
'1345997314'); --
-------------------------------------------------------- -- --
Структура таблицы `res` -- CREATE TABLE IF NOT EXISTS
`res` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(40)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lat_name`
varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `what`
varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `give`
varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `kol`
int(11) NOT NULL, `cena` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- Дамп
данных таблицы `res` -- INSERT INTO `res` (`id`, `usr`,
`name`, `lat_name`, `tip`, `what`, `give`, `kol`, `cena`) VALUES (1,
'Admin', 'HP-10', 'HP-10', 'elexir', 'hp', '10', 1, 25), (2, 'Dima7ik',
'MP-5', 'MP-5', 'elexir', 'mp', '5', 2, 15), (3, 'Dima7ik', 'Камень',
'kamen', 'res', 'res', '0', 1, 6), (4, 'Dima7ik', 'Дерево', 'derevo',
'res', 'res', '0', 2, 9); --
-------------------------------------------------------- -- --
Структура таблицы `rydnik` -- CREATE TABLE IF NOT EXISTS
`rydnik` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `over` varchar(25) COLLATE
utf8_unicode_ci NOT NULL, `last` varchar(25) COLLATE utf8_unicode_ci NOT
NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ; -- -- Дамп данных
таблицы `rydnik` -- INSERT INTO `rydnik` (`id`, `usr`, `over`,
`last`) VALUES (15, 'FacelesS', '1307270371', '1307267971'); --
-------------------------------------------------------- -- --
Структура таблицы `shemaz` -- CREATE TABLE IF NOT EXISTS
`shemaz` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tip` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `shems` varchar(250) COLLATE
utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT
CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; -- -- Дамп
данных таблицы `shemaz` -- INSERT INTO `shemaz` (`id`, `tip`,
`shems`) VALUES (1, '1', '1,8,7,5'), (2, '2', '1,8,7,5,3,4'), (3, '2',
'1,8,7,5,3,4,2,6'); --
-------------------------------------------------------- -- --
Структура таблицы `shems` -- CREATE TABLE IF NOT EXISTS
`shems` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `name` varchar(100) COLLATE
utf8_unicode_ci NOT NULL, `name_item` varchar(100) COLLATE
utf8_unicode_ci NOT NULL, `lat_name` varchar(100) COLLATE utf8_unicode_ci
NOT NULL, `nead_res` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`unknow` int(11) NOT NULL, `tip` varchar(30) COLLATE utf8_unicode_ci NOT
NULL, `cena` int(11) NOT NULL, `scena` int(11) NOT NULL, `umin`
int(11) NOT NULL, `umax` int(11) NOT NULL, `pgolova` int(11) NOT NULL,
`pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL, `hp` int(11) NOT
NULL, `mp` int(11) NOT NULL, `krit` int(11) NOT NULL, `ukrit` int(11)
NOT NULL, `antikrit` int(11) NOT NULL, `sila` int(11) NOT NULL,
`lovk` int(11) NOT NULL, `um` int(11) NOT NULL, `prot` int(11) NOT
NULL, `klas` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `nsila`
int(11) NOT NULL, `num` int(11) NOT NULL, `nlovk` int(11) NOT NULL,
`nlvl` int(11) NOT NULL, `kol` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1
; -- -------------------------------------------------------- -- --
Структура таблицы `shop` -- CREATE TABLE IF NOT EXISTS
`shop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(40)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cena` int(11) NOT
NULL, `umin` int(11) NOT NULL, `umax` int(11) NOT NULL, `pgolova`
int(11) NOT NULL, `pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL,
`hp` int(11) NOT NULL, `mp` int(11) NOT NULL, `krit` int(11) NOT NULL,
`ukrit` int(11) NOT NULL, `antikrit` int(11) NOT NULL, `sila` int(11)
NOT NULL, `lovk` int(11) NOT NULL, `um` int(11) NOT NULL, `prot`
int(11) NOT NULL, `klas` varchar(10) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL, `nsila` int(11) NOT NULL, `num` int(11) NOT
NULL, `nlovk` int(11) NOT NULL, `nlvl` int(11) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- --
Дамп данных таблицы `shop` -- INSERT INTO `shop` (`id`,
`city`, `tip`, `name`, `cena`, `umin`, `umax`, `pgolova`, `pbody`, `pnogi`,
`hp`, `mp`, `krit`, `ukrit`, `antikrit`, `sila`, `lovk`, `um`, `prot`,
`klas`, `nsila`, `num`, `nlovk`, `nlvl`) VALUES (1, 'lave', 'weapon',
'Полусломаный ППш', 250, 15, 35, 0, 0, 0, 0, 0, 0, 1, 0, 1,
1, 1, 0, 'not', 0, 0, 0, 0), (2, 'lave', 'golova', 'Кепка', 100, 0, 0,
10, 0, 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, 'not', 0, 0, 0, 0), (3, 'lave',
'body', 'Футболка', 100, 0, 0, 0, 10, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1,
'not', 0, 0, 0, 0), (4, 'lave', 'ruki', 'Битки', 70, 1, 2, 0, 0, 0, 1,
0, 1, 1, 1, 1, 1, 0, 1, 'not', 0, 0, 0, 0), (5, 'lave', 'nogi', 'Кеды',
80, 1, 2, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 1, 'not', 0, 0, 0, 0), (6,
'lave', 'plash', 'Олимпика', 100, 0, 0, 0, 5, 0, 1, 0, 0, 0, 0, 0,
0, 0, 1, 'not', 0, 0, 0, 0), (7, 'lave', 'poyas', 'Ремень', 35, 0, 0,
0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 0, 0, 0, 0), (8, 'lave', 'shit',
'Бронежилет', 300, 0, 0, 0, 30, 0, 15, 0, 0, 0, 10, 0, 3, 0, 10,
'not', 0, 0, 0, 0), (9, 'lave', 'amulet', 'Цепь', 10, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 'not', 0, 0, 0, 0), (10, 'lave', 'kolco',
'Кольцо', 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'not', 0, 0,
0, 0); -- -------------------------------------------------------- -- --
Структура таблицы `shopelexirs` -- CREATE TABLE IF NOT
EXISTS `shopelexirs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city`
varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name`
varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`lat_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `give` int(11) NOT NULL, `cena` int(11) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- --
Дамп данных таблицы `shopelexirs` -- INSERT INTO
`shopelexirs` (`id`, `city`, `name`, `lat_name`, `tip`, `what`, `give`,
`cena`) VALUES (1, 'lave', 'HP-10', 'HP-10', 'elexir', 'hp', 10, 5), (2,
'lave', 'HP-50', 'HP-50', 'elexir', 'hp', 50, 50), (3, 'lave', 'HP-100',
'HP-100', 'elexir', 'hp', 100, 100); --
-------------------------------------------------------- -- --
Структура таблицы `shop_aura` -- CREATE TABLE IF NOT
EXISTS `shop_aura` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city`
varchar(30) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(100) COLLATE
utf8_unicode_ci NOT NULL, `lat_name` varchar(100) COLLATE utf8_unicode_ci
NOT NULL, `cena` int(11) NOT NULL, `umin` int(11) NOT NULL, `umax`
int(11) NOT NULL, `protect` int(11) NOT NULL, `hp` int(11) NOT NULL,
`mp` int(11) NOT NULL, `krit` int(11) NOT NULL, `ukrit` int(11) NOT
NULL, `klas` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `nsila`
int(11) NOT NULL, `num` int(11) NOT NULL, `nlovk` int(11) NOT NULL,
`nlvl` int(11) NOT NULL, `actime` int(32) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=14 ; -- -- Дамп данных таблицы
`shop_aura` -- INSERT INTO `shop_aura` (`id`, `city`, `name`, `lat_name`,
`cena`, `umin`, `umax`, `protect`, `hp`, `mp`, `krit`, `ukrit`, `klas`,
`nsila`, `num`, `nlovk`, `nlvl`, `actime`) VALUES (13, 'lave', 'Дар
божий', 'dar_bozhiy', 1, 3, 5, 10, 10, 0, 3, 3, 'not', 0, 0, 0, 0,
3600); -- -------------------------------------------------------- -- --
Структура таблицы `shop_mag` -- CREATE TABLE IF NOT EXISTS
`shop_mag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30)
COLLATE utf8_unicode_ci NOT NULL, `klas` varchar(10) COLLATE
utf8_unicode_ci NOT NULL, `name` varchar(40) COLLATE utf8_unicode_ci NOT
NULL, `lat_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL, `tip`
varchar(10) COLLATE utf8_unicode_ci NOT NULL, `uron` varchar(100) COLLATE
utf8_unicode_ci NOT NULL, `mp` varchar(100) COLLATE utf8_unicode_ci NOT
NULL, `hp` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `plushp`
varchar(100) COLLATE utf8_unicode_ci NOT NULL, `cena` varchar(100)
COLLATE utf8_unicode_ci NOT NULL, `lvl` int(11) NOT NULL, `nead_res`
text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; --
-------------------------------------------------------- -- --
Структура таблицы `sklad` -- CREATE TABLE IF NOT EXISTS
`sklad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `tip` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `name` varchar(40)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lat_name`
varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `cena`
int(11) NOT NULL, `umin` int(11) NOT NULL, `umax` int(11) NOT NULL,
`pgolova` int(11) NOT NULL, `pbody` int(11) NOT NULL, `pnogi` int(11)
NOT NULL, `hp` int(11) NOT NULL, `mp` int(11) NOT NULL, `krit`
int(11) NOT NULL, `ukrit` int(11) NOT NULL, `antikrit` int(11) NOT
NULL, `sila` int(11) NOT NULL, `lovk` int(11) NOT NULL, `um` int(11)
NOT NULL, `prot` int(11) NOT NULL, `klas` varchar(10) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL, `nsila` int(11) NOT NULL,
`nlovk` int(11) NOT NULL, `num` int(11) NOT NULL, `nlvl` int(11) NOT
NULL, `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `give` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `kol` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `taverna` -- CREATE TABLE IF NOT EXISTS
`taverna` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `npc` varchar(100)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `tmp` -- CREATE TABLE IF NOT EXISTS
`tmp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `mob` int(11) NOT
NULL, `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL, `location` int(11) NOT NULL, `ltime` varchar(25) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; --
-------------------------------------------------------- -- --
Структура таблицы `tmp_zamok` -- CREATE TABLE IF NOT
EXISTS `tmp_zamok` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr`
varchar(10) COLLATE utf8_unicode_ci NOT NULL, `mob` int(11) NOT NULL,
`city` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `ltime` varchar(25)
COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ; --
-------------------------------------------------------- -- --
Структура таблицы `towers` -- CREATE TABLE IF NOT EXISTS
`towers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50)
COLLATE utf8_unicode_ci NOT NULL, `hp` int(11) NOT NULL, `hpall`
int(11) NOT NULL, `point` int(11) NOT NULL, `exp` int(11) NOT NULL,
`money` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `control`
varchar(10) COLLATE utf8_unicode_ci NOT NULL, `lvl` int(11) NOT NULL,
`mlvl` int(11) NOT NULL, `cena` int(11) NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=11 ; -- -- Дамп данных таблицы
`towers` -- INSERT INTO `towers` (`id`, `name`, `hp`, `hpall`, `point`,
`exp`, `money`, `control`, `lvl`, `mlvl`, `cena`) VALUES (1,
'Курган', 180, 180, 3, 3, '0,2', 'white', 0, 3, 0), (10, 'Mafiozi
Street', 250, 250, 5, 5, '0,2', 'white', 3, 5, 10); --
-------------------------------------------------------- -- --
Структура таблицы `users` -- CREATE TABLE IF NOT EXISTS
`users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pass` varchar(32)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `email` varchar(35)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `ip` varchar(25)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `pol` varchar(2)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `prava` int(1) NOT
NULL, `storona` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL, `lvl` int(11) NOT NULL, `money` int(11) NOT NULL, `skill`
int(11) NOT NULL, `hp` int(11) NOT NULL, `hpall` int(11) NOT NULL,
`mp` int(11) NOT NULL, `mpall` int(11) NOT NULL, `exp` int(11) NOT
NULL, `sila` int(11) NOT NULL, `um` int(11) NOT NULL, `lovk` int(11)
NOT NULL, `prot` int(11) NOT NULL, `pgolova` int(11) NOT NULL,
`pbody` int(11) NOT NULL, `pnogi` int(11) NOT NULL, `antikrit` int(11)
NOT NULL, `krit` int(11) NOT NULL, `ukrit` int(11) NOT NULL, `umin`
int(11) NOT NULL, `umax` int(11) NOT NULL, `city` varchar(25) CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, `klas` varchar(10) CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, `clan` varchar(10) CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, `lvisit` varchar(50) CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, `loses` int(11) NOT NULL,
`wins` int(11) NOT NULL, `arenaloses` int(11) NOT NULL, `arenawins`
int(11) NOT NULL, `slava` int(11) NOT NULL, `predatel` int(11) NOT
NULL, `ref` varchar(25) NOT NULL, `kel` varchar(10) NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- --
Дамп данных таблицы `users` -- INSERT INTO `users` (`id`,
`usr`, `pass`, `email`, `ip`, `pol`, `prava`, `storona`, `lvl`, `money`,
`skill`, `hp`, `hpall`, `mp`, `mpall`, `exp`, `sila`, `um`, `lovk`, `prot`,
`pgolova`, `pbody`, `pnogi`, `antikrit`, `krit`, `ukrit`, `umin`, `umax`,
`city`, `klas`, `clan`, `lvisit`, `loses`, `wins`, `arenaloses`,
`arenawins`, `slava`, `predatel`, `ref`, `kel`) VALUES (2, 'test',
'098f6bcd4621d373cade4e832627b4f6', 'testers@mas.ru', '85.26.183.62', 'm',
0, 'white', 0, 0, 0, 12, 12, 9, 9, 0, 1, 3, 3, 0, 2, 1, 2, 8, 5, 5, 3, 9,
'lave', 'wizard', '', '26 августа, 2012 20:10:55', 0, 0, 0, 0, 0, 0,
'', '0'); --
-------------------------------------------------------- -- --
Структура таблицы `user_assasin` -- CREATE TABLE IF NOT
EXISTS `user_assasin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `quest`
int(11) NOT NULL, `mob` int(11) NOT NULL, `city` varchar(30) CHARACTER
SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `user_kill` -- CREATE TABLE IF NOT
EXISTS `user_kill` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr`
varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `quest`
int(11) NOT NULL, `killing` int(11) NOT NULL, `city` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) )
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ; --
-------------------------------------------------------- -- --
Структура таблицы `world` -- CREATE TABLE IF NOT EXISTS
`world` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, `x` int(11) NOT
NULL, `y` int(11) NOT NULL, `bu` int(11) NOT NULL, `bd` int(11) NOT
NULL, `bl` int(11) NOT NULL, `br` int(11) NOT NULL, `incity` int(11)
NOT NULL, `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL, `portal` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=270 ; -- -- Дамп данных
таблицы `world` -- INSERT INTO `world` (`id`, `name`, `x`, `y`,
`bu`, `bd`, `bl`, `br`, `incity`, `city`, `portal`) VALUES (1, 'Выезд
из Las Vegas', 0, 0, 0, 0, 0, 0, 1, 'lave', 0), (2, 'Тропа на
север', 0, 1, 0, 0, 0, 0, 0, 'lave', 0), (3, 'Тропа на
восток', 1, 0, 0, 0, 0, 0, 0, 'lave', 0), (4, 'Тропа на
север', 0, 2, 0, 0, 0, 0, 0, 'lave', 0), (5, 'Квартал
мафии - запад', 0, 3, 0, 0, 0, 0, 0, 'lave', 0), (6,
'Квартал мафии', 1, 3, 0, 0, 0, 0, 0, 'lave', 0), (7,
'Квартал мафии - восток', 2, 3, 0, 0, 0, 0, 0, 'lave',
0), (8, 'Дорога на север', 1, 1, 0, 0, 0, 0, 0, 'lave',
0), (9, 'Холодная равнина - юг', 1, 2, 0, 0, 0, 0, 0,
'lave', 0), (10, 'Тропа на восток', 2, 0, 0, 0, 0, 0, 0,
'lave', 0), (11, 'Волчий лес - юг', 3, 0, 0, 0, 0, 0, 0, 'lave',
0), (12, 'Волчий лес', 3, 1, 0, 0, 0, 0, 0, 'lave', 1), (13,
'Волчий лес - запад', 2, 1, 0, 0, 0, 0, 0, 'lave', 0), (14,
'Волчий лес - восток', 4, 1, 0, 0, 0, 0, 0, 'lave', 0), (15,
'Волчий лес - север', 4, 2, 0, 0, 0, 0, 0, 'lave', 0), (16,
'Мрачное ущелье', 1, 4, 0, 0, 0, 0, 0, 'lave', 1), (17,
'Мрачное ущелье - север', 1, 5, 0, 0, 0, 0, 0, 'lave',
0), (18, 'Мрачное ущелье - север', 1, 6, 0, 0, 0, 0, 0,
'lave', 0), (19, 'Каменное поле', 1, 7, 0, 0, 0, 0, 0, 'lave',
1), (20, 'Пригород - запад', 2, 7, 0, 0, 0, 0, 0, 'lave',
0), (21, 'Пригород - Старый квартал', 3, 6, 0, 0, 0,
0, 0, 'lave', 0), (22, 'Каменное поле - север', 1, 8, 0,
0, 0, 0, 0, 'lave', 0), (23, 'Каменное поле - запад', 0,
7, 0, 0, 0, 0, 0, 'lave', 0), (24, 'Пещера гоблинов -
проход', 3, 7, 0, 0, 0, 0, 0, 'lave', 0), (25, 'Опушка
Лысого леса', 3, 3, 0, 0, 0, 0, 0, 'lave', 1), (26, 'Лысый
лес - тропа на север', 3, 4, 0, 0, 0, 0, 0, 'lave', 0), (27,
'Лысый лес - тропа на восток', 4, 4, 0, 0, 0, 0, 0,
'lave', 0), (28, 'Лысый лес - мостик-запад', 5, 4, 0, 0,
0, 0, 0, 'lave', 0), (29, 'Лысый лес - мостик-восток',
6, 4, 0, 0, 0, 0, 0, 'lave', 0), (30, 'Опушка Лысого леса',
7, 4, 0, 0, 0, 0, 0, 'lave', 0), (31, 'Кладбище -
юго-восток', 8, 4, 0, 0, 0, 0, 0, 'lave', 0), (32,
'Кладбище - восток', 8, 5, 0, 0, 0, 0, 0, 'lave', 0), (33,
'Кладбище - северо-восток', 8, 6, 0, 0, 0, 0, 0,
'lave', 0), (34, 'Кладбище - север', 9, 6, 0, 0, 0, 0, 0,
'lave', 0), (35, 'Кладбище - юг', 9, 4, 0, 0, 0, 0, 0, 'lave',
0), (36, 'Кладбище - юго-запад', 10, 4, 0, 1, 0, 0, 0,
'lave', 0), (37, 'Кладбище - запад', 10, 5, 0, 0, 0, 0, 0,
'lave', 0), (38, 'Кладбище - северо-запад', 10, 6, 0, 0,
0, 0, 0, 'lave', 0), (39, 'Кладбище', 9, 5, 0, 0, 0, 0, 0, 'lave',
0), (75, 'Вход в Болото', 5, 1, 0, 0, 0, 0, 0, 'lave', 1), (71,
'Болото', 6, 1, 0, 0, 0, 0, 0, 'lave', 0), (73, 'Болото-юг',
6, 2, 0, 0, 0, 0, 0, 'lave', 0), (74, 'Болото-запад', 7, 1, 0,
0, 0, 0, 0, 'lave', 0), (76, 'Ущелье духов', 1, 9, 0, 0, 0, 0,
0, 'lave', 1), (77, 'Ущелье духов - север', 1, 10, 0, 0, 0,
0, 0, 'lave', 0), (78, 'Храм Луны - вход', 2, 10, 0, 0, 0, 0,
0, 'lave', 0), (79, 'Храм Луны - нижнее крыло', 2, 9, 0,
0, 0, 0, 0, 'lave', 0), (80, 'Храм Луны - коридор', 3, 10,
0, 0, 0, 0, 0, 'lave', 0), (81, 'Храм Луны - вход в
большой зал', 3, 9, 0, 0, 0, 0, 0, 'lave', 0), (82, 'Храм
Луны - алтарь Луны', 4, 10, 0, 0, 0, 0, 0, 'lave', 0), (84,
'Храм Луны - большой зал', 4, 9, 0, 0, 0, 0, 0, 'lave',
0), (85, 'Храм Луны - большой зал', 5, 9, 0, 0, 0, 0, 0,
'lave', 0), (86, 'Храм Луны - востоное крыло', 5, 10,
0, 0, 0, 0, 0, 'lave', 0), (87, 'Храм Луны - северное
крыло', 4, 11, 0, 0, 0, 0, 0, 'lave', 0), (88, 'Храм Луны -
северное крыло', 5, 11, 0, 0, 0, 0, 0, 'lave', 0), (89,
'Окраина Болота', 8, 1, 0, 0, 0, 0, 0, 'lave', 0), (108,
'Вход на Озеро', 9, 1, 0, 0, 0, 0, 0, 'lave', 1), (93,
'Озеро', 10, 1, 0, 0, 0, 0, 0, 'lave', 0), (98, 'Заброшеный
причал', 11, 1, 0, 0, 0, 0, 0, 'lave', 0), (99,
'Озеро-Север', 10, 2, 0, 0, 0, 0, 0, 'lave', 0), (101,
'Лагуна', 9, 2, 0, 0, 0, 0, 0, 'lave', 0), (102, 'Чистый
Рудник', 10, 3, 1, 0, 0, 0, 0, 'lave', 0), (103, 'Берег
Озера', 11, 3, 0, 0, 0, 0, 0, 'lave', 0), (104, 'Озеро-Юг', 10,
0, 0, 0, 0, 0, 0, 'lave', 0), (106, 'Озеро-Юго-восток', 11,
0, 0, 0, 0, 0, 0, 'lave', 0); --
-------------------------------------------------------- -- --
Структура таблицы `zamok` -- CREATE TABLE IF NOT EXISTS
`zamok` ( `id` int(11) NOT NULL AUTO_INCREMENT, `city` varchar(30)
COLLATE utf8_unicode_ci NOT NULL, `name` varchar(30) COLLATE
utf8_unicode_ci NOT NULL, `clan` varchar(10) COLLATE utf8_unicode_ci NOT
NULL, `vorota` int(11) NOT NULL, `kristals` int(11) NOT NULL, PRIMARY
KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=2 ; -- -- Дамп данных таблицы
`zamok` -- INSERT INTO `zamok` (`id`, `city`, `name`, `clan`, `vorota`,
`kristals`) VALUES (1, 'fornost', 'Форност', 'bymer', 1099486,
5); -- -------------------------------------------------------- -- --
Структура таблицы `zasada` -- CREATE TABLE IF NOT EXISTS
`zasada` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usr` varchar(10)
COLLATE utf8_unicode_ci NOT NULL, `city` varchar(30) COLLATE
utf8_unicode_ci NOT NULL, `location` int(11) NOT NULL, `x` int(11) NOT
NULL, `y` int(11) NOT NULL, `tip` int(11) NOT NULL, PRIMARY KEY
(`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=26 ; /*!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 */;
К файлу
К просмотру архива
Онлайн: 2
Реклама
Наш надёжный хостинг партнёр
Купить рекламу