hè hè vừa cài lại cái sql code cho bạn :D
của bạn bên dưới đó nhớ sửa thông số connect sql ở đầu nhé mình làm dựa trên code forest web có j k ổn hi vọng các bác bro bỏ quá cho
<?
error_reporting(E_ALL ^E_NOTICE ^E_WARNING);
$muweb['dbhost'] = '127.0.0.1';
$muweb['database'] = 'MuOnline';
$muweb['dbuser'] = 'sa';
$muweb['dbpassword'] = 'testcode';
?>
</div></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="393" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">
<fieldset>
<legend>Find Ip</legend>
<table width="402" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="402"><table width="200" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td><form action="" method="post" name="search_ip" id="search_ip">
<table width="210" border="0" cellspacing="4" cellpadding="0">
<tr>
<td colspan="2"><span class="normal_text">Character:</span>
<input name="ip_search_admin" type="text" id="ip_search_admin" size="17" maxlength="10"></td>
</tr>
<tr>
<td width="76" valign="middle"><span class="normal_text">Search type</span></td>
<td width="122"><p>
<label>
<input type="radio" name="search_type" value="1" checked>
<span class="normal_text">Exact Match</span></label>
<br>
<label>
<input type="radio" name="search_type" value="0">
<span class="normal_text">Partial Match</span></label>
<br>
</p></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><input type="submit" name="Submit" value="Find ip"></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">
<?PHP
function clean_var($var=NULL) {
<b><font color=red>[Chỉ có thành viên mới xem link được. <a href="register.php"> Nhấp đây để đăng ký thành viên......</a>]</font></b>
<b><font color=red>[Chỉ có thành viên mới xem link được. <a href="register.php"> Nhấp đây để đăng ký thành viên......</a>]</font></b>
return $newvar;
}
include('config.php');
$conn=mssql_connect($muweb['dbhost'],$muweb['dbuser'],$muweb['dbpassword']) or die("A Conntection With The Server Cannot Be Established, Please Contact The Tech Support Staff!");
$select = mssql_select_db($muweb['database'],$conn) or die("A Conntection With The DB Cannot Be Established, Please Contact The Tech Support Staff!");
//include("config_connect.php");
$search = stripslashes($_POST['ip_search_admin']);
$search_type = stripslashes($_POST['search_type']);
$search_type = clean_var($search_type);
$search = str_replace("'","",$search);
$search = str_replace(";","",$search);
$search_exact = "SELECT accountid,ctlcode,name from Character where name='$search'";
$search_partial = "SELECT accountid,ctlcode,name from Character where name like '%$search%'";
if($_POST['search_type']==1){
$result = mssql_query($search_exact);}
if($_POST['search_type']==0){
$result = mssql_query($search_partial);}
echo '<TABLE border=0 cellPadding=0 cellSpacing=0 >
<br><span class=normal_text>Search Character ip Results</span>
<br></br>
<table class="sort-table" id="table-1" width=350 height=30 border="0" cellpadding="0" cellspacing="0">
<thead><tr>
<td>#</td>
<td>Name</td>
<td>Account</td>
<td>IP</td>
<td>Mode</td>
<td>Status</td>
</tr></thead>
';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$status_check="Select ConnectStat from MEMB_STAT where memb___id='$row[0]'";
$status_reults = mssql_query($status_check);
$status = mssql_fetch_row($status_reults);
$get_ip = "Select ip from MEMB_STAT where memb___id='$row[0]'";
$get_ip_exec = mssql_query($get_ip);
$get_ip_done = mssql_fetch_row($get_ip_exec);
if($status[0] == 0){ $status[0] ="Offline";
}
if($status[0] == 1){ $status[0] ="Online";
}
if($row[1] == 1){$row[1] = "<table><tr><td bgcolor='yellow'><font color='#000000' size='1'>Blocked</font></td></tr></table>";}
elseif($row[1] == 0){$row[1] = "Normal";}
elseif($row[1] == 32){$row[1] = "<table><tr><td bgcolor='blue'><font color='#FFFFFF' size='1'>GM</font></td></tr></table>";}
if($get_ip_done[0] == NULL){$get_ip_done[0] = "<table><tr><td bgcolor='FF0000'><font color='#FFFFFF' size='1'>Error #120</font></td></tr></table>";}
$rank = $i+1;
echo "<tbody><tr>
<td align=left>$rank</td>
<td align=left>$row[2]</td>
<td align=left>$row[0]</td>
<td align=left>$get_ip_done[0]</td>
<td align=left>$row[1]</td>
<td align=left>$status[0]</td>
</tr></tbody>";
}
?>
</table>
</div></td>
</tr>
</table>
</fieldset>
</div></td>
</tr>
</table>