Файл: Gladiators v2.2/install/damp/db.sql
Строк: 571
-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Jul 23, 2012 at 11:26 PM
-- Server
version: 5.1.40
-- PHP Version: 5.2.12
SET
SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;
--
-- Database: `db`
--
--
--------------------------------------------------------
--
-- Table
structure for table `arena`
--
CREATE TABLE IF NOT EXISTS `arena` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`lider` varchar(25) NOT NULL,
`oponent` varchar(25) NOT NULL,
`status` varchar(10) NOT NULL,
`min_lvl` int(2) NOT NULL,
`max_lvl` int(2) NOT NULL,
`timer`
varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=18 ;
--
-- Dumping data for table
`arena`
--
--
--------------------------------------------------------
--
-- Table
structure for table `ban_akk`
--
CREATE TABLE IF NOT EXISTS `ban_akk` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) 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 ;
--
-- Dumping data for table `ban_akk`
--
--
--------------------------------------------------------
--
-- Table
structure for table `ban_chat`
--
CREATE TABLE IF NOT EXISTS `ban_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) 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=60 ;
--
-- Dumping data for table `ban_chat`
--
--
--------------------------------------------------------
--
-- Table
structure for table `ban_pers`
--
CREATE TABLE IF NOT EXISTS `ban_pers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) 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=62 ;
--
-- Dumping data for table `ban_pers`
--
--
--------------------------------------------------------
--
-- Table
structure for table `built`
--
CREATE TABLE IF NOT EXISTS `built` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`level`
int(3) NOT NULL,
`price_level` varchar(100) NOT NULL,
`type`
varchar(10) NOT NULL,
`gold` int(11) NOT NULL,
`tree` int(11) NOT
NULL,
`iron` int(11) NOT NULL,
`stones` int(11) NOT NULL,
`earnings`
varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=5 ;
--
-- Dumping data for table
`built`
--
INSERT INTO `built` (`id`, `name`, `level`, `price_level`,
`type`, `gold`, `tree`, `iron`, `stones`, `earnings`) VALUES
(1,
'Золота копальня', 1,
'1000|2000|5000|40000|80000|150000|300000|600000|999999', 'gold', 50, 50,
50, 50, '1000'),
(2, 'Каменная шахта', 1,
'1000|2000|5000|40000|80000|150000|300000|600000|999999', 'stones', 50, 50,
50, 10, '1000'),
(3, 'Железная шахта', 1,
'1000|2000|5000|40000|80000|150000|300000|600000|999999', 'iron', 50, 50,
50, 50, '1000'),
(4, 'Пилорама', 1,
'1000|2000|5000|40000|80000|150000|300000|600000|999999', 'tree', 50, 50,
50, 50, '1000');
--
--------------------------------------------------------
--
-- Table
structure for table `chars`
--
CREATE TABLE IF NOT EXISTS `chars` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) NOT NULL,
`nick`
varchar(10) NOT NULL,
`hp` int(11) NOT NULL,
`hpall` int(11) NOT NULL,
`exp` int(50) NOT NULL,
`p_ataka` int(11) NOT NULL,
`p_golova` int(11)
NOT NULL,
`p_def` int(11) NOT NULL,
`p_body` int(11) NOT NULL,
`lvl`
int(11) NOT NULL,
`rasa` varchar(10) NOT NULL,
`gold` int(50) NOT
NULL,
`p_nogi` int(11) NOT NULL,
`skill` int(11) NOT NULL,
`tree`
int(50) NOT NULL,
`iron` int(50) NOT NULL,
`stones` int(50) NOT NULL,
`arena_win` int(25) NOT NULL,
`pol` varchar(1) NOT NULL,
`prava`
int(11) NOT NULL,
`clan` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data
for table `chars`
--
--
--------------------------------------------------------
--
-- Table
structure for table `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id`
int(15) NOT NULL AUTO_INCREMENT,
`usr` varchar(30) COLLATE
utf8_unicode_ci NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`data` 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 ;
--
--
Dumping data for table `chat`
--
--
--------------------------------------------------------
--
-- Table
structure for table `clan`
--
CREATE TABLE IF NOT EXISTS `clan` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`lider` varchar(25) NOT NULL,
`name`
varchar(25) NOT NULL,
`alli` varchar(25) NOT NULL,
`emblema`
varchar(50) NOT NULL,
`gold` int(50) NOT NULL,
`zapret` int(5) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;
--
-- Dumping data for table `clan`
--
INSERT INTO
`clan` (`id`, `lider`, `name`, `alli`, `emblema`, `gold`, `zapret`)
VALUES
(1, '256894', 'weapon50', '', 'L2base.su_00008.bmp', 0, 0);
--
--------------------------------------------------------
--
-- Table
structure for table `clan_chat`
--
CREATE TABLE IF NOT EXISTS `clan_chat`
(
`id` int(15) NOT NULL AUTO_INCREMENT,
`usr` varchar(30) COLLATE
utf8_unicode_ci NOT NULL,
`clan` varchar(30) COLLATE utf8_unicode_ci NOT
NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`data` 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 ;
--
-- Dumping data
for table `clan_chat`
--
--
--------------------------------------------------------
--
-- Table
structure for table `implements`
--
CREATE TABLE IF NOT EXISTS
`implements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25)
NOT NULL,
`name` varchar(25) NOT NULL,
`lat_name` varchar(25) NOT
NULL,
`p_ataka` int(25) NOT NULL,
`p_def` int(25) NOT NULL,
`p_golova` int(25) NOT NULL,
`p_body` int(25) NOT NULL,
`p_nogi`
int(25) NOT NULL,
`hp` int(25) NOT NULL,
`lvl` int(25) NOT NULL,
`dressed` varchar(10) NOT NULL,
`type` varchar(25) NOT NULL,
`number`
int(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table
`implements`
--
--
--------------------------------------------------------
--
-- Table
structure for table `log_error`
--
CREATE TABLE IF NOT EXISTS `log_error`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) NOT NULL,
`text` text NOT NULL,
`file` varchar(25) NOT NULL,
KEY `id` (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data
for table `log_error`
--
--
--------------------------------------------------------
--
-- Table
structure for table `mail`
--
CREATE TABLE IF NOT EXISTS `mail` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`sender` varchar(25) NOT NULL,
`recipient` varchar(25) NOT NULL,
`messages` text NOT NULL,
`date`
varchar(25) NOT NULL,
`time` varchar(25) NOT NULL,
`read` varchar(5)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `mail`
--
--
--------------------------------------------------------
--
-- Table
structure for table `monster`
--
CREATE TABLE IF NOT EXISTS `monster` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
`p_ataka` int(11) NOT NULL,
`p_def` int(11) NOT NULL,
`hp` int(11) NOT
NULL,
`hpall` int(11) NOT NULL,
`lvl` int(11) NOT NULL,
`resp_time`
int(11) NOT NULL,
`status` varchar(4) NOT NULL,
`exp` int(11) NOT
NULL,
`zoloto` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=16 ;
--
-- Dumping data for table
`monster`
--
INSERT INTO `monster` (`id`, `name`, `p_ataka`, `p_def`,
`hp`, `hpall`, `lvl`, `resp_time`, `status`, `exp`, `zoloto`) VALUES
(1,
'Волк', 7, 3, 20, 20, 1, 0, 'on', 3, 10),
(2, 'Волк', 7, 3, 20, 20,
1, 0, 'on', 3, 10),
(3, 'Волк', 7, 3, -18, 20, 1, 0, 'on', 3, 10),
(4,
'Волк', 7, 3, 20, 20, 1, 0, 'on', 3, 10),
(5, 'Волк', 7, 3, 20, 20,
1, 0, 'on', 3, 10),
(6, 'Волк', 7, 3, 20, 20, 1, 0, 'on', 3, 10),
(7,
'Волк', 7, 3, 20, 20, 1, 0, 'on', 3, 10),
(8, 'Серый Волк',
10, 6, 35, 35, 2, 0, 'on', 5, 15),
(9, 'Серый Волк', 10, 6, 35,
35, 2, 0, 'on', 5, 15),
(10, 'Серый Волк', 10, 6, -13, 35, 2, 0,
'on', 5, 15),
(11, 'Серый Волк', 10, 6, 35, 35, 2, 0, 'on', 5,
15),
(12, 'Серый Волк', 10, 6, 35, 35, 2, 0, 'on', 5, 15),
(13,
'Серый Волк', 10, 6, 35, 35, 2, 0, 'on', 5, 15),
(14, 'Серый
Волк', 10, 6, 35, 35, 2, 0, 'on', 5, 15),
(15, 'Серый Волк',
10, 6, -13, 35, 2, 0, 'on', 5, 15);
--
--------------------------------------------------------
--
-- Table
structure for table `msg_arena`
--
CREATE TABLE IF NOT EXISTS `msg_arena`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) NOT NULL,
`oponent` varchar(25) NOT NULL,
`msg` text NOT NULL,
`time` int(50) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `msg_arena`
--
--
--------------------------------------------------------
--
-- Table
structure for table `my_construction`
--
CREATE TABLE IF NOT EXISTS
`my_construction` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr`
varchar(25) NOT NULL,
`name` varchar(25) NOT NULL,
`level` int(3) NOT
NULL,
`price_level` varchar(100) NOT NULL,
`type` varchar(10) NOT
NULL,
`earnings` int(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table
`my_construction`
--
--
--------------------------------------------------------
--
-- Table
structure for table `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) NOT NULL,
`date` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table
`online`
--
--
--------------------------------------------------------
--
-- Table
structure for table `shop`
--
CREATE TABLE IF NOT EXISTS `shop` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
`lat_name` varchar(25) NOT NULL,
`p_ataka` int(25) NOT NULL,
`p_def`
int(25) NOT NULL,
`p_golova` int(25) NOT NULL,
`p_body` int(25) NOT
NULL,
`p_nogi` int(25) NOT NULL,
`hp` int(25) NOT NULL,
`lvl` int(2)
NOT NULL,
`type` varchar(25) NOT NULL,
`number` int(25) NOT NULL,
`gold` int(25) NOT NULL,
`tree` int(25) NOT NULL,
`iron` int(25) NOT
NULL,
`stones` int(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=187 ;
--
-- Dumping data for table
`shop`
--
INSERT INTO `shop` (`id`, `name`, `lat_name`, `p_ataka`,
`p_def`, `p_golova`, `p_body`, `p_nogi`, `hp`, `lvl`, `type`, `number`,
`gold`, `tree`, `iron`, `stones`) VALUES
(1, 'Меч новичка',
'not', 2, 0, 0, 0, 0, 0, 1, 'weapon', 0, 10, 0, 0, 0),
(2, 'Меч
розрушений', 'not', 4, 0, 0, 0, 0, 0, 1, 'weapon', 0, 20, 0, 0,
0),
(3, 'Стальной меч', 'not', 3, 0, 0, 0, 0, 0, 1, 'weapon', 0,
0, 0, 20, 0),
(4, 'Деревяный меч', 'not', 4, 0, 0, 0, 0, 0, 1,
'weapon', 0, 0, 18, 0, 0),
(5, 'Каменная булава', 'not', 5,
0, 0, 0, 0, 0, 1, 'weapon', 0, 0, 0, 0, 54),
(6, 'Простой меч',
'not', 1, 0, 0, 0, 0, 0, 1, 'weapon', 0, 8, 0, 0, 0),
(7, 'Большой
кинжал', 'not', 4, 0, 0, 0, 0, 0, 1, 'weapon', 0, 0, 0, 31, 0),
(8,
'Копьё', 'not', 2, 0, 0, 0, 0, 0, 1, 'weapon', 0, 0, 0, 16, 0),
(9,
'Двуручный меч', 'not', 5, 0, 0, 0, 0, 0, 1, 'weapon', 0, 48,
0, 0, 0),
(10, 'Меч розрушений', 'not', 8, 0, 0, 0, 0, 0, 4,
'weapon', 0, 74, 0, 0, 0),
(11, 'Стальной меч', 'not', 7, 0, 0,
0, 0, 0, 4, 'weapon', 0, 0, 0, 67, 0),
(12, 'Деревяный меч',
'not', 6, 0, 0, 0, 0, 0, 4, 'weapon', 0, 0, 70, 0, 0),
(13,
'Каменная булава', 'not', 10, 0, 0, 0, 0, 0, 4, 'weapon', 0,
0, 0, 0, 92),
(14, 'Простой меч', 'not', 8, 0, 0, 0, 0, 0, 4,
'weapon', 0, 79, 0, 0, 0),
(15, 'Большой кинжал', 'not', 9, 0,
0, 0, 0, 0, 4, 'weapon', 0, 0, 0, 80, 0),
(16, 'Копьё', 'not', 7, 0,
0, 0, 0, 0, 4, 'weapon', 0, 0, 0, 86, 0),
(17, 'Двуручный меч',
'not', 7, 0, 0, 0, 0, 0, 4, 'weapon', 0, 107, 0, 0, 0),
(18, 'Меч
розрушений', 'not', 13, 0, 0, 0, 0, 0, 6, 'weapon', 0, 254, 0, 0,
0),
(19, 'Стальной меч', 'not', 16, 0, 0, 0, 0, 0, 6, 'weapon',
0, 0, 0, 371, 0),
(20, 'Деревяный меч', 'not', 12, 0, 0, 0, 0,
0, 6, 'weapon', 0, 0, 210, 0, 0),
(21, 'Каменная булава',
'not', 15, 0, 0, 0, 0, 0, 6, 'weapon', 0, 0, 0, 0, 300),
(22,
'Простой меч', 'not', 13, 0, 0, 0, 0, 0, 6, 'weapon', 0, 193, 0,
0, 0),
(23, 'Большой кинжал', 'not', 14, 0, 0, 0, 0, 0, 6,
'weapon', 0, 0, 0, 250, 0),
(24, 'Копьё', 'not', 12, 0, 0, 0, 0, 0, 6,
'weapon', 0, 0, 0, 230, 0),
(25, 'Двуручный меч', 'not', 13, 0,
0, 0, 0, 0, 6, 'weapon', 0, 229, 0, 0, 0),
(26, 'Меч
розрушений', 'not', 21, 0, 0, 0, 0, 0, 9, 'weapon', 0, 512, 0, 0,
0),
(27, 'Стальной меч', 'not', 20, 0, 0, 0, 0, 0, 9, 'weapon',
0, 0, 0, 500, 0),
(28, 'Деревяный меч', 'not', 23, 0, 0, 0, 0,
0, 9, 'weapon', 0, 0, 520, 0, 0),
(29, 'Каменная булава',
'not', 25, 0, 0, 0, 0, 0, 9, 'weapon', 0, 0, 0, 0, 661),
(30,
'Простой меч', 'not', 22, 0, 0, 0, 0, 0, 9, 'weapon', 0, 523, 0,
0, 0),
(31, 'Большой кинжал', 'not', 20, 0, 0, 0, 0, 0, 9,
'weapon', 0, 0, 0, 501, 0),
(32, 'Копьё', 'not', 21, 0, 0, 0, 0, 0, 9,
'weapon', 0, 0, 0, 522, 0),
(33, 'Двуручный меч', 'not', 23, 0,
0, 0, 0, 0, 9, 'weapon', 0, 566, 0, 0, 0),
(34, 'Меч
розрушений', 'not', 28, 0, 0, 0, 0, 0, 12, 'weapon', 0, 856, 0,
0, 0),
(35, 'Стальной меч', 'not', 28, 0, 0, 0, 0, 0, 12,
'weapon', 0, 0, 0, 850, 0),
(36, 'Деревяный меч', 'not', 29, 0,
0, 0, 0, 0, 12, 'weapon', 0, 0, 760, 0, 0),
(37, 'Каменная
булава', 'not', 32, 0, 0, 0, 0, 0, 12, 'weapon', 0, 0, 0, 0,
973),
(38, 'Простой меч', 'not', 27, 0, 0, 0, 0, 0, 12, 'weapon',
0, 726, 0, 0, 0),
(39, 'Большой кинжал', 'not', 30, 0, 0, 0,
0, 0, 12, 'weapon', 0, 0, 0, 813, 0),
(40, 'Копьё', 'not', 29, 0, 0,
0, 0, 0, 12, 'weapon', 0, 0, 0, 791, 0),
(41, 'Двуручный меч',
'not', 28, 0, 0, 0, 0, 0, 12, 'weapon', 0, 763, 0, 0, 0),
(42, 'Меч
розрушений', 'not', 36, 0, 0, 0, 0, 0, 15, 'weapon', 0, 1240, 0,
0, 0),
(43, 'Стальной меч', 'not', 36, 0, 0, 0, 0, 0, 15,
'weapon', 0, 0, 0, 1200, 0),
(44, 'Деревяный меч', 'not', 32,
0, 0, 0, 0, 0, 15, 'weapon', 0, 0, 982, 0, 0),
(45, 'Каменная
булава', 'not', 38, 0, 0, 0, 0, 0, 15, 'weapon', 0, 0, 0, 0,
1431),
(46, 'Простой меч', 'not', 37, 0, 0, 0, 0, 0, 15,
'weapon', 0, 1256, 0, 0, 0),
(47, 'Большой кинжал', 'not', 35,
0, 0, 0, 0, 0, 15, 'weapon', 0, 0, 0, 1396, 0),
(48, 'Копьё', 'not',
38, 0, 0, 0, 0, 0, 15, 'weapon', 0, 0, 0, 1269, 0),
(49,
'Двуручный меч', 'not', 37, 0, 0, 0, 0, 0, 15, 'weapon', 0,
1426, 0, 0, 0),
(50, 'Меч розрушений', 'not', 45, 0, 0, 0, 0,
0, 18, 'weapon', 0, 1542, 0, 0, 0),
(51, 'Стальной меч', 'not',
43, 0, 0, 0, 0, 0, 18, 'weapon', 0, 0, 0, 1625, 0),
(52,
'Деревяный меч', 'not', 46, 0, 0, 0, 0, 0, 18, 'weapon', 0, 0,
1539, 0, 0),
(53, 'Каменная булава', 'not', 44, 0, 0, 0, 0,
0, 18, 'weapon', 0, 0, 0, 0, 1671),
(54, 'Простой меч', 'not',
45, 0, 0, 0, 0, 0, 18, 'weapon', 0, 1546, 0, 0, 0),
(55, 'Большой
кинжал', 'not', 46, 0, 0, 0, 0, 0, 18, 'weapon', 0, 0, 0, 1789,
0),
(56, 'Копьё', 'not', 48, 0, 0, 0, 0, 0, 18, 'weapon', 0, 0, 0,
1925, 0),
(57, 'Двуручный меч', 'not', 44, 0, 0, 0, 0, 0, 18,
'weapon', 0, 1476, 0, 0, 0),
(58, 'Меч розрушений', 'not', 61,
0, 0, 0, 0, 0, 22, 'weapon', 0, 2345, 0, 0, 0),
(59, 'Стальной
меч', 'not', 58, 0, 0, 0, 0, 0, 22, 'weapon', 0, 0, 0, 2215, 0),
(60,
'Деревяный меч', 'not', 60, 0, 0, 0, 0, 0, 22, 'weapon', 0, 0,
2456, 0, 0),
(61, 'Каменная булава', 'not', 57, 0, 0, 0, 0,
0, 22, 'weapon', 0, 0, 0, 0, 2136),
(62, 'Простой меч', 'not',
63, 0, 0, 0, 0, 0, 22, 'weapon', 0, 2621, 0, 0, 0),
(63, 'Большой
кинжал', 'not', 60, 0, 0, 0, 0, 0, 22, 'weapon', 0, 0, 0, 2536,
0),
(64, 'Копьё', 'not', 58, 0, 0, 0, 0, 0, 22, 'weapon', 0, 0, 0,
2478, 0),
(65, 'Двуручный меч', 'not', 59, 0, 0, 0, 0, 0, 22,
'weapon', 0, 2391, 0, 0, 0),
(66, 'Меч розрушений', 'not', 70,
0, 0, 0, 0, 0, 26, 'weapon', 0, 3564, 0, 0, 0),
(67, 'Стальной
меч', 'not', 70, 0, 0, 0, 0, 0, 26, 'weapon', 0, 0, 0, 3465, 0),
(68,
'Деревяный меч', 'not', 71, 0, 0, 0, 0, 0, 26, 'weapon', 0, 0,
3752, 0, 0),
(69, 'Каменная булава', 'not', 69, 0, 0, 0, 0,
0, 26, 'weapon', 0, 0, 0, 0, 3851),
(70, 'Простой меч', 'not',
73, 0, 0, 0, 0, 0, 26, 'weapon', 0, 3694, 0, 0, 0),
(71, 'Большой
кинжал', 'not', 70, 0, 0, 0, 0, 0, 26, 'weapon', 0, 0, 0, 3258,
0),
(72, 'Копьё', 'not', 72, 0, 0, 0, 0, 0, 26, 'weapon', 0, 0, 0,
4120, 0),
(73, 'Двуручный меч', 'not', 67, 0, 0, 0, 0, 0, 26,
'weapon', 0, 3567, 0, 0, 0),
(74, 'Меч розрушений', 'not', 89,
0, 0, 0, 0, 0, 30, 'weapon', 0, 9568, 0, 0, 0),
(75, 'Стальной
меч', 'not', 75, 0, 0, 0, 0, 0, 30, 'weapon', 0, 0, 0, 8756, 0),
(76,
'Деревяный меч', 'not', 86, 0, 0, 0, 0, 0, 30, 'weapon', 0, 0,
8256, 0, 0),
(77, 'Каменная булава', 'not', 100, 0, 0, 0, 0,
0, 30, 'weapon', 0, 0, 0, 0, 13524),
(78, 'Простой меч', 'not',
90, 0, 0, 0, 0, 0, 30, 'weapon', 0, 11475, 0, 0, 0),
(79, 'Большой
кинжал', 'not', 95, 0, 0, 0, 0, 0, 30, 'weapon', 0, 0, 0, 9986,
0),
(80, 'Копьё', 'not', 97, 0, 0, 0, 0, 0, 30, 'weapon', 0, 0, 0,
12369, 0),
(81, 'Двуручный меч', 'not', 99, 0, 0, 0, 0, 0, 30,
'weapon', 0, 12987, 0, 0, 0),
(82, 'Щит новичка', 'not', 0, 1, 0,
0, 0, 0, 1, 'shield', 0, 10, 0, 0, 0),
(83, 'Деревяный щит',
'not', 0, 2, 0, 0, 0, 0, 1, 'shield', 0, 0, 15, 0, 0),
(84,
'Железный щит', 'not', 0, 3, 0, 0, 0, 0, 1, 'shield', 0, 0, 0,
13, 0),
(85, 'Деревяный щит', 'not', 0, 5, 0, 0, 0, 0, 4,
'shield', 0, 0, 24, 0, 0),
(86, 'Железный щит', 'not', 0, 6, 0,
0, 0, 0, 4, 'shield', 0, 0, 0, 30, 0),
(87, 'Деревяный щит',
'not', 0, 7, 0, 0, 0, 0, 6, 'shield', 0, 0, 50, 0, 0),
(88,
'Железный щит', 'not', 0, 6, 0, 0, 0, 0, 6, 'shield', 0, 0, 0,
48, 0),
(89, 'Деревяный щит', 'not', 0, 11, 0, 0, 0, 0, 10,
'shield', 0, 0, 121, 0, 0),
(90, 'Железный щит', 'not', 0, 10,
0, 0, 0, 0, 10, 'shield', 0, 0, 0, 115, 0),
(91, 'Деревяный
щит', 'not', 0, 15, 0, 0, 0, 0, 14, 'shield', 0, 0, 256, 0, 0),
(92,
'Железный щит', 'not', 0, 17, 0, 0, 0, 0, 14, 'shield', 0, 0, 0,
375, 0),
(93, 'Деревяный щит', 'not', 0, 20, 0, 0, 0, 0, 18,
'shield', 0, 0, 1578, 0, 0),
(94, 'Железный щит', 'not', 0, 22,
0, 0, 0, 0, 18, 'shield', 0, 0, 0, 1652, 0),
(95, 'Деревяный
щит', 'not', 0, 30, 0, 0, 0, 0, 22, 'shield', 0, 0, 1863, 0, 0),
(96,
'Железный щит', 'not', 0, 29, 0, 0, 0, 0, 22, 'shield', 0, 0, 0,
1820, 0),
(97, 'Деревяный щит', 'not', 0, 38, 0, 0, 0, 0, 26,
'shield', 0, 0, 2594, 0, 0),
(98, 'Железный щит', 'not', 0, 40,
0, 0, 0, 0, 26, 'shield', 0, 0, 0, 2863, 0),
(99, 'Деревяный
щит', 'not', 0, 50, 0, 0, 0, 0, 30, 'shield', 0, 0, 7526, 0, 0),
(100,
'Железный щит', 'not', 0, 60, 0, 0, 0, 0, 30, 'shield', 0, 0, 0,
12741, 0),
(101, 'Щит герцога', 'not', 0, 80, 0, 0, 0, 0, 30,
'shield', 0, 0, 0, 16852, 0),
(102, 'Капюшон новичка', 'not',
0, 0, 1, 0, 0, 0, 1, 'golova', 0, 10, 0, 0, 0),
(103, 'Деревяный
шлем', 'not', 0, 0, 2, 0, 0, 0, 1, 'golova', 0, 0, 15, 0, 0),
(104,
'Железный шлем', 'not', 0, 0, 2, 0, 0, 0, 1, 'golova', 0, 0, 0,
13, 0),
(105, 'Шлем преисподия', 'not', 0, 3, 0, 0, 0, 0, 1,
'golova', 0, 0, 0, 0, 20),
(106, 'Деревяный шлем', 'not', 0,
0, 4, 0, 0, 0, 4, 'golova', 0, 0, 25, 0, 0),
(107, 'Железный
шлем', 'not', 0, 0, 5, 0, 0, 0, 4, 'golova', 0, 0, 0, 28, 0),
(108,
'Шлем преисподия', 'not', 0, 0, 6, 0, 0, 0, 4, 'golova', 0,
0, 0, 0, 30),
(109, 'Деревяный шлем', 'not', 0, 0, 7, 0, 0, 0,
8, 'golova', 0, 0, 152, 0, 0),
(110, 'Железный шлем', 'not', 0,
0, 7, 0, 0, 0, 8, 'golova', 0, 0, 0, 160, 0),
(111, 'Шлем
преисподия', 'not', 0, 0, 8, 0, 0, 0, 8, 'golova', 0, 0, 0, 0,
171),
(112, 'Деревяный шлем', 'not', 0, 0, 9, 0, 0, 0, 12,
'golova', 0, 0, 256, 0, 0),
(113, 'Железный шлем', 'not', 0, 0,
8, 0, 0, 0, 12, 'golova', 0, 0, 0, 312, 0),
(114, 'Шлем
преисподия', 'not', 0, 0, 10, 0, 0, 0, 12, 'golova', 0, 0, 0, 0,
472),
(115, 'Деревяный шлем', 'not', 0, 0, 12, 0, 0, 0, 16,
'golova', 0, 0, 1578, 0, 0),
(116, 'Железный шлем', 'not', 0,
0, 10, 0, 0, 0, 16, 'golova', 0, 0, 0, 1369, 0),
(117, 'Шлем
преисподия', 'not', 0, 0, 11, 0, 0, 0, 16, 'golova', 0, 0, 0, 0,
1671),
(118, 'Деревяный шлем', 'not', 0, 0, 16, 0, 0, 0, 20,
'golova', 0, 0, 3587, 0, 0),
(119, 'Железный шлем', 'not', 0,
0, 14, 0, 0, 0, 20, 'golova', 0, 0, 0, 3452, 0),
(120, 'Шлем
преисподия', 'not', 0, 0, 17, 0, 0, 0, 20, 'golova', 0, 0, 0, 0,
3741),
(121, 'Деревяный шлем', 'not', 0, 0, 20, 0, 0, 0, 24,
'golova', 0, 0, 4325, 0, 0),
(122, 'Железный шлем', 'not', 0,
0, 20, 0, 0, 0, 24, 'golova', 0, 0, 0, 3963, 0),
(123, 'Шлем
преисподия', 'not', 0, 0, 18, 0, 0, 0, 24, 'golova', 0, 0, 0, 0,
4558),
(124, 'Деревяный шлем', 'not', 0, 0, 24, 0, 0, 0, 28,
'golova', 0, 0, 5785, 0, 0),
(125, 'Железный шлем', 'not', 0,
0, 22, 0, 0, 0, 28, 'golova', 0, 0, 0, 4759, 0),
(126, 'Шлем
преисподия', 'not', 0, 0, 23, 0, 0, 0, 28, 'golova', 0, 0, 0, 0,
5123),
(127, 'Деревяный шлем', 'not', 0, 0, 28, 0, 0, 0, 30,
'golova', 0, 0, 8639, 0, 0),
(128, 'Железный шлем', 'not', 0,
0, 27, 0, 0, 0, 30, 'golova', 0, 0, 0, 7964, 0),
(129, 'Шлем
преисподия', 'not', 0, 0, 30, 0, 0, 0, 30, 'golova', 0, 0, 0, 0,
11945),
(130, 'Кольщюга новичка', 'not', 0, 0, 0, 1, 0, 0,
1, 'body', 0, 10, 0, 0, 0),
(131, 'Железная кольчюга',
'not', 0, 0, 0, 2, 0, 0, 1, 'body', 0, 0, 0, 17, 0),
(132,
'Деревяная кольчюга', 'not', 0, 0, 0, 3, 0, 0, 1, 'body',
0, 0, 15, 0, 0),
(133, 'Железная кольчюга', 'not', 0, 0, 0,
4, 0, 0, 4, 'body', 0, 0, 0, 25, 0),
(134, 'Деревяная
кольчюга', 'not', 0, 0, 0, 3, 0, 0, 4, 'body', 0, 0, 23, 0,
0),
(135, 'Железная кольчюга', 'not', 0, 0, 0, 7, 0, 0, 8,
'body', 0, 0, 0, 50, 0),
(136, 'Деревяная кольчюга',
'not', 0, 0, 0, 6, 0, 0, 8, 'body', 0, 0, 45, 0, 0),
(137,
'Железная кольчюга', 'not', 0, 0, 0, 9, 0, 0, 12, 'body',
0, 0, 0, 131, 0),
(138, 'Деревяная кольчюга', 'not', 0, 0,
0, 8, 0, 0, 12, 'body', 0, 0, 119, 0, 0),
(139, 'Железная
кольчюга', 'not', 0, 0, 0, 13, 0, 0, 16, 'body', 0, 0, 0, 264,
0),
(140, 'Деревяная кольчюга', 'not', 0, 0, 0, 11, 0, 0,
16, 'body', 0, 0, 250, 0, 0),
(141, 'Железная кольчюга',
'not', 0, 0, 0, 15, 0, 0, 20, 'body', 0, 0, 0, 846, 0),
(142,
'Деревяная кольчюга', 'not', 0, 0, 0, 17, 0, 0, 20,
'body', 0, 0, 1425, 0, 0),
(143, 'Железная кольчюга',
'not', 0, 0, 0, 20, 0, 0, 24, 'body', 0, 0, 0, 2645, 0),
(144,
'Деревяная кольчюга', 'not', 0, 0, 0, 21, 0, 0, 24,
'body', 0, 0, 2700, 0, 0),
(145, 'Железная кольчюга',
'not', 0, 0, 0, 25, 0, 0, 28, 'body', 0, 0, 0, 4521, 0),
(146,
'Деревяная кольчюга', 'not', 0, 0, 0, 27, 0, 0, 28,
'body', 0, 0, 5001, 0, 0),
(147, 'Железная кольчюга',
'not', 0, 0, 0, 40, 0, 0, 30, 'body', 0, 0, 0, 13916, 0),
(148,
'Деревяная кольчюга', 'not', 0, 0, 0, 34, 0, 0, 30,
'body', 0, 0, 10741, 0, 0),
(149, 'Сапоги новичка', 'not', 0,
0, 0, 0, 1, 0, 1, 'nogi', 0, 10, 0, 0, 0),
(150, 'Коженые
сапоги', 'not', 0, 0, 0, 0, 1, 0, 1, 'nogi', 0, 20, 0, 0, 0),
(151,
'Простые сапоги', 'not', 0, 0, 0, 0, 2, 0, 1, 'nogi', 0, 25,
0, 0, 0),
(152, 'Деревяные сапоги', 'not', 0, 0, 0, 0, 1, 0,
1, 'nogi', 0, 0, 19, 0, 0),
(153, 'Коженые сапоги', 'not', 0,
0, 0, 0, 4, 0, 4, 'nogi', 0, 53, 0, 0, 0),
(154, 'Простые
сапоги', 'not', 0, 0, 0, 0, 4, 0, 4, 'nogi', 0, 49, 0, 0, 0),
(155,
'Деревяные сапоги', 'not', 0, 0, 0, 0, 3, 0, 4, 'nogi', 0,
0, 50, 0, 0),
(156, 'Коженые сапоги', 'not', 0, 0, 0, 0, 7, 0,
8, 'nogi', 0, 154, 0, 0, 0),
(157, 'Простые сапоги', 'not', 0,
0, 0, 0, 5, 0, 8, 'nogi', 0, 140, 0, 0, 0),
(158, 'Деревяные
сапоги', 'not', 0, 0, 0, 0, 7, 0, 8, 'nogi', 0, 0, 160, 0, 0),
(159,
'Коженые сапоги', 'not', 0, 0, 0, 0, 10, 0, 12, 'nogi', 0,
262, 0, 0, 0),
(160, 'Простые сапоги', 'not', 0, 0, 0, 0, 7,
0, 12, 'nogi', 0, 236, 0, 0, 0),
(161, 'Деревяные сапоги',
'not', 0, 0, 0, 0, 9, 0, 12, 'nogi', 0, 0, 257, 0, 0),
(162,
'Коженые сапоги', 'not', 0, 0, 0, 0, 13, 0, 16, 'nogi', 0,
451, 0, 0, 0),
(163, 'Простые сапоги', 'not', 0, 0, 0, 0, 11,
0, 16, 'nogi', 0, 571, 0, 0, 0),
(164, 'Деревяные сапоги',
'not', 0, 0, 0, 0, 12, 0, 16, 'nogi', 0, 0, 497, 0, 0),
(165,
'Коженые сапоги', 'not', 0, 0, 0, 0, 15, 0, 20, 'nogi', 0,
1741, 0, 0, 0),
(166, 'Простые сапоги', 'not', 0, 0, 0, 0, 12,
0, 20, 'nogi', 0, 1464, 0, 0, 0),
(167, 'Деревяные сапоги',
'not', 0, 0, 0, 0, 14, 0, 20, 'nogi', 0, 0, 1651, 0, 0),
(168,
'Коженые сапоги', 'not', 0, 0, 0, 0, 18, 0, 24, 'nogi', 0,
2784, 0, 0, 0),
(169, 'Простые сапоги', 'not', 0, 0, 0, 0, 16,
0, 24, 'nogi', 0, 2458, 0, 0, 0),
(170, 'Деревяные сапоги',
'not', 0, 0, 0, 0, 19, 0, 24, 'nogi', 0, 0, 3415, 0, 0),
(171,
'Коженые сапоги', 'not', 0, 0, 0, 0, 25, 0, 28, 'nogi', 0,
3546, 0, 0, 0),
(172, 'Простые сапоги', 'not', 0, 0, 0, 0, 22,
0, 28, 'nogi', 0, 3157, 0, 0, 0),
(173, 'Деревяные сапоги',
'not', 0, 0, 0, 0, 24, 0, 28, 'nogi', 0, 0, 3852, 0, 0),
(174,
'Коженые сапоги', 'not', 0, 0, 0, 0, 30, 0, 30, 'nogi', 0,
9546, 0, 0, 0),
(175, 'Простые сапоги', 'not', 0, 0, 0, 0, 28,
0, 30, 'nogi', 0, 7596, 0, 0, 0),
(176, 'Деревяные сапоги',
'not', 0, 0, 0, 0, 29, 0, 30, 'nogi', 0, 0, 8126, 0, 0),
(177,
'Эликсир', 'not', 0, 0, 0, 0, 0, 5, 1, 'elixir', 1, 5, 0, 0,
0),
(178, 'Эликсир', 'not', 0, 0, 0, 0, 0, 8, 3, 'elixir', 1, 10, 0,
0, 0),
(179, 'Эликсир', 'not', 0, 0, 0, 0, 0, 15, 5, 'elixir', 1,
20, 0, 0, 0),
(180, 'Эликсир', 'not', 0, 0, 0, 0, 0, 20, 7,
'elixir', 1, 30, 0, 0, 0),
(181, 'Эликсир', 'not', 0, 0, 0, 0, 0,
30, 9, 'elixir', 1, 40, 0, 0, 0),
(182, 'Эликсир', 'not', 0, 0, 0,
0, 0, 50, 11, 'elixir', 1, 70, 0, 0, 0),
(183, 'Эликсир', 'not', 0,
0, 0, 0, 0, 65, 15, 'elixir', 1, 100, 0, 0, 0),
(184, 'Эликсир',
'not', 0, 0, 0, 0, 0, 80, 20, 'elixir', 1, 200, 0, 0, 0),
(185,
'Эликсир', 'not', 0, 0, 0, 0, 0, 100, 25, 'elixir', 1, 350, 0, 0,
0),
(186, 'Эликсир', 'not', 0, 0, 0, 0, 0, 150, 30, 'elixir', 1,
450, 0, 0, 0);
--
--------------------------------------------------------
--
-- Table
structure for table `support`
--
CREATE TABLE IF NOT EXISTS `support` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) NOT NULL,
`msg`
text NOT NULL,
`date` varchar(50) NOT NULL,
`read` varchar(10) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
--
-- Dumping data for table `support`
--
--
--------------------------------------------------------
--
-- Table
structure for table `tmp_arena`
--
CREATE TABLE IF NOT EXISTS `tmp_arena`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) NOT NULL,
`oponent` varchar(25) NOT NULL,
`time` varchar(50) NOT NULL,
`losetime`
varchar(50) NOT NULL,
`step` varchar(10) NOT NULL,
`protect`
varchar(25) NOT NULL,
`attack` varchar(25) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=32 ;
--
--
Dumping data for table `tmp_arena`
--
--
--------------------------------------------------------
--
-- Table
structure for table `to_clan`
--
CREATE TABLE IF NOT EXISTS `to_clan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`lider` varchar(25) NOT NULL,
`usr` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table
`to_clan`
--
--
--------------------------------------------------------
--
-- Table
structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL,
`pass` varchar(255) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL,
`data_reg` varchar(255) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Dumping data for table
`users`
--
INSERT INTO `users` (`id`, `usr`, `pass`, `data_reg`)
VALUES
(1, 'test5', 'e3d704f3542b44a621ebed70dc0efe13', '23 июля,
2012');
-- --------------------------------------------------------
--
--
Table structure for table `warehouse_items`
--
CREATE TABLE IF NOT EXISTS
`warehouse_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr`
varchar(25) NOT NULL,
`name` varchar(50) NOT NULL,
`lat_name`
varchar(50) NOT NULL,
`p_ataka` int(25) NOT NULL,
`p_def` int(25) NOT
NULL,
`p_golova` int(25) NOT NULL,
`p_body` int(25) NOT NULL,
`p_nogi` int(25) NOT NULL,
`hp` int(25) NOT NULL,
`lvl` int(3) NOT
NULL,
`dressed` varchar(10) NOT NULL,
`type` varchar(20) NOT NULL,
`number` int(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Dumping data for table
`warehouse_items`
--
--
--------------------------------------------------------
--
-- Table
structure for table `warehouse_res`
--
CREATE TABLE IF NOT EXISTS
`warehouse_res` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr`
varchar(25) NOT NULL,
`name` varchar(25) NOT NULL,
`type` varchar(10)
NOT NULL,
`number` int(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;
--
-- Dumping data for table
`warehouse_res`
--
--
--------------------------------------------------------
--
-- Table
structure for table `z_clan`
--
CREATE TABLE IF NOT EXISTS `z_clan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`usr` varchar(25) NOT NULL,
`clan` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Dumping data for table
`z_clan`
--