<html>
<head>
<title>Блок Он-Лайн, версия 2.3 - Выполнение SQL запросов (Установка)</title>
<meta http-equiv="content-type" content="text/html; charset=windows-1251">
<style type="text/css">
html,body{
height:100%;
background: #FFFFFF;
font-size: 11px;
font-family: tahoma;
color:#676767;
}
table{
border:0px;
border-collapse:collapse;
}
a {
text-decoration: underline;
font-size: 11px;
font-family: tahoma;
color:#4494c3;
}
table td{
padding:0px;
font-size: 11px;
font-family: tahoma;
color:#676767;
}
.title, .title a{
color: #ffffff;
font-size: 12px;
font-family: Arial;
text-transform:uppercase;
font-weight:bold;
text-decoration:none;
}
.info, .info a{
font-size: 10px;
font-family: tahoma;
text-decoration:none;
}
select {
font-size: 11px;
font-family: tahoma;
}
form {
PADDING-RIGHT: 0px;
PADDING-LEFT: 0px;
PADDING-BOTTOM: 0px;
MARGIN: 0px;
PADDING-TOP: 0px;
}
</style>
</head>
<body leftmargin="0" topmargin="0" marginheight="0" marginwidth="0">
<?PHP
error_reporting(7);
ini_set('display_errors', true);
ini_set('html_errors', false);
define('DATALIFEENGINE', true);
define('ROOT_DIR', dirname (__FILE__));
define('ENGINE_DIR', ROOT_DIR.'/engine');
require_once(ENGINE_DIR.'/classes/mysql.php');
require_once(ENGINE_DIR.'/data/dbconfig.php');
$config['charset'] = "windows-1251";
$db_charset = "cp1251";
$db_collate = "cp1251_general_ci";
$tableSchema = array();
// Если таблица найдена, то удаляем таблицу из БД
$tableSchema[] = "DROP TABLE IF EXISTS `" . PREFIX . "_online`";
// Создаём таблицу
$tableSchema[] = "
CREATE TABLE `" . PREFIX . "_online` (
`uid` int(10) unsigned NOT NULL default '0',
`session` char(32) NOT NULL,
`lastdate` int(10) unsigned NOT NULL default '0',
`location` varchar(255) NOT NULL,
`useragent` char(100) NOT NULL,
`ip` char(15) default NULL,
`proxy` char(15) default NULL,
PRIMARY KEY (`session`),
KEY `idx` (`uid`)
) TYPE=MyISAM /*!40101 DEFAULT CHARACTER SET {$db_charset} COLLATE {$db_collate} */";
$tableSchema[] = "ALTER TABLE `" . PREFIX . "_users`
ADD `country` VARCHAR( 50 ) NOT NULL AFTER `land` ,
ADD `city` VARCHAR( 50 ) NOT NULL AFTER `country`,
ADD `useragent` CHAR( 100 ) NOT NULL AFTER `hash`,
ADD `logged_proxy` CHAR( 15 ) NOT NULL AFTER `logged_ip`,
ADD `location` VARCHAR( 255 ) NOT NULL";
if(!$db = @mysql_connect(DBHOST, DBUSER, DBPASS))
die('<font size=+1>An Error Occurred</font><hr>Unable to connect to the database. <BR>Check dbhost, dbhost, and dbpass in dbconfig.php.');
if(!@mysql_select_db(DBNAME,$db))
die("<font size=+1>An Error Occurred</font><hr>Unable to find the database <b>$dbname</b> on your MySQL server.");
foreach($tableSchema as $table) {
$result = mysql_query($table) or die("Error:<b> ". mysql_error()." </b>in file <b>".__FILE__."</b> on line <b>".__LINE__);
}
echo<<<HTML
<div style="padding:40px; text-align:center;">Выполнение SQL запросов было успешно завершено.<br />Удалите файл
HTML;
echo __FILE__;
?>
</div>
</body>
</html>
/www/install.php on line 118
