/[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.5 - (show annotations)
Thu Oct 30 15:52:32 2025 UTC (4 months, 2 weeks ago) by sysadm
Branch: MAIN
CVS Tags: HEAD
Changes since 1.4: +0 -1 lines
Update width limit

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 "current_action" => array(),
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, current_action FROM user_online WHERE UID = $uid
89 AND last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)
90 ORDER BY last_tm DESC";
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 while ($row = mysqli_fetch_array($rs))
103 {
104 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 }
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