function Add($arFields) { global $DB; if (!CForumSmile::CheckFields("ADD", $arFields)) { return false; } if (CACHED_b_forum_smile !== false) { $GLOBALS["CACHE_MANAGER"]->CleanDir("b_forum_smile"); } $arInsert = $DB->PrepareInsert("b_forum_smile", $arFields); $strSql = "INSERT INTO b_forum_smile(" . $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_smile_lang", $arFields["LANG"][$i]); $strSql = "INSERT INTO b_forum_smile_lang(SMILE_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 (!CForumSmile::CheckFields("UPDATE", $arFields)) { return false; } if (CACHED_b_forum_smile !== false) { $GLOBALS["CACHE_MANAGER"]->CleanDir("b_forum_smile"); } $strUpdate = $DB->PrepareUpdate("b_forum_smile", $arFields); if (!empty($strUpdate)) { $strSql = "UPDATE b_forum_smile SET " . $strUpdate . " WHERE ID = " . $ID; $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__); } if (!empty($arFields["LANG"])) { $DB->Query("DELETE FROM b_forum_smile_lang WHERE SMILE_ID = " . $ID, false, "File: " . __FILE__ . "<br>Line: " . __LINE__); foreach ($arFields["LANG"] as $i => $val) { $arInsert = $DB->PrepareInsert("b_forum_smile_lang", $arFields["LANG"][$i]); $strSql = "INSERT INTO b_forum_smile_lang(SMILE_ID, " . $arInsert[0] . ") VALUES(" . $ID . ", " . $arInsert[1] . ")"; $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__); } } return $ID; }