--- fenglin/bbs/preference_service.php 2025/04/08 01:58:33 1.2 +++ fenglin/bbs/preference_service.php 2025/04/08 09:27:26 1.3 @@ -92,27 +92,6 @@ $sign_2 = mysqli_real_escape_string($db_conn, $sign_2); $sign_3 = mysqli_real_escape_string($db_conn, $sign_3); - // Begin transaction - $rs = mysqli_query($db_conn, "SET autocommit=0"); - if ($rs == false) - { - $result_set["return"]["code"] = -2; - $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn); - - mysqli_close($db_conn); - exit(json_encode($result_set)); - } - - $rs = mysqli_query($db_conn, "BEGIN"); - if ($rs == false) - { - $result_set["return"]["code"] = -2; - $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn); - - mysqli_close($db_conn); - exit(json_encode($result_set)); - } - $sql = "UPDATE user_pubinfo SET user_timezone = '$user_tz', introduction = '$introduction', ". "photo = $photo, sign_1 = '$sign_1', sign_2 = '$sign_2', sign_3 = '$sign_3'". " WHERE UID=" . $_SESSION["BBS_uid"]; @@ -124,17 +103,6 @@ exit(); } - // Commit transaction - $rs = mysqli_query($db_conn, "COMMIT"); - if ($rs == false) - { - $result_set["return"]["code"] = -2; - $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn); - - mysqli_close($db_conn); - exit(json_encode($result_set)); - } - // Update user_tz in session data $_SESSION["BBS_user_tz"] = new DateTimeZone($user_tz);