/[LeafOK_CVS]/fenglin/www/load_doc_list.inc.php
ViewVC logotype

Diff of /fenglin/www/load_doc_list.inc.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.9 by sysadm, Tue Apr 1 05:23:05 2025 UTC Revision 1.10 by sysadm, Fri Apr 11 12:47:39 2025 UTC
# Line 19  function load_doc_list($section_name,$nu Line 19  function load_doc_list($section_name,$nu
19          }          }
20          mysql_free_result($rs);          mysql_free_result($rs);
21          if ($subtitle)          if ($subtitle)
22                  echo (" <tr class=title_list><td height=20 valign=bottom><a href=\"/bbs/bbs.php?".                  echo (" <tr class=title_list><td height=20 valign=bottom><a href=\"/bbs/list.php?".
23                          "sid=$sid&switch_view=ex\" target=_blank><b>$title</b></a></td></tr>\n");                          "sid=$sid&ex=1\" target=_blank><b>$title</b></a></td></tr>\n");
24          else          else
25                  echo (" <tr class=title_bar_$style><td><a class=guide href=\"/bbs/bbs.php?".                  echo (" <tr class=title_bar_$style><td><a class=guide href=\"/bbs/list.php?".
26                          "sid=$sid&switch_view=ex\" target=_blank>$title&gt;&gt;</a></td></tr>\n");                          "sid=$sid&ex=1\" target=_blank>$title&gt;&gt;</a></td></tr>\n");
27          echo ("<tr class=title_list><td height=8></td></tr>\n");          echo ("<tr class=title_list><td height=8></td></tr>\n");
28          $rs=mysql_query("select AID,title from bbs where TID=0 and SID=$sid and excerption".          $rs=mysql_query("select AID,title from bbs where TID=0 and SID=$sid and excerption".
29                  " and visible order by ontop desc, AID desc limit $num")                  " and visible order by ontop desc, AID desc limit $num")
# Line 73  function load_top($num, $length, $db_con Line 73  function load_top($num, $length, $db_con
73          $sql = "SELECT AID, bbs.title AS title, section_config.title as s_title          $sql = "SELECT AID, bbs.title AS title, section_config.title as s_title
74                          FROM bbs INNER JOIN section_config ON bbs.SID = section_config.SID                          FROM bbs INNER JOIN section_config ON bbs.SID = section_config.SID
75                          WHERE section_config.recommend AND TID = 0 AND visible AND view_count >= 10                          WHERE section_config.recommend AND TID = 0 AND visible AND view_count >= 10
76                          AND (sub_dt >= SUBDATE(NOW(), INTERVAL '7' DAY))                          AND (sub_dt >= SUBDATE(NOW(), INTERVAL 7 DAY))
77                          ORDER BY excerption DESC, (view_count + reply_count) DESC, transship                          ORDER BY excerption DESC, (view_count + reply_count) DESC, transship
78                          LIMIT 10";                          LIMIT 10";
79    

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1