修复烈焰私服因合区错误导致玩家装备错乱问题
发表时间：2015-03-06 12:44点击人气：责任编辑：admin
修复烈焰私服私服因合区错误导致玩家装备错乱问题
自己加上数据库连接问题
数据库表根据自己数据库情况修改
<?php
$ZBinfo=mysql_query("SELECT * FROM game.playeritems order by guid asc");
$i=1;
while($rs=mysql_fetch_array($ZBinfo)){
$charinfo=mysql_query("SELECT * FROM game.characters where guid=".$rs['guid']."");
$rs4 = mysql_fetch_array($charinfo);
if (!$rs4){
echo $rs['guid']."--装备-<font color=red>No Data 已删除</font><br>";
$query="delete from game.playeritems where guid=".$rs['guid']."";
mysql_query($query);
}else{
echo $rs4['name']."-装备-Yes 保留数据<br>";
}
$i++;
}
?>
------------------www.yeyo6.com-------------------
<?php
$ZBSinfo=mysql_query("SELECT * FROM game.playeritemslog order by guid asc");
$i=1;
while($rs=mysql_fetch_array($ZBSinfo)){
$charinfo=mysql_query("SELECT * FROM game.characters where guid=".$rs['guid']."");
$rs5 = mysql_fetch_array($charinfo);
if (!$rs5){
echo $rs['guid']."--装备LOG-<font color=red>No Data 已删除</font><br>";
$query="delete from game.playeritemslog where guid=".$rs['guid']."";
mysql_query($query);
}else{
echo $rs5['name']."-装备LOG-Yes 保留数据<br>";
}
$i++;
}
?>
以上烈焰私服装备错乱修复代码为页游咯www.yeyo6.com(老MAN QQ:97078681)原创
转载请注明出处
自己加上数据库连接问题
数据库表根据自己数据库情况修改
<?php
$ZBinfo=mysql_query("SELECT * FROM game.playeritems order by guid asc");
$i=1;
while($rs=mysql_fetch_array($ZBinfo)){
$charinfo=mysql_query("SELECT * FROM game.characters where guid=".$rs['guid']."");
$rs4 = mysql_fetch_array($charinfo);
if (!$rs4){
echo $rs['guid']."--装备-<font color=red>No Data 已删除</font><br>";
$query="delete from game.playeritems where guid=".$rs['guid']."";
mysql_query($query);
}else{
echo $rs4['name']."-装备-Yes 保留数据<br>";
}
$i++;
}
?>
------------------www.yeyo6.com-------------------
<?php
$ZBSinfo=mysql_query("SELECT * FROM game.playeritemslog order by guid asc");
$i=1;
while($rs=mysql_fetch_array($ZBSinfo)){
$charinfo=mysql_query("SELECT * FROM game.characters where guid=".$rs['guid']."");
$rs5 = mysql_fetch_array($charinfo);
if (!$rs5){
echo $rs['guid']."--装备LOG-<font color=red>No Data 已删除</font><br>";
$query="delete from game.playeritemslog where guid=".$rs['guid']."";
mysql_query($query);
}else{
echo $rs5['name']."-装备LOG-Yes 保留数据<br>";
}
$i++;
}
?>
以上烈焰私服装备错乱修复代码为页游咯www.yeyo6.com(老MAN QQ:97078681)原创
转载请注明出处