-- phpMyAdmin SQL Dump
-- version 4.0.10.6
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1:3306
-- Время создания: Янв 31 2015 г., 17:22
-- Версия сервера: 5.5.41-log
-- Версия PHP: 5.4.35
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 */;
--
-- База данных: `woc`
--
-- --------------------------------------------------------
--
-- Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`login` varchar(100) NOT NULL,
`msg` varchar(500) NOT NULL,
`time` varchar(5) NOT NULL,
`channel` varchar(50) NOT NULL,
`loc` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `chat`
--
INSERT INTO `chat` (`login`, `msg`, `time`, `channel`, `loc`) VALUES
('SHiFT', 'sdfsef', '21:59', 'lfg', 'human_village'),
('SHiFT', 'sdvdz', '22:00', 'lfg', 'human_village'),
('SHiFT', 'v\\s zdfas ', '22:00', 'lfg', 'human_village'),
('SHiFT', ' F SDVF AD', '22:00', 'lfg', 'human_village'),
('SHiFT', 'RDF efd', '22:00', 'lfg', 'human_village'),
('SHiFT', ' gsb gfdgsbs ', '22:00', 'lfg', 'human_village'),
('SHiFT', ' fsfbsfb', '22:00', 'lfg', 'human_village'),
('SHiFT', ' sgb rbadsf', '22:00', 'lfg', 'human_village'),
('SHiFT', 's gfs fvad', '22:00', 'lfg', 'human_village'),
('SHiFT', 'тест', '11:08', 'lfg', 'human_village'),
('SHiFT', 'тест 2', '11:08', 'lfg', 'human_village'),
('SHiFT', '.', '11:08', 'lfg', 'human_village'),
('SHiFT', 'успешно', '11:09', 'lfg', 'human_village'),
('SHiFT', 'добро пожаловать в чат', '11:09', 'lfg', 'human_village');
-- --------------------------------------------------------
--
-- Структура таблицы `config`
--
CREATE TABLE IF NOT EXISTS `config` (
`title` varchar(100) NOT NULL,
`copy` varchar(1200) NOT NULL,
`date` varchar(20) NOT NULL,
`css` varchar(10) NOT NULL,
`lng` varchar(2) NOT NULL,
`hsl` varchar(50) NOT NULL,
`hsl_x` int(11) NOT NULL,
`hsl_y` int(11) NOT NULL,
`osl` varchar(50) NOT NULL,
`osl_x` int(11) NOT NULL,
`osl_y` int(11) NOT NULL,
`esl` varchar(50) NOT NULL,
`esl_x` int(11) NOT NULL,
`esl_y` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `config`
--
INSERT INTO `config` (`title`, `copy`, `date`, `css`, `lng`, `hsl`, `hsl_x`, `hsl_y`, `osl`, `osl_x`, `osl_y`, `esl`, `esl_x`, `esl_y`) VALUES
('World of Craft | Free wap game | SHiFT Projects', 'SP', '2o14', 'default', 'ru', 'human_village', 1, 3, 'orc_village', 4, 3, 'elf_village', 2, 4);
-- --------------------------------------------------------
--
-- Структура таблицы `exp`
--
CREATE TABLE IF NOT EXISTS `exp` (
`lvl` int(11) NOT NULL,
`exp` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `exp`
--
INSERT INTO `exp` (`lvl`, `exp`) VALUES
(1, 0),
(2, 500),
(3, 1500),
(4, 4500),
(5, 7000),
(6, 14000),
(7, 20000),
(8, 50000),
(9, 120000),
(10, 250000);
-- --------------------------------------------------------
--
-- Структура таблицы `map`
--
CREATE TABLE IF NOT EXISTS `map` (
`1` varchar(300) NOT NULL,
`2` varchar(300) NOT NULL,
`3` varchar(300) NOT NULL,
`4` varchar(300) NOT NULL,
`5` varchar(300) NOT NULL,
`6` varchar(300) NOT NULL,
`7` varchar(300) NOT NULL,
`8` varchar(300) NOT NULL,
`9` varchar(300) NOT NULL,
`10` varchar(300) NOT NULL,
`11` varchar(300) NOT NULL,
`12` varchar(300) NOT NULL,
`13` varchar(300) NOT NULL,
`14` varchar(300) NOT NULL,
`15` varchar(300) NOT NULL,
`location` varchar(50) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Дамп данных таблицы `map`
--
INSERT INTO `map` (`1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`, `10`, `11`, `12`, `13`, `14`, `15`, `location`, `id`) VALUES
('0.png|0hp45.png|0hp45.png|0hp45.png|0hp45.png|0hp45.png|0hp45.png|0hp49.png|0hp48.png|0hp45.png|0hp45.png|0hp45.png|0.png|0.png|0.png|', '0.png|0hp11.png|0hp11.png|0hp11.png|0hp11.png|0hp50.png|0hp11.png|0hp47.png|0hp46.png|0hp11.png|0hp11.png|0hp11.png|0.png|0.png|0.png|', '0.png|0hp5.png|0hp5.png|0hp5.png|0hp5.png|0hp51.png|0hp5.png|0hp5.png|0hp5.png|0hp5.png|0hp27.png|0hp44.png|0.png|0.png|0.png|', '0.png|0hp5.png|0hp.png|0hp.png|0hp2.png|0hp6.png|0hp6.png|0hp6.png|0hp6.png|0hp1.png|0hp28a.png|0hp43.png|0.png|0.png|0.png|', '0.png|0hp5.png|0hp.png|0hp.png|0hp9.png|0hp33b.png|0hp33d.png|0hp33c.png|0hp33npc.png|0hp8.png|0hp.png|0hp.png|0.png|0.png|0.png|1', '0.png|0hp5.png|0hp.png|0hp.png|0hp9.png|0hp33b.png|0hp33e.png|0hp33f.png|0hp33a.png|0hp8.png|0hp.png|0hp.png|0.png|0.png|0.png|', '0.png|0hp5.png|0hp.png|0hp.png|0hp3.png|0hp7.png|0hp7.png|0hp7.png|0hp7.png|0hp4.png|0hp.png|0hp.png|0.png|0.png|0.png|', '0.png|0hp5.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0.png|0.png|0.png|', '0.png|0hp5.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp33f.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0hp.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', 'mhome2', 1),
('0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0hp24.png|0hp23.png|0hp21.png|0hp12.png|0hp13.png|0hp11.png|0hp11.png|0hp31.png|0hp11.png|0hp11.png|0hp14.png|0.png|0.png', '0.png|0.png|0hp26.png|0hp25.png|0hp22.png|0hp17.png|0hp16.png|0hp5.png|0hp5.png|0hp30.png|0hp29.png|0hp27.png|0hp5.png|0.png|0.png|', '0.png|0.png|0hp5.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp32.png|0hp34.png|0hp28.png|0hp.png|0.png|0.png|', '0.png|0.png|0hp5.png|0hp.png|0hp.png|0hp2.png|0hp6.png|0hp19.png|0hp6.png|0hp1.png|0hp.png|0hp.png|0hp.png|0.png|0.png|', '0.png|0.png|0hp5.png|0hp36.png|0hp35.png|0hp9.png|0hp10.png|0hp20.png|0hp10.png|0hp8.png|0hp.png|0hp.png|0hp.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0hp5.png|0hp37.png|0hp38.png|0hp9.png|0hp10.png|0hp10.png|0hp10.png|0hp8.png|0hp.png|0hp.png|0hp.png|0.png|0.png|', '0.png|0.png|0hp5.png|0hp.png|0hp.png|0hp3.png|0hp7.png|0hp7.png|0hp7.png|0hp4.png|0hp.png|0hp.png|0hp.png|0.png|0.png|', '0.png|0.png|0hp5.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0hp.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0hp5.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0hp24.png|0hp23.png|0hp40.png|0hp21.png|0.png|0.png|0.png|0.png|0.png|0.png|0hp40.png|0hp14.png|0hp41.png|0hp39.png|0hp21.png|', '0hp26.png|0hp25.png|0hp5.png|0hp22.png|0.png|0.png|0.png|0.png|0.png|0.png|0hp2.png|0hp6.png|0hp6.png|0hp6.png|0hp22.png|', '0hp5.png|0hp2.png|0hp1.png|0hp.png|0.png|0.png|0.png|0.png|0.png|0.png|0hp9.png|0hp10.png|0hp10.png|0hp10.png|0hp8.png|', '0hp5.png|0hp3.png|0hp4.png|0hp.png|0.png|0.png|0.png|0.png|0.png|0.png|0hp9.png|0hp10.png|0hp10.png|0hp10.png|0hp8.png|', 'mhome', 2),
('0.png|0.png|0.png|0.png|0.png|0hp11.png|0hp42.png|0hp11.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0hp2.png|0hp6.png|0hp1.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0hp9.png|0hp10.png|0hp8.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0hp9.png|0hp10.png|0hp8.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0hp11.png|0hp11.png|0hp11.png|0hp11.png|0hp9.png|0hp10.png|0hp8.png|0hp11.png|0hp11.png|0hp11.png|0hp11.png|0.png|0.png|0.png|', '0.png|0hp5.png|0hp5.png|0hp5.png|0hp27.png|0hp9.png|0hp10.png|0hp8.png|0hp27.png|0hp5.png|0hp5.png|0hp5.png|0.png|0.png|0.png|', '0.png|0hp.png|0hp.png|0hp.png|0hp28a.png|0hp9.png|0hp10.png|0hp8.png|0hp28a.png|0hp.png|0hp.png|0hp.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0hp9.png|0hp10.png|0hp8.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0hp3.png|0hp7.png|0hp4.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0hp.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', '0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|0.png|', 'test', 3),
('0ga.png|0ga.png|0g22.png|0g23.png|0g23.png|0g23.png|0g21.png|0ga.png|0gb.png|0g.png|0gc.png|0ga.png|0ga.png|0ga.png|0ga.png|', '0g.png|0g8.png|0g12a.png|0g18a.png|0g16.png|0g19.png|0g13.png|0g9.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g6.png|0g7b.png|0g7.png|0g11.png|0g7a.png|0g7c.png|0g4.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g3.png|0g1.png|0g1.png|0g1.png|0g1.png|0g1.png|0g2.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g24.png|0g26.png|0g26.png|0g25.png|0g9.png|0g8.png|0g24.png|0g26.png|0g26.png|0g26.png|0g25.png|0g9.png|0g.png|0g.png|0g.png|', '0g22.png|0g23.png|0g23.png|0g21.png|0g4.png|0g6.png|0g22.png|0g23.png|0g23.png|0g23.png|0g21.png|0g4.png|0g.png|0g.png|0g.png|', '0g12a.png|0g18.png|0g19.png|0g13.png|0g4.png|0g6.png|0g12a.png|0g18b.png|0g16.png|0g19.png|0g13.png|0g4.png|0g.png|0g.png|0g.png|', '0g3.png|0g1.png|0g1.png|0g1.png|0g2.png|0g3.png|0g1.png|0g1.png|0g1.png|0g1.png|0g1.png|0g2.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', 'human_village', 4),
('0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', 'orc_village', 5),
('0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', '0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|0g.png|', 'elf_village', 7);
-- --------------------------------------------------------
--
-- Структура таблицы `map_forwarding`
--
CREATE TABLE IF NOT EXISTS `map_forwarding` (
`map` varchar(100) NOT NULL,
`map_x` int(11) NOT NULL,
`map_y` int(11) NOT NULL,
`destination` varchar(100) NOT NULL,
`destination_x` int(11) NOT NULL,
`destination_y` int(11) NOT NULL,
`desc` varchar(100) NOT NULL,
`auto` varchar(3) NOT NULL,
`script` varchar(200) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Дамп данных таблицы `map_forwarding`
--
INSERT INTO `map_forwarding` (`map`, `map_x`, `map_y`, `destination`, `destination_x`, `destination_y`, `desc`, `auto`, `script`, `id`) VALUES
('mhome', 6, 10, 'mhome', 12, 12, 'enter', 'no', '', 1),
('mhome', 12, 12, 'mhome', 6, 10, 'exit', 'no', '', 2),
('mhome', 10, 3, 'mhome2', 9, 3, '', 'yes', '', 3),
('mhome2', 10, 3, 'mhome', 11, 3, 'st_up', 'no', '', 4),
('mhome2', 10, 4, 'mhome', 11, 3, 'st_up', 'no', '', 5),
('mhome2', 3, 10, 'test', 6, 1, 'enter', 'no', '', 6),
('test', 6, 10, 'mhome', 7, 7, 'enter', 'no', '', 7),
('mhome', 10, 12, 'mhome', 2, 12, 'enter', 'no', 'assets/adminroom.scr', 8),
('mhome', 2, 12, 'mhome', 10, 12, 'exit', 'no', '', 9);
-- --------------------------------------------------------
--
-- Структура таблицы `map_tips`
--
CREATE TABLE IF NOT EXISTS `map_tips` (
`map` varchar(100) NOT NULL,
`map_x` int(11) NOT NULL,
`map_y` int(11) NOT NULL,
`tip` varchar(600) NOT NULL,
`tip_desc` varchar(100) NOT NULL,
`auto` varchar(3) NOT NULL,
`script` varchar(200) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Дамп данных таблицы `map_tips`
--
INSERT INTO `map_tips` (`map`, `map_x`, `map_y`, `tip`, `tip_desc`, `auto`, `script`, `id`) VALUES
('mhome', 12, 3, 'tip_1', 'tip_1d', 'no', '', 1),
('mhome', 7, 6, 'tip_2', 'tip_2d', 'no', '', 2),
('mhome', 2, 4, 'tip_3', 'tip_3d', 'no', 'assets/comp.scr', 3),
('human_village', 0, 8, 'tip_1', 'tip_1d', 'no', '', 7),
('human_village', 2, 3, 'tip_4', 'tip_4d', 'no', '', 8),
('human_village', 0, 0, '23', '23', 'yes', '', 9);
-- --------------------------------------------------------
--
-- Структура таблицы `max_online`
--
CREATE TABLE IF NOT EXISTS `max_online` (
`max` int(10) NOT NULL,
`date` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `max_online`
--
INSERT INTO `max_online` (`max`, `date`) VALUES
(4, '27.11.2014');
-- --------------------------------------------------------
--
-- Структура таблицы `movecontroll`
--
CREATE TABLE IF NOT EXISTS `movecontroll` (
`texture` varchar(200) NOT NULL,
UNIQUE KEY `texture` (`texture`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `movecontroll`
--
INSERT INTO `movecontroll` (`texture`) VALUES
('0.png'),
('0g11.png'),
('0g12.png'),
('0g12a.png'),
('0g13.png'),
('0g14.png'),
('0g15.png'),
('0g16.png'),
('0g17.png'),
('0g19.png'),
('0g20.png'),
('0g21.png'),
('0g22.png'),
('0g23.png'),
('0g24.png'),
('0g25.png'),
('0g26.png'),
('0ga.png'),
('0gb.png'),
('0gc.png'),
('0gd.png'),
('0ge.png'),
('0gf.png'),
('0hp11.png'),
('0hp12.png'),
('0hp13.png'),
('0hp14.png'),
('0hp15.png'),
('0hp16.png'),
('0hp17.png'),
('0hp18.png'),
('0hp19.png'),
('0hp21.png'),
('0hp22.png'),
('0hp23.png'),
('0hp24.png'),
('0hp25.png'),
('0hp26.png'),
('0hp30.png'),
('0hp31.png'),
('0hp32.png'),
('0hp34.png'),
('0hp37.png'),
('0hp38.png'),
('0hp39.png');
-- --------------------------------------------------------
--
-- Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`new` varchar(1500) NOT NULL,
`date` varchar(10) NOT NULL,
`time` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `news`
--
INSERT INTO `news` (`new`, `date`, `time`) VALUES
('Старт игры.<pre>Сегодня стартовал тестовый сервер игры World of Craft!</pre>', '27.11.2014', '18:55');
-- --------------------------------------------------------
--
-- Структура таблицы `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`time` varchar(200) NOT NULL,
`ip` varchar(200) NOT NULL,
`ua` varchar(200) NOT NULL,
`name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Дамп данных таблицы `online`
--
INSERT INTO `online` (`time`, `ip`, `ua`, `name`) VALUES
('1422714002', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.91 Safari/537.36', 'Гость');
-- --------------------------------------------------------
--
-- Структура таблицы `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`login` varchar(10) NOT NULL,
`phash` varchar(50) NOT NULL,
`mail` varchar(40) NOT NULL,
`sex` varchar(10) NOT NULL,
`rdate` varchar(10) NOT NULL,
`rtime` varchar(8) NOT NULL,
`lvisit` varchar(30) NOT NULL,
`ip` varchar(15) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`pos` int(11) NOT NULL,
`posx` int(11) NOT NULL,
`posy` int(11) NOT NULL,
`server` varchar(100) NOT NULL,
`loc` varchar(100) NOT NULL,
`avatar` varchar(300) NOT NULL,
`race` varchar(20) NOT NULL,
`hp` int(11) NOT NULL,
`hpm` int(11) NOT NULL,
`mp` int(11) NOT NULL,
`mpm` int(11) NOT NULL,
`exp` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Дамп данных таблицы `user`
--
INSERT INTO `user` (`login`, `phash`, `mail`, `sex`, `rdate`, `rtime`, `lvisit`, `ip`, `id`, `pos`, `posx`, `posy`, `server`, `loc`, `avatar`, `race`, `hp`, `hpm`, `mp`, `mpm`, `exp`) VALUES
('SHiFT', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '[email protected]', 'man', '27,11,2014', '21:56:20', '23,12,2014 [12:32]', '127.0.0.1', 11, 1, 10, 4, 'test', 'human_village', 'm.png', 'human', 0, 0, 0, 0, 0),
('admin', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '[email protected]', 'woman', '27,11,2014', '22:01:54', '12,12,2014 [20:12]', '127.0.0.1', 12, 1, 0, 1, 'test', 'human_village', 'w.png', 'elf', 0, 0, 0, 0, 0),
('ass', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '[email protected]', 'woman', '27,11,2014', '22:02:51', '', '127.0.0.1', 13, 1, 4, 3, 'test', 'orc_village', 'w.png', 'orc', 0, 0, 0, 0, 0);
/*!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 */;