/e/class/t_functions.php
PHP | 2980 lines | 2655 code | 60 blank | 265 comment | 308 complexity | e70dc3a11115355e300481125cbe3779 MD5 | raw file
- <?php
- if(!defined('InEmpireCMS'))
- {
- exit();
- }
- define('InEmpireCMSTfun',TRUE);
- require_once(ECMS_PATH."e/class/userfun.php");
-
- //列表模板分页函数
- function sys_ShowListPage($num,$pagenum,$dolink,$dotype,$page,$lencord,$ok,$search=""){
- global $fun_r;
- //首页
- if($pagenum<>1)
- {
- $pagetop="<a href='".$dolink."index".$dotype."'>".$fun_r['startpage']."</a> ";
- }
- else
- {
- $pagetop=$fun_r['startpage']." ";
- }
- //上一页
- if($pagenum<>1)
- {
- $pagepr=$pagenum-1;
- if($pagepr==1)
- {
- $prido="index".$dotype;
- }
- else
- {
- $prido="index_".$pagepr.$dotype;
- }
- $pagepri="<a href='".$dolink.$prido."'>".$fun_r['pripage']."</a> ";
- }
- else
- {
- $pagepri=$fun_r['pripage']." ";
- }
- //下一页
- if($pagenum<>$page)
- {
- $pagenex=$pagenum+1;
- $pagenext="<a href='".$dolink."index_".$pagenex.$dotype."'>".$fun_r['nextpage']."</a> ";
- }
- else
- {
- $pagenext=$fun_r['nextpage']." ";
- }
- //尾页
- if($pagenum==$page)
- {
- $pageeof=$fun_r['lastpage'];
- }
- else
- {
- $pageeof="<a href='".$dolink."index_".$page.$dotype."'>".$fun_r['lastpage']."</a>";
- }
- $options="";
- //取得下拉页码
- if(empty($search))
- {
- for($go=1;$go<=$page;$go++)
- {
- if($go==1)
- {$file="index".$dotype;}
- else
- {$file="index_".$go.$dotype;}
- if($ok==$go)
- {$select=" selected";}
- else
- {$select="";}
- $myoptions.="<option value='".$dolink.$file."'>".$fun_r['gotos'].$go.$fun_r['gotol']."</option>";
- $options.="<option value='".$dolink.$file."'".$select.">".$fun_r['gotos'].$go.$fun_r['gotol']."</option>";
- }
- }
- else
- {
- $myoptions=$search;
- $options=str_replace("value='".$dolink."index_".$ok.$dotype."'>","value='".$dolink."index_".$ok.$dotype."' selected>",$search);
- }
- $options="<select name=select onchange=\"self.location.href=this.options[this.selectedIndex].value\">".$options."</select>";
- //分页
- $pagelink=$pagetop.$pagepri.$pagenext.$pageeof;
- //替换模板变量
- $pager['showpage']=ReturnListpageStr($pagenum,$page,$lencord,$num,$pagelink,$options);
- $pager['option']=$myoptions;
- return $pager;
- }
-
- //列表模板之列表式分页
- function sys_ShowListMorePage($num,$page,$dolink,$type,$totalpage,$line,$ok,$search=""){
- global $fun_r,$public_r;
- if($num<=$line)
- {
- $pager['showpage']='';
- return $pager;
- }
- $page_line=$public_r['listpagelistnum'];
- $snum=2;
- //$totalpage=ceil($num/$line);//取得总页数
- $firststr='';
- //上一页
- if($page<>1)
- {
- $toppage='<a href="'.$dolink.'index'.$type.'">'.$fun_r['startpage'].'</a> ';
- $pagepr=$page-1;
- if($pagepr==1)
- {
- $prido="index".$type;
- }
- else
- {
- $prido="index_".$pagepr.$type;
- }
- $prepage='<a href="'.$dolink.$prido.'">'.$fun_r['pripage'].'</a>';
- }
- //下一页
- if($page!=$totalpage)
- {
- $pagenex=$page+1;
- $nextpage=' <a href="'.$dolink.'index_'.$pagenex.$type.'">'.$fun_r['nextpage'].'</a>';
- $lastpage=' <a href="'.$dolink.'index_'.$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.'index'.$type.'">';
- $is_2="</a>";
- }
- else
- {
- $is_1='<a href="'.$dolink.'index_'.$i.$type.'">';
- $is_2="</a>";
- }
- $returnstr.=' '.$is_1.$i.$is_2;
- }
- $returnstr=$firststr.$toppage.$prepage.$returnstr.$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,$do_openbqquery,$dbtbpre,$fun_r,$class_tr,$emod_r,$etable_r,$eyh_r;
- if($enews==24&&$do_openbqquery==1)//按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)//专题
- {
- if(strstr($classid,','))//多专题
- {
- $son_r=sys_ReturnMoreZt($classid);
- $classid=$son_r[0];
- $where=$son_r[1];
- }
- else
- {
- if($classid=='selfinfo')//显示当前专题信息
- {
- $classid=$navclassid;
- }
- $where="ztid like '%|".$classid."|%'";
- }
- $tbname=$class_zr[$classid][tbname];
- $mid=$etable_r[$tbname][mid];
- $yhid=$class_zr[$classid][yhid];
- }
- 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
- {
- $where="ttid='$classid'";
- }
- $mid=$class_tr[$classid][mid];
- $tbname=$emod_r[$mid][tbname];
- $yhid=$class_tr[$classid][yhid];
- }
- if($enews==0)//栏目最新
- {
- $query='('.$where.') and checked=1';
- $order='newstime';
- $yhvar='bqnew';
- }
- elseif($enews==1)//栏目热门
- {
- $query='('.$where.') and checked=1';
- $order='onclick';
- $yhvar='bqhot';
- }
- elseif($enews==2)//栏目推荐
- {
- $query='('.$where.') and isgood>0 and checked=1';
- $order='newstime';
- $yhvar='bqgood';
- }
- elseif($enews==9)//栏目评论排行
- {
- $query='('.$where.') and checked=1';
- $order='plnum';
- $yhvar='bqpl';
- }
- elseif($enews==12)//栏目头条
- {
- $query='('.$where.') and firsttitle>0 and checked=1';
- $order='newstime';
- $yhvar='bqfirst';
- }
- elseif($enews==15)//栏目下载排行
- {
- $query='('.$where.') and checked=1';
- $order='totaldown';
- $yhvar='bqdown';
- }
- elseif($enews==3)//所有最新
- {
- $query='checked=1';
- $order='newstime';
- $tbname=$public_r[tbname];
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqnew';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==4)//所有点击排行
- {
- $query='checked=1';
- $order='onclick';
- $tbname=$public_r[tbname];
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqhot';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==5)//所有推荐
- {
- $query='isgood>0 and checked=1';
- $order='newstime';
- $tbname=$public_r[tbname];
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqgood';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==10)//所有评论排行
- {
- $query='checked=1';
- $order='plnum';
- $tbname=$public_r[tbname];
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqpl';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==13)//所有头条
- {
- $query='firsttitle>0 and checked=1';
- $order='newstime';
- $tbname=$public_r[tbname];
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqfirst';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==16)//所有下载排行
- {
- $query='checked=1';
- $order='totaldown';
- $tbname=$public_r[tbname];
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqdown';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==6)//专题最新
- {
- $query='('.$where.') and checked=1';
- $order='newstime';
- $yhvar='bqnew';
- }
- elseif($enews==7)//专题点击排行
- {
- $query='('.$where.') and checked=1';
- $order='onclick';
- $yhvar='bqhot';
- }
- elseif($enews==8)//专题推荐
- {
- $query='('.$where.') and isgood>0 and checked=1';
- $order='newstime';
- $yhvar='bqgood';
- }
- elseif($enews==11)//专题评论排行
- {
- $query='('.$where.') and checked=1';
- $order='plnum';
- $yhvar='bqpl';
- }
- elseif($enews==14)//专题头条
- {
- $query='('.$where.') and firsttitle>0 and checked=1';
- $order='newstime';
- $yhvar='bqfirst';
- }
- elseif($enews==17)//专题下载排行
- {
- $query='('.$where.') and checked=1';
- $order='totaldown';
- $yhvar='bqdown';
- }
- elseif($enews==18)//各表最新
- {
- $query='checked=1';
- $order='newstime';
- $tbname=$classid;
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqnew';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==19)//各表热门
- {
- $query='checked=1';
- $order='onclick';
- $tbname=$classid;
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqhot';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==20)//各表推荐
- {
- $query='isgood>0 and checked=1';
- $order='newstime';
- $tbname=$classid;
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqgood';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==21)//各表评论排行
- {
- $query='checked=1';
- $order='plnum';
- $tbname=$classid;
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqpl';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==22)//各表头条信息
- {
- $query='firsttitle>0 and checked=1';
- $order="newstime";
- $tbname=$classid;
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqfirst';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==23)//各表下载排行
- {
- $query='checked=1';
- $order='totaldown';
- $tbname=$classid;
- $mid=$etable_r[$tbname][mid];
- $yhvar='bqdown';
- $yhid=$etable_r[$tbname][yhid];
- }
- elseif($enews==25)//标题分类最新
- {
- $query='('.$where.') and checked=1';
- $order='newstime';
- $yhvar='bqnew';
- }
- elseif($enews==26)//标题分类点击排行
- {
- $query='('.$where.') and checked=1';
- $order='onclick';
- $yhvar='bqhot';
- }
- elseif($enews==27)//标题分类推荐
- {
- $query='('.$where.') and isgood>0 and checked=1';
- $order='newstime';
- $yhvar='bqgood';
- }
- elseif($enews==28)//标题分类评论排行
- {
- $query='('.$where.') and checked=1';
- $order='plnum';
- $yhvar='bqpl';
- }
- elseif($enews==29)//标题分类头条
- {
- $query='('.$where.') and firsttitle>0 and checked=1';
- $order='newstime';
- $yhvar='bqfirst';
- }
- elseif($enews==30)//标题分类下载排行
- {
- $query='('.$where.') and checked=1';
- $order='totaldown';
- $yhvar='bqdown';
- }
- //不调用
- if(!strstr($public_r['nottobq'],','.$classid.','))
- {
- $query.=ReturnNottoBqWhere();
- }
- //附加条件
- if(!empty($ewhere))
- {
- $query.=' and ('.$ewhere.')';
- }
- //图片信息
- if(!empty($do))
- {
- $query.=' and ispic=1';
- }
- //中止
- 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;
- //优化
- $yhadd='';
- if(!empty($eyh_r[$yhid]['dobq']))
- {
- $yhadd=ReturnYhSql($yhid,$yhvar);
- }
- $query='select '.ReturnSqlListF($mid).' from '.$dbtbpre.'ecms_'.$tbname.' where '.$yhadd.$query.' order by '.ReturnSetTopSql('bq').$addorder.' limit '.$line;
- $sql=$empire->query1($query);
- if(!$sql)
- {
- echo"SQL Error: ".ReRepSqlTbpre($query);
- }
- return $sql;
- }
-
- //返回标签模板
- function sys_ReturnBqTemp($tempid){
- global $empire,$dbtbpre,$fun_r;
- $r=$empire->fetch1("select tempid,modid,temptext,showdate,listvar,subnews,rownum,docode from ".GetTemptb("enewsbqtemp")." where tempid='$tempid'");
- if(empty($r[tempid]))
- {
- echo $fun_r['BqErrorNbqtemp']."(ID=".$tempid.")";
- }
- return $r;
- }
-
- //替换栏目名
- function ReplaceEcmsinfoClassname($temp,$enews,$classid){
- global $class_r,$class_zr;
- if(strstr($classid,","))
- {
- return $temp;
- }
- $thecdo=',0,1,2,9,12,15,';
- $thezdo=',6,7,8,11,14,17,';
- //栏目
- if(strstr($thecdo,",".$enews.","))
- {
- $classname=$class_r[$classid][classname];
- $r[classid]=$classid;
- $classurl=sys_ReturnBqClassname($r,9);
- }
- //专题
- elseif(strstr($thezdo,",".$enews.","))
- {
- $r[ztid]=$classid;
- $classname=$class_zr[$classid][ztname];
- $classurl=sys_ReturnBqZtname($r);
- }
- else
- {}
- if($classname)
- {
- $temp=str_replace("[!--the.classname--]",$classname,$temp);
- $temp=str_replace("[!--the.classurl--]",$classurl,$temp);
- $temp=str_replace("[!--the.classid--]",$classid,$temp);
- }
- return $temp;
- }
-
- //带模板的标签
- function sys_GetEcmsInfo($classid,$line,$strlen,$have_class=0,$enews=0,$tempid,$doing=0,$ewhere='',$eorder=''){
- global $empire,$public_r;
- $sql=sys_ReturnBqQuery($classid,$line,$enews,$doing,$ewhere,$eorder);
- if(!$sql)
- {return "";}
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- $docode=$tr[docode];
- //替换变量
- $listtemp=ReplaceEcmsinfoClassname($listtemp,$enews,$classid);
- if(empty($rownum))
- {$rownum=1;}
- //字段
- $ret_r=ReturnReplaceListF($tr[modid]);
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- while($r=$empire->fetch($sql))
- {
- $r[oldtitle]=$r[title];
- //替换列表变量
- $repvar=ReplaceListVars($no,$listvar,$subnews,$strlen,$formatdate,$url,$have_class,$r,$ret_r,$docode);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //灵动标签:返回SQL内容函数
- function sys_ReturnEcmsLoopBq($classid=0,$line=10,$enews=3,$doing=0,$ewhere='',$eorder=''){
- return sys_ReturnBqQuery($classid,$line,$enews,$doing,$ewhere,$eorder);
- }
-
- //灵动标签:返回特殊内容函数
- function sys_ReturnEcmsLoopStext($r){
- global $class_r;
- $sr['titleurl']=sys_ReturnBqTitleLink($r);
- $sr['classname']=$class_r[$r[classid]][bname]?$class_r[$r[classid]][bname]:$class_r[$r[classid]][classname];
- $sr['classurl']=sys_ReturnBqClassname($r,9);
- return $sr;
- }
-
- //返回相关链接操作类型
- function sys_OtherLinkQuery($classid,$line,$enews,$doing){
- global $empire,$public_r,$class_r,$class_zr,$navinfor,$dbtbpre,$eyh_r,$etable_r;
- if($enews==1)//按表
- {
- $tbname=$classid;
- }
- elseif($enews==2)//按栏目
- {
- if($classid=='selfinfo')//当前栏目
- {
- $classid=$navinfor['classid'];
- }
- $tbname=$class_r[$classid]['tbname'];
- if($class_r[$classid][islast])
- {
- $and="classid='$classid'";
- }
- else
- {
- $and=ReturnClass($class_r[$classid][sonclass]);
- }
- }
- elseif($enews==3)//按专题
- {
- $tbname=$class_zr[$classid]['tbname'];
- $and="ztid like '%|".$classid."|%'";
- }
- else//默认
- {
- $tbname=$class_r[$navinfor[classid]]['tbname'];
- }
- //关键字
- $keys='';
- if(!empty($enews))
- {
- $repadd='';
- $keyr=explode(',',$navinfor['keyboard']);
- $count=count($keyr);
- for($i=0;$i<$count;$i++)
- {
- if($i==0)
- {
- $or='';
- }
- else
- {
- $or=' or ';
- }
- $repadd.=$or."[!--f--!] like '%".$keyr[$i]."%'";
- }
- //搜索范围
- if($public_r['newslink']==1)
- {
- $keys='('.str_replace('[!--f--!]','keyboard',$repadd).')';
- }
- elseif($public_r['newslink']==2)
- {
- $keys='('.str_replace('[!--f--!]','keyboard',$repadd).' or '.str_replace('[!--f--!]','title',$repadd).')';
- }
- else
- {
- $keys='('.str_replace('[!--f--!]','title',$repadd).')';
- }
- }
- else
- {
- $keys='id in ('.$navinfor['keyid'].')';
- }
- //当前信息
- if($tbname==$class_r[$navinfor[classid]][tbname])
- {
- $and.=empty($and)?"id<>'$navinfor[id]'":" and id<>'$navinfor[id]'";
- }
- //图片信息
- if($doing)
- {
- $and.=empty($and)?"ispic=1":" and ispic=1";
- }
- if($and)
- {
- $and.=' and ';
- }
- if(empty($line))
- {
- $line=$class_r[$navinfor[classid]]['link_num'];
- }
- //优化
- $yhvar='otherlink';
- $yhid=$etable_r[$tbname][yhid];
- $yhadd='';
- if($yhid)
- {
- $yhadd=ReturnYhSql($yhid,$yhvar);
- }
- $query="select * from {$dbtbpre}ecms_".$tbname." where ".$yhadd.$and.$keys." and checked=1 order by newstime desc limit $line";
- $sql=$empire->query1($query);
- if(!$sql)
- {
- echo"SQL Error: ".ReRepSqlTbpre($query);
- }
- return $sql;
- }
-
- //相关链接标签
- function sys_GetOtherLinkInfo($tempid,$classid='',$line=0,$strlen=60,$have_class=0,$enews=0,$doing=0){
- global $empire,$navinfor,$public_r;
- if(empty($navinfor['keyboard'])||(empty($enews)&&!$navinfor['keyid']))
- {
- return '';
- }
- $sql=sys_OtherLinkQuery($classid,$line,$enews,$doing);
- if(!$sql)
- {return "";}
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- $docode=$tr[docode];
- //替换变量
- $listtemp=ReplaceEcmsinfoClassname($listtemp,$enews,$classid);
- if(empty($rownum))
- {$rownum=1;}
- //字段
- $ret_r=ReturnReplaceListF($tr[modid]);
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- while($r=$empire->fetch($sql))
- {
- $r[oldtitle]=$r[title];
- //替换列表变量
- $repvar=ReplaceListVars($no,$listvar,$subnews,$strlen,$formatdate,$url,$have_class,$r,$ret_r,$docode);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //文字标签函数
- function sys_GetClassNews($classid,$line,$strlen,$showdate=true,$enews=0,$have_class=0,$formatdate='(m-d)',$ewhere='',$eorder=''){
- global $empire;
- $sql=sys_ReturnBqQuery($classid,$line,$enews,0,$ewhere,$eorder);
- if(!$sql)
- {return "";}
- $record=0;
- while($r=$empire->fetch($sql))
- {
- $record=1;
- $oldtitle=$r[title];
- $title=sub($r[title],0,$strlen,false);
- //标题属性
- $title=DoTitleFont($r[titlefont],$title);
- //显示栏目
- $myadd=sys_ReturnBqClassname($r,$have_class);
- //显示时间
- if($showdate)
- {
- $newstime=date($formatdate,$r[newstime]);
- $newstime=" ".$newstime;
- }
- //标题链接
- $titleurl=sys_ReturnBqTitleLink($r);
- $title="·".$myadd."<a href='".$titleurl."' target=_blank title='".$oldtitle."'>".$title."</a>".$newstime;
- $allnews.="<tr><td height=20>".$title."</td></tr>";
- }
- if($record)
- {
- echo"<table border=0 cellpadding=0 cellspacing=0>$allnews</table>";
- }
- }
-
- //图文信息调用
- function sys_GetClassNewsPic($classid,$line,$num,$width,$height,$showtitle=true,$strlen,$enews=0,$ewhere='',$eorder=''){
- global $empire;
- $sql=sys_ReturnBqQuery($classid,$num,$enews,1,$ewhere,$eorder);
- if(!$sql)
- {return "";}
- //输出
- $i=0;
- while($r=$empire->fetch($sql))
- {
- $i++;
- if(($i-1)%$line==0||$i==1)
- {$class_text.="<tr>";}
- //标题链接
- $titleurl=sys_ReturnBqTitleLink($r);
- //------是否显示标题
- if($showtitle)
- {
- $oldtitle=$r[title];
- $title=sub($r[title],0,$strlen,false);
- //标题属性
- $title=DoTitleFont($r[titlefont],$title);
- $title="<br><span style='line-height:15pt'>".$title."</span>";
- }
- $class_text.="<td align=center><a href='".$titleurl."' target=_blank><img src='".$r[titlepic]."' width='".$width."' height='".$height."' border=0 alt='".$oldtitle."'>".$title."</a></td>";
- //分割
- if($i%$line==0)
- {$class_text.="</tr>";}
- }
- if($i<>0)
- {
- $table="<table width=100% border=0 cellpadding=3 cellspacing=0>";$table1="</table>";
- $ys=$line-$i%$line;
- $p=0;
- for($j=0;$j<$ys&&$ys!=$line;$j++)
- {
- $p=1;
- $class_text.="<td></td>";
- }
- if($p==1)
- {
- $class_text.="</tr>";
- }
- }
- $text=$table.$class_text.$table1;
- echo"$text";
- }
-
- //简介型调用
- function sys_GetClassNewsText($classid,$line,$tablecolor,$enews=0,$have_class=0,$ewhere='',$eorder=''){
- global $empire;
- $sql=sys_ReturnBqQuery($classid,$line,$enews,0,$ewhere,$eorder);
- if(!$sql)
- {return "";}
- while($r=$empire->fetch($sql))
- {
- //标题属性
- $title=DoTitleFont($r[titlefont],$r[title]);
- //标题链接
- $titleurl=sys_ReturnBqTitleLink($r);
- //显示类别
- $myadd=sys_ReturnBqClassname($r,$have_class);
- $smalltext=nl2br($r[smalltext]);
- $allnews.="<table width=99% border=0 align=center cellpadding=3 cellspacing=0>
- <tr bgcolor=".$tablecolor."><td width=62% height=25><strong>.</strong> ".$myadd."<a href='".$titleurl."' target=_blank>".$title."</a></td><td width=38%>发布时间:".date("Y-m-d H:i:s",$r[newstime])."</td></tr><tr valign=top><td height=25 colspan=2>".$smalltext."</td></tr></table>";
- }
- echo"$allnews";
- }
-
- //滚动图片信息
- function sys_GetAutoPic($classid,$line,$width,$height,$showtitle=true,$strlen,$speed=5000,$enews=0,$ewhere='',$eorder=''){
- global $empire;
- $sql=sys_ReturnBqQuery($classid,$line,$enews,1,$ewhere,$eorder);
- if(!$sql)
- {return "";}
- $jsarray="";
- $i=0;
- while($r=$empire->fetch($sql))
- {
- $i++;
- //标题链接
- $titleurl=sys_ReturnBqTitleLink($r);
- //------是否显示标题
- if($showtitle)
- {
- $title=sub($r[title],0,$strlen,false);
- //标题属性
- $title=addslashes(DoTitleFont($r[titlefont],htmlspecialchars($title)));
- }
- $jsarray.="imgUrl[".$i."]=\"".$r[titlepic]."\";
- imgLink[".$i."]=\"".$titleurl."\";
- imgTz[".$i."]=\"<a href='".$titleurl."' target=_blank>".$title."</a>\";";
- }
- $pic="<a onclick=\"javascript:goUrl();\" style=\"CURSOR: hand\"><img style=\"FILTER: revealTrans(duration=2,transition=20);border-color:black;color:#000000\" src=\"javascript:\" width='".$width."' height='".$height."' border=1 name=imgInit id=imgInit></a>";
- ?>
- <script language=JavaScript>
- var imgUrl=new Array();
- var imgLink=new Array();
- var imgTz=new Array();
- var adNum=0;
- <?=$jsarray?>
- var imgPre=new Array();
- var j=0;
- for (i=1;i<=<?=$line?>;i++) {
- if( (imgUrl[i]!="") && (imgLink[i]!="") ) {
- j++;
- } else {
- break;
- }
- }
- function playTran(){
- if (document.all)
- imgInit.filters.revealTrans.play();
- }
- var key=0;
- function nextAd(){
- if(adNum<j)adNum++ ;
- else adNum=1;
-
- if( key==0 ){
- key=1;
- } else if (document.all){
- imgInit.filters.revealTrans.Transition=6;
- imgInit.filters.revealTrans.apply();
- playTran();
- }
- document.images.imgInit.src=imgUrl[adNum];
- <?
- if($showtitle)
- {
- ?>
- document.getElementById('jdtz').innerHTML=imgTz[adNum];
- <?
- }
- ?>
- theTimer=setTimeout("nextAd()", <?=$speed?>);
- }
- function goUrl(){
- jumpUrl=imgLink[adNum];
- jumpTarget='_blank';
- if (jumpUrl != ''){
- if (jumpTarget != '')
- window.open(jumpUrl,jumpTarget);
- else
- location.href=jumpUrl;
- }
- }
- </script>
- <?
- //显示标题
- if($showtitle)
- {
- ?>
- <table border=0 cellpadding=0 cellspacing=0>
- <tr><td align=center><?=$pic?></td></tr>
- <tr><td height=1></td></tr>
- <tr><td align=center style="background:#B1B1B1 right no-repeat" height=23 id=jdtz></td></tr>
- </table>
- <?
- }
- else
- {
- echo $pic;
- }
- echo"<script>nextAd();</script>";
- }
-
- //图片信息调用
- function sys_GetPicNews($picid,$showtitle=false,$showtext=false){
- global $empire,$dbtbpre;
- $r=$empire->fetch1("select picid,title,pic_url,url,pic_width,pic_height,open_pic,border,pictext from {$dbtbpre}enewspic where picid='$picid' limit 1");
- $pic="";
- if($r[pic_width])
- {$pic.=" width='".$r[pic_width]."'";}
- if($r[pic_height])
- {$pic.=" height='".$r[pic_height]."'";}
- $pic="<a href='".$r[url]."' title='".$r[title]."' target='".$r[open_pic]."'><img src='".$r[pic_url]."'".$pic." border=".$r[border]."></a>";
- //显示标题
- if($showtitle)
- {$pic.="<br><span style='line-height:15pt'><a href='".$r[url]."' target='".$r[open_pic]."'>".$r[title]."</a></span>";}
- //显示简介
- if($showtext)
- {$pic="<table width=100% border=0 align=center cellpadding=3 cellspacing=1><tr><td width=32%><div align=center>".$pic."</div></td><td width=68%><div><a href='".$r[url]."' title='".$r[title]."' target='".$r[open_pic]."'>".nl2br($r[pictext])."</a></div></td></tr></table>";}
- echo"$pic";
- }
-
- //多图片信息
- function sys_GetMorePicNews($classid,$line,$num,$width,$height,$showtitle=true,$strlen,$enews=0){
- global $empire,$public_r,$dbtbpre;
- $sql=$empire->query("select * from {$dbtbpre}enewspic where classid='$classid' order by picid desc limit $num");
- //输出
- $i=0;
- while($r=$empire->fetch($sql))
- {
- $i++;
- if(($i-1)%$line==0||$i==1)
- {$class_text.="<tr>";}
- //是否显示原链接
- if($enews==0)
- {$titleurl=$r[url];}
- else
- {$titleurl=$public_r[newsurl]."e/NewsSys/ShowImg?picid=".$r[picid];}
- //------是否显示标题
- if($showtitle)
- {
- $title=sub($r[title],0,$strlen,false);
- $title="<br><span style='line-height:15pt'>".$title."</span>";
- }
- $class_text.="<td align=center><a href='".$titleurl."' target=_blank><img src='".$r[pic_url]."' width='".$width."' height='".$height."' border=0>".$title."</a></td>";
- //分割
- if($i%$line==0)
- {$class_text.="</tr>";}
- }
- if($i<>0)
- {
- $table="<table width=100% border=0 cellpadding=3 cellspacing=0>";$table1="</table>";
- $ys=$line-$i%$line;
- $p=0;
- for($j=0;$j<$ys&&$ys!=$line;$j++)
- {
- $p=1;
- $class_text.="<td></td>";
- }
- if($p==1)
- {
- $class_text.="</tr>";
- }
- }
- $text=$table.$class_text.$table1;
- echo"$text";
- }
-
- //广告标签
- function sys_GetAd($adid){
- global $empire,$public_r,$dbtbpre;
- $r=$empire->fetch1("select * from {$dbtbpre}enewsad where adid='$adid'");
- //到期
- if(time()>to_time($r['endtime']))
- {
- echo addslashes($r[reptext]);
- return '';
- }
- if($r['ylink'])
- {
- $ad_url=$r['url'];
- }
- else
- {
- $ad_url=$public_r[newsurl]."e/public/ClickAd?adid=".$adid;//广告链接
- }
- //----------------------文字广告
- if($r[t]==1)
- {
- $r[titlefont]=$r[titlecolor].','.$r[titlefont];
- $picurl=DoTitleFont($r[titlefont],$r[picurl]);//文字属性
- $h="<a href='".$ad_url."' target=".$r[target]." title='".$r[alt]."'>".addslashes($picurl)."</a>";
- //普通显示
- if($r[adtype]==1)
- {
- $html=$h;
- }
- //可移动透明对话框
- else
- {
- $html="<script language=javascript src=".$public_r[newsurl]."d/js/acmsd/ecms_dialog.js></script>
- <div style='position:absolute;left:300px;top:150px;width:".$r[pic_width]."; height:".$r[pic_height].";z-index:1;solid;filter:alpha(opacity=90)' id=DGbanner5 onmousedown='down1(this)' onmousemove='move()' onmouseup='down=false'><table cellpadding=0 border=0 cellspacing=1 width=".$r[pic_width]." height=".$r[pic_height]." bgcolor=#000000><tr><td height=18 bgcolor=#5A8ACE align=right style='cursor:move;'><a href=# style='font-size: 9pt; color: #eeeeee; text-decoration: none' onClick=clase('DGbanner5') >关闭>>><img border='0' src='".$public_r[newsurl]."d/js/acmsd/close_o.gif'></a> </td></tr><tr><td bgcolor=f4f4f4 > ".$h."</td></tr></table></div>";
- }
- }
- //------------------html广告
- elseif($r[t]==2)
- {
- $h=addslashes($r[htmlcode]);
- //普通显示
- if($r[adtype]==1)
- {
- $html=$h;
- }
- //可移动透明对话框
- else
- {
- $html="<script language=javascript src=".$public_r[newsurl]."d/js/acmsd/ecms_dialog.js></script>
- <div style='position:absolute;left:300px;top:150px;width:".$r[pic_width]."; height:".$r[pic_height].";z-index:1;solid;filter:alpha(opacity=90)' id=DGbanner5 onmousedown='down1(this)' onmousemove='move()' onmouseup='down=false'><table cellpadding=0 border=0 cellspacing=1 width=".$r[pic_width]." height=".$r[pic_height]." bgcolor=#000000><tr><td height=18 bgcolor=#5A8ACE align=right style='cursor:move;'><a href=# style='font-size: 9pt; color: #eeeeee; text-decoration: none' onClick=clase('DGbanner5') >关闭>>><img border='0' src='".$public_r[newsurl]."d/js/acmsd/close_o.gif'></a> </td></tr><tr><td bgcolor=f4f4f4 > ".$h."</td></tr></table></div>";
- }
- }
- //------------------弹出广告
- elseif($r[t]==3)
- {
- //打开新窗口
- if($r[adtype]==8)
- {
- $html="<script>window.open('".$r[url]."');</script>";
- }
- //弹出窗口
- elseif($r[adtype]==9)
- {
- $html="<script>window.open('".$r[url]."','','width=".$r[pic_width].",height=".$r[pic_height].",scrollbars=yes');</script>";
- }
- //普能网页窗口
- else
- {
- $html="<script>window.showModalDialog('".$r[url]."','','dialogWidth:".$r[pic_width]."px;dialogHeight:".$r[pic_height]."px;scroll:no;status:no;help:no');</script>";
- }
- }
- //---------------------图片与flash广告
- else
- {
- $filetype=GetFiletype($r[picurl]);
- //flash
- if($filetype==".swf")
- {
- $h="<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0' name='movie' width='".$r[pic_width]."' height='".$r[pic_height]."' id='movie'><param name='movie' value='".$r[picurl]."'><param name='quality' value='high'><param name='menu' value='false'><embed src='".$r[picurl]."' width='".$r[pic_width]."' height='".$r[pic_height]."' quality='high' pluginspage='http://www.macromedia.com/go/getflashplayer' type='application/x-shockwave-flash' id='movie' name='movie' menu='false'></embed><PARAM NAME='wmode' VALUE='Opaque'></object>";
- }
- else
- {
- $h="<a href='".$ad_url."' target=".$r[target]."><img src='".$r[picurl]."' border=0 width='".$r[pic_width]."' height='".$r[pic_height]."' alt='".$r[alt]."'></a>";
- }
- //普通显示
- if($r[adtype]==1)
- {
- $html=$h;
- }
- //满屏浮动显示
- elseif($r[adtype]==4)
- {
- $html="<script>ns4=(document.layers)?true:false;
- ie4=(document.all)?true:false;
- if(ns4){document.write(\"<layer id=DGbanner2 width=".$r[pic_width]." height=".$r[pic_height]." onmouseover=stopme('DGbanner2') onmouseout=movechip('DGbanner2')>".$h."</layer>\");}
- else{document.write(\"<div id=DGbanner2 style='position:absolute; width:".$r[pic_width]."px; height:".$r[pic_height]."px; z-index:9; filter: Alpha(Opacity=90)' onmouseover=stopme('DGbanner2') onmouseout=movechip('DGbanner2')>".$h."</div>\");}</script>
- <script language=javascript src=".$public_r[newsurl]."d/js/acmsd/ecms_float_fullscreen.js></script>";
- }
- //上下浮动显示 - 右
- elseif($r[adtype]==5)
- {
- $html="<script>if (navigator.appName == 'Netscape')
- {document.write(\"<layer id=DGbanner3 top=150 width=".$r[pic_width]." height=".$r[pic_height].">".$h."</layer>\");}
- else{document.write(\"<div id=DGbanner3 style='position: absolute;width:".$r[pic_height].";top:150;visibility: visible;z-index: 1'>".$h."</div>\");}</script>
- <script language=javascript src=".$public_r[newsurl]."d/js/acmsd/ecms_float_upanddown.js></script>";
- }
- //上下浮动显示 - 左
- elseif($r[adtype]==6)
- {
- $html="<script>if(navigator.appName == 'Netscape')
- {document.write(\"<layer id=DGbanner10 top=150 width=".$r[pic_width]." height=".$r[pic_height].">".$h."</layer>\");}
- else{document.write(\"<div id=DGbanner10 style='position: absolute;width:".$r[pic_width].";top:150;visibility: visible;z-index: 1'>".$h."</div>\");}</script>
- <script language=javascript src=".$public_r[newsurl]."d/js/acmsd/ecms_float_upanddown_L.js></script>";
- }
- //全屏幕渐隐消失
- elseif($r[adtype]==7)
- {
- $html="<script>ns4=(document.layers)?true:false;
- if(ns4){document.write(\"<layer id=DGbanner4Cont onLoad='moveToAbsolute(layer1.pageX-160,layer1.pageY);clip.height=".$r[pic_height].";clip.width=".$r[pic_width]."; visibility=show;'><layer id=DGbanner4News position:absolute; top:0; left:0>".$h."</layer></layer>\");}
- else{document.write(\"<div id=DGbanner4 style='position:absolute;top:0; left:0;'><div id=DGbanner4Cont style='position:absolute;width:".$r[pic_width].";height:".$r[pic_height].";clip:rect(0,".$r[pic_width].",".$r[pic_height].",0)'><div id=DGbanner4News style='position:absolute;top:0;left:0;right:820'>".$h."</div></div></div>\");}</script>
- <script language=javascript src=".$public_r[newsurl]."d/js/acmsd/ecms_fullscreen.js></script>";
- }
- //可移动透明对话框
- elseif($r[adtype]==3)
- {
- $html="<script language=javascript src=".$public_r[newsurl]."d/js/acmsd/ecms_dialog.js></script>
- <div style='position:absolute;left:300px;top:150px;width:".$r[pic_width]."; height:".$r[pic_height].";z-index:1;solid;filter:alpha(opacity=90)' id=DGbanner5 onmousedown='down1(this)' onmousemove='move()' onmouseup='down=false'><table cellpadding=0 border=0 cellspacing=1 width=".$r[pic_width]." height=".$r[pic_height]." bgcolor=#000000><tr><td height=18 bgcolor=#5A8ACE align=right style='cursor:move;'><a href=# style='font-size: 9pt; color: #eeeeee; text-decoration: none' onClick=clase('DGbanner5') >关闭>>><img border='0' src='".$public_r[newsurl]."d/js/acmsd/close_o.gif'></a> </td></tr><tr><td bgcolor=f4f4f4 > ".$h."</td></tr></table></div>";
- }
- else
- {
- $html="<script>function closeAd(){huashuolayer2.style.visibility='hidden';huashuolayer3.style.visibility='hidden';}function winload(){huashuolayer2.style.top=109;huashuolayer2.style.left=5;huashuolayer3.style.top=109;huashuolayer3.style.right=5;}//if(document.body.offsetWidth>800){
- {document.write(\"<div id=huashuolayer2 style='position: absolute;visibility:visible;z-index:1'><table width=0 border=0 cellspacing=0 cellpadding=0><tr><td height=10 align=right bgcolor=666666><a href=javascript:closeAd()><img src=".$public_r[newsurl]."d/js/acmsd/close.gif width=12 height=10 border=0></a></td></tr><tr><td>".$h."</td></tr></table></div>\"+\"<div id=huashuolayer3 style='position: absolute;visibility:visible;z-index:1'><table width=0 border=0 cellspacing=0 cellpadding=0><tr><td height=10 align=right bgcolor=666666><a href=javascript:closeAd()><img src=".$public_r[newsurl]."d/js/acmsd/close.gif width=12 height=10 border=0></a></td></tr><tr><td>".$h."</td></tr></table></div>\");}winload()//}</script>";
- }
- }
- echo $html;
- }
-
- //投票标签
- function sys_GetVote($voteid){
- global $empire,$public_r,$dbtbpre;
- $r=$empire->fetch1("select * from {$dbtbpre}enewsvote where voteid='$voteid'");
- if(empty($r[votetext]))
- {
- return '';
- }
- //模板
- $votetemp=ReturnVoteTemp($r[tempid],0);
- $votetemp=RepVoteTempAllvar($votetemp,$r);
- $listexp="[!--empirenews.listtemp--]";
- $listtemp_r=explode($listexp,$votetemp);
- $r_exp="\r\n";
- $f_exp="::::::";
- //项目数
- $r_r=explode($r_exp,$r[votetext]);
- $checked=0;
- for($i=0;$i<count($r_r);$i++)
- {
- $checked++;
- $f_r=explode($f_exp,$r_r[$i]);
- //投票类型
- if($r[voteclass])
- {$vote="<input type=checkbox name=vote[] value=".$checked.">";}
- else
- {$vote="<input type=radio name=vote value=".$checked.">";}
- $votetext.=RepVoteTempListvar($listtemp_r[1],$vote,$f_r[0]);
- }
- $votetext=$listtemp_r[0].$votetext.$listtemp_r[2];
- echo"$votetext";
- }
-
- //信息投票标签
- function sys_GetInfoVote($classid,$id){
- global $empire,$public_r,$dbtbpre;
- $r=$empire->fetch1("select * from {$dbtbpre}enewsinfovote where id='$id' and classid='$classid' limit 1");
- if(empty($r[votetext]))
- {
- return '';
- }
- //模板
- $votetemp=ReturnVoteTemp($r[tempid],0);
- $votetemp=RepVoteTempAllvar($votetemp,$r);
- $listexp="[!--empirenews.listtemp--]";
- $listtemp_r=explode($listexp,$votetemp);
- $r_exp="\r\n";
- $f_exp="::::::";
- //项目数
- $r_r=explode($r_exp,$r[votetext]);
- $checked=0;
- for($i=0;$i<count($r_r);$i++)
- {
- $checked++;
- $f_r=explode($f_exp,$r_r[$i]);
- //投票类型
- if($r[voteclass])
- {$vote="<input type=checkbox name=vote[] value=".$checked.">";}
- else
- {$vote="<input type=radio name=vote value=".$checked.">";}
- $votetext.=RepVoteTempListvar($listtemp_r[1],$vote,$f_r[0]);
- }
- $votetext=$listtemp_r[0].$votetext.$listtemp_r[2];
- return $votetext;
- }
-
- //友情链接
- function sys_GetSitelink($line,$num,$enews=0,$classid=0,$stats=0){
- global $empire,$public_r,$dbtbpre;
- //图片
- if($enews==1)
- {$a=" and lpic<>''";}
- //文字
- elseif($enews==2)
- {$a=" and lpic=''";}
- else
- {$a="";}
- //调用相应的栏目分类
- if(!empty($classid))
- {
- $whereclass=" and classid='$classid'";
- }
- $sql=$empire->query("select * from {$dbtbpre}enewslink where checked=1".$a.$whereclass." order by myorder,lid limit ".$num);
- //输出
- $i=0;
- while($r=$empire->fetch($sql))
- {
- //链接
- if(empty($stats))
- {
- $linkurl=$public_r[newsurl]."e/public/GotoSite?lid=".$r[lid]."&url=".urlencode($r[lurl]);
- }
- else
- {
- $linkurl=$r[lurl];
- }
- $i++;
- if(($i-1)%$line==0||$i==1)
- {$class_text.="<tr>";}
- //文字
- if(empty($r[lpic]))
- {
- $logo="<a href='".$linkurl."' title='".$r[lname]."' target=".$r[target].">".$r[lname]."</a>";
- }
- //图片
- else
- {
- $logo="<a href='".$linkurl."' target=".$r[target]."><img src='".$r[lpic]."' alt='".$r[lname]."' border=0 width='".$r[width]."' height='".$r[height]."'></a>";
- }
- $class_text.="<td align=center>".$logo."</td>";
- //分割
- if($i%$line==0)
- {$class_text.="</tr>";}
- }
- if($i<>0)
- {
- $table="<table width=100% border=0 cellpadding=3 cellspacing=0>";$table1="</table>";
- $ys=$line-$i%$line;
- $p=0;
- for($j=0;$j<$ys&&$ys!=$line;$j++)
- {
- $p=1;
- $class_text.="<td></td>";
- }
- if($p==1)
- {
- $class_text.="</tr>";
- }
- }
- $text=$table.$class_text.$table1;
- echo"$text";
- }
-
- //显示栏目导航
- function sys_ShowClass($show=0){
- global $navclassid,$empire,$class_r,$public_r,$dbtbpre;
- if(empty($navclassid))
- {$classid=0;}
- else
- {
- $classid=$navclassid;
- //终极栏目则显示同级栏目
- if($class_r[$classid][islast]&&$class_r[$classid][bclassid])
- {
- $classid=$class_r[$classid][bclassid];
- }
- if($class_r[$classid][islast]&&empty($class_r[$classid][bclassid]))
- {$classid=0;}
- }
- $sql=$empire->query("select classid,classname,islast,sonclass,tbname from {$dbtbpre}enewsclass where bclassid='$classid' and showclass=0 order by myorder,classid");
- $s="";
- while($r=$empire->fetch($sql))
- {
- //栏目链接
- $classurl=sys_ReturnBqClassname($r,9);
- //显示类别数据数
- if($show)
- {
- //终极栏目
- if($r[islast])
- {
- $where="classid='$r[classid]'";
- }
- else
- {
- $where=ReturnClass($r[sonclass]);
- }
- $cr=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_".$r[tbname]." where ".$where." and checked=1");
- $num=$cr[total];
- $newsdata=" (<font color=red>".$num."</font>)";
- }
- $s.="<tr><td> <img src='".$public_r[newsurl]."e/data/images/class.gif' border=0> <a href=".$classurl.">".$r[classname]."</a>".$newsdata."</td></tr>";
- }
- $s="<table>".$s."</table>";
- echo $s;
- }
-
- //显示网站地图
- function sys_ShowMap($classid,$line,$bcolor,$color,$shownum=0){
- global $empire,$class_r,$dbtbpre;
- $sql=$empire->query("select classid,classname,sonclass,islast,tbname from {$dbtbpre}enewsclass where bclassid='$classid' and showclass=0 order by myorder,classid");
- while($r=$empire->fetch($sql))
- {
- //显示栏目数据数
- if($shownum)
- {
- //终极栏目
- if($r[islast])
- {
- $where="classid='$r[classid]'";
- }
- else
- {
- $where=ReturnClass($r[sonclass]);
- }
- $cr=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_".$r[tbname]." where ".$where." and checked=1 limit 1");
- $num=$cr[total];
- $newsdata=" <font color=cccccc>(".$num.")</font>";
- }
- //栏目链接
- $classurl=sys_ReturnBqClassname($r,9);
- $text.="<table width=100% border=0 cellpadding=5 cellspacing=1 bgcolor=".$bcolor."><tr><td> <a href=\"".$classurl."\" target=\"_blank\">".$r[classname]."</a>".$newsdata."</td></tr><tr><td bgcolor=".$color.">";
- $sql1=$empire->query("select classname,classid,islast,sonclass,tbname from {$dbtbpre}enewsclass where bclassid='$r[classid]' and showclass=0 order by myorder,classid");
- $i=0;
- $class_text="";
- while($r1=$empire->fetch($sql1))
- {
- //显示类别数据数
- if($shownum)
- {
- //终极类别
- if($r1[islast])
- {
- $where="classid='$r1[classid]'";
- }
- else
- {
- $where=ReturnClass($r1[sonclass]);
- }
- $cr=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_".$r1[tbname]." where ".$where." and checked=1 limit 1");
- $num=$cr[total];
- $newsdata=" <font color=cccccc>(".$num.")</font>";
- }
- //栏目链接
- $classurl=sys_ReturnBqClassname($r1,9);
- $i++;
- if(($i-1)%$line==0||$i==1)
- {$class_text.="<tr>";}
- $class_text.="<td align=center><a href=\"".$classurl."\" target=\"_blank\">".$r1[classname]."</a>".$newsdata."</td>";
- //分割
- if($i%$line==0)
- {$class_text.="</tr>";}
- }
- if($i<>0)
- {
- $table="<table width=100% border=0 cellpadding=5 cellspacing=1>";
- $table1="</table>";
- $ys=$line-$i%$line;
- $p=0;
- for($j=0;$j<$ys&&$ys!=$line;$j++)
- {
- $p=1;
- $class_text.="<td></td>";
- }
- if($p==1)
- {
- $class_text.="</tr>";
- }
- }
- $text.=$table.$class_text.$table1."</td></tr></table>";
- }
- echo $text;
- }
-
- //引用文件
- function sys_IncludeFile($file){
- @include($file);
- }
-
- //读取远程文件
- function sys_ReadFile($http){
- global $do_openreadfile;
- if($do_openreadfile==0&&!strstr($http,"://"))
- {
- return "";
- }
- echo ReadFiletext($http);
- }
-
- //信息统计
- function sys_TotalData($classid,$enews=0,$day=0){
- global $empire,$class_r,$class_zr,$dbtbpre,$fun_r;
- if(empty($classid))
- {
- return "";
- }
- if($day)
- {
- if($day==1)//今日信息
- {
- $date=date("Y-m-d");
- $starttime=$date." 00:00:01";
- $endtime=$date." 23:59:59";
- }
- elseif($day==2)//本月信息
- {
- $date=date("Y-m");
- $starttime=$date."-01 00:00:01";
- $endtime=$date."-".date("t")." 23:59:59";
- }
- elseif($day==3)//本年信息
- {
- $date=date("Y");
- $starttime=$date."-01-01 00:00:01";
- $endtime=($date+1)."-01-01 00:00:01";
- }
- $and=" and newstime>=".to_time($starttime)." and newstime<=".to_time($endtime);
- }
- //统计专题
- if($enews==1)
- {
- if(empty($class_zr[$classid][tbname]))
- {
- echo $fun_r['BqErrorZid']."=<b>".$classid."</b>".$fun_r['BqErrorNtb'];
- return "";
- }
- $query="select count(*) as total from {$dbtbpre}ecms_".$class_zr[$classid][tbname]." where ztid like '%|".$classid."|%' and checked=1".$and;
- }
- //统计数据表
- elseif($enews==2)
- {
- $query="select count(*) as total from {$dbtbpre}ecms_".$classid." where checked=1".$and;
- }
- //统计栏目数据
- else
- {
- if(empty($class_r[$classid][tbname]))
- {
- echo $fun_r['BqErrorCid']."=<b>".$classid."</b>".$fun_r['BqErrorNtb'];
- return "";
- }
- if($class_r[$classid][islast])//终极栏目
- {
- $where="classid='$classid'";
- }
- else//大栏目
- {
- $where=ReturnClass($class_r[$classid][sonclass]);
- }
- $query="select count(*) as total from {$dbtbpre}ecms_".$class_r[$classid][tbname]." where ".$where." and checked=1".$and;
- }
- $num=$empire->gettotal($query);
- echo $num;
- }
-
- //flash幻灯图片信息调用
- function sys_FlashPixpic($classid,$line,$width,$height,$showtitle=true,$strlen,$enews=0,$sec=5,$ewhere='',$eorder=''){
- global $empire,$public_r,$class_r,$class_zr;
- $sql=sys_ReturnBqQuery($classid,$line,$enews,1,$ewhere,$eorder);
- if(!$sql)
- {return "";}
- $i=0;
- while($r=$empire->fetch($sql))
- {
- //标题链接
- $titleurl=sys_ReturnBqTitleLink($r);
- //------是否显示标题
- if($showtitle)
- {
- $title=sub($r[title],0,$strlen,false);
- //标题属性
- $title=addslashes(DoTitleFont($r[titlefont],htmlspecialchars($title)));
- }
- $fh="|";
- if($i==0)
- {
- $fh="";
- }
- $url.=$fh.$titleurl;
- $pic.=$fh.$r[titlepic];
- $subject.=$fh.$title;
- $i=1;
- }
- //显示标题
- if($showtitle)
- {
- $text_height=22;
- }
- else
- {
- $text_height=0;
- }
- ?>
- <script type="text/javascript">
- <!--
- var interval_time=<?=$sec?>;
- var focus_width=<?=$width?>;
- var focus_height=<?=$height?>;
- var text_height=<?=$text_height?>;
- var text_align="center";
- var swf_height = focus_height+text_height;
- var swfpath="<?=$public_r[newsurl]?>e/data/images/pixviewer.swf";
- var swfpatha="<?=$public_r[newsurl]?>e/data/images/pixviewer.swf";
-
- var pics="<?=urlencode($pic)?>";
- var links="<?=urlencode($url)?>";
- var texts="<?=htmlspecialchars($subject)?>";
-
- document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
- document.write('<param name="movie" value="'+swfpath+'"><param name="quality" value="high"><param name="bgcolor" value="#ffffff">');
- document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
- document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'&text_align='+text_align+'&interval_time='+interval_time+'">');
- document.write('<embed src="'+swfpath+'" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'&text_align='+text_align+'&interval_time='+interval_time+'" menu="false" bgcolor="#ffffff" quality="high" width="'+ focus_width +'" height="'+ swf_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />');
- document.write('</object>');
- //-->
- </script>
- <?
- }
-
- //搜索关键字
- function sys_ShowSearchKey($line,$num,$classid=0,$enews=0){
- global $empire,$public_r,$dbtbpre;
- if($enews)
- {
- $order="searchid";
- }
- else
- {
- $order="onclick";
- }
- if($classid)
- {
- $add=" and classid='$classid'";
- }
- $sql=$empire->query("select searchid,keyboard from {$dbtbpre}enewssearch where iskey=0".$add." order by ".$order." desc limit ".$num);
- $i=0;
- $returnkey="";
- while($r=$empire->fetch($sql))
- {
- $i++;
- $keyurl=$public_r[newsurl]."e/search/result/?searchid=$r[searchid]";
- $br="";
- if($i%$line==0)
- {
- $br="<br>";
- }
- $jg=" ";
- if($br)
- {
- $jg="";
- }
- $returnkey.="<a href='".$keyurl."' target=_blank>".$r[keyboard]."</a>".$jg.$br;
- }
- echo $returnkey;
- }
-
- //带模板的标签显示-循环
- function sys_GetEcmsInfoMore($classid,$line,$strlen,$have_class=0,$ecms=0,$tr,$doing=0,$field,$cr,$dofirstinfo=0,$fsubtitle=0,$fsubnews=0,$fdoing=0,$ewhere='',$eorder=''){
- global $empire,$public_r;
- //操作类型
- if($ecms==0)//栏目最新
- {
- $enews=0;
- }
- elseif($ecms==1)//栏目热门
- {
- $enews=1;
- }
- elseif($ecms==2)//栏目推荐
- {
- $enews=2;
- }
- elseif($ecms==3)//栏目评论排行
- {
- $enews=9;
- }
- elseif($ecms==4)//栏目头条
- {
- $enews=12;
- }
- elseif($ecms==5)//栏目下载排行
- {
- $enews=15;
- }
- elseif($ecms==6)//栏目评分
- {
- $enews=25;
- }
- elseif($ecms==7)//栏目投票
- {
- $enews=26;
- }
- else
- {
- $enews=0;
- }
- $sql=sys_ReturnBqQuery($classid,$line,$enews,$doing,$ewhere,$eorder);
- if(!$sql)
- {return "";}
- //取得模板
- $listtemp=$tr[temptext];
- $subnews=$tr[subnews];
- $listvar=$tr[listvar];
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- $docode=$tr[docode];
- //替换变量
- $listtemp=ReplaceEcmsinfoClassname($listtemp,$enews,$classid);
- $listtemp=sys_ForSonclassDataFirstInfo($listtemp,$cr,$dofirstinfo,$fsubtitle,$fsubnews,$fdoing);
- if(empty($rownum))
- {$rownum=1;}
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- while($r=$empire->fetch($sql))
- {
- $r[oldtitle]=$r[title];
- //替换列表变量
- $repvar=ReplaceListVars($no,$listvar,$subnews,$strlen,$formatdate,$url,$have_class,$r,$field,$docode);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //循环子栏目显示头条信息
- function sys_ForSonclassDataFirstInfo($temptext,$cr,$ecms=0,$subtitle=0,$subnews=0,$fdoing=0){
- global $empire,$class_r,$public_r,$dbtbpre;
- if($ecms==2||$ecms==3||$ecms==4)
- {
- $where=$class_r[$cr[classid]][islast]?"classid='$cr[classid]'":ReturnClass($class_r[$cr[classid]][sonclass]);
- }
- if($fdoing)
- {
- $add=" and ispic=1";
- }
- if($ecms==1)//栏目缩图
- {
- $id=$cr['classid'];
- $title=$cr['classname'];
- $titleurl=sys_ReturnBqClassname($cr,9);
- $titlepic=$cr['classimg'];
- $smalltext=$cr['intro'];
- }
- elseif($ecms==2)//推荐信息
- {
- $r=$empire->fetch1("select * from {$dbtbpre}ecms_".$class_r[$cr[classid]][tbname]." where checked=1 and isgood>0 and (".$where.")".$add." order by newstime desc limit 1");
- }
- elseif($ecms==3)//头条信息
- {
- $r=$empire->fetch1("select * from {$dbtbpre}ecms_".$class_r[$cr[classid]][tbname]." where checked=1 and firsttitle>0 and (".$where.")".$add." order by newstime desc limit 1");
- }
- elseif($ecms==4)//最新信息
- {
- $r=$empire->fetch1("select * from {$dbtbpre}ecms_".$class_r[$cr[classid]][tbname]." where checked=1 and (".$where.")".$add." order by newstime desc limit 1");
- }
- else
- {
- return $temptext;
- }
- if($ecms!=1)
- {
- $id=$r['id'];
- $title=$r['title'];
- $titleurl=sys_ReturnBqTitleLink($r);
- $titlepic=$r['titlepic'];
- //简介
- if($r['smalltext'])
- {$smalltext=$r['smalltext'];}
- elseif($r['flashsay'])
- {$smalltext=$r['flashsay'];}
- elseif($r['softsay'])
- {$smalltext=$r['softsay'];}
- elseif($r['moviesay'])
- {$smalltext=$r['moviesay'];}
- elseif($r['picsay'])
- {$smalltext=$r['picsay'];}
- }
- $oldtitle=$title;
- if($subtitle)
- {$title=sub($title,0,$subtitle,false);}
- if(empty($titlepic))
- {$titlepic=$public_r[newsurl]."e/data/images/notimg.gif";}
- if(!empty($subnews))
- {$smalltext=sub($smalltext,0,$subnews,false);}
- $temptext=str_replace('[!--sonclass.id--]',$id,$temptext);
- $temptext=str_replace('[!--sonclass.title--]',$title,$temptext);
- $temptext=str_replace('[!--sonclass.oldtitle--]',$oldtitle,$temptext);
- $temptext=str_replace('[!--sonclass.titlepic--]',$titlepic,$temptext);
- $temptext=str_replace('[!--sonclass.titleurl--]',$titleurl,$temptext);
- $temptext=str_replace('[!--sonclass.text--]',$smalltext,$temptext);
- return $temptext;
- }
-
- //循环子栏目数据
- function sys_ForSonclassData($classid,$line,$strlen,$have_class=0,$enews=0,$tempid,$doing=0,$cline=0,$dofirstinfo=0,$fsubtitle=0,$fsubnews=0,$fdoing=0,$ewhere='',$eorder=''){
- global $empire,$public_r,$class_r,$class_zr,$navclassid,$dbtbpre;
- //多栏目
- if(strstr($classid,","))
- {
- $son_r=sys_ReturnMoreClass($classid);
- $classid=$son_r[0];
- $where=$son_r[1];
- }
- else
- {
- //当前栏目
- if($classid=="selfinfo")
- {
- $classid=$navclassid;
- }
- $where="bclassid='$classid'";
- }
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $tr[temptext]=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $tr[listvar]=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- //限制条数
- if($cline)
- {
- $limit=" limit ".$cline;
- }
- //字段
- $ret_r=ReturnReplaceListF($tr[modid]);
- //栏目字段
- if($dofirstinfo==1)
- {
- $addclassfield=',classname,classimg,intro';
- }
- $csql=$empire->query("select classid".$addclassfield." from {$dbtbpre}enewsclass where ".$where." and wburl='' order by myorder,classid".$limit);
- while($cr=$empire->fetch($csql))
- {
- sys_GetEcmsInfoMore($cr[classid],$line,$strlen,$have_class,$enews,$tr,$doing,$ret_r,$cr,$dofirstinfo,$fsubtitle,$fsubnews,$fdoing,$ewhere,$eorder);
- }
- }
-
- //带模板的栏目导航标签
- function sys_ShowClassByTemp($classid,$tempid,$show=0,$cline=0){
- global $navclassid,$empire,$class_r,$public_r,$dbtbpre;
- //当前栏目
- if($classid=="selfinfo")
- {
- if(empty($navclassid))
- {$classid=0;}
- else
- {
- $classid=$navclassid;
- //终极类别则显示同级类别
- if($class_r[$classid][islast]&&$class_r[$classid][bclassid])
- {
- $classid=$class_r[$classid][bclassid];
- }
- if($class_r[$classid][islast]&&empty($class_r[$classid][bclassid]))
- {$classid=0;}
- }
- }
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- if(empty($rownum))
- {$rownum=1;}
- //限制条数
- if($cline)
- {
- $limit=" limit ".$cline;
- }
- //替换变量
- $bclassname=$class_r[$classid][classname];
- $br[classid]=$classid;
- $bclassurl=sys_ReturnBqClassname($br,9);
- $listtemp=str_replace("[!--bclassname--]",$bclassname,$listtemp);
- $listtemp=str_replace("[!--bclassurl--]",$bclassurl,$listtemp);
- $listtemp=str_replace("[!--bclassid--]",$classid,$listtemp);
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- $sql=$empire->query("select classid,classname,islast,sonclass,tbname,intro,classimg from {$dbtbpre}enewsclass where bclassid='$classid' and showclass=0 order by myorder,classid".$limit);
- while($r=$empire->fetch($sql))
- {
- //显示类别数据数
- if($show)
- {
- //终极类别
- if($r[islast])
- {
- $where="classid='$r[classid]'";
- }
- else
- {
- $where=ReturnClass($r[sonclass]);
- }
- $cr=$empire->fetch1("select count(*) as total from {$dbtbpre}ecms_".$r[tbname]." where ".$where." and checked=1");
- $num=$cr[total];
- }
- //替换列表变量
- $repvar=ReplaceShowClassVars($no,$listvar,$r,$num,0,$subnews);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //循环子栏目导航标签
- function sys_ForShowSonClass($classid,$tempid,$show=0,$cline=0){
- global $navclassid,$empire,$class_r,$public_r,$dbtbpre;
- //多栏目
- if(strstr($classid,","))
- {
- $where='classid in ('.$classid.')';
- }
- else
- {
- if($classid=="selfinfo")//当前栏目
- {
- $classid=intval($navclassid);
- }
- $where="bclassid='$classid'";
- }
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $tr[temptext]=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $tr[listvar]=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- //限制条数
- if($cline)
- {
- $limit=" limit ".$cline;
- }
- $no=1;
- $sql=$empire->query("select classid,classname,islast,sonclass,tbname,intro,classimg from {$dbtbpre}enewsclass where ".$where." and showclass=0 order by myorder,classid".$limit);
- while($r=$empire->fetch($sql))
- {
- //显示栏目数据数
- if($show)
- {
- if($r[islast])//终极栏目
- {
- $swhere="classid='$r[classid]'";
- }
- else
- {
- $swhere=ReturnClass($r[sonclass]);
- }
- $num=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_".$r[tbname]." where ".$swhere." and checked=1");
- }
- sys_GetShowClassMore($r[classid],$r,$tr,$no,$num,$show);
- $no++;
- }
- }
-
- //栏目导航标签-循环
- function sys_GetShowClassMore($bclassid,$bcr,$tr,$bno,$bnum,$show=0){
- global $empire,$class_r,$public_r,$dbtbpre;
- //取得模板
- $listtemp=$tr[temptext];
- $subnews=$tr[subnews];
- $listvar=$tr[listvar];
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- if(empty($rownum))
- {$rownum=1;}
- //替换变量
- $listtemp=str_replace("[!--bclassname--]",$bcr[classname],$listtemp);
- $bclassurl=sys_ReturnBqClassname($bcr,9);//栏目链接
- $listtemp=str_replace("[!--bclassurl--]",$bclassurl,$listtemp);
- $listtemp=str_replace("[!--bclassid--]",$bclassid,$listtemp);
- $bclassimg=$bcr[classimg]?$bcr[classimg]:$public_r[newsurl]."e/data/images/notimg.gif";//栏目图片
- $listtemp=str_replace("[!--bclassimg--]",$bclassimg,$listtemp);
- $listtemp=str_replace("[!--bintro--]",nl2br($bcr[intro]),$listtemp);//栏目简介
- $listtemp=str_replace("[!--bno--]",$bno,$listtemp);
- $listtemp=str_replace("[!--bnum--]",$bnum,$listtemp);
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- $sql=$empire->query("select classid,classname,islast,sonclass,tbname,intro,classimg from {$dbtbpre}enewsclass where bclassid='$bclassid' and showclass=0 order by myorder,classid");
- while($r=$empire->fetch($sql))
- {
- //显示栏目数据数
- if($show)
- {
- if($r[islast])//终极栏目
- {
- $where="classid='$r[classid]'";
- }
- else
- {
- $where=ReturnClass($r[sonclass]);
- }
- $num=$empire->gettotal("select count(*) as total from {$dbtbpre}ecms_".$r[tbname]." where ".$where." and checked=1");
- }
- //替换列表变量
- $repvar=ReplaceShowClassVars($no,$listvar,$r,$num,0,$subnews);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //替换栏目导航标签
- function ReplaceShowClassVars($no,$listtemp,$r,$num,$ecms=0,$subnews=0){
- global $public_r,$class_r;
- //栏目链接
- if($ecms==1)
- {
- $classurl=sys_ReturnBqZtname($r);
- $r['classname']=$r['ztname'];
- $r['classid']=$r['ztid'];
- $r['classimg']=$r['ztimg'];
- }
- else
- {
- $classurl=sys_ReturnBqClassname($r,9);
- }
- if($subnews)
- {
- $r[intro]=sub($r[intro],0,$subnews,false);
- }
- $listtemp=str_replace("[!--classurl--]",$classurl,$listtemp);
- //栏目名称
- $listtemp=str_replace("[!--classname--]",$r[classname],$listtemp);
- //栏目id
- $listtemp=str_replace("[!--classid--]",$r[classid],$listtemp);
- //栏目图片
- if(empty($r[classimg]))
- {
- $r[classimg]=$public_r[newsurl]."e/data/images/notimg.gif";
- }
- $listtemp=str_replace("[!--classimg--]",$r[classimg],$listtemp);
- //栏目简介
- $listtemp=str_replace("[!--intro--]",nl2br($r[intro]),$listtemp);
- //记录数
- $listtemp=str_replace("[!--num--]",$num,$listtemp);
- //序号
- $listtemp=str_replace("[!--no--]",$no,$listtemp);
- return $listtemp;
- }
-
- //留言调用
- function sys_ShowLyInfo($line,$tempid,$bid=0){
- global $empire,$dbtbpre,$public_r;
- $a="";
- if($bid)
- {
- $a=" and bid='$bid'";
- }
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- if(empty($rownum))
- {$rownum=1;}
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- $sql=$empire->query("select lyid,name,email,lytime,lytext,retext from {$dbtbpre}enewsgbook where checked=0".$a." order by lyid desc limit ".$line);
- while($r=$empire->fetch($sql))
- {
- //替换列表变量
- $repvar=ReplaceShowLyVars($no,$listvar,$r,$formatdate,$subnews);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //替换留言标签
- function ReplaceShowLyVars($no,$listtemp,$r,$formatdate,$subnews=0){
- global $public_r;
- if($subnews)
- {
- $r['lytext']=sub($r['lytext'],0,$subnews,false);
- }
- $listtemp=str_replace("[!--lyid--]",$r['lyid'],$listtemp);//id
- $listtemp=str_replace("[!--lytext--]",nl2br($r['lytext']),$listtemp);//留言内容
- $listtemp=str_replace("[!--retext--]",nl2br($r['retext']),$listtemp);//回复
- $listtemp=str_replace("[!--lytime--]",format_datetime($r['lytime'],$formatdate),$listtemp);
- $listtemp=str_replace("[!--name--]",$r['name'],$listtemp);
- $listtemp=str_replace("[!--email--]",$r['email'],$listtemp);
- //序号
- $listtemp=str_replace("[!--no--]",$no,$listtemp);
- return $listtemp;
- }
-
- //专题调用
- function sys_ShowZtData($tempid,$zcid=0,$cline=0,$classid=0){
- global $empire,$dbtbpre,$public_r;
- $a='';
- if($zcid)
- {
- $a.=' and zcid in ('.$zcid.')';
- }
- if($classid)
- {
- $a.=' and classid in ('.$classid.')';
- }
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- if(empty($rownum))
- {$rownum=1;}
- //限制条数
- if($cline)
- {
- $limit=" limit ".$cline;
- }
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- $sql=$empire->query("select ztid,ztname,intro,ztimg from {$dbtbpre}enewszt where showzt=0".$a." order by myorder,ztid desc".$limit);
- while($r=$empire->fetch($sql))
- {
- //替换列表变量
- $repvar=ReplaceShowClassVars($no,$listvar,$r,$num,1,$subnews);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //图库模型分页标签
- function sys_PhotoMorepage($tempid,$spicwidth=0,$spicheight=0){
- global $navinfor;
- $morepic=$navinfor['morepic'];
- if(empty($morepic))
- {
- return "";
- }
- //取得标签
- $tempr=sys_ReturnBqTemp($tempid);
- if(empty($tempr['tempid']))
- {return "";}
- $rexp="\r\n";
- $fexp="::::::";
- $gs="";
- if($spicwidth)
- {$gs=" width='".$spicwidth."'";}
- if($spicheight)
- {$gs.=" height='".$spicheight."'";}
- $rstr="";
- $sdh="";
- $firstpic="";
- $optionstr="";
- $titleoption="";
- $listpage="";
- $nbsp="";
- $rr=explode($rexp,$morepic);
- $count=count($rr);
- for($i=0;$i<$count;$i++)
- {
- $j=$i+1;
- $fr=explode($fexp,$rr[$i]);
- $smallpic=$fr[0]; //小图
- $bigpic=$fr[1]; //大图
- if(empty($bigpic))
- {
- $bigpic=$smallpic;
- }
- $picname=htmlspecialchars($fr[2]); //名称
- $showpic=ReplaceMorePagelistvar($tempr['listvar'],$picname,$bigpic);
- $sdh.=$nbsp."<a href='#ecms' onclick='GotoPhPage(".$j.");' title='".$picname."'><img src='".$smallpic."' alt='".$picname."' border=0".$gs."></a>";
- if($i==0)
- {
- $firstpic=$showpic;
- }
- $rstr.="photosr[".$j."]=\"".addslashes($showpic)."\";
- ";
- $optionstr.="<option value=".$j.">第 ".$j." 页</option>";
- $titleoption.="<option value=".$j.">".$j."、".$picname."</option>";
- $listpage.=$nbsp."<a href='#ecms' onclick='GotoPhPage(".$j.");' title='".$picname."'>".$j."</a>";
- $nbsp=" ";
- }
- echo ReplaceMorePagetemp($tempr['temptext'],$rstr,$sdh,$optionstr,$titleoption,$firstpic,$listpage);
- }
-
- //替换图片集分页模板
- function ReplaceMorePagetemp($temp,$rstr,$sdh,$select,$titleselect,$showpic,$listpage){
- $temp=str_replace("[!--photor--]",$rstr,$temp);
- $temp=str_replace("[!--smalldh--]",$sdh,$temp);
- $temp=str_replace("[!--select--]",$select,$temp);
- $temp=str_replace("[!--titleselect--]",$titleselect,$temp);
- $temp=str_replace("[!--listpage--]",$listpage,$temp);
- $temp=str_replace("<!--list.var1-->",$showpic,$temp);
- return $temp;
- }
-
- //替换图片集listvar模板
- function ReplaceMorePagelistvar($temp,$picname,$picurl){
- $temp=str_replace("[!--picname--]",$picname,$temp);
- $temp=str_replace("[!--picurl--]",$picurl,$temp);
- return $temp;
- }
-
- //输出复选框字段内容
- function sys_EchoCheckboxFValue($f,$exp='<br>'){
- global $navinfor;
- $r=explode('|',$navinfor[$f]);
- $count=count($r);
- for($i=1;$i<$count-1;$i++)
- {
- if($i==1)
- {
- $str.=$r[$i];
- }
- else
- {
- $str.=$exp.$r[$i];
- }
- }
- echo $str;
- }
-
- //评论调用
- function sys_ShowPlInfo($line,$tempid,$classid=0,$id=0,$isgood=0,$enews=0){
- global $empire,$dbtbpre,$class_r,$public_r;
- $a="";
- if($isgood)
- {
- $a.=" and isgood='$isgood'";
- }
- if($classid)
- {
- if($class_r[$classid][islast])
- {
- $where="classid='$classid'";
- }
- else
- {
- $where=ReturnClass($class_r[$classid][sonclass]);
- }
- $a.=" and ".$where;
- }
- if($id)
- {
- $a.=" and id='$id'";
- }
- //排序
- if($enews==1)//支持
- {
- $order='zcnum desc,plid desc';
- }
- elseif($enews==2)//反对
- {
- $order='fdnum desc,plid desc';
- }
- else//发布时间
- {
- $order='plid desc';
- }
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- if(empty($rownum))
- {$rownum=1;}
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- $sql=$empire->query("select plid,userid,username,saytime,id,classid,zcnum,fdnum,stb from {$dbtbpre}enewspl where checked=0".$a." order by ".$order." limit ".$line);
- while($r=$empire->fetch($sql))
- {
- $fr=$empire->fetch1("select saytext from {$dbtbpre}enewspl_data_".$r['stb']." where plid='$r[plid]'");
- $r[saytext]=$fr[saytext];
- //替换列表变量
- $repvar=ReplaceShowPlVars($no,$listvar,$r,$formatdate,$subnews);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //替换评论标签
- function ReplaceShowPlVars($no,$listtemp,$r,$formatdate,$subnews=0){
- global $public_r,$empire,$dbtbpre,$class_r;
- //标题
- $infor=$empire->fetch1("select titleurl,groupid,classid,newspath,filename,id,title from {$dbtbpre}ecms_".$class_r[$r[classid]][tbname]." where id='$r[id]' limit 1");
- $r['saytext']=stripSlashes($r['saytext']);
- if($subnews)
- {
- $r['saytext']=sub($r['saytext'],0,$subnews,false);
- }
- if($r['userid'])
- {
- $r['username']="<a href='".$public_r[newsurl]."e/space/?userid=$r[userid]' target='_blank'>$r[username]</a>";
- }
- if(empty($r['username']))
- {
- $r['username']='匿名';
- }
- $titleurl=sys_ReturnBqTitleLink($infor);
- $listtemp=str_replace("[!--titleurl--]",$titleurl,$listtemp);
- $listtemp=str_replace("[!--title--]",$infor['title'],$listtemp);
- $listtemp=str_replace("[!--plid--]",$r['plid'],$listtemp);
- $listtemp=str_replace("[!--pltext--]",RepPltextFace($r['saytext']),$listtemp);
- $listtemp=str_replace("[!--id--]",$r['id'],$listtemp);
- $listtemp=str_replace("[!--classid--]",$r['classid'],$listtemp);
- $listtemp=str_replace("[!--pltime--]",format_datetime($r['saytime'],$formatdate),$listtemp);
- $listtemp=str_replace("[!--username--]",$r['username'],$listtemp);
- $listtemp=str_replace("[!--zcnum--]",$r['zcnum'],$listtemp);
- $listtemp=str_replace("[!--fdnum--]",$r['fdnum'],$listtemp);
- //序号
- $listtemp=str_replace("[!--no--]",$no,$listtemp);
- return $listtemp;
- }
-
- //显示单个会员信息
- function sys_ShowMemberInfo($userid=0,$fields=''){
- global $empire,$dbtbpre,$public_r,$navinfor,$level_r,$user_tablename,$user_userid,$user_group;
- if(empty($userid)&&$navinfor[ismember]==0)
- {
- return '';
- }
- if(!defined('InEmpireCMSUser'))
- {
- include_once ECMS_PATH.'e/class/user.php';
- }
- $uid=$userid?$userid:$navinfor[userid];
- $uid=(int)$uid;
- if(empty($fields))
- {
- $fields='u.*,ui.*';
- }
- $r=$empire->fetch1("select ".$fields." from {$user_tablename} u LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u.".$user_userid."=ui.userid where u.".$user_userid."='$uid' limit 1");
- $r['groupname']=$level_r[$r[$user_group]][groupname];//会员组
- return $r;
- }
-
- //调用会员列表
- function sys_ListMemberInfo($line=10,$ecms=0,$groupid=0,$userids=0,$fields=''){
- global $empire,$dbtbpre,$public_r,$navinfor,$level_r,$user_tablename,$user_userid,$user_group,$user_userfen,$user_money,$user_checked;
- if(!defined('InEmpireCMSUser'))
- {
- include_once ECMS_PATH.'e/class/user.php';
- }
- //操作类型
- if($ecms==1)//积分排行
- {
- $order='u.'.$user_userfen.' desc';
- }
- elseif($ecms==2)//资金排行
- {
- $order='u.'.$user_money.' desc';
- }
- elseif($ecms==3)//空间人气排行
- {
- $order='ui.viewstats desc';
- }
- else//用户ID排行
- {
- $order='u.'.$user_userid.' desc';
- }
- $where='';
- if($groupid)
- {
- $where.=' and u.'.$user_group.' in ('.$groupid.')';
- }
- if($userids)
- {
- $where.=' and u.'.$user_userid.' in ('.$userids.')';
- }
- if(empty($fields))
- {
- $fields='u.*,ui.*';
- }
- $sql=$empire->query("select ".$fields." from {$user_tablename} u LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u.".$user_userid."=ui.userid where u.".$user_checked."=1".$where." order by ".$order." limit ".$line);
- return $sql;
- }
-
- //显示TAGS
- function sys_eShowTags($cid,$num=0,$line=0,$order='',$isgood='',$isgoodshow='',$showjg='',$shownum=0,$cs=''){
- global $empire,$dbtbpre,$public_r,$navinfor;
- $str='';
- if(empty($showjg))
- {
- $showjg=' ';
- }
- $ln=0;
- if($cid=='selfinfo')
- {
- if(empty($navinfor['infotags']))
- {
- return '';
- }
- $jg='';
- $r=explode(',',$navinfor['infotags']);
- $count=count($r);
- for($i=0;$i<$count;$i++)
- {
- $ln++;
- $br='';
- if($line)
- {
- if($ln%$line==0)
- {
- $br='<br>';
- }
- }
- $str.=$jg.'<a href="'.$public_r[newsurl].'e/tags/?tagname='.urlencode($r[$i]).$cs.'" target="_blank">'.$r[$i].'</a>'.$br;
- $jg=$br?'':$showjg;
- }
- }
- else
- {
- $and='';
- $where='';
- if($cid)
- {
- $where=strstr($cid,',')?"cid in ($cid)":"cid='$cid'";
- $and=' and ';
- }
- if($isgood)
- {
- $where.=$and.'isgood=1';
- }
- if($where)
- {
- $where=' where '.$where;
- }
- $order=$order?' '.$order:' tagid desc';
- $limit='';
- if($num)
- {
- $limit=' limit '.$num;
- }
- //推荐标红
- $gfont1='';
- $gfont2='';
- if($isgoodshow)
- {
- if(strstr($isgoodshow,'r'))
- {
- $gfont1='<font color="red">';
- $gfont2='</font>';
- }
- if(strstr($isgoodshow,'s'))
- {
- $gfont1=$gfont1.'<b>';
- $gfont2='</b>'.$gfont2;
- }
- }
- $jg='';
- $snum='';
- $sql=$empire->query("select tagid,tagname,num,isgood from {$dbtbpre}enewstags".$where." order by".$order.$limit);
- while($r=$empire->fetch($sql))
- {
- if($shownum)
- {
- $snum='('.$r[num].')';
- }
- $font1='';
- $font2='';
- if($isgoodshow&&$r[isgood])
- {
- $font1=$gfont1;
- $font2=$gfont2;
- }
- $ln++;
- $br='';
- if($line)
- {
- if($ln%$line==0)
- {
- $br='<br>';
- }
- }
- $str.=$jg.'<a href="'.$public_r[newsurl].'e/tags/?tagid='.$r[tagid].$cs.'" target="_blank">'.$font1.$r[tagname].$snum.$font2.'</a>'.$br;
- $jg=$br?'':$showjg;
- }
- }
- echo $str;
- }
-
- //返回组合查询
- function sys_ReturnTogQuery($type,$id,$line,$classid='',$mid=''){
- global $empire,$public_r,$class_r,$class_zr,$navclassid,$dbtbpre,$class_tr,$emod_r;
- if($type=='tags')//TAGS
- {
- $idf='tagid';
- $orderf='newstime';
- $table=$dbtbpre.'enewstagsdata';
- }
- else//碎片
- {
- $idf='spid';
- $orderf='newstime';
- $table=$dbtbpre.'enewssp_2';
- }
- $where=strstr($id,',')?"$idf in ($id)":"$idf='$id'";
- //栏目
- if($classid)
- {
- if(strstr($classid,','))//多栏目
- {
- $son_r=sys_ReturnMoreClass($classid,1);
- $classid=$son_r[0];
- $add=$son_r[1];
- }
- else
- {
- if($classid=='selfinfo')//显示当前栏目信息
- {
- $classid=$navclassid;
- }
- if($class_r[$classid][islast])
- {
- $add="classid='$classid'";
- }
- else
- {
- $add=ReturnClass($class_r[$classid][sonclass]);
- }
- }
- $where.=' and ('.$add.')';
- }
- //模型
- if($mid)
- {
- $where.=strstr($mid,',')?" and mid in ($mid)":" and mid='$mid'";
- }
- $query='select classid,id from '.$table.' where '.$where.' order by '.$orderf.' desc limit '.$line;
- $sql=$empire->query1($query);
- if(!$sql)
- {
- echo"SQL Error: ".ReRepSqlTbpre($query);
- }
- return $sql;
- }
-
- //调用TAGS信息
- function sys_eShowTagsInfo($tagid,$line,$strlen,$tempid,$classid='',$mid=''){
- global $empire,$dbtbpre,$public_r,$class_r,$emod_r;
- if(empty($tagid))
- {
- return '';
- }
- $sql=sys_ReturnTogQuery('tags',$tagid,$line,$classid,$mid);
- if(!$sql)
- {return "";}
- //取得模板
- $tr=sys_ReturnBqTemp($tempid);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- $docode=$tr[docode];
- if(empty($rownum))
- {$rownum=1;}
- //字段
- $ret_r=ReturnReplaceListF($tr[modid]);
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- while($r=$empire->fetch($sql))
- {
- if(empty($class_r[$r[classid]][tbname]))
- {
- continue;
- }
- $infor=$empire->fetch1("select * from {$dbtbpre}ecms_".$class_r[$r[classid]][tbname]." where id='$r[id]'");
- if(empty($infor[checked]))
- {
- continue;
- }
- $infor[oldtitle]=$infor[title];
- //替换列表变量
- $repvar=ReplaceListVars($no,$listvar,$subnews,$strlen,$formatdate,$url,$have_class,$infor,$ret_r,$docode);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //-------------------------- 碎片 --------------------------
- //显示碎片
- function sys_eShowSpInfo($spvar,$line=10,$strlen=0){
- global $empire,$dbtbpre,$public_r;
- if(empty($spvar))
- {
- return '';
- }
- $spr=$empire->fetch1("select spid,spname,sppic,spsay,tempid,sptype from {$dbtbpre}enewssp where varname='$spvar' limit 1");
- if($spr['sptype']==1)//静态信息碎片
- {
- sys_eShowSp1($spr['spid'],$spr,$line,$strlen);
- }
- elseif($spr['sptype']==2)
- {
- sys_eShowSp2($spr['spid'],$spr,$line,$strlen);
- }
- elseif($spr['sptype']==3)
- {
- sys_eShowSp3($spr['spid']);
- }
- }
-
- //替换碎片名
- function ReplaceSpClassname($temp,$spid,$spr){
- $temp=str_replace("[!--the.spname--]",$spr[spname],$temp);
- $temp=str_replace("[!--the.spid--]",$spid,$temp);
- $temp=str_replace("[!--the.sppic--]",$spr[sppic],$temp);
- $temp=str_replace("[!--the.spsay--]",$spr[spsay],$temp);
- return $temp;
- }
-
- //静态信息碎片
- function sys_eShowSp1($spid,$spr,$line,$strlen){
- global $empire,$dbtbpre,$public_r;
- //取得模板
- $tr=sys_ReturnBqTemp($spr['tempid']);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- //替换模板变量
- $listtemp=ReplaceSpClassname($listtemp,$spid,$spr);
- if(empty($rownum))
- {$rownum=1;}
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- $sql=$empire->query("select sid,title,titlepic,bigpic,titleurl,smalltext,titlefont,newstime,titlepre,titlenext from {$dbtbpre}enewssp_1 where spid='$spid' order by newstime desc limit ".$line);
- while($r=$empire->fetch($sql))
- {
- $r[oldtitle]=$r[title];
- //替换列表变量
- $repvar=ReplaceShowSponeVars($no,$listvar,$subnews,$strlen,$formatdate,$r);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //替换静态碎片标签
- function ReplaceShowSponeVars($no,$listtemp,$subnews,$subtitle,$formatdate,$r){
- global $public_r;
- //标题
- if(!empty($subtitle))//截取字符
- {
- $r[title]=sub($r[title],0,$subtitle,false);
- }
- $r[title]=DoTitleFont($r[titlefont],$r[title]);
- $listtemp=str_replace('[!--title--]',$r['title'],$listtemp);
- $listtemp=str_replace('[!--oldtitle--]',$r['oldtitle'],$listtemp);
- //时间
- $listtemp=str_replace('[!--newstime--]',date($formatdate,$r['newstime']),$listtemp);
- //其它变量
- $listtemp=str_replace('[!--id--]',$r['sid'],$listtemp);
- $listtemp=str_replace('[!--titleurl--]',$r['titleurl'],$listtemp);
- $listtemp=str_replace('[!--titlepic--]',$r['titlepic'],$listtemp);
- $listtemp=str_replace('[!--bigpic--]',$r['bigpic'],$listtemp);
- $listtemp=str_replace('[!--titlepre--]',$r['titlepre'],$listtemp);
- $listtemp=str_replace('[!--titlenext--]',$r['titlenext'],$listtemp);
- //简介
- if(!empty($subnews))//截取字符
- {
- $r[smalltext]=sub($r[smalltext],0,$subnews,false);
- }
- $listtemp=str_replace('[!--smalltext--]',nl2br($r['smalltext']),$listtemp);
- //序号
- $listtemp=str_replace('[!--no.num--]',$no,$listtemp);
- return $listtemp;
- }
-
- //动态信息碎片
- function sys_eShowSp2($spid,$spr,$line,$strlen){
- global $empire,$dbtbpre,$public_r,$class_r,$emod_r;
- $sql=sys_ReturnTogQuery('sp',$spid,$line,'','');
- if(!$sql)
- {return "";}
- //取得模板
- $tr=sys_ReturnBqTemp($spr['tempid']);
- if(empty($tr['tempid']))
- {return "";}
- $listtemp=str_replace('[!--news.url--]',$public_r[newsurl],$tr[temptext]);
- $subnews=$tr[subnews];
- $listvar=str_replace('[!--news.url--]',$public_r[newsurl],$tr[listvar]);
- $rownum=$tr[rownum];
- $formatdate=$tr[showdate];
- $docode=$tr[docode];
- //替换模板变量
- $listtemp=ReplaceSpClassname($listtemp,$spid,$spr);
- if(empty($rownum))
- {$rownum=1;}
- //字段
- $ret_r=ReturnReplaceListF($tr[modid]);
- //列表
- $list_exp="[!--empirenews.listtemp--]";
- $list_r=explode($list_exp,$listtemp);
- $listtext=$list_r[1];
- $no=1;
- $changerow=1;
- while($r=$empire->fetch($sql))
- {
- if(empty($class_r[$r[classid]][tbname]))
- {
- continue;
- }
- $infor=$empire->fetch1("select * from {$dbtbpre}ecms_".$class_r[$r[classid]][tbname]." where id='$r[id]'");
- if(empty($infor[checked]))
- {
- continue;
- }
- $infor[oldtitle]=$infor[title];
- //替换列表变量
- $repvar=ReplaceListVars($no,$listvar,$subnews,$strlen,$formatdate,$url,$have_class,$infor,$ret_r,$docode);
- $listtext=str_replace("<!--list.var".$changerow."-->",$repvar,$listtext);
- $changerow+=1;
- //超过行数
- if($changerow>$rownum)
- {
- $changerow=1;
- $string.=$listtext;
- $listtext=$list_r[1];
- }
- $no++;
- }
- //多余数据
- if($changerow<=$rownum&&$listtext<>$list_r[1])
- {
- $string.=$listtext;
- }
- $string=$list_r[0].$string.$list_r[2];
- echo $string;
- }
-
- //代码碎片
- function sys_eShowSp3($spid){
- global $empire,$dbtbpre;
- $r=$empire->fetch1("select sptext from {$dbtbpre}enewssp_3 where spid='$spid' limit 1");
- echo $r['sptext'];
- }
-
- //调用生成缩图
- function sys_ResizeImg($file,$width,$height,$docut=0,$target_filename=''){
- global $public_r,$tranpicturetype;
- if(!$file||!$width||!$height)
- {
- return $file;
- }
- //扩展名
- $filetype=GetFiletype($file);
- if(!strstr($tranpicturetype,','.$filetype.','))
- {
- return $file;
- }
- $efileurl=eReturnFileUrl();
- if(strstr($file,$efileurl))
- {
- $file=str_replace($efileurl,'/d/file/',$file);
- }
- if(strstr($file,'://'))
- {
- return $file;
- }
- $filename=ECMS_PATH.substr($file,1);
- if(!file_exists($filename))
- {
- return $file;
- }
- if($target_filename)
- {
- $newfilename=$target_filename;
- }
- else
- {
- $newfilename=md5($file.'-'.$width.'-'.$height.'-'.$docut);
- }
- $newname=ECMS_PATH.'e/data/tmp/titlepic/'.$newfilename;
- if(empty($target_filename)&&file_exists($newname.$filetype))
- {
- return $public_r['newsurl'].'e/data/tmp/titlepic/'.$newfilename.$filetype;
- }
- if(!defined('InEmpireCMSGd'))
- {
- include_once ECMS_PATH.'e/class/gd.php';
- }
- $filer=ResizeImage($filename,$newname,$width,$height,$docut);
- $fileurl=$public_r['newsurl'].'e/data/tmp/titlepic/'.$newfilename.$filer['filetype'];
- return $fileurl;
- }
- ?>