当前位置:首页>>魔兽单机>>正文
WOW单机版网页:查询被封停的账号及IP信息
2013-04-17 12:37:52 作者:网络 来源: 浏览次数:0
摘要:WOW单机版网页:查询被封停的账号及IP信息
下面是一个PHP的网页代码。你设置好数据库的连接属性后,基本上就可以使用了

需要IIS或则apache支持+ PHP支持+MYSQL数据库+你的单机版数据库


 <?php

$host
= 'localhost';
$user = 'root';
$password = 'root';
$realmdb = 'realmd';

mysql_connect($host, $user, $password);
mysql_select_db($realmdb);

function
banmaradek($time) {
if(
$time >= 3600)
{
$ora = $time/60/60;
$time_n = (int)$ora." hours.";
}

if(
$time <= 3599)
{
$perc = $time/60;
$time_n = (int)$perc." min.";
}

if(
$time <= 59)
{
$time_n = (int)$time." sec.";
}
return
$time_n;
}

$query = mysql_query("SELECT id,bannedby,banreason,unbandate FROM account_banned WHERE unbandate>='".time()."'");
while (
$sql=mysql_fetch_row($query) ) {
$account_name = mysql_fetch_array(mysql_query("SELECT * FROM account WHERE id='".$sql['0']."'"));

$ban_acc .= "<tr>
< td>"
.strtolower($account_name[username])."</td>
< td >"
.$sql['1']."</td>
< td>"
.$sql['2']."</td>
< td>"
.banmaradek($sql['3'] - time())."</td>
< /tr>"
;

}

$query = mysql_query("SELECT ip,bannedby,banreason,unbandate FROM ip_banned WHERE unbandate>='".time()."'");
while (
$sql=mysql_fetch_row($query) ) {

$ban_ip .= "<tr>
< td >"
.$sql['0']."</td>
< td>"
.$sql['1']."</td>
< td>"
.$sql['2']."</td>
< td>"
.banmaradek($sql['3'] - time())."</td>
< /tr>"
;

}

print
'<fieldset class="logged"><legend class="logged">Banolt Accountok:</legend>';
print
"<table width='100%' border='0'>";
print
"<tr>
< td width='120'><font color=\"#85889a\"><b>Account Name</b></font></td>
< td width='100'><font color=\"#85889a\"><b>Banned By</b></font></td>
< td><font color=\"#85889a\"><b>-</b></font></td>
< td width='120'><font color=\"#85889a\"><b>UnBanDate</b></font></td>
< /tr>"
;
print
$ban_acc;
print
"</table></fieldset>";


print
'<fieldset class="logged"><legend class="logged">
Banned IP List</legend>';
print
"<table width='100%' border='0'>";
print
"<tr>
< td width='120'><font color=\"#85889a\"><b>IP</b></font></td>
< td width='100'><font color=\"#85889a\"><b>Banned By</b></font></td>
< td><font color=\"#85889a\"><b>-</b></font></td>
< td width='120'><font color=\"#85889a\"><b>UnBanDate</b></font></td>
< /tr>"
;
print
$ban_ip;
print
"</table></fieldset>";

mysql_close();
?>


相关报道:

[关闭] [返回顶部]


  返回首页 | 最新资讯 | 资源下载 | 魔兽图片 | 单机文档 | 技术攻略 | 玩家视频
备案号:蜀ICP备2024062380号-1
免责声明:本网站为热爱怀旧WOW的玩家们建立的魔兽世界资料网站,仅供交流和学习使用,非盈利和商用.如有侵权之处,请联系我们,我们会在24小时内确认删除侵权内容,谢谢合作。
Copyright © 2024 - 2024 WOWAII.COM Corporation, All Rights Reserved

机器人国度