ufik / WebCMS2

queries("BEGIN");}function

insert_into($h,$r){return

queries("INSERT INTO ".table($h).($r?" (".implode(", ",array_keys($r)).")\nVALUES (".implode(", ",$r).")":"DEFAULT VALUES"));}function

insert_update($h,$r,$Ma){global$g;$ra=array();$t=array();foreach($r

as$d=>$b){$ra[]="$d = $b";if(isset($Ma[idf_unescape($d)])){$t[]="$d = $b";}}return($t&&queries("UPDATE ".table($h)." SET ".implode(", ",$ra)." WHERE ".implode(" AND ",$t))&&$g->affected_rows)||queries("INSERT INTO ".table($h)." (".implode(", ",array_keys($r)).") VALUES (".implode(", ",$r).")");}function

last_id(){return

0;}function

explain($g,$i){return$g->query("EXPLAIN $i");}function

queries("BEGIN TRANSACTION");}function

insert_into($h,$r){return

queries("INSERT INTO ".table($h).($r?" (".implode(", ",array_keys($r)).")\nVALUES (".implode(", ",$r).")":"DEFAULT VALUES"));}function

insert_update($h,$r,$Ma){$ra=array();$t=array();foreach($r

as$d=>$b){$ra[]="$d = $b";if(isset($Ma[idf_unescape($d)])){$t[]="$d = $b";}}return

queries("MERGE ".table($h)." USING (VALUES(".implode(", ",$r).")) AS source (c".implode(", c",range(1,count($r))).") ON ".implode(" AND ",$t)." WHEN MATCHED THEN UPDATE SET ".implode(", ",$ra)." WHEN NOT MATCHED THEN INSERT (".implode(", ",array_keys($r)).") VALUES (".implode(", ",$r).");");}function

last_id(){global$g;return$g->result("SELECT SCOPE_IDENTITY()");}function

explain($g,$i){$g->query("SET SHOWPLAN_ALL ON");$c=$g->query($i);$g->query("SET SHOWPLAN_ALL OFF");return$c;}function