| 1 |
<?php
|
| 2 |
require_once "../lib/str_process.inc.php";
|
| 3 |
|
| 4 |
function load_doc_list(string $sid, int $num, int $length, int $style, bool $subtitle, mysqli $db_conn) : bool
|
| 5 |
{
|
| 6 |
$sql = "SELECT SID, title FROM section_config WHERE SID = $sid";
|
| 7 |
|
| 8 |
$rs = mysqli_query($db_conn, $sql);
|
| 9 |
if ($rs == false)
|
| 10 |
{
|
| 11 |
return false;
|
| 12 |
}
|
| 13 |
|
| 14 |
if ($row = mysqli_fetch_array($rs))
|
| 15 |
{
|
| 16 |
$title = $row["title"];
|
| 17 |
}
|
| 18 |
else
|
| 19 |
{
|
| 20 |
$sid = 0;
|
| 21 |
$title = "";
|
| 22 |
}
|
| 23 |
mysqli_free_result($rs);
|
| 24 |
|
| 25 |
if ($subtitle)
|
| 26 |
{
|
| 27 |
echo <<<HTML
|
| 28 |
<tr class="title_list">
|
| 29 |
<td height="25" valign=bottom>
|
| 30 |
<a href="..//bbs/list.php?sid={$sid}&ex=1" target=_blank>
|
| 31 |
<b>{$title}</b>
|
| 32 |
</a>
|
| 33 |
</td>
|
| 34 |
</tr>
|
| 35 |
HTML;
|
| 36 |
}
|
| 37 |
else
|
| 38 |
{
|
| 39 |
echo <<<HTML
|
| 40 |
<tr class="title_bar_{$style}">
|
| 41 |
<td>
|
| 42 |
<a class="guide" href="../bbs/list.php?sid={$sid}&ex=1" target=_blank>
|
| 43 |
{$title}>>
|
| 44 |
</a>
|
| 45 |
</td>
|
| 46 |
</tr>
|
| 47 |
HTML;
|
| 48 |
}
|
| 49 |
|
| 50 |
echo <<<HTML
|
| 51 |
<tr class="title_list">
|
| 52 |
<td height="8">
|
| 53 |
</td>
|
| 54 |
</tr>
|
| 55 |
HTML;
|
| 56 |
|
| 57 |
$sql = "SELECT AID, title FROM bbs WHERE TID = 0 AND SID = $sid AND excerption
|
| 58 |
AND visible ORDER BY ontop DESC, AID DESC LIMIT $num";
|
| 59 |
|
| 60 |
$rs = mysqli_query($db_conn, $sql);
|
| 61 |
if ($rs == false)
|
| 62 |
{
|
| 63 |
return false;
|
| 64 |
}
|
| 65 |
|
| 66 |
while($row = mysqli_fetch_array($rs))
|
| 67 |
{
|
| 68 |
$title_f = htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8');
|
| 69 |
|
| 70 |
echo <<<HTML
|
| 71 |
<tr class="title_list">
|
| 72 |
<td height="18">
|
| 73 |
·<a href="../bbs/view_article.php?tn=portal&id={$row["AID"]}" target=_blank>
|
| 74 |
{$title_f}
|
| 75 |
</a>
|
| 76 |
</td>
|
| 77 |
</tr>
|
| 78 |
HTML;
|
| 79 |
}
|
| 80 |
mysqli_free_result($rs);
|
| 81 |
|
| 82 |
echo <<<HTML
|
| 83 |
<tr class="title_list">
|
| 84 |
<td height="8" align="right">
|
| 85 |
</td>
|
| 86 |
</tr>
|
| 87 |
HTML;
|
| 88 |
|
| 89 |
return true;
|
| 90 |
}
|
| 91 |
|
| 92 |
function load_top(int $num, int $length, mysqli $db_conn) : bool
|
| 93 |
{
|
| 94 |
$sql = "SELECT AID, bbs.title AS title, section_config.title as s_title
|
| 95 |
FROM bbs INNER JOIN section_config ON bbs.SID = section_config.SID
|
| 96 |
WHERE section_config.recommend AND TID = 0 AND visible AND view_count >= 10
|
| 97 |
AND (sub_dt >= SUBDATE(NOW(), INTERVAL 7 DAY))
|
| 98 |
ORDER BY excerption DESC, (view_count + reply_count) DESC, transship
|
| 99 |
LIMIT 10";
|
| 100 |
|
| 101 |
$rs = mysqli_query($db_conn, $sql);
|
| 102 |
if ($rs == false)
|
| 103 |
{
|
| 104 |
return false;
|
| 105 |
}
|
| 106 |
|
| 107 |
echo <<<HTML
|
| 108 |
<tr>
|
| 109 |
<td height="8">
|
| 110 |
</td>
|
| 111 |
</tr>
|
| 112 |
HTML;
|
| 113 |
|
| 114 |
while ($row = mysqli_fetch_array($rs))
|
| 115 |
{
|
| 116 |
$title_f = htmlspecialchars(split_line("[" . $row["s_title"] . "] " . $row["title"], "", $length, 1), ENT_HTML401, 'UTF-8');
|
| 117 |
|
| 118 |
echo <<<HTML
|
| 119 |
<tr>
|
| 120 |
<td height="18">
|
| 121 |
·<a href="../bbs/view_article.php?tn=portal&id={$row["AID"]}" target=_blank>
|
| 122 |
{$title_f}
|
| 123 |
</a>
|
| 124 |
</td>
|
| 125 |
</tr>
|
| 126 |
HTML;
|
| 127 |
}
|
| 128 |
mysqli_free_result($rs);
|
| 129 |
|
| 130 |
echo <<<HTML
|
| 131 |
<tr>
|
| 132 |
<td height="8">
|
| 133 |
</td>
|
| 134 |
</tr>
|
| 135 |
HTML;
|
| 136 |
|
| 137 |
return true;
|
| 138 |
}
|
| 139 |
|
Parent Directory
| 
Revision Log