.
*/
$MySQLconn = mysql_pconnect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS); # persistent Db connection
mysql_select_db(MYSQL_DB, $MySQLconn);
$MySQLconn2 = mysql_pconnect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS); # persistent Db connection
mysql_select_db(MYSQL_DB, $MySQLconn2);
function doquery($query, $backup=true) {
global $MySQLconn, $MySQLconn2;
global $setup;
switch( strtoupper(substr($query, 0, 6)) ) {
case "SELECT":
// SELECT ... FROM `table` ...
$type="SELECT";
break;
case "INSERT":
// INSERT INTO `table` ...
$type="INSERT";
break;
case "UPDATE":
// UPDATE `table` SET ...
$type="UPDATE";
break;
default:
$type="";
$table="";
}
$res = mysql_query($query,$MySQLconn);
if(!$res) {
@debug("MySQL query [".nl2br($query)."] failed: ".mysql_error());
echo "
Error while communicating with the database.\n";
}elseif( (preg_match("/(select|describe)/i", $query)==0) AND (preg_match("/mailout/i", $query)==0) AND (preg_match("/querylog/i", $query)==0) AND $backup ) {
// Updating query
if( !DEVELOPMENTVERSION ) {
$query = "INSERT INTO `querylog` (`date`, `sid`, `user`, `query`)
VALUES ('".date("Y-m-d H:i:s")."', ".addslashes($_SESSION['sess_uid']).", '".addslashes($_SESSION['sess_name'])."', '".addslashes($query)."')";
if( !mysql_query($query, $MySQLconn2) ) {
debug("Failed logging query");
}
}
}
return $res;
}
function getaffected() {
global $MySQLconn;
return mysql_affected_rows($MySQLconn);
}
function getinsertid() {
global $MySQLconn;
return mysql_insert_id($MySQLconn);
}
?>