fenglin/bbs/section_setting.php

<?
        require_once "../lib/db_open.inc.php";
        require_once "./session_init.inc.php";
        require_once "./theme.inc.php";

        force_login();

        $result_set = array(
                "return" => array(
                        "code" => 0,
                        "message" => "",
                        "errorFields" => array(),
                )
        );

        $sid = (isset($_GET["sid"]) ? intval($_GET["sid"]) : $BBS_default_sid);

        if (!$_SESSION["BBS_priv"]->checkpriv($sid, S_POST | S_MAN_S))
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "没有权限";

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        // Load section setting
        $sql = "SELECT * FROM section_config WHERE SID = $sid AND enable";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Query section data error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        if ($row = mysqli_fetch_array($rs))
        {
                $result_set["data"] = array(
                        "sid" => $sid,
                        "announcement" => $row["announcement"],
                        "comment" => $row["comment"],
                        "ex_update" => $row["ex_update"],
                        "section_hierachy" => array(),
                        "masters" => array(),
                );
        }
        else
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "Section data not exist";

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        mysqli_free_result($rs);

        // Load section master
        $sql = "SELECT section_master.UID, username, major, begin_dt, end_dt FROM section_master
                        INNER JOIN user_list ON section_master.UID = user_list.UID
                        WHERE SID = $sid AND section_master.enable AND (NOW() BETWEEN begin_dt AND end_dt)
                        ORDER BY major DESC, begin_dt ASC, end_dt ASC";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Query section master error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        while ($row = mysqli_fetch_array($rs))
        {
                array_push($result_set["data"]["masters"], array(
                        "uid" => $row["UID"],
                        "username" => $row["username"],
                        "major" => $row["major"],
                        "begin_dt" => $row["begin_dt"],
                        "end_dt" => $row["end_dt"],
                ));
        }
        mysqli_free_result($rs);

        // Load section list
        $sql = "SELECT SID, section_config.CID, section_config.title AS s_title, section_class.title AS c_title
                        FROM section_config INNER JOIN section_class ON section_config.CID = section_class.CID
                        WHERE section_class.enable AND section_config.enable
                        ORDER BY section_class.sort_order, section_config.sort_order";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Query section error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        $last_cid = -1;
        $last_c_title = "";
        $section_list = array();
        while ($row = mysqli_fetch_array($rs))
        {
                if ($row["CID"] != $last_cid)
                {
                        if (count($section_list) > 0)
                        {
                                array_push($result_set["data"]["section_hierachy"], array(
                                        "cid" => $last_cid,
                                        "title" => $last_c_title,
                                        "sections" => $section_list,
                                ));

                                $section_list = array();
                        }

                        $last_cid = $row["CID"];
                        $last_c_title = $row["c_title"];
                }

                if ($_SESSION["BBS_priv"]->checkpriv($row["SID"], S_POST | S_MAN_S))
                {
                        array_push($section_list, array(
                                "sid" => $row["SID"],
                                "title" => $row["s_title"],
                        ));
                }
        }

        if (count($section_list) > 0)
        {
                array_push($result_set["data"]["section_hierachy"], array(
                        "cid" => $last_cid,
                        "title" => $last_c_title,
                        "sections" => $section_list,
                ));
        }

        mysqli_free_result($rs);

        mysqli_close($db_conn);

        // Output with theme view
        $theme_view_file = get_theme_file("view/section_setting", $_SESSION["BBS_theme_name"]);
        if ($theme_view_file == null)
        {
                exit(json_encode($result_set)); // Output data in Json
        }
        include $theme_view_file;
