| 1 |
<? |
<? |
| 2 |
|
require_once "../lib/db_open.inc.php"; |
| 3 |
require_once "./session_init.inc.php"; |
require_once "./session_init.inc.php"; |
| 4 |
|
require_once "./user_level.inc.php"; |
| 5 |
?> |
?> |
| 6 |
<? |
<? |
| 7 |
set_user_action("search_user"); |
$page = (isset($_GET["page"]) ? intval($_GET["page"]) : 1); |
| 8 |
|
$rpp = (isset($_GET["rpp"]) ? intval($_GET["rpp"]) : 20); |
|
$page_max_record=60; |
|
| 9 |
|
|
| 10 |
if (isset($_GET["page"])) |
$type = (isset($_GET["type"]) ? intval($_GET["type"]) : 0); |
| 11 |
$page=intval($_GET["page"]); |
$online = (isset($_GET["online"]) && $_GET["online"] == "1" ? 1 : 0); |
| 12 |
else |
$friend = (isset($_GET["friend"]) && $_GET["friend"] == "1" ? 1 : 0); |
| 13 |
$page=1; |
$search_text = (isset($_GET["search_text"]) ? $_GET["search_text"] : ""); |
| 14 |
if ($page<1) |
|
| 15 |
$page=1; |
$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) |
| 17 |
|
GROUP BY is_guest"; |
| 18 |
|
|
| 19 |
if (isset($_GET["type"])) |
$rs = mysqli_query($db_conn, $sql); |
| 20 |
$type=intval($_GET["type"]); |
if ($rs == false) |
| 21 |
else |
{ |
| 22 |
$type=1; |
echo("Count online user error" . mysqli_error($db_conn)); |
| 23 |
|
exit(); |
| 24 |
|
} |
| 25 |
|
|
| 26 |
if (isset($_GET["search_text"])) |
$guest_online = 0; |
| 27 |
$search_text=trim($_GET["search_text"]); |
$user_online = 0; |
|
else |
|
|
$search_text=""; |
|
|
$search_author=addslashes(stripslashes($search_text)); |
|
| 28 |
|
|
| 29 |
$db_conn=include "./db_open.inc.php"; |
while ($row = mysqli_fetch_array($rs)) |
| 30 |
|
{ |
| 31 |
|
if ($row["is_guest"]) |
| 32 |
|
{ |
| 33 |
|
$guest_online = $row["u_count"]; |
| 34 |
|
} |
| 35 |
|
else |
| 36 |
|
{ |
| 37 |
|
$user_online = $row["u_count"]; |
| 38 |
|
} |
| 39 |
|
} |
| 40 |
|
mysqli_free_result($rs); |
| 41 |
|
|
| 42 |
|
$sql = "SELECT COUNT(user_list.UID) AS rec_count FROM user_list" . |
| 43 |
|
($online ? " INNER JOIN user_online ON user_list.UID = user_online.UID" : "") . |
| 44 |
|
($friend ? " INNER JOIN friend_list ON user_list.UID = friend_list.fUID" : "") . |
| 45 |
|
($type == 1 ? " INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID" : "") . |
| 46 |
|
" WHERE user_list.enable AND ". |
| 47 |
|
($type == 1 ? "nickname" : "username") . |
| 48 |
|
" LIKE '%" . mysqli_real_escape_string($db_conn, $search_text) . "%'" . |
| 49 |
|
($online ? " AND last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)" : ""). |
| 50 |
|
($friend ? " AND friend_list.UID = " . $_SESSION["BBS_uid"] : ""); |
| 51 |
|
|
| 52 |
$rs=mysql_query("select count(user_list.UID) as rec_count from user_list". |
$rs = mysqli_query($db_conn, $sql); |
| 53 |
" inner join user_pubinfo on user_list.UID=user_pubinfo.UID where". |
if ($rs == false) |
| 54 |
" user_list.enable and ".($type==1?"user_pubinfo.nickname":"user_list.username"). |
{ |
| 55 |
" like '%$search_author%'") |
echo("Query user error" . mysqli_error($db_conn)); |
| 56 |
or die("Query user error!"); |
exit(); |
| 57 |
|
} |
| 58 |
|
|
| 59 |
$row=mysql_fetch_array($rs); |
if ($row = mysqli_fetch_array($rs)) |
| 60 |
$toa=$u_count=$row["rec_count"]; |
{ |
| 61 |
|
$toa = $row["rec_count"]; |
| 62 |
|
} |
| 63 |
|
|
| 64 |
mysql_free_result($rs); |
mysqli_free_result($rs); |
| 65 |
|
|
| 66 |
if ($toa==0) |
$page_total = ceil($toa / $rpp); |
| 67 |
$toa=1; |
if ($page > $page_total) |
| 68 |
|
{ |
| 69 |
|
$page = $page_total; |
| 70 |
|
} |
| 71 |
|
|
| 72 |
$page_total=intval($toa/$page_max_record); |
if ($page <= 0) |
| 73 |
if (($toa % $page_max_record)>0) |
{ |
| 74 |
$page_total++; |
$page = 1; |
| 75 |
if ($page>$page_total) |
} |
|
$page=$page_total; |
|
| 76 |
?> |
?> |
| 77 |
<html> |
<html> |
| 78 |
<head> |
<head> |
| 79 |
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> |
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| 80 |
<title>用户查找结果</title> |
<title>鐢ㄦ埛鏌ユ壘缁撴灉</title> |
| 81 |
<link rel="stylesheet" href="css/default.css" type="text/css"> |
<link rel="stylesheet" href="css/default.css" type="text/css"> |
| 82 |
<script language="JavaScript" src="/js/nw_open.js"></script> |
<style type="text/css"> |
| 83 |
|
TD.head,TD.level,TD.login_dt,TD.dark,TD.username |
| 84 |
|
{ |
| 85 |
|
border-right: #d0d3F0 1px solid; |
| 86 |
|
border-left: #d0d3F0 1px solid; |
| 87 |
|
border-bottom: #d0d3F0 1px solid; |
| 88 |
|
} |
| 89 |
|
TD.head |
| 90 |
|
{ |
| 91 |
|
font-family: 妤蜂綋; |
| 92 |
|
color: #909090; |
| 93 |
|
} |
| 94 |
|
TD.login_dt,TD.level,TD.dark,TD.username |
| 95 |
|
{ |
| 96 |
|
text-align: center; |
| 97 |
|
} |
| 98 |
|
TD.login_dt,TD.dark |
| 99 |
|
{ |
| 100 |
|
color: #909090; |
| 101 |
|
background-color: #eaf0Fa; |
| 102 |
|
} |
| 103 |
|
TD.head,TD.level |
| 104 |
|
{ |
| 105 |
|
background-color: #fafbfc; |
| 106 |
|
} |
| 107 |
|
TD.level |
| 108 |
|
{ |
| 109 |
|
color: orange; |
| 110 |
|
} |
| 111 |
|
TD.username |
| 112 |
|
{ |
| 113 |
|
background-color: #fafbfc; |
| 114 |
|
} |
| 115 |
|
TD.username:hover |
| 116 |
|
{ |
| 117 |
|
background-color: #eaf0Fa; |
| 118 |
|
} |
| 119 |
|
</style> |
| 120 |
|
|
| 121 |
|
<script language="JavaScript" src="/js/nw_open.js"></script> |
| 122 |
|
<script language="JavaScript"> |
| 123 |
|
function ch_page(page) |
| 124 |
|
{ |
| 125 |
|
document.change_page.page.value = page; |
| 126 |
|
document.change_page.submit(); |
| 127 |
|
return false; |
| 128 |
|
} |
| 129 |
|
|
| 130 |
|
function ch_rpp() |
| 131 |
|
{ |
| 132 |
|
document.change_page.page.value = Math.floor(document.change_page.page.value * <? echo $rpp; ?> / document.change_page.rpp.value); |
| 133 |
|
document.change_page.submit(); |
| 134 |
|
return false; |
| 135 |
|
} |
| 136 |
|
</script> |
| 137 |
</head> |
</head> |
| 138 |
<body> |
<body> |
| 139 |
<center> |
<center> |
| 140 |
<table border="0" cellpadding="1" cellspacing="0" width="770"> |
<table cols="2" border="0" cellpadding="0" cellspacing="0" width="770"> |
| 141 |
<tr bgcolor="#d0d3F0" height="20"> |
<tr> |
| 142 |
<td align="center" class="title"> |
<td colspan="2" style="color:green;"> |
| 143 |
<? if ($u_count==0) |
<a class="s2" href="main.php"><? echo $BBS_name; ?></a>>>鏌ユ壘<? echo ($online?"鍦ㄧ嚎":""); ?><? echo ($friend?"濂藉弸":"鐢ㄦ埛"); ?> |
| 144 |
|
</td> |
| 145 |
|
</tr> |
| 146 |
|
<tr bgcolor="#d0d3F0" height="2"> |
| 147 |
|
<td colspan="2"></td></tr> |
| 148 |
|
<tr> |
| 149 |
|
<td class="dark" width="3%"></td> |
| 150 |
|
<td class="head" width="97%"> |
| 151 |
|
<? |
| 152 |
|
if ($toa==0) |
| 153 |
{ |
{ |
| 154 |
?> |
?>鏈壘鍒版寚瀹氱敤鎴<? |
| 155 |
未找到指定用户<? } |
} |
| 156 |
else |
else |
| 157 |
{ |
{ |
| 158 |
?>用户查找结果（共<? echo $u_count; ?>位）<? } ?> |
?>鐢ㄦ埛鏌ユ壘缁撴灉锛堝叡<? echo $toa; ?>浣嶏級 |
| 159 |
|
<? |
| 160 |
|
} |
| 161 |
|
?>锛堝綋鍓嶅湪绾挎敞鍐岀敤鎴<? echo $user_online; ?>浣嶏紝娓稿<? echo $guest_online; ?>浣嶏級 |
| 162 |
</td> |
</td> |
| 163 |
</tr> |
</tr> |
| 164 |
</table> |
</table> |
| 165 |
<table bgcolor="#f0F3Fa" border="0" cellpadding="5" cellspacing="0" width="770"> |
<table border="0" cellpadding="1" cellspacing="0" width="770"> |
| 166 |
<tr> |
<tr height="10"> |
| 167 |
<td width="5%"> |
<td> |
|
</td> |
|
|
<td width="15%"> |
|
|
</td> |
|
|
<td width="15%"> |
|
|
</td> |
|
|
<td width="15%"> |
|
|
</td> |
|
|
<td width="15%"> |
|
|
</td> |
|
|
<td width="15%"> |
|
|
</td> |
|
|
<td width="15%"> |
|
|
</td> |
|
|
<td width="5%"> |
|
| 168 |
</td> |
</td> |
| 169 |
</tr> |
</tr> |
| 170 |
<? |
</table> |
| 171 |
$color[0]="#f0F3Fa"; |
<table bgcolor="#f0F3Fa" border="0" cellpadding="0" cellspacing="0" width="770"> |
| 172 |
$color[1]="#FAFBFC"; |
<tr bgcolor="#d0d3F0" height="20"> |
| 173 |
$color_index=-1; |
<td class="title" width="4%"></td> |
| 174 |
$color_count=2; |
<td class="title" width="15%">鐢ㄦ埛ID</td> |
| 175 |
|
<td class="title" width="20%">鏄电О</td> |
| 176 |
|
<td class="title" width="12%">绛夌骇</td> |
| 177 |
|
<td class="title" width="18%">鏈鍚庣櫥闄嗘椂闂</td> |
| 178 |
|
<td class="title" width="27%"></td> |
| 179 |
|
<td class="title" width="4%"></td> |
| 180 |
|
</tr> |
| 181 |
|
<? |
| 182 |
|
$sql = "SELECT user_list.UID, username, nickname, exp, gender, gender_pub, last_login_dt FROM user_list" . |
| 183 |
|
($online ? " INNER JOIN user_online ON user_list.UID = user_online.UID" : "") . |
| 184 |
|
($friend ? " INNER JOIN friend_list ON user_list.UID = friend_list.fUID" : "") . |
| 185 |
|
" INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID WHERE user_list.enable AND ". |
| 186 |
|
($type == 1 ? "nickname" : "username") . |
| 187 |
|
" LIKE '%" . mysqli_real_escape_string($db_conn, $search_text) . "%'" . |
| 188 |
|
($online ? " AND last_tm >= SUBDATE(NOW(), INTERVAL $BBS_user_off_line SECOND)" : ""). |
| 189 |
|
($friend ? " AND friend_list.UID = " . $_SESSION["BBS_uid"] : "") . |
| 190 |
|
" ORDER BY " . ($type == 1 ? "nickname" : "username") . |
| 191 |
|
" LIMIT " . ($page-1) * $rpp . ", $rpp"; |
| 192 |
|
|
| 193 |
$rs=mysql_query("select user_list.UID,username,nickname,". |
$rs = mysqli_query($db_conn, $sql); |
| 194 |
"IF(user_pubinfo.gender_pub,IF(user_pubinfo.gender='M',". |
if ($rs == false) |
| 195 |
"'<font color=blue>♂</font>','<font color=red>♀</font>'),'') as gender". |
{ |
| 196 |
" from user_list". |
echo("Query user error" . mysqli_error($db_conn)); |
| 197 |
" inner join user_pubinfo on user_list.UID=user_pubinfo.UID where". |
exit(); |
| 198 |
" user_list.enable and ".($type==1?"user_pubinfo.nickname":"user_list.username"). |
} |
|
" like '%$search_author%' order by ".($type==1?"nickname":"username"). |
|
|
" limit ".($page-1)*$page_max_record.",$page_max_record") |
|
|
or die("Query user error!"); |
|
| 199 |
|
|
| 200 |
do |
while ($row = mysqli_fetch_array($rs)) |
| 201 |
{ |
{ |
|
$color_index=($color_index+1)%$color_count; |
|
| 202 |
?> |
?> |
| 203 |
<tr bgcolor="<? echo $color[$color_index]; ?>"> |
<tr height="25"> |
| 204 |
<td align="center"> |
<td class="dark"> |
| 205 |
</td> |
<? |
| 206 |
<? |
if ($row["gender_pub"]) |
|
for ($i=1; $i<=6; $i=$i+1) |
|
| 207 |
{ |
{ |
| 208 |
if ($row=mysql_fetch_array($rs)) |
if ($row["gender"] == 'M') |
| 209 |
{ |
{ |
| 210 |
?> |
echo ("<font color=blue>鈾</font>"); |
|
<td align="center" onmouseover="this.bgColor='#f0FaFf';" onmouseout="this.bgColor='<? echo $color[$color_index]; ?>';"> |
|
|
<? echo $row["gender"]; ?><a class="s2" href="javascript:show_profile(<? echo $row["UID"]; ?>)"><? echo ($type==1?$row["nickname"]:$row["username"]); ?></a> |
|
|
</td> |
|
|
<? |
|
| 211 |
} |
} |
| 212 |
else |
else |
| 213 |
{ |
{ |
| 214 |
|
echo ("<font color=red>鈾</font>"); |
| 215 |
|
} |
| 216 |
|
} |
| 217 |
|
else |
| 218 |
|
{ |
| 219 |
|
echo ("<font color=green>?</font>"); |
| 220 |
|
} |
| 221 |
?> |
?> |
|
<td align="center"> |
|
| 222 |
</td> |
</td> |
| 223 |
<? |
<td class="username"> |
| 224 |
} |
<a class="s2" href="" onclick="return show_profile(<? echo $row["UID"]; ?>);"><? echo $row["username"]; ?></a> |
| 225 |
} |
</td> |
| 226 |
|
<td class="dark"> |
| 227 |
|
<? echo $row["nickname"]; ?> |
| 228 |
|
</td> |
| 229 |
|
<td class="level"> |
| 230 |
|
<? echo user_level($row["exp"]); ?> |
| 231 |
|
</td> |
| 232 |
|
<td class="login_dt"> |
| 233 |
|
<? echo $row["last_login_dt"]; ?> |
| 234 |
|
</td> |
| 235 |
|
<td class="level"> |
| 236 |
|
<? |
| 237 |
|
if ($_SESSION["BBS_priv"]->checkpriv(0, S_MSG)) |
| 238 |
|
{ |
| 239 |
|
?> |
| 240 |
|
<a class="s2" href="" onclick="return NW_open('send_msg.php?user_id=<? echo $row["UID"]; ?>', 'send_msg', 500, 300);">鍙戦佹秷鎭</a> |
| 241 |
|
<? |
| 242 |
|
} |
| 243 |
?> |
?> |
| 244 |
|
</td> |
| 245 |
<td align="center"> |
<td align="center"> |
| 246 |
</td> |
</td> |
| 247 |
</tr> |
</tr> |
| 248 |
<? |
<? |
| 249 |
}while($row); |
} |
| 250 |
|
|
| 251 |
|
mysqli_free_result($rs); |
| 252 |
?> |
?> |
| 253 |
</table> |
</table> |
|
<? |
|
|
mysql_free_result($rs); |
|
|
mysql_close($db_conn); |
|
|
?> |
|
| 254 |
<table cols="3" border="0" cellpadding="5" cellspacing="0" width="770"> |
<table cols="3" border="0" cellpadding="5" cellspacing="0" width="770"> |
| 255 |
<tr bgcolor="#d0d3F0" height="10"> |
<tr bgcolor="#d0d3F0" height="10"> |
| 256 |
<td colspan="3" > |
<td colspan="3" > |
| 261 |
</td> |
</td> |
| 262 |
</tr> |
</tr> |
| 263 |
<tr> |
<tr> |
| 264 |
<td width="25%" align="center" style="color:#909090"> |
<form action="search_user.php" method="get" id="change_page" name="change_page"> |
| 265 |
<form action="search_user.php" method="get" id="change_page" name="change_page"> |
<td width="30%" style="color:#909090"> |
| 266 |
<input type="hidden" id="search_text" name="search_text" value="<? echo $search_text;?>"> |
姣忛〉<select size="1" id="rpp" name="rpp" onchange="ch_rpp();"> |
| 267 |
分页: <? echo $page; ?>/<? echo $page_total; ?>页 |
<? |
| 268 |
<? if ($page>1) |
foreach ($BBS_rpp_options as $v) |
| 269 |
{ |
{ |
| 270 |
?><a class="s8" title="首页" href="search_user.php?page=1&type=<? echo $type; ?><? if ($search_text!="") echo "&search_text=".$search_text;?>"><font face=webdings>9</font></a><a class="s8" title="上一页" href="search_user.php?page=<? echo $page-1; ?>&type=<? echo $type; ?><? if ($search_text!="") echo "&search_text=".$search_text;?>"><font face=webdings>7</font></a><? } |
echo ("<option value=\"$v\"" . ($v == $rpp ? " selected" : "") . ">$v</option>"); |
| 271 |
else |
} |
| 272 |
{ |
?> |
| 273 |
?><font face=webdings>97</font><? } ?> |
</select>浜 |
| 274 |
<input id="page_id" name="page" value="<? echo ($page) ; ?>" size="2"> |
<? |
| 275 |
<? if ($page<$page_total) |
if ($page > 1) |
| 276 |
{ |
{ |
| 277 |
?><a class="s8" title="下一页" href="search_user.php?page=<? echo $page+1; ?>&type=<? echo $type; ?><? if ($search_text!="") echo "&search_text=".$search_text;?>"><font face=webdings>8</font></a><a class="s8" title="尾页" href="search_user.php?page=<? echo $page_total; ?>&type=<? echo $type; ?><? if ($search_text!="") echo "&search_text=".$search_text;?>"><font face=webdings>:</font></a><? } |
?> |
| 278 |
else |
<a class="s8" title="棣栭〉" href="" onclick="return ch_page(1);"><font face=webdings>9</font></a> |
| 279 |
{ |
<a class="s8" title="涓婁竴椤" href="" onclick="return ch_page(<? echo ($page - 1); ?>);"><font face=webdings>7</font></a> |
| 280 |
?><font face=webdings>8:</font><? } ?> |
<? |
| 281 |
</form> |
} |
| 282 |
</td> |
else |
| 283 |
<td width="50" align="center"> |
{ |
| 284 |
<form action="search_user.php" method="get" id="search"> |
?> |
| 285 |
<font color=#909090>查找用户</font> |
<font face=webdings>9 7</font> |
| 286 |
<select name="type"> |
<? |
| 287 |
<option value="1" <? if ($type==1) echo "selected"; ?> >按昵称</option> |
} |
| 288 |
<option value="2" <? if ($type==2) echo "selected"; ?> >按用户名</option> |
?> |
| 289 |
</select> |
绗<input id="page" name="page" value="<? echo ($page) ; ?>" style="width: 30px;">/<? echo $page_total; ?>椤 |
| 290 |
<input type="text" id="search_text" name="search_text" size="15"> <input type=image src="images/search.gif" alt="按昵称查找注册用户" border="0" name="image"></a> |
<? |
| 291 |
</form> |
if ($page < $page_total) |
| 292 |
|
{ |
| 293 |
|
?> |
| 294 |
|
<a class="s8" title="涓嬩竴椤" href="" onclick="return ch_page(<? echo ($page + 1); ?>);"><font face=webdings>8</font></a> |
| 295 |
|
<a class="s8" title="灏鹃〉" href="" onclick="return ch_page(<? echo ($page_total); ?>);"><font face=webdings>:</font></a> |
| 296 |
|
<? |
| 297 |
|
} |
| 298 |
|
else |
| 299 |
|
{ |
| 300 |
|
?> |
| 301 |
|
<font face=webdings>8 :</font> |
| 302 |
|
<? |
| 303 |
|
} |
| 304 |
|
?> |
| 305 |
</td> |
</td> |
| 306 |
<td width="25"> |
<td width="50%"> |
| 307 |
|
<select name="type"> |
| 308 |
|
<option value="0" <? if ($type==0) echo "selected"; ?> >鎸夌敤鎴峰悕</option> |
| 309 |
|
<option value="1" <? if ($type==1) echo "selected"; ?> >鎸夋樀绉</option> |
| 310 |
|
</select> |
| 311 |
|
<input type="text" id="search_text" name="search_text" size="15" value="<? echo $search_text;?>"> |
| 312 |
|
<input type="checkbox" id="online" name="online" value="1" <? echo ($online ? "checked" : "");?>><font color=#909090>鍦ㄧ嚎</font> |
| 313 |
|
<input type="checkbox" id="friend" name="friend" value="1" <? echo ($friend ? "checked" : "");?>><font color=#909090>濂藉弸</font> |
| 314 |
|
<input type=image src="images/search.gif" alt="鏌ユ壘鐢ㄦ埛" border="0" name="image"></a> |
| 315 |
</td> |
</td> |
| 316 |
|
<td width="10%"> |
| 317 |
|
</td> |
| 318 |
|
</form> |
| 319 |
</tr> |
</tr> |
| 320 |
</table> |
</table> |
| 321 |
</center> |
</center> |
| 322 |
<? |
<? |
| 323 |
include "./foot.inc.php"; |
mysqli_close($db_conn); |
| 324 |
|
|
| 325 |
|
include "./foot.inc.php"; |
| 326 |
?> |
?> |
| 327 |
</body> |
</body> |
| 328 |
</html> |
</html> |
|
|
|
Parent Directory
| 
Revision Log
| 
Patch