article_check.php

程序安装简便容易

<?php
!$_SERVER['PHP_SELF'] && $_SERVER['PHP_SELF']=$_SERVER['SCRIPT_NAME'];
substr($_SERVER['PHP_SELF'],-9,-4)!=='admin' && exit('Forbidden');

include_once(R_P.'cache/set.php');

$query=query("SELECT * FROM duoxun_sort ORDER BY vieworder ASC,sid ASC");
while($rs=fetch_array($query)) {
	$sortdb[]=$rs;
}

$s_sid=empty($_GET['sort']) ? 'all' : $_GET['sort'];
$all_selected=$s_sid=='all' ? ' selected' : '';
$perpage=empty($_GET['perpage']) ? 35 : $_GET['perpage'];

$sql=$s_sid=='all' ? "SELECT COUNT(*) AS count FROM duoxun_subject WHERE ifshow=0" : "SELECT COUNT(*) AS count FROM duoxun_subject WHERE sid=$s_sid AND ifshow=0";
$rs=get_one($sql);
$num=$rs['count'];
$pages=ceil($num/$perpage);

if(empty($_GET['page']) || $_GET['page']<1) {
	$page=1;
	$start=0;
} elseif($_GET['page']>$pages) {
	$page=$pages;
	$start=($page-1)*$perpage;
} else {
	$page=$_GET['page'];
	$start=($page-1)*$perpage;
}

$sql=$s_sid=='all' ? "SELECT * FROM duoxun_subject WHERE ifshow=0 ORDER BY postdate DESC,aid DESC LIMIT $start,$perpage" : "SELECT * FROM duoxun_subject WHERE sid=$s_sid AND ifshow=0 ORDER BY postdate DESC,aid DESC LIMIT $start,$perpage";
$query=query($sql);
while($rs=fetch_array($query)) {
	$catedb[]=$rs;
}

$mpurl="admin.php?job=article_check&sort=$s_sid&perpage=$perpage";
$fenye=admin_fenye($num,$perpage,$page,$mpurl,0);

$s_num=!empty($catedb) ? count($catedb) : 0;

if($s_sid=='all') {
	$s_name='全部待审核文章';
	$s_out='总共有'.$s_num.'条主题文章待审核';
} else {
	$rs=get_one("SELECT name FROM duoxun_sort WHERE sid=$s_sid");
	$s_name=$rs['name'];
	$s_out='分类'.$s_name.'现有'.$s_num.'条主题文章待审核';
}

if(!empty($_GET['do'])) {
	if($_GET['do']=='show') {
		$sort=$_POST['sort'];
		$perpage=$_POST['perpage'];
		echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article_check&sort=$sort&perpage=$perpage'>";
		exit;
	} elseif($_GET['do']=='pass') {
		$aid=$_GET['id'];
		$query=query("UPDATE duoxun_subject SET ifshow='1' WHERE aid='$aid'");
		if($query) {
			echo "<script language=\"javascript\">alert(\"通过审核操作成功！\")</script>";
			echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article_check&sort=$s_sid&perpage=$perpage&page=$page'>";			
			exit;
		} else {
			echo "<script language=\"javascript\">alert(\"通过审核操作失败！请重试！\")</script>";
			echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article_check&sort=$s_sid&perpage=$perpage&page=$page'>";			
			exit;
		}
	} elseif($_GET['do']=='del') {
		$aid=$_GET['id'];
		query("DELETE FROM duoxun_subject WHERE aid=$aid");
		query("DELETE FROM duoxun_content WHERE aid=$aid");
		query("DELETE FROM duoxun_comment WHERE aid=$aid");
		echo "<script language=\"javascript\">alert(\"删除成功！\")</script>";
		echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article_check&sort=$s_sid&perpage=$perpage&page=$page'>";			
		exit;
	} elseif($_GET['do']=='admin') {
		if(!empty($_POST['action']) && !empty($_POST['aids'])) {
			if($_POST['action']=='pass') {
				foreach($_POST['aids'] as $aid) {
					query("UPDATE duoxun_subject SET ifshow='1' WHERE aid='$aid'");
				}
				echo "<script language=\"javascript\">alert(\"操作成功！\")</script>";
				echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article_check&sort=$s_sid&perpage=$perpage&page=$page'>";			
				exit;
			} elseif($_POST['action']=='del') {
				foreach($_POST['aids'] as $aid) {
					query("DELETE FROM duoxun_subject WHERE aid=$aid");
					query("DELETE FROM duoxun_content WHERE aid=$aid");
					query("DELETE FROM duoxun_comment WHERE aid=$aid");
				}
				echo "<script language=\"javascript\">alert(\"删除成功！\")</script>";
				echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article_check&sort=$s_sid&perpage=$perpage&page=$page'>";			
				exit;
			}
		}
	} elseif($_GET['do']=='check') {
		$aid=$_GET['id'];
		
		$subject=get_one("SELECT * FROM duoxun_subject WHERE aid=$aid");
		  $select_color_a=$subject['title_color']=='White' ? ' selected' : '';
		  $select_color_b=$subject['title_color']=='Black' ? ' selected' : '';
		  $select_color_c=$subject['title_color']=='Red' ? ' selected' : '';
		  $select_color_d=$subject['title_color']=='Yellow' ? ' selected' : '';
		  $select_color_e=$subject['title_color']=='Pink' ? ' selected' : '';
		  $select_color_f=$subject['title_color']=='Green' ? ' selected' : '';
		  $select_color_g=$subject['title_color']=='Orange' ? ' selected' : '';
		  $select_color_h=$subject['title_color']=='Purple' ? ' selected' : '';
		  $select_color_i=$subject['title_color']=='Blue' ? ' selected' : '';
		  $select_color_j=$subject['title_color']=='Beige' ? ' selected' : '';
		  $select_color_k=$subject['title_color']=='Brown' ? ' selected' : '';
		  $select_color_l=$subject['title_color']=='Teal' ? ' selected' : '';
		  $select_color_m=$subject['title_color']=='Navy' ? ' selected' : '';
		  $select_color_n=$subject['title_color']=='Maroon' ? ' selected' : '';
		  $select_color_o=$subject['title_color']=='LimeGreen' ? ' selected' : '';

		  $select_extra_a=$subject['title_extra']=='b' ? ' selected' : '';
		  $select_extra_b=$subject['title_extra']=='i' ? ' selected' : '';
		  $select_extra_c=$subject['title_extra']=='u' ? ' selected' : '';

		  $select_comment_a=$subject['ifcommect']==1 ? ' checked' : '';
		  $select_comment_b=$subject['ifcommect']==0 ? ' checked' : '';

		  $select_commect_check_a=$subject['commect_check']==1 ? ' checked' : '';
		  $select_commect_check_b=$subject['commect_check']==0 ? ' checked' : '';
		  

		$query=query("SELECT * FROM duoxun_content WHERE aid=$aid ORDER BY pid ASC");
		while($rs=fetch_array($query)) {
			$contentdb[]=$rs;
		}

		$pid=$contentdb[0]['pid'];		
		$pid=empty($_GET['pid']) ? $pid : $_GET['pid'];
		$pid_num=!empty($contentdb) ? count($contentdb) : 0;
		for($i=0;$i<$pid_num;$i++) {
			if($contentdb[$i]['pid']==$pid) {
				$pid_p=$i;
				$pid_pid=$i+1;
			}
		}			
	} elseif($_GET['do']=='change') {
		$aid=$_POST['aid'];
		$pid=$_POST['pid'];
		$subject=$_POST['subject'];
		$title_color=$_POST['title_color'];
		$title_extra=$_POST['title_extra'];
		$sid=$_POST['sid'];
		$topped=$_POST['topped'];
		$ifcommect=$_POST['ifcommect'];
		$commect_check=$_POST['commect_check'];
		$content=$_POST['content'];
		query("UPDATE duoxun_subject SET subject='$subject',title_color='$title_color',title_extra='$title_extra',sid='$sid',topped='$topped',ifcommect='$ifcommect',commect_check='$commect_check' WHERE aid='$aid'");
		query("UPDATE duoxun_content SET content='$content' WHERE aid='$aid' AND pid='$pid'");
		echo "<script language=\"javascript\">alert(\"修改成功！\")</script>";
		echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article_check&sort=$s_sid&perpage=$perpage&page=$page'>";
		exit;
	}
}

require_once template('article_check','admin');

?>