fenglin/www/load_doc_list.inc.php

<?
        require_once "../lib/str_process.inc.php";
?>
<?
function load_doc_list($section_name, $num, $length, $style, $subtitle, $db_conn)
{
        $sql = "SELECT SID, title FROM section_config WHERE sname = '" .
                        mysqli_real_escape_string($db_conn, $section_name) . "'";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                echo("Query section error: " . mysqli_error($db_conn));
                exit();
        }

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

        if ($subtitle)
        {
                echo (" <tr class=title_list><td height=20 valign=bottom>" .
                        "<a href=\"/bbs/list.php?sid=$sid&ex=1\" target=_blank>" .
                        "<b>$title</b></a></td></tr>\n");
                
        }
        else
        {
                echo (" <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>\n");
        }

        echo ("<tr class=title_list><td height=8></td></tr>\n");

        $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)
        {
                echo("Query article error: " . mysqli_error($db_conn));
                exit();
        }

        while($row = mysqli_fetch_array($rs))
        {
                echo ("<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>\n");
        }
        mysqli_free_result($rs);

        echo ("<tr class=title_list><td height=8 align=right></td></tr>\n");
}

function load_class_list($class_name, $section_name_list, $num, $length, $style, $db_conn)
{
        $sql = "SELECT CID,title FROM section_class WHERE cname = '" .
                        mysqli_real_escape_string($db_conn, $class_name) . "'";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                echo("Query class error: " . mysqli_error($db_conn));
                exit();
        }

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

        echo ("<tr class=title_bar_$style><td>$title&gt;&gt;</td></tr>\n");

        $sql = "SELECT sname FROM section_config WHERE CID = $cid
                        AND enable ORDER BY sort_order";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                echo("Query section error: " . mysqli_error($db_conn));
                exit();
        }

        while ($row = mysqli_fetch_array($rs))
        {
                if (in_array($row["sname"], $section_name_list))
                {
                        load_doc_list($row["sname"], $num, $length, $style, true, $db_conn);
                }
        }
        mysqli_free_result($rs);
}

function load_top($num, $length, $db_conn)
{
        $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)
        {
                echo("Query data error: " . mysqli_error($db_conn));
                exit();
        }

        echo ("<tr><td height=8></td></tr>\n");

        while ($row = mysqli_fetch_array($rs))
        {
                echo ("<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>\n");
        }
        mysqli_free_result($rs);

        echo ("<tr><td height=8></td></tr>\n");
}

