--- fenglin/bbs/user_service_reg.php 2025/04/23 06:05:53 1.1 +++ fenglin/bbs/user_service_reg.php 2025/04/29 11:55:32 1.4 @@ -6,7 +6,7 @@ require_once "../lib/db_open.inc.php"; require_once "../lib/send_mail.inc.php"; require_once "./session_init.inc.php"; - require_once "./reg_check.inc.php"; + require_once "./user_reg_check.inc.php"; $data = json_decode(file_get_contents("php://input"), true); @@ -148,7 +148,7 @@ // Secure SQL statement $nickname = mysqli_real_escape_string($db_conn, $nickname); $realname = mysqli_real_escape_string($db_conn, $realname); - + // Begin transaction $rs = mysqli_query($db_conn, "SET autocommit=0"); if ($rs == false) @@ -159,7 +159,7 @@ mysqli_close($db_conn); exit(json_encode($result_set)); } - + $rs = mysqli_query($db_conn, "BEGIN"); if ($rs == false) { @@ -172,7 +172,7 @@ // Check availability of username and nickname $sql = "SELECT UID FROM user_list WHERE username = '$username' FOR UPDATE"; - + $rs = mysqli_query($db_conn, $sql); if ($rs == false) { @@ -214,9 +214,9 @@ )); } mysqli_free_result($rs); - + $sql = "SELECT UID FROM user_pubinfo WHERE email = '$email' FOR UPDATE"; - + $rs = mysqli_query($db_conn, $sql); if ($rs == false) { @@ -338,4 +338,3 @@ mysqli_close($db_conn); exit(json_encode($result_set)); -?>