Файл: public_html/db1433243350.sql
Строк: 459
-- phpMyAdmin SQL Dump
-- version 3.5.6
-- http://www.phpmyadmin.net
--
--
Хост: localhost
-- Время создания: Июн 02 2015 г.,
16:48
-- Версия сервера: 5.5.30
-- Версия PHP:
5.4.11
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 */;
--
-- База данных: `db1433243350`
--
--
--------------------------------------------------------
--
--
Структура таблицы `adm_chat`
--
CREATE TABLE IF NOT EXISTS
`adm_chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11)
DEFAULT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) DEFAULT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `anketa`
--
CREATE TABLE IF NOT EXISTS
`anketa` (
`name` varchar(20) DEFAULT NULL,
`id_us` int(11) DEFAULT
NULL,
`city` varchar(100) DEFAULT NULL,
`osebe` varchar(500) DEFAULT
NULL,
`interes` varchar(500) DEFAULT NULL,
`data` varchar(20) NOT NULL
DEFAULT '0',
UNIQUE KEY `nick` (`name`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `ban`
--
CREATE TABLE IF NOT EXISTS
`ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`id_ban` int(11) NOT NULL,
`prich`
varchar(1024) NOT NULL,
`view` set('1','0') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_user` (`id_user`,`id_ban`),
KEY `time`
(`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `bashni`
--
CREATE TABLE IF NOT EXISTS
`bashni` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`sila` int(11) NOT
NULL,
`health` int(11) NOT NULL,
`max_health` int(11) NOT NULL,
`lovk` int(11) NOT NULL,
`zashit` int(11) NOT NULL,
`id_user` int(11)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `boss`
--
CREATE TABLE IF NOT EXISTS
`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 DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS
`chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11)
DEFAULT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) DEFAULT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `clans`
--
CREATE TABLE IF NOT EXISTS
`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 DEFAULT CHARSET=cp1251
AUTO_INCREMENT=2 ;
--
-- Дамп данных таблицы
`clans`
--
INSERT INTO `clans` (`id`, `name`, `gerb`, `level`, `exp`, `g`,
`s`, `r`, `rank_for_invite`, `rank_for_delete`, `built_1`, `built_2`,
`built_2_time`, `built_3`, `built_3_time`) VALUES
(1, 'nefest', 0, 1, 0, 0,
0, '', '0', '0', 0, 0, 0, 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `clan_invite`
--
CREATE TABLE IF NOT
EXISTS `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 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `clan_memb`
--
CREATE TABLE IF NOT
EXISTS `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 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2
;
--
-- Дамп данных таблицы `clan_memb`
--
INSERT INTO
`clan_memb` (`id`, `clan`, `user`, `rank`, `g`, `s`, `exp`, `time`,
`last_update`, `v`) VALUES
(1, 1, 1, '4', 0, 0, 0, 1433249059, 1433335459,
0);
-- --------------------------------------------------------
--
--
Структура таблицы `clan_msg`
--
CREATE TABLE IF NOT EXISTS
`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
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `clan_msg_read`
--
CREATE TABLE IF NOT
EXISTS `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 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
--
Структура таблицы `forum_comm`
--
CREATE TABLE IF NOT
EXISTS `forum_comm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg`
varchar(10024) DEFAULT NULL,
`time` int(11) NOT NULL,
`id_user` int(11)
NOT NULL,
`id_topic` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_razdel`
--
CREATE TABLE IF NOT
EXISTS `forum_razdel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(10024) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `forum_topic`
--
CREATE TABLE IF NOT
EXISTS `forum_topic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name`
varchar(10024) DEFAULT NULL,
`msg` varchar(10024) DEFAULT NULL,
`time`
int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`id_razdel` int(11) NOT
NULL,
`close` int(11) NOT NULL DEFAULT '0',
`verh` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `gold_zapros`
--
CREATE TABLE IF NOT
EXISTS `gold_zapros` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) DEFAULT NULL,
`time` int(11) NOT NULL,
`sum` int(11) DEFAULT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `ignor`
--
CREATE TABLE IF NOT EXISTS
`ignor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kto` int(11) DEFAULT
NULL,
`kogo` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `inventar`
--
CREATE TABLE IF NOT EXISTS
`inventar` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`name` varchar(50)
NOT NULL,
`plus` varchar(12) NOT NULL,
`class` int(12) NOT NULL,
`id_user` int(12) NOT NULL,
`img` varchar(50) NOT NULL,
`status`
varchar(10) NOT NULL,
`id_resa` int(12) NOT NULL,
`lvl` int(12) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `ipban`
--
CREATE TABLE IF NOT EXISTS
`ipban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(200)
DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `klan`
--
CREATE TABLE IF NOT EXISTS
`klan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_bolum` int(11) NOT
NULL,
`name` varchar(32) NOT NULL,
`id_user` int(11) DEFAULT NULL,
`time_create` int(11) NOT NULL,
`time` int(11) NOT NULL,
`close`
set('0','1') NOT NULL DEFAULT '0',
`text` mediumtext,
`up` int(100)
DEFAULT '0',
`upder` int(100) DEFAULT '0',
`manzil` varchar(16) NOT
NULL DEFAULT '0',
`gold` int(64) DEFAULT '0',
`lvl` int(11) DEFAULT
'1',
`exp` int(11) DEFAULT '0',
`sera` int(11) DEFAULT '0',
`kol_user` int(11) DEFAULT '1',
PRIMARY KEY (`id`),
KEY `id_forum`
(`id_bolum`),
FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `kompl`
--
CREATE TABLE IF NOT EXISTS
`kompl` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`id_komp` int(12) NOT
NULL,
`name` varchar(50) NOT NULL,
`type` varchar(200) NOT NULL,
`cena` int(12) NOT NULL,
`url` varchar(50) NOT NULL,
`stats`
varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `komplekt`
--
CREATE TABLE IF NOT EXISTS
`komplekt` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`name` varchar(50)
NOT NULL,
`lvl` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `kompl_us`
--
CREATE TABLE IF NOT EXISTS
`kompl_us` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`id_komp` int(12)
NOT NULL,
`act` int(1) NOT NULL DEFAULT '0',
`id_us` int(11) DEFAULT
NULL,
`type` char(200) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `magazin`
--
CREATE TABLE IF NOT EXISTS
`magazin` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`class` int(12) NOT
NULL,
`name` varchar(50) NOT NULL,
`xoru` varchar(12) NOT NULL,
`cena` int(12) NOT NULL,
`url` varchar(50) NOT NULL,
`lvl_d` int(12)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `mail`
--
CREATE TABLE IF NOT EXISTS
`mail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT
NULL,
`id_kont` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg`
varchar(1024) NOT NULL,
`read` set('0','1') NOT NULL DEFAULT '0',
`unlink` int(11) DEFAULT '0',
`show_vk` int(1) DEFAULT '1',
PRIMARY KEY
(`id`),
KEY `id_user` (`id_user`,`id_kont`),
KEY `read` (`read`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `mypets`
--
CREATE TABLE IF NOT EXISTS
`mypets` (
`id_pets` int(255) NOT NULL,
`id_user` int(255) NOT NULL,
`pets` varchar(255) CHARACTER SET cp1251 NOT NULL,
`petsname`
varchar(255) CHARACTER SET cp1251 NOT NULL,
`silapets` int(3) NOT NULL,
`healthpets` int(3) NOT NULL,
`vinoslpets` int(3) NOT NULL,
`tun_1_lev`
int(10) NOT NULL DEFAULT '1',
`tun_2_lev` int(10) NOT NULL DEFAULT '1',
`tun_3_lev` int(10) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS
`news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` varchar(10024)
DEFAULT NULL,
`time` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`title` varchar(32) DEFAULT NULL,
`main_time` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `news_kom`
--
CREATE TABLE IF NOT EXISTS
`news_kom` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11)
NOT NULL,
`msg` varchar(1024) NOT NULL,
`time` int(11) NOT NULL,
`id_news` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `pets`
--
CREATE TABLE IF NOT EXISTS
`pets` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`pets` varchar(255)
CHARACTER SET cp1251 NOT NULL,
`petsname` varchar(255) CHARACTER SET
cp1251 NOT NULL,
`price` int(255) NOT NULL,
`level` int(3) NOT NULL,
`silapets` int(4) NOT NULL,
`vinoslpets` int(255) NOT NULL,
`healthpets` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `ref`
--
CREATE TABLE IF NOT EXISTS
`ref` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_us` int(11) DEFAULT
NULL,
`nak` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `smiles`
--
CREATE TABLE IF NOT EXISTS
`smiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`adres` varchar(1024)
NOT NULL,
`name` varchar(250) DEFAULT '1',
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `ticket`
--
CREATE TABLE IF NOT EXISTS
`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 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
--
Структура таблицы `undying`
--
CREATE TABLE IF NOT EXISTS
`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 DEFAULT CHARSET=cp1251
AUTO_INCREMENT=3803 ;
--
-- Дамп данных таблицы
`undying`
--
INSERT INTO `undying` (`id`, `time`, `end`, `start`,
`opponents`) VALUES
(3802, 1433257862, '0', '0', 1);
--
--------------------------------------------------------
--
--
Структура таблицы `undying_member`
--
CREATE TABLE IF NOT
EXISTS `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 DEFAULT CHARSET=cp1251
AUTO_INCREMENT=8199 ;
--
-- Дамп данных таблицы
`undying_member`
--
INSERT INTO `undying_member` (`id`, `battle`, `user`,
`dead`, `exit`, `time`, `kills`, `dmg`) VALUES
(8198, 3802, 1, '0', '0',
1433248829, 0, 0);
--
--------------------------------------------------------
--
--
Структура таблицы `user`
--
CREATE TABLE IF NOT EXISTS
`user` (
`race` int(11) DEFAULT '0',
`last_update` int(11) DEFAULT
'1',
`ban_pr` varchar(64) NOT NULL,
`id` int(11) NOT NULL
AUTO_INCREMENT,
`timereg` int(11) DEFAULT NULL,
`nick` varchar(20)
DEFAULT NULL,
`pol` int(11) DEFAULT NULL,
`pass` varchar(100) DEFAULT
NULL,
`online` varchar(10) DEFAULT NULL,
`level` varchar(10) DEFAULT
'1',
`max_lvl` int(11) NOT NULL DEFAULT '42',
`exp` varchar(10) DEFAULT
'0',
`kris` int(11) DEFAULT '0',
`health` varchar(10) DEFAULT NULL,
`max_health` varchar(10) DEFAULT NULL,
`mana` varchar(10) DEFAULT NULL,
`max_mana` varchar(10) DEFAULT NULL,
`gold` varchar(10) DEFAULT '10',
`silver` varchar(10) DEFAULT '1000',
`sila` int(11) NOT NULL DEFAULT
'0',
`lovk` int(11) NOT NULL DEFAULT '0',
`zashit` int(11) NOT NULL
DEFAULT '0',
`param` int(11) NOT NULL DEFAULT '0',
`avatar` int(11) NOT
NULL DEFAULT '0',
`prava` int(11) NOT NULL DEFAULT '0',
`set_p_str`
int(11) NOT NULL DEFAULT '10',
`podarok` int(11) NOT NULL DEFAULT '0',
`boss_pobed` int(11) NOT NULL DEFAULT '0',
`baza_gold` int(11) NOT NULL
DEFAULT '1',
`baza_silver` int(11) NOT NULL DEFAULT '1',
`baza_mana`
int(11) NOT NULL DEFAULT '1',
`baza_health` int(11) NOT NULL DEFAULT
'1',
`news_read` int(11) NOT NULL DEFAULT '0',
`boss_mission` int(11)
NOT NULL DEFAULT '0',
`duel_mission` int(11) NOT NULL DEFAULT '0',
`time_pohod` int(255) NOT NULL,
`time_pohod_money` int(255) NOT NULL,
`pohod` int(255) NOT NULL,
`pohod_start` int(255) NOT NULL,
`pohod_time` int(255) NOT NULL,
`ip` varchar(200) DEFAULT NULL,
`arenaweek` int(11) DEFAULT '0',
`kolboss` int(11) DEFAULT '0',
`tsila`
int(11) DEFAULT '1',
`tmax_health` int(11) DEFAULT '1',
`tlovk` int(11)
DEFAULT '1',
`tzashit` int(11) DEFAULT '1',
`tmax_mana` int(11) DEFAULT
'1',
`peshera` int(255) NOT NULL,
`peshera_start` int(255) NOT NULL,
`peshera_time` int(255) NOT NULL,
`time_peshera` int(255) NOT NULL,
`almaz` int(11) DEFAULT '40',
`pohodlvl` varchar(10) DEFAULT '1',
`idkompl` int(11) NOT NULL DEFAULT '0',
`tipkompl` int(11) DEFAULT '0',
`ubks` int(11) DEFAULT '1',
`ubkh` int(11) DEFAULT '1',
`ubkl` int(11)
DEFAULT '1',
`ubkz` int(11) DEFAULT '1',
`ubksp` int(11) DEFAULT '1',
`ubkhp` int(11) DEFAULT '1',
`ubklp` int(11) DEFAULT '1',
`ubkzp`
int(11) DEFAULT '1',
`avas` int(11) NOT NULL DEFAULT '1',
`avah`
int(11) NOT NULL DEFAULT '1',
`aval` int(11) NOT NULL DEFAULT '1',
`avaz` int(11) NOT NULL DEFAULT '1',
`perenos_bonus` int(11) NOT NULL
DEFAULT '0',
`podar` int(11) NOT NULL DEFAULT '0',
`trava` int(11)
DEFAULT '0',
`oves` int(11) DEFAULT '0',
`idkon` int(11) NOT NULL
DEFAULT '0',
`avakon` int(11) NOT NULL DEFAULT '0',
`vinos` int(11)
DEFAULT '0',
`speed` int(11) DEFAULT '0',
`avaruns` int(11) NOT NULL
DEFAULT '0',
`avarunh` int(11) NOT NULL DEFAULT '0',
`avarunl` int(11)
NOT NULL DEFAULT '0',
`avarunz` int(11) NOT NULL DEFAULT '0',
`idruns`
int(11) NOT NULL DEFAULT '0',
`idrunh` int(11) NOT NULL DEFAULT '0',
`idrunl` int(11) NOT NULL DEFAULT '0',
`idrunz` int(11) NOT NULL DEFAULT
'0',
`duel_rating` int(11) DEFAULT '0',
`arka_pobed` int(11) DEFAULT
'0',
`arka_reyt` int(11) DEFAULT '0',
`levelkon` int(11) DEFAULT '1',
`levelkon2` int(11) DEFAULT '1',
`levelkon3` int(11) DEFAULT '1',
`ban`
int(11) NOT NULL,
`st_arka` int(11) DEFAULT '0',
`st_arkap` int(11)
DEFAULT '0',
`st_dyel` int(11) DEFAULT '0',
`st_dyelp` int(11) DEFAULT
'0',
`st_boss` int(11) DEFAULT '0',
`st_bossp` int(11) DEFAULT '0',
`kam` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nick`
(`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
--
Дамп данных таблицы `user`
--
INSERT INTO `user` (`race`,
`last_update`, `ban_pr`, `id`, `timereg`, `nick`, `pol`, `pass`, `online`,
`level`, `max_lvl`, `exp`, `kris`, `health`, `max_health`, `mana`,
`max_mana`, `gold`, `silver`, `sila`, `lovk`, `zashit`, `param`, `avatar`,
`prava`, `set_p_str`, `podarok`, `boss_pobed`, `baza_gold`, `baza_silver`,
`baza_mana`, `baza_health`, `news_read`, `boss_mission`, `duel_mission`,
`time_pohod`, `time_pohod_money`, `pohod`, `pohod_start`, `pohod_time`,
`ip`, `arenaweek`, `kolboss`, `tsila`, `tmax_health`, `tlovk`, `tzashit`,
`tmax_mana`, `peshera`, `peshera_start`, `peshera_time`, `time_peshera`,
`almaz`, `pohodlvl`, `idkompl`, `tipkompl`, `ubks`, `ubkh`, `ubkl`, `ubkz`,
`ubksp`, `ubkhp`, `ubklp`, `ubkzp`, `avas`, `avah`, `aval`, `avaz`,
`perenos_bonus`, `podar`, `trava`, `oves`, `idkon`, `avakon`, `vinos`,
`speed`, `avaruns`, `avarunh`, `avarunl`, `avarunz`, `idruns`, `idrunh`,
`idrunl`, `idrunz`, `duel_rating`, `arka_pobed`, `arka_reyt`, `levelkon`,
`levelkon2`, `levelkon3`, `ban`, `st_arka`, `st_arkap`, `st_dyel`,
`st_dyelp`, `st_boss`, `st_bossp`, `kam`) VALUES
(0, 1433249084, '', 1,
1433244164, 'nefest', 1, '123123', '1433249084', '10', 42, '0', 0, '80',
'80', '1050', '1050', '49077', '0', 80, 80, 80, 320, 0, 245345, 10, 1, 0,
1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, '85.26.186.38', 0, 0, 1, 1, 1, 1, 1, 0,
0, 0, 0, 40, '1', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0,
'100'),
(0, 1433244771, '', 2, 1433244538, 'Rsks', 1, 'Sol225588',
'1433244771', '2', 42, '0', 0, '83.5', '82', '1050', '1050', '23', '1020',
82, 82, 82, 328, 0, 0, 10, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0,
'82.145.223.32', 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 45, '1', 0, 0, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 5, 12, 1, 1, 1, 0, 5, 0, 0, 0, 0, 0, ''),
(0, 1433248633, '', 3,
1433248437, 'Senusert', 1, '111111', '1433248633', '1', 42, '0', 0, '80',
'80', '1050', '1050', '10', '1000', 80, 80, 80, 320, 0, 0, 10, 0, 0, 1, 1,
1, 1, 0, 0, 0, 0, 0, 0, 0, 0, '95.158.235.79', 0, 0, 1, 1, 1, 1, 1, 0, 0,
0, 0, 40, '1', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0,
''),
(0, 1433248808, '', 4, 1433248612, 'я лошок..', 1, 'Sergei34',
'1433248808', '1', 42, '11', 0, '85', '85', '901', '1050', '3', '114', 85,
85, 80, 335, 0, 0, 10, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0,
'141.0.12.204', 0, 0, 2, 2, 2, 1, 1, 0, 0, 0, 0, 41, '1', 0, 0, 1, 1, 1, 1,
1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
3, 57, 1, 1, 1, 0, 3, 0, 0, 0, 0, 0, ''),
(0, 1433248958, '', 5,
1433248907, 'Axpa', 1, 'qazsedcft', '1433248958', '1', 42, '0', 0, '80',
'80', '1050', '1050', '10', '1000', 80, 80, 80, 320, 0, 0, 10, 0, 0, 1, 1,
1, 1, 0, 0, 0, 0, 0, 0, 0, 0, '92.51.1.8', 0, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0,
40, '1', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, ''),
(0,
1433249256, '', 6, 1433249163, 'Tratata', 1, 'tratata', '1433249256', '1',
42, '0', 0, '80', '80', '1050', '1050', '510', '1000', 80, 80, 80, 320, 0,
0, 10, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, '195.189.120.15', 0, 0, 1,
1, 1, 1, 1, 0, 0, 0, 0, 40, '1', 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0,
0, 0, 0, 0, '');
--
--------------------------------------------------------
--
--
Структура таблицы `users_konts`
--
CREATE TABLE IF NOT
EXISTS `users_konts` (
`id_user` int(11) NOT NULL,
`id_kont` int(11)
NOT NULL,
`time` int(11) NOT NULL,
`new_msg` int(11) NOT NULL DEFAULT
'0',
`name` varchar(64) DEFAULT NULL,
UNIQUE KEY `id_user`
(`id_user`,`id_kont`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `user_podarok`
--
CREATE TABLE IF NOT
EXISTS `user_podarok` (
`user_id` int(255) NOT NULL,
`last_auth`
int(255) NOT NULL,
`stage` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
--
Структура таблицы `worldkassa`
--
CREATE TABLE IF NOT
EXISTS `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
DEFAULT CHARSET=utf8 COMMENT='Статистика платежей
через WorldKassa' AUTO_INCREMENT=1 ;
/*!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 */;