¤@¡B¥[¤J¥¼ª¾ÀY»Î»P Email ªº¬d¸ß
¤G¡B¬d¸ßµ²ªGÅã¥Ü Email »P µù¥U IP ¦ì¸m
ק鷺®e
admin\members.php
¤@¡B§ä´M ·j¯Á¥Î¤á ¦r¦ê
¬Ý¨ì¤U±¦³¤@¦ê
<option value="">¥ô¦óÀY»Î</option>
<option value="Admin">ºÞ ²z û</option>
<option value="SuperMod">¶W¯Åª©¥D</option>
<option value="Moderator">ª© ¥D</option>
<option value="Member">¥¿¦¡·|û</option>
<option value="Banned">¸T¤î³X°Ý</option>
<option value="PostBanned">¸T¤îµo¨¥</option>
¦b³o¦ê¤U±¥[¤W
<option value="NOTMEMBER">¥¼ª¾ÀY»Î</option>
´N¦h¤@Ó¬d¸ßªº¿ï¶µ¤F
¤G¡B×§ï¬d¸ß±ø¥ó
§ä´M
$conditions .= $userstatus != "" ? " AND status='$userstatus'" : NULL;
§ï¦¨
if($userstatus =="NOTMEMBER")
{ $conditions .=" AND status not in ('Admin','SuperMod','Moderator','Member','Banned','PostBanned') "; }
else if($userstatus !="")
{ $conditions .= " AND status='$userstatus'"; }
¬d¸ß®É´N·|¬dªº¥X¥¼ª¾ÀY»Î¤F
¤T¡B¥[¤W Email ¬d¸ßÄæ¦ì
§ä´M
<tr><td bgcolor="<?=ALTBG1?>">µù¥U IP ¶}ÀY (¦p 202.97)¡G</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="text" name="regip" size="40"></td></tr>
¦b¤U±¥[¤W
<tr><td bgcolor="<?=ALTBG1?>">Email¡G</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="text" name="emaildata" size="40"></td></tr>
´N¦³¬d¸ßªº±ø¥óÄæ¦ì¥i¥H¿é¤J¤F
¥|¡B¥[¤W Email ¬d¸ß¥\¯à
§ä´M
$conditions .= $regip != "" ? " AND regip LIKE '$regip%'" : NULL;
¦b¤U±¥[¤W
$conditions .= $emaildata != "" ? " AND email LIKE '%$emaildata%'" : NULL;
´N¯à¬d¸ß Email ùتºÃöÁä¦r¤F
¤¡B³]©w¬d¸ß¥X¨Óªº¸ê®Æ¥Îµù¥U IP ±Æ§Ç(¥Ñ¤p¨ì¤j)
§ä´M
$query = $db->query("SELECT * FROM $table_members WHERE $conditions LIMIT $offset, $memberperpage");
§ó§ï¬°
$query = $db->query("SELECT * FROM $table_members WHERE $conditions Order by regip LIMIT $offset, $memberperpage");
¦p¦¹¤@¨Ó¬d¥X¨Óªº¸ê®Æ´N·|¨Ìµù¥Uªº IP ±Æ§Ç¤F
[ Last edited by Aikon on 2004-10-25 at 16:23 ]