Файл: install/install_gego.php
Строк: 87
<?php
define('_IN_JOHNCMS', 1);
$headmod = 'install';
require_once ("../incfiles/core.php");
require_once ("../incfiles/head.php");
echo '<div class="phdr">Қосымша модулдері орнату</div>';
mysql_query("CREATE TABLE IF NOT EXISTS `stol_guest` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`adm` tinyint(1) NOT NULL DEFAULT '0',
`time` int(15) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(25) NOT NULL DEFAULT '',
`text` text NOT NULL,
`ip` bigint(11) NOT NULL DEFAULT '0',
`browser` tinytext NOT NULL,
`admin` varchar(25) NOT NULL DEFAULT '',
`otvet` text NOT NULL,
`otime` int(15) NOT NULL DEFAULT '0',
`edit_who` varchar(20) NOT NULL DEFAULT '',
`edit_time` int(11) NOT NULL DEFAULT '0',
`edit_count` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `ip` (`ip`),
KEY `adm` (`adm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1709 ;"); // Стол заказов
mysql_query("ALTER TABLE `users` ADD `statusID` INT NOT NULL AFTER `status` ,
ADD `statusText` INT NOT NULL AFTER `statusID`;");
mysql_query("DROP TABLE `shop`");
mysql_query("CREATE TABLE IF NOT EXISTS `shop` (
`id` int(3) NOT NULL auto_increment,
`price` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;");
mysql_query("ALTER TABLE `users` ADD `balans` int(11) NOT NULL default '0'");
mysql_query("ALTER TABLE `users` ADD `money_time` int(11) NOT NULL DEFAULT '0'");
mysql_query("ALTER TABLE `users` ADD `cnick` varchar(25) NOT NULL DEFAULT '0'");
mysql_query("ALTER TABLE `users` ADD `cstat` varchar(25) NOT NULL DEFAULT '0'");
mysql_query("INSERT INTO `shop` SET `price` = '10'");
mysql_query("INSERT INTO `shop` SET `price` = '20'");
mysql_query("INSERT INTO `shop` SET `price` = '30'");
mysql_query("INSERT INTO `shop` SET `price` = '40'");
mysql_query("INSERT INTO `shop` SET `price` = '20'");
mysql_query("INSERT INTO `shop` SET `price` = '15'");
mysql_query("INSERT INTO `shop` SET `price` = '15'");
mysql_query("INSERT INTO `shop` SET `price` = '10'");
mysql_query("INSERT INTO `shop` SET `price` = '5'");
mysql_query("INSERT INTO `shop` SET `price` = '20'");
mysql_query("INSERT INTO `shop` SET `price` = '10'");
mysql_query("INSERT INTO `shop` SET `price` = '10'");
mysql_query("INSERT INTO `shop` SET `price` = '30'");
mysql_query("DROP TABLE `downfiles`, `downkomm`, `downpath`, `down_bookmarks`, `downscreen`;");
mysql_query("CREATE TABLE IF NOT EXISTS `downfiles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(2) NOT NULL DEFAULT '0',
`pathid` int(11) NOT NULL,
`way` text NOT NULL,
`name` text NOT NULL,
`desc` text NOT NULL,
`time` int(11) NOT NULL,
`rating` varchar(3) NOT NULL DEFAULT '0',
`gol` text NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
`size` int(11) NOT NULL DEFAULT '0',
`login` text NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '1',
`themeid` int(11) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `pathid` (`pathid`),
KEY `time` (`time`),
KEY `type_status` (`type`,`status`),
FULLTEXT KEY `desc` (`desc`),
FULLTEXT KEY `way` (`way`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE IF NOT EXISTS `downkomm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fileid` int(11) NOT NULL,
`time` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`text` text NOT NULL,
`plus` int(11) NOT NULL,
`minus` int(11) NOT NULL,
`golos` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE IF NOT EXISTS `downpath` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`refid` int(11) NOT NULL,
`way` text NOT NULL,
`name` text NOT NULL,
`desc` text NOT NULL,
`position` int(11) NOT NULL,
`dost` int(11) NOT NULL DEFAULT '0',
`types` varchar(250) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `ref` (`refid`),
KEY `position` (`position`),
FULLTEXT KEY `way` (`way`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE IF NOT EXISTS `downscreen` (
`id` int(11) NOT NULL auto_increment,
`fileid` int(11) NOT NULL,
`way` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE IF NOT EXISTS `down_bookmarks` (
`user` int(11) NOT NULL,
`file` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
mysql_query("ALTER TABLE `forum` ADD `id_user` int(11) NOT NULL default 0;");
mysql_query("ALTER TABLE `users` ADD `journal_forum` int(11) NOT NULL default 0;");
echo '<div class="menu"><b>Орнатылды</b><br/>';
echo 'Стол заказов<br/>Журнал форума<br/>Загруз-Центр Максим(Simba)<br/>Новости 2 (Krite)<br/>Магазин сайта (ValekS)<br/>Х'статус<br/>Бәрі орнатылды ;))<br/><br/><p><a href="../index.php">Сайтқа кіру</a></p></div>' ;
echo '<div class="phdr">MOD by GeGo</div>' ;
require_once ('../incfiles/end.php');
?>