admin_subject.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=='edit'){
	$act='editsave';
	$show='编辑题目';
	$subjectid=intval($subjectid);
	$subjectinfo=$db->get_one("SELECT * FROM {$tablepre}wxsubject where id='$subjectid'");
	if(!$subjectinfo){showmessage("未定义操作");}
	$subjectinfo['subject']=htmlspecialchars($subjectinfo['subject']);
	$subjectinfo['key1']=htmlspecialchars($subjectinfo['key1']);
	$subjectinfo['key2']=htmlspecialchars($subjectinfo['key2']);
	$subjectinfo['key3']=htmlspecialchars($subjectinfo['key3']);
	$subjectinfo['key4']=htmlspecialchars($subjectinfo['key4']);
}elseif($action=='add'){
	$show='增加题目';
	$subjectinfo=array();
	$act='addsave';

}elseif($action=='del'){
	$subjectid=intval($subjectid);
	$subjectinfo=$db->get_one("SELECT * FROM {$tablepre}wxsubject where id='$subjectid'");
	$db->query("delete from {$tablepre}wxsubject where id='$subjectid'");
	showmessage("删除题目完成！<BR><BR><a href=pet.php?index=admin&adminindex=subject>题目管理</a>");
}elseif($action=='addsave'){
	$subject=trim($subject);
	$key1=trim($key1);
	$key2=trim($key2);
	$key3=trim($key3);
	$key4=trim($key4);
	$truekey=intval($truekey);
	
	if($subject=='' || $key1=='' || $key2==''){showmessage("题目、答案1和答案2必须填写！","javascript:history.back()");}
	if($truekey>4 || $truekey<1){showmessage("正确答案填写有误！","javascript:history.back()");}
	
	$db->query("insert into {$tablepre}wxsubject (subject,key1,key2,key3,key4,truekey) values ('$subject','$key1','$key2','$key3','$key4','$truekey')");
	showmessage("题目添加完成！<BR><BR><a href=pet.php?index=admin&adminindex=subject>题目管理</a>");

}elseif($action=='editsave'){
	$subjectid=intval($subjectid);
	$subjectinfo=$db->get_one("SELECT * FROM {$tablepre}wxsubject where id='$subjectid'");
	if(!$subjectinfo){showmessage("未定义操作");}
  
	$subject=trim($subject);
	$key1=trim($key1);
	$key2=trim($key2);
	$key3=trim($key3);
	$key4=trim($key4);
	$truekey=intval($truekey);
	
	if($subject=='' || $key1=='' || $key2==''){showmessage("题目、答案1和答案2必须填写！","javascript:history.back()");}
	if($truekey>4 || $truekey<1){showmessage("正确答案填写有误！","javascript:history.back()");}
   
	
	$db->query("update {$tablepre}wxsubject set subject='$subject',key1='$key1',key2='$key2',key3='$key3',key4='$key4',truekey='$truekey' where id='$subjectid'");
	showmessage("题目编辑完成！<BR><BR><a href=pet.php?index=admin&adminindex=subject>题目管理</a>");

}else{
	$action='show';
	$sqlbb="";

	$subject=str_replace($strarr,"",$subject);
	if($subject!='' && cnstrlen($subject)<20){
		$sqlbb=" and subject like '%".$subject."%'";
		$subject=rawurlencode(stripslashes($subject));
	}
	
	$perpage = 20; //每页显示记录数
    $page=intval($page);
    if($page<1) $page=1;
	
	$query=$db->get_one("select count(*) as num from {$tablepre}wxsubject where 1 $sqlbb");
	$num = $query['num'];
	$pagesnum=ceil($num/$perpage);
	if($page>=$pagesnum) $page=$pagesnum;
	$mpurl = "pet.php?index=admin&adminindex=subject&action=show&subject=$subject";
	$mulpage=multi($num, $perpage, $page, $mpurl);
	$star = $page * $perpage - $perpage; 
	if($num==0)$star=0;
	$subjectlist=array(); 
	$query = $db->query("SELECT * FROM {$tablepre}wxsubject where 1 $sqlbb   ORDER BY id  LIMIT $star,$perpage");
	while($subectinfo = $db->fetch_array($query)) {
		$subjectinfo['subject']=htmlspecialchars($subjectinfo['subject']);
		$subjectlist[]=$subectinfo;
	}
}

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