fenglin/bbs/view_user.php

<?php
        require_once "../lib/db_open.inc.php";
        require_once "../lib/lml.inc.php";
        require_once "../lib/ip_mask.inc.php";
        require_once "./section_list.inc.php";
        require_once "./session_init.inc.php";
        require_once "./user_level.inc.php";
        require_once "./user_photo_path.inc.php";
        require_once "./theme.inc.php";

        force_login();

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

        $uid = (isset($_GET["uid"]) ? intval($_GET["uid"]) : 0);
        $ip_mask_level = ($_SESSION["BBS_priv"]->checklevel(P_ADMIN_M | P_ADMIN_S) ? 1 : 2);

        $sql = "SELECT user_list.*, user_reginfo.*, user_pubinfo.*,
                        DATEDIFF(NOW(), last_login_dt) AS day
                        FROM user_list INNER JOIN user_reginfo ON user_list.UID = user_reginfo.UID
                        INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID
                        WHERE user_list.UID = $uid AND enable";

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

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

        if (!($row = mysqli_fetch_array($rs)))
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "用户数据不存在！";

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

        // Fill up result data
        $result_set["data"] = array(
                "uid" => $uid,
                "username" => $row["username"],
                "nickname" => $row["nickname"],
                "verified" => $row["verified"],
                "p_login" => $row["p_login"],
                "p_post" => $row["p_post"],
                "p_msg" => $row["p_msg"],
                "p_all" => ($row["p_login"] && $row["p_post"] && $row["p_msg"]),
                "birthday" => (new DateTimeImmutable($row["birthday"])),
                "gender" => $row["gender"],
                "gender_pub" => $row["gender_pub"],
                "signup_dt" => (new DateTimeImmutable($row["signup_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
                "introduction" => $row["introduction"],
                "exp" => $row["exp"],
                "life" => $row["life"],
                "dead" => false,
                "online" => false,
                "last_tm" => (new DateTimeImmutable($row["last_login_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
                "ip" => "",
                "is_friend" => false,
                "photo" => "",
                "section_hierachy" => array(),
                );

        if (!in_array($row["life"], $BBS_life_immortal))
        {
                $result_set["data"]["life"] = $row["life"] - $row["day"] - 1;
                if ($result_set["data"]["life"] < 0)
                {
                        $result_set["data"]["life"] = 0;
                        $result_set["data"]["dead"] = true;
                }
        }

        mysqli_free_result($rs);

        $sql = "SELECT IF(last_tm < SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND), 1, 0) AS timeout,
                        ip, last_tm FROM user_online WHERE UID = $uid
                        ORDER BY last_tm DESC LIMIT 1";

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

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

        if ($row = mysqli_fetch_array($rs))
        {
                $result_set["data"]["online"] = ($row["timeout"] == 0);
                $result_set["data"]["ip"] = ip_mask($row["ip"], $ip_mask_level);
                $result_set["data"]["last_tm"] = (new DateTimeImmutable($row["last_tm"]))->setTimezone($_SESSION["BBS_user_tz"]);
        }
        mysqli_free_result($rs);

        $sql = "SELECT * FROM friend_list WHERE UID = " . $_SESSION["BBS_uid"] .
                        " AND fUID = $uid";

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

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

        $result_set["data"]["is_friend"] = (mysqli_num_rows($rs) > 0);
        mysqli_free_result($rs);

        $result_set["data"]["photo"] = photo_path($uid, $db_conn);

        // Load section list
        $ret = load_section_list($result_set["data"]["section_hierachy"],
                function (array $section, array $filter_param) : bool
                {
                        return $_SESSION["BBS_priv"]->checkpriv($section["SID"], S_MAN_M);
                },
                function (array $section, array $filter_param) : mixed
                {
                        return null;
                },
                $db_conn);

        if ($ret == 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));
        }

        mysqli_close($db_conn);

        // Output with theme view
        $theme_view_file = get_theme_file("view/view_user", $_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	<?php
2			require_once "../lib/db_open.inc.php";
3			require_once "../lib/lml.inc.php";
4			require_once "../lib/ip_mask.inc.php";
5			require_once "./section_list.inc.php";
6			require_once "./session_init.inc.php";
7			require_once "./user_level.inc.php";
8			require_once "./user_photo_path.inc.php";
9			require_once "./theme.inc.php";
10
11			force_login();
12
13			$result_set = array(
14			"return" => array(
15			"code" => 0,
16			"message" => "",
17			"errorFields" => array(),
18			)
19			);
20
21			$uid = (isset($_GET["uid"]) ? intval($_GET["uid"]) : 0);
22			$ip_mask_level = ($_SESSION["BBS_priv"]->checklevel(P_ADMIN_M \| P_ADMIN_S) ? 1 : 2);
23
24			$sql = "SELECT user_list., user_reginfo., user_pubinfo.*,
25			DATEDIFF(NOW(), last_login_dt) AS day
26			FROM user_list INNER JOIN user_reginfo ON user_list.UID = user_reginfo.UID
27			INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID
28			WHERE user_list.UID = $uid 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 user info error: " . mysqli_error($db_conn);
35
36			mysqli_close($db_conn);
37			exit(json_encode($result_set));
38			}
39
40			if (!($row = mysqli_fetch_array($rs)))
41			{
42			$result_set["return"]["code"] = -1;
43			$result_set["return"]["message"] = "用户数据不存在！";
44
45			mysqli_close($db_conn);
46			exit(json_encode($result_set));
47			}
48
49			// Fill up result data
50			$result_set["data"] = array(
51			"uid" => $uid,
52			"username" => $row["username"],
53			"nickname" => $row["nickname"],
54			"verified" => $row["verified"],
55			"p_login" => $row["p_login"],
56			"p_post" => $row["p_post"],
57			"p_msg" => $row["p_msg"],
58			"p_all" => ($row["p_login"] && $row["p_post"] && $row["p_msg"]),
59			"birthday" => (new DateTimeImmutable($row["birthday"])),
60			"gender" => $row["gender"],
61			"gender_pub" => $row["gender_pub"],
62			"signup_dt" => (new DateTimeImmutable($row["signup_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
63			"introduction" => $row["introduction"],
64			"exp" => $row["exp"],
65			"life" => $row["life"],
66			"dead" => false,
67			"online" => false,
68			"last_tm" => (new DateTimeImmutable($row["last_login_dt"]))->setTimezone($_SESSION["BBS_user_tz"]),
69			"ip" => "",
70			"is_friend" => false,
71			"photo" => "",
72			"section_hierachy" => array(),
73			);
74
75			if (!in_array($row["life"], $BBS_life_immortal))
76			{
77			$result_set["data"]["life"] = $row["life"] - $row["day"] - 1;
78			if ($result_set["data"]["life"] < 0)
79			{
80			$result_set["data"]["life"] = 0;
81			$result_set["data"]["dead"] = true;
82			}
83			}
84
85			mysqli_free_result($rs);
86
87			$sql = "SELECT IF(last_tm < SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND), 1, 0) AS timeout,
88			ip, last_tm FROM user_online WHERE UID = $uid
89			ORDER BY last_tm DESC LIMIT 1";
90
91			$rs = mysqli_query($db_conn, $sql);
92			if ($rs == false)
93			{
94			$result_set["return"]["code"] = -2;
95			$result_set["return"]["message"] = "Query online user error: " . mysqli_error($db_conn);
96
97			mysqli_close($db_conn);
98			exit(json_encode($result_set));
99			}
100
101			if ($row = mysqli_fetch_array($rs))
102			{
103			$result_set["data"]["online"] = ($row["timeout"] == 0);
104			$result_set["data"]["ip"] = ip_mask($row["ip"], $ip_mask_level);
105			$result_set["data"]["last_tm"] = (new DateTimeImmutable($row["last_tm"]))->setTimezone($_SESSION["BBS_user_tz"]);
106			}
107			mysqli_free_result($rs);
108
109			$sql = "SELECT * FROM friend_list WHERE UID = " . $_SESSION["BBS_uid"] .
110			" AND fUID = $uid";
111
112			$rs = mysqli_query($db_conn, $sql);
113			if ($rs == false)
114			{
115			$result_set["return"]["code"] = -2;
116			$result_set["return"]["message"] = "Query friend error: " . mysqli_error($db_conn);
117
118			mysqli_close($db_conn);
119			exit(json_encode($result_set));
120			}
121
122			$result_set["data"]["is_friend"] = (mysqli_num_rows($rs) > 0);
123			mysqli_free_result($rs);
124
125			$result_set["data"]["photo"] = photo_path($uid, $db_conn);
126
127			// Load section list
128			$ret = load_section_list($result_set["data"]["section_hierachy"],
129			function (array $section, array $filter_param) : bool
130			{
131			return $_SESSION["BBS_priv"]->checkpriv($section["SID"], S_MAN_M);
132			},
133			function (array $section, array $filter_param) : mixed
134			{
135			return null;
136			},
137			$db_conn);
138
139			if ($ret == false)
140			{
141			$result_set["return"]["code"] = -2;
142			$result_set["return"]["message"] = "Query section error: " . mysqli_error($db_conn);
143
144			mysqli_close($db_conn);
145			exit(json_encode($result_set));
146			}
147
148			mysqli_close($db_conn);
149
150			// Output with theme view
151			$theme_view_file = get_theme_file("view/view_user", $_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