Файл: chats/setup.php
Строк: 595
<?php
require( "inc/conf.inc.php" );
require( "inc/connect.php" );
echo "<title>{$cname}</title>";
echo "<style type="text/css">";
echo "body { font-size: x-small; color: {$tcol}; background-color: {$bcol}; text-align: center }";
echo "a:link,a:visited { text-decoration: none; color: {$lcol} }";
echo ".ab { border-style:solid; border-width: 1px; background-color: #008FF0 }";
echo ".ac { border-style:solid; border-width: 1px; background-color: #008000 }";
echo ".ad { border-style:solid; border-width: 1px; background-color: #FF0000 }";
echo "</style>";
echo "</head>";
echo "<body>";
switch ( $mod )
{
case "s2" :
echo "<div class="ab">Настраиваем</div><br/>";
$sql = "INSERT INTO `users` VALUES (1, 'admin', 'pass', '', '1', '6-13', '1978-06-13', 13, 0, 0, 0, 6, 1978, NULL, '', '', '', '', '', '', '0000-00-00', '0000-00-00', '', 32, 0, 20, 990, 0, 0, 0, 0, 1, 1, 1, 4, 1, 0, 0, '', '', 9, 1245065996, '11', '', '127.0.0.1', 'Opera/9.27 (Windows NT 5.1; U; MRA 5.4 (build 02644); ru)', 1, 1, 12, 0, 2, NULL, NULL, 0, 0, NULL, 0, 0, 0, 0, 0, NULL, '', '', '', 0, 0, '', '', '', '', 0, 0, 0, 0, 0, 0, NULL, 0, '');";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "INSERT INTO `users` VALUES (2, 'KOT', 'password', '', '1', '12-24', '1976-12-24', 24, 0, 0, 0, 12, 1976, NULL, 'XaPKIB', '', 'olegarhi75@mail.ru', '378036650', 'http://waufon.ru', '', '0000-00-00', '0000-00-00', '', 32567, 0, 20, 990, 0, 0, 0, 0, 1, 1, 1, 4, 5, 0, 0, '', '', 0, 1245066717, '11', '', '127.0.0.1', 'Opera/9.27 (Windows NT 5.1; U; MRA 5.4 (build 02644); ru)', 1, 1, 12, 0, 1, NULL, 36806, 0, 0, NULL, 0, 0, 0, 0, 0, NULL, '', '', '', 0, 0, '', '', '', '', 0, 0, 0, 0, 0, 0, NULL, 0, '');";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
/////////////
$sql = "INSERT INTO `vict` VALUES (1, 'Растение семейства злаков, имеющее двухцветковые колоски, которые собраны в густые метельчатые соцветия. (8 букв)', '1', 'бухарник', '1177870223')";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "INSERT INTO `vict1` VALUES (1, 'Растение семейства злаков, имеющее двухцветковые колоски, которые собраны в густые метельчатые соцветия. (8 букв)', '1', 'бухарник', '1177870223')";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
//////////
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `reg` (rn `id` int(11) NOT NULL auto_increment,rn `logo` text,rn `reg` tinyint(4) default '0',rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
//////////
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `settings` (`sid` varchar(1) NOT NULL,`reg` varchar(255) NOT NULL,`adv` varchar(255) NOT NULL,`computer` varchar(255) NOT NULL,FULLTEXT KEY `adv` (`adv`,`computer`),FULLTEXT KEY `sid` (`sid`))";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `partner` (
`partner` int(11) NOT NULL auto_increment,
`log` varchar(255) NOT NULL default '0',
`pass` varchar(255) NOT NULL default '0',
`site` varchar(255) NOT NULL default '0',
`name` varchar(255) NOT NULL default '0',
PRIMARY KEY (`partner`))";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "INSERT INTO `settings` (`sid`, `reg`, `adv`, `computer`) VALUES ('1', '1', '1', '1')";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `setting` (
`klu4` smallint(1) NOT NULL default '0',
`link1` varchar(200) NOT NULL default '',
`link2` varchar(200) NOT NULL default '',
`link3` varchar(200) NOT NULL default '',
`link1_name` varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
`link2_name` varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
`link3_name` varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
PRIMARY KEY (`klu4`))";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "INSERT INTO `setting` VALUES (1, 'waufon.ru', 'sim-sim.h2m.ru', 'topik.gif', 0x776175666f6e, 0x73696d2d73696d, 0x544f50494b2069207373796c6b69206b617274696e6b7520736d656e6920762061646d696e6b65206368617461)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "INSERT INTO `forum_sections`(`id`, `name`, `topic`, `time`) VALUES (1, 'Общение', 0, 1213513524),(2, 'Религия', 0, 1204821173),(3, 'Разное', 0, 1204821173),(4, 'Вап-мастеру', 0, 1213627816),(5, 'О сексе', 0, 1217709964),(6, 'Хакеры и искуство взлома', 0, 1218089561),(7, 'Музыка и обсудить исполнителей', 0, 1217710779),(8, 'Компютеры', 0, 1213327836),(9, 'Спорт', 0, 1213327836),(10, 'О зверюшках', 0, 1213327836)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "INSERT INTO `setts` VALUES (1, 0, 'Викторина')";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
umask( 0 );
if ( file_exists( "./prsm" ) )
{
@chmod( "./prsm", 511 );
}
if ( file_exists( "data/stats.dat" ) )
{
@chmod( "data/stats.dat", 438 );
}
if ( file_exists( "data/optim.dat" ) )
{
@chmod( "data/optim.dat", 438 );
}
if ( file_exists( "data/counter.dat" ) )
{
@chmod( "data/counter.dat", 438 );
}
echo "<br/>Ваши данные в чате";
echo "<br/>Login:........<b>admin</b><br/>";
echo "Password:.....<b>pass";
echo "<br/><b><a href="index.php">ВХОД В Ч@Т</a></b><br/><br/>";
echo "<br/>Скрипт обновлен админом сайта <a href="http://kompam.net">kompam.net</a></b>Спасибо Всем учасникам нашего форума<br/>Прошу об одном,оставляйте в любом месте мой копирайт Цените мои безсонные ночи<br/>Впрочем скрипт харош и ибаш в свой чат нах ггг.<b>с Ув.Кот.</b><br/>";
echo $msg;
$to=$mail;
$subject="Установка чатаnHOMEn";
$headers="From: iNET olegarhi75@mail.run";
$headers.="Content-type: text/html; charset="utf-8"";
$headers.="Subject: $subject";
$headers.="Content-type: text/html; charset="utf-8"";
mail($to, $subject, $msg, $headers);
break;
case "s1" :
echo "<div class="ab">Создаем таблицы</div><br/>";
$sql = "CREATE TABLE `ban` (rn `id` int(11) NOT NULL auto_increment,rn `ip` text NOT NULL,rn `soft` text NOT NULL,rn `ltime` int(11) NOT NULL default '0',rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `banlogin` (rn `id` int(11) NOT NULL auto_increment,rn `ip` text NOT NULL, rn`login` text NOT NULL, rn `soft` text NOT NULL,rn `ltime` int(11) NOT NULL default '0',rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `bansoft` (rn `id` int(11) NOT NULL auto_increment,rn `ip` text NOT NULL,rn `soft` text NOT NULL,rn `ltime` int(11) NOT NULL default '0',rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `ipsoft` (rn `id` int(11) NOT NULL auto_increment,rn `ip` text NOT NULL,rn `soft` text NOT NULL,rn `ltime` int(11) NOT NULL default '0',rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `forum_message` (rn `id` int(11) NOT NULL auto_increment,rn `topic` int(11) NOT NULL default '0',rn `login` text NOT NULL,rn `msg` text NOT NULL, rn `time` text NOT NULL, rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `forum_sections` (rn `id` int(11) NOT NULL auto_increment, rn `name` text NOT NULL, rn `topic` int(11) NOT NULL default '0', rn `time` int(11) NOT NULL default '0', rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `forum_topic` (rn `id` int(11) NOT NULL auto_increment, rn `section` int(11) NOT NULL default '0', rn `login` text NOT NULL, rn `name` text NOT NULL, rn `close` int(11) NOT NULL default '0', rn `time` int(11) NOT NULL default '0', rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `chat_rating` (rn `id` int(11) NOT NULL auto_increment,rn `sitename` text NOT NULL,rn `today` int(11) NOT NULL default '0',rn `allday` int(11) NOT NULL default '0',rn `ltime` int(11) NOT NULL default '0',rn `mydate` date NOT NULL default '0000-00-00',rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `ignor` (rn `tid` int(11) NOT NULL auto_increment, rn `login` text character set cp1251, rn `topic` text character set cp1251,rn `id` int(11) NOT NULL default '0',rn `usid` int(10) default '0',rn PRIMARY KEY (`tid`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `friends` (rn `tid` int(11) NOT NULL auto_increment, rn `login` text character set cp1251, rn `topic` text character set cp1251,rn `id` int(11) NOT NULL default '0',rn `usid` int(10) default '0',rn PRIMARY KEY (`tid`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `evils` (rn `tid` int(11) NOT NULL auto_increment, rn `login` text character set cp1251, rn `topic` text character set cp1251,rn `id` int(11) NOT NULL default '0',rn `usid` int(10) default '0',rn PRIMARY KEY (`tid`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `intim` (rn `id` int(10) unsigned NOT NULL auto_increment,rn `login` tinytext NOT NULL,rn `msg` text NOT NULL,rn `id_from` int(10) unsigned NOT NULL default '0',rn `id_to` int(10) unsigned NOT NULL default '0',rn `wtime` int(10) unsigned NOT NULL,rn `pwd` tinytext NOT NULL,rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `control` (rn `id` int(11) NOT NULL auto_increment,rn `chislo` int(11) NOT NULL default '0',rn `time` int(11) NOT NULL default '0',rn PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `letters` (rn `id` int(11) NOT NULL auto_increment,rn `login` text NOT NULL,rn `topic` text NOT NULL,rn `msg` text NOT NULL,rn `id_from` int(11) NOT NULL default '0',rn `id_to` int(11) NOT NULL default '0',rn `wtime` text NOT NULL,rn `new` int(11) NOT NULL default '0',rn `del_in` int(11) NOT NULL default '0',rn `del_out` text NOT NULL,rn PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `zags` (rn `id` int(11) NOT NULL auto_increment,rn `login` text NOT NULL,rn `topic` text NOT NULL,rn `msg` text NOT NULL,rn `id_from` int(11) NOT NULL default '0',rn `id_to` int(11) NOT NULL default '0',rn `wtime` text NOT NULL,rn `new` int(11) NOT NULL default '0',rn `del_in` int(11) NOT NULL default '0',rn `del_out` text NOT NULL,rn PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `mess` (rn `id` int(11) NOT NULL auto_increment,rn `login` text NOT NULL,rn `msg` text NOT NULL,rn `id_from` int(11) NOT NULL default '0',rn `id_to` int(11) NOT NULL default '0',rn `wtime` text NOT NULL,rn `room` text NOT NULL,rn PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `news` (rn `id` int(11) NOT NULL auto_increment,rn `login` text NOT NULL,rn `title` text NOT NULL,rn `content` text NOT NULL,rn `organizatory` text NOT NULL,rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `team` (rn `id` int(11) NOT NULL auto_increment,rn `login` text NOT NULL,rn `title` text NOT NULL,rn `content` text NOT NULL,rn `organizatory` text NOT NULL,rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `rating` (rn `id` int(11) NOT NULL default '0',rn `sname` text,rn `saddr` text,rn `hit` int(11) NOT NULL default '0',rn `all` int(11) NOT NULL default '0',rn `time` int(11) NOT NULL default '0',rn `close` int(11) NOT NULL default '0'rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `attack` (`id` int(11) NOT NULL auto_increment,`userid` int(11) NOT NULL default '0',`who` text,`msg` text,`power` int(11) NOT NULL default '0',`time` int(11) NOT NULL default '0',`what` text,PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `messagi` (`id` int(11) NOT NULL auto_increment,`kto` int(11) NOT NULL default '0',`komu` int(11) NOT NULL default '0',`msg` text,PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `bands` (`id` int(11) NOT NULL auto_increment,`name` text,`boss` text,`members` text,`avtoritet` text,`cars` text,`guns` text,`mafcredits` int(11) NOT NULL default '0',PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `refers` (`id` int(11) NOT NULL auto_increment,`userid` int(11) NOT NULL default '0',`refer` text,PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `user_home` (`id` int(11) NOT NULL auto_increment,`userid` int(11) NOT NULL default '0',`cars` text,`guns` text,`mafcredits` int(11) NOT NULL default '0',PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `fights` (`id` int(11) NOT NULL auto_increment,`userid` int(11) NOT NULL default '0',`last` text NOT NULL,PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `krisha` (`id` int(2) NOT NULL auto_increment,`city` int(2) NOT NULL default '0',`house` text NOT NULL,`mafcredits` int(2) NOT NULL default '0',`band` text NOT NULL,`users` text NOT NULL,`time` int(11) NOT NULL default '0',PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `kasino` (`id` int(11) NOT NULL auto_increment,`userid` int(11) NOT NULL default '0',`combo` text NOT NULL,PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `forsage` (`id` int(11) NOT NULL auto_increment,`users` text NOT NULL,`stage` int(2) NOT NULL default '1',`win` text NOT NULL,`time` int(11) NOT NULL,PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `forsage_cars` (`id` int(11) NOT NULL auto_increment,`userid` int(11) NOT NULL default '0',`gonka` int(11) NOT NULL default '0',`car` text NOT NULL,`mods` int(11) NOT NULL default '0',PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `sklad` (rn`id` int(11) NOT NULL auto_increment,rn`kto` int(11) NOT NULL default '0',rn`komu` int(11) NOT NULL default '0',rn`chto` text NOT NULL,rn`type` int(2) NOT NULL default '0',rnPRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `osobnyaki` (rn`id` int(11) NOT NULL auto_increment,rn`bandname` text NOT NULL,rn`type` int(2) NOT NULL default '0',rnPRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `setts` (rn `id` int(8) NOT NULL auto_increment,rn `var` int(11) default NULL,rn `name` text,rn PRIMARY KEY (`id`)rn) ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`login` text NOT NULL,
`pass` text NOT NULL,
`name` text NOT NULL,
`sex` text NOT NULL,
`birth` varchar(10) default NULL,
`bdata` date default '0000-00-00',
`bday` int(11) default '0',
`zagsbday` int(11) default '0',
`zagsbmonth` int(11) default '0',
`zagsbyear` int(11) default '0',
`bmonth` int(11) default '0',
`byear` int(11) default '0',
`photo` text,
`live` text,
`mobile` text,
`email` text,
`icq` varchar(255) NOT NULL,
`url` text,
`about` text,
`regdate` date NOT NULL default '0000-00-00',
`zagsdate` date NOT NULL default '0000-00-00',
`status` text,
`posts` int(11) NOT NULL default '0',
`credits` int(11) NOT NULL default '0',
`num_msgs` smallint(6) NOT NULL default '0',
`time_update` smallint(6) NOT NULL default '0',
`trans` tinyint(4) NOT NULL default '0',
`em` tinyint(4) default '0',
`vyd` tinyint(4) default '0',
`priv` tinyint(4) default '0',
`autohello` int(1) default '1',
`bothello` int(1) default '1',
`mcol` tinyint(4) default '0',
`vposts` int(11) NOT NULL default '0',
`genij` int(11) default '0',
`kick` int(11) NOT NULL default '0',
`ban` int(11) NOT NULL default '0',
`whokick` text NOT NULL,
`whykick` text NOT NULL,
`level` int(11) NOT NULL default '0',
`ltime` int(11) NOT NULL default '0',
`lroom` text NOT NULL,
`pwd` text NOT NULL,
`ip` text,
`browser` text NOT NULL,
`safe` tinyint(4) NOT NULL default '0',
`fsize` tinyint(4) NOT NULL default '0',
`theme` tinyint(4) NOT NULL default '0',
`ncol` tinyint(4) NOT NULL default '0',
`nastroj` tinyint(4) NOT NULL default '0',
`zags` text,
`baks` int(11) default NULL,
`krutoj` int(11) default '0',
`prizrak` int(1) default '0',
`bogatstvo` text,
`inv` int(1) default '0',
`avator` tinyint(4) NOT NULL default '0',
`mafcredits` int(11) default '0',
`votefoto` int(11) default '0',
`rabota` int(11) NOT NULL default '0',
`img` varchar(50) character set cp1251 collate cp1251_bin default NULL,
`para` varchar(50) NOT NULL,
`latuser` varchar(30) NOT NULL,
`ruser` varchar(30) NOT NULL,
`police` int(3) NOT NULL default '0',
`health` int(4) NOT NULL default '0',
`band` text NOT NULL,
`last` text NOT NULL,
`cars` text NOT NULL,
`guns` text NOT NULL,
`nums` int(11) NOT NULL default '0',
`voodoo` int(1) NOT NULL default '0',
`golod` int(4) NOT NULL default '0',
`secur` int(3) NOT NULL default '0',
`city` int(3) NOT NULL default '0',
`shrift` tinyint(4) default '0',
`myavatar` varchar(50) default NULL,
`kupleno` int(11) NOT NULL default '0',
`sound` tinyint(4) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=19 ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure<br/>=====</div>";
}
$sql = "CREATE TABLE `vict` (rn `id` int(11) NOT NULL default '0',rn `msg` text NOT NULL,rn `vopros` text,rn `answered` text,rn `time` text NOT NULL,rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `vict1` (rn `id` int(11) NOT NULL default '0',rn `msg` text NOT NULL,rn `vopros` text,rn `answered` text,rn `time` text NOT NULL,rn PRIMARY KEY (`id`)rn)";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `zapiski` (
`klu4` int(8) NOT NULL default '0',
`who` varchar(40) character set cp1251 collate cp1251_bin NOT NULL default '',
`idwho` int(12) NOT NULL default '0',
`message` blob NOT NULL,
`towhom` varchar(40) character set cp1251 collate cp1251_bin NOT NULL default '',
`idtowhom` int(12) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
`readd` tinyint(1) NOT NULL default '0',
`topic` varchar(80) character set cp1251 collate cp1251_bin NOT NULL default '',
`date` varchar(50) character set cp1251 collate cp1251_bin NOT NULL default '',
`insend` tinyint(1) NOT NULL default '1',
`ininc` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `svadbi` (
`id` int(11) NOT NULL auto_increment,
`zhenih` text NOT NULL,
`nevesta` text NOT NULL,
`frzhenih` blob NOT NULL,
`frnevesta` blob NOT NULL,
`date` varchar(10) character set cp1251 collate cp1251_bin default NULL,
`vremya` varchar(10) character set cp1251 collate cp1251_bin default NULL,
`organizatory` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
$sql = "CREATE TABLE `golos` (
`id` int(11) NOT NULL auto_increment,
`login` int(11) default '0',
`who` int(11) NOT NULL default '0',
`ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=20 ";
if ( mysql_query( $sql ) )
{
echo "<div class="ac">OK</div>";
}
else
{
echo "<div class="ad">Failure</div>";
}
echo "<br/><b><a href="setup.php?mod=s2">Дальше</a></b><br/><br/>";
break;
default :
echo "<div class="ab">Установка чата</div>";
echo "<br/><b><a href="setup.php?mod=s1">Дальше</a></b><br/><br/>";
break;
}
require("inc/coper.php");
echo "</body></html>";
mysql_close( $link );
?>