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"]),
                "current_action" => array(),
                "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, current_action FROM user_online WHERE UID = $uid
                        AND last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)
                        ORDER BY last_tm DESC";

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

        while ($row = mysqli_fetch_array($rs))
        {
                if ($result_set["data"]["online"] == false)
                {
                        $result_set["data"]["online"] = true;
                        $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"]);
                }
                array_push($result_set["data"]["current_action"], $row["current_action"]);
        }
        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	sysadm	1.4	"current_action" => array(),
70	sysadm	1.1	"ip" => "",
71			"is_friend" => false,
72			"photo" => "",
73			"section_hierachy" => array(),
74			);
75
76			if (!in_array($row["life"], $BBS_life_immortal))
77			{
78			$result_set["data"]["life"] = $row["life"] - $row["day"] - 1;
79			if ($result_set["data"]["life"] < 0)
80			{
81			$result_set["data"]["life"] = 0;
82			$result_set["data"]["dead"] = true;
83			}
84			}
85
86			mysqli_free_result($rs);
87
88			$sql = "SELECT IF(last_tm < SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND), 1, 0) AS timeout,
89	sysadm	1.3	ip, last_tm, current_action FROM user_online WHERE UID = $uid
90	sysadm	1.4	AND last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)
91			ORDER BY last_tm DESC";
92	sysadm	1.1
93			$rs = mysqli_query($db_conn, $sql);
94			if ($rs == false)
95			{
96			$result_set["return"]["code"] = -2;
97			$result_set["return"]["message"] = "Query online user error: " . mysqli_error($db_conn);
98
99			mysqli_close($db_conn);
100			exit(json_encode($result_set));
101			}
102
103	sysadm	1.4	while ($row = mysqli_fetch_array($rs))
104	sysadm	1.1	{
105	sysadm	1.4	if ($result_set["data"]["online"] == false)
106			{
107			$result_set["data"]["online"] = true;
108			$result_set["data"]["ip"] = ip_mask($row["ip"], $ip_mask_level);
109			$result_set["data"]["last_tm"] = (new DateTimeImmutable($row["last_tm"]))->setTimezone($_SESSION["BBS_user_tz"]);
110			}
111			array_push($result_set["data"]["current_action"], $row["current_action"]);
112	sysadm	1.1	}
113			mysqli_free_result($rs);
114
115			$sql = "SELECT * FROM friend_list WHERE UID = " . $_SESSION["BBS_uid"] .
116			" AND fUID = $uid";
117
118			$rs = mysqli_query($db_conn, $sql);
119			if ($rs == false)
120			{
121			$result_set["return"]["code"] = -2;
122			$result_set["return"]["message"] = "Query friend error: " . mysqli_error($db_conn);
123
124			mysqli_close($db_conn);
125			exit(json_encode($result_set));
126			}
127
128			$result_set["data"]["is_friend"] = (mysqli_num_rows($rs) > 0);
129			mysqli_free_result($rs);
130
131			$result_set["data"]["photo"] = photo_path($uid, $db_conn);
132
133			// Load section list
134			$ret = load_section_list($result_set["data"]["section_hierachy"],
135			function (array $section, array $filter_param) : bool
136			{
137			return $_SESSION["BBS_priv"]->checkpriv($section["SID"], S_MAN_M);
138			},
139			function (array $section, array $filter_param) : mixed
140			{
141			return null;
142			},
143			$db_conn);
144
145			if ($ret == false)
146			{
147			$result_set["return"]["code"] = -2;
148			$result_set["return"]["message"] = "Query section error: " . mysqli_error($db_conn);
149
150			mysqli_close($db_conn);
151			exit(json_encode($result_set));
152			}
153
154			mysqli_close($db_conn);
155
156			// Output with theme view
157			$theme_view_file = get_theme_file("view/view_user", $_SESSION["BBS_theme_name"]);
158			if ($theme_view_file == null)
159			{
160			exit(json_encode($result_set)); // Output data in Json
161			}
162			include $theme_view_file;
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1