--- fenglin/bbs/common_lib.inc.php	2025/04/01 04:17:10	1.4
+++ fenglin/bbs/common_lib.inc.php	2025/04/04 03:33:09	1.5
@@ -1,6 +1,6 @@
 <?
 //Log article operation into table bbs_article_log
-function article_op_log($aid,$uid,$op_type,$ip_addr,$db_conn=null)
+function article_op_log(int $aid, int $uid, string $op_type, string $ip_addr, mysqli $db_conn = null) : mysqli_result | bool
 {
 	/*
 		Type	Description
@@ -19,23 +19,27 @@ function article_op_log($aid,$uid,$op_ty
 		N		Unrecommend article
 		Z		Set article as trnasship
 	*/
-	$ret = mysql_query("insert into bbs_article_op(AID,UID,type,op_dt,op_ip)".
-		" values($aid,$uid,'$op_type',now(),'$ip_addr')",$db_conn);
-	
+
+	$sql = "INSERT INTO bbs_article_op(AID, UID, type, op_dt, op_ip)
+			VALUES($aid, $uid, '$op_type', NOW(), '$ip_addr')";
+
+	$ret = mysqli_query($db_conn, $sql);
+
 	return $ret;
 }
 
 //Add/Subtract user exp
-function user_exp_change($uid,$exp_change,$db_conn=null)
+function user_exp_change(int $uid, int $exp_change, mysqli $db_conn = null) : mysqli_result | bool
 {
-	$ret = mysql_query("update user_pubinfo set exp=exp+$exp_change".
-		" where UID=".$uid);
+	$sql = "UPDATE user_pubinfo SET exp = exp + $exp_change WHERE UID = $uid";
+
+	$ret = mysqli_query($db_conn, $sql);
 
 	return $ret;
 }
 
 //Display error message in a pop-up window
-function error_msg($msg,$back=false,$close=false)
+function error_msg($msg, $back=false, $close=false)
 {
 	$ret = "<script language=\"JavaScript\">\n".
 		"	alert(\"".str_replace("\n","\\\n",$msg)."\");\n".