|
本页为文章各类型的 更多新闻 页面
*
* 首先判断是否是子类型,如果是,则读出夫类型
* 如果是子类型,直接读取
* 如果是父类型,连接子类型读取
*
*/
$path="../admin/";
include_once $path."inc/config.inc.php";
include_once $path."db/mysql.php";
include_once $path."inc/templates.class.php";
include_once $path."inc/function.inc.php";
$param = array_merge($_GET,$_POST,$_REQUEST);
$param["class"];
$class = (int)$param["class"];
if(!is_int($class)||$class==0){exit();}
//数据库连接
$conn=new sql_db;
$conn->sql_connect($DB_Host,$DB_UserName,$DB_PassWord,$DB_Name);
$sql = "select CLASS_NAME,CLASS_LEVEL from CLASS where CLASS_ID=$class limit 1";
$rs = $conn->sql_query($sql);
$class_name = mysql_db_name($rs,0,"CLASS_NAME");
$class_leve = mysql_db_name($rs,0,"CLASS_LEVEL");
$class_id = $class;
if($class_leve > 0){ //条件为真时候传递过来的是子类型
$sql = "select CLASS_ID,CLASS_NAME,CLASS_LEVEL from CLASS where CLASS_ID=$class_id limit 1";
$rs = $conn->sql_query($sql);
$m_class_name = @mysql_db_name($rs,0,"CLASS_NAME");
$m_class_leve = @mysql_db_name($rs,0,"CLASS_LEVEL");
$m_class_id =@mysql_db_name($rs,0,"CLASS_ID");
$c_class_name = class_name;
$c_class_leve =class_leve;
$c_class_id = $class;
$type = "child";
}
else{ //此时传递过来的是父类型
$type = "parent";
$m_class_name = $class_name;
$m_class_leve =$class_leve;
$m_class_id = $class;
$sql = "select count(*) as num from CLASS where CLASS_LEVEL=$m_class_id";
$rs = $conn->sql_query($sql);
$child_num = @mysql_db_name($rs,0,"num");
if($child_num == 0){
$type = "alone";
}
}
if($type=="child"){
$num_sql ="select count(*) as num from ARTICAL,CLASS where ARTICAL_CLASS=$c_class_id and ARTICAL_CLASS = CLASS_ID";
$sql ="select ARTICAL_ID,ARTICAL_TITLE,ARTICAL_SHTML,ARTICAL_PATH,ARTICAL_CLASS,ARTICAL_HITS,ARTICAL_TIME,CLASS_ID,CLASS_NAME from ARTICAL,CLASS where ARTICAL_CLASS=$c_class_id and ARTICAL_CLASS = CLASS_ID order by ARTICAL_ID desc"; //需要limit
}
elseif($type=="parent"){
$num_sql ="select count(*) as num from ARTICAL,CLASS where CLASS_LEVEL=$m_class_id and ARTICAL_CLASS = CLASS_ID";
$sql="select ARTICAL_ID,ARTICAL_TITLE,ARTICAL_SHTML,ARTICAL_PATH,ARTICAL_CLASS,ARTICAL_HITS,ARTICAL_TIME,CLASS_ID,CLASS_NAME from ARTICAL,CLASS where CLASS_LEVEL=$m_class_id and ARTICAL_CLASS = CLASS_ID order by ARTICAL_ID desc"; ////需要limit
}
elseif($type=="alone"){
$num_sql ="select count(*) as num from ARTICAL,CLASS where ARTICAL_CLASS=$m_class_id and ARTICAL_CLASS = CLASS_ID";
$sql ="select ARTICAL_ID,ARTICAL_TITLE,ARTICAL_SHTML,ARTICAL_PATH,ARTICAL_CLASS,ARTICAL_HITS,ARTICAL_TIME,CLASS_ID,CLASS_NAME from ARTICAL,CLASS where ARTICAL_CLASS=$m_class_id and ARTICAL_CLASS = CLASS_ID order by ARTICAL_ID desc"; //需要limit
}
else{
exit();
}
$rs = $conn->sql_query($num_sql);
$total = mysql_db_name($rs,0,"num"); //得出总条数
$pagesize = 22; //每页显示12个图片
$pages = ceil($total/$pagesize);
$page = $param["page"];
if($page > $pages){$page = $pages;}
if($page < 1){$page = 1; }
$limit = " limit ".(($page-1)*$pagesize).",$pagesize ";
//经过限制之后的查询语句
$sql .= $limit;
$query_f=$conn->sql_query($sql);
$rt_n=$conn->sql_numrows($query_f);
$rt_f=$conn->sql_fetchrowset($query_f);
$news_array = $rt_f;
if(!is_array($news_array)){
$news_array = array();
}
$DoPage=new template("../".$Template_p);
$DoPage->set_file("Index_File","club_news.tpl");
if($type=="child"){
$DoPage->set_var("m_class_name",$m_class_name);
$DoPage->set_var("m_class_url",$title);
$DoPage->set_var("c_class_name",$c_class_name);
$DoPage->set_var("c_class_url",$title);
$DoPage->set_var("sign",">");
}
elseif($type=="parent"){
$DoPage->set_var("m_class_name",$m_class_name);
$DoPage->set_var("m_class_url",$title);
$DoPage->set_var("sign","");
}
$DoPage->set_block("Index_File","LIST","LISTA");
foreach($news_array as $key=>$val){
$DoPage->parse("LISTA","LIST",1);
$title = $val["ARTICAL_TITLE"];
$html_class_url = "class_url";
$class = $val["CLASS_NAME"];
$time = date("Y-m-d",$val["ARTICAL_TIME"]);
$path = $val["ARTICAL_PATH"];
$path = substr($path,2);
$shtml = $val["ARTICAL_SHTML"];
$url = Web_url . "html/?".$path.$shtml;
$DoPage->set_var("class_title","".$class ."]");
$DoPage->set_var("title",$title);
$DoPage->set_var("html_url",$url);
$DoPage->set_var("time",$time);
}
$URL = Web_url."html/more.shtml?";
foreach($_GET as $key=>$val){
if($key!="page"){
$URL_query .= "&".$key."=".$val;
}
}
if($URL_query!=""){ $URL = $URL.substr($URL_query,1);
$page_url = $URL."&";
}
else{ $URL = substr($URL,0,strlen($URL)-1); $page_url = $URL."?"; }
for($i=1;$i <= $pages;$i++){
$pagelist .= " $i";
}
$pagelist .=" ";
$DoPage->set_var("current_url",$URL);
$DoPage->set_var("nextpage",$page+1);
$DoPage->set_var("frontpage",$page-1);
$DoPage->set_var("page",$page);
$DoPage->set_var("pages",$pages);
$DoPage->set_var("total",$total);
$DoPage->set_var("pagesize",$pagesize);
$DoPage->set_var("pagelist",$pagelist);
$DoPage->parse("OutPut","Index_File");
$DoPage->p("OutPut");
?>
|
