- Модуль: socialnetwork
- Путь к файлу: ~/bitrix/modules/socialnetwork/classes/mysql/log_counter.php
- Класс: CSocNetLogCounter
- Вызов: CSocNetLogCounter::ClearByUser
function ClearByUser($user_id, $site_id = SITE_ID, $code = "**", $page_size = 0, $page_last_date_1 = "")
{
global $DB;
$user_id = intval($user_id);
if ($user_id <= 0)
return false;
$strSQL = "
INSERT INTO b_sonet_log_counter (USER_ID, SITE_ID, CODE, CNT, LAST_DATE, PAGE_SIZE, PAGE_LAST_DATE_1)
VALUES ($user_id, '".$DB->ForSQL($site_id)."', '".$DB->ForSQL($code)."', 0, ".$DB->CurrentTimeFunction().", ".(intval($page_size) > 0 ? $page_size : "NULL").", ".($page_last_date_1 <> '' ? $DB->CharToDateFunction($page_last_date_1) : "NULL").")
ON DUPLICATE KEY UPDATE CNT = 0, LAST_DATE = ".$DB->CurrentTimeFunction().(intval($page_size) > 0 ? ", PAGE_SIZE = ".$page_size : "").($page_last_date_1 <> '' ? ", PAGE_LAST_DATE_1 = ".$DB->CharToDateFunction($page_last_date_1) : "")."
";
$res = $DB->Query($strSQL, false, "FILE: ".__FILE__."
LINE: ".__LINE__);
$strSQL = "DELETE FROM b_sonet_log_counter WHERE USER_ID = ".$user_id." AND CODE = '".$code."' AND SITE_ID = '**'";
$res = $DB->Query($strSQL, false, "FILE: ".__FILE__."
LINE: ".__LINE__);
}