fenglin/www/load_doc_list.inc.php

<?php
require_once "../lib/str_process.inc.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)
        {
                echo <<<HTML
                <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>
                HTML;
        }
        else
        {
                echo <<<HTML
                <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>
                HTML;
        }

        echo <<<HTML
        <tr class="title_list">
                <td height="8">
                </td>
        </tr>
        HTML;

        $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))
        {
                $title_f = htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8');

                echo <<<HTML
                <tr class="title_list">
                        <td height="18">
                                ·<a href="../bbs/view_article.php?tn=portal&id={$row["AID"]}" target=_blank>
                                        {$title_f}
                                </a>
                        </td>
                </tr>
                HTML;
        }
        mysqli_free_result($rs);

        echo <<<HTML
        <tr class="title_list">
                <td height="8" align="right">
                </td>
        </tr>
        HTML;

        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;
        }

        echo <<<HTML
        <tr>
                <td height="8">
                </td>
        </tr>
        HTML;

        while ($row = mysqli_fetch_array($rs))
        {
                $title_f = htmlspecialchars(split_line("[" . $row["s_title"] . "] " . $row["title"], "", $length, 1), ENT_HTML401, 'UTF-8');

                echo <<<HTML
                <tr>
                        <td height="18">
                                ·<a href="../bbs/view_article.php?tn=portal&id={$row["AID"]}" target=_blank>
                                        {$title_f}
                                </a>
                        </td>
                </tr>
                HTML;
        }
        mysqli_free_result($rs);

        echo <<<HTML
        <tr>
                <td height="8">
                </td>
        </tr>
        HTML;

        return true;
}

1	sysadm	1.15	<?php
2	sysadm	1.16	require_once "../lib/str_process.inc.php";
3
4	sysadm	1.13	function load_doc_list(string $sid, int $num, int $length, int $style, bool $subtitle, mysqli $db_conn) : bool
5	sysadm	1.1	{
6	sysadm	1.13	$sql = "SELECT SID, title FROM section_config WHERE SID = $sid";
7	sysadm	1.11
8			$rs = mysqli_query($db_conn, $sql);
9			if ($rs == false)
10			{
11	sysadm	1.13	return false;
12	sysadm	1.11	}
13
14			if ($row = mysqli_fetch_array($rs))
15	sysadm	1.1	{
16	sysadm	1.11	$title = $row["title"];
17	sysadm	1.1	}
18			else
19			{
20	sysadm	1.11	$sid = 0;
21			$title = "";
22	sysadm	1.1	}
23	sysadm	1.11	mysqli_free_result($rs);
24
25	sysadm	1.1	if ($subtitle)
26	sysadm	1.11	{
27	sysadm	1.16	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	sysadm	1.11	}
37	sysadm	1.1	else
38	sysadm	1.11	{
39	sysadm	1.16	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	sysadm	1.11	}
49	sysadm	1.16
50			echo <<<HTML
51	sysadm	1.13	<tr class="title_list">
52			<td height="8">
53			</td>
54			</tr>
55	sysadm	1.16	HTML;
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.16	$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	sysadm	1.1	}
80	sysadm	1.11	mysqli_free_result($rs);
81	sysadm	1.16
82			echo <<<HTML
83	sysadm	1.13	<tr class="title_list">
84			<td height="8" align="right">
85			</td>
86			</tr>
87	sysadm	1.16	HTML;
88	sysadm	1.11
89	sysadm	1.13	return true;
90	sysadm	1.1	}
91
92	sysadm	1.13	function load_top(int $num, int $length, mysqli $db_conn) : bool
93	sysadm	1.1	{
94	sysadm	1.6	$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	sysadm	1.10	AND (sub_dt >= SUBDATE(NOW(), INTERVAL 7 DAY))
98	sysadm	1.6	ORDER BY excerption DESC, (view_count + reply_count) DESC, transship
99			LIMIT 10";
100	sysadm	1.1
101	sysadm	1.6	$rs = mysqli_query($db_conn, $sql);
102			if ($rs == false)
103			{
104	sysadm	1.13	return false;
105	sysadm	1.6	}
106	sysadm	1.16
107			echo <<<HTML
108	sysadm	1.13	<tr>
109			<td height="8">
110			</td>
111			</tr>
112	sysadm	1.16	HTML;
113
114	sysadm	1.6	while ($row = mysqli_fetch_array($rs))
115	sysadm	1.1	{
116	sysadm	1.16	$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	sysadm	1.1	}
128	sysadm	1.11	mysqli_free_result($rs);
129
130	sysadm	1.16	echo <<<HTML
131	sysadm	1.13	<tr>
132			<td height="8">
133			</td>
134			</tr>
135	sysadm	1.16	HTML;
136	sysadm	1.13
137			return true;
138	sysadm	1.1	}
139	sysadm	1.17
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1