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

Diff of /fenglin/bbs/search_user.php

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 1.16 by sysadm, Fri Apr 4 05:27:31 2025 UTC Revision 1.17 by sysadm, Fri Apr 4 05:59:31 2025 UTC
# Line 13  $friend = (isset($_GET["friend"]) && $_G Line 13  $friend = (isset($_GET["friend"]) && $_G
13  $search_text = (isset($_GET["search_text"]) ? $_GET["search_text"] : "");  $search_text = (isset($_GET["search_text"]) ? $_GET["search_text"] : "");
14    
15  $sql = "SELECT IF(UID = 0, 1, 0) AS is_guest, COUNT(*) AS u_count FROM user_online  $sql = "SELECT IF(UID = 0, 1, 0) AS is_guest, COUNT(*) AS u_count FROM user_online
16                  WHERE last_tm >= SUBDATE(NOW(), INTERVAL '$BBS_user_off_line' SECOND)                  WHERE last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)
17                  GROUP BY is_guest";                  GROUP BY is_guest";
18    
19  $rs = mysqli_query($db_conn, $sql);  $rs = mysqli_query($db_conn, $sql);
# Line 46  $sql = "SELECT COUNT(user_list.UID) AS r Line 46  $sql = "SELECT COUNT(user_list.UID) AS r
46                  " WHERE user_list.enable AND ".                  " WHERE user_list.enable AND ".
47                  ($type == 1 ? "nickname" : "username") .                  ($type == 1 ? "nickname" : "username") .
48                  " LIKE '%" . mysqli_real_escape_string($db_conn, $search_text) . "%'" .                  " LIKE '%" . mysqli_real_escape_string($db_conn, $search_text) . "%'" .
49                  ($online ? " AND last_tm >= SUBDATE(NOW(), INTERVAL '$BBS_user_off_line' SECOND)" : "").                  ($online ? " AND last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)" : "").
50                  ($friend ? " AND friend_list.UID = " . $_SESSION["BBS_uid"] : "");                  ($friend ? " AND friend_list.UID = " . $_SESSION["BBS_uid"] : "");
51    
52  $rs = mysqli_query($db_conn, $sql);  $rs = mysqli_query($db_conn, $sql);
# Line 185  $sql = "SELECT user_list.UID, username, Line 185  $sql = "SELECT user_list.UID, username,
185                  " INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID WHERE user_list.enable AND ".                  " INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID WHERE user_list.enable AND ".
186                  ($type == 1 ? "nickname" : "username") .                  ($type == 1 ? "nickname" : "username") .
187                  " LIKE '%" . mysqli_real_escape_string($db_conn, $search_text) . "%'" .                  " LIKE '%" . mysqli_real_escape_string($db_conn, $search_text) . "%'" .
188                  ($online ? " AND last_tm >= SUBDATE(NOW(), INTERVAL '$BBS_user_off_line' SECOND)" : "").                  ($online ? " AND last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)" : "").
189                  ($friend ? " AND friend_list.UID = " . $_SESSION["BBS_uid"] : "") .                  ($friend ? " AND friend_list.UID = " . $_SESSION["BBS_uid"] : "") .
190                  " ORDER BY " . ($type == 1 ? "nickname" : "username") .                  " ORDER BY " . ($type == 1 ? "nickname" : "username") .
191                  " LIMIT " . ($page-1) * $rpp . ", $rpp";                  " LIMIT " . ($page-1) * $rpp . ", $rpp";

Legend:
Removed lines/characters  
Changed lines/characters
  Added lines/characters
webmaster@leafok.com
 ViewVC Help
Powered by ViewVC 1.3.0-beta1