/[LeafOK_CVS]/fenglin/bbs/view_user.php
ViewVC logotype

Contents of /fenglin/bbs/view_user.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.3 - (show annotations)
Wed Jun 18 05:11:02 2025 UTC (8 months, 4 weeks ago) by sysadm
Branch: MAIN
Changes since 1.2: +3 -1 lines
Display user current action

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 "current_action" => "",
70 "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 ip, last_tm, current_action FROM user_online WHERE UID = $uid
90 ORDER BY last_tm DESC LIMIT 1";
91
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 if ($row = mysqli_fetch_array($rs))
103 {
104 $result_set["data"]["online"] = ($row["timeout"] == 0);
105 $result_set["data"]["ip"] = ip_mask($row["ip"], $ip_mask_level);
106 $result_set["data"]["last_tm"] = (new DateTimeImmutable($row["last_tm"]))->setTimezone($_SESSION["BBS_user_tz"]);
107 $result_set["data"]["current_action"] = $row["current_action"];
108 }
109 mysqli_free_result($rs);
110
111 $sql = "SELECT * FROM friend_list WHERE UID = " . $_SESSION["BBS_uid"] .
112 " AND fUID = $uid";
113
114 $rs = mysqli_query($db_conn, $sql);
115 if ($rs == false)
116 {
117 $result_set["return"]["code"] = -2;
118 $result_set["return"]["message"] = "Query friend error: " . mysqli_error($db_conn);
119
120 mysqli_close($db_conn);
121 exit(json_encode($result_set));
122 }
123
124 $result_set["data"]["is_friend"] = (mysqli_num_rows($rs) > 0);
125 mysqli_free_result($rs);
126
127 $result_set["data"]["photo"] = photo_path($uid, $db_conn);
128
129 // Load section list
130 $ret = load_section_list($result_set["data"]["section_hierachy"],
131 function (array $section, array $filter_param) : bool
132 {
133 return $_SESSION["BBS_priv"]->checkpriv($section["SID"], S_MAN_M);
134 },
135 function (array $section, array $filter_param) : mixed
136 {
137 return null;
138 },
139 $db_conn);
140
141 if ($ret == false)
142 {
143 $result_set["return"]["code"] = -2;
144 $result_set["return"]["message"] = "Query section error: " . mysqli_error($db_conn);
145
146 mysqli_close($db_conn);
147 exit(json_encode($result_set));
148 }
149
150 mysqli_close($db_conn);
151
152 // Output with theme view
153 $theme_view_file = get_theme_file("view/view_user", $_SESSION["BBS_theme_name"]);
154 if ($theme_view_file == null)
155 {
156 exit(json_encode($result_set)); // Output data in Json
157 }
158 include $theme_view_file;

webmaster@leafok.com
ViewVC Help
Powered by ViewVC 1.3.0-beta1