"DESC"), $arFilter=Array()) { global $DB; $arSqlSearch = Array(); if(!is_array($arFilter)) $filter_keys = Array(); else $filter_keys = array_keys($arFilter); for($i=0; $iForSql($arFilter[$filter_keys[$i]]); if ($val == '') continue; $key = $filter_keys[$i]; if ($key[0]=="!") { $key = mb_substr($key, 1); $bInvert = true; } else $bInvert = false; switch(mb_strtoupper($key)) { case "NAME": $arSqlSearch[] = "CL.NAME ".($bInvert? "<>" : "=")." '".$val."'"; break; case "TYPE": $arSqlSearch[] = "CL.TYPE ".($bInvert? "<>" : "=")." '".$val."'"; break; } } $strSqlSearch = ""; for($i=0; $i$order) { $by = mb_strtoupper($by); $order = mb_strtoupper($order); if ($order!="ASC") $order = "DESC"; if ($by == "NAME") $arSqlOrder[] = " CL.NAME ".$order." "; elseif ($by == "TYPE") $arSqlOrder[] = " CL.TYPE ".$order." "; else { $arSqlOrder[] = " CL.LAST_USED ".$order." "; $by = "LAST_USED"; } } $strSqlOrder = ""; DelDuplicateSort($arSqlOrder); for ($i=0; $iQuery($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); return $db_res; } function Add($arFields) { global $DB; if ($arFields["TYPE"]!="E") $arFields["TYPE"] = "I"; $arInsert = $DB->PrepareInsert("b_catalog_load", $arFields); $strSql = "INSERT INTO b_catalog_load(".$arInsert[0].") ". "VALUES(".$arInsert[1].")"; $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__); return true; } function Delete($ID) { global $DB; return $DB->Query("DELETE FROM b_catalog_load WHERE NAME = '".intval($ID)."' ", true); } function SetLastUsed($NAME, $TYPE) { global $DB; $DB->Query( "UPDATE b_catalog_load SET ". " LAST_USED = 'N' ". "WHERE TYPE = '".$DB->ForSql($TYPE)."'"); $DB->Query( "UPDATE b_catalog_load SET ". " LAST_USED = 'Y' ". "WHERE NAME = '".$DB->ForSql($NAME)."' ". " AND TYPE = '".$DB->ForSql($TYPE)."'"); return true; } } ?>