/[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.2 - (show annotations)
Tue Apr 29 11:55:32 2025 UTC (10 months, 2 weeks ago) by sysadm
Branch: MAIN
Changes since 1.1: +0 -1 lines
Remove redundant PHP closing tag

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;

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