- |
- |
-
- |
-
- |
-
- |
-
- |
-
- |
-
- |
-
+
+
+ |
|
-
-$color[0]="#f0F3Fa";
-$color[1]="#FAFBFC";
-$color_index=-1;
-$color_count=2;
+
+
+
+ |
+ 鐢ㄦ埛ID |
+ 鏄电О |
+ 绛夌骇 |
+ 鏈鍚庣櫥闄嗘椂闂 |
+ |
+ |
+
+
+$sql = "SELECT user_list.UID, username, nickname, exp, gender, gender_pub, last_login_dt FROM user_list" .
+ ($online ? " INNER JOIN user_online ON user_list.UID = user_online.UID" : "") .
+ ($friend ? " INNER JOIN friend_list ON user_list.UID = friend_list.fUID" : "") .
+ " INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID WHERE user_list.enable AND ".
+ ($type == 1 ? "nickname" : "username") .
+ " LIKE '%" . mysqli_real_escape_string($db_conn, $search_text) . "%'" .
+ ($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line" : "").
+ ($friend ? " AND friend_list.UID = " . $_SESSION["BBS_uid"] : "") .
+ " ORDER BY " . ($type == 1 ? "nickname" : "username") .
+ " LIMIT " . ($page-1) * $rpp . ", $rpp";
-$rs=mysql_query("select user_list.UID,username,nickname,".
- "IF(user_pubinfo.gender_pub,IF(user_pubinfo.gender='M',".
- "'♂','♀'),'') as gender".
- " from user_list".
- " inner join user_pubinfo on user_list.UID=user_pubinfo.UID where".
- " 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!");
+$rs = mysqli_query($db_conn, $sql);
+if ($rs == false)
+{
+ echo("Query user error" . mysqli_error($db_conn));
+ exit();
+}
-do
+while ($row = mysqli_fetch_array($rs))
{
- $color_index=($color_index+1)%$color_count;
?>
-
- |
- |
-
- for ($i=1; $i<=6; $i=$i+1)
+
+ |
+
+ if ($row["gender_pub"])
{
- if ($row=mysql_fetch_array($rs))
+ if ($row["gender"] == 'M')
{
-?>
- |
- echo $row["gender"]; ?>)"> echo ($type==1?$row["nickname"]:$row["username"]); ?>
- |
-
+ echo ("鈾");
}
- else
+ else
{
+ echo ("鈾");
+ }
+ }
+ else
+ {
+ echo ("?");
+ }
?>
-
|
-
- }
- }
+
+ );"> echo $row["username"]; ?>
+ |
+
+ echo $row["nickname"]; ?>
+ |
+
+ echo user_level($row["exp"]); ?>
+ |
+
+ echo $row["last_login_dt"]; ?>
+ |
+
+
+ if ($_SESSION["BBS_priv"]->checkpriv(0, S_MSG))
+ {
+?>
+ ', 'send_msg', 500, 300);">鍙戦佹秷鎭
+
+ }
?>
+ |
|
-}while($row);
+}
+
+mysqli_free_result($rs);
?>
-
-mysql_free_result($rs);
-mysql_close($db_conn);
-?>
|
@@ -151,43 +261,68 @@ mysql_close($db_conn);
|
- |
-
- |
-
-
+
|
- include "./foot.inc.php";
+mysqli_close($db_conn);
+
+include "./foot.inc.php";
?>
-
|