<?php
// Some DB functions
if(!function_exists("dbconnect")) { // just in case. Some people seemed to be having an issue and this was the easiest fix.
function dbconnect($dbhost, $dbuser, $dbpass, $dbname ) {
$mysql_access = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if(mysqli_connect_error()) {
include(_BASEDIR."languages/en.php"); // Because we haven't got a language set yet.
die(_FATALERROR." "._NOTCONNECTED);
}
mysqli_query($mysql_access, "SET SESSION sql_mode = 'MYSQL40'");
mysqli_query($mysql_access, "SET NAMES UTF8;");
return $mysql_access;
}
function dbquery($query) {
global $debug, $headerSent, $dbconnect;
if($debug && $headerSent) echo "<!-- $query -->\n";
$result = $dbconnect->query($query) or accessDenied( _FATALERROR.(isADMIN ? "Query: ".$query."<br />Error: (".$dbconnect->mysqli_errno.") ".$dbconnect->mysqli_error : ""));
return $result;
}
function dbnumrows($query) {
global $debug, $dbconnect;
if ($query === false && $debug) {
echo "<!-- dbnumrows ".$dbconnect->mysqli_error." -->\n";
}
return $query->num_rows;
}
function dbassoc($query) {
global $debug, $dbconnect;
if ($query === false && $debug) {
echo "<!-- dbassoc ".$dbconnect->mysqli_error." -->\n";
}
return $query->fetch_assoc();
}
function dbinsertid($tablename = 0) {
global $dbconnect;
return $dbconnect->insert_id;
}
function dbrow($query) {
global $debug, $dbconnect;
if ($query === false && $debug) {
if($error) echo "<!-- dbrow ".$dbconnect->mysqli_error." -->\n";
}
return $query->fetch_row();
}
function dbclose() {
global $dbconnect;
$dbconnect->close();
}
// Used to escape text being put into the database.
function escapestring($str) {
global $dbconnect;
if (!is_array($str)) return $dbconnect->real_escape_string($str);
return array_map('escapestring', $str);
}
// End DB functions
}
?>