';
$sql = '';
$set_karma = unserialize($set['karma']);
if ($user_id) {
// Фиксируем местоположение авторизованных
if (!$datauser['karma_off'] && $set_karma['on'] && $datauser['karma_time'] <= ($realtime - 86400)) {
$sql = "`karma_time` = '$realtime', ";
}
$movings = $datauser['movings'];
if ($datauser['lastdate'] < ($realtime - 300)) {
$movings = 0;
$sql .= "`sestime` = '$realtime',";
}
if ($datauser['place'] != $headmod) {
$movings = $movings + 1;
$sql .= "`movings` = '$movings', `place` = '$headmod',";
}
if ($datauser['browser'] != $agn)
$sql .= "`browser` = '" . mysql_real_escape_string($agn) . "',";
$totalonsite = $datauser['total_on_site'];
if ($datauser['lastdate'] > ($realtime - 300))
$totalonsite = $totalonsite + $realtime - $datauser['lastdate'];
mysql_query("UPDATE `users` SET $sql
`total_on_site` = '$totalonsite',
`lastdate` = '$realtime'
WHERE `id` = '$user_id'
");
} else {
// Фиксируем местоположение гостей
$sid = md5($ip . $agn);
$movings = 0;
$req = mysql_query("SELECT * FROM `cms_guests` WHERE `session_id` = '$sid' LIMIT 1");
if (mysql_num_rows($req)) {
// Если есть в базе, то обновляем данные
$res = mysql_fetch_assoc($req);
$movings = $res['movings'];
if ($res['sestime'] < ($realtime - 300)) {
$movings = 0;
$sql .= "`sestime` = '$realtime',";
}
if ($res['ip'] != $ip)
$sql .= "`ip` = '$ip',";
if ($res['browser'] != $agn)
$sql .= "`browser` = '" . mysql_real_escape_string($agn) . "',";
if ($res['place'] != $headmod) {
$movings = $movings + 1;
$sql .= "`movings` = '$movings', `place` = '$headmod',";
}
mysql_query("UPDATE `cms_guests` SET $sql
`lastdate` = '$realtime'
WHERE `session_id` = '$sid'");
} else {
// Если еще небыло в базе, то добавляем запись
mysql_query("INSERT INTO `cms_guests` SET
`session_id` = '$sid',
`ip` = '$ip',
`browser` = '" . mysql_real_escape_string($agn) . "',
`lastdate` = '$realtime',
`sestime` = '$realtime',
`place` = '$headmod'
");
}
}
/*
-----------------------------------------------------------------
Выводим сообщение о Бане
-----------------------------------------------------------------
*/
if (!empty($ban))
echo '
';
/*
-----------------------------------------------------------------
Ссылки на непрочитанное
-----------------------------------------------------------------
*/
if ($user_id) {
$list = array ();
if ($headmod != "pradd") {
$new_mail = mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `user` = '$user_id' AND `type` = 'in' AND `read` = 'no'"), 0);
if ($new_mail)
$list[] = '
Сообщение(' . $new_mail . ')';
}
if ($headmod != "pradd") {
$new_mail = mysql_result(mysql_query("SELECT COUNT(*) FROM `privat` WHERE `user` = '$login' AND `type` = 'in' AND `chit` = 'no'"), 0);
if ($new_mail)
$list[] = '
Сообщ. от Системы(' . $new_mail . ')';
}
if ($datauser['comm_count'] > $datauser['comm_old']) {
$list[] = '
' . $lng['guestbook'] . ' (' . ($datauser['comm_count'] - $datauser['comm_old']) . ')';
}
if(!empty($list))
echo '';
}
if ($user_id) {
if ($count = questions::count_user_addressee_and_no_answered($user_id)) {
echo '';
}
}
