--- fenglin/bbs/post_service.php	2025/04/07 08:39:42	1.6
+++ fenglin/bbs/post_service.php	2025/04/16 01:51:52	1.9
@@ -1,11 +1,11 @@
 <?
 	require_once "../lib/common.inc.php";
 	require_once "../lib/db_open.inc.php";
+	require_once "../lib/lml.inc.php";
+	require_once "../lib/str_process.inc.php";
 	require_once "./common_lib.inc.php";
 	require_once "./session_init.inc.php";
-	require_once "../lib/lml.inc.php";
 	require_once "./check_sub.inc.php";
-	require_once "../lib/str_process.inc.php";
 
 	force_login();
 
@@ -221,7 +221,7 @@
 		}
 		else // Reply article
 		{
-			$sql = "SELECT TID, SID, title, `lock` FROM bbs WHERE AID = $reply_id AND visible";
+			$sql = "SELECT TID, SID, title, `lock` FROM bbs WHERE AID = $reply_id AND visible FOR UPDATE";
 			
 			$rs = mysqli_query($db_conn, $sql);
 			if ($rs == false)
@@ -255,7 +255,7 @@
 
 			if ($tid != 0) // Article to be replied is not the head of topic thread
 			{
-				$sql = "SELECT SID, title, `lock` FROM bbs WHERE AID = $tid AND visible";
+				$sql = "SELECT SID, title, `lock` FROM bbs WHERE AID = $tid AND visible FOR UPDATE";
 
 				$rs = mysqli_query($db_conn, $sql);
 				if ($rs == false)
@@ -320,7 +320,7 @@
 				$result_set["return"]["code"] = -1;
 				array_push($result_set["return"]["errorFields"], array(
 					"id" => "prompt",
-					"errMsg" => "本版连续发表主题数量达到上限",
+					"errMsg" => "本版连续发表文章数量达到上限",
 				));
 		
 				mysqli_close($db_conn);
@@ -348,7 +348,7 @@
 	}
 	else // Modify article
 	{
-		$sql = "SELECT TID, UID, SID, excerption FROM bbs WHERE AID = $id AND visible";
+		$sql = "SELECT TID, UID, SID, excerption FROM bbs WHERE AID = $id AND visible FOR UPDATE";
 
 		$rs = mysqli_query($db_conn, $sql);
 		if ($rs == false)
@@ -622,7 +622,7 @@
 		if ($reply_id > 0)
 		{
 			$sql = "UPDATE bbs SET reply_count = reply_count + 1,
-					last_reply_dt = now(), last_reply_UID=" . $_SESSION["BBS_uid"] .
+					last_reply_dt = NOW(), last_reply_UID=" . $_SESSION["BBS_uid"] .
 					", last_reply_username = '" . $_SESSION["BBS_username"] .
 					"', last_reply_nickname = '$nickname' WHERE Aid = $tid";