fenglin/bbs/search_user.php

<?
        require_once "../lib/db_open.inc.php";
        require_once "./session_init.inc.php";
        require_once "./user_level.inc.php";
?>
<?
$page_max_record=20;

if (isset($_GET["page"]))
        $page=intval($_GET["page"]);
else
        $page=1;
if ($page<1)
        $page=1;

if (isset($_GET["type"]))
        $type=intval($_GET["type"]);
else
        $type=2;

if (isset($_GET["online"]))
        $online=($_GET["online"]=="on");
else
        $online=0;

if (isset($_GET["friend"]))
        $friend=($_GET["friend"]=="on");
else
        $friend=0;

if (isset($_GET["search_text"]))
        $search_text=trim($_GET["search_text"]);
else
        $search_text="";
$search_author=addslashes(stripslashes($search_text));

$rs=mysql_query("select user_online.SID from user_online WHERE UID = 0".
        ($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line" : ""))
        or die("Count guest error!");
$guest_count=mysql_num_rows($rs);
mysql_free_result($rs);

$rs=mysql_query("select user_online.SID from user_online WHERE UID <> 0".
        ($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line" : ""))
        or die("Count user error!");
$user_count=mysql_num_rows($rs);
mysql_free_result($rs);

$rs=mysql_query("select count(user_list.UID) as rec_count 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?"user_pubinfo.nickname":"user_list.username").
        " like '%$search_author%'".
        ($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line" : "").
        ($friend ? " and friend_list.UID=".$_SESSION["BBS_uid"]:"")
        )
        or die("Query user error!");

$row=mysql_fetch_array($rs);
$u_count=$row["rec_count"];

mysql_free_result($rs);

$toa=$u_count;
if ($toa==0)
        $toa=1;

$page_total=intval($toa/$page_max_record);
if (($toa % $page_max_record)>0)
        $page_total++;
if ($page>$page_total)
        $page=$page_total;
?>
<html>
        <head>
                <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
                <title>用户查找结果</title>
                <link rel="stylesheet" href="css/default.css" type="text/css">

<style type="text/css">
TD.head,TD.level,TD.login_dt,TD.dark,TD.username
{
        border-right: #d0d3F0 1px solid;
        border-left: #d0d3F0 1px solid;
        border-bottom: #d0d3F0 1px solid;
}
TD.head
{
        font-family: 楷体;
        color:#909090;
}
TD.login_dt,TD.level,TD.dark,TD.username
{
        text-align:center;
}
TD.login_dt,TD.dark
{
        color:#909090;
        background-color:#eaf0Fa;
}
TD.head,TD.level
{
        background-color:#fafbfc;
}
TD.level
{
        color:orange;
}
</style>

                <script language="JavaScript" src="/js/nw_open.js"></script>
        </head>
        <body>
                <center>
                        <table cols="2" border="0" cellpadding="0" cellspacing="0" width="770">
                                <tr>
                                        <td colspan="2" style="color:green;">
                                                <a class="s2" href="main.php"><? echo $BBS_name; ?></a>&gt;&gt;查找<? echo ($online?"在线":""); ?><? echo ($friend?"好友":"用户"); ?>
                                        </td>
                                </tr>
                                <tr bgcolor="#d0d3F0" height="2">
                                        <td colspan="2"></td></tr>
                                <tr>
                                        <td class="dark" width="3%"></td>
                                        <td class="head" width="97%">
                                                <? if ($u_count==0)
{
?>
                                                未找到指定用户<? }
        else
{
?>用户查找结果（共<? echo $u_count; ?>位）<? } ?>
                                                （当前在线注册用户<? echo $user_count; ?>位，游客<? echo $guest_count; ?>位）
                                        </td>
                                </tr>
                        </table>
                        <table border="0" cellpadding="1" cellspacing="0" width="770">
                                <tr height="10">
                                        <td>
                                        </td>
                                </tr>
                        </table>
                        <table bgcolor="#f0F3Fa" border="0" cellpadding="0" cellspacing="0" width="770">
                                <tr bgcolor="#d0d3F0" height="20">
                                        <td class="title" width="4%"></td>
                                        <td class="title" width="15%">用户ID</td>
                                        <td class="title" width="20%">昵称</td>
                                        <td class="title" width="12%">等级</td>
                                        <td class="title" width="18%">最后登陆时间</td>
                                        <td class="title" width="27%"></td>
                                        <td class="title" width="4%"></td>
                                </tr>
                                <? 
$color[0]="#f0F3Fa";
$color[1]="#FAFBFC";
$color_index=-1;
$color_count=2;

$rs=mysql_query("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?"user_pubinfo.nickname":"user_list.username").
        " like '%$search_author%'".
        ($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)*$page_max_record.",$page_max_record")
        or die("Query user error!");

while($row=mysql_fetch_array($rs))
{
        $color_index=($color_index+1)%$color_count;
?>
                                <tr height="25">
                                        <td class="dark">
<?
        if ($row["gender_pub"])
        {
                if ($row["gender"] == 'M')
                        echo ("<font color=blue>♂</font>");
                else
                        echo ("<font color=red>♀</font>");
        }
        else
        {
                echo ("<font color=green>?</font>");
        }
?>
                                        </td>
                                        <td class="username" bgcolor="#fafbfc" onmouseover="this.bgColor='#eaf0Fa';" onmouseout="this.bgColor='#fafbfc';">
                                                <a class="s2" href="javascript:show_profile(<? echo $row["UID"]; ?>)"><? echo $row["username"]; ?></a>
                                        </td>
                                        <td class="dark">
                                                <? echo $row["nickname"]; ?>
                                        </td>
                                        <td class="level">
                                                <? echo user_level($row["exp"]); ?>
                                        </td>
                                        <td class="login_dt">
                                                <? echo $row["last_login_dt"]; ?>
                                        </td>
                                        <td class="level">
                                                <a class="s2" href="javascript:NW_open('send_msg.php?user_id=<? echo $row["UID"]; ?>','send_msg',500,300)">发送消息</a>
                                        </td>
                                        <td align="center">
                                        </td>
                                </tr>
<? 
}
?>
                        </table>
<? 
mysql_free_result($rs);
mysql_close($db_conn);
?>
                        <table cols="3" border="0" cellpadding="5" cellspacing="0" width="770">
                                <tr bgcolor="#d0d3F0" height="10">
                                        <td colspan="3" >
                                        </td>
                                </tr>
                                <tr height="10">
                                        <td colspan="3" >
                                        </td>
                                </tr>
                                <tr>
    <td width="25%" align="center" style="color:#909090">
    <form action="search_user.php" method="get" id="change_page" name="change_page">
      <input type="hidden" id="search_text" name="search_text" value="<? echo $search_text;?>">
      <input type="hidden" id="online" name="online" value="<? echo ($online?"on":"off"); ?>">
      <input type="hidden" id="friend" name="friend" value="<? echo ($friend?"on":"off"); ?>">
      分页: <? echo $page; ?>/<? echo $page_total; ?>页
<? if ($page>1)
{
?><a class="s8" title="首页" href="search_user.php?page=1&amp;type=<? echo $type; ?>&amp;online=<? echo ($online?"on":"off"); ?>&amp;friend=<? echo ($friend?"on":"off"); ?><? if ($search_text!="") echo "&amp;search_text=".$search_text;?>"><font face=webdings>9</font></a><a class="s8" title="上一页" href="search_user.php?page=<? echo $page-1; ?>&amp;type=<? echo $type; ?>&amp;online=<? echo ($online?"on":"off"); ?>&amp;friend=<? echo ($friend?"on":"off"); ?><? if ($search_text!="") echo "&amp;search_text=".$search_text;?>"><font face=webdings>7</font></a><? }
  else
{
?><font face=webdings>97</font><? } ?>
      <input id="page_id" name="page" value="<? echo ($page) ; ?>" size="2">
<? if ($page<$page_total)
{
?><a class="s8" title="下一页" href="search_user.php?page=<? echo $page+1; ?>&amp;type=<? echo $type; ?>&amp;online=<? echo ($online?"on":"off"); ?>&amp;friend=<? echo ($friend?"on":"off"); ?><? if ($search_text!="") echo "&amp;search_text=".$search_text;?>"><font face=webdings>8</font></a><a class="s8" title="尾页" href="search_user.php?page=<? echo $page_total; ?>&amp;type=<? echo $type; ?>&amp;online=<? echo ($online?"on":"off"); ?>&amp;friend=<? echo ($friend?"on":"off"); ?><? if ($search_text!="") echo "&amp;search_text=".$search_text;?>"><font face=webdings>:</font></a><? }
  else
{
?><font face=webdings>8:</font><? } ?>
    </form>
    </td>
                                        <td width="50" align="center">
                                                <form action="search_user.php" method="get" id="search">
                                                        <font color=#909090>查找用户</font>
                                                        <select name="type">
                                                                <option value="2" <? if ($type==2) echo "selected"; ?> >按用户名</option>
                                                                <option value="1" <? if ($type==1) echo "selected"; ?> >按昵称</option>
                                                        </select>
                                                        <input type="text" id="search_text" name="search_text" size="15">
                                                        <input type="checkbox" id="online" name="online" <? echo ($online?"checked":"");?> ><font color=#909090>在线</font>
                                                        <input type="checkbox" id="friend" name="friend" <? echo ($friend?"checked":"");?> ><font color=#909090>好友</font>
                                                        <input type=image src="images/search.gif" alt="查找用户" border="0" name="image"></a>
                                                </form>
                                        </td>
                                        <td width="25">
                                        </td>
                                </tr>
                        </table>
                </center>
<?
        include "./foot.inc.php";
?>
        </body>
</html>
1	sysadm	1.1	<?
2	sysadm	1.12	require_once "../lib/db_open.inc.php";
3	sysadm	1.1	require_once "./session_init.inc.php";
4	sysadm	1.4	require_once "./user_level.inc.php";
5	sysadm	1.1	?>
6	sysadm	1.9	<?
7	sysadm	1.4	$page_max_record=20;
8	sysadm	1.1
9			if (isset($_GET["page"]))
10			$page=intval($_GET["page"]);
11			else
12			$page=1;
13			if ($page<1)
14			$page=1;
15
16			if (isset($_GET["type"]))
17			$type=intval($_GET["type"]);
18			else
19	sysadm	1.5	$type=2;
20	sysadm	1.1
21	sysadm	1.4	if (isset($_GET["online"]))
22			$online=($_GET["online"]=="on");
23			else
24			$online=0;
25
26			if (isset($_GET["friend"]))
27			$friend=($_GET["friend"]=="on");
28			else
29			$friend=0;
30
31	sysadm	1.1	if (isset($_GET["search_text"]))
32			$search_text=trim($_GET["search_text"]);
33			else
34			$search_text="";
35			$search_author=addslashes(stripslashes($search_text));
36
37	sysadm	1.11	$rs=mysql_query("select user_online.SID from user_online WHERE UID = 0".
38			($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line" : ""))
39	sysadm	1.4	or die("Count guest error!");
40			$guest_count=mysql_num_rows($rs);
41			mysql_free_result($rs);
42
43	sysadm	1.11	$rs=mysql_query("select user_online.SID from user_online WHERE UID <> 0".
44			($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line" : ""))
45	sysadm	1.4	or die("Count user error!");
46			$user_count=mysql_num_rows($rs);
47			mysql_free_result($rs);
48
49	sysadm	1.1	$rs=mysql_query("select count(user_list.UID) as rec_count from user_list".
50	sysadm	1.4	($online?" inner join user_online on user_list.UID=user_online.UID":"").
51			($friend?" inner join friend_list on user_list.UID=friend_list.fUID":"").
52	sysadm	1.1	" inner join user_pubinfo on user_list.UID=user_pubinfo.UID where".
53			" user_list.enable and ".($type==1?"user_pubinfo.nickname":"user_list.username").
54	sysadm	1.4	" like '%$search_author%'".
55	sysadm	1.11	($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line" : "").
56	sysadm	1.4	($friend ? " and friend_list.UID=".$_SESSION["BBS_uid"]:"")
57			)
58	sysadm	1.1	or die("Query user error!");
59
60			$row=mysql_fetch_array($rs);
61	sysadm	1.4	$u_count=$row["rec_count"];
62	sysadm	1.1
63			mysql_free_result($rs);
64
65	sysadm	1.4	$toa=$u_count;
66	sysadm	1.1	if ($toa==0)
67			$toa=1;
68
69			$page_total=intval($toa/$page_max_record);
70			if (($toa % $page_max_record)>0)
71			$page_total++;
72			if ($page>$page_total)
73			$page=$page_total;
74			?>
75			<html>
76			<head>
77	sysadm	1.7	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
78			<title>用户查找结果</title>
79	sysadm	1.1	<link rel="stylesheet" href="css/default.css" type="text/css">
80	sysadm	1.4
81			<style type="text/css">
82			TD.head,TD.level,TD.login_dt,TD.dark,TD.username
83			{
84			border-right: #d0d3F0 1px solid;
85			border-left: #d0d3F0 1px solid;
86			border-bottom: #d0d3F0 1px solid;
87			}
88			TD.head
89			{
90	sysadm	1.7	font-family: 楷体;
91	sysadm	1.4	color:#909090;
92			}
93			TD.login_dt,TD.level,TD.dark,TD.username
94			{
95			text-align:center;
96			}
97			TD.login_dt,TD.dark
98			{
99			color:#909090;
100			background-color:#eaf0Fa;
101			}
102			TD.head,TD.level
103			{
104			background-color:#fafbfc;
105			}
106			TD.level
107			{
108			color:orange;
109			}
110			</style>
111
112			<script language="JavaScript" src="/js/nw_open.js"></script>
113	sysadm	1.1	</head>
114			<body>
115			<center>
116	sysadm	1.4	<table cols="2" border="0" cellpadding="0" cellspacing="0" width="770">
117			<tr>
118			<td colspan="2" style="color:green;">
119	sysadm	1.8	<a class="s2" href="main.php"><? echo $BBS_name; ?></a>>>查找<? echo ($online?"在线":""); ?><? echo ($friend?"好友":"用户"); ?>
120	sysadm	1.4	</td>
121			</tr>
122			<tr bgcolor="#d0d3F0" height="2">
123			<td colspan="2"></td></tr>
124			<tr>
125			<td class="dark" width="3%"></td>
126			<td class="head" width="97%">
127	sysadm	1.1	<? if ($u_count==0)
128			{
129			?>
130	sysadm	1.7	未找到指定用户<? }
131	sysadm	1.1	else
132			{
133	sysadm	1.7	?>用户查找结果（共<? echo $u_count; ?>位）<? } ?>
134			（当前在线注册用户<? echo $user_count; ?>位，游客<? echo $guest_count; ?>位）
135	sysadm	1.1	</td>
136			</tr>
137			</table>
138	sysadm	1.4	<table border="0" cellpadding="1" cellspacing="0" width="770">
139			<tr height="10">
140			<td>
141	sysadm	1.1	</td>
142	sysadm	1.4	</tr>
143			</table>
144			<table bgcolor="#f0F3Fa" border="0" cellpadding="0" cellspacing="0" width="770">
145			<tr bgcolor="#d0d3F0" height="20">
146			<td class="title" width="4%"></td>
147	sysadm	1.7	<td class="title" width="15%">用户ID</td>
148			<td class="title" width="20%">昵称</td>
149			<td class="title" width="12%">等级</td>
150			<td class="title" width="18%">最后登陆时间</td>
151	sysadm	1.4	<td class="title" width="27%"></td>
152			<td class="title" width="4%"></td>
153	sysadm	1.1	</tr>
154			<?
155			$color[0]="#f0F3Fa";
156			$color[1]="#FAFBFC";
157			$color_index=-1;
158			$color_count=2;
159
160	sysadm	1.4	$rs=mysql_query("select user_list.UID,username,nickname,exp,".
161			"gender,gender_pub,last_login_dt from user_list".
162			($online?" inner join user_online on user_list.UID=user_online.UID":"").
163			($friend?" inner join friend_list on user_list.UID=friend_list.fUID":"").
164	sysadm	1.1	" inner join user_pubinfo on user_list.UID=user_pubinfo.UID where".
165			" user_list.enable and ".($type==1?"user_pubinfo.nickname":"user_list.username").
166	sysadm	1.4	" like '%$search_author%'".
167	sysadm	1.11	($online ? " AND TIMESTAMPDIFF(SECOND, last_tm, NOW()) <= $BBS_user_off_line":"").
168	sysadm	1.4	($friend ? " and friend_list.UID=".$_SESSION["BBS_uid"]:"").
169			" order by ".($type==1?"nickname":"username").
170	sysadm	1.1	" limit ".($page-1)*$page_max_record.",$page_max_record")
171			or die("Query user error!");
172
173	sysadm	1.4	while($row=mysql_fetch_array($rs))
174	sysadm	1.1	{
175			$color_index=($color_index+1)%$color_count;
176			?>
177	sysadm	1.4	<tr height="25">
178			<td class="dark">
179			<?
180			if ($row["gender_pub"])
181			{
182			if ($row["gender"] == 'M')
183	sysadm	1.7	echo ("<font color=blue>♂</font>");
184	sysadm	1.4	else
185	sysadm	1.7	echo ("<font color=red>♀</font>");
186	sysadm	1.4	}
187			else
188	sysadm	1.1	{
189	sysadm	1.4	echo ("<font color=green>?</font>");
190			}
191	sysadm	1.1	?>
192			</td>
193	sysadm	1.4	<td class="username" bgcolor="#fafbfc" onmouseover="this.bgColor='#eaf0Fa';" onmouseout="this.bgColor='#fafbfc';">
194			<a class="s2" href="javascript:show_profile(<? echo $row["UID"]; ?>)"><? echo $row["username"]; ?></a>
195			</td>
196			<td class="dark">
197			<? echo $row["nickname"]; ?>
198			</td>
199			<td class="level">
200			<? echo user_level($row["exp"]); ?>
201			</td>
202			<td class="login_dt">
203			<? echo $row["last_login_dt"]; ?>
204			</td>
205			<td class="level">
206	sysadm	1.7	<a class="s2" href="javascript:NW_open('send_msg.php?user_id=<? echo $row["UID"]; ?>','send_msg',500,300)">发送消息</a>
207	sysadm	1.1	</td>
208			<td align="center">
209			</td>
210			</tr>
211			<?
212	sysadm	1.4	}
213	sysadm	1.1	?>
214			</table>
215			<?
216			mysql_free_result($rs);
217			mysql_close($db_conn);
218			?>
219			<table cols="3" border="0" cellpadding="5" cellspacing="0" width="770">
220			<tr bgcolor="#d0d3F0" height="10">
221			<td colspan="3" >
222			</td>
223			</tr>
224			<tr height="10">
225			<td colspan="3" >
226			</td>
227			</tr>
228			<tr>
229			<td width="25%" align="center" style="color:#909090">
230			<form action="search_user.php" method="get" id="change_page" name="change_page">
231			<input type="hidden" id="search_text" name="search_text" value="<? echo $search_text;?>">
232	sysadm	1.4	<input type="hidden" id="online" name="online" value="<? echo ($online?"on":"off"); ?>">
233			<input type="hidden" id="friend" name="friend" value="<? echo ($friend?"on":"off"); ?>">
234	sysadm	1.7	分页: <? echo $page; ?>/<? echo $page_total; ?>页
235	sysadm	1.1	<? if ($page>1)
236			{
237	sysadm	1.7	?><a class="s8" title="首页" href="search_user.php?page=1&type=<? echo $type; ?>&online=<? echo ($online?"on":"off"); ?>&friend=<? echo ($friend?"on":"off"); ?><? 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; ?>&online=<? echo ($online?"on":"off"); ?>&friend=<? echo ($friend?"on":"off"); ?><? if ($search_text!="") echo "&search_text=".$search_text;?>"><font face=webdings>7</font></a><? }
238	sysadm	1.1	else
239			{
240			?><font face=webdings>97</font><? } ?>
241			<input id="page_id" name="page" value="<? echo ($page) ; ?>" size="2">
242			<? if ($page<$page_total)
243			{
244	sysadm	1.7	?><a class="s8" title="下一页" href="search_user.php?page=<? echo $page+1; ?>&type=<? echo $type; ?>&online=<? echo ($online?"on":"off"); ?>&friend=<? echo ($friend?"on":"off"); ?><? 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; ?>&online=<? echo ($online?"on":"off"); ?>&friend=<? echo ($friend?"on":"off"); ?><? if ($search_text!="") echo "&search_text=".$search_text;?>"><font face=webdings>:</font></a><? }
245	sysadm	1.1	else
246			{
247			?><font face=webdings>8:</font><? } ?>
248			</form>
249			</td>
250			<td width="50" align="center">
251			<form action="search_user.php" method="get" id="search">
252	sysadm	1.7	<font color=#909090>查找用户</font>
253	sysadm	1.1	<select name="type">
254	sysadm	1.7	<option value="2" <? if ($type==2) echo "selected"; ?> >按用户名</option>
255			<option value="1" <? if ($type==1) echo "selected"; ?> >按昵称</option>
256	sysadm	1.1	</select>
257	sysadm	1.4	<input type="text" id="search_text" name="search_text" size="15">
258	sysadm	1.7	<input type="checkbox" id="online" name="online" <? echo ($online?"checked":"");?> ><font color=#909090>在线</font>
259			<input type="checkbox" id="friend" name="friend" <? echo ($friend?"checked":"");?> ><font color=#909090>好友</font>
260			<input type=image src="images/search.gif" alt="查找用户" border="0" name="image"></a>
261	sysadm	1.1	</form>
262			</td>
263			<td width="25">
264			</td>
265			</tr>
266			</table>
267			</center>
268			<?
269			include "./foot.inc.php";
270			?>
271			</body>
272			</html>
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1