Файл: dating/install.php
Строк: 148
<?php
###################################################
# Знакомства под dcms 6.6.4 и 6.7.7 #
# Автор: Nort, он же Lns #
# icq: 484014288, сайт: http://inwap.org #
# #
# Вы не имеете права продавать, распростронять, #
# давать друзьям даный скрипт. #
# #
# Даная версия являет платной, и купить #
# можно только у автора. #
###################################################
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
$set['title']= 'Знакомства';
include_once '../sys/inc/thead.php';
include_once 'function.php';
title();
aut();
only_reg();
# ===================================================================
echo $div_name;
echo $Inform.' Установка знакомств<br/>';
echo '</div>';
echo $div_link;
echo 'Таблицы залиты.<br/>';
echo '</div>';
mysql_query("ALTER TABLE `user` ADD `dating_city_id` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `dating_region_id` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `dating_country_id` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingAnketa` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingTime` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingTimeChat` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingChatPass` varchar( 32 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingPrChatId` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingPrChatTime` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingTimeStar` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `DatingAnketaPr` float DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `dating_foto_1` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `dating_foto_2` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `dating_foto_3` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("CREATE TABLE IF NOT EXISTS `dating` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(24) NOT NULL,
`or` varchar(512) NOT NULL,
`cel` varchar(512) NOT NULL,
`brak` varchar(512) NOT NULL,
`partner` varchar(512) NOT NULL,
`voz` int(11) NOT NULL,
`rost` int(11) NOT NULL,
`ves` int(11) NOT NULL,
`glaza` varchar(128) NOT NULL,
`volosy` varchar(128) NOT NULL,
`telo` varchar(512) NOT NULL,
`telo2` varchar(512) NOT NULL,
`harakter` varchar(128) NOT NULL,
`zan` varchar(512) NOT NULL,
`prof` varchar(128) NOT NULL,
`kur` varchar(512) NOT NULL,
`o_sebe` varchar(512) NOT NULL,
`book` varchar(512) NOT NULL,
`flv` varchar(512) NOT NULL,
`music` varchar(512) NOT NULL,
`interes` varchar(512) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("ALTER TABLE `dating` ADD `user_id` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating` ADD `time_reg` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating` ADD `date` varchar( 32 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating` ADD `pol` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating` ADD `DatingAnketaPr` float DEFAULT '0' NOT NULL ;");
mysql_query("CREATE TABLE IF NOT EXISTS `dating_chat` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`msg` varchar(512) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE IF NOT EXISTS `dating_chat_p` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`ank_id` int(11) NOT NULL,
`msg` varchar(512) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("CREATE TABLE IF NOT EXISTS `dating_album` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("ALTER TABLE `dating_album` ADD `balls` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating_album` ADD `pass` varchar( 16 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating_album` ADD `opis` varchar( 512 ) NOT NULL ;");
mysql_query("CREATE TABLE IF NOT EXISTS `dating_photo` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`photo` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
mysql_query("ALTER TABLE `dating_photo` ADD `album_id` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating_photo` ADD `18` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `dating_photo` ADD `opis` varchar( 512 ) NOT NULL ;");
mysql_query("ALTER TABLE `dating_photo` ADD `rating` INT( 11 ) DEFAULT '0' NOT NULL ;");
mysql_query("ALTER TABLE `user` ADD `ratingnum` INT( 11 ) DEFAULT '0' NOT NULL ;");
# Рейтинг
mysql_query("CREATE TABLE IF NOT EXISTS `datingrating` (
`id` int(11) auto_increment,
`user_id` int(11) NOT NULL,
`photo_id` int(11) NOT NULL,
`rating` int(11) NOT NULL,
`time` int(11) NOT NULL,
`date` varchar(128) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
# Комментарии
mysql_query("CREATE TABLE IF NOT EXISTS `datingcomments` (
`id` int(11) auto_increment,
`user_id` int(11) NOT NULL,
`photo_id` int(11) NOT NULL,
`komm` varchar(512) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
# Журнал
mysql_query("CREATE TABLE IF NOT EXISTS `dating_jurnal` (
`id` int(11) auto_increment,
`user_id` int(11) NOT NULL,
`text` text NOT NULL,
`time` int(11) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
# ===================================================================
include_once '../sys/inc/tfoot.php';
?>