fenglin/www/load_doc_list.inc.php

<?php
        require_once "../lib/str_process.inc.php";
?>
<?php
function load_doc_list(string $sid, int $num, int $length, int $style, bool $subtitle, mysqli $db_conn) : bool
{
        $sql = "SELECT SID, title FROM section_config WHERE SID = $sid";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                return false;
        }

        if ($row = mysqli_fetch_array($rs))
        {
                $title = $row["title"];
        }
        else
        {
                $sid = 0;
                $title = "";
        }
        mysqli_free_result($rs);

        if ($subtitle)
        {
?>
        <tr class=title_list>
                <td height="25" valign=bottom>
                        <a href="..//bbs/list.php?sid=<?= $sid; ?>&ex=1" target=_blank>
                                <b><?= $title; ?></b>
                        </a>
                </td>
        </tr>
<?              
        }
        else
        {
?>
        <tr class=title_bar_<?= $style; ?>>
                <td>
                        <a class="guide" href="../bbs/list.php?sid=<?= $sid; ?>&ex=1" target=_blank>
                                <?= $title; ?>&gt;&gt;
                        </a>
                </td>
        </tr>
<?php
        }
?>
        <tr class="title_list">
                <td height="8">
                </td>
        </tr>
<?php

        $sql = "SELECT AID, title FROM bbs WHERE TID = 0 AND SID = $sid AND excerption
                        AND visible ORDER BY ontop DESC, AID DESC LIMIT $num";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                return false;
        }

        while($row = mysqli_fetch_array($rs))
        {
?>
        <tr class="title_list">
                <td height="18">
                        ·<a href="../bbs/view_article.php?tn=portal&id=<?= $row["AID"]; ?>" target=_blank>
                                <?= htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8'); ?>
                        </a>
                </td>
        </tr>
<?php
        }
        mysqli_free_result($rs);
?>
        <tr class="title_list">
                <td height="8" align="right">
                </td>
        </tr>
<?php

        return true;
}

function load_top(int $num, int $length, mysqli $db_conn) : bool
{
        $sql = "SELECT AID, bbs.title AS title, section_config.title as s_title
                        FROM bbs INNER JOIN section_config ON bbs.SID = section_config.SID
                        WHERE section_config.recommend AND TID = 0 AND visible AND view_count >= 10
                        AND (sub_dt >= SUBDATE(NOW(), INTERVAL 7 DAY))
                        ORDER BY excerption DESC, (view_count + reply_count) DESC, transship
                        LIMIT 10";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                return false;
        }
?>
        <tr>
                <td height="8">
                </td>
        </tr>
<?php
        while ($row = mysqli_fetch_array($rs))
        {
?>
        <tr>
                <td height="18">
                        ·<a href="../bbs/view_article.php?tn=portal&id=<?= $row["AID"]; ?>" target=_blank>
                                <?= htmlspecialchars(split_line("[" . $row["s_title"] . "] " . $row["title"], "", $length, 1), ENT_HTML401, 'UTF-8'); ?>
                        </a>
                </td>
        </tr>
<?php
        }
        mysqli_free_result($rs);

?>
        <tr>
                <td height="8">
                </td>
        </tr>
<?php

        return true;
}

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