article.php

来自「phpcms网站管理系统 很不错的 有需要的就下载看看八 」· PHP 代码 · 共 869 行 · 第 1/3 页

	$result=$db->query("SELECT articleid,channelid,catid,title,includepic,titlefontcolor,titlefonttype,showcommentlink,hits,username,addtime,editor,edittime,checker,checktime,ontop,elite,stars,recycle,status FROM ".TABLE_ARTICLE." WHERE status=3 AND recycle=0 AND channelid='$channelid' $addquery ORDER BY $dordertype LIMIT $offset,$pagesize");
	while($r=$db->fetch_array($result))
	{
		$p->set_catid($r[catid]);
		$r[url] = $p->get_itemurl($r[articleid],$r[addtime]);
		$r[catdir] = $p->get_listurl(1);
		$r[title] = titleformat($r[title],$r[titlefontcolor],$r[titlefonttype],$r[includepic]);
		$r[adddate]=date("Y-m-d",$r[addtime]);
		$articles[]=$r;
	}
	include admintpl('article_manage');
break;

case 'special':
	$referer=urlencode('?mod='.$mod.'&file='.$file.'&action=special&channelid='.$channelid.'&specialid='.$specialid.'&srchtype='.$srchtype.'&keyword='.$keyword.'&ontop='.$ontop.'&elite='.$elite.'&ordertype='.$ordertype.'&page='.$page);
	if(!$page)
	{
		$page=1;
		$offset=0;
	}
	else
	{
		$offset=($page-1)*$pagesize;
	}

	if(!empty($keywords))
	{
		$keyword=str_replace(' ','%',$keywords);
		$keyword=str_replace('*','%',$keyword);
		switch($srchtype)
		{
		case '0':
				$addquery=" AND (title LIKE '%$keyword%' or titleintact LIKE '%$keyword%' or subheading LIKE '%$keyword%') ";
		break;
		case '1':
				$addquery=" AND content LIKE '%$keyword%' ";
		break;
		case '2':
				$addquery=" AND author LIKE '%$keyword%' ";
		break;
		case '3':
				$addquery=" AND username LIKE '%$keyword%' ";
		break;
		default :
				$addquery=" AND (title LIKE '%$keyword%' or titleintact LIKE '%$keyword%' or subheading LIKE '%$keyword%') ";
		}
	}

	$addquery .= $specialid ? " AND specialid=$specialid " : "";
	$addquery .= $elite ? " AND elite=1 " : "";
	$addquery .= $ontop ? " AND ontop=1 " : "";
	$addquery .= $time ? sql_time($time) : "";
	switch($ordertype)
	{
		case 1:
			$dordertype=" articleid DESC ";
		break;
		case 2:
			$dordertype=" articleid ";
		break;
		case 3:
			$dordertype=" hits DESC ";
		break;
		case 4:
			$dordertype=" hits ";
		break;
		default :
			$dordertype=" articleid DESC ";
	}

	$r = $db->get_one("SELECT COUNT(*) AS num FROM ".TABLE_ARTICLE." a WHERE status=3 AND recycle=0 AND specialid>0 AND channelid='$channelid' $addquery");
	$number=$r["num"];
	$url="?mod=".$mod."&file=".$file."&action=special&channelid=".$channelid."&catid=".$catid."&specialid=".$specialid."&srchtype=".$srchtype."&keyword=".$keyword."&ontop=".$ontop."&elite=".$elite."&ordertype=".$ordertype."&page=".$page;
	$pages=phppages($number,$page,$pagesize,$url);
	$result=$db->query("SELECT articleid,specialid,catid,title,includepic,titlefontcolor,titlefonttype,showcommentlink,hits,username,addtime,editor,edittime,checker,checktime,ontop,elite,stars FROM ".TABLE_ARTICLE." WHERE status=3 AND recycle=0 AND specialid>0 AND channelid='$channelid' $addquery ORDER BY $dordertype LIMIT $offset,$pagesize");
	while($r=$db->fetch_array($result))
	{
	    $s = $db->get_one("SELECT specialid,specialname,addtime FROM ".TABLE_SPECIAL." a WHERE specialid=$r[specialid]");
		$p->set_catid($r[catid]);
		$r[url] = $p->get_itemurl($r[articleid],$r[addtime]);
		$r[specialname] = wordscut($s[specialname],24,1);
		$r[specialurl] = $p->get_specialitemurl($s[specialid],$s[addtime]);
		$r[title] = titleformat($r[title],$r[titlefontcolor],$r[titlefonttype],$r[includepic]);
		$r[adddate]=date("Y-m-d",$r[addtime]);
		$articles[]=$r;
	}
	$special_list = special_select($channelid,'specialid','请选择专题',$specialid);
	$special_select = special_select($channelid,'jump','请选择专题进行管理',$specialid,'onchange="if(this.options[this.selectedIndex].value!=\'\'){location=\'?mod='.$mod.'&file='.$file.'&action=special&channelid='.$channelid.'&specialid=\'+this.options[this.selectedIndex].value;}"');
	include admintpl('article_special');
