--- lbbs/utils/bin/gen_top.php	2004/12/01 06:04:37	1.4
+++ lbbs/utils/bin/gen_top.php	2005/07/10 02:36:22	1.6
@@ -1,4 +1,4 @@
-#!/usr/local/bin/php
+#!/usr/local/php/bin/php
 <?
 	if (!isset($_SERVER["argc"]))
 		$_SERVER["argc"] = 0;
@@ -16,12 +16,12 @@
 	$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".
+		" bbs.SID=section_config.SID 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);
+		"bbs.transship limit 10",$db_conn)
+		or die ("Query data error");
 
 	$i = 1;
 	while ($row=mysql_fetch_array($rs))
@@ -33,7 +33,7 @@
 			strftime("%b %d %H:%M:%S", strtotime($row["sub_dt"])),
 			str_repeat(" ", 16 - strlen($row["username"])),
 			$row["username"], substr($row["title"],0,60), 
-			str_repeat(" ", 60 - strlen($row["title"]))
+			str_repeat(" ", 60 - strlen($row["title"]) >=0 ? 60 - strlen($row["title"]) : 0)
 			);
 	}