--- lbbs/utils/lib/db_open.inc.php	2025/04/28 03:31:00	1.3
+++ lbbs/utils/lib/db_open.inc.php	2025/07/02 04:17:33	1.5
@@ -1,11 +1,42 @@
-<?
+<?php
 	include "../conf/db_conn.conf.php";
 
-	$db_conn_id=mysql_connect($DB_hostname, $DB_username, $DB_password)
-		or die("Could not connect database");
-	mysql_select_db($DB_database,$db_conn_id) or die("Invalid database");
-	mysql_query("SET CHARACTER SET gb2312", $db_conn_id);
-	mysql_query("SET NAMES 'gb2312'", $db_conn_id);
+	function db_open($sql_charset = "utf8")
+	{
+		global $DB_hostname, $DB_username, $DB_password, $DB_database, $DB_session_timezone;
 
-	return $db_conn_id;
-?>
+		mysqli_report(MYSQLI_REPORT_OFF);
+
+		$mysqli = @new mysqli($DB_hostname, $DB_username, $DB_password, $DB_database);
+
+		if ($mysqli->connect_errno)
+		{
+			echo ("Mysqli connection error: " . $mysqli->connect_error);
+			return NULL;
+		}
+
+		$mysqli->set_charset($sql_charset);
+		if ($mysqli->errno) {
+			echo ("Mysqli error: " . $mysqli->error . "\n");
+		}
+
+		if (isset($DB_session_timezone))
+		{
+			$mysqli->query("SET time_zone = '" . $DB_session_timezone . "'");
+			if ($mysqli->errno) {
+				echo ("Mysqli error: " . $mysqli->error . "\n");
+			}
+		}
+
+		return $mysqli;
+	}
+
+	if (!isset($db_conn))
+	{
+		$db_conn = db_open();
+
+		if ($db_conn == NULL)
+		{
+			exit();
+		}
+	}