Просмотр архива Мир воинов (ЯДРО)

DROP TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`id_user` int(11) NOT NULL,
  `support` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `contacts`;

CREATE TABLE `contacts` (
  `user` int(11) NOT
NULL DEFAULT '0',
  `ho` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT
NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

INSERT INTO
contacts
VALUES("1","82","1469730058");
INSERT INTO
contacts
VALUES("82","1","1469730058");



DROP TABLE
IF EXISTS `items`;

CREATE TABLE `items` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `gold` int(11)
NOT NULL DEFAULT '0',
  `name` text,
  `img` text,
  `strength` int(11) NOT
NULL DEFAULT '0',
  `armor` int(11) NOT NULL DEFAULT '0',
  `time` int(11)
NOT NULL DEFAULT '0',
  `health` int(11) DEFAULT '0',
  `razdel` text,
 
`status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=10 DEFAULT CHARSET=cp1251;

INSERT INTO items
VALUES("1","1","60","Меч
Фрейра","img/shop/oruj1.jpg","100","100","1469724072","100","oruj","0");
INSERT
INTO items
VALUES("2","1","150","Копьё
Парацельса","img/shop/oruj2.jpg","250","250","1469727263","250","oruj","0");
INSERT
INTO items
VALUES("3","1","2500","Катана
Гоуцзана","img/shop/oruj10.jpg","3000","3000","1469799555","3000","oruj","1");
INSERT
INTO items VALUES("4","88","60","Меч
Фрейра","img/shop/oruj1.jpg","100","100","1469799625","100","oruj","1");
INSERT
INTO items VALUES("5","1","2000","Меч
Раваны","img/shop/oruj9.jpg","2500","2500","1469799807","2500","oruj","0");
INSERT
INTO items VALUES("6","89","60","Меч
Фрейра","img/shop/oruj1.jpg","100","100","1469799881","100","oruj","1");
INSERT
INTO items
VALUES("7","1","1800","Топор
Эгера","img/shop/oruj8.jpg","2000","2000","1469800018","2000","oruj","0");
INSERT
INTO items
VALUES("8","1","1250","Клинок
Роналда","img/shop/oruj7.jpg","1500","1500","1469800085","1500","oruj","0");
INSERT
INTO items VALUES("9","1","60","Меч
Фрейра","img/shop/oruj1.jpg","100","100","1469810141","100","oruj","0");



DROP
TABLE IF EXISTS `mail`;

CREATE TABLE `mail` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `from` int(11) NOT NULL DEFAULT '0',
  `to` int(11) NOT
NULL DEFAULT '0',
  `text` text,
  `time` int(11) NOT NULL DEFAULT '0',
 
`read` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251;

INSERT INTO mail
VALUES("1","1","82","тест)","1469730058","0");



DROP
TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text,
  `time` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT
CHARSET=cp1251;

INSERT INTO news VALUES("1","Игра
запущена!","1469194451");



DROP TABLE IF EXISTS
`shop`;

CREATE TABLE `shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`gold` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT
'0',
  `name` text,
  `img` text,
  `strength` int(11) NOT NULL DEFAULT
'0',
  `armor` int(11) NOT NULL DEFAULT '0',
  `health` int(11) NOT NULL
DEFAULT '0',
  `razdel` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=12 DEFAULT CHARSET=cp1251;

INSERT INTO shop
VALUES("1","60","1","Меч
Фрейра","img/shop/oruj1.jpg","100","100","100","oruj");
INSERT
INTO shop
VALUES("2","150","5","Копьё
Парацельса","img/shop/oruj2.jpg","250","250","250","oruj");
INSERT
INTO shop VALUES("3","400","10","Меч
Тетры","img/shop/oruj3.jpg","500","500","500","oruj");
INSERT
INTO shop VALUES("4","500","15","Меч
Букара","img/shop/oruj4.jpg","700","700","700","oruj");
INSERT
INTO shop
VALUES("5","800","20","Копьё
Бёрна","img/shop/oruj5.jpg","1000","1000","1000","oruj");
INSERT
INTO shop
VALUES("6","1000","25","Топор
Зигфрида","img/shop/oruj6.jpg","1200","1200","1200","oruj");
INSERT
INTO shop
VALUES("7","1250","30","Клинок
Роналда","img/shop/oruj7.jpg","1500","1500","1500","oruj");
INSERT
INTO shop
VALUES("8","1800","35","Топор
Эгера","img/shop/oruj8.jpg","2000","2000","2000","oruj");
INSERT
INTO shop VALUES("9","2000","40","Меч
Раваны","img/shop/oruj9.jpg","2500","2500","2500","oruj");
INSERT
INTO shop
VALUES("10","2500","45","Катана
Гоуцзана","img/shop/oruj10.jpg","3000","3000","3000","oruj");
INSERT
INTO shop
VALUES("11","3000","50","Клинок
Грабителя","img/shop/oruj11.jpg","4000","4000","4000","oruj");



DROP
TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `login` varchar(100) DEFAULT NULL,
  `password`
varchar(100) DEFAULT NULL,
  `level` int(11) DEFAULT '1',
  `exp` int(11)
DEFAULT '0',
  `ban_time` int(11) DEFAULT '0',
  `online` int(11) DEFAULT
'0',
  `reg_time` int(11) DEFAULT '0',
  `gold` int(11) DEFAULT '0',
 
`access` int(11) DEFAULT '0',
  `race` text,
  `health` int(11) DEFAULT
'0',
  `armor` int(11) DEFAULT '0',
  `strength` int(11) DEFAULT '0',
 
`max_health` int(11) DEFAULT '0',
  `regen_health` int(11) DEFAULT '0',
 
`ip` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT
CHARSET=cp1251;

INSERT INTO users
VALUES("1","Admin","7687154","50","1000","0","1469897197","1469161002","29594716","1","1","2751","2757","2770","2751","1469803988","95.153.132.60");
INSERT
INTO users
VALUES("81","Воин","bldslsblds","1","0","0","1469718915","1469718901","100","0","2","0","0","0","0","0","95.153.128.73");
INSERT
INTO users
VALUES("82","Воин","bldslsblds","1","0","0","1469718980","1469718925","100","0","1","0","0","0","0","0","95.153.128.73");
INSERT
INTO users
VALUES("83","Воин","bldslsblds","1","0","0","1469731557","1469731548","100","0","1","0","0","0","0","0","95.153.128.73");
INSERT
INTO users
VALUES("84","Воин","bldslsblds","1","0","1470336633","0","1469731755","100","0","0","0","0","0","0","0","");
INSERT
INTO users
VALUES("85","Воин","bldslsblds","1","0","0","0","1469731772","100","0","0","0","0","0","0","0","");
INSERT
INTO users
VALUES("86","Воин","bldslsblds","1","0","0","1469732130","1469732070","100","0","1","0","0","0","0","0","95.153.128.73");
INSERT
INTO users
VALUES("87","Воин","bldslsblds","1","0","0","1469789365","1469789354","100","0","1","0","0","0","0","0","95.153.128.73");
INSERT
INTO users
VALUES("88","Воин","bldslsblds","1","0","0","1469799651","1469799614","40","0","1","35","100","100","100","1469799659","95.153.128.73");
INSERT
INTO users
VALUES("89","Воин","bldslsblds","1","0","0","1469799903","1469799820","40","0","1","89","100","100","100","1469799913","95.153.128.73");
INSERT
INTO users
VALUES("90","Воин","bldslsblds","1","0","0","1469805208","1469804796","100","0","1","0","0","0","0","0","185.26.182.35");
INSERT
INTO users
VALUES("91","Воин","bldslsblds","1","0","0","0","1469808401","100","0","0","0","0","0","0","0","");
INSERT
INTO users
VALUES("92","Воин","bldslsblds","1","0","0","1469810150","1469810132","70","0","1","0","0","0","0","0","95.153.132.189");
INSERT
INTO users
VALUES("93","Воин","bldslsblds","1","0","0","1469860817","1469860799","100","0","1","0","0","0","0","0","95.153.134.215");
INSERT
INTO users
VALUES("94","Воин","bldslsblds","1","0","0","1469883971","1469883952","100","0","1","0","0","0","0","0","95.153.132.60");
INSERT
INTO users
VALUES("95","Воин","bldslsblds","1","0","0","1469884080","1469884075","100","0","1","0","0","0","0","0","95.153.132.60");