public static function Add($arFields)
{
global $DB;
if (!CForumRank::CheckFields("ADD", $arFields)) {
return false;
}
$arInsert = $DB->PrepareInsert("b_forum_rank", $arFields);
$strSql = "INSERT INTO b_forum_rank(" . $arInsert[0] . ") VALUES(" . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
$ID = intVal($DB->LastID());
foreach ($arFields["LANG"] as $i => $val) {
$arInsert = $DB->PrepareInsert("b_forum_rank_lang", $arFields["LANG"][$i]);
$strSql = "INSERT INTO b_forum_rank_lang(RANK_ID, " . $arInsert[0] . ") VALUES(" . $ID . ", " . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
}
return $ID;
}
public static function Update($ID, $arFields)
{
global $DB;
$ID = intVal($ID);
if ($ID <= 0) {
return False;
}
if (!CForumRank::CheckFields("UPDATE", $arFields)) {
return false;
}
$strUpdate = $DB->PrepareUpdate("b_forum_rank", $arFields);
$strSql = "UPDATE b_forum_rank SET " . $strUpdate . " WHERE ID = " . $ID;
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
if (is_set($arFields, "LANG")) {
$DB->Query("DELETE FROM b_forum_rank_lang WHERE RANK_ID = " . $ID, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
foreach ($arFields["LANG"] as $i => $val) {
$arInsert = $DB->PrepareInsert("b_forum_rank_lang", $arFields["LANG"][$i]);
$strSql = "INSERT INTO b_forum_rank_lang(RANK_ID, " . $arInsert[0] . ") VALUES(" . $ID . ", " . $arInsert[1] . ")";
$DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
}
}
return $ID;
}
