public static function Delete($ID)
{
global $DB;
$ID = IntVal($ID);
$arTrackback = CBlogTrackback::GetByID($ID);
if ($arTrackback) {
CBlogPost::Update($arTrackback["POST_ID"], array("=NUM_TRACKBACKS" => "NUM_TRACKBACKS - 1"));
}
unset($GLOBALS["BLOG_TRACKBACK"]["BLOG_TRACKBACK_CACHE_" . $ID]);
return $DB->Query("DELETE FROM b_blog_trackback WHERE ID = " . $ID . "", true);
}
function Add($arFields)
{
global $DB;
$arFields1 = array();
foreach ($arFields as $key => $value)
{
if (substr($key, 0, 1) == "=")
{
$arFields1[substr($key, 1)] = $value;
unset($arFields[$key]);
}
}
if (!CBlogTrackback::CheckFields("ADD", $arFields))
return false;
$arInsert = $DB->PrepareInsert("b_blog_trackback", $arFields);
foreach ($arFields1 as $key => $value)
{
if (strlen($arInsert[0]) > 0)
$arInsert[0] .= ", ";
$arInsert[0] .= $key;
if (strlen($arInsert[1]) > 0)
$arInsert[1] .= ", ";
$arInsert[1] .= $value;
}
$ID = False;
if (strlen($arInsert[0]) > 0)
{
$strSql =
"INSERT INTO b_blog_trackback(".$arInsert[0].") ".
"VALUES(".$arInsert[1].")";
$DB->Query($strSql, False, "File: ".__FILE__."<br>Line: ".__LINE__);
$ID = IntVal($DB->LastID());
}
if ($ID)
{
$arTrackback = CBlogTrackback::GetByID($ID);
CBlogPost::Update($arTrackback["POST_ID"], array("=NUM_TRACKBACKS" => "NUM_TRACKBACKS + 1"));
}
return $ID;
}
function Add($arFields)
{
global $DB;
$arFields1 = array();
foreach ($arFields as $key => $value) {
if (substr($key, 0, 1) == "=") {
$arFields1[substr($key, 1)] = $value;
unset($arFields[$key]);
}
}
if (!CBlogTrackback::CheckFields("ADD", $arFields)) {
return false;
}
$arInsert = $DB->PrepareInsert("b_blog_trackback", $arFields);
foreach ($arFields1 as $key => $value) {
if (strlen($arInsert[0]) > 0) {
$arInsert[0] .= ", ";
}
$arInsert[0] .= $key;
if (strlen($arInsert[1]) > 0) {
$arInsert[1] .= ", ";
}
$arInsert[1] .= $value;
}
$ID = False;
if (strlen($arInsert[0]) > 0) {
$ID = IntVal($DB->NextID("SQ_B_BLOG_TRACKBACK"));
$strSql = "INSERT INTO b_blog_trackback(ID, " . $arInsert[0] . ") " . "VALUES(" . $ID . ", " . $arInsert[1] . ")";
$arBinds = array();
if (is_set($arFields, "PREVIEW_TEXT")) {
$arBinds["PREVIEW_TEXT"] = $arFields["PREVIEW_TEXT"];
}
$DB->QueryBind($strSql, $arBinds);
}
if ($ID) {
$arTrackback = CBlogTrackback::GetByID($ID);
CBlogPost::Update($arTrackback["POST_ID"], array("=NUM_TRACKBACKS" => "NUM_TRACKBACKS + 1"));
}
return $ID;
}
