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

Annotation of /fenglin/bbs/search_user.php

Parent Directory Parent Directory | Revision Log Revision Log

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