<?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 ) {
	$mysqli_access = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
 
	try
	{
		$mysqli_access = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
	}
	catch (mysqli_sql_exception $e)
	{
		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 = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");
	//mysqli_query($mysqli_access, "SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION'");
	// MariaDB seems to disable ONLY_FULL_GROUP_BY strict mode by default - needed for MySQL 8.0 and above...
	// HIGH_NOT_PRECEDENCE was part of MYSQL40 compat mode
	mysqli_query($mysqli_access, "SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION,HIGH_NOT_PRECEDENCE'");
	mysqli_set_charset($mysqli_access, "utf8");
    mysqli_query($mysqli_access, "SET NAMES UTF8;");
	return $mysqli_access;
}

// Error text of the last statement, for diagnostics in die() strings: "(errno) message".
function dberror() {
	global $dbconnect;
	if(!($dbconnect instanceof mysqli)) return "";
	return "(".$dbconnect->errno.") ".$dbconnect->error;
}

function dbquery($query) {
	global $debug, $headerSent, $dbconnect;
	if($debug && $headerSent) echo "<!-- $query -->\n";
	$result = NULL;
	try
	{
			$result = $dbconnect->query($query);
	}
	catch (mysqli_sql_exception $e)
	{
		if(function_exists('accessDenied')) {
			accessDenied(_FATALERROR . (isADMIN ? "Query: " . $query . "<br />Error: " . dberror() : ""));
		}
		else {
			// this is very rare case. Uncomment this if you really lost what is doing. This is before pagesetup.php, so Admin is not set
			//	echo "Query: " . $query . "<br />Error: " . dberror() "<br />" ;
			die(" <b>A fatal MySQL error was encountered.</b><br /> Check tableprefix. ");
		}

	}
	return $result;
}

function dbnumrows($query) {
	global $debug, $dbconnect;
	if ($query === false && $debug) {
		echo "<!-- dbnumrows ".($dbconnect ? $dbconnect->error : "")." -->\n";
	}
	return $query === false ? 0 : $query->num_rows;
}

function dbfetcharray($query) {
	global $debug, $dbconnect;
	if ($query === false && $debug) {
		echo "<!-- dbfetcharray ".($dbconnect ? $dbconnect->error : "")." -->\n";
	}
	return $query === false ? null : $query->fetch_array();
}

function dbassoc($query) {
	global $debug, $dbconnect;
	if ($query === false && $debug) {
		echo "<!-- dbassoc ".($dbconnect ? $dbconnect->error : "")." -->\n";
	}
	return $query === false ? null : $query->fetch_assoc();
}

function dbinsertid($tablename = 0) {
	global $dbconnect;
	return $dbconnect->insert_id;
}

function dbrow($query) {
	global $debug, $dbconnect;
	if ($query === false && $debug) {
		if($dbconnect->error) echo "<!-- dbrow ".($dbconnect ? $dbconnect->error : "")." -->\n";
	}
	return $query === false ? null : $query->fetch_row();
}

function dbclose() {
	global $dbconnect;
	if($dbconnect instanceof mysqli) $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

}
?>