break;

case 'myitem':

	$status=isset($status) ? $status : 3;
	$referer=urlencode('?mod='.$mod.'&file='.$file.'&action=myitem&channelid='.$channelid.'&catid='.$catid.'&status='.$status.'&srchtype='.$srchtype.'&keyword='.$keyword.'&ontop='.$ontop.'&elite='.$elite.'&ordertype='.$ordertype.'&page='.$page);
	@extract($db->get_one("SELECT COUNT(*) AS num_3 FROM ".TABLE_ARTICLE." WHERE status=3 AND username='$_username' AND recycle=0 AND channelid='$channelid'","CACHE"));
	@extract($db->get_one("SELECT COUNT(*) AS num_1 FROM ".TABLE_ARTICLE." WHERE status=1 AND username='$_username' AND recycle=0 AND channelid='$channelid'","CACHE"));
	@extract($db->get_one("SELECT COUNT(*) AS num_0 FROM ".TABLE_ARTICLE." WHERE status=0 AND username='$_username' AND recycle=0 AND channelid='$channelid'","CACHE"));
	@extract($db->get_one("SELECT COUNT(*) AS num_2 FROM ".TABLE_ARTICLE." WHERE status=2 AND username='$_username' AND recycle=0 AND channelid='$channelid'","CACHE"));
	if(!$page)
	{
		$page=1;
		$offset=0;
	}
	else
	{
		$offset=($page-1)*$pagesize;
	}
		if(!empty($keywords))
	{
		$keyword=str_replace(' ','%',$keywords);
		$keyword=str_replace('*','%',$keyword);
		switch($srchtype)
		{
		case '0':
				$addquery=" AND (title LIKE '%$keyword%' or titleintact LIKE '%$keyword%' or subheading LIKE '%$keyword%') ";
		break;
		case '1':
				$addquery=" AND content LIKE '%$keyword%' ";
		break;
		case '2':
				$addquery=" AND author LIKE '%$keyword%' ";
		break;
		case '3':
				$addquery=" AND username LIKE '%$keyword%' ";
		break;
		default :
				$addquery=" AND (title LIKE '%$keyword%' or titleintact LIKE '%$keyword%' or subheading LIKE '%$keyword%') ";
		}
	}
	if($catid)
	{
		$arrchildid=$_CAT[$catid][child] ? $_CAT[$catid][arrchildid] : $catid;
		$addquery.=" AND catid IN($arrchildid) ";
	}
	$addquery .= $elite ? " AND elite=1 " : "";
	$addquery .= $ontop ? " AND ontop=1 " : "";
	switch($ordertype)
	{
		case 1:
			$dordertype=" articleid DESC ";
		break;
		case 2:
			$dordertype=" articleid ";
		break;
		case 3:
			$dordertype=" hits DESC ";
		break;
		case 4:
			$dordertype=" hits ";
		break;
		default :
			$dordertype=" articleid DESC ";
	}

	$query="SELECT COUNT(*) as num FROM ".TABLE_ARTICLE." WHERE status='$status' AND username='$_username' AND recycle=0 AND channelid='$channelid' $addquery ";
	$result=$db->query($query);
	$r=$db->fetch_array($result);
	$number=$r["num"];
	$url="?mod=".$mod."&file=".$file."&action=myitem&channelid=".$channelid."&catid=".$catid."&status=".$status."&srchtype=".$srchtype."&keyword=".$keyword."&ontop=".$ontop."&elite=".$elite."&ordertype=".$ordertype."&page=".$page;
	$pages=phppages($number,$page,$pagesize,$url);
	$query="SELECT articleid,channelid,catid,title,includepic,titlefontcolor,titlefonttype,showcommentlink,hits,username,addtime,editor,edittime,checker,checktime,ontop,elite,stars,recycle,status FROM ".TABLE_ARTICLE." WHERE status='$status' AND username='$_username' AND recycle=0 AND channelid='$channelid' $addquery ORDER BY $dordertype LIMIT $offset,$pagesize ";
	$result=$db->query($query);
	while($r=$db->fetch_array($result))
	{
		$r[url] = $p->get_itemurl($r[articleid],$r[addtime]);
		$p->set_catid($r[catid]);
		$r[catdir] = $p->get_caturl();
		$r[title] = titleformat($r[title],$r[titlefontcolor],$r[titlefonttype],$r[includepic]);
		$r[adddate]=date("Y-m-d",$r[addtime]);
		
		$articles[]=$r;
	}
	
	include admintpl('article_myitem');
break;


case 'check':
	$referer=urlencode("?mod=".$mod."&file=".$file."&action=check&channelid=".$channelid."&catid=".$catid."&srchtype=".$srchtype."&keywords=".$keywords."&ordertype=".$ordertype."&page=".$page);
	if(!$page)
	{
		$page=1;
		$offset=0;
	}
	else
	{
		$offset=($page-1)*$pagesize;
	}

	if(!empty($keywords))
	{
		$keyword=str_replace(' ','%',$keywords);
		$keyword=str_replace('*','%',$keyword);
		switch($srchtype)
		{
		case '0':
				$addquery=" AND (title LIKE '%$keyword%' or titleintact LIKE '%$keyword%' or subheading LIKE '%$keyword%') ";
		break;
		case '1':
				$addquery=" AND content LIKE '%$keyword%' ";
		break;
		case '2':
				$addquery=" AND author LIKE '%$keyword%' ";
		break;
		case '3':
				$addquery=" AND username LIKE '%$keyword%' ";
		break;
		default :
				$addquery=" AND (title LIKE '%$keyword%' or titleintact LIKE '%$keyword%' or subheading LIKE '%$keyword%') ";
		}
	}
	if($catid)
	{
		$addquery.=" AND catid=$catid ";
	}
	elseif($_grade==5)
	{
		$catids = is_array($_purview_category) ? implode(",",$_purview_category) : "";
		$addquery .= $catids ? " AND catid IN($catids) " : "";
	}

	switch($ordertype)
	{
		case 1:
			$dordertype=" articleid DESC ";
		break;
		case 2:
			$dordertype=" articleid ";
		break;
		case 3:
			$dordertype=" hits DESC ";
		break;
		case 4:
			$dordertype=" hits ";
		break;
		default :
			$dordertype=" articleid DESC ";
	}
	$r = $db->get_one("SELECT COUNT(*) AS num FROM ".TABLE_ARTICLE." WHERE status=1 AND recycle=0 AND channelid='$channelid' $addquery");
	$number=$r["num"];
	$url="?mod=".$mod."&file=".$file."&action=check&channelid=".$channelid."&catid=".$catid."&srchtype=".$srchtype."&keyword=".$keyword."&ordertype=".$ordertype."&page=".$page;
	$pages=phppages($number,$page,$pagesize,$url);
	$result=$db->query("SELECT articleid,channelid,catid,title,includepic,titlefontcolor,titlefonttype,showcommentlink,hits,username,addtime,editor,edittime,checker,checktime,ontop,elite,stars,recycle,status FROM ".TABLE_ARTICLE." WHERE status=1 AND recycle=0 AND channelid='$channelid' $addquery ORDER BY $dordertype LIMIT $offset,$pagesize");
	while($r=$db->fetch_array($result))
	{
		$p->set_catid($r[catid]);
		$r[catdir] = $p->get_caturl();
		$r[title] = titleformat($r[title],$r[titlefontcolor],$r[titlefonttype],$r[includepic]);
		$r[adddate]=date("Y-m-d",$r[addtime]);
		
		$articles[]=$r;
	}
	include admintpl('article_check');
break;

case 'sendback':

	if($submit)
	{
		if(empty($articleid))
		{
			showmessage('非法参数！请返回！');
		}
		if($ifpm)
		{
			if(empty($title))
			{
				showmessage('对不起，标题不能为空！请返回！');
			}
			if(empty($content))
			{
				showmessage('对不起，内容不能为空！请返回！');
			}
			sendpm($username,$title,$content);
		}
		if($ifemail)
		{
			sendusermail($username,$title,$content);
		}
		$db->query("UPDATE ".TABLE_ARTICLE." SET status=2,elite=0,ontop=0 WHERE articleid='$articleid' AND channelid='$channelid'");
		showmessage('操作成功！',$referer);

	}
	else
	{
		if(empty($articleid))
		{
			showmessage('非法参数！请返回！');
		}