--- fenglin/bbs/list.php 2025/04/13 01:03:17 1.4 +++ fenglin/bbs/list.php 2025/04/29 11:55:32 1.8 @@ -1,4 +1,4 @@ - $row["username"], "major" => $row["major"], )); - } + } mysqli_free_result($rs); // Query articles @@ -218,7 +218,7 @@ array_push($visited_aid_list, $row["AID"]); } } - + mysqli_data_seek($rs, 0); if ($aid_list != "-1") @@ -230,20 +230,22 @@ { $result_set["return"]["code"] = -2; $result_set["return"]["message"] = "Query view_article_log error: " . mysqli_error($db_conn); - + mysqli_close($db_conn); exit(json_encode($result_set)); } - + while ($row_view = mysqli_fetch_array($rs_view)) { array_push($visited_aid_list, $row_view["AID"]); } - + mysqli_free_result($rs_view); } } + $author_list = array(); + while ($row = mysqli_fetch_array($rs)) { array_push($result_set["data"]["articles"], array( @@ -269,9 +271,48 @@ "last_reply_nickname" => $row["last_reply_nickname"], "visited" => (($_SESSION["BBS_uid"] > 0 && in_array($row["AID"], $visited_aid_list)) ? 1 : 0), )); + + if (!isset($author_list[$row["UID"]])) + { + $author_list[$row["UID"]] = true; + } + if (!isset($author_list[$row["last_reply_UID"]])) + { + $author_list[$row["last_reply_UID"]] = true; + } } mysqli_free_result($rs); + $uid_list = "-1"; + foreach ($author_list as $uid => $status) + { + $uid_list .= (", " . $uid); + } + unset($author_list); + + $author_list = array(); + + $sql = "SELECT UID FROM user_list WHERE UID IN ($uid_list) AND enable"; + + $rs = mysqli_query($db_conn, $sql); + if ($rs == false) + { + $result_set["return"]["code"] = -2; + $result_set["return"]["message"] = "Query user list error: " . mysqli_error($db_conn); + + mysqli_close($db_conn); + exit(json_encode($result_set)); + } + + while ($row = mysqli_fetch_array($rs)) + { + $author_list[$row["UID"]] = true; + } + mysqli_free_result($rs); + + $result_set["data"]["author_list"] = $author_list; + unset($author_list); + mysqli_close($db_conn); // Cleanup @@ -302,4 +343,3 @@ exit(json_encode($result_set)); // Output data in Json } include $theme_view_file; -?>