--- fenglin/bbs/section_service_setting.php 2025/04/23 07:14:47 1.1 +++ fenglin/bbs/section_service_setting.php 2026/02/11 10:59:14 1.5 @@ -17,7 +17,7 @@ $announcement = (isset($data["announcement"]) ? $data["announcement"] : ""); $sort_order = (isset($data["sort_order"]) ? intval($data["sort_order"]) : 0); $ex_update = (isset($data["ex_update"]) && $data["ex_update"] == "1" ? 1 : 0); - + $result_set = array( "return" => array( "code" => 0, @@ -103,7 +103,7 @@ mysqli_close($db_conn); exit(json_encode($result_set)); } - + $rs = mysqli_query($db_conn, "BEGIN"); if ($rs == false) { @@ -143,7 +143,7 @@ exit(json_encode($result_set)); } mysqli_free_result($rs); - + if ($_SESSION["BBS_priv"]->checklevel(P_ADMIN_M)) { // Set sort order of sections in the same section class @@ -161,7 +161,7 @@ } $i = 1; - $sid_disabled_list = "-1"; + $sid_disabled_list = array(-1); $real_sort_order = 0; while ($row = mysqli_fetch_array($rs)) { @@ -184,7 +184,7 @@ { if ($row["sort_order"] != 0) { - $sid_disabled_list .= (", " . $row["SID"]); + array_push($sid_disabled_list, $row["SID"]); } continue; } @@ -201,7 +201,7 @@ { $result_set["return"]["code"] = -2; $result_set["return"]["message"] = "Update section error: " . mysqli_error($db_conn); - + mysqli_close($db_conn); exit(json_encode($result_set)); } @@ -225,23 +225,25 @@ { $result_set["return"]["code"] = -2; $result_set["return"]["message"] = "Update section error: " . mysqli_error($db_conn); - + mysqli_close($db_conn); exit(json_encode($result_set)); } } // Enforce sort_order of disabled sections to 0 - if ($sid_disabled_list != "-1") + if (count($sid_disabled_list) > 1) { - $sql = "UPDATE section_config SET sort_order = 0 WHERE SID IN ($sid_disabled_list)"; + $sql = "UPDATE section_config SET sort_order = 0 WHERE SID IN (" . + implode(",", $sid_disabled_list) . + ")"; $rs = mysqli_query($db_conn, $sql); if ($rs == false) { $result_set["return"]["code"] = -2; $result_set["return"]["message"] = "Update section error: " . mysqli_error($db_conn); - + mysqli_close($db_conn); exit(json_encode($result_set)); } @@ -253,14 +255,14 @@ $sql = "UPDATE section_config SET sname = '$sname', title = '$title', exp_get = $exp_get, recommend = $recommend, read_user_level = $read_user_level, write_user_level = $write_user_level, comment = '$comment', - announcement = '$announcement', ex_update = $ex_update, + announcement = '$announcement', ex_update = $ex_update, ex_menu_update = $ex_update, set_UID = " . $_SESSION["BBS_uid"] . ", set_dt = NOW(), set_ip='" . client_addr() ."' WHERE SID = $sid"; } else { $sql = "UPDATE section_config SET comment = '$comment', - announcement = '$announcement', ex_update = $ex_update, + announcement = '$announcement', ex_update = $ex_update, ex_menu_update = $ex_update, set_UID = " . $_SESSION["BBS_uid"] . ", set_dt = NOW(), set_ip='" . client_addr() ."' WHERE SID = $sid"; } @@ -288,4 +290,3 @@ mysqli_close($db_conn); exit(json_encode($result_set)); -?>