帝国cms建站总结-(分页)
帝国cms分页代码文件t_functions.php
代码为:
<?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="",$add){ global $fun_r; //文件名 if(empty($add['dofile'])) { $add['dofile']='index'; } //静态页数 $repagenum=$add['repagenum']; //首页 if($pagenum<>1) { $pagetop="<a href='".$dolink.$add['dofile'].$dotype."'>".$fun_r['startpage']."</a> "; } else { $pagetop=$fun_r['startpage']." "; } //上一页 if($pagenum<>1) { $pagepr=$pagenum-1; if($pagepr==1) { $prido=$add['dofile'].$dotype; } else { $prido=$add['dofile'].'_'.$pagepr.$dotype; } $pagepri="<a href='".$dolink.$prido."'>".$fun_r['pripage']."</a> "; } else { $pagepri=$fun_r['pripage']." "; } //下一页 if($pagenum<>$page) { $pagenex=$pagenum+1; $nextpagelink=$repagenum&&$repagenum<$pagenex?eReturnRewritePageLink2($add,$pagenex):$dolink.$add['dofile'].'_'.$pagenex.$dotype; $pagenext="<a href='".$nextpagelink."'>".$fun_r['nextpage']."</a> "; } else { $pagenext=$fun_r['nextpage']." "; } //尾页 if($pagenum==$page) { $pageeof=$fun_r['lastpage']; } else { $lastpagelink=$repagenum&&$repagenum<$page?eReturnRewritePageLink2($add,$page):$dolink.$add['dofile'].'_'.$page.$dotype; $pageeof="<a href='".$lastpagelink."'>".$fun_r['lastpage']."</a>"; } $options=""; //取得下拉页码 if(empty($search)) { for($go=1;$go<=$page;$go++) { if($go==1) {$file=$add['dofile'].$dotype;} else {$file=$add['dofile'].'_'.$go.$dotype;} $thispagelink=$repagenum&&$repagenum<$go?eReturnRewritePageLink2($add,$go):$dolink.$file; if($ok==$go) {$select=" selected";} else {$select="";} $myoptions.="<option value='".$thispagelink."'>".$fun_r['gotos'].$go.$fun_r['gotol']."</option>"; $options.="<option value='".$thispagelink."'".$select.">".$fun_r['gotos'].$go.$fun_r['gotol']."</option>"; } } else { $myoptions=$search; $options=str_replace("value='".$dolink.$add['dofile'].'_'.$ok.$dotype."'>","value='".$dolink.$add['dofile']."_".$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="",$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=' 共有'.$num.'条记录'; //上一页 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>'; } //下一页 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>'; } $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.$returnstr.$nextpage.$lastpage.$firststr; $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=$toppage.$prepage.$returnstr.$nextpage.$lastpage.$firststr; 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 { $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; } //返回标签模板 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,$class_tr; 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_tr[$classid]['tbname']; $and="ttid='$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,1); } $query="select * from {$dbtbpre}ecms_".$tbname." where ".$yhadd.$and.$keys." 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_GetAd($adid){ global $empire,$public_r,$dbtbpre; $r=$empire->fetch1("select * from {$dbtbpre}enewsad where adid='$adid'"); //到期 if($r['endtime']<>'0000-00-00'&&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_IncludeFile($file){ @include($file); } //读取远程文件 function sys_ReadFile($http){ echo ReadFiletext($http); } //信息统计 function sys_TotalData($classid,$enews=0,$day=0,$totaltype=0){ global $empire,$class_r,$class_zr,$dbtbpre,$fun_r,$class_tr; if(empty($classid)) { return ""; } //统计类型 if($totaltype==1)//评论数 { $totalfield='sum(plnum) as total'; } elseif($totaltype==2)//点击数 { $totalfield='sum(onclick) as total'; } elseif($totaltype==3)//下载数 { $totalfield='sum(totaldown) as total'; } else//信息数 { $totalfield='count(*) as total'; } 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_tr[$classid][tbname])) { echo $fun_r['BqErrorTtid']."=<b>".$classid."</b>".$fun_r['BqErrorNtb']; return ""; } $query="select ".$totalfield." from {$dbtbpre}ecms_".$class_tr[$classid][tbname]." where ttid='$classid'".$and; } elseif($enews==2)//统计数据表 { $query="select ".$totalfield." from {$dbtbpre}ecms_".$classid.(empty($and)?'':' where '.substr($and,5)); } 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 ".$totalfield." from {$dbtbpre}ecms_".$class_r[$classid][tbname]." where ".$where.$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],ehtmlspecialchars($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="<?=ehtmlspecialchars($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 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 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 (".$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,infos from {$dbtbpre}enewsclass where bclassid='$classid' and showclass=0 order by myorder,classid".$limit); while($r=$empire->fetch($sql)) { //显示类别数据数 if($show) { $num=ReturnClassInfoNum($r); } //替换列表变量 $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,infos from {$dbtbpre}enewsclass where ".$where." and showclass=0 order by myorder,classid".$limit); while($r=$empire->fetch($sql)) { //显示栏目数据数 if($show) { $num=ReturnClassInfoNum($r); } 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,infos from {$dbtbpre}enewsclass where bclassid='$bclassid' and showclass=0 order by myorder,classid"); while($r=$empire->fetch($sql)) { //显示栏目数据数 if($show) { $num=ReturnClassInfoNum($r); } //替换列表变量 $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=ehtmlspecialchars($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,saytext from {$dbtbpre}enewspl_".$public_r['pldeftb']." where checked=0".$a." order by ".$order." limit ".$line); while($r=$empire->fetch($sql)) { //替换列表变量 $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 isurl,titleurl,classid,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--]",date($formatdate,$r['saytime']),$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; if(empty($userid)&&$navinfor[ismember]==0) { return ''; } if(!defined('InEmpireCMSUser')) { include_once ECMS_PATH.'e/member/class/user.php'; } $uid=$userid?$userid:$navinfor[userid]; $uid=(int)$uid; if(empty($fields)) { $fields='u.*,ui.*'; } $r=$empire->fetch1("select ".$fields." from ".eReturnMemberTable()." u LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u.".egetmf('userid')."=ui.userid where u.".egetmf('userid')."='$uid' limit 1"); $field_groupid=egetmf('groupid'); $r['groupname']=$level_r[$r[$field_groupid]][groupname];//会员组 return $r; } //调用会员列表 function sys_ListMemberInfo($line=10,$ecms=0,$groupid=0,$userids=0,$fields=''){ global $empire,$dbtbpre,$public_r,$navinfor,$level_r; if(!defined('InEmpireCMSUser')) { include_once ECMS_PATH.'e/member/class/user.php'; } //操作类型 if($ecms==1)//积分排行 { $order='u.'.egetmf('userfen').' desc'; } elseif($ecms==2)//资金排行 { $order='u.'.egetmf('money').' desc'; } elseif($ecms==3)//空间人气排行 { $order='ui.viewstats desc'; } else//用户ID排行 { $order='u.'.egetmf('userid').' desc'; } $where=''; if($groupid) { $where.=' and u.'.egetmf('groupid').' in ('.$groupid.')'; } if($userids) { $where.=' and u.'.egetmf('userid').' in ('.$userids.')'; } if(empty($fields)) { $fields='u.*,ui.*'; } $sql=$empire->query("select ".$fields." from ".eReturnMemberTable()." u LEFT JOIN {$dbtbpre}enewsmemberadd ui ON u.".egetmf('userid')."=ui.userid where u.".egetmf('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='',$vartype=''){ 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>'; } } if(empty($cs)) { $rewriter=eReturnRewriteTagsUrl(0,$r[$i],1); $tagsurl=$rewriter['pageurl']; } else { $tagsurl=$public_r[newsurl].'e/tags/?tagname='.urlencode($r[$i]).$cs; } $str.=$jg.'<a href="'.$tagsurl.'" 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>'; } } if(empty($cs)&&$vartype<>'tagid') { $rewriter=eReturnRewriteTagsUrl($r['tagid'],$r['tagname'],1); $tagsurl=$rewriter['pageurl']; } else { $tagsurl=$public_r[newsurl].'e/tags/?'.($vartype=='tagid'?'tagid='.$r[tagid]:'tagname='.urlencode($r[tagname])).$cs; } $str.=$jg.'<a href="'.$tagsurl.'" target="_blank">'.$font1.$r[tagname].$snum.$font2.'</a>'.$br; $jg=$br?'':$showjg; } } echo $str; } //索引灵动标签:返回SQL内容函数 function sys_ReturnEcmsIndexLoopBq($id=0,$line=10,$enews=3,$classid='',$mid='',$ewhere=''){ global $navclassid; if($enews==1)//专题最新 { $type='zt'; $eorder='newstime desc'; $selectf=',ztid,cid,isgood'; } elseif($enews==2)//专题最早 { $type='zt'; $eorder='newstime asc'; $selectf=',ztid,cid,isgood'; } elseif($enews==3)//专题推荐 { $type='zt'; $eorder='newstime asc'; $selectf=',ztid,cid,isgood'; $where=' and isgood>0'; } elseif($enews==4)//专题子类最新 { $type='ztc'; $eorder='newstime desc'; $selectf=',ztid,cid,isgood'; } elseif($enews==5)//专题子类最早 { $type='ztc'; $eorder='newstime asc'; $selectf=',ztid,cid,isgood'; } elseif($enews==6)//专题子类推荐 { $type='ztc'; $eorder='newstime asc'; $selectf=',ztid,cid,isgood'; $where=' and isgood>0'; } elseif($enews==7)//TAGS最新 { $type='sp'; $eorder='newstime desc'; $selectf=''; } elseif($enews==8)//TAGS最早 { $type='sp'; $eorder='newstime asc'; $selectf=''; } elseif($enews==9)//碎片最新 { $type='tags'; $eorder='newstime desc'; $selectf=''; } elseif($enews==10)//碎片最早 { $type='tags'; $eorder='newstime asc'; $selectf=''; } elseif($enews==11)//SQL调用 { $type='sql'; $eorder='newstime asc'; $selectf=''; } if($id=='selfinfo')//显示当前ID信息 { $id=$navclassid; } return sys_ReturnTogQuery($type,$id,$line,$classid,$mid,$ewhere,$eorder,$selectf); } //返回组合查询 function sys_ReturnTogQuery($type,$id,$line,$classid='',$mid='',$ewhere='',$eorder='',$selectf=''){ global $empire,$public_r,$class_r,$class_zr,$navclassid,$dbtbpre,$class_tr,$emod_r; if($type=='tags')//TAGS { $idf='tagid'; $orderf='newstime desc'; $table=$dbtbpre.'enewstagsdata'; } elseif($type=='zt')//专题 { $idf='ztid'; $orderf='newstime desc'; $table=$dbtbpre.'enewsztinfo'; } elseif($type=='ztc')//专题子类 { $idf='cid'; $orderf='newstime desc'; $table=$dbtbpre.'enewsztinfo'; } elseif($type=='sql')//SQL查询 { $query_first=substr($id,0,7); if(!($query_first=='select '||$query_first=='SELECT ')) { return ''; } $id=RepSqlTbpre($id); $sql=$empire->query1($id); if(!$sql) { echo'SQL Error: '.ReRepSqlTbpre($id); } return $sql; } else//碎片 { $idf='spid'; $orderf='newstime desc'; $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'"; } //附加sql条件 if(!empty($ewhere)) { $where.=' and ('.$ewhere.')'; } //排序 if(!empty($eorder)) { $orderf=$eorder; } $query='select classid,id'.$selectf.' from '.$table.' where '.$where.' order by '.$orderf.' 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]' limit 1"); if(empty($infor['id'])) { 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]' limit 1"); if(empty($infor['id'])) { 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='',$target_path='e/data/tmp/titlepic/'){ global $public_r,$ecms_config; if(!$file||!$width||!$height) { return $file; } //扩展名 $filetype=GetFiletype($file); if(!strstr($ecms_config['sets']['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); } $newpath=ECMS_PATH.$target_path; $newurl=$public_r['newsurl'].$target_path; $newname=$newpath.$newfilename; if(empty($target_filename)&&file_exists($newname.$filetype)) { return $newurl.$newfilename.$filetype; } if(!defined('InEmpireCMSGd')) { include_once ECMS_PATH.'e/class/gd.php'; } $filer=ResizeImage($filename,$newname,$width,$height,$docut); $fileurl=$newurl.$newfilename.$filer['filetype']; return $fileurl; } ?>