Файл: woc.sql
Строк: 1570
-- 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',
'a@a.a', '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',
'uashift@gmail.com', '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',
'a@a.xa', '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 */;