Файл: baza.sql
Строк: 568
DROP TABLE IF EXISTS `arena`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `ban`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `bashni`;
CREATE TABLE `bashni` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL,
`str` int(11) NOT NULL,
`vit` int(11) NOT
NULL,
`agi` int(11) NOT NULL,
`def` int(11) NOT NULL,
`id_user`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1
DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `bazaar`;
CREATE TABLE
`bazaar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`1` int(11) NOT NULL,
`2` int(11) NOT NULL,
`3` int(11) NOT NULL,
`4` int(11) NOT NULL,
`5` int(11) NOT NULL,
`6` int(11) NOT NULL,
`7` int(11) NOT NULL,
`8`
int(11) NOT NULL,
`9` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO bazaar
VALUES("1","1881069371","2108858238","1895473173","2085900979","2052031923","2114927629","2109073925","2136577001","2134054177");
DROP
TABLE IF EXISTS `block`;
CREATE TABLE `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;
DROP TABLE IF EXISTS `boss`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=latin1;
INSERT INTO boss
VALUES("1","Огненный
пес","1","500","1000","300","450","35","50","1.png");
INSERT
INTO boss VALUES("8","
Горлум","35","5357","7000","4800","5297","210","310","9");
INSERT
INTO boss VALUES("2","Рыцырь
смерти","5","1000","1500","500","600","45","75","2");
INSERT
INTO boss
VALUES("3","Палач","10","1300","1050","960","950","60","100","3");
INSERT
INTO boss
VALUES("4","Горгулья","15","1650","2000","1200","1700","80","150","4");
INSERT
INTO boss
VALUES("5","Змей","20","3050","3500","2520","2510","120","200","5");
INSERT
INTO boss
VALUES("6","Минотавр","25","3500","3850","3550","3600","150","210","6");
INSERT
INTO boss VALUES("7","Повелитель
огня","30","4520","4071","4347","4254","180","250","7");
INSERT
INTO boss
VALUES("9","Варлорд","40","7000","8000","5000","8000","300","350","10");
DROP
TABLE IF EXISTS `cave`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `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
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS
`clan_invite`;
CREATE TABLE `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 AUTO_INCREMENT=1
DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS `clan_memb`;
CREATE TABLE
`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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `clan_msg`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `clan_msg_read`;
CREATE TABLE
`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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `clans`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `coliseum`;
CREATE TABLE
`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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP TABLE IF
EXISTS `coliseum_log`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `coliseum_member`;
CREATE TABLE `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
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS
`complects`;
CREATE TABLE `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 AUTO_INCREMENT=56 DEFAULT CHARSET=cp1251;
INSERT INTO
complects VALUES("1","1","Комплект
воина","9","10","11","12","13","14","15","16");
INSERT
INTO complects
VALUES("36","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("37","3","Комплект
стервятника","105","106","107","108","109","110","111","112");
INSERT
INTO complects
VALUES("34","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("35","3","Комплект
паладина","81","82","83","84","85","86","87","88");
INSERT
INTO complects
VALUES("32","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("33","3","Комплект
зверобоя","57","58","59","60","61","62","63","64");
INSERT
INTO complects
VALUES("30","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("31","3","Комплект
возмездия","49","50","51","52","53","54","55","56");
INSERT
INTO complects
VALUES("28","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("29","3","Комплект
ветерана","41","42","43","44","45","46","47","48");
INSERT
INTO complects
VALUES("26","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("27","2","Комплект
рыцаря","73","74","75","76","77","78","79","80");
INSERT
INTO complects
VALUES("24","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("25","2","Комплект
искателя","65","66","67","68","69","70","71","72");
INSERT
INTO complects
VALUES("22","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("23","2","Комплект
ассасина","33","34","35","36","37","38","39","40");
INSERT
INTO complects VALUES("21","1","Комплект
охотника","25","26","27","28","29","30","31","32");
INSERT
INTO complects VALUES("20","1","Комплект
ополченца","17","18","19","20","21","22","23","24");
INSERT
INTO complects
VALUES("38","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("39","3","Комплект
стойкости","113","114","115","116","117","118","119","120");
INSERT
INTO complects
VALUES("40","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("41","4","Комплект
призрака","89","90","91","92","93","94","95","96");
INSERT
INTO complects VALUES("42","4","Комплект
скалы","97","98","99","100","101","102","103","104");
INSERT
INTO complects VALUES("43","4","Комплект
страха","121","122","123","124","125","126","127","128");
INSERT
INTO complects VALUES("44","4","Комплект
атакера","129","130","131","132","133","134","135","136");
INSERT
INTO complects VALUES("45","5","Комплект
мстителя","202","203","204","205","206","207","208","209");
INSERT
INTO complects VALUES("46","5","Комплект
инквизитора","186","187","188","189","190","191","192","193");
INSERT
INTO complects VALUES("47","5","Комплект
хранителя","194","195","196","197","198","199","200","201");
INSERT
INTO complects VALUES("48","5","Комплект
избранного","178","179","180","181","182","183","184","185");
INSERT
INTO complects VALUES("49","4","Комплект
гладиатора","137","138","139","140","141","142","143","144");
INSERT
INTO complects VALUES("50","4","Комплект
элиты","145","146","147","148","149","150","151","152");
INSERT
INTO complects VALUES("51","4","Комплект
молотобоя","161","162","163","164","165","166","167","168");
INSERT
INTO complects
VALUES("52","0","","0","0","0","0","0","0","0","0");
INSERT
INTO complects VALUES("53","5","Комплект
палача","210","211","212","213","214","215","216","217");
INSERT
INTO complects VALUES("54","6","Набор
Анархии","218","219","220","221","222","223","224","225");
INSERT
INTO complects VALUES("55","6","Комплект
Дракона","226","227","228","229","230","231","232","233");
DROP
TABLE IF EXISTS `contacts`;
CREATE TABLE `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;
DROP TABLE IF
EXISTS `dragons`;
CREATE TABLE `dragons` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 NOT NULL,
`user`
int(11) NOT NULL,
`str` int(11) NOT NULL,
`agi` int(11) NOT NULL,
`def` int(11) NOT NULL,
`in` int(11) NOT NULL,
`lvl` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`time` int(11) NOT NULL,
`type` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `drova`;
CREATE TABLE `drova` (
`id` int(11) NOT NULL,
`user` int(11) NOT NULL,
`h` int(11) NOT NULL,
`time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO
drova
VALUES("0","1","5","1423220182");
INSERT
INTO drova
VALUES("0","1","5","1423220182");
INSERT
INTO drova
VALUES("0","1","0","0");
DROP
TABLE IF EXISTS `duel`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `exchange`;
CREATE TABLE `exchange` (
`user_id` int(11)
NOT NULL AUTO_INCREMENT,
`time` int(11) DEFAULT NULL,
`count` int(11)
DEFAULT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `nick` (`time`)
)
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `farm`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `forum_comments`;
CREATE TABLE
`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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `forum_sub`;
CREATE TABLE
`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 AUTO_INCREMENT=20 DEFAULT
CHARSET=cp1251;
INSERT INTO forum_sub
VALUES("14","Предложения","0");
INSERT
INTO forum_sub VALUES("13","Вопросы по
игре","0");
INSERT INTO forum_sub
VALUES("1","Новости","2");
INSERT INTO
forum_sub VALUES("16","Кланы (Поиск,
Прием)","0");
INSERT INTO forum_sub
VALUES("17","Разговоры тут
(Общение)","0");
INSERT INTO forum_sub
VALUES("18","Ошибки,
Баги","0");
INSERT INTO forum_sub
VALUES("19","Подарки","2");
DROP
TABLE IF EXISTS `forum_topic`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `gemts`;
CREATE TABLE `gemts` (
`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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `inv`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `items`;
CREATE TABLE `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 AUTO_INCREMENT=314 DEFAULT CHARSET=cp1251;
INSERT
INTO items VALUES("1","1","Шлем
бродяги","0","0");
INSERT INTO items
VALUES("2","2","Наплечник
бродяги","0","0");
INSERT INTO items
VALUES("3","3","Рубашка
бродяги","0","0");
INSERT INTO items
VALUES("4","4","Перчатки
бродяги","0","0");
INSERT INTO items
VALUES("5","5","Щит
бродяги","0","0");
INSERT INTO items
VALUES("6","6","Нож
бродяги","0","0");
INSERT INTO items
VALUES("7","7","Штаны
бродяги","0","0");
INSERT INTO items
VALUES("8","8","Ботинки
бродяги","0","0");
INSERT INTO items
VALUES("9","1","Шлем
воина","1","1");
INSERT INTO items
VALUES("10","2","Наплечник
воина","1","1");
INSERT INTO items
VALUES("11","3","Броня
воина","1","1");
INSERT INTO items
VALUES("12","4","Перчатки
воина","1","1");
INSERT INTO items
VALUES("13","5","Щит
воина","1","1");
INSERT INTO items
VALUES("14","6","Меч
воина","1","1");
INSERT INTO items
VALUES("15","7","Штаны
воина","1","1");
INSERT INTO items
VALUES("16","8","Сапоги
воина","1","1");
INSERT INTO items
VALUES("17","1","Шлем
ополченца","1","1");
INSERT INTO items
VALUES("18","2","Наплечник
ополченца","1","1");
INSERT INTO items
VALUES("19","3","Броня
ополченца","1","1");
INSERT INTO items
VALUES("20","4","Перчатки
ополченца","1","1");
INSERT INTO items
VALUES("21","5","Щит
ополченца","1","1");
INSERT INTO items
VALUES("22","6","Топор
ополченца","1","1");
INSERT INTO items
VALUES("23","7","Штаны
ополченца","1","1");
INSERT INTO items
VALUES("24","8","Сапоги
ополченца","1","1");
INSERT INTO items
VALUES("25","1","Маска
охотника","1","1");
INSERT INTO items
VALUES("26","2","Наплечник
охотника","1","1");
INSERT INTO items
VALUES("27","3","Броня
охотника","1","1");
INSERT INTO items
VALUES("28","4","Перчатки
охотника","1","1");
INSERT INTO items
VALUES("29","5","Катар охотника
инь","1","1");
INSERT INTO items
VALUES("30","6","Катар охотника
янь","1","1");
INSERT INTO items
VALUES("31","7","Штаны
охотника","1","1");
INSERT INTO items
VALUES("32","8","Сапоги
охотника","1","1");
INSERT INTO items
VALUES("33","1","Шлем
ассасина","2","10");
INSERT INTO items
VALUES("34","2","Наплечник
ассасина","2","10");
INSERT INTO items
VALUES("35","3","Броня
ассасина","2","10");
INSERT INTO items
VALUES("36","4","Перчатки
ассасина","2","10");
INSERT INTO items
VALUES("37","5","Веер ассасина
инь","2","10");
INSERT INTO items
VALUES("38","6","Веер ассасина
инь","2","10");
INSERT INTO items
VALUES("39","7","Штаны
ассасина","2","10");
INSERT INTO items
VALUES("40","8","Сапоги
ассасина","2","10");
INSERT INTO items
VALUES("41","1","Шлем
ветерана","3","24");
INSERT INTO items
VALUES("42","2","Наплечник
ветерана","3","24");
INSERT INTO items
VALUES("43","3","Броня
ветерана","3","24");
INSERT INTO items
VALUES("44","4","Перчатки
ветерана","3","24");
INSERT INTO items
VALUES("45","5","Щит
ветерана","3","24");
INSERT INTO items
VALUES("46","6","Топор
ветерана","3","24");
INSERT INTO items
VALUES("47","7","Штаны
ветерана","3","24");
INSERT INTO items
VALUES("48","8","Сапоги
ветерана","3","24");
INSERT INTO items
VALUES("49","1","Шлем
возмездия","3","24");
INSERT INTO items
VALUES("50","2","Наплечник
возмездия","3","24");
INSERT INTO items
VALUES("51","3","Броня
возмездия","3","24");
INSERT INTO items
VALUES("52","4","Перчатки
возмездия","3","24");
INSERT INTO items
VALUES("53","5","Меч возмездия
инь","3","24");
INSERT INTO items
VALUES("54","6","Меч возмездия
янь","3","24");
INSERT INTO items
VALUES("55","7","Штаны
возмездия","3","24");
INSERT INTO items
VALUES("56","8","Сапоги
возмездия","3","24");
INSERT INTO items
VALUES("57","1","Шлем
зверобоя","3","24");
INSERT INTO items
VALUES("58","2","Наплечник
зверобоя","3","24");
INSERT INTO items
VALUES("59","3","Броня
зверобоя","3","24");
INSERT INTO items
VALUES("60","4","Перчатки
зверобоя","3","24");
INSERT INTO items
VALUES("61","5","Щит
зверобоя","3","24");
INSERT INTO items
VALUES("62","6","Меч
зверобоя","3","24");
INSERT INTO items
VALUES("63","7","Штаны
зверобоя","3","24");
INSERT INTO items
VALUES("64","8","Сапоги
зверобоя","3","24");
INSERT INTO items
VALUES("65","1","Шлем
искателя","2","10");
INSERT INTO items
VALUES("66","2","Наплечник
искателя","2","10");
INSERT INTO items
VALUES("67","3","Броня
искателя","2","10");
INSERT INTO items
VALUES("68","4","Перчатки
искателя","2","10");
INSERT INTO items
VALUES("69","5","Коготь искателя
инь","2","10");
INSERT INTO items
VALUES("70","6","Коготь искателя
янь","2","10");
INSERT INTO items
VALUES("71","7","Штаны
искател","2","10");
INSERT INTO items
VALUES("72","8","Сапоги
искателя","2","10");
INSERT INTO items
VALUES("73","1","Шлем
рыцаря","2","10");
INSERT INTO items
VALUES("74","2","Наплечник
рыцаря","2","10");
INSERT INTO items
VALUES("75","3","Броня
рыцаря","2","10");
INSERT INTO items
VALUES("76","4","Перчатки
рыцаря","2","10");
INSERT INTO items
VALUES("77","5","Щит
рыцаря","2","10");
INSERT INTO items
VALUES("78","6","Топор
рыцаря","2","10");
INSERT INTO items
VALUES("79","7","Штаны
рыцаря","2","10");
INSERT INTO items
VALUES("80","8","Сапоги
рыцаря","2","10");
INSERT INTO items
VALUES("81","1","Шлем
паладина","3","24");
INSERT INTO items
VALUES("82","2","Наплечник
паладина","3","24");
INSERT INTO items
VALUES("83","3","Броня
паладина","3","24");
INSERT INTO items
VALUES("84","4","Перчатки
паладина","3","24");
INSERT INTO items
VALUES("85","5","Меч паладина
инь","3","24");
INSERT INTO items
VALUES("86","6","Меч паладина
янь","3","24");
INSERT INTO items
VALUES("87","7","Штаны
паладина","3","24");
INSERT INTO items
VALUES("88","8","Сапоги
паладина","3","24");
INSERT INTO items
VALUES("89","1","Шлем
призрака","4","48");
INSERT INTO items
VALUES("90","2","Наплечник
призрака","4","48");
INSERT INTO items
VALUES("91","3","Броня
призрака","4","48");
INSERT INTO items
VALUES("92","4","Перчатки
призрака","4","48");
INSERT INTO items
VALUES("93","5","Когти призрака
инь","4","48");
INSERT INTO items
VALUES("94","6","Когти призрака
янь","4","48");
INSERT INTO items
VALUES("95","7","Штаны
призрака","4","48");
INSERT INTO items
VALUES("96","8","Сапоги
призрака","4","48");
INSERT INTO items
VALUES("97","1","Шлем
скалы","4","48");
INSERT INTO items
VALUES("98","2","Наплечник
скалы","4","48");
INSERT INTO items
VALUES("99","3","Броня
скалы","4","48");
INSERT INTO items
VALUES("100","4","Перчатки
скалы","4","48");
INSERT INTO items
VALUES("101","5","Щит
скалы","4","48");
INSERT INTO items
VALUES("102","6","Тесак
скалы","4","48");
INSERT INTO items
VALUES("103","7","Штаны
скалы","4","48");
INSERT INTO items
VALUES("104","8","Сапоги
скалы","4","48");
INSERT INTO items
VALUES("105","1","Шлем
стервятника","3","24");
INSERT INTO
items VALUES("106","2","Наплечники
стервятника","3","24");
INSERT INTO
items VALUES("107","3","Броня
стервятника","3","24");
INSERT INTO
items VALUES("108","4","Перчатки
стервятника","3","24");
INSERT INTO
items VALUES("109","5","Клинок
стервятника инь","3","24");
INSERT
INTO items VALUES("110","6","Клинок
стервятника янь","3","24");
INSERT
INTO items VALUES("111","7","Штаны
стервятника","3","24");
INSERT INTO
items VALUES("112","8","Сапоги
стервятника","3","24");
INSERT INTO
items VALUES("113","1","Шлем
стойкости","3","24");
INSERT INTO items
VALUES("114","2","Наплечник
стойкости","3","24");
INSERT INTO items
VALUES("115","3","Броня
стойкости","3","24");
INSERT INTO items
VALUES("116","4","Перчатки
стойкости","3","24");
INSERT INTO items
VALUES("117","5","Щит
стойкости","3","24");
INSERT INTO items
VALUES("118","6","Топор
стойкости","3","24");
INSERT INTO items
VALUES("120","8","Сапоги
стойкости","3","24");
INSERT INTO items
VALUES("119","7","Штаны
стойкости","3","24");
INSERT INTO items
VALUES("121","1","Шлем
страха","4","48");
INSERT INTO items
VALUES("122","2","Наплечник
страха","4","48");
INSERT INTO items
VALUES("123","3","Броня
страха","4","48");
INSERT INTO items
VALUES("124","4","Перчатки
страха","4","48");
INSERT INTO items
VALUES("125","5","Меч страха
инь","4","48");
INSERT INTO items
VALUES("126","6","Меч страха
янь","4","48");
INSERT INTO items
VALUES("127","7","Штаны
страха","4","48");
INSERT INTO items
VALUES("128","8","Сапоги
страха","4","48");
INSERT INTO items
VALUES("129","1","Шлем
атакера","4","48");
INSERT INTO items
VALUES("130","2","Наплечник
атакера","4","48");
INSERT INTO items
VALUES("131","3","Броня
атакера","4","48");
INSERT INTO items
VALUES("132","4","Перчатки
атакера","4","48");
INSERT INTO items
VALUES("133","5","Щит
атакера","4","48");
INSERT INTO items
VALUES("134","6","Меч
атакера","4","48");
INSERT INTO items
VALUES("135","7","Штаны
атакера","4","48");
INSERT INTO items
VALUES("136","8","Сапоги
атакера","4","48");
INSERT INTO items
VALUES("137","1","Шлем
гладиатора","4","48");
INSERT INTO items
VALUES("138","2","Наплечник
гладиатора","4","48");
INSERT INTO items
VALUES("139","3","Броня
гладиатора","4","48");
INSERT INTO items
VALUES("140","4","Перчатки
гладиатора","4","48");
INSERT INTO items
VALUES("141","5","Меч гладиатора
инь","4","48");
INSERT INTO items
VALUES("142","6","Меч гладиатора
янь","4","48");
INSERT INTO items
VALUES("143","7","Штаны
гладиатора","4","48");
INSERT INTO items
VALUES("144","8","Сапоги
гладиатора","4","48");
INSERT INTO items
VALUES("145","1","Шлем
элиты","4","48");
INSERT INTO items
VALUES("146","2","Наплечник
элиты","4","48");
INSERT INTO items
VALUES("147","3","Броня
элиты","4","48");
INSERT INTO items
VALUES("148","4","Перчатки
элиты","4","48");
INSERT INTO items
VALUES("149","5","Щит
элиты","4","48");
INSERT INTO items
VALUES("150","6","Меч
элиты","4","48");
INSERT INTO items
VALUES("151","7","Штаны
элиты","4","48");
INSERT INTO items
VALUES("152","8","Сапоги
элиты","4","48");
INSERT INTO items
VALUES("161","1","Шлем
молотобоя","4","48");
INSERT INTO items
VALUES("162","2","Наплечник
молотобоя","4","48");
INSERT INTO items
VALUES("163","3","Броня
молотобоя","4","48");
INSERT INTO items
VALUES("164","4","Перчатки
молотобоя","4","48");
INSERT INTO items
VALUES("165","5","Молот молотобоя
инь","4","48");
INSERT INTO items
VALUES("166","6","Молот молотобоя
янь","4","48");
INSERT INTO items
VALUES("167","7","Штаны
молотобоя","4","48");
INSERT INTO items
VALUES("168","8","Сапоги
молотобоя","4","48");
INSERT INTO items
VALUES("169","1","Маска
тени","4","48");
INSERT INTO items
VALUES("170","2","Наплечник
тени","4","48");
INSERT INTO items
VALUES("171","3","Броня
тени","4","48");
INSERT INTO items
VALUES("172","4","Перчатки
тени","4","48");
INSERT INTO items
VALUES("173","5","Зубья тени
инь","4","48");
INSERT INTO items
VALUES("174","6","Зубья тени
янь","4","48");
INSERT INTO items
VALUES("175","7","Штаны
тени","4","48");
INSERT INTO items
VALUES("176","8","Сапоги
тени","4","48");
INSERT INTO items
VALUES("178","1","Шлем
избранного","5","200");
INSERT INTO
items VALUES("179","2","Наплечник
избранного","5","200");
INSERT INTO
items VALUES("180","3","Броня
избранного","5","200");
INSERT INTO
items VALUES("181","4","Перчатки
избранного","5","200");
INSERT INTO
items VALUES("182","5","Меч
избранного инь","5","200");
INSERT
INTO items VALUES("183","6","Меч
избранного янь","5","200");
INSERT
INTO items VALUES("184","7","Штаны
избранного","5","200");
INSERT INTO
items VALUES("185","8","Сапоги
избранного","5","200");
INSERT INTO
items VALUES("186","1","Шлем
инквизитора","5","200");
INSERT INTO
items VALUES("187","2","Наплечник
инквизитора","5","200");
INSERT INTO
items VALUES("188","3","Кираса
инквизитора","5","200");
INSERT INTO
items VALUES("189","4","Перчатки
инквизитора","5","200");
INSERT INTO
items VALUES("190","5","Щит
инквизитора","5","200");
INSERT INTO
items VALUES("191","6","Меч
инквизитора","5","200");
INSERT INTO
items VALUES("192","7","Штаны
инквизитора","5","200");
INSERT INTO
items VALUES("193","8","Сапоги
инквизитора","5","200");
INSERT INTO
items VALUES("194","1","Шлем
хранителя","5","200");
INSERT INTO items
VALUES("195","2","Наплечник
хранителя","5","200");
INSERT INTO items
VALUES("196","3","Броня
хранителя","5","200");
INSERT INTO items
VALUES("197","4","Перчатки
хранителя","5","200");
INSERT INTO items
VALUES("198","5","Щит
хранителя","5","200");
INSERT INTO items
VALUES("199","6","Меч
хранителя","5","200");
INSERT INTO items
VALUES("200","7","Штаны
хранителя","5","200");
INSERT INTO items
VALUES("201","8","Сапоги
хранителя","5","200");
INSERT INTO items
VALUES("202","1","Шлем
мстителя","5","200");
INSERT INTO items
VALUES("203","2","Наплечник
мстителя","5","200");
INSERT INTO items
VALUES("204","3","Броня
мстителя","5","200");
INSERT INTO items
VALUES("205","4","Перчатки
мстителя","5","200");
INSERT INTO items
VALUES("206","5","Меч мстителя
инь","5","200");
INSERT INTO items
VALUES("207","6","Меч мстителя
янь","5","200");
INSERT INTO items
VALUES("208","7","Штаны
мстителя","5","200");
INSERT INTO items
VALUES("209","8","Сапоги
мстителя","5","200");
INSERT INTO items
VALUES("210","1","Шлем
палача","5","200");
INSERT INTO items
VALUES("211","2","Наплечник
палача","5","200");
INSERT INTO items
VALUES("212","3","Кираса
палача","5","200");
INSERT INTO items
VALUES("213","4","Перчатки
палача","5","200");
INSERT INTO items
VALUES("214","5","Шипастый круг
палача","5","200");
INSERT INTO items
VALUES("215","6","Топор
палача","5","200");
INSERT INTO items
VALUES("216","7","Штаны
палача","5","200");
INSERT INTO items
VALUES("217","8","Сапоги
палача","5","200");
INSERT INTO items
VALUES("218","1","Шлем
анархии","6","200");
INSERT INTO items
VALUES("219","2","Наплечник
анархии","6","200");
INSERT INTO items
VALUES("220","3","Броня
анархии","6","200");
INSERT INTO items
VALUES("221","4","Перчатки
анархии","6","200");
INSERT INTO items
VALUES("222","5","Щит
анархии","6","200");
INSERT INTO items
VALUES("223","6","Посох
анархии","6","200");
INSERT INTO items
VALUES("224","7","Штаны
анархии","6","200");
INSERT INTO items
VALUES("225","8","Сапоги
анархии","6","200");
INSERT INTO items
VALUES("226","1","Шлем
дракона","6","200");
INSERT INTO items
VALUES("227","2","Наплечник
дракона","6","200");
INSERT INTO items
VALUES("228","3","Броня
дракона","6","200");
INSERT INTO items
VALUES("229","4","Перчатки
дракона","6","200");
INSERT INTO items
VALUES("230","5","Коса дракона
инь","6","200");
INSERT INTO items
VALUES("231","6","Коса дракона
янь","6","200");
INSERT INTO items
VALUES("232","7","Штаны
дракона","6","200");
INSERT INTO items
VALUES("233","8","Сапоги
дракона","6","200");
INSERT INTO items
VALUES("234","1","Шлем
молнии","6","200");
INSERT INTO items
VALUES("235","2","Наплечник
молнии","6","200");
INSERT INTO items
VALUES("236","3","Броня
молнии","6","200");
INSERT INTO items
VALUES("237","4","Перчатки
молнии","6","200");
INSERT INTO items
VALUES("238","5","Меч молнии
инь","6","200");
INSERT INTO items
VALUES("239","6","Меч молнии
янь","6","200");
INSERT INTO items
VALUES("240","7","Штаны
молнии","6","200");
INSERT INTO items
VALUES("241","8","Сапоги
молнии","6","200");
INSERT INTO items
VALUES("242","1","Шлем
осквернителя","6","200");
INSERT INTO
items VALUES("243","2","Наплечник
осквернителя","6","200");
INSERT INTO
items VALUES("244","3","Броня
осквернителя","6","200");
INSERT INTO
items VALUES("245","4","Перчатки
осквернителя","6","200");
INSERT INTO
items VALUES("246","5","Щит
осквернителя","6","200");
INSERT INTO
items VALUES("247","6","Меч
осквернителя","6","200");
INSERT INTO
items VALUES("248","7","Штаны
осквернителя","6","200");
INSERT INTO
items VALUES("249","8","Сапоги
осквернителя","6","200");
INSERT INTO
items VALUES("250","1","Шлем
ястреба","6","200");
INSERT INTO items
VALUES("251","2","Наплечник
ястреба","6","200");
INSERT INTO items
VALUES("252","3","Броня
ястреба","6","200");
INSERT INTO items
VALUES("253","4","Перчатки
ястреба","6","200");
INSERT INTO items
VALUES("254","5","Арбалет ястреба
инь","6","200");
INSERT INTO items
VALUES("255","6","Арбалет ястреба
янь","6","200");
INSERT INTO items
VALUES("256","7","Штаны
ястреба","6","200");
INSERT INTO items
VALUES("257","8","Сапоги
ястреба","6","200");
INSERT INTO items
VALUES("258","1","Шлем
атланта","6","200");
INSERT INTO items
VALUES("259","2","Наплечник
атланта","6","200");
INSERT INTO items
VALUES("260","3","Броня
атланта","6","200");
INSERT INTO items
VALUES("261","4","Перчатки
атланта","6","200");
INSERT INTO items
VALUES("262","5","Щит
атланта","6","200");
INSERT INTO items
VALUES("263","6","Молот
атланта","6","200");
INSERT INTO items
VALUES("264","7","Штаны
атланта","6","200");
INSERT INTO items
VALUES("265","8","Сапоги
атланта","6","200");
INSERT INTO items
VALUES("266","1","Шлем
эльфийца","6","200");
INSERT INTO items
VALUES("267","2","Наплечник
эльфийца","6","200");
INSERT INTO items
VALUES("268","3","Броня
эльфийца","6","200");
INSERT INTO items
VALUES("269","4","Перчатки
эльфийца","6","200");
INSERT INTO items
VALUES("270","5","Клинок эльфийца
инь","6","200");
INSERT INTO items
VALUES("271","6","Клинок эльфийца
янь","6","200");
INSERT INTO items
VALUES("272","7","Штаны
эльфийца","6","200");
INSERT INTO items
VALUES("273","8","Сапоги
эльфийца","6","200");
INSERT INTO items
VALUES("274","1","Шлем
проклятого","6","200");
INSERT INTO
items VALUES("275","2","Наплечник
проклятого","6","200");
INSERT INTO
items VALUES("276","3","Доспех
проклятого","6","200");
INSERT INTO
items VALUES("277","4","Перчатки
проклятого","6","200");
INSERT INTO
items VALUES("278","5","Щит
проклятого","6","200");
INSERT INTO
items VALUES("279","6","Молот
проклятого","6","200");
INSERT INTO
items VALUES("280","7","Штаны
проклятого","6","200");
INSERT INTO
items VALUES("281","8","Сапоги
проклятого","6","200");
INSERT INTO
items VALUES("282","1","Шлем
солнца","6","200");
INSERT INTO items
VALUES("283","2","Наплечник
солнца","6","200");
INSERT INTO items
VALUES("284","3","Доспех
солнца","6","200");
INSERT INTO items
VALUES("285","4","Перчатки
солнца","6","200");
INSERT INTO items
VALUES("286","5","Клинок солнца
инь","6","200");
INSERT INTO items
VALUES("287","6","Клинок солнца
янь","6","200");
INSERT INTO items
VALUES("288","7","Штаны
солнца","6","200");
INSERT INTO items
VALUES("289","8","Сапоги
солнца","6","200");
INSERT INTO items
VALUES("290","1","Шлем
циклопа","6","200");
INSERT INTO items
VALUES("291","2","Наплечник
циклопа","6","200");
INSERT INTO items
VALUES("292","3","Доспех
циклопа","6","200");
INSERT INTO items
VALUES("293","4","Перчатки
циклопа","6","200");
INSERT INTO items
VALUES("294","5","Щит
циклопа","6","200");
INSERT INTO items
VALUES("295","6","Меч
циклопа","6","200");
INSERT INTO items
VALUES("296","7","Штаны
циклопа","6","200");
INSERT INTO items
VALUES("297","8","Сапоги
циклопа","6","200");
INSERT INTO items
VALUES("298","1","Шлем
олимпийца","5","200");
INSERT INTO items
VALUES("299","2","Наплечник
олимпийца","5","200");
INSERT INTO items
VALUES("300","3","Броня
олимпийца","5","200");
INSERT INTO items
VALUES("301","4","Перчатки
олимпийца","5","200");
INSERT INTO items
VALUES("302","5","Щит
олимпийца","5","200");
INSERT INTO items
VALUES("303","6","Меч
олимпийца","5","200");
INSERT INTO items
VALUES("304","7","Штаны
олимпийца","5","200");
INSERT INTO items
VALUES("305","8","Сапоги
олимпийца","5","200");
INSERT INTO items
VALUES("306","1","Шлем
луны","5","200");
INSERT INTO items
VALUES("307","2","Наплечник
луны","5","200");
INSERT INTO items
VALUES("308","3","Броня
луны","5","200");
INSERT INTO items
VALUES("309","4","Перчатки
луны","5","200");
INSERT INTO items
VALUES("310","5","Щит
луны","5","200");
INSERT INTO items
VALUES("311","6","Меч
луны","5","200");
INSERT INTO items
VALUES("312","7","Штаны
луны","5","200");
INSERT INTO items
VALUES("313","8","Сапоги
луны","5","200");
INSERT INTO items
VALUES("177","5","Автомат
Калашникова","4","48");
DROP TABLE
IF EXISTS `king`;
CREATE TABLE `king` (
`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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `king_member`;
CREATE TABLE `king_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 AUTO_INCREMENT=1
DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS `mail`;
CREATE TABLE
`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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `maneken`;
CREATE TABLE `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 AUTO_INCREMENT=5 DEFAULT
CHARSET=cp1251;
INSERT INTO maneken
VALUES("1","1","0","0","0","0","0","0","0","0");
INSERT
INTO maneken
VALUES("2","1","0","0","0","0","0","0","0","0");
INSERT
INTO maneken
VALUES("3","9046","0","0","0","0","0","0","0","0");
INSERT
INTO maneken
VALUES("4","11590","0","0","0","0","0","0","0","0");
DROP
TABLE IF EXISTS `mod_chat`;
CREATE TABLE `mod_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;
DROP TABLE IF EXISTS `pit`;
CREATE TABLE `pit` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT
NULL,
`sila` int(10) DEFAULT '0',
`heart` int(10) DEFAULT '0',
`ud`
int(10) DEFAULT '0',
`bron` int(10) DEFAULT '0',
`mana` int(10) DEFAULT
'0',
`pit_id` int(10) unsigned NOT NULL,
`level` int(12) DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`pit_mag`;
CREATE TABLE `pit_mag` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`img` varchar(200) DEFAULT NULL,
`name` varchar(200)
DEFAULT NULL,
`cena` int(12) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO pit_mag
VALUES("1","pet.png","Дракон","600");
DROP
TABLE IF EXISTS `pnv`;
CREATE TABLE `pnv` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`gemt` 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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `premium`;
CREATE TABLE `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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP TABLE IF
EXISTS `pvp_Elfi`;
CREATE TABLE `pvp_Elfi` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` int(11) NOT NULL,
`r` int(11) NOT NULL,
`target` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS
`quest`;
CREATE TABLE `quest` (
`id` int(100) NOT NULL DEFAULT '0',
`title` text,
`description` text,
`c` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
`_gold` int(11) NOT NULL DEFAULT
'0',
`_silver` int(11) NOT NULL DEFAULT '0',
`_exp` int(11) NOT NULL
DEFAULT '0',
`place` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO quest
VALUES("2","Только
победы!","Победить 10\r\nпротивников
на
арене","10","0","2","670","46","1");
INSERT
INTO quest VALUES("3","Поход
новичка","Отправиться в
любой\r\nпоход 3
раза","3","0","1","680","52","4");
INSERT
INTO quest VALUES("4","Поиск
ресурсов","Исследуйте 2
раза\r\nпещеру","2","0","1","600","36","5");
INSERT
INTO quest VALUES("5","Задание
мудреца","Выполни любые 10\r\nзаданий
в хижине
мудреца","10","0","2","640","41","2");
INSERT
INTO quest
VALUES("6","Гладиатор","Проведи 3
боя в
колизее","3","0","1","600","36","6");
INSERT
INTO quest VALUES("7","Жажда
крови!","Принять участие в\r\nдолине
бессмертных как минимум в
5-ти\r\nбитвах","5","0","0","1420","0","7");
INSERT
INTO quest VALUES("8","Легендарный
воин","Победи 5 раз
в\r\nдуэлях","5","0","1","0","121","3");
DROP
TABLE IF EXISTS `ref`;
CREATE TABLE `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 AUTO_INCREMENT=1
DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS `relict`;
CREATE TABLE
`relict` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(255)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`a1` int(1) NOT
NULL,
`a2` int(1) NOT NULL,
`a3` int(1) NOT NULL,
`a4` int(1) NOT
NULL,
`b1` int(1) NOT NULL,
`b2` int(1) NOT NULL,
`b3` int(1) NOT
NULL,
`b4` int(1) NOT NULL,
`c1` int(1) NOT NULL,
`c2` int(1) NOT
NULL,
`c3` int(1) NOT NULL,
`c4` int(1) NOT NULL,
`d1` int(1) NOT
NULL,
`d2` int(1) NOT NULL,
`d3` int(1) NOT NULL,
`d4` int(1) NOT
NULL,
`e1` int(1) NOT NULL,
`e2` int(1) NOT NULL,
`e3` int(1) NOT
NULL,
`e4` int(1) NOT NULL,
`f1` int(1) NOT NULL,
`f2` int(1) NOT
NULL,
`f3` int(1) NOT NULL,
`f4` int(1) NOT NULL,
`g1` int(1) NOT
NULL,
`g2` int(1) NOT NULL,
`g3` int(1) NOT NULL,
`g4` int(1) NOT
NULL,
`h1` int(1) NOT NULL,
`h2` int(1) NOT NULL,
`h3` int(1) NOT
NULL,
`h4` int(1) NOT NULL,
`i1` int(1) NOT NULL,
`i2` int(1) NOT
NULL,
`i3` int(1) NOT NULL,
`i4` int(1) NOT NULL,
`j1` int(1) NOT
NULL,
`j2` int(1) NOT NULL,
`j3` int(1) NOT NULL,
`j4` int(1) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `sack`;
CREATE TABLE `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
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS
`ticket`;
CREATE TABLE `ticket` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` int(11) DEFAULT NULL,
`act` int(1) NOT NULL,
`nazv` char(255)
DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `ticket_answer`;
CREATE TABLE
`ticket_answer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type`
enum('user','admin') NOT NULL,
`text` varchar(2048) NOT NULL,
`ticket`
int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1
DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `undying`;
CREATE TABLE
`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 AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `undying_member`;
CREATE TABLE
`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 AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP
TABLE IF EXISTS `user_q`;
CREATE TABLE `user_q` (
`user` int(11) NOT
NULL DEFAULT '0',
`q` int(11) NOT NULL DEFAULT '0',
`c` int(11) NOT
NULL DEFAULT '0',
`complete` int(11) NOT NULL DEFAULT '0',
`time`
int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
DROP TABLE IF EXISTS `users`;
CREATE TABLE `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',
`mail_closed` int(10) DEFAULT NULL,
`kod` int(10) DEFAULT
NULL,
`kode` int(10) DEFAULT NULL,
`league` int(11) NOT NULL,
`league_place` int(11) NOT NULL,
`league_fights` int(11) NOT NULL,
`key` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251;
DROP TABLE IF EXISTS
`worldkassa`;
CREATE TABLE `worldkassa` (
`id` int(11) unsigned NOT NULL
AUTO_INCREMENT COMMENT 'ID платежа (Внутренний ID)',
`id_user` int(11) unsigned NOT NULL COMMENT 'ID пользователя',
`id_bill` int(11) unsigned NOT NULL COMMENT 'ID платежа в
Worldkassa',
`time` int(11) unsigned NOT NULL COMMENT 'Время
инициализации платежа',
`time_oplata` int(11)
unsigned DEFAULT '0' COMMENT 'Время оплаты',
`summa`
decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'Сумма',
`type`
enum('0','1','2') DEFAULT '0' COMMENT 'Тип пополнения 1 - , 2
- ',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=utf8 COMMENT='Статистика платежей через
WorldKassa';
DROP TABLE IF EXISTS `zamok`;
CREATE TABLE `zamok` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL,
`param` int(11) NOT NULL,
`titan1` int(11) NOT NULL,
`titan2` int(11) NOT NULL,
`titan3` int(11)
NOT NULL,
`id_user` int(11) NOT NULL,
`level` varchar(10) NOT NULL
DEFAULT '1',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF
EXISTS `zarm`;
CREATE TABLE `zarm` (
`id` int(11) NOT NULL,
`user`
int(11) NOT NULL,
`h` int(11) NOT NULL,
`time` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;