Просмотр архива Скрипт игры Waphero.ru

DROP TABLE IF EXISTS `anketa`;

CREATE TABLE `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;




DROP
TABLE IF EXISTS `bashni`;

CREATE TABLE `bashni` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL,
  `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 AUTO_INCREMENT=358 DEFAULT CHARSET=latin1;




DROP
TABLE IF EXISTS `boss`;

CREATE TABLE `boss` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL,
  `lvl` int(11) NOT NULL,
  `sila` int(11) NOT
NULL,
  `health` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `zashit`
int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
 
`image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT
CHARSET=latin1;




DROP TABLE IF EXISTS `chat`;

CREATE TABLE `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 AUTO_INCREMENT=24526 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `forum_comm`;

CREATE TABLE `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 AUTO_INCREMENT=2400 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `forum_razdel`;

CREATE TABLE
`forum_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(10024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

INSERT INTO forum_razdel
VALUES("1","Помощь по игре");
INSERT INTO
forum_razdel VALUES("2","Общение");
INSERT INTO
forum_razdel
VALUES("3","Предложения");
INSERT INTO
forum_razdel VALUES("4","Вопросы по
оплате");
INSERT INTO forum_razdel
VALUES("5","Ошибки и баги");
INSERT INTO
forum_razdel
VALUES("6","Обновления");



DROP TABLE IF
EXISTS `forum_topic`;

CREATE TABLE `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 AUTO_INCREMENT=546 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `gold_zapros`;

CREATE TABLE `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
AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`ignor`;

CREATE TABLE `ignor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`kto` int(11) DEFAULT NULL,
  `kogo` int(11) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `inventar`;

CREATE TABLE `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
AUTO_INCREMENT=1019 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`ipban`;

CREATE TABLE `ipban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`ip` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=95 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`kompl`;

CREATE TABLE `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
AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`kompl_us`;

CREATE TABLE `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 AUTO_INCREMENT=3603 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `komplekt`;

CREATE TABLE `komplekt`
(
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
 
`lvl` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`magazin`;

CREATE TABLE `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 AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `mail`;

CREATE TABLE `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
AUTO_INCREMENT=19735 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`mypets`;

CREATE TABLE `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;




DROP TABLE IF EXISTS
`news`;

CREATE TABLE `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 AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;




DROP TABLE IF
EXISTS `news_kom`;

CREATE TABLE `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 AUTO_INCREMENT=340 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `pets`;

CREATE TABLE `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 AUTO_INCREMENT=35 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `ref`;

CREATE TABLE `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
AUTO_INCREMENT=415 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`smiles`;

CREATE TABLE `smiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,

 `adres` varchar(1024) NOT NULL,
  `name` varchar(250) DEFAULT '1',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `ticket`;

CREATE TABLE `ticket` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` int(11) DEFAULT NULL,
  `act`
int(1) NOT NULL,
  `nazv` char(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`user`;

CREATE TABLE `user` (
  `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',
  `exp`
varchar(10) 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 '0',
 
`silver` varchar(10) DEFAULT '0',
  `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',
  `duel_rating` int(11) NOT NULL DEFAULT '0',
 
`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',
  `ban` 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,
  `pets`
varchar(255) NOT NULL,
  `healthpets` int(255) NOT NULL,
  `petsname`
varchar(255) NOT NULL DEFAULT 'Нет питомца',
  `silapets`
int(255) NOT NULL,
  `vinoslpets` int(255) NOT NULL,
  `petschek` int(3)
NOT NULL,
  `arenaweek` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE
KEY `nick` (`nick`)
) ENGINE=MyISAM AUTO_INCREMENT=2397 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `user_podarok`;

CREATE TABLE
`user_podarok` (
  `user_id` int(255) NOT NULL,
  `last_auth` int(255) NOT
NULL,
  `stage` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `users_konts`;

CREATE TABLE
`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;




DROP TABLE IF EXISTS `worldkassa`;

CREATE TABLE
`worldkassa` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID
платежа (Внутренний ID)',
  `id_user` int(11) unsigned NOT
NULL COMMENT 'ID пользователя',
  `id_bill` int(11) unsigned
NOT NULL COMMENT 'ID платежа в Worldkassa',
  `time` int(11)
unsigned NOT NULL COMMENT 'Время инициализации
платежа',
  `time_oplata` int(11) unsigned DEFAULT '0' COMMENT
'Время оплаты',
  `summa` decimal(11,2) NOT NULL DEFAULT '0.00'
COMMENT 'Сумма',
  `type` enum('0','1','2') DEFAULT '0' COMMENT
'Тип пополнения 1 - рубины, 2 - монеты',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1387 DEFAULT CHARSET=utf8
COMMENT='Статистика платежей через WorldKassa';