--- lbbs/utils/bin/gen_top.php	2004/10/22 17:45:36	1.1
+++ lbbs/utils/bin/gen_top.php	2025/10/13 07:14:48	1.14
@@ -1,50 +1,92 @@
-#!/usr/local/bin/php
-<?
+<?php
 	if (!isset($_SERVER["argc"]))
-		$_SERVER["argc"] = 0;
+	{
+		echo ("Invalid usage");
+		exit();
+	}
 
-	if (isset($_SERVER["argv"][0]))
-		chdir(substr($_SERVER["argv"][0],0,strrpos($_SERVER["argv"][0],"/")));
+	chdir(dirname($_SERVER["argv"][0]));
 
-	$cache_path = "../../data/bbs_top.txt";
+	require_once "../lib/db_open.inc.php";
+	require_once "../lib/str_process.inc.php";
 
-	$buffer =
-		"                -----===== 全国十大热门话题 =====-----\r\n\r\n";
-
-	$db_conn = include "./db_open.inc.php";
-	
-	$rs = mysql_query(
-		" select bbs.title, sname, username".
-		" 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);
+	$text_file_path = "../../var/bbs_top.txt";
+	$menu_file_path = "../../var/bbs_top_menu.conf";
 
-	i = 1;
+	$buffer_text =
+		"                     \033[1;34m-----\033[37m=====\033[41;37m 鏈珯鍗佸ぇ鐑棬璇濋 \033[40m=====\033[34m-----\033[m\r\n\r\n";
+
+	$buffer_screen = <<<SCREEN
+#---------------------------------------------------------------------
+%S_TOP10
+                     \033[1;34m-----\033[37m=====\033[41;37m 鏈珯鍗佸ぇ鐑棬璇濋 \033[40m=====\033[34m-----\033[m
+
+SCREEN;
+
+	$buffer_menu = <<<MENU
+#---------------------------------------------------------------------
+%menu M_TOP10
+title       0, 0, "鍗佸ぇ鐑棬璇濋"
+screen      2, 0, S_TOP10
+
+MENU;
+
+	$sql = "SELECT AID, bbs.title AS title, sname,
+			section_config.title AS s_title, 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";
 
-	while ($row=mysql_fetch_array($rs))
+	$rs = mysqli_query($db_conn, $sql);
+	if ($rs == false)
 	{
-		sprintf ($temp,
-			"第 %2d 名 版块 : [%s]%s%s%s\r\n".
-			"         标题 : %s%s\r\n",
-			i++, $row["sname"], str_repeat(" ", 36 - strlen($row["sname"])),
-			$row["username"], str_repeat(" ", 28 - strlen($row["username"]))
-			);
-		$buffer.=$temp;
+		echo("Query data error: " . mysqli_error($db_conn));
+		exit();
 	}
-	
-	mysql_free_result($rs);
 
-	mysql_close($db_conn);
-
-	if (($fp=fopen($cache_path,"w")))
+	$i = 1;
+	while ($row = mysqli_fetch_array($rs))
 	{
-		fwrite($fp,$buffer);
-		fclose($fp);
+		$title_f = split_line($row["title"], "", 60, 1, "");
+
+		$line_section = sprintf (
+			" \033[1;37m绗� \033[31m%2d \033[37m鍚� 鐗堝潡 : \033[33m%s [%s]%s \033[37m銆� \033[32m%s \033[37m銆慭033[35m%s%s ",
+			$i,
+			$row["s_title"],
+			$row["sname"],
+			str_repeat(" ", 20 - str_length($row["s_title"]) - strlen($row["sname"])),
+			(new DateTimeImmutable($row["sub_dt"]))->format("M d H:i:s"),
+			str_repeat(" ", 16 - strlen($row["username"])),
+			$row["username"]
+			);
+
+		$line_article = sprintf (
+			" \033[1;37m       鏍囬 : \033[44;37m%s%s  \033[0;40;37m",
+			$title_f,
+			str_repeat(" ", 60 - str_length($title_f))
+			);
+
+		$buffer_text .= $line_section . "\n  " . $line_article . "\n";
+
+		$buffer_screen .= $line_section . "\n\n";
+
+		$row_article = $i * 2 + 2;
+
+		$buffer_menu .= <<<MENU
+@LOCATE_ARTICLE   {$row_article}, 3, 1, 0,   "{$row['sname']}|{$row['AID']}",    "{$line_article}"
+
+MENU;
+
+		$i++;
 	}
-	
-	return 0;
-?>
+	mysqli_free_result($rs);
+
+	mysqli_close($db_conn);
+
+	$buffer_screen .= "%\n";
+	$buffer_menu .= ("%\n" . $buffer_screen);
+
+	file_put_contents($text_file_path, $buffer_text);
+	file_put_contents($menu_file_path, $buffer_menu);