- Модуль: socialnetwork
- Путь к файлу: ~/bitrix/modules/socialnetwork/classes/general/log_follow.php
- Класс: CSocNetLogFollow
- Вызов: CSocNetLogFollow::DeleteByLogID
static function DeleteByLogID($log_id, $type = false, $bUseSmartLogic = false)
{
global $DB;
if (intval($log_id) <= 0)
{
return false;
}
if (
$type == "Y"
&& $bUseSmartLogic
)
{
$default_follow = COption::GetOptionString("socialnetwork", "follow_default_type", "Y");
if ($default_follow == "N")
{
$arUserID = array();
$strSQL = "SELECT
USER_ID FROM b_sonet_log_follow
WHERE
CODE = '**'
AND TYPE='Y'
";
$dbRes = $DB->Query($strSQL, false, "File: ".__FILE__."
Line: ".__LINE__);
while ($arRes = $dbRes->Fetch())
{
$arUserID[] = $arRes["USER_ID"];
}
if (count($arUserID) > 0)
{
$strSQL = "DELETE FROM b_sonet_log_follow
WHERE
TYPE = 'Y'
AND CODE = 'L".$log_id."'
AND USER_ID IN (".implode(", ", $arUserID).")
";
$DB->Query($strSQL, false, "FILE: ".__FILE__."
LINE: ".__LINE__);
}
$strSQL = "UPDATE b_sonet_log_follow
SET b_sonet_log_follow.FOLLOW_DATE = NULL
WHERE
TYPE = 'Y'
AND CODE = 'L".$log_id."'
";
if ($DB->Query($strSQL, false, "FILE: ".__FILE__."
LINE: ".__LINE__))
{
return true;
}
else
{
return false;
}
}
else
{
$arUserID = array();
$strSQL = "SELECT
USER_ID FROM b_sonet_log_follow
WHERE
CODE = '**'
AND TYPE='N'
";
$dbRes = $DB->Query($strSQL, false, "File: ".__FILE__."
Line: ".__LINE__);
while ($arRes = $dbRes->Fetch())
$arUserID[] = $arRes["USER_ID"];
if (count($arUserID) > 0)
{
$strSQL = "UPDATE b_sonet_log_follow
SET b_sonet_log_follow.FOLLOW_DATE = NULL
WHERE
TYPE = 'Y'
AND CODE = 'L".$log_id."'
AND USER_ID IN (".implode(", ", $arUserID).")
";
$DB->Query($strSQL, false, "FILE: ".__FILE__."
LINE: ".__LINE__);
}
$strSQL = "DELETE FROM b_sonet_log_follow
WHERE
TYPE = 'Y'
AND CODE = 'L".$log_id."'";
if (count($arUserID) > 0)
$strSQL .= " AND USER_ID NOT IN (".implode(", ", $arUserID).")";
if ($DB->Query($strSQL, false, "FILE: ".__FILE__."
LINE: ".__LINE__))
return true;
else
return false;
}
}
else
{
$strSQL = "DELETE FROM b_sonet_log_follow WHERE CODE = 'L".$log_id."'";
if ($DB->Query($strSQL, false, "FILE: ".__FILE__."
LINE: ".__LINE__))
return true;
else
return false;
}
}