Просмотр поста

$sql = '';
$set_karma = unserialize($set['karma']);
if ($user_id) {
    // Фиксируем местоположение авторизованных
    if (!core::$user_data['karma_off'] && $set_karma['on'] && core::$user_data['karma_time'] <= (time() - 86400)) {
        $sql .= " `karma_time` = '" . time() . "', ";
    }
    $movings = core::$user_data['movings'];
    if (core::$user_data['lastdate'] < (time() - 300)) {
        $movings = 0;
        $sql .= " `sestime` = '" . time() . "', ";
    }
    if (core::$user_data['place'] != $headmod) {
        ++$movings;
        $sql .= " `place` = '" . mysql_real_escape_string($headmod) . "', ";
    }
    if (core::$user_data['browser'] != $agn)
        $sql .= " `browser` = '" . mysql_real_escape_string($agn) . "', ";
    $totalonsite = core::$user_data['total_on_site'];
    if (core::$user_data['lastdate'] > (time() - 300))
        $totalonsite = $totalonsite + time() - core::$user_data['lastdate'];
    mysql_query("UPDATE `users` SET $sql
    `movings` = '$movings',
    `total_on_site` = '$totalonsite',
    `lastdate` = '" . time() . "'
    WHERE `id` = '$user_id'
");
} else {
    // Фиксируем местоположение гостей
    $movings = 0;
    $session = md5(core::$ip . core::$ip_via_proxy . core::$user_agent);
    $req = mysql_query("SELECT * FROM `cms_sessions` WHERE `session_id` = '$session' LIMIT 1");
    if (mysql_num_rows($req)) {
        // Если есть в базе, то обновляем данные
        $res = mysql_fetch_assoc($req);
        $movings = ++$res['movings'];
        if ($res['sestime'] < (time() - 300)) {
            $movings = 1;
            $sql .= " `sestime` = '" . time() . "', ";
        }
        if ($res['place'] != $headmod) {
            $sql .= " `place` = '" . mysql_real_escape_string($headmod) . "', ";
        }
        mysql_query("UPDATE `cms_sessions` SET $sql
        `movings` = '$movings',
        `lastdate` = '" . time() . "'
        WHERE `session_id` = '$session'
    ");
    } else {
        // Если еще небыло в базе, то добавляем запись
        mysql_query("INSERT INTO `cms_sessions` SET
        `session_id` = '" . $session . "',
        `ip` = '" . core::$ip . "',
        `ip_via_proxy` = '" . core::$ip_via_proxy . "',
        `browser` = '" . mysql_real_escape_string($agn) . "',
        `lastdate` = '" . time() . "',
        `sestime` = '" . time() . "',
        `place` = '" . mysql_real_escape_string($headmod) . "'
    ");
    }
}