fenglin/bbs/view_user.php

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