| 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>></a></td></tr>\n"); |
"sid=$sid&ex=1\" target=_blank>$title>></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>".htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8')." </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); |
| 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 |
|
|
| 87 |
echo ("<tr><td height=8></td></tr>\n"); |
echo ("<tr><td height=8></td></tr>\n"); |
| 88 |
while ($row = mysqli_fetch_array($rs)) |
while ($row = mysqli_fetch_array($rs)) |
| 89 |
{ |
{ |
| 90 |
echo ("<tr><td height=18>·[".$row["s_title"]. |
echo ("<tr><td height=18>·<a href=\"view_article.php?id=". |
|
"]<a href=\"show_article.php?aid=". |
|
| 91 |
$row["AID"]."\" target=_blank>" . |
$row["AID"]."\" target=_blank>" . |
| 92 |
htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') . |
htmlspecialchars(split_line("[" . $row["s_title"] . "] " . $row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') . |
| 93 |
" </a></td></tr>\n"); |
" </a></td></tr>\n"); |
| 94 |
} |
} |
| 95 |
echo ("<tr><td height=8></td></tr>\n"); |
echo ("<tr><td height=8></td></tr>\n"); |
| 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>" . |
$row["AID"]."\" target=_blank>" . |
| 112 |
htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') . |
htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') . |
| 113 |
" </a></td></tr>\n"); |
" </a></td></tr>\n"); |