admin_userpet.php

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

		$cwb=intval($cwb1);
		$cwbbank=intval($cwbbank);
		$mypetgd=intval($mypetgd);
		$familyid=intval($familyid);
		$sleeptime=intval($sleeptime);
		$vip=intval($vip);
		
		$sqlaa=$sqlbb=$sqlcc='';
		if($myzs!=$mypetzs){
		$db->query("update {$tablepre}wxpetdata set zs='$mypetzs' where id='$petid'");
		}
		if($petlevel!=$mypetlevel || $petjob!=$mypetjob){
			$mypetexp=ceil(exp((exp(log($mypetlevel-1)/3))*log(10))*($mypetjob*0.2+1))+1;
			$sqlaa=",mypetexp='".sprintf("%.0f",$mypetexp)."'";
		}
		
		if($petlevel!=$mypetlevel && $petjob==$mypetjob){
			$sqlaa.=",mypetlevel='$mypetlevel'";
		}
		
		if($petjob!=$mypetjob){
			$mypetmaxhp=$mypetlevel*25+100;
			$mypetmaxmp=$mypetlevel*2;
			$gotpoints=$mypetlevel*3+$mypetjob*$petsettings['pointjob'];
			$sqlbb=",career='0',leveltemp='$mypetlevel',mypetlevel='$mypetlevel',mypetmaxhp='$mypetmaxhp',mypethp='$mypetmaxhp',mypetmaxmp='$mypetmaxmp',mypetmp='$mypetmaxmp',mypetsp='5000',str=0,vit=0,agi=0,kno=0,dex=0,points='$gotpoints',mqp=0,bmqp=0";
			$db->query("update {$tablepre}wxpetmagic set mlight=0,mheal=0,mtitan=0,mpower=0,mlive=0,msleep=0,mfire=0,mice=0,mfirewind=0,mlightbomb=0,mcallhell=0,mtwohit=0,mlothit=0,mkiller2=0 where username='$petusername'");
		}
		
		if($familyid!=0){
			$familyinfo= $db->get_one("select * from {$tablepre}wxfamily where familyid='$familyid'");
			if(!$familyinfo){
				showmessage("请输入正确的家族ID号，详情可到家族管理中查看","javascript:history.back()");
			}else{
				$sqlcc=",fagreetag='$fagreetag',familyid='$familyid'";
			}
		}else{
			$sqlcc=",fagreetag=0,familyid=0";
		}
		
		if($otheritem!=''){
			$otheritemarray=explode(',',$otheritem);
			$otheritemnumarray=explode(',',$otheritemnum);
			if(count($otheritemnumarray)!=count($otheritemarray)){
				showmessage("请输入正确的宠物背包物品数量","javascript:history.back()");
			}
			$query = $db->get_one("select count(*) as nums from {$tablepre}wxitem  where itemname in ('".str_replace(",","','",$otheritem)."') and itemtype>5 ");
			if($query[nums]!=count($otheritemarray)){
				showmessage("请输入正确的宠物背包物品名称","javascript:history.back()");
			}
		}else{
			$otheritem=$otheritemnum='';
		}
		
		$db->query("update {$tablepre}wxpetdata set otheritem='$otheritem',otheritemnum='$otheritemnum',sleeptime='$sleeptime',openpk='$openpk',bantag='$bantag',petname='$petname',mypetpic='$mypetpic',mypetjob='$mypetjob',criring='$criring',cwb='$cwb',cwbbank='$cwbbank',mypetgd='$mypetgd',mypetgood='$mypetgood',vip='$vip' $sqlaa $sqlbb $sqlcc where id='$petid'");
		showmessage("修改会员宠物数据完成<BR><BR><a href=pet.php?index=admin&adminindex=userpet>会员宠物数据</a>");	
	}	
}elseif($action=='viewpet'){
	$petid=intval($petid);
	$petinfo=$db->get_one("SELECT * FROM {$tablepre}wxpetdata where id='$petid'");
	if(!$petinfo){
		showmessage("宠物数据不存在！<BR><BR><a href=pet.php?index=admin&adminindex=userpet>会员宠物数据</a>");
	}else{
		$career=$petinfo['career'];
		$petjob = $petinfo['mypetjob'];
		$petusername=addslashes($petinfo['username']);
		$petlevel = $petinfo['mypetlevel'];
		$points = $petinfo['points'];
		$str = $petinfo['str'];
		$vit = $petinfo['vit'];
		$agi = $petinfo['agi'];
		$int = $petinfo['kno'];
		$dex = $petinfo['dex'];
	
		$petmagic=$db->get_one("SELECT * FROM {$tablepre}wxpetmagic where username='$petusername'");
		$magicshow="";
		if($career==1){
			$skillword.=$petmagic[mheal]?"治疗术 ":"";
			$skillword.=$petmagic[mtitan]?"大地术 ":"";
			$skillword.=$petmagic[mpower]?"气血术 ":"";
			$skillword.=$petmagic[mlive]?"复活术 ":"";
		}elseif($career==2){
			$skillword.=$petmagic[mtwohit]?"二重攻击 ":"";
			$skillword.=$petmagic[mlothit]?"多重攻击 ":"";
			$skillword.=$petmagic[mkiller2]?"分身术 ":"";
		}elseif($career==3){
			$skillword.=$petmagic[mfire]?"炎暴术 ":"";
			$skillword.=$petmagic[mice]?"寒冰术 ":"";
			$skillword.=$petmagic[mfirewind]?"地暴术 ":"";
			$skillword.=$petmagic[mlightbomb]?"光暴术 ":"";
			$skillword.=$petmagic[msleep]?"催眠术 ":"";
			$skillword.=$petmagic[mcallhell]?"召唤地狱使者 ":"";
		}else{
			// no work
		}
	
		$careerarr=array(0=>'<font color=gray>杂牌军</font>',1=>'<font color=blue>圣骑士</font>',2=>'<font color=#ff00ff>刺客</font>',3=>'<font color=#660066>大法师</font>');
		$work=$careerarr[$career];
	
		$pointsatk= floor(($petjob+1) * ($petlevel/200+1) * ($str*3+(($agi>30)?($agi-30)*1.5:0)));
		$pointsdef= floor(($petjob+1) * ($petlevel/200+1) * ($vit*1.25+$dex*2.5));
		$pointsmatk=floor(($petjob+1) * ($petlevel/200+1) * ($int*5));
		$petatk = $petinfo['mypetatk'] + $pointsatk + 2 + intval($petlevel/2);
		$petdef = $petinfo['mypetdef'] + $pointsdef + 3 + intval($petlevel/2);
		$petmatk = $pointsmatk + 2 + intval($petlevel/2);

		$mqp=floor($int/6)-$petinfo['bmqp'];
		$petflee=intval($agi / 12)+(($petinfo['item4']=='kingb')?10:0); 
		$petflee=($petflee >= 100)?99:$petflee;
		
		$itemshow="";
		$items="'$petinfo[item1]','$petinfo[item2]','$petinfo[item3]','$petinfo[item4]','$petinfo[item5]'";
		$query = $db->query("select itemtype,cname,addnum,itemname,pic from {$tablepre}wxitem where itemname in (".$items.")");
		while($iteminfo = $db->fetch_array($query)) {
			$itemtype=$iteminfo['itemtype'];
			$tmpword=$itemtype>2?"防御+".$iteminfo[addnum]:"攻击+".$iteminfo[addnum];
			$itemshow.="<img src=$imgpath/$iteminfo[pic]  width=34 alt=$iteminfo[cname]，$tmpword align='absmiddle'> ";
		}
		$petinfo['petregdate'] = gmdate("Y-m-d H:i:s", $petinfo['petregdate'] + $timeoffset * 3600);
		$petinfo['actime'] = gmdate("Y-m-d H:i:s", $petinfo['actime'] + $timeoffset * 3600);

		$otheritem=$petinfo['otheritem'];
		$otheritemnum=$petinfo['otheritemnum'];
		$otheritemarr=array();
		$otheritemshow="";

		if($otheritem!=''){
			$otheritemarray=explode(',',$otheritem);
			$otheritemnumarray=explode(',',$otheritemnum);
			for($i=0;$i<count($otheritemarray);$i++){
				if(intval($otheritemnumarray[$i])>0 && $otheritemarray[$i]!='0'){
					$otheritemarr[$otheritemarray[$i]]=$otheritemnumarray[$i];
				}else{
					unset($otheritemarray[$i]);
					unset($otheritemnumarray[$i]);
				}
			}
			$otheritem=implode(',',$otheritemarray);
			$otheritemnum=implode(',',$otheritemnumarray);
			if($otheritem!=$petinfo['otheritem']){
				$db->query("update {$tablepre}wxpetdata SET otheritem='$otheritem',otheritemnum='$otheritemnum' WHERE username='$petusername'");
			}
		}
		if($otheritem!=''){
			$query = $db->query("select * from {$tablepre}wxitem  where itemname in ('".str_replace(",","','",$otheritem)."')  order by itemname;");
			while($iteminfo = $db->fetch_array($query)) {
				$itemname=$iteminfo['itemname'];
				$cname=$iteminfo['cname'];
				$itemnums=$otheritemarr[$itemname];
				$otheritemshow.=$cname."：".$itemnums."　";
			}
		}
	}
		
}else{
	$action='show';
	$perpage = 25;
	$page=intval($page)?intval($page):1;
	
	if($orderby == '1'){
		$order = " cwb desc ";
	}elseif($orderby == '2') {
		$order = " cwbbank desc ";
	}elseif($orderby == '3') {
		$order = " petregdate ";
	}else{
		$order = " mypetjob desc,mypetexp desc,petregdate ";
		$orderby='0';
	}
	
	$strarr=array(" ","\\'","\'","'","%",";","\\","\"");
	$petusername=str_replace($strarr,"",$petusername);
	if($petusername!=''){
		$sqlaa=" and username like '%".$petusername."%'";
		$sqlbb=" and username like '%".$petusername."%'";
		$petusername=rawurlencode($petusername);
	}
	
	$num= $db->result($db->query("SELECT COUNT(*) FROM {$tablepre}wxpetdata where 1 $sqlaa "),0);
	$page=($page>ceil($num/$perpage))?ceil($num/$perpage):$page;
	$mpurl = "pet.php?index=admin&adminindex=userpet&action=show&orderby=$orderby&petusername=$petusername";
	$mulpage=multi($num, $perpage, $page, $mpurl);
	$star = $num==0?0:($page * $perpage - $perpage); 

	$petlist=array(); 
	$query = $db->query("SELECT * FROM {$tablepre}wxpetdata where 1 $sqlbb ORDER BY $order  LIMIT $star,$perpage");
	while($petinfo = $db->fetch_array($query)) {
		
		$petinfo['usernameenc'] = rawurlencode($petinfo['username']);
		$petinfo['allcwb']=$petinfo['cwbbank']+$petinfo['cwb'];
		$petinfo['petregdate'] = gmdate("Y-m-d H:i:s", $petinfo['petregdate'] + $timeoffset * 3600);
		
		$career=$petinfo['career'];
		$careerarr=array(0=>'<font color=gray>杂牌军</font>',1=>'<font color=blue>圣骑士</font>',2=>'<font color=#ff00ff>刺客</font>',3=>'<font color=#660066>大法师</font>');
		$petinfo['work']=$careerarr[$career];	
		$petlist[] = $petinfo;
	} 
}

include template('admin_userpet',9938,'wxpet/templates');
?>