".mysql_errno().": ".mysql_error());
$time2 = microtime();
$qtime = db_query_time($time1,$time2);
if ($qtime>5) {
$fh=fopen($GLOBALS['opt_dir']."/temp/mysql.res","a");
flock($fh,LOCK_EX);
fputs($fh,"QUERY: ".$query."\nAction: ".$GLOBALS['action'].", Module: ".$GLOBALS['module'].", Time: ".date("r",time())."\nExec time: $qtime\n\n");
fclose($fh);
}
if ($GLOBALS['common']) $GLOBALS['query_time']+=$qtime;
return $tmpres;
}
function db_test() {
$link=$GLOBALS['link'];
$sql = "CREATE TABLE IbXpTeSt (test1 INT NOT NULL, test2 CHAR(8))";
$res = db_query($sql,$link);
$sql = "ALTER TABLE IbXpTeSt ADD PRIMARY KEY (test1)";
$res = db_query($sql,$link);
$sql = "INSERT INTO IbXpTeSt SET test1=20, test2=\"fuck you\"";
$res = db_query($sql,$link);
$sql = "UPDATE IbXpTeSt SET test1=30 WHERE test1=20";
$res = db_query($sql,$link);
$sql = "SELECT * FROM IbXpTeSt";
$res = db_query($sql,$link);
db_free_result($res);
$sql = "DROP TABLE IbXpTeSt";
$res = db_query($sql,$link);
}
function db_explain($sql) {
$link=$GLOBALS['link'];
$pos=strpos(strtoupper($sql),"SELECT");
if ($pos!==false) {
$sql = substr($sql,$pos);
$sql2 = "EXPLAIN $sql";
$res2 = mysql_query($sql2,$link);
echo "";
for ($i=0; $i".mysql_field_name($res2,$i)."";
echo "
";
while ($row=mysql_fetch_row($res2)) {
echo "";
foreach ($row as $column) echo "| $column | ";
echo "
";
}
echo "
";
mysql_free_result($res2);
}
}
function db_backup($filename,$mode="f") {
$link=$GLOBALS['link'];
$open=$mode."open";
$write=$mode."write";
$close=$mode."close";
$fh=call_user_func($open,$filename,"wb");
$output = "-- ---------------------------------------------\n";
$output.= "-- \n";
$output.= "-- Dump of database ".$GLOBALS['DBname']." from forum \"".$GLOBALS['opt_title']."\"\n";
$output.= "-- Time of dump: ".date("l, d F Y G:i:s")."\n";
$output.= "-- \n";
$output.= "-- ---------------------------------------------\n\n";
$tablequery = mysql_list_tables($GLOBALS['DBname']);
if (!$tablequery) { error(MSG_e_dump_tables); }
while ($table=mysql_fetch_row($tablequery)) {
$blobs[$table[0]]=array();
$fieldsquery = mysql_query("SHOW FIELDS FROM $table[0];",$link);
$output .="\n\n-- Table $table[0]\n\nDROP TABLE IF EXISTS $table[0];\n\n" ;
$output .= "CREATE TABLE $table[0] (\n";
$count=0;
while ($row = mysql_fetch_array($fieldsquery)) {
if ($count>0) $output.= ",\n";
$output .= " ".$row["Field"];
$output .= " ".$row["Type"];
if (is_numeric($row["Default"])) $output .= " DEFAULT ".$row["Default"];
elseif ($row["Default"]!="") $output .= " DEFAULT '".addslashes($row["Default"])."'";
if ($row["Null"]!="YES") { $output .= " NOT NULL "; }
if ($row["Extra"]) { $output .= " ".$row["Extra"]; }
if (strpos(strtoupper($row["Type"]),"BLOB")!==false) $blobs[$table[0]][$count]=1;
$count++;
}
$keys=array();
$querykeys=mysql_query("SHOW KEYS FROM ".$table[0]);
$num_keys=mysql_num_rows($querykeys);
if ($num_rows>0) { $output.= ","; }
$primary=0;
for($i=0; $i<$num_keys; $i++){
$row = mysql_fetch_array($querykeys);
if (!$keys[$row["Key_name"]]) { $keys[$row["Key_name"]]=$row["Column_name"]; }
else { $keys[$row["Key_name"]].=",".$row["Column_name"]; }
if ($row['Non_unique']==0) $keytype[$row["Key_name"]]="UNIQUE ";
if ($row['Index_type']=="FULLTEXT") $keytype[$row["Key_name"]]="FULLTEXT ";
}
foreach ($keys as $curkey=>$curcolumns) {
if ($curkey=="PRIMARY") {
$output .= ",\n PRIMARY KEY ($curcolumns)";
}
else {
$output .= ",\n ".$keytype[$curkey]."INDEX $curkey ($curcolumns)";
}
}
$output.="\n);";
}
$output.="\n";
call_user_func($write,$fh,$output);
$tablequery = mysql_list_tables($GLOBALS['DBname']);
if (!$tablequery) error(MSG_e_dump_tables);
while ($table=mysql_fetch_row($tablequery)) {
$output .= "\n\n-- Table ".$table[0]." data:\n";
$query = mysql_query("SELECT * FROM $table[0]");
$count = mysql_num_fields($query);
while ($row=mysql_fetch_row($query)) {
unset($output);
$output .= "INSERT INTO $table[0] VALUES (";
for ($i=0; $i<$count; $i++) {
if (isset($row[$i])) {
if ($blobs[$table[0]][$i]==1) {
$output .= "0x";
$len=strlen($row[$i]);
for ($j=0; $j<$len; $j++) $output.=dechex(ord($row[$i][$j]));
}
else {
$row[$i]=str_replace("\n","\\n",mysql_real_escape_string($row[$i]));
$output .= "\"".$row[$i]."\"";
}
} // WARNING!!!
else $output .= "NULL";
if ($i<($count-1)) { $output .= ","; }
}
$output .= ");\n";
call_user_func($write,$fh,$output);
}
}
call_user_func($close,$fh);
}
function db_query_time($start,$stop) {
list($startusec,$startsec) = explode(" ",$start);
list($stopusec,$stopsec) = explode(" ",$stop);
return ($stopsec-$startsec)+($stopusec-$startusec);
}
function db_slashes($string) {
return mysql_escape_string($string);
}
?>