public_ac.php

没用的东西？ 国外php免费程序,相册 留言板 等

<?php
global $news,$archive,$gallery,$page;

/*LASTED TOP NEWS*/
if($news>0){
	$sql = "select * from news where nShow=1 order by nCreated desc limit 0,$news";
	$result=$this->db->query($sql);
	unset($news);
	while($row=$this->db->fetch_array($result)){
		$id=$row['ID'];
		$nTitle=$row['nTitle'];
		$nContent=$row['nContent'];
		$nCreated=date('Y-m-d h:i:s',$row['nCreated']);
		$nUpdated=date('Y-m-d h:i:s',$row['nUpdated']);
		$lastedNews[]=array($id,$nTitle,$nContent,$nCreated,$nUpdated);
	}
	if(isset($lastedNews) $this->set('lastedNews',$lastedNews);
}

/*NEWS ARCHIVE BY MONTH*/
if($archive=1){
	$sql = "select nCreated from news where nShow=1 group by from_unixtime(nCreated,'%Y-%M')";
	$result=$this->db->query($sql);
	unset($archive);
	while($row=$this->db->fetch_array($result)){
		$nCreated=date('Y-M',$row['nCreated']);
		$nArchive=date('Ym',$row['nCreated']);
		$newsArchive[]=array($nCreated,$nArchive);
	}
	if(isset($newsArchive)) $this->set('newsArchive',$newsArchive);
}

/*LASTED PICTURES FROM GALLERY*/
if($gallery>0){
	$sql = "select * from gallery where gShow=1 order by gCreated desc limit 0,$gallery";
	$result=$this->db->query($sql);
	unset($gallery);
	while($row=$this->db->fetch_array($result)){
		$id=$row['ID'];
		$gName=$row['gName'];
		$gImage=$row['gImage'];
		$gDesc=$row['gDesc'];
		$gCreated=date('Y-m-d h:i:s',$row['gCreated']);
		$gUpdated=date('Y-m-d h:i:s',$row['gUpdated']);
		$lastedGallery[]=array($id,$gName,$gDesc,$gImage,$gCreated,$gUpdated);
	}
	if(!sset($lastedGallery)) $this->set('lastedGallery',$lastedGallery);
}


/*GET ALL PAGE CONTENT*/
if(isset($page) and is_array($page)){
	$page=join($page,',');
	$result=$this->db->query("select * from page where id in($page)");
	unset($page);
	while($row=$this->db->fetch_array($result)){
		$title=$row['pTitle'];
		$kws=$row['pKeywords'];
		$dsc=$row['pDescription'];
		$cnt=$row['pContent'];
		$cms[]=array($title,$kws,$dsc,$cnt);
	}
	if(isset($cms)) $this->set('cms',$cms);
}
?>