<?php
if(!defined('IN_DISCUZ')){ exit('Access Denied');} 
if($gm==0){exit('Access Denied');}
if($petsettings['shopcredits']){
	$shopcredits= $GLOBALS['extcredits'.$petsettings['shopcredits']];
	$shopcreditsname= $extcredits[$petsettings['shopcredits']][title];
}
if($action=='total'){
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid'");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		$itemname=$iteminfo['itemname'];
		$itemcname=$iteminfo['cname'];
		$itemtype=$iteminfo['itemtype'];
		$query=$db->get_one("select sum(itemnums) as total from {$tablepre}wxstorage where itemname='$itemname' and username!='無心'");
		$num1=$query[total];
		$query=$db->get_one("select sum(itemnums) as total from {$tablepre}wxfamilyshop where itemname='$itemname'");
		$num3=$query[total];
		$query=$db->get_one("select sum(itemnums) as total from {$tablepre}wxitemmarket where itemname='$itemname'");
		$num4=$query[total];
		$query=$db->get_one("select sum(itemnums) as total from {$tablepre}wxauction where itemname='$itemname' and gettag=0");
		$num5=$query[total];
		if($itemtype<10){
			$query=$db->get_one("select count(*) as total from {$tablepre}wxpetdata where item{$itemtype}='$itemname'");
			$num2=$query[total];
		}else{
			$num2=0;
		}
		$totalnums=$num1+$num2+$num3+$num4+$num5;
	}
}elseif($action=='viewequip'){
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid' and itemtype<10");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		$itemname=$iteminfo['itemname'];
		$itemcname=$iteminfo['cname'];
		$itemtype=$iteminfo['itemtype'];
		$query=$db->get_one("select count(*) as num from {$tablepre}wxpetdata where item{$itemtype}='$itemname'");
		$num = $query['num'];
		$perpage = 50; 
		$page=intval($page)?intval($page):1;
		$page=($page>ceil($num/$perpage))?ceil($num/$perpage):$page;
		$mpurl = "pet.php?index=admin&adminindex=item&action=viewequip&itemid=$itemid";
		$mulpage=multi($num, $perpage, $page, $mpurl);
		$star = $num==0?0:($page * $perpage - $perpage); 

		$usershoplist=array(); 
		$query = $db->query("select username,mypetjob,mypetlevel from {$tablepre}wxpetdata where item{$itemtype}='$itemname' order by mypetjob desc,mypetlevel desc LIMIT $star,$perpage");
		while($usershopinfo = $db->fetch_array($query)) {
			$usershoplist[] = $usershopinfo;
		}
	}
}elseif($action=='viewfstorage'){
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid'");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		$itemname=$iteminfo['itemname'];
		$itemcname=$iteminfo['cname'];
		$query=$db->get_one("select count(*) as num from {$tablepre}wxfamilyshop where itemname='$itemname' and itemnums>0");
		$num = $query['num'];
		$perpage = 50; 
		$page=intval($page)?intval($page):1;
		$page=($page>ceil($num/$perpage))?ceil($num/$perpage):$page;
		$mpurl = "pet.php?index=admin&adminindex=item&action=viewfstorage&itemid=$itemid";
		$mulpage=multi($num, $perpage, $page, $mpurl);
		$star = $num==0?0:($page * $perpage - $perpage); 

		$usershoplist=array(); 
		$query = $db->query("select a.*,b.familyname,b.username from {$tablepre}wxfamilyshop a,{$tablepre}wxfamily b where a.itemname='$itemname' and a.itemnums>0 and a.familyid=b.familyid order by a.itemnums desc LIMIT $star,$perpage");
		while($usershopinfo = $db->fetch_array($query)) {
			$usershoplist[] = $usershopinfo;
		}
	}
}elseif($action=='viewstorage'){
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid'");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		$itemname=$iteminfo['itemname'];
		$itemcname=$iteminfo['cname'];
		$query=$db->get_one("select count(*) as num from {$tablepre}wxstorage where itemname='$itemname' and itemnums>0");
		$num = $query['num'];
		$perpage = 50; 
		$page=intval($page)?intval($page):1;
		$page=($page>ceil($num/$perpage))?ceil($num/$perpage):$page;
		$mpurl = "pet.php?index=admin&adminindex=item&action=viewstorage&itemid=$itemid";
		$mulpage=multi($num, $perpage, $page, $mpurl);
		$star = $num==0?0:($page * $perpage - $perpage); 

		$usershoplist=array(); 
		$query = $db->query("select * from {$tablepre}wxstorage where itemname='$itemname' and itemnums>0 order by itemnums desc LIMIT $star,$perpage");
		while($usershopinfo = $db->fetch_array($query)) {
			$usershoplist[] = $usershopinfo;
		}
	}
}elseif($action=="unwear" ){
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("select * from {$tablepre}wxitem where id='$itemid' and itemtype<10");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		$itemname=$iteminfo['itemname'];
		$cname=$iteminfo['cname'];
		$itemtype=$iteminfo['itemtype'];
		$itemaddnum=$iteminfo['addnum'];
		$atkordef=$itemtype>2?'mypetdef':'mypetatk';
	
		$i=0;
		$myquery=$db->query("select username from {$tablepre}wxpetdata where item{$itemtype}='$itemname'");
		while($myrow = $db->fetch_array($myquery)) {
			$i++;
			$petusername=addslashes($myrow['username']);
			updatestoragebyitemname($petusername,$itemname,1,1);
		}
		
		$str=$iteminfo['str'];
		$kno=$iteminfo['kno'];
		$vit=$iteminfo['vit'];
		$dex=$iteminfo['dex'];
		$agi=$iteminfo['agi'];
		$maxmp=$iteminfo['maxmp'];
		$maxhp=$iteminfo['maxhp'];
		$db->query("update {$tablepre}wxpetdata set item{$itemtype}='0',$atkordef=$atkordef-$itemaddnum,str=str-'$str',kno=kno-'$kno',vit=vit-'$vit',dex=dex-'$dex',agi=agi-'$agi',mypetmaxmp=mypetmaxmp-'$maxmp',mypetmaxhp=mypetmaxhp-'$maxhp' where item{$itemtype}='$itemname'");
		showmessage("成功從所有裝備【 $cname 】的寵物身上卸下此物品【 $i 】！<BR><BR><a href=pet.php?index=admin&adminindex=item&itemtype=$itemtype>寵物系統物品設置</a>");
	}
}elseif($action=="give" ){
	$strarr=array(" ","%",",");
	$id=intval($id);
	$nums=intval($nums);
	$giveusername=str_replace($strarr,"",$giveusername);
	if(strlen($giveusername)<3 || strlen($giveusername)>20 ){
		showmessage("請輸入正確的會員名字!","javascript:history.back()");
	}elseif($nums<=0 || $nums>999){
		showmessage("請輸入正確的贈送數量!","javascript:history.back()");
	}else{
		$query = $db->get_one("SELECT username FROM {$tablepre}wxpetdata WHERE username='$giveusername' ");
		if(!$query){
			showmessage("寵物系統中沒有這號人物!","javascript:history.back()");
		}else{
			$giveusername=$query['username'];
			$iteminfo=$db->get_one("select * from {$tablepre}wxitem where id='$id'");
			if(!$query){
				showmessage('無效操作','pet.php?index=admin&adminindex=item');
			}else{
				$itemname=$iteminfo['itemname'];
				$cname=$iteminfo['cname'];
				$itemtype=$iteminfo['itemtype'];
				updatestoragebyitemname(addslashes($giveusername),$itemname,$nums,1);
				$givelog="<?PHP exit('Access Denied'); ?>\tGM\t".htmlspecialchars($giveusername)."\t$cname\t$nums\t$timestamp\n";
				writepetlog('givelog.php',$givelog);
				showmessage("成功贈送給 ".$giveusername." ".$nums." 個 $cname!<BR><BR><a href=pet.php?index=admin&adminindex=item&itemtype=$itemtype>物品設置</a>");
			}
		}
	}	
}elseif($action=='add'){
	$wearcheck='';
	$act='addsave';
	$show='增加物品'; 
	$wearcheck="";
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid'");
	if(!$iteminfo){
		$iteminfo=array();
		$iteminfo['maxjob']=99;
		$iteminfo['numbers']=9999;
		$iteminfo['upmoney']=9999;
		$iteminfo['multiple']=$iteminfo['uprange']=$iteminfo['addnum']=$iteminfo['money']=$iteminfo['requirejob']=$iteminfo['requirelevel']=$iteminfo['droprange']=$iteminfo['droplevel']=$iteminfo['sellnum']=0;
		$iteminfo['maxhp']=$iteminfo['maxmp']=$iteminfo['str']=$iteminfo['vit']=$iteminfo['dex']=$iteminfo['kno']=$iteminfo['agi']=0;
	}
	
	$itemtypelist='';
	foreach($typecname as $typeid => $values) {
		$selecttag=($typeid==$iteminfo['itemtype'])?"selected":"";
		$itemtypelist.="<option value='$typeid' $selecttag>$values</option>";
	}
		
}elseif($action=='edit'){
	$act='editsave';
	$show='編輯物品';
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid'");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		$itemname=$iteminfo['itemname'];
		$itemtype=$iteminfo['itemtype'];
		if($itemtype<10){
			$weartag = $db->result($db->query("select count(*) from {$tablepre}wxpetdata where item{$itemtype}='$itemname'"),0);
			$itemtypelist="<option value='$itemtype'>".$typecname[$itemtype]."</option>";
		}else{
			$weartag=0;
			$itemtypelist='';
			foreach($typecname as $typeid => $values) {
				if($typeid>10){
					$selecttag=($typeid==$itemtype)?"selected":"";
					$itemtypelist.="<option value='$typeid' $selecttag>$values</option>";
				}
			}
		}		
		$wearcheck=$weartag?"disabled='disabled'":"";
	}
	
}elseif($action=='del'){
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT itemname FROM {$tablepre}wxitem where id='$itemid'");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		showmessage("警告：刪除此物品將同時刪除寵物系統中此物品相關數據！！<BR><BR><a href=pet.php?index=admin&adminindex=item>寵物系統物品設置</a>　||　<A href='pet.php?index=admin&adminindex=item&itemid=$itemid&action=delsave'>確定刪除</a>");
	}
}elseif($action=='delsave'){
	$itemid=intval($itemid);
	$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid'");
	if(!$iteminfo){
		showmessage('無效操作','pet.php?index=admin&adminindex=item');
	}else{
		$itemtype=$iteminfo['itemtype'];
		$itemname=$iteminfo['itemname'];
		$cname=$iteminfo['cname'];
	
		if($itemtype<10){
			$query=$db->get_one("select count(*) as nums from {$tablepre}wxpetdata where item{$itemtype}='$itemname'");
			if($query['nums']!=0){
				showmessage("已有會員的寵物裝備【 $cname 】，系統不允許刪除，請先卸載此物品！","javascript:history.back()");
			}else{
				$query=$db->get_one("select count(*) as nums from {$tablepre}wxitemsuit where item{$itemtype}='$itemname'");
				if($query['nums']!=0){
					showmessage("裝備【 $cname 】是某套裝的一樣，系統不允許刪除！","javascript:history.back()");
				}
			}	
		}
		
		$query=$db->get_one("select id from {$tablepre}wxcompose where concat(',',itemarr,',') like '%,".$itemname.",%' ");
		if($query){
			$id=$query['id'];
			showmessage("物品【 $cname 】是某合成物品配料的一樣，請先修改此合成物品的設置！","pet.php?index=admin&adminindex=compose&action=edit&id=$id");
		}
		
		$db->query("delete from {$tablepre}wxfamilyshop where itemname='$itemname'");
		$db->query("delete from {$tablepre}wxfamilyrecord where itemname='$itemname'");
		$db->query("delete from {$tablepre}wxitem where itemname='$itemname'");
		$db->query("delete from {$tablepre}wxitemmarket where itemname='$itemname'");
		$db->query("delete from {$tablepre}wxstorage where itemname='$itemname'");