?>
1	sysadm	1.1	<?
2			require_once "../lib/db_open.inc.php";
3			require_once "./session_init.inc.php";
4			require_once "./theme.inc.php";
5
6			force_login();
7
8			$result_set = array(
9			"return" => array(
10			"code" => 0,
11			"message" => "",
12			"errorFields" => array(),
13			)
14			);
15
16			$sid = (isset($_GET["sid"]) ? intval($_GET["sid"]) : $BBS_default_sid);
17
18			if (!$_SESSION["BBS_priv"]->checkpriv($sid, S_POST \| S_MAN_S))
19			{
20			$result_set["return"]["code"] = -1;
21			$result_set["return"]["message"] = "没有权限";
22
23			mysqli_close($db_conn);
24			exit(json_encode($result_set));
25			}
26
27	sysadm	1.3	// Load section setting
28	sysadm	1.1	$sql = "SELECT * FROM section_config WHERE SID = $sid AND enable";
29
30			$rs = mysqli_query($db_conn, $sql);
31			if ($rs == false)
32			{
33			$result_set["return"]["code"] = -2;
34			$result_set["return"]["message"] = "Query section data error: " . mysqli_error($db_conn);
35
36			mysqli_close($db_conn);
37			exit(json_encode($result_set));
38			}
39
40	sysadm	1.3	if ($row = mysqli_fetch_array($rs))
41	sysadm	1.1	{
42	sysadm	1.2	$result_set["data"] = array(
43	sysadm	1.1	"sid" => $sid,
44			"announcement" => $row["announcement"],
45			"comment" => $row["comment"],
46			"ex_update" => $row["ex_update"],
47	sysadm	1.2	"section_hierachy" => array(),
48	sysadm	1.3	"masters" => array(),
49	sysadm	1.1	);
50			}
51			else
52			{
53			$result_set["return"]["code"] = -1;
54			$result_set["return"]["message"] = "Section data not exist";
55
56			mysqli_close($db_conn);
57			exit(json_encode($result_set));
58			}
59
60			mysqli_free_result($rs);
61
62	sysadm	1.3	// Load section master
63			$sql = "SELECT section_master.UID, username, major, begin_dt, end_dt FROM section_master
64			INNER JOIN user_list ON section_master.UID = user_list.UID
65			WHERE SID = $sid AND section_master.enable AND (NOW() BETWEEN begin_dt AND end_dt)
66			ORDER BY major DESC, begin_dt ASC, end_dt ASC";
67
68			$rs = mysqli_query($db_conn, $sql);
69			if ($rs == false)
70			{
71			$result_set["return"]["code"] = -2;
72			$result_set["return"]["message"] = "Query section master error: " . mysqli_error($db_conn);
73
74			mysqli_close($db_conn);
75			exit(json_encode($result_set));
76			}
77
78			while ($row = mysqli_fetch_array($rs))
79			{
80			array_push($result_set["data"]["masters"], array(
81			"uid" => $row["UID"],
82			"username" => $row["username"],
83			"major" => $row["major"],
84			"begin_dt" => $row["begin_dt"],
85			"end_dt" => $row["end_dt"],
86			));
87			}
88			mysqli_free_result($rs);
89
90	sysadm	1.2	// Load section list
91			$sql = "SELECT SID, section_config.CID, section_config.title AS s_title, section_class.title AS c_title
92			FROM section_config INNER JOIN section_class ON section_config.CID = section_class.CID
93			WHERE section_class.enable AND section_config.enable
94			ORDER BY section_class.sort_order, section_config.sort_order";
95	sysadm	1.1
96			$rs = mysqli_query($db_conn, $sql);
97			if ($rs == false)
98			{
99			$result_set["return"]["code"] = -2;
100	sysadm	1.2	$result_set["return"]["message"] = "Query section error: " . mysqli_error($db_conn);
101	sysadm	1.1
102			mysqli_close($db_conn);
103			exit(json_encode($result_set));
104			}
105
106	sysadm	1.2	$last_cid = -1;
107			$last_c_title = "";
108			$section_list = array();
109			while ($row = mysqli_fetch_array($rs))
110			{
111			if ($row["CID"] != $last_cid)
112			{
113			if (count($section_list) > 0)
114			{
115			array_push($result_set["data"]["section_hierachy"], array(
116			"cid" => $last_cid,
117			"title" => $last_c_title,
118			"sections" => $section_list,
119			));
120
121			$section_list = array();
122			}
123
124			$last_cid = $row["CID"];
125			$last_c_title = $row["c_title"];
126			}
127
128			if ($_SESSION["BBS_priv"]->checkpriv($row["SID"], S_POST \| S_MAN_S))
129			{
130			array_push($section_list, array(
131			"sid" => $row["SID"],
132			"title" => $row["s_title"],
133			));
134			}
135			}
136	sysadm	1.1
137	sysadm	1.2	if (count($section_list) > 0)
138	sysadm	1.1	{
139	sysadm	1.2	array_push($result_set["data"]["section_hierachy"], array(
140			"cid" => $last_cid,
141			"title" => $last_c_title,
142			"sections" => $section_list,
143	sysadm	1.1	));
144			}
145	sysadm	1.2
146	sysadm	1.1	mysqli_free_result($rs);
147
148			mysqli_close($db_conn);
149
150			// Output with theme view
151			$theme_view_file = get_theme_file("view/section_setting", $_SESSION["BBS_theme_name"]);
152			if ($theme_view_file == null)
153			{
154			exit(json_encode($result_set)); // Output data in Json
155			}
156			include $theme_view_file;
157			?>
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1