Просмотр архива Скрипт копии игрушек

DROP TABLE IF EXISTS `adm_users`;

CREATE TABLE `adm_users` (
  `id`
int(11) NOT NULL AUTO_INCREMENT,
  `login` text NOT NULL,
  `password` text
NOT NULL,
  `sid` text NOT NULL,
  `ip` text NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO
adm_users
VALUES("1","admin","0375ac64be28ab9edeccb7abd32413b5","765f83d3850f0824d6d9b711055f87f4","88.147.152.104");



DROP
TABLE IF EXISTS `category`;

CREATE TABLE `category` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `about` text NOT NULL,
 
`description` text NOT NULL,
  `keywords` text NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

INSERT INTO
category
VALUES("16","Стратегии","","","");
INSERT
INTO category
VALUES("17","Драки","","","");
INSERT
INTO category
VALUES("18","Симуляторы","","","");
INSERT
INTO category
VALUES("19","RPG","","","");
INSERT
INTO category
VALUES("20","Стрелялки","","","");
INSERT
INTO category
VALUES("21","Фермы","","","");
INSERT
INTO category
VALUES("22","Гонки","","","");
INSERT
INTO category
VALUES("23","Экономические","","","");
INSERT
INTO category
VALUES("24","Другие","","","");
INSERT
INTO category
VALUES("26","Любительские","","","");
INSERT
INTO category
VALUES("27","лучшие","","","");



DROP
TABLE IF EXISTS `contacts`;

CREATE TABLE `contacts` (
  `key` text NOT
NULL,
  `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT
INTO contacts
VALUES("email","reklama2016@list.ru");
INSERT INTO
contacts VALUES("telephone","79085589150");
INSERT INTO
contacts VALUES("skype","нету");
INSERT INTO
contacts VALUES("icq","666666");



DROP TABLE IF
EXISTS `news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `name` text NOT NULL,
  `text` text NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

INSERT
INTO news VALUES("2","Мы
открылись","Это первая новость
данного сайта,он сейчас в
доработке.Делается этот сайт просто так
от скуки");



DROP TABLE IF EXISTS `rekl`;

CREATE TABLE
`rekl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
 
`url` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `settings_core`;

CREATE TABLE
`settings_core` (
  `key` text NOT NULL,
  `value` text NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO settings_core
VALUES("description","каталог игр");
INSERT
INTO settings_core VALUES("title","");
INSERT INTO
settings_core VALUES("keywords","каталог
игр");
INSERT INTO settings_core
VALUES("page","7");
INSERT INTO settings_core
VALUES("rules","Пусто");



DROP TABLE IF EXISTS
`site`;

CREATE TABLE `site` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`id_category` int(11) NOT NULL,
  `url` varchar(100) NOT NULL,
  `name`
varchar(100) NOT NULL,
  `about` text NOT NULL,
  `description`
varchar(255) NOT NULL,
  `keywords` varchar(255) NOT NULL,
  `mod` int(11)
NOT NULL,
  `ban` int(11) NOT NULL,
  `ban_text` text NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

INSERT
INTO site
VALUES("5","23","nebo.mobi","Небоскребы","Построй
небоскреб мечты и сделай своих жителей
счастливыми!","","","1","0","");
INSERT
INTO site
VALUES("6","16","spacecrysis.ru","SpaceCrysis","SpaceCrysis
- это многопользовательская онлайн
стратегия реального времени, в которой
вы сражаетесь с реальными противниками.
Выберите одну из сторон: сплоченных
потомков людей Терранов,
высокотехнологических Протоссов или
агресивных насекомоподобных Зергов и
докажите, что вы великий стратег и что во
вселенной вам нет
равных!","","","1","0","");
INSERT
INTO site
VALUES("7","21","crazy-mobil.ru","Моя
деревня","Так увлекательно вести
хозяйство Вам ещё никогда не доводилось!
Такого вы ещё не видели, присоединяйтесь,
это затягивает! - Сочные фрукты и овощи! -
Ароматная выпечка! - Выпекайте, готовьте,
консервируйте! - Торгуйте товарами со
своей фермы с
друзьями","","","1","0","");
INSERT
INTO site
VALUES("8","27","btwars.ru","War Of
TitanS","Спустя тысячи лет, мир
разрушен. Боги были свергнуты с небес.
Стань одним из богов и получи своё
законное, место! Игра, о которой будут
ходить легенды. Теперь легенду, можешь
создать и
ты!","","","1","0","");
INSERT
INTO site
VALUES("9","21","kolhoz.mobi","Удивительный
колхоз","Фермеры объединяются
в\r\nколхозы! Улучшение своей фермы
и\r\nвесёлые бои на
овощах.","","","1","0","");
INSERT
INTO site
VALUES("10","19","titanwar.ru","Заварушка","Эпическая
борьба двух сторон за власть и
золото!","","","1","0","");



DROP
TABLE IF EXISTS `useronline`;

CREATE TABLE `useronline` (
  `timestamp`
int(15) NOT NULL DEFAULT '0',
  `ip` varchar(40) NOT NULL,
  `file`
varchar(100) NOT NULL,
  PRIMARY KEY (`timestamp`),
  KEY `ip` (`ip`),
 
KEY `file` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO
useronline
VALUES("1429416579","88.147.152.104","/pages/category.php");
INSERT
INTO useronline
VALUES("1429416581","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416562","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416560","88.147.152.104","/pages/category.php");
INSERT
INTO useronline
VALUES("1429416554","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416548","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416546","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416544","88.147.152.104","/pages/category.php");
INSERT
INTO useronline
VALUES("1429416538","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416535","88.147.152.104","/pages/category.php");
INSERT
INTO useronline
VALUES("1429416392","88.147.152.104","/pages/news.php");
INSERT
INTO useronline
VALUES("1429416375","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416373","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416372","88.147.152.104","/pages/site.php");
INSERT
INTO useronline
VALUES("1429416343","88.147.152.104","/panel/site_mod.php");
INSERT
INTO useronline
VALUES("1429416347","88.147.152.104","/panel/site_mod.php");
INSERT
INTO useronline
VALUES("1429416348","88.147.152.104","/panel/site_mod.php");
INSERT
INTO useronline
VALUES("1429416353","88.147.152.104","/panel/site_mod.php");
INSERT
INTO useronline
VALUES("1429416371","88.147.152.104","/pages/category.php");
INSERT
INTO useronline
VALUES("1429416335","88.147.152.104","/panel/login.php");
INSERT
INTO useronline
VALUES("1429416337","88.147.152.104","/panel/site_mod.php");
INSERT
INTO useronline
VALUES("1429416333","88.147.152.104","/panel/login.php");