function load_recommend($num, $length, $db_conn)
{
        $sql = "SELECT AID, title FROM bbs WHERE TID = 0 AND recommend AND visible
                        ORDER BY sub_dt DESC LIMIT $num";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                echo("Query data error: " . mysqli_error($db_conn));
                exit();
        }

        echo ("<tr class=title_list><td height=8></td></tr>\n");

        while ($row = mysqli_fetch_array($rs))
        {
                echo ("<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>\n");
        }
        mysql_free_result($rs);

        echo ("<tr class=title_list><td height=8></td></tr>\n");
}
?>
1	sysadm	1.1	<?
2	sysadm	1.6	require_once "../lib/str_process.inc.php";
3			?>
4			<?
5	sysadm	1.11	function load_doc_list($section_name, $num, $length, $style, $subtitle, $db_conn)
6	sysadm	1.1	{
7	sysadm	1.11	$sql = "SELECT SID, title FROM section_config WHERE sname = '" .
8			mysqli_real_escape_string($db_conn, $section_name) . "'";
9
10			$rs = mysqli_query($db_conn, $sql);
11			if ($rs == false)
12			{
13			echo("Query section error: " . mysqli_error($db_conn));
14			exit();
15			}
16
17			if ($row = mysqli_fetch_array($rs))
18	sysadm	1.1	{
19	sysadm	1.11	$sid = $row["SID"];
20			$title = $row["title"];
21	sysadm	1.1	}
22			else
23			{
24	sysadm	1.11	$sid = 0;
25			$title = "";
26	sysadm	1.1	}
27	sysadm	1.11	mysqli_free_result($rs);
28
29	sysadm	1.1	if ($subtitle)
30	sysadm	1.11	{
31			echo (" <tr class=title_list><td height=20 valign=bottom>" .
32			"<a href=\"/bbs/list.php?sid=$sid&ex=1\" target=_blank>" .
33			"<b>$title</b></a></td></tr>\n");
34
35			}
36	sysadm	1.1	else
37	sysadm	1.11	{
38			echo (" <tr class=title_bar_$style><td>" .
39			"<a class=guide href=\"/bbs/list.php?sid=$sid&ex=1\" target=_blank>" .
40			"$title>></a></td></tr>\n");
41			}
42
43	sysadm	1.1	echo ("<tr class=title_list><td height=8></td></tr>\n");
44	sysadm	1.11
45			$sql = "SELECT AID, title FROM bbs WHERE TID = 0 AND SID = $sid AND excerption
46			AND visible ORDER BY ontop DESC, AID DESC LIMIT $num";
47
48			$rs = mysqli_query($db_conn, $sql);
49			if ($rs == false)
50			{
51			echo("Query article error: " . mysqli_error($db_conn));
52			exit();
53			}
54
55			while($row = mysqli_fetch_array($rs))
56	sysadm	1.1	{
57	sysadm	1.11	echo ("<tr class=title_list><td height=18>" .
58			"·<a href=\"../bbs/view_article.php?tn=portal&id=" . $row["AID"] . "\" target=_blank>" .
59			htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') .
60			"</a></td></tr>\n");
61	sysadm	1.1	}
62	sysadm	1.11	mysqli_free_result($rs);
63
64			echo ("<tr class=title_list><td height=8 align=right></td></tr>\n");
65	sysadm	1.1	}
66
67	sysadm	1.11	function load_class_list($class_name, $section_name_list, $num, $length, $style, $db_conn)
68	sysadm	1.1	{
69	sysadm	1.11	$sql = "SELECT CID,title FROM section_class WHERE cname = '" .
70			mysqli_real_escape_string($db_conn, $class_name) . "'";
71
72			$rs = mysqli_query($db_conn, $sql);
73			if ($rs == false)
74	sysadm	1.1	{
75	sysadm	1.11	echo("Query class error: " . mysqli_error($db_conn));
76			exit();
77			}
78
79			if ($row = mysqli_fetch_array($rs))
80			{
81			$cid = $row["CID"];
82			$title = $row["title"];
83	sysadm	1.1	}
84			else
85			{
86	sysadm	1.11	$cid = 0;
87			$title = "";
88	sysadm	1.1	}
89	sysadm	1.11	mysqli_free_result($rs);
90
91			echo ("<tr class=title_bar_$style><td>$title>></td></tr>\n");
92
93			$sql = "SELECT sname FROM section_config WHERE CID = $cid
94			AND enable ORDER BY sort_order";
95	sysadm	1.1
96	sysadm	1.11	$rs = mysqli_query($db_conn, $sql);
97			if ($rs == false)
98			{
99			echo("Query section error: " . mysqli_error($db_conn));
100			exit();
101			}
102	sysadm	1.1
103	sysadm	1.11	while ($row = mysqli_fetch_array($rs))
104	sysadm	1.1	{
105	sysadm	1.11	if (in_array($row["sname"], $section_name_list))
106			{
107			load_doc_list($row["sname"], $num, $length, $style, true, $db_conn);
108			}
109	sysadm	1.1	}
110	sysadm	1.11	mysqli_free_result($rs);
111	sysadm	1.1	}
112
113	sysadm	1.6	function load_top($num, $length, $db_conn)
114	sysadm	1.1	{
115	sysadm	1.6	$sql = "SELECT AID, bbs.title AS title, section_config.title as s_title
116			FROM bbs INNER JOIN section_config ON bbs.SID = section_config.SID
117			WHERE section_config.recommend AND TID = 0 AND visible AND view_count >= 10
118	sysadm	1.10	AND (sub_dt >= SUBDATE(NOW(), INTERVAL 7 DAY))
119	sysadm	1.6	ORDER BY excerption DESC, (view_count + reply_count) DESC, transship
120			LIMIT 10";
121	sysadm	1.1
122	sysadm	1.6	$rs = mysqli_query($db_conn, $sql);
123			if ($rs == false)
124			{
125			echo("Query data error: " . mysqli_error($db_conn));
126			exit();
127			}
128	sysadm	1.1
129			echo ("<tr><td height=8></td></tr>\n");
130	sysadm	1.11
131	sysadm	1.6	while ($row = mysqli_fetch_array($rs))
132	sysadm	1.1	{
133	sysadm	1.11	echo ("<tr><td height=18>·<a href=\"../bbs/view_article.php?tn=portal&id=" . $row["AID"] . "\" target=_blank>" .
134	sysadm	1.8	htmlspecialchars(split_line("[" . $row["s_title"] . "] " . $row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') .
135	sysadm	1.11	"</a></td></tr>\n");
136	sysadm	1.1	}
137	sysadm	1.11	mysqli_free_result($rs);
138
139	sysadm	1.1	echo ("<tr><td height=8></td></tr>\n");
140			}
141
142	sysadm	1.6	function load_recommend($num, $length, $db_conn)
143	sysadm	1.1	{
144	sysadm	1.11	$sql = "SELECT AID, title FROM bbs WHERE TID = 0 AND recommend AND visible
145			ORDER BY sub_dt DESC LIMIT $num";
146
147			$rs = mysqli_query($db_conn, $sql);
148			if ($rs == false)
149			{
150			echo("Query data error: " . mysqli_error($db_conn));
151			exit();
152			}
153	sysadm	1.1
154			echo ("<tr class=title_list><td height=8></td></tr>\n");
155	sysadm	1.11
156			while ($row = mysqli_fetch_array($rs))
157	sysadm	1.1	{
158	sysadm	1.11	echo ("<tr class=title_list><td height=18>·<a href=\"../bbs/view_article.php?tn=portal&id=" . $row["AID"] . "\" target=_blank>" .
159	sysadm	1.6	htmlspecialchars(split_line($row["title"], "", $length, 1), ENT_HTML401, 'UTF-8') .
160	sysadm	1.11	"</a></td></tr>\n");
161	sysadm	1.1	}
162	sysadm	1.11	mysql_free_result($rs);
163
164	sysadm	1.1	echo ("<tr class=title_list><td height=8></td></tr>\n");
165			}
166			?>
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1