/[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.2 by sysadm, Sat Oct 8 18:12:18 2005 UTC Revision 1.10 by sysadm, Fri Apr 11 12:47:39 2025 UTC
# Line 1  Line 1 
1  <?  <?
2  require_once "./gen_top.inc.php";          require_once "../lib/str_process.inc.php";
3    ?>
4    <?
5  function load_doc_list($section_name,$num,$length,$style,$subtitle,$db_conn)  function load_doc_list($section_name,$num,$length,$style,$subtitle,$db_conn)
6  {  {
7          $rs=mysql_query("select SID,title from section_config where sname=".          $rs=mysql_query("select SID, title from section_config where sname=".
8                  "'$section_name'",$db_conn)                  "'$section_name'",$db_conn)
9                  or die("Query section error!");                  or die("Query section error!");
10          if ($row=mysql_fetch_array($rs))          if ($row=mysql_fetch_array($rs))
# Line 18  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")
30                  or die("Query article error!");                  or die("Query article error!");
31          while($row=mysql_fetch_array($rs))          while($row=mysql_fetch_array($rs))
32          {          {
33                  echo ("<tr class=title_list><td height=18>กค<a href=\"show_article.php?aid=".                  echo ("<tr class=title_list><td height=18>ยท<a href=\"view_article.php?id=".
34                          $row["AID"]."\" target=_blank>".substr($row["title"],0,$length)." </a></td></tr>\n");                          $row["AID"]."\" target=_blank>".htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8')." </a></td></tr>\n");
35          }          }
36          mysql_free_result($rs);          mysql_free_result($rs);
37          echo ("<tr class=title_list><td height=8 align=right><a href=\"rss.php?sid=$sid\"".          echo ("<tr class=title_list><td height=8 align=right><a href=\"rss.php?sid=$sid\"".
# Line 54  function load_class_list($class_name,$se Line 55  function load_class_list($class_name,$se
55          }          }
56          mysql_free_result($rs);          mysql_free_result($rs);
57    
58          echo (" <tr class=title_bar_$style><td><a class=guide href=\"/bbs/class.php?".          echo (" <tr class=title_bar_$style><td>$title&gt;&gt;</td></tr>\n");
                 "cid=$cid\" target=_blank>$title&gt;&gt;</a></td></tr>\n");  
59    
60          $rs_s=mysql_query("select sname from section_config where CID=".          $rs_s=mysql_query("select sname from section_config where CID=".
61                  $cid." and enable order by sort_order",$db_conn)                  $cid." and enable order by sort_order",$db_conn)
# Line 68  function load_class_list($class_name,$se Line 68  function load_class_list($class_name,$se
68          mysql_free_result($rs_s);          mysql_free_result($rs_s);
69  }  }
70    
71  function load_top($num,$length,$db_conn)  function load_top($num, $length, $db_conn)
72  {  {
73          gen_top_article(10,$db_conn);          $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
75                            WHERE section_config.recommend AND TID = 0 AND visible AND view_count >= 10
76                            AND (sub_dt >= SUBDATE(NOW(), INTERVAL 7 DAY))
77                            ORDER BY excerption DESC, (view_count + reply_count) DESC, transship
78                            LIMIT 10";
79    
80          $rs=mysql_query("select * from bbs_top_list limit $num",$db_conn)          $rs = mysqli_query($db_conn, $sql);
81                  or die("Query data error!");          if ($rs == false)
82            {
83                    echo("Query data error: " . mysqli_error($db_conn));
84                    exit();
85            }
86    
87          echo ("<tr><td height=8></td></tr>\n");          echo ("<tr><td height=8></td></tr>\n");
88          while ($row=mysql_fetch_array($rs))          while ($row = mysqli_fetch_array($rs))
89          {          {
90                  echo ("<tr><td height=18>กค[".$row["section_title"].                  echo ("<tr><td height=18>ยท<a href=\"view_article.php?id=".
91                          "]<a href=\"show_article.php?aid=".                          $row["AID"]."\" target=_blank>" .
92                          $row["AID"]."\" target=_blank>".substr($row["bbs_title"],0,$length)." </a></td></tr>\n");                          htmlspecialchars(split_line("[" . $row["s_title"] . "] " . $row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') .
93                            " </a></td></tr>\n");
94          }          }
95          echo ("<tr><td height=8></td></tr>\n");          echo ("<tr><td height=8></td></tr>\n");
96    
97          mysql_free_result($rs);          mysqli_free_result($rs);
98  }  }
99    
100  function load_recommend($num,$length,$db_conn)  function load_recommend($num, $length, $db_conn)
101  {  {
102          $rs=mysql_query("select AID,title".          $rs=mysql_query("select AID,title".
103                  " from bbs where TID=0 and recommend and visible".                  " from bbs where TID=0 and recommend and visible".
104                  " order by sub_dt desc limit $num",$db_conn)                  " order by sub_dt desc limit $num", $db_conn)
105                  or die("Query data error!");                  or die("Query data error!");
106    
107          echo ("<tr class=title_list><td height=8></td></tr>\n");          echo ("<tr class=title_list><td height=8></td></tr>\n");
108          while ($row=mysql_fetch_array($rs))          while ($row=mysql_fetch_array($rs))
109          {          {
110                  echo ("<tr class=title_list><td height=18>กค<a href=\"show_article.php?aid=".                  echo ("<tr class=title_list><td height=18>ยท<a href=\"view_article.php?id=".
111                          $row["AID"]."\" target=_blank>".substr($row["title"],0,$length)." </a></td></tr>\n");                          $row["AID"]."\" target=_blank>" .
112                            htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') .
113                            " </a></td></tr>\n");
114          }          }
115          echo ("<tr class=title_list><td height=8></td></tr>\n");          echo ("<tr class=title_list><td height=8></td></tr>\n");
116    
117          mysql_free_result($rs);          mysql_free_result($rs);
118  }  }
119  ?>  ?>
   

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