t_functions.php

一、超强系统模型扩展功能 EmpireCMS卓越之处在于：不仅提供了网站管理功能

	{
		$query="(".$where.") and checked=1";
		$order="newstime";
		$tbname=$class_zr[$classid][tbname];
    }
	//专题点击排行
	elseif($enews==7)
	{
		$query="(".$where.") and checked=1";
		$order="onclick";
		$tbname=$class_zr[$classid][tbname];
    }
	//专题推荐
	elseif($enews==8)
	{
		$query="(".$where.") and checked=1 and isgood=1";
		$order="newstime";
		$tbname=$class_zr[$classid][tbname];
    }
	//专题评论排行
	elseif($enews==11)
	{
		$query="(".$where.") and checked=1";
		$order="plnum";
		$tbname=$class_zr[$classid][tbname];
    }
	//专题头条
	elseif($enews==14)
	{
		$query="(".$where.") and checked=1 and firsttitle=1";
		$order="newstime";
		$tbname=$class_zr[$classid][tbname];
    }
	//专题下载排行
	elseif($enews==17)
	{
		$query="(".$where.") and checked=1";
		$order="totaldown";
		$tbname=$class_zr[$classid][tbname];
    }
	//专题评分
	elseif($enews==29)
	{
		$query="(".$where.") and checked=1";
		$order="infopfennum";
		$tbname=$class_zr[$classid][tbname];
    }
	//专题投票
	elseif($enews==30)
	{
		$query="(".$where.") and checked=1";
		$order="votenum";
		$tbname=$class_zr[$classid][tbname];
    }
	//各表最新
	elseif($enews==18)
	{
		$query="checked=1";
		$order="newstime";
		$tbname=$classid;
	}
	//各表热门
	elseif($enews==19)
	{
		$query="checked=1";
		$order="onclick";
		$tbname=$classid;
	}
	//各表推荐
	elseif($enews==20)
	{
		$query="isgood=1 and checked=1";
		$order="newstime";
		$tbname=$classid;
	}
	//各表评论排行
	elseif($enews==21)
	{
		$query="checked=1";
		$order="plnum";
		$tbname=$classid;
	}
	//各表头条信息
	elseif($enews==22)
	{
		$query="firsttitle=1 and checked=1";
		$order="newstime";
		$tbname=$classid;
	}
	//各表下载排行
	elseif($enews==23)
	{
		$query="checked=1";
		$order="totaldown";
		$tbname=$classid;
	}
	//各表评分排行
	elseif($enews==31)
	{
		$query="checked=1";
		$order="infopfennum";
		$tbname=$classid;
	}
	//各表投票排行
	elseif($enews==32)
	{
		$query="checked=1";
		$order="votenum";
		$tbname=$classid;
	}
	else
	{}
	//不调用
	if(!strstr($public_r['nottobq'],','.$classid.','))
	{
		$query.=ReturnNottoBqWhere();
	}
	//图片信息
	if($do)
	{
		$query.=" and titlepic<>''";
    }
	//中止
	if(empty($tbname))
	{
		echo $fun_r['BqErrorCid']."=<b>".$classid."</b>".$fun_r['BqErrorNtb']."(".$fun_r['BqErrorDo']."=".$enews.")";
		return false;
	}
	//当前时间
	//$todaytime=date("Y-m-d H:i:s");
	$query="select * from {$dbtbpre}ecms_".$tbname." where ".$query." order by istop desc,".$order." desc,id desc limit $line";
	$sql=$empire->query1($query);
	if(!$sql)
	{
		echo"SQL Error: ".$query;
	}
	return $sql;
}

//返回标签模板
function sys_ReturnBqTemp($tempid){
	global $empire,$dbtbpre,$fun_r;
	$r=$empire->fetch1("select tempid,modid,temptext,showdate,listvar,subnews,rownum 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,25,26,";
	$thezdo=",6,7,8,11,14,17,29,30,";
	//栏目
	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){
	global $empire;
	$sql=sys_ReturnBqQuery($classid,$line,$enews,$doing);
	if(!$sql)
	{return "";}
	//取得模板
	$tr=sys_ReturnBqTemp($tempid);
	if(empty($tr['tempid']))
	{return "";}
	$listtemp=$tr[temptext];
	$subnews=$tr[subnews];
	$listvar=$tr[listvar];
	$rownum=$tr[rownum];
	$formatdate=$tr[showdate];
	//替换变量
	$listtemp=ReplaceEcmsinfoClassname($listtemp,$enews,$classid);
	if(empty($rownum))
	{$rownum=1;}
	//字段
	$ret_r=ReturnAddF($r,$tr[modid],$userid,$username,2,2,0);
	//列表
	$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];
		$r[title]=sub($r[title],0,$strlen,false);
		//替换列表变量
		$repvar=ReplaceListVars($no,$listvar,$subnews,0,$formatdate,$url,$have_class,$r,$ret_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 sys_OtherLinkQuery($classid,$line,$enews,$doing){
	global $empire,$class_r,$class_zr,$navinfor,$dbtbpre;
	if($enews==1)//按表
	{
		$tbname=$classid;
	}
	elseif($enews==2)//按栏目
	{
		$tbname=$class_r[$classid]['tbname'];
		if($classid=='selfinfo')//当前栏目
		{
			$classid=$navinfor['classid'];
		}
		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))
	{
		$keyr=explode(',',$navinfor['keyboard']);
		$count=count($keyr);
		for($i=0;$i<$count;$i++)
		{
			if($i==0)
			{
				$or='';
			}
			else
			{
				$or=' or ';
			}
			$keys.=$or."keyboard like '%".$keyr[$i]."%'";
		}
		$keys='('.$keys.')';
	}
	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)?"titlepic<>''":" and titlepic<>''";
    }
	if($and)
	{
		$and.=' and ';
	}
	if(empty($line))
	{
		$line=$class_r[$navinfor[classid]]['link_num'];
	}
	$query="select * from {$dbtbpre}ecms_".$tbname." where ".$and.$keys." order by newstime desc limit $line";
	$sql=$empire->query1($query);
	if(!$sql)
	{
		echo"SQL Error: ".$query;
	}
	return $sql;
}

//相关链接标签
function sys_GetOtherLinkInfo($tempid,$classid='',$line=0,$strlen=60,$have_class=0,$enews=0,$doing=0){
	global $empire,$navinfor;
	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=$tr[temptext];
	$subnews=$tr[subnews];
	$listvar=$tr[listvar];
	$rownum=$tr[rownum];
	$formatdate=$tr[showdate];
	//替换变量
	$listtemp=ReplaceEcmsinfoClassname($listtemp,$enews,$classid);
	if(empty($rownum))
	{$rownum=1;}
	//字段
	$ret_r=ReturnAddF($r,$tr[modid],$userid,$username,2,2,0);
	//列表
	$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];
		$r[title]=sub($r[title],0,$strlen,false);
		//替换列表变量
		$repvar=ReplaceListVars($no,$listvar,$subnews,0,$formatdate,$url,$have_class,$r,$ret_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 sys_GetClassNews($classid,$line,$strlen,$showdate=true,$enews=0,$have_class=0,$formatdate='(m-d)'){
	global $empire;
	$sql=sys_ReturnBqQuery($classid,$line,$enews,0);
	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=format_datetime($r[newstime],$formatdate);
            $newstime="&nbsp;".$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){
	global $empire;
	$sql=sys_ReturnBqQuery($classid,$num,$enews,1);
	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){
	global $empire;
	$sql=sys_ReturnBqQuery($classid,$line,$enews,0);
	if(!$sql)
	{return "";}
	while($r=$empire->fetch($sql))
	{