ufik / WebCMS2

q($b);}function

explain($g,$i){$g->query("EXPLAIN PLAN FOR $i");return$g->query("SELECT * FROM plan_table");}function

alter_table($h,$f,$p,$Oa,$Ca,$wb,$U,$Va,$zb){$v=$Ha=array();foreach($p

as$e){$b=$e[1];if($b&&$e[0]!=""&&idf_escape($e[0])!=$b[0]){queries("ALTER TABLE ".table($h)." RENAME COLUMN ".idf_escape($e[0])." TO $b[0]");}if($b){$v[]=($h!=""?($e[0]!=""?"MODIFY (":"ADD ("):"  ").implode($b).($h!=""?")":"");}else{$Ha[]=idf_escape($e[0]);}}if($h==""){return

queries("CREATE TABLE ".table($f)." (\n".implode(",\n",$v)."\n)");}return(!$v||queries("ALTER TABLE ".table($h)."\n".implode("\n",$v)))&&(!$Ha||queries("ALTER TABLE ".table($h)." DROP (".implode(", ",$Ha).")"))&&($h==$f||queries("ALTER TABLE ".table($h)." RENAME TO ".table($f)));}function

foreign_keys($h){return

array();}function

truncate_tables($D){return

true;}function

auto_increment(){return" IDENTITY".($_POST["Auto_increment"]!=""?"(".(+$_POST["Auto_increment"]).",1)":"")." PRIMARY KEY";}function

alter_table($h,$f,$p,$Oa,$Ca,$wb,$U,$Va,$zb){$v=array();foreach($p

as$e){$C=idf_escape($e[0]);$b=$e[1];if(!$b){$v["DROP"][]=" COLUMN $C";}else{$b[1]=preg_replace("~( COLLATE )'(\\w+)'~","\\1\\2",$b[1]);if($e[0]==""){$v["ADD"][]="\n  ".implode("",$b).($h==""?substr($Oa[$b[0]],16+strlen($b[0])):"");}else{unset($b[6]);if($C!=$b[0]){queries("EXEC sp_rename ".q(table($h).".$C").", ".q(idf_unescape($b[0])).", 'COLUMN'");}$v["ALTER COLUMN ".implode("",$b)][]="";}}}if($h==""){return

queries("CREATE TABLE ".table($f)." (".implode(",",(array)$v["ADD"])."\n)");}if($h!=$f){queries("EXEC sp_rename ".q(table($h)).", ".q($f));}if($Oa){$v[""]=$Oa;}foreach($v

as$d=>$b){if(!queries("ALTER TABLE ".idf_escape($f)." $d".implode(",",$b))){return

false;}}return

true;}function

false;}function

auto_increment(){$Hd=" PRIMARY KEY";if($_GET["create"]!=""&&$_POST["auto_increment_col"]){foreach(indexes($_GET["create"])as$w){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$w["columns"],true)){$Hd="";break;}if($w["type"]=="PRIMARY"){$Hd=" UNIQUE";}}}return" AUTO_INCREMENT$Hd";}function

alter_table($h,$f,$p,$Oa,$Ca,$wb,$U,$Va,$zb){$v=array();foreach($p

as$e){$v[]=($e[1]?($h!=""?($e[0]!=""?"CHANGE ".idf_escape($e[0]):"ADD"):" ")." ".implode($e[1]).($h!=""?" $e[2]":""):"DROP ".idf_escape($e[0]));}$v=array_merge($v,$Oa);$Yb="COMMENT=".q($Ca).($wb?" ENGINE=".q($wb):"").($U?" COLLATE ".q($U):"").($Va!=""?" AUTO_INCREMENT=$Va":"").$zb;if($h==""){return

queries("CREATE TABLE ".table($f)." (\n".implode(",\n",$v)."\n) $Yb");}if($h!=$f){$v[]="RENAME TO ".table($f);}$v[]=$Yb;return

queries("ALTER TABLE ".table($h)."\n".implode(",\n",$v));}function

alter_indexes($h,$v){foreach($v

as$d=>$b){$v[$d]=($b[2]=="DROP"?"\nDROP INDEX ".idf_escape($b[1]):"\nADD $b[0] ".($b[0]=="PRIMARY"?"KEY ":"").($b[1]!=""?idf_escape($b[1])." ":"").$b[2]);}return