Файл: install/inc/2.php
Строк: 87
<?
if (isset($_SESSION['mysql_ok']) && $_SESSION['mysql_ok']==true)
{
if(isset($_GET['step']) && $_GET['step']=='4')
{
$_SESSION['i_step']++;
header("Location: index.php?$passgen&".SID);
exit;
}
}elseif (isset($_POST['host']) && isset($_POST['user']) && isset($_POST['pass']) && isset($_POST['db']))
{
if(!($db=@mysql_connect($_POST['host'], $_POST['user'],$_POST['pass'])))
{
$err[]='Невозможно подключиться к серверу '.$_POST['host'];
}
elseif(!@mysql_select_db($_POST['db'],$db))
{
$err[]='Проверьте название базы';
}
else
{
$set['mysql_db_name']=$_SESSION['db']=$_POST['db'];
$set['mysql_host']=$_SESSION['host']=$_POST['host'];
$set['mysql_user']=$_SESSION['user']=$_POST['user'];
$set['mysql_pass']=$_SESSION['pass']=$_POST['pass'];
mysql_query('set charset utf8');
mysql_query('SET names utf8');
mysql_query('set character_set_client="utf8"');
mysql_query('set character_set_connection="utf8"');
mysql_query('set character_set_result="utf8"');
$buf = "
CREATE TABLE IF NOT EXISTS `ban` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`pri` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `cats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `img` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cat` int(11) NOT NULL,
`name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`foto` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`view` int(11) NOT NULL DEFAULT '0',
`date` int(20) NOT NULL,
`ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `jalobs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`ank` int(11) NOT NULL,
`ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`view` int(1) NOT NULL DEFAULT '0',
`date` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` int(11) NOT NULL,
`ip` varchar(255) NOT NULL,
`ua` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
";
$a = 0;
while ($b = strpos($buf,';',$a+1)){
$i++;
$a = substr($buf,$a+1,$b-$a);
mysql_query($a);
$a = $b;
}
echo "Загружено таблиц:".$i;
if($i > 0){
$_SESSION['mysql_ok']=true;
}
}
}
if (isset($_SESSION['mysql_ok']) && $_SESSION['mysql_ok']==true)
{
echo "<div class='msg'>Подключение к базе данных успешно выполнено</div>n";
$_SESSION['i_step']++;
header("Location: index.php?$passgen&".SID);
exit;
if (isset($msg))
{
foreach ($msg as $key=>$value) {
echo "<div class='msg'>$value</div>n";
}
}
if (isset($err))
{
foreach ($err as $key=>$value) {
echo "<div class='err'>$value</div>n";
}
}
echo "<hr />n";
echo "<form method="get" action="index.php">n";
echo "<input name="step" value="".($_SESSION['i_step']+1)."" type="hidden" />n";
echo "<input value="".(isset($err)?'Чего - то не хватает':'Продолжить')."" type="submit"".(isset($err)?' disabled="disabled"':null)." />n";
echo "</form>n";
}
else
{
if (isset($err))
{
foreach ($err as $key=>$value) {
echo "<div class='err'>$value</div>n";
}
}
echo "<form method="post" action="index.php?$passgen">n";
echo "Хост:<br />n";
echo "<input name="host" value="$set[mysql_host]" type="text" /><br />n";
echo "Пользователь:<br />n";
echo "<input name="user" value="$set[mysql_user]" type="text" /><br />n";
echo "Пароль:<br />n";
echo "<input name="pass" value="$set[mysql_pass]" type="text" /><br />n";
echo "Имя базы:<br />n";
echo "<input name="db" value="$set[mysql_db_name]" type="text" /><br />n";
echo "<input value="Далее" type="submit" />n";
echo "</form>n";
}
echo "<hr />n";
echo "<b>Шаг: $_SESSION[i_step]</b> из <b>4</b>n";
?>