admin_userpet.php

天使宠物 V6 Final版 天使宠物 V6 Final版目前支持Discuz!6.0 和 Discuz!6.1论坛

<?php
if(!defined('IN_DISCUZ')){exit('Access Denied');} 
if($gm==0){exit('Access Denied');} 

if($action=="delsave"  && $adminid==1){
	$petid=intval($petid);
	$petinfo=$db->get_one("SELECT username FROM {$tablepre}wxpetdata where id='$petid'");
	if(!$petinfo){
		showmessage('无效操作','pet.php?index=admin&adminindex=userpet');
	}else{	
		$username=$petinfo['username'];
		$usernamess=addslashes($username);
		$familyid=$petinfo['familyid'];
		$db->query("delete from {$tablepre}wxpetdata where username='$usernamess'");
		$db->query("delete from {$tablepre}wxpetmagic where username='$usernamess'");
		$db->query("delete from {$tablepre}wxstorage where username='$usernamess'");
		$db->query("delete from {$tablepre}wxitemmarket where username='$usernamess'");
		$db->query("delete from {$tablepre}wxpkdata where username='$usernamess'");
		$db->query("delete from {$tablepre}wxpkdata where pkname='$usernamess'");
		$db->query("delete from {$tablepre}wxrose where username='$usernamess'");
		$db->query("delete from {$tablepre}tsfz where username='$usernamess'");
		$db->query("delete from {$tablepre}tsfeed where username='$usernamess'");
		$db->query("delete from {$tablepre}tsmission where username='$usernamess'");
		$query=$db->get_one("SELECT username FROM {$tablepre}wxfamily where familyid='$familyid' and username='$usernamess'");
		if($query){
			$db->query("delete from {$tablepre}wxfamily WHERE familyid='$familyid'");
			$db->query("delete from {$tablepre}wxfamilyshop WHERE familyid='$familyid'");
			$db->query("delete from {$tablepre}wxfamilyrecord WHERE familyid='$familyid'");
			$db->query("UPDATE {$tablepre}wxpetdata SET familyid='0',fagreetag='0' WHERE familyid='$familyid'");
		}
		showmessage("已经删除【 $username 】宠物系统中的相关数据！ <BR><BR><a href=pet.php?index=admin&adminindex=userpet>会员宠物数据</a>");	
	}
}elseif($action=="del"  && $adminid==1){
	$petid=intval($petid);
	$petinfo=$db->get_one("SELECT username FROM {$tablepre}wxpetdata where id='$petid'");
	if(!$petinfo){
		showmessage('无效操作','pet.php?index=admin&adminindex=userpet');
	}else{
		$username=$petinfo[username];
		showmessage("警告：您确定要删除【 $username 】宠物系统中的相关数据吗？ <BR><BR><a href=pet.php?index=admin&adminindex=userpet>会员宠物数据</a>　||　<A href='pet.php?index=admin&adminindex=userpet&petid=$petid&action=delsave'>确定删除</a>");
	}
}elseif($action=="rename" && $adminid==1){
	$strarr=array(" ","%",",",";");
	$oldusername=str_replace($strarr,"",$oldusername);
	$newusername=str_replace($strarr,"",$newusername);
	if($oldusername=='' || $newusername==''){
		showmessage("原会员名和新会员名都必须填写！","pet.php?index=admin&adminindex=userpet");
	}else{
		$query=$db->get_one("select username from {$tablepre}wxpetdata where username='$oldusername'");
		if(!$query){
			showmessage("宠物系统中并没有【 ".stripslashes($oldusername)." 】的宠物资料！","pet.php?index=admin&adminindex=userpet");
		}
		$query=$db->get_one("select username from {$tablepre}members where username='$oldusername'");
		if($query){
			showmessage("论坛中已经存在【 ".stripslashes($oldusername)." 】会员！","pet.php?index=admin&adminindex=userpet");
		}
		$query=$db->get_one("select username from {$tablepre}members where username='$newusername'");
		if(!$query){
			showmessage("论坛中不存在【 ".stripslashes($newusername)." 】会员！","pet.php?index=admin&adminindex=userpet");
		}
		$query=$db->get_one("select username from {$tablepre}wxpetdata where username='$newusername'");
		if($query){
			showmessage("宠物系统中已经存在【 ".stripslashes($newusername)." 】的宠物资料！","pet.php?index=admin&adminindex=userpet");
		}
		$db->query("update {$tablepre}wxpetdata set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxpetmagic set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxpetdata set teamname='$newusername' where teamname='$oldusername'");
		$db->query("update {$tablepre}wxstorage set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxitemmarket set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxfamilyrecord set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxfamily set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxrose set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}tsfz set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}tsfeed set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}tsmission set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxpkdata set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxpkdata set pkname='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxauction set username='$newusername' where username='$oldusername'");
		$db->query("update {$tablepre}wxauction set auctionuser='$newusername' where auctionuser='$oldusername'");
		$db->query("update {$tablepre}wxauctionlog set username='$newusername' where username='$oldusername'");
		showmessage("改名成功，原会员【 ".stripslashes($oldusername)." 】的宠物相关数据已成功变成新会员【 ".stripslashes($newusername)." 】！","pet.php?index=admin&adminindex=userpet");
	}
	
}if($action=="delnouserpet"  && $adminid==1 && mysql_get_server_info() > '4.1'){
	$query=$db->get_one("select count(*) as totalpets from {$tablepre}wxpetdata where username not in (select username from {$tablepre}members)");
	$totalpets=$query['totalpets'];
	if($totalpets){
		$db->query("delete from {$tablepre}wxpetdata where  not exists (select username from {$tablepre}members where username={$tablepre}wxpetdata.username)");
		$db->query("delete from {$tablepre}wxpetmagic where  not exists (select username from {$tablepre}members where username={$tablepre}wxpetmagic.username)");
		$db->query("delete from {$tablepre}wxstorage where not exists (select username from {$tablepre}members where username={$tablepre}wxstorage.username)");
		$db->query("delete from {$tablepre}tsfz where not exists (select username from {$tablepre}members where username={$tablepre}tsfz.username)");
		$db->query("delete from {$tablepre}tsfeed where not exists (select username from {$tablepre}members where username={$tablepre}tsfeed.username)");
		$db->query("delete from {$tablepre}tsmission where not exists (select username from {$tablepre}members where username={$tablepre}tsmission.username)");
		$db->query("delete from {$tablepre}wxitemmarket where  not exists  (select username from {$tablepre}members where username={$tablepre}wxitemmarket.username)");
		$db->query("delete from {$tablepre}wxfamilyrecord where  not exists  (select username from {$tablepre}members where username={$tablepre}wxfamilyrecord.username)");
		$db->query("delete from {$tablepre}wxrose where  not exists (select username from {$tablepre}members where username={$tablepre}wxrose.username)");
		$db->query("delete from {$tablepre}wxpkdata where  not exists (select username from {$tablepre}members where username={$tablepre}wxpkdata.username)");
		$db->query("delete from {$tablepre}wxpkdata where  not exists (select username from {$tablepre}members where username={$tablepre}wxpkdata.pkname)");
	}
	showmessage("此次共清理【 $totalpets 】个已删除会员的宠物！","pet.php?index=admin&adminindex=userpet");

}elseif($action=="delnopet"  && $adminid==1 && mysql_get_server_info() > '4.1'){
	$db->query("delete from {$tablepre}wxstorage where  not exists   (select username from {$tablepre}wxpetdata where username={$tablepre}wxstorage.username)");
	$db->query("delete from {$tablepre}tsfz where  not exists   (select username from {$tablepre}wxpetdata where username={$tablepre}tsfz.username)");
	$db->query("delete from {$tablepre}tsfeed where  not exists   (select username from {$tablepre}wxpetdata where username={$tablepre}tsfeed.username)");
	$db->query("delete from {$tablepre}tsmission where  not exists   (select username from {$tablepre}wxpetdata where username={$tablepre}tsmission.username)");
	$db->query("delete from {$tablepre}wxitemmarket where  not exists   (select username from {$tablepre}wxpetdata where username={$tablepre}wxitemmarket.username)");
	$db->query("delete from {$tablepre}wxfamilyrecord where  not exists   (select username from {$tablepre}wxpetdata where username={$tablepre}wxfamilyrecord.username)");
	$db->query("delete from {$tablepre}wxpkdata where  not exists (select username from {$tablepre}members where username={$tablepre}wxpkdata.username)");
	$db->query("delete from {$tablepre}wxpkdata where  not exists (select username from {$tablepre}members where username={$tablepre}wxpkdata.pkname)");
	showmessage("清理成功！","pet.php?index=admin&adminindex=userpet");
	
}elseif($action=="editstorage"){
	$id=intval($id);
	$myquery=$db->get_one("select a.*, b.id as petid,c.itemtype  from {$tablepre}wxstorage a,{$tablepre}wxpetdata b,{$tablepre}wxitem c where a.username=b.username and a.id='$id' and a.itemname=c.itemname");
	if(!$myquery){
		showmessage('无效操作','pet.php?index=admin&adminindex=userpet');
	}else{
		$nums=intval($nums);
		$petid=$myquery['petid'];
		$itemtype=$myquery['itemtype'];
		$db->query("update {$tablepre}wxstorage set itemnums='$nums' where id='$id'");  
		showmessage("完成更改会员仓库物品数量！","pet.php?index=admin&adminindex=userpet&action=viewstorage&petid=$petid&itemtype=$itemtype");
	}
}elseif($action=="viewstorage" ){
	$petid=intval($petid);
	$petinfo=$db->get_one("SELECT username FROM {$tablepre}wxpetdata where id='$petid'");
	if(!$petinfo){showmessage('无效操作','pet.php?index=admin&adminindex=userpet');}
	$username=$petinfo[username];
	
	$itemtypelist="<a href=pet.php?index=admin&adminindex=userpet&action=viewstorage&itemtype=0&petid=$petid>所有</a> |";
	foreach($typecname as $typeid => $values) {
		$itemtypelist.=" <a href=pet.php?index=admin&adminindex=userpet&action=viewstorage&petid=$petid&itemtype=$typeid>$values</a> |";
	}
	
	$itemtype=intval($itemtype)>=0?intval($itemtype):0;
	if($itemtype==0){
		$sqlaa="select count(*)  from {$tablepre}wxstorage where username='".addslashes($username)."'";
		$sqlbb="";
	}else{
		$sqlaa="select count(*) from {$tablepre}wxstorage a,{$tablepre}wxitem b where a.itemname=b.itemname and a.username='".addslashes($username)."' and b.itemtype='$itemtype'";;
		$sqlbb=" and b.itemtype='$itemtype' ";
	}
	
	$perpage = 10; 
	$page=intval($page)?intval($page):1;
	$num= $db->result($db->query($sqlaa),0);
	$page=($page>ceil($num/$perpage))?ceil($num/$perpage):$page;
	$mpurl = "pet.php?index=admin&adminindex=userpet&action=viewstorage&petid=$petid&itemtype=$itemtype";
	$mulpage=multi($num, $perpage, $page, $mpurl);
	$star = $num==0?0:($page * $perpage - $perpage);

	$itemlist=array();
	$query = $db->query("select a.*,b.maxjob,b.career,b.selltag,b.addname,b.upitemname,b.itemtype,b.cname,b.moretxt,b.cwb,b.pic,b.requirejob,b.requirelevel,b.addnum,b.itemsex,b.str,b.vit,b.dex,b.kno,b.agi,b.maxhp,b.maxmp,b.usetag
						 from {$tablepre}wxstorage a,{$tablepre}wxitem b 
						 where a.itemname=b.itemname and a.username='".addslashes($username)."'   $sqlbb 
						 order by b.itemtype,a.itemnums desc LIMIT $star,$perpage");
	while($iteminfo = $db->fetch_array($query)) {
		$itemname=$iteminfo['itemname'];
		$itemtype=$iteminfo['itemtype'];
		$addname=$iteminfo['addname'];
		$iteminfo['moretxt']=moretxt($iteminfo);
		$iteminfo['typename']=$typecname[$itemtype];
		$itemlist[] = $iteminfo;
	}
}elseif($action=='editpet'){
	$petid=intval($petid);
	$petinfo=$db->get_one("SELECT * FROM {$tablepre}wxpetdata where id='$petid'");
	if(!$petinfo){
		showmessage('无效操作','pet.php?index=admin&adminindex=userpet');
	}
  
}elseif($action=='editsave'){
	$strarr=array(" ","\\'","\'","'","%",";","\\","\"","<",">");
	$petname=str_replace($strarr,"",$petname);
	$petinfo=$db->get_one("SELECT * FROM {$tablepre}wxpetdata where id='$petid'");
	if(!$petinfo){
		showmessage('无效操作','pet.php?index=admin&adminindex=userpet');
	}elseif(cnstrlen($petname)>15 || $petname==''){
		showmessage("请输入正确的宠物名字","javascript:history.back()");
	}elseif($mypetpic!='' && !preg_match("/^http[s]{0,1}:\/\/[a-zA-Z0-9\.\/\-_]{5,88}\.(jpg|gif|bmp|png)$/", strtolower($mypetpic))){
		showmessage("请输入正确的宠物形象图片","javascript:history.back()");
	}elseif($otheritem!='' && !preg_match("/^[a-z0-9_,]{3,60}$/", $otheritem)){
		showmessage("请输入正确的宠物背包物品名称","javascript:history.back()");
	}elseif($otheritem!='' && !preg_match("/^[0-9,]{1,60}$/", $otheritemnum)){
		showmessage("请输入正确的宠物背包物品数量","javascript:history.back()");
	}else{
		$myzs = $petinfo['zs'];
		$petjob = $petinfo['mypetjob'];
		$petusername=addslashes($petinfo['username']);
		$petlevel = $petinfo['mypetlevel'];
		$points=$petinfo['points'];
		$mypetgood=intval($mypetgood);
		$mypetgood=($mypetgood<-100)?-100:$mypetgood;
		$mypetgood=($mypetgood>100)?100:$mypetgood;
		$bantag=$bantag?1:0;
		$openpk=$openpk?1:0;
		$fagreetag=$fagreetag?1:0;
		$mypetzs=intval($zs);
		$mypetjob=intval($mypetjob);
		$mypetlevel=intval($mypetlevel);
		$criring=intval($criring);