📄 admin_item.php
字号:
$db->query("delete from {$tablepre}wxauction where itemname='$itemname'");
$db->query("update {$tablepre}wxnpcdata set npcitem='' where npcitem='$itemname'");
if($itemtype>10){
$db->query("update {$tablepre}wxpetdata set otheritem=replace(concat(',',otheritem,','),',$itemname,',',0,') where concat(',',otheritem,',') like '%,$itemname,%'");
$db->query("update {$tablepre}wxpetdata set otheritem=mid(otheritem,2,length(otheritem)-2) where otheritem like ',%,'");
}else{
$db->query("update {$tablepre}wxitem set upitemname='' where upitemname='$itemname'");
}
showmessage("删除物品成功！<BR><BR><a href=pet.php?index=admin&adminindex=item&itemtype=$itemtype>宠物系统物品设置</a>");
}
}elseif($action=='editsave'){
$strarr=array(" ","\\'","\'","'","%",";","\\","\"");
$itemid=intval($itemid);
$cname=str_replace($strarr,"",$cname);
$pic=str_replace('\\\\','/',$pic);
$droprange=intval($droprange);
$droptag=$droptag?1:0;
$droplevel=intval($droplevel);
$requirejob=intval($requirejob);
$maxjob=intval($maxjob);
$requirelevel=intval($requirelevel);
$selltag = $selltag!=1 && $selltag!=2 && $selltag!=3?0:$selltag;
$usetag = $usetag?1:0;
$sellcwb=intval($sellcwb);
$sellyxb=intval($sellyxb);
$numbers=intval($numbers);
$upmoney=intval($upmoney);
$moretxt=htmlspecialchars(str_replace(" ","",$moretxt));
$upitemname=str_replace($strarr,"",$upitemname);
$addnum=intval($addnum);
$sqlaa='';
$iteminfo=$db->get_one("SELECT * FROM {$tablepre}wxitem where id='$itemid'");
if(!$iteminfo){
showmessage('无效操作','pet.php?index=admin&adminindex=item');
}elseif(cnstrlen($cname)>15 || cnstrlen($cname)<2){
showmessage("请输入2－15个字符的物品中文名称！","javascript:history.back()");
}elseif($droprange<0 || $droprange>100){
showmessage("设置物品掉落概率有误，请输入0－100的数字！","javascript:history.back()");
}elseif(!preg_match("/^[a-zA-Z0-9_\/]{5,50}\.(gif|jpg|bmp|png)$/", $pic)){
showmessage("请输入正确的物品图片地址！","javascript:history.back()");
}else{
$itemname=$iteminfo['itemname'];
$olditemtype=$iteminfo['itemtype'];
if($olditemtype>10){
$itemtype=intval($itemtype);
$sqlaa=",itemtype='$itemtype'";
$addnamearray=array('mypetmp','mypethp','mypetmaxmp','mypetmaxhp','str','kno','vit','dex','agi','numbers','mypetatk','mypetdef','criring','mypetgd','mypetexp');
if(!in_array($addname,$addnamearray)){
$sqlaa.=",addnum='0',addname='',usetag='$usetag'";
}else{
$sqlaa.=",addnum='$addnum',addname='$addname',usetag=0";
}
}else{
$itemtype=$olditemtype;
$weartag = $db->result($db->query("select count(*) from {$tablepre}wxpetdata where item{$itemtype}='$itemname'"),0);
if($weartag==0){
$itemsex= $itemsex!=1 && $itemsex!=2?0:$itemsex;
$career = $career!=1 && $career!=2 && $career!=3?0:$career;
$sqlaa.=",itemsex='$itemsex',career='$career'";
}
if($upitemname!=''){
$uprange=intval($uprange);
if($uprange<0 || $uprange>100){
showmessage("设置物品升级概率有误，请输入0－100的数字！","javascript:history.back()");
}elseif(!preg_match("/^[a-zA-Z0-9_]{3,}$/", $upitemname)){
showmessage("升级物品英文名称只能为英文字符，数字和下划线！","javascript:history.back()");
}else{
$query=$db->get_one("SELECT * FROM {$tablepre}wxitem where itemname='$upitemname' and itemtype='$itemtype'");
if(!$query){
showmessage("在同类型装备中不存在此物品，请返回重新输入！","javascript:history.back()");
}else{
$sqlaa.=",upitemname='$upitemname',uprange='$uprange'";
}
}
}else{
$sqlaa.=",upitemname='',uprange='0'";
}
$str=intval($str);
$kno=intval($kno);
$vit=intval($vit);
$dex=intval($dex);
$agi=intval($agi);
$maxmp=intval($maxmp);
$maxhp=intval($maxhp);
$sqlaa.=",addnum='$addnum',str='$str',vit='$vit',kno='$kno',dex='$dex',agi='$agi',maxmp='$maxmp',maxhp='$maxhp'";
$str=$str-$iteminfo['str'];
$kno=$kno-$iteminfo['kno'];
$vit=$vit-$iteminfo['vit'];
$dex=$dex-$iteminfo['dex'];
$agi=$agi-$iteminfo['agi'];
$maxmp=$maxmp-$iteminfo['maxmp'];
$maxhp=$maxhp-$iteminfo['maxhp'];
$addnum=$addnum-$iteminfo['addnum'];
$atkordef=$itemtype>2?'mypetdef':'mypetatk';
$db->query("update {$tablepre}wxpetdata set $atkordef=$atkordef+$addnum,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'");
}
$db->query("update {$tablepre}wxitem set cname='$cname',numbers='$numbers',upmoney='$upmoney',moretxt='$moretxt',pic='$pic',selltag='$selltag',cwb='$sellcwb',yxb='$sellyxb',droptag='$droptag',droplevel='$droplevel',droprange='$droprange',requirejob='$requirejob',maxjob='$maxjob',requirelevel='$requirelevel' $sqlaa where id='$itemid'");
showmessage("物品设置成功！<BR><BR><a href=pet.php?index=admin&adminindex=item&itemtype=$itemtype>宠物系统物品设置</a>");
}
}elseif($action=='addsave'){
$strarr=array(" ","\\'","\'","'","%",";","\\","\"");
$addnamearray=array('mypetmp','mypethp','mypetmaxmp','mypetmaxhp','str','kno','vit','dex','agi','mypetatk','mypetdef','criring','mypetgd','mypetexp');
$droptag=$droptag?1:0;
$droplevel=intval($droplevel);
$droprange=intval($droprange);
$selltag= $selltag!=1 && $selltag!=2 && $selltag!=3?0:$selltag;
$sellcwb=intval($sellcwb);
$sellyxb=intval($sellyxb);
$itemsex= $itemsex!=1 && $itemsex!=2?0:$itemsex;
$career = $career!=1 && $career!=2 && $career!=3?0:$career;
$requirejob=intval($requirejob);
$maxjob=intval($maxjob);
$requirelevel=intval($requirelevel);
$itemtype=intval($itemtype);
$itemname=str_replace($strarr,"",$itemname);
$cname=str_replace($strarr,"",$cname);
$addnum=intval($addnum);
$pic=str_replace('\\\\','/',$pic);
$moretxt=htmlspecialchars(str_replace(" ","",$moretxt));
$upitemname=str_replace($strarr,"",$upitemname);
$usetag = $usetag?1:0;
if(!preg_match("/^[a-zA-Z0-9_]{3,}$/", $itemname)){
showmessage("请正确输入3－15个字符的物品英文名称！","javascript:history.back()");
}elseif(cnstrlen($cname)>15 || cnstrlen($cname)<2){
showmessage("请输入2－15个字符的物品中文名称！","javascript:history.back()");
}elseif(!preg_match("/^[a-zA-Z0-9_\/]{5,50}\.(gif|jpg|bmp|png)$/", $pic)){
showmessage("请输入正确的物品图片地址！","javascript:history.back()");
}elseif($droprange<0 || $droprange>100){
showmessage("设置物品掉落概率有误，请输入0－100的数字！","javascript:history.back()");
}else{
$query=$db->get_one("SELECT * FROM {$tablepre}wxitem where itemname='$itemname' ");
if($query){
showmessage("此物品英文名次已经存在，请更改另外一个名称！","javascript:history.back()");
}else{
if($itemtype<10){
$addname='';
$usetag=0;
$uprange=intval($uprange);
if($uprange<0 || $uprange>100){
showmessage("设置物品升级概率有误，请输入0－100的数字！","javascript:history.back()");
}elseif($upitemname!='' && !preg_match("/^[a-zA-Z0-9_]{3,15}$/", $upitemname)){
showmessage("请正确输入3－15个字符的升级物品英文名称！","javascript:history.back()");
}elseif($upitemname!=''){
$query=$db->get_one("SELECT itemname FROM {$tablepre}wxitem where itemname='$upitemname' and itemtype='$itemtype'");
if(!$query){
showmessage("在同类型装备中不存在此物品，请返回重新输入！","javascript:history.back()");
}
}
$str=intval($str);
$kno=intval($kno);
$vit=intval($vit);
$dex=intval($dex);
$agi=intval($agi);
$maxmp=intval($maxmp);
$maxhp=intval($maxhp);
$sqlaa=",'$str','$vit','$kno','$dex','$agi','$maxhp','$maxmp'";
}else{
$sqlaa=",0,0,0,0,0,0,0";
$career=$itemsex=$uprange=0;
$upitemname='';
if(!in_array($addname,$addnamearray)){
$addname='';
}else{
$usetag=0;
}
}
$db->query("insert into {$tablepre}wxitem (usetag,numbers,upmoney,career,addname,upitemname,uprange,itemsex,moretxt,cname,pic,maxjob,itemname,droptag,selltag,cwb,yxb,requirejob,requirelevel,addnum,droplevel,droprange,itemtype,str,vit,kno,dex,agi,maxhp,maxmp) values ('$usetag','$numbers','$upmoney','$career','$addname','$upitemname','$uprange','$itemsex','$moretxt','$cname','$pic','$maxjob','$itemname','$droptag','$selltag','$sellcwb','$sellyxb','$requirejob','$requirelevel','$addnum','$droplevel','$droprange','$itemtype' $sqlaa)");
showmessage("物品添加成功！<BR><BR><a href=pet.php?index=admin&adminindex=item>宠物系统物品设置</a>");
}
}
}else{
$action='show';
$itemtypelist='<a href=pet.php?index=admin&adminindex=item&action=show&itemtype=0>所有</a> |';
foreach($typecname as $typeid => $values) {
$itemtypelist.=" <a href=pet.php?index=admin&adminindex=item&action=show&itemtype=$typeid>$values</a> |";
}
$itemtype=intval($itemtype)>0?intval($itemtype):0;
if($itemtype==0){
$sqlaa="select count(*) as num from {$tablepre}wxitem";
$sqlbb="";
}else{
$sqlaa="select count(*) as num from {$tablepre}wxitem where itemtype='$itemtype'";
$sqlbb=" and a.itemtype='$itemtype' ";
}
$strarr=array(" ","\\'","\'","'","%",";","\\","\"");
$cname=str_replace($strarr,"",$cname);
if($cname!=''){
$sqlaa="select count(*) as num from {$tablepre}wxitem where cname like '%".$cname."%'";
$sqlbb=" and a.cname like '%".$cname."%'";
$cname=rawurlencode($cname);
}
$perpage = 15;
$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=item&action=show&itemtype=$itemtype&cname=$cname";
$mulpage=multi($num, $perpage, $page, $mpurl);
$star = $num==0?0:($page * $perpage - $perpage);
$itemlist=array();
$query = $db->query("SELECT a.*,b.cname as upitemcname FROM {$tablepre}wxitem a left join {$tablepre}wxitem b on a.upitemname=b.itemname where 1 $sqlbb ORDER BY a.itemtype,a.itemname,a.addnum 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];
if($iteminfo['selltag']==1){
$iteminfo['selltag']='<font color=blue>普通商店</font>';
}elseif($iteminfo['selltag']==2){
$iteminfo['selltag']='<font color=red>特殊商店</font>';
}elseif($iteminfo['selltag']==3){
$iteminfo['selltag']='<font color=red>VIP商店</font>';
}else{
$iteminfo['selltag']='否';
}
if($iteminfo['droptag']==1){
$iteminfo['droptxt']='<font color=red>是</font>';
$iteminfo['droptxt'].="<br>概率：$iteminfo[droprange]%";
$iteminfo['droptxt'].="<br>怪物等级：$iteminfo[droplevel]";
}elseif($iteminfo['droptag']==0 && $iteminfo['droprange']>0){
$iteminfo['droptxt']='<font color=green>否</font>';
$iteminfo['droptxt'].="<br>概率：$iteminfo[droprange]%";
$iteminfo['droptxt'].="<br>怪物等级：$iteminfo[droplevel]";
}else{
$iteminfo['droptxt']='否';
}
$itemlist[] = $iteminfo;
}
}
include template('admin_item',9938,'wxpet/templates');
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -