Файл: iwup.biz/stat/stat.php
Строк: 24
<?php
$dblocation = 'localhost';
$dbname = 'igrun108_stat'; // имя базы
$dbuser = 'igrun108_stat'; // имя пользователя
$dbpasswd = 'ut*!q[CT71v4'; // пароль
$dbcnx = mysql_connect($dblocation, $dbuser, $dbpasswd);
if(!$dbcnx)
die(mysql_error());
mysql_select_db($dbname, $dbcnx);
mysql_unbuffered_query("SET `character_set_client` = 'utf8';");
mysql_unbuffered_query("SET `character_set_results` = 'utf8';");
mysql_unbuffered_query("SET `collation_connection` = 'utf8_general_ci';");
$ip = $_SERVER['REMOTE_ADDR'];
$ua = mysql_real_escape_string(trim($_SERVER['HTTP_USER_AGENT']));
if(mysql_num_rows(mysql_query("SELECT * FROM `logs` WHERE `ip` = '{$ip}' and `ua` = '{$ua}' LIMIT 1")))
{
mysql_query("UPDATE `stat` SET `hits` = `hits`+1") or die(mysql_error());
}
else
{
mysql_query("UPDATE `stat` SET `hosts` = `hosts`+1, `hits` = `hits`+1") or die(mysql_error());
mysql_query("INSERT INTO `logs` VALUES ('{$ip}', '{$ua}')") or die(mysql_error());
}
$stat = mysql_fetch_array(mysql_query("SELECT * FROM `stat`"));
?>