修改路径m\e\class\t_functions.php大概在100行左右。已可以搜索“列表模板之列表式分页”换成下面的代码:
//列表模板之列表式分页
function sys_ShowListMorePage($num,$page,$dolink,$type,$totalpage,$line,$ok,$search="",$add){
global $fun_r,$public_r;
if($num<=$line)
{
$pager['showpage']='';
return $pager;
}
//文件名
if(empty($add['dofile']))
{
$add['dofile']='index';
}
//静态页数
$repagenum=$add['repagenum'];
$page_line=$public_r['listpagelistnum'];
$snum=2;
$totalpage=ceil($num/$line);//取得总页数
$firststr='<a title="Total record"> <b>'.$num.'</b> </a> ';
//上一页
if($page<>1)
{
$toppage='<a href="'.$dolink.$add['dofile'].$type.'">'.$fun_r['startpage'].'</a>';
$pagepr=$page-1;
if($pagepr==1)
{
$prido=$add['dofile'].$type;
}
else
{
$prido=$add['dofile'].'_'.$pagepr.$type;
}
$prepage='<a href="'.$dolink.$prido.'">'.$fun_r['pripage'].'</a>';
}else{
$toppage='<a >'.$fun_r['startpage'].'</a>';
$prepage='<a >'.$fun_r['pripage'].'</a>';
}
//下一页
if($page!=$totalpage)
{
$pagenex=$page+1;
$nextpagelink=$repagenum&&$repagenum<$pagenex?eReturnRewritePageLink2($add,$pagenex):$dolink.$add['dofile'].'_'.$pagenex.$type;
$lastpagelink=$repagenum&&$repagenum<$totalpage?eReturnRewritePageLink2($add,$totalpage):$dolink.$add['dofile'].'_'.$totalpage.$type;
$nextpage='<a href="'.$nextpagelink.'">'.$fun_r['nextpage'].'</a>';
$lastpage='<a href="'.$lastpagelink.'">'.$fun_r['lastpage'].'</a>';
}else{
$nextpage='<a>'.$fun_r['nextpage'].'</a>';
$lastpage='<a>'.$fun_r['lastpage'].'</a>';
}
$starti=$page-$snum<1?1:$page-$snum;
$no=0;
for($i=$starti;$i<=$totalpage&&$no<$page_line;$i++)
{
$no++;
if($page==$i)
{
$is_1="<b>";
$is_2="</b>";
}
elseif($i==1)
{
$is_1='<a href="'.$dolink.$add['dofile'].$type.'">';
$is_2="</a>";
}
else
{
$thispagelink=$repagenum&&$repagenum<$i?eReturnRewritePageLink2($add,$i):$dolink.$add['dofile'].'_'.$i.$type;
$is_1='<a href="'.$thispagelink.'">';
$is_2="</a>";
}
$returnstr.=' '.$is_1.$i.$is_2;
}
$returnstr=$toppage.$prepage.'<span>'.$page.'/'.$totalpage.'页</span>'.$nextpage.$lastpage;
$pager['showpage']=$returnstr;
return $pager;
}
//返回内容分页
function sys_ShowTextPage($totalpage,$page,$dolink,$add,$type,$search=""){
global $fun_r,$public_r;
if($totalpage==1)
{
return '';
}
$page_line=$public_r['textpagelistnum'];
$snum=2;
//$totalpage=ceil($num/$line);//取得总页数
$firststr='<a title="Page"> <b>'.$page.'</b>/<b>'.$totalpage.'</b> </a> ';
//上一页
if($page<>1)
{
$toppage='<a href="'.$dolink.$add[filename].$type.'">'.$fun_r['startpage'].'</a> ';
$pagepr=$page-1;
if($pagepr==1)
{
$prido=$add[filename].$type;
}
else
{
$prido=$add[filename].'_'.$pagepr.$type;
}
$prepage='<a href="'.$dolink.$prido.'">'.$fun_r['pripage'].'</a>';
}
//下一页
if($page!=$totalpage)
{
$pagenex=$page+1;
$nextpage=' <a href="'.$dolink.$add[filename].'_'.$pagenex.$type.'">'.$fun_r['nextpage'].'</a>';
$lastpage=' <a href="'.$dolink.$add[filename].'_'.$totalpage.$type.'">'.$fun_r['lastpage'].'</a>';
}
$starti=$page-$snum<1?1:$page-$snum;
$no=0;
for($i=$starti;$i<=$totalpage&&$no<$page_line;$i++)
{
$no++;
if($page==$i)
{
$is_1="<b>";
$is_2="</b>";
}
elseif($i==1)
{
$is_1='<a href="'.$dolink.$add[filename].$type.'">';
$is_2="</a>";
}
else
{
$is_1='<a href="'.$dolink.$add[filename].'_'.$i.$type.'">';
$is_2="</a>";
}
$returnstr.=' '.$is_1.$i.$is_2;
}
$returnstr=$firststr.$toppage.$prepage.$returnstr.$nextpage.$lastpage;
return $returnstr;
}
//返回下拉式内容分页导航
function sys_ShowTextPageSelect($thispagenum,$dolink,$add,$filetype,$n_r){
if($thispagenum==1)
{
return '';
}
$titleselect='';
for($j=1;$j<=$thispagenum;$j++)
{
if($j==1)
{
$title=$add[title];
$plink=$add[filename].$filetype;
}
else
{
$k=$j-1;
$ti_r=explode('[/!--empirenews.page--]',$n_r[$k]);
if(count($ti_r)>=2&&$ti_r[0])
{
$title=$ti_r[0];
}
else
{
$title=$add[title].'('.$j.')';
}
$plink=$add[filename].'_'.$j.$filetype;
}
$titleselect.='<option value="'.$dolink.$plink.'?'.$j.'">'.$title.'</option>';
}
$titleselect='<select name="titleselect" onchange="self.location.href=this.options[this.selectedIndex].value">'.$titleselect.'</select>';
return $titleselect;
}
//返回sql语句
function sys_ReturnBqQuery($classid,$line,$enews=0,$do=0,$ewhere='',$eorder=''){
global $empire,$public_r,$class_r,$class_zr,$navclassid,$dbtbpre,$fun_r,$class_tr,$emod_r,$etable_r,$eyh_r;
if($enews==24)//按sql查询
{
$query_first=substr($classid,0,7);
if(!($query_first=='select '||$query_first=='SELECT '))
{
return "";
}
$classid=RepSqlTbpre($classid);
$sql=$empire->query1($classid);
if(!$sql)
{
echo"SQL Error: ".ReRepSqlTbpre($classid);
}
return $sql;
}
if($enews==0||$enews==1||$enews==2||$enews==9||$enews==12||$enews==15)//栏目
{
if(strstr($classid,','))//多栏目
{
$son_r=sys_ReturnMoreClass($classid,1);
$classid=$son_r[0];
$where=$son_r[1];
}
else
{
if($classid=='selfinfo')//显示当前栏目信息
{
$classid=$navclassid;
}
if($class_r[$classid][islast])
{
$where="classid='$classid'";
}
else
{
$where=ReturnClass($class_r[$classid][sonclass]);
}
}
$tbname=$class_r[$classid][tbname];
$mid=$class_r[$classid][modid];
$yhid=$class_r[$classid][yhid];
}
elseif($enews==6||$enews==7||$enews==8||$enews==11||$enews==14||$enews==17)//专题
{
echo"Error:Change to use e:indexloop";
return false;
}
elseif($enews==25||$enews==26||$enews==27||$enews==28||$enews==29||$enews==30)//标题分类
{
if(strstr($classid,','))//多标题分类
{
$son_r=sys_ReturnMoreTT($classid);
$classid=$son_r[0];
$where=$son_r[1];
}
else
{
if($classid=='selfinfo')//显示当前标题分类信息
{
$classid=$navclassid;
}
$where="ttid='$classid'";
}
$mid=$class_tr[$classid][mid];
$tbname=$emod_r[$mid][tbname];
$yhid=$class_tr[$classid][yhid];
}
$query='';
$qand=' and ';
if($enews==0)//栏目最新
{
$query=' where ('.$where.')';
$order='newstime';
$yhvar='bqnew';
}
elseif($enews==1)//栏目热门
{
$query=' where ('.$where.')';
$order='onclick';
$yhvar='bqhot';
}
elseif($enews==2)//栏目推荐
{
$query=' where ('.$where.') and isgood>0';
$order='newstime';
$yhvar='bqgood';
}
elseif($enews==9)//栏目评论排行
{
$query=' where ('.$where.')';
$order='plnum';
$yhvar='bqpl';
}
elseif($enews==12)//栏目头条
{
$query=' where ('.$where.') and firsttitle>0';
$order='newstime';
$yhvar='bqfirst';
}
elseif($enews==15)//栏目下载排行
{
$query=' where ('.$where.')';
$order='totaldown';
$yhvar='bqdown';
}
elseif($enews==3)//所有最新
{
$qand=' where ';
$order='newstime';
$tbname=$public_r[tbname];
$mid=$etable_r[$tbname][mid];
$yhvar='bqnew';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==4)//所有点击排行
{
$qand=' where ';
$order='onclick';
$tbname=$public_r[tbname];
$mid=$etable_r[$tbname][mid];
$yhvar='bqhot';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==5)//所有推荐
{
$query=' where isgood>0';
$order='newstime';
$tbname=$public_r[tbname];
$mid=$etable_r[$tbname][mid];
$yhvar='bqgood';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==10)//所有评论排行
{
$qand=' where ';
$order='plnum';
$tbname=$public_r[tbname];
$mid=$etable_r[$tbname][mid];
$yhvar='bqpl';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==13)//所有头条
{
$query=' where firsttitle>0';
$order='newstime';
$tbname=$public_r[tbname];
$mid=$etable_r[$tbname][mid];
$yhvar='bqfirst';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==16)//所有下载排行
{
$qand=' where ';
$order='totaldown';
$tbname=$public_r[tbname];
$mid=$etable_r[$tbname][mid];
$yhvar='bqdown';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==18)//各表最新
{
$qand=' where ';
$order='newstime';
$tbname=$classid;
$mid=$etable_r[$tbname][mid];
$yhvar='bqnew';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==19)//各表热门
{
$qand=' where ';
$order='onclick';
$tbname=$classid;
$mid=$etable_r[$tbname][mid];
$yhvar='bqhot';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==20)//各表推荐
{
$query=' where isgood>0';
$order='newstime';
$tbname=$classid;
$mid=$etable_r[$tbname][mid];
$yhvar='bqgood';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==21)//各表评论排行
{
$qand=' where ';
$order='plnum';
$tbname=$classid;
$mid=$etable_r[$tbname][mid];
$yhvar='bqpl';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==22)//各表头条信息
{
$query=' where firsttitle>0';
$order="newstime";
$tbname=$classid;
$mid=$etable_r[$tbname][mid];
$yhvar='bqfirst';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==23)//各表下载排行
{
$qand=' where ';
$order='totaldown';
$tbname=$classid;
$mid=$etable_r[$tbname][mid];
$yhvar='bqdown';
$yhid=$etable_r[$tbname][yhid];
}
elseif($enews==25)//标题分类最新
{
$query=' where ('.$where.')';
$order='newstime';
$yhvar='bqnew';
}
elseif($enews==26)//标题分类点击排行
{
$query=' where ('.$where.')';
$order='onclick';
$yhvar='bqhot';
}
elseif($enews==27)//标题分类推荐
{
$query=' where ('.$where.') and isgood>0';
$order='newstime';
$yhvar='bqgood';
}
elseif($enews==28)//标题分类评论排行
{
$query=' where ('.$where.')';
$order='plnum';
$yhvar='bqpl';
}
elseif($enews==29)//标题分类头条
{
$query=' where ('.$where.') and firsttitle>0';
$order='newstime';
$yhvar='bqfirst';
}
elseif($enews==30)//标题分类下载排行
{
$query=' where ('.$where.')';
$order='totaldown';
$yhvar='bqdown';
}
//优化
$yhadd='';
if(!empty($eyh_r[$yhid]['dobq']))
{
$yhadd=ReturnYhSql($yhid,$yhvar);
if(!empty($yhadd))
{
$query.=$qand.$yhadd;
$qand=' and ';
}
}
//不调用
if(!strstr($public_r['nottobq'],','.$classid.','))
{
$notbqwhere=ReturnNottoBqWhere();
if(!empty($notbqwhere))
{
$query.=$qand.$notbqwhere;
$qand=' and ';
}
}
//图片信息
if(!empty($do))
{
$query.=$qand.'ispic=1';
$qand=' and ';
}
//附加条件
if(!empty($ewhere))
{
$query.=$qand.'('.$ewhere.')';
$qand=' and ';
}
//中止
if(empty($tbname))
{
echo $fun_r['BqErrorCid']."=<b>".$classid."</b>".$fun_r['BqErrorNtb']."(".$fun_r['BqErrorDo']."=".$enews.")";
return false;
}
//排序
$addorder=empty($eorder)?$order.' desc':$eorder;
$query='select '.ReturnSqlListF($mid).' from '.$dbtbpre.'ecms_'.$tbname.$query.' order by '.ReturnSetTopSql('bq').$addorder.' limit '.$line;
$sql=$empire->query1($query);
if(!$sql)
{
echo"SQL Error: ".ReRepSqlTbpre($query);
}
return $sql;
}
声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。
评论(0)