--- lbbs/utils/bin/gen_top.php	2004/10/22 18:47:51	1.2
+++ lbbs/utils/bin/gen_top.php	2025/05/03 14:59:50	1.10
@@ -1,53 +1,54 @@
-#!/usr/local/bin/php
-<?
+<?php
 	if (!isset($_SERVER["argc"]))
-		$_SERVER["argc"] = 0;
+	{
+		echo ("Invalid usage");
+		exit();
+	}
+
+	chdir(dirname($_SERVER["argv"][0]));
 
-	if (isset($_SERVER["argv"][0]))
-		chdir(substr($_SERVER["argv"][0],0,strrpos($_SERVER["argv"][0],"/")));
+	require_once "../lib/db_open.inc.php";
+	require_once "../lib/str_process.inc.php";
 
-	$cache_path = "../../data/bbs_top.txt";
+	$cache_path = "../../var/bbs_top.txt";
 
 	$buffer =
 		"               \033[1;34m-----\033[37m=====\033[41;37m 本站十大热门话题 \033[40m=====\033[34m-----\033[m\r\n\r\n";
 
-	$db_conn = include "./db_open.inc.php";
-	
-	$rs = mysql_query(
-		" select bbs.title, sname, username, sub_dt".
-		" from bbs inner join section_config on".
-		" bbs.SID=section_config.SID inner join user_list on".
-		" user_list.UID=bbs.UID where section_config.recommend".
-		" and bbs.TID=0 and bbs.visible and bbs.view_count>=10".
-		" and (bbs.sub_dt >= subdate(now(),interval '7' day))".
-		" order by bbs.excerption desc,bbs.view_count+bbs.reply_count desc,".
-		"bbs.transship limit 10",$db_conn);
+	$sql = "SELECT AID, bbs.title AS title, sname, username, sub_dt
+			FROM bbs INNER JOIN section_config ON bbs.SID = section_config.SID
+			WHERE section_config.recommend AND TID = 0 AND visible AND view_count >= 10
+			AND (sub_dt >= SUBDATE(NOW(), INTERVAL 7 DAY))
+			ORDER BY excerption DESC, (view_count + reply_count) DESC, transship
+			LIMIT 10";
+
+	$rs = mysqli_query($db_conn, $sql);
+	if ($rs == false)
+	{
+		echo("Query data error: " . mysqli_error($db_conn));
+		exit();
+	}
 
 	$i = 1;
-	while ($row=mysql_fetch_array($rs))
+	while ($row = mysqli_fetch_array($rs))
 	{
+		$title_f = split_line($row["title"], "", 60, 1, "");
+
 		$buffer .= sprintf (
-			" \033[1;37m第 \033[31m%2d \033[37m名 版块 : \033[33m%s%s \033[37m【\033[32m%s \033[37m】    \033[35m%s%s \r\n".
-			" \033[37m     标题 : \033[44;37m%s%s \033[0;40;37m\r\n",
-			$i++, $row["sname"], str_repeat(" ", 20 - strlen($row["sname"])),
-			strftime("%a %d %H:%M:%S", strtotime($row["sub_dt"])),
+			" \033[1;37m第 \033[31m%2d \033[37m名 版块 : \033[33m%s%s \033[37m【 \033[32m%s \033[37m】   \033[35m%s%s \n" .
+			" \033[37m         标题 : \033[44;37m%s%s \033[0;40;37m\n",
+			$i++,
+			$row["sname"],
+			str_repeat(" ", 20 - strlen($row["sname"])),
+			(new DateTimeImmutable($row["sub_dt"]))->format("M d H:i:s"),
 			str_repeat(" ", 16 - strlen($row["username"])),
-			$row["username"], substr($row["title"],0,60), 
-			str_repeat(" ", 60 - strlen($row["title"]))
+			$row["username"],
+			$title_f,
+			str_repeat(" ", 60 - str_length($title_f))
 			);
 	}
-	
-	mysql_free_result($rs);
+	mysqli_free_result($rs);
 
-	mysql_close($db_conn);
+	mysqli_close($db_conn);
 
-	$buffer .= "\r\n";
-	
-	if (($fp=fopen($cache_path,"w")))
-	{
-		fwrite($fp,$buffer);
-		fclose($fp);
-	}
-	
-	return 0;
-?>
+	file_put_contents($cache_path, $buffer);