admin_family.php

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

<?php
if(!defined('IN_DISCUZ')){exit('Access Denied');} 
if($gm==0){exit('无效的越权访问！');}
$strarr=array(" ","\\'","\'","'","%",";","\\","\"","<",">");

if($action=='delfamily'){
	$familyid=intval($familyid);
	showmessage("删除此家族将同时删除该家族仓库里所有物品和家族资金,确定删除吗？<BR><BR><a href='pet.php?index=admin&adminindex=family'>家族管理</a>　||　<A href='pet.php?index=admin&adminindex=family&familyid=$familyid&action=delfamilysave'>确定删除</a>");	
}elseif($action=='delfamilysave'){
	$familyid=intval($familyid);
	$familyinfo= $db->get_one("select familyname from {$tablepre}wxfamily where familyid='$familyid'");
	if(!$familyinfo){
		showmessage("无效操作",'pet.php?index=admin&adminindex=family');
	}else{
		$familyname=$familyinfo['familyname'];
		$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("删除家族【{$familyname}】完成！<BR><BR><a href=pet.php?index=admin&adminindex=family>家族管理</a>");
	}
}elseif($action=='showrecord'){
	$familyid=intval($familyid);
	$familyinfo= $db->get_one("select familyname from {$tablepre}wxfamily where familyid='$familyid'");
	if(!$familyinfo){
		showmessage("无效操作",'pet.php?index=admin&adminindex=family');
	}
	$familyname=$familyinfo['familyname'];
	$perpage = 50; 
	$page=intval($page)?intval($page):1;
	$num = $db->result($db->query("SELECT COUNT(*) FROM {$tablepre}wxfamilyrecord where familyid='$familyid'"),0);
	$page=($page>ceil($num/$perpage))?ceil($num/$perpage):$page;
	$mpurl = "pet.php?index=admin&adminindex=family&action=showrecord&familyid=$familyid";
	$mulpage=multi($num, $perpage, $page, $mpurl);
	$star = $num==0?0:($page * $perpage - $perpage); 

	$recordlist=array(); 
	$query = $db->query("SELECT a.*,b.cname from {$tablepre}wxfamilyrecord a left join {$tablepre}wxitem b on a.itemname=b.itemname  where  a.familyid='$familyid'  ORDER BY  a.dotime desc  LIMIT $star,$perpage");
	while($recordinfo = $db->fetch_array($query)) {
		$recordinfo['usernameenc'] = rawurlencode($recordinfo['username']);
		$recordinfo['dotime'] = gmdate("Y-m-d H:i:s", $recordinfo['dotime'] + $timeoffset * 3600);
		$dotype=$recordinfo['dotype'];
		if($dotype==12){
			$recordinfo['dotype']='<font color=red>加入家族</font>';
			$recordinfo['cname']='------';
		}elseif($dotype==13){
			$recordinfo['dotype']='<font color=green>退出家族</font>';
			$recordinfo['cname']='------';
		}elseif($dotype==15){
			$recordinfo['dotype']='<font color=blue>开除家族</font>';
			$recordinfo['cname']='------';
		}elseif($dotype==2){
			$recordinfo['dotype']=$recordinfo['nums']>0?'<font color=red>贡献物品</font>':'<font color=green>领取物品</font>'; 
		}elseif($dotype==3){
			$recordinfo['dotype']=$recordinfo['nums']>0?'<font color=red>贡献宠物币</font>':'<font color=green>领取宠物币</font>'; 
			$recordinfo['cname']='------';
		}elseif($dotype==11){
			$recordinfo['dotype']='<font color=blue>申请加入家族</font>';
			$recordinfo['cname']='------';
		}
		$recordinfo['nums']=abs($recordinfo['nums']);
		$recordlist[] = $recordinfo;
	}

}elseif($action=='showstorage'){
	$familyid=intval($familyid);
	$familyinfo= $db->get_one("select familyname from {$tablepre}wxfamily where familyid='$familyid'");
	if(!$familyinfo){
		showmessage("无效操作",'pet.php?index=admin&adminindex=family');
	}
	$familyname=$familyinfo['familyname'];
	$itemtypelist="<a href=pet.php?index=admin&adminindex=family&action=showstorage&familyid=$familyid&itemtype=0&petid=$petid>所有</a> |";
	foreach($typecname as $typeid => $values) {
		$itemtypelist.=" <a href=pet.php?index=admin&adminindex=family&action=showstorage&familyid=$familyid&itemtype=$typeid>$values</a> |";
	}
	
	$itemtype=intval($itemtype)>=0?intval($itemtype):0;
	if($itemtype==0){
		$sqlaa="select count(*) as num from {$tablepre}wxfamilyshop where familyid='$familyid' and itemnums!=0";
		$sqlbb="";
	}else{
		$sqlaa="select count(*) as num from {$tablepre}wxfamilyshop a LEFT JOIN {$tablepre}wxitem b on a.itemname=b.itemname where a.familyid='$familyid' and a.itemnums!=0 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=family&action=showstorage&familyid=$familyid&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}wxfamilyshop a,{$tablepre}wxitem b 
						 where a.itemname=b.itemname  and a.familyid='$familyid'  $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=="editstorage"){
	$id=intval($id);
	$query=$db->get_one("select a.*, b.itemtype  from {$tablepre}wxfamilyshop a,{$tablepre}wxitem b where a.id='$id' and a.itemname=b.itemname");
	if(!$query){showmessage('无效操作','pet.php?index=admin&adminindex=family');}
  
	$nums=intval($nums);
	$itemtype=$query['itemtype'];
	$familyid=$query['familyid'];
  
	$db->query("update {$tablepre}wxfamilyshop set itemnums='$nums' where id='$id'");
	showmessage("完成更改家族仓库物品数量！","pet.php?index=admin&adminindex=family&action=showstorage&familyid=$familyid&itemtype=$itemtype");
  
}elseif($action=='edit'){
	$familyid=intval($familyid);
	$familyinfo= $db->get_one("select * from {$tablepre}wxfamily where familyid='$familyid'");
	if(!$familyinfo){
		showmessage("无效操作",'pet.php?index=admin&adminindex=family');
	}
	
}elseif($action=='editsave'){
	$familyid=intval($familyid);
	$familyinfo= $db->get_one("select * from {$tablepre}wxfamily where familyid='$familyid'");
	if(!$familyinfo){
		showmessage("无效操作",'pet.php?index=admin&adminindex=family');
	}
	$familyname=str_replace($strarr,"",$familyname);
	$username=str_replace($strarr,"",$username);
	$petlevel=intval($petlevel);
	$petjob=intval($petjob);
	$agreetag=$agreetag?1:0;
	$daygivemoney=intval($daygivemoney);
	$maxgivemoney=intval($maxgivemoney);
	$familymoney=intval($familymoney);
	
	if(cnstrlen($familyname)<3 || cnstrlen($familyname)>10){
		showmessage("请输入3-10个字符的家族名字！","javascript:history.back()");
	}
	if($username!=$familyinfo['username']){
		$query=$db->get_one("select username,familyid,fagreetag from {$tablepre}wxpetdata where username='$username'");
		if(!$query){
			showmessage("宠物系统不存在此用户，请返回重新填写家族创始人！","javascript:history.back()");
		}elseif($query['familyid']!=0 && $query['familyid']!=$familyid){
			showmessage("此用户已经是其他家族的创始人能或族员！","javascript:history.back()");
		}else{
			$username=$query['username'];
			$db->query("update {$tablepre}wxpetdata set familyid='$familyid',fagreetag=1 where username='".addslashes($username)."'");
		}
	}
	$db->query("update {$tablepre}wxfamily set username='".addslashes($username)."',familyname='$familyname',familymoney='$familymoney',petlevel='$petlevel',petjob='$petjob',agreetag='$agreetag',daygivemoney='$daygivemoney',maxgivemoney='$maxgivemoney' where familyid='$familyid'");
	showmessage("家族设置完成！<BR><BR><a href=pet.php?index=admin&adminindex=family>家族管理</a>");
	
}else{
	$action='list';
	$perpage = 15; 
	$page=intval($page)?intval($page):1;
	$num = $db->result($db->query("SELECT COUNT(*) FROM {$tablepre}wxfamily"),0);
	$page=($page>ceil($num/$perpage))?ceil($num/$perpage):$page;
	$mpurl = "pet.php?index=admin&adminindex=family";
	$mulpage=multi($num, $perpage, $page, $mpurl);
	$star = $num==0?0:($page * $perpage - $perpage); 

	$familylist=array(); 
	$query = $db->query("SELECT a.familyid, count(*) as membernums,b.familyname,b.username as familymaster, b.familymoney, b.createtime, b.petjob,b.petlevel,b.daygivemoney,b.maxgivemoney,b.agreetag FROM {$tablepre}wxpetdata a 
	                     left join {$tablepre}wxfamily b on a.familyid=b.familyid
						 where a.familyid<>0 and a.fagreetag=1 group by a.familyid ORDER BY  membernums desc  LIMIT $star,$perpage");
	
	while($familyinfo = $db->fetch_array($query)) {
		$familyinfo[createtime]=gmdate("Y-m-d H:i", $familyinfo[createtime] + $timeoffset * 3600);
		$familyinfo['usernameenc'] = rawurlencode($familyinfo['familymaster']);
		$familylist[] = $familyinfo;
	} 
}
include template('admin_family',9938,'wxpet/templates');
?>