📄 article.php

📁 程序安装简便容易
💻 PHP
字号:
<?php
!$_SERVER['PHP_SELF'] && $_SERVER['PHP_SELF']=$_SERVER['SCRIPT_NAME'];
substr($_SERVER['PHP_SELF'],-9,-4)!=='admin' && exit('Forbidden');

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

$orderdb=array(
	1=>'按发布时间由近到远',
	2=>'按浏览次数由多到少',
	3=>'按评论条数由多到少',
	4=>'按发布时间由远到近',
	5=>'按浏览次数由少到多',
	6=>'按评论条数由少到多',
);

if(!empty($_GET['do'])) {
	if($_GET['do']=='show') {
		$sort=$_POST['sort'];
		$order=$_POST['order'];
		$perpage=$_POST['perpage'];
		echo "<meta http-equiv='refresh' content='0;url=admin.php?job=article&sort=$sort&order=$order&perpage=$perpage'>";
		exit;
	} elseif($_GET['do']=='edit') {
		$aid=$_POST['aid'];
		$title_color=$_POST['title_color'];
		$title_extra=$_POST['title_extra'];
		$author=$_POST['author'];
		if(!empty($author)) {
			$rs=get_one("SELECT uid FROM duoxun_members WHERE username='$author'");
			$authorid=$rs['uid'];
		} else {
			$authorid='';
		}
		$itfrom=$_POST['itfrom'];
		$subject=$_POST['subject'];
		$ifshow=$_POST['ifshow'];
		$postdate=$_POST['postdate'];
		$userip=$_POST['userip'];
		$ifcommect=$_POST['ifcommect'];
		$commect_check=$_POST['commect_check'];
		$ipfrom=cvipfrom($onlineip);
		$ipfrom=str_replace("\n","",$ipfrom);
		$query=query("SELECT * FROM duoxun_comment WHERE aid=$aid AND ifshow=1");
		while($rs=fetch_array($query)) {
			$cnumdb[]=$rs;
		}
		$cnum=!empty($cnumdb) ? count($cnumdb) : 0;
		$pid=$_POST['pid'];
		$content=$_POST['content'];
		$query_a=query("UPDATE duoxun_subject SET title_color='$title_color',title_extra='$title_extra',author='$author',authorid='$authorid',itfrom='$itfrom',subject='$subject',ifshow='$ifshow',postdate='$postdate',userip='$userip',ifcommect='$ifcommect',commect_check='$commect_check',ipfrom='$ipfrom',cnum='$cnum' WHERE aid=$aid");
		$query_b=query("UPDATE duoxun_content SET content='$content' WHERE aid='$aid' AND pid='$pid'");
		if($set['ifhtml']=='1') {
			$query=query("SELECT * FROM duoxun_content WHERE aid='$aid' ORDER BY pid ASC");
			while($rs=fetch_array($query)) {
				$catedb[]=$rs;
			}
			if(count($catedb)<=1) {
				$fenye='';
				$content=$catedb[0]['content'];
				ob_start();
				include(R_P.$tplpath.'/readtpl.htm');
				writeover(R_P.$sid.'_'.$aid.'.html',ob_get_contents(),'rb+',0);
				ob_end_clean();
				@chmod(R_P.$sid.'_'.$aid.'.html',0777);
				unset($catedb);
			} elseif(count($catedb)>1) {
				foreach($catedb as $key=>$cate) {
					$key++;
					if($key==1) {
						$fenye='页码:<b><a href="'.$sid.'_'.$aid.'.html">'.$key.'</a></b>|';
						for($i=2;$i<count($catedb)+1;$i++) {
							$fenye.="<a href=".$sid."_".$aid."_".$i.".html>".$i."</a>|";
						}
						$content=$cate['content'];
						ob_start();
						include(R_P.$tplpath.'/readtpl.htm');
						writeover(R_P.$sid.'_'.$aid.'.html',ob_get_contents(),'rb+',0);
						ob_end_clean();
						@chmod(R_P.$sid.'_'.$aid.'.html',0777);
					} else {
						$fenye='页码:<a href="'.$sid.'_'.$aid.'.html">1</a>|';
						for($i=2;$i<count($catedb)+1;$i++) {
							$page=$i==$key ? '<b>'.$i.'</b>' : $i;
							$fenye.="<a href=".$sid."_".$aid."_".$i.".html>".$page."</a> |";
						}
						$content=$cate['content'];
						ob_start();
						include(R_P.$tplpath.'/readtpl.htm');
						writeover(R_P.$sid.'_'.$aid.'_'.$key.'.html',ob_get_contents(),'rb+',0);
						ob_end_clean();
						@chmod(R_P.$sid.'_'.$aid.'_'.$key.'.html',0777);
					}
				}
				unset($catedb);
			}
		}
		if($query_a && $query_b) {
			echo "<script language=\"javascript\">alert(\"文章编辑成功!\")</script>";
			echo "<meta http-equiv='refresh' content='0;url={$_COOKIE['article_u']}'>";
			exit;
		} else {
			echo "<script language=\"javascript\">alert(\"文章编辑失败！请重试！\")</script>";
			echo "<meta http-equiv='refresh' content='0;url={$_COOKIE['article_u']}'>";
			exit;
		}
	} elseif($_GET['do']=='admin') {
		foreach($_POST as $key=>$value) {
			if(is_numeric($key)) {
				query("UPDATE duoxun_subject SET topped='$value' WHERE aid='$key'");
			}
		}
		if(!empty($_POST['action']) && !empty($_POST['aids'])) {
			if($_POST['action']=='move') {
				$aid='';
				foreach($_POST['aids'] as $value) {
					$aid.=$value.',';
				}
				echo "<meta http-equiv='refresh' content='0;url=admin.php?job=move&id=$aid'>";
				exit;		
			} elseif($_POST['action']=='del') {
				foreach($_POST['aids'] as $value) {
					query("DELETE FROM duoxun_subject WHERE aid=$value");
					query("DELETE FROM duoxun_content WHERE aid=$value");
					query("DELETE FROM duoxun_comment WHERE aid=$value");
				}
				echo "<script language=\"javascript\">alert(\"操作成功！\")</script>";
				echo "<meta http-equiv='refresh' content='0;url={$_COOKIE['article_u']}'>";
				exit;
			}
		}
	} elseif($_GET['do']=='del_pid') {
		$aid=$_GET['aid'];
		$pid=$_GET['pid'];
		query("DELETE FROM duoxun_content WHERE aid=$aid AND pid=$pid");
		echo "<script language=\"javascript\">alert(\"已成功删除该篇文章！\")</script>";
		echo "<meta http-equiv='refresh' content='0;url={$_COOKIE['article_u']}'>";
		exit;
	} elseif($_GET['do']=='add_pid') {
		$aid=$_GET['aid'];
		$pid=$_GET['p_c'];
		$content=$_POST['pid_content'];
		$query=query("INSERT INTO duoxun_content (aid,pid,content) VALUES ('$aid','$pid','$content')");
		if($set['ifhtml']=='1') {
			$query=query("SELECT * FROM duoxun_content WHERE aid='$aid' ORDER BY pid ASC");
			while($rs=fetch_array($query)) {
				$catedb[]=$rs;
			}
			if(count($catedb)<=1) {
				$fenye='';
				$content=$catedb[0]['content'];
				ob_start();
				include(R_P.$tplpath.'/readtpl.htm');
				writeover(R_P.$sid.'_'.$aid.'.html',ob_get_contents(),'rb+',0);
				ob_end_clean();
				@chmod(R_P.$sid.'_'.$aid.'.html',0777);
				unset($catedb);
			} elseif(count($catedb)>1) {
				foreach($catedb as $key=>$cate) {
					$key++;
					if($key==1) {
						$fenye='页码:<b><a href="'.$sid.'_'.$aid.'.html">'.$key.'</a></b>|';
						for($i=2;$i<count($catedb)+1;$i++) {
							$fenye.="<a href=".$sid."_".$aid."_".$i.".html>".$i."</a>|";
						}
						$content=$cate['content'];
						ob_start();
						include(R_P.$tplpath.'/readtpl.htm');
						writeover(R_P.$sid.'_'.$aid.'.html',ob_get_contents(),'rb+',0);
						ob_end_clean();
						@chmod(R_P.$sid.'_'.$aid.'.html',0777);
					} else {
						$fenye='页码:<a href="'.$sid.'_'.$aid.'.html">1</a>|';
						for($i=2;$i<count($catedb)+1;$i++) {
							$page=$i==$key ? '<b>'.$i.'</b>' : $i;
							$fenye.="<a href=".$sid."_".$aid."_".$i.".html>".$page."</a> |";
						}
						$content=$cate['content'];
						ob_start();
						include(R_P.$tplpath.'/readtpl.htm');
						writeover(R_P.$sid.'_'.$aid.'_'.$key.'.html',ob_get_contents(),'rb+',0);
						ob_end_clean();
						@chmod(R_P.$sid.'_'.$aid.'_'.$key.'.html',0777);
					}
				}
				unset($catedb);
			}
		}
		if($query) {
			echo "<script language=\"javascript\">alert(\"已成功添加该篇文章！\")</script>";
			echo "<meta http-equiv='refresh' content='0;url=admin.php?job=edit&do=edit&id=$aid&pid=$pid'>";
			exit;
		} else {
			echo "<script language=\"javascript\">alert(\"该篇文章添加失败！请重试\")</script>";
			echo "<meta http-equiv='refresh' content='0;url=admin.php?job=edit&do=edit&id=$aid'>";
			exit;
		}			
	} elseif($_GET['do']=='del') {
		$aid=$_GET['id'];
		if($set['ifhtml']=='1') {
			$rs=get_one("SELECT COUNT(*) AS count FROM duoxun_content WHERE aid='$aid'");
			$sid=get_one("SELECT sid FROM duoxun_subject WHERE aid='$aid'");
			if($rs['count']<=1) {
				@unlink(R_P.$sid.'_'.$aid.'.htm');
			} else {
				@unlink(R_P.$sid.'_'.$aid.'.htm');
				for($i=2;$i<$rs['count']+1;$i++) {
					@unlink(R_P.$sid.'_'.$aid.'_'.$i.'.htm');
				}
			}
		}	
		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={$_COOKIE['article_u']}'>";
		exit;
	}	
}

$sort=empty($_GET['sort']) ? 0 : $_GET['sort'];
$order=empty($_GET['order']) ? 1 : $_GET['order'];
$perpage=empty($_GET['perpage']) ? 35 : $_GET['perpage'];

switch($order) {
	case 1:
		$sqladd='ORDER BY postdate DESC';
		break;
	case 2:
		$sqladd='ORDER BY hits DESC,postdate DESC';
		break;
	case 3:
		$sqladd='ORDER BY cnum DESC,postdate DESC';
		break;
	case 4:
		$sqladd='ORDER BY postdate ASC';
		break;
	case 5:
		$sqladd='ORDER BY hits ASC,postdate DESC';
		break;
	case 6:
		$sqladd='ORDER BY cnum ASC,postdate DESC';
		break;
}

$rs=get_one("SELECT COUNT(*) AS count FROM duoxun_subject WHERE sid={$sortdb[$sort]['sid']} AND topped=0");
$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;
}

$query=query("SELECT * FROM duoxun_subject WHERE sid={$sortdb[$sort]['sid']} AND topped!=0 ORDER BY topped ASC");
while($rs=fetch_array($query)) {
	$topdb[]=$rs;
}

$query=query("SELECT * FROM duoxun_subject WHERE sid={$sortdb[$sort]['sid']} AND topped=0 $sqladd LIMIT $start,$perpage");
while($rs=fetch_array($query)) {
	$catedb[]=$rs;
}

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

$article_u='admin.php?'.$_SERVER['QUERY_STRING'];
setcookie('article_u','',$timestamp-86400);
setcookie('article_u',$article_u,$timestamp+86400);

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

?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -