<?php

/**
*为了获取模板的标签,定义数组值,如果是旧标签的话.在后来会被数值替换.新标签的话继续是数组,也会进一步被处理
**/
function label_array($key){
	global $label,$all_label;
	$key=str_replace(array('"',"'"),array('',''),$key);
	$label[$key]=array();
	$all_label[]=$key;
}

//头与尾用
function label_array_hf($key){
	global $label_hf,$all_label;
	$label_hf[$key]=array();
	$all_label[]=$key;
}

/**
*添加层,后台更新内容要用到
**/
function add_div($value,$tag,$type='code',$div_w='',$div_h='',$div_bgcolor='',$if_hf=''){
	global $webdb,$chtype,$ch;
	if($value){
		$div_w>50 || $div_w=50;
		$div_h>21 || $div_h=21;
		$div_bgcolor || $div_bgcolor='#A6A6FF';
		$type=="flash" && $br="<br>";	//防止被FLASH档住,看不到层
		
		$value_a="<div id=\"$tag\" style=\"text-align:left;width:{$div_w}px;height:{$div_h}px;position:absolute;z-index:2;border:#ff0000 solid 1.5px;background-color: $div_bgcolor;filter:Alpha(Opacity=50);\" onmouseover=\"showlabel_(this,'over','$type','$if_hf');\" onmouseout=\"showlabel_(this,'out','$type','$if_hf');\" onclick=\"showlabel_(this,'click','$type','$if_hf');\"><div style='position:absolute;z-index:6;' onclick='return false;'  onmouseover=\"ckjump_(0);\" onmouseout=\"ckjump_(1);\"><img src=\"$webdb[www_url]/images/default/position2.gif\"  style='width:21px;height:21px;' border=\"0\" usemap=\"#Map$tag\"  /><map name=\"Map$tag\"><area shape=\"rect\" coords=\"7,0,14,7\" href=\"javascript:\"  onMouseDown=\"change_po_('up',1,'$tag');\"  onMouseUp=\"change_po_('up',0,'$tag');\"  alt=\"向上\" /><area shape=\"rect\" coords=\"7,14,14,21\" href=\"javascript:\"  onMouseDown=\"change_po_('down',1,'$tag');\" onMouseUp=\"change_po_('down',0,'$tag');\"  alt=\"向下\" /><area shape=\"rect\" coords=\"0,7,7,14\" href=\"javascript:\"  onMouseDown=\"change_po_('left',1,'$tag');\"  onMouseUp=\"change_po_('left',0,'$tag');\"   alt=\"向左\" /><area shape=\"rect\" coords=\"14,7,21,14\" href=\"javascript:\" onMouseDown=\"change_po_('right',1,'$tag');\" onMouseUp=\"change_po_('right',0,'$tag');\"  alt=\"向右\" /></map></div></div>$br<table border='0' cellspacing='0' cellpadding='0' class='label_$tag'>  <tr>    <td>$value</td> </tr></table>";

		$value_b="<div  class=\"p8label\" id=\"$tag\" style=\"filter:alpha(opacity=50);position: absolute; border: 1px solid #ff0000; z-index: 9999; color: rgb(0, 0, 0); text-align: left; opacity: 0.4; width: {$div_w}px; height:{$div_h}px; background-color:$div_bgcolor;\" onmouseover=\"showlabel_(this,'over','$type','$if_hf');\" onmouseout=\"showlabel_(this,'out','$type','$if_hf');\" onclick=\"showlabel_(this,'click','$type','$if_hf');\"><div onmouseover=\"ckjump_(0);\" onmouseout=\"ckjump_(1);\" style=\"position: absolute; width: 15px; height: 15px; background: url($webdb[www_url]/images/default/se-resize.png) no-repeat scroll -8px -8px transparent; right: 0px; bottom: 0px; clear: both; cursor: se-resize; font-size: 1px; line-height: 0%;\"></div></div>$br<table border='0' cellspacing='0' cellpadding='0' class='label_$tag'>  <tr>   <td>$value</td>  </tr></table>";

		//$value外面套一个table,目的是为了处理兼容性问题,有时标签过多,有个别标签无法显示
		if(is_file(ROOT_PATH."images/default/label_jq.js")){
			return $value_b;
		}else{	//兼容旧的
			return "$value_a";
		}		
	}
}


function rollpic_2js($rolldb){
	global $webdb;
	@extract($rolldb);
	$width || $width=200;
	$height || $height=200;
	$num=count($picurl);
	for($i=0;$i<=$num;$i++){
		if(!$picurl[$i]){
			continue;
		}
		$picurl[$i]=tempdir($picurl[$i]);
		//$picurl[$i]=AddSlashes($picurl[$i]);
		//$piclink[$i]=urlencode(AddSlashes($piclink[$i]));
		//$picalt[$i]=AddSlashes($picalt[$i]);
		$j=$i-1;//后台那里是从1开始的.所以这时要处理
		$show.="<LI style=\"WIDTH: {$width}px; HEIGHT: {$height}px\"><A href=\"{$piclink[$i]}\" target=\"_blank\"><IMG  src=\"{$picurl[$i]}\" style=\"WIDTH: {$width}px; HEIGHT: {$height}px;\"></A><SPAN class=\"title\">{$picalt[$i]}</SPAN></LI>";
	}
	$show="<SCRIPT src=\"$webdb[www_url]/images/default/rollpic.js\" type=\"text/javascript\"></SCRIPT>
<link rel=\"stylesheet\" type=\"text/css\" href=\"$webdb[www_url]/images/default/rollpic.css\">
<DIV class=\"p8rollpic\"><UL class=\"slideshow\">$show</UL></DIV>
<SCRIPT type=\"text/javascript\">runslideshow();</SCRIPT>";
	return $show;
}


/*滚动特效的图片--js方式*/
function rollPic_JS($rolldb){
	global $webdb;
	@extract($rolldb);
	$width || $width=200;
	$height || $height=150;
	$num=count($picurl);
	$rand=rands(5);
	$string='';
	for($i=0;$i<=$num;$i++){
		if(!$picurl[$i]){
			continue;
		}
		$img=tempdir($picurl[$i]);
		$url=$piclink[$i];
		$title=$picalt[$i];
		$string.="<P><A title='$title' href='$url' target=_blank><IMG style='HEIGHT:{$height}px;' alt='$title' src='$img'></A><A title='$title' href='$url' target='_blank'>$title</A></P>";
	}
	//自定义幻灯片接口
	if($RollStyleType&&is_file(ROOT_PATH."template/default/rollpic/$RollStyleType") ){
		foreach($picurl AS $key=>$value){
			$picurl[$key]=addslashes($picurl[$key]);
			$picalt[$key]=addslashes($picalt[$key]);
			$piclink[$key]=urlencode($piclink[$key]);
		}
		$title=implode("|",$picalt);
		$img=implode("|",$picurl);
		$url=implode("|",$piclink);
		include(ROOT_PATH."template/default/rollpic/$RollStyleType");
		return $show;
	}
	$height=$height+30;	
	$rolltype || $rolltype='scrollLeft';
	$rolltime>0 || $rolltime=3;
	$show="<link rel='stylesheet' type='text/css' href='$webdb[www_url]/images/default/rollpic.css'>
<script type='text/javascript' src='$webdb[www_url]/images/default/jquery-1.2.6.min.js'></script>
<SCRIPT type='text/javascript'>
$(function() {
$('#rollpicobj$rand') 
.after('<div id=pager$rand class=pager>') 
.cycle({ 
fx:     '$rolltype', 
speed:   500, 
timeout: {$rolltime}000, 
pause:   1, 
pager:  '#pager$rand' 
});
});
</SCRIPT>
<DIV class='rollpicTB' style='width:{$width}px;FLOAT: left;TEXT-ALIGN: center;'><DIV id='rollpicobj$rand' class='rollpicobj' style='HEIGHT:{$height}px;'>$string</DIV></div>";
	return $show;
}

//JS幻灯片,没有标题的
function rollPic_no_title_js($rolldb){
	global $webdb;
	@extract($rolldb);
	$width || $width=200;
	$height || $height=200;
	$jsnum=$num=count($picurl);
	for($i=1;$i<=$num;$i++){
		if(!$picurl[$i]){
			$jsnum--;
			continue;
		}
		$picurl[$i]=tempdir($picurl[$i]);
		$picurl[$i]=AddSlashes($picurl[$i]);
		$piclink[$i]=(AddSlashes($piclink[$i]));
		$picalt[$i]=AddSlashes($picalt[$i]);
		$show.="
				img{$i}=new Image ();img{$i}.src='$picurl[$i]';
				url{$i}=new Image ();url{$i}.src='$piclink[$i]';
				";
	}
	$show="

<script type='text/javascript'>
var widths=$width;
var heights=$height;
var counts=$jsnum;
$show
var nn=1;
var key=0;
function change_img()
{if(key==0){key=1;}
else if(document.all)
{document.getElementById(\"pic\").filters[0].Apply();document.getElementById(\"pic\").filters[0].Play(duration=2);}
eval('document.getElementById(\"pic\").src=img'+nn+'.src');
eval('document.getElementById(\"url\").href=url'+nn+'.src');
eval('document.getElementById(\"url\").target=\"blank\"');
for (var i=1;i<=counts;i++){document.getElementById(\"xxjdjj\"+i).className='axx';}
document.getElementById(\"xxjdjj\"+nn).className='bxx';
nn++;if(nn>counts){nn=1;}
tt=setTimeout('change_img()',4000);}
function changeimg(n){nn=n;window.clearInterval(tt);change_img();}
document.write('<style>');
document.write('.axx{padding:1px 7px;border-left:#cccccc 1px solid;}');
document.write('a.axx:link,a.axx:visited{text-decoration:none;color:#fff;line-height:12px;font:9px sans-serif;background-color:#666;}');
document.write('a.axx:active,a.axx:hover{text-decoration:none;color:#fff;line-height:12px;font:9px sans-serif;background-color:#999;}');
document.write('.bxx{padding:1px 7px;border-left:#cccccc 1px solid;}');
document.write('a.bxx:link,a.bxx:visited{text-decoration:none;color:#fff;line-height:12px;font:9px sans-serif;background-color:#D34600;}');
document.write('a.bxx:active,a.bxx:hover{text-decoration:none;color:#fff;line-height:12px;font:9px sans-serif;background-color:#D34600;}');
document.write('</style>');
document.write('<div style=\"width:'+widths+'px;height:'+heights+'px;overflow:hidden;text-overflow:clip;\">');
document.write('<div><a id=\"url\"><img id=\"pic\" style=\"border:0px;filter:progid:dximagetransform.microsoft.wipe(gradientsize=1.0,wipestyle=4, motion=forward)\" width='+widths+' height='+heights+' /></a></div>');
document.write('<div style=\"filter:alpha(style=1,opacity=10,finishOpacity=80);background: #888888;width:100%-2px;text-align:right;top:-12px;position:relative;margin:1px;height:12px;padding:0px;margin:0px;border:0px;\">');
for(var i=1;i<counts+1;i++){document.write('<a href=\"javascript:changeimg('+i+');\" id=\"xxjdjj'+i+'\" class=\"axx\" target=\"_self\">'+i+'</a>');}
document.write('</div></div>');
change_img();
</script>
	
	";

	return $show;
}


/*滚动特效的图片--FLASH方式*/
function rollPic_flash($rolldb){
	global $webdb;
	@extract($rolldb);
	$width || $width=200;
	$height || $height=200;
	$num=count($picurl);
	for($i=0;$i<=$num;$i++){
		if(!$picurl[$i]){
			continue;
		}
		$picurl[$i]=tempdir($picurl[$i]);
		$picurl[$i]=AddSlashes($picurl[$i]);
		$piclink[$i]=urlencode(AddSlashes($piclink[$i]));
		$picalt[$i]=AddSlashes($picalt[$i]);
		$j=$i-1;//后台那里是从1开始的.所以这时要处理
		$show.="
				imgUrl[{$j}]='{$picurl[$i]}';
				imgLink[{$j}]='{$piclink[$i]}';
				imgtext[{$j}]='{$picalt[$i]}';
				";
	}
	$show="

<script type='text/javascript'>
var imgUrl = new Array();
var imgtext = new Array();
var imgLink = new Array();

$show

var pics=imgUrl[0];
var links=imgLink[0];
var texts=imgtext[0];
for(var i=1;i<imgUrl.length;i++){
	pics+='|'+imgUrl[i];
	links+='|'+imgLink[i];
	texts+='|'+imgtext[i];
}

var focus_width=$width
var focus_height=$height
if(window.ActiveXObject){
	var text_height=22;
}else{
	var text_height=40;
	focus_height=focus_height+40;
}
var swf_height = focus_height+text_height

document.write('<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\" width=\"'+ focus_width +'\" height=\"'+ swf_height +'\">');
document.write('<param name=\"allowScriptAccess\" value=\"sameDomain\" /><param name=\"movie\" value=\"$webdb[www_url]/images/default/rollpic.swf\" /><param name=\"quality\" value=\"high\" /><param name=\"bgcolor\" value=\"#F0F0F0\">');
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+'\">');
document.write('<embed src=\"$webdb[www_url]/images/default/rollpic.swf\" wmode=\"opaque\" FlashVars=\"pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'\" menu=\"false\" bgcolor=\"#F0F0F0\" quality=\"high\" width=\"'+ focus_width +'\" height=\"'+ focus_height +'\" allowScriptAccess=\"sameDomain\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" />');
document.write('</object>');

</script>
	
	";

	return $show;
}

/**
*获取标题列表,包括图片及内容
**/
function Get_Title($format){
	global $db,$webdb,$pre,$ModuleDB;
	
	//方便下面得到URL的真实列表地址
	$page=1;
	
	if(strstr($format[sql],'$GLOBALS[')){
		eval("\$format[sql]=\"$format[sql]\";");
	}
	if(strstr($format[sql2],'$GLOBALS[')){
		eval("\$format[sql2]=\"$format[sql2]\";");
	}
	//此处屏障报错,主要是处理不同版本之间存在的一些差异性问题
	$query=$db->query("$format[sql]",'','0');
	if(!$query){
		return ;
	}
	//辅助模板存在,并且辅助SQL存在的话,要读数据库
	if($format[tplpart_2code]&&$format[sql2]){
		$query2=$db->query($format[sql2],'','0');
		$rs2=$db->fetch_array($query2);
		$rs2=label_set_rs($format,$rs2);
	}
	while($rs=$db->fetch_array($query)){
		
		//有辅助模板时,要特别处理,CK代表截取了一条数据
		if($format[tplpart_2code]){
			if($format[sql2]){			//如果有SQL语句的话,要过滤雷同的记录
				if($rs2[id]==$rs[id]){
					$ck++;
					continue;
				}				
			}elseif(!$ck){				//没SQL语句,并且辅助模板有变量时,要截取一条记录,$content一般不会单独出现
				if(strstr($format[tplpart_2code],'$title')||strstr($format[tplpart_2code],'$picurl')){
					$rs2=label_set_rs($format,$rs);
					$ck++;
					continue;
				}
			}
		}
		$listdb[]=label_set_rs($format,$rs);
	}

	//有辅助模板时,没有截取到数据时,要过滤最后一条记录
	if($format[tplpart_2code]&&!$ck){
		array_pop($listdb);
		//针对那种没有变量的辅助模板
		if(!$format[sql2]){
			$rs2=label_set_rs($format,'');
		}
	}

	//幻灯片,=='rollpic'旧版,=='r'即V6
	if($format[stype]=='rollpic'||$format[stype]=='r')
	{
		foreach( $listdb AS $key=>$rs){
			$iii++;
			$picurl[$iii]=$rs[picurl];
			unset($rs[picurl]);
			$picalt[$iii]=$rs[title];
			@extract($rs);			
			eval("\$showurl=\"$showurl\";");
			$piclink[$iii]=$showurl;
		}
		$format[picurl]=$picurl;
		$format[picalt]=$picalt;
		$format[piclink]=$piclink;
		return rollPic_JS($format);
	}

	//处理多列的问题
	$listdb=array_chunk($listdb,$format[colspan]);
	$width=floor((1/$format[colspan])*100);
	foreach($listdb AS $key1=>$array1){
		$show.="<tr>";
		//有辅助模板时,第一个外循环,要特别处理一下,即内循环加多一个
		if($format[tplpart_2code]&&$key1==0){
			$array1[-1]=$rs2;
			ksort($array1);
		}

		foreach($array1 AS $key2=>$rs){
			$jjj++;
			@extract($rs);			
			//if($format[tplpath]=='/common_zh_title/zh_bigtitle.jpg'){	die("fd$tpl_2code");}
			//有辅助模板时,第一个外循环,第一个内循环时,特别处理辅助模板
			if($tpl_2code&&$key1==0&&$jjj==1){
				$format[titlenum2] && $title=get_word($full_title,$format[titlenum2]);
				$format[content_num2] && $content=get_word($full_content,$format[content_num2]);
				$htmlcode=addslashes($tpl_2code);
				eval("\$htmlcode=\"$htmlcode\";");
				$htmlcode=$htmlcodeTOP=StripSlashes($htmlcode);
			}else{
				$i++;	//方便模板用序号

				//自定义模型当中,获取这三个select,radio,checkbox表单中类似“1|中国”真实值
				if($format[SYS]=='form'){
					$m_array=unserialize($M_config);
					foreach( $m_array[listshow_db] AS $key3=>$rs3){
						$$key3=SRC_true_value($m_array[field_db][$key3],$$key3);
					}
				}

				$htmlcode=addslashes($tpl_1code);
				eval("\$htmlcode=\"$htmlcode\";");
				$htmlcode=StripSlashes($htmlcode);
				$show.="<td width=$width%>$htmlcode</td>";
			}
			$DivTpl.=$htmlcode;
		}
		$show.="</tr>";
	}
	if($format[DivTpl]){
		//DIV布局
		return $DivTpl;
	}else{
		//table布局
		return "$htmlcodeTOP<table width='100%' border='0' cellspacing='0' cellpadding='0'>$show</table>";
	}
}

//系统专题
function Get_sp($format){
	global $db,$pre,$webdb,$TB_pre,$TB_url,$timestamp;
	//方便下面得到URL的真实列表地址
	$page=1;
	$rsdb=$db->get_one("SELECT * FROM {$pre}special WHERE id='$format[spid]'");

	//纠正存在可能错误的字符串.比如',1,2'这种情形
	$array_a=explode(",",$rsdb[aids]);
	foreach( $array_a AS $key=>$value){
		if(!$value){
			unset($array_a[$key]);
		}
	}
	$rsdb[aids]=implode(",",$array_a);
	unset($array_a);
	$array_a=explode(",",$rsdb[tids]);
	foreach( $array_a AS $key=>$value){
		if(!$value){
			unset($array_a[$key]);
		}
	}
	$rsdb[tids]=implode(",",$array_a);
	
	$Rows=$format[rowspan]*$format[colspan];
	
	//有辅助模板时,要加多一条
	if($format[tplpart_2code]){
		$Rows++;
	}

	if($rsdb[aids])
	{
		//获取文章数据
		$detail=get_sp_article($format,$rsdb,$Rows);
		$detail[0] && $listdb=$detail[0];
		$rs2=$detail[1];
	}
	

	//如果文章中获取的记录不够,则继续从论坛中获取
	if($rsdb[tids]){
		if($format[tplpart_2code]){
			if(count($listdb)<($Rows-1)){
				$getbbs=1;
			}
		}else{
			if(count($listdb)<$Rows){
				$getbbs=1;
			}
		}
	}
	
	if($getbbs)
	{
		$Rows2=$Rows-count($listdb);
		if(ereg("^pwbbs",$webdb[passport_type]))
		{
			$detail=get_sp_pwbbs($format,$rsdb,$Rows2,$rs2);
			$_listdb=$detail[0];
			$rs3=$detail[1];
		}
		elseif(ereg("^dzbbs",$webdb[passport_type]))
		{
			$detail=get_sp_dzbbs($format,$rsdb,$Rows2,$rs2);
			$_listdb=$detail[0];
			$rs3=$detail[1];
		}
		if($format[order]=='default'){
			$tidsdb=explode(",",$rsdb[tids]);
			foreach($tidsdb AS $key=>$value){
				if($_listdb[$value]){
					$listdb[]=$_listdb[$value];
				}
			}
		}else{
			//数组会自动类加
			foreach($_listdb AS $key=>$value){
				$listdb[]=$value;
			}
		}
		//针对辅助模板
		if($format[tplpart_2code]){
			//针对如果记录没有足够指定的条数,则不必去掉一条记录,否则就要去掉最后一条
			if(count($listdb)>($Rows-1)){
				array_pop($listdb);
			}
			//如果文章系统里不存在,则获取论坛的
			if($rs3){
				$rs2=$rs3;
			}
		}
	}

	$listdb||$listdb=array();
	//幻灯片
	if($format[stype]=='rollpic'||$format[stype]=='r')
	{
		foreach( $listdb AS $key=>$rs){
			$iii++;
			$picurl[$iii]=$rs[picurl];
			unset($rs[picurl]);
			$picalt[$iii]=$rs[title];
			@extract($rs);
			eval("\$showurl=\"$rs[showurl]\";");
			$piclink[$iii]=$showurl;
		}
		$format[picurl]=$picurl;
		$format[picalt]=$picalt;
		$format[piclink]=$piclink;
		return rollPic_JS($format);
	}

	$listdb=array_chunk($listdb,$format[colspan]);
	$width=floor((1/$format[colspan])*100);
	foreach($listdb AS $key1=>$array1){
		$show.="<tr>";

		//有辅助模板时,第一个外循环,要特别处理一下,即内循环加多一个
		if($format[tplpart_2code]&&$key1==0){
			$array1[-1]=$rs2;
			ksort($array1);
		}

		foreach($array1 AS $key2=>$rs){
			$jjj++;
			@extract($rs);
			//有辅助模板时,第一个外循环,第一个内循环时,特别处理辅助模板
			if($tpl_2code&&$key1==0&&$jjj==1){
				$format[titlenum2] && $title=get_word($full_title,$format[titlenum2]);
				$format[content_num2] && $content=get_word($full_content,$format[content_num2]);
				$htmlcode=addslashes($tpl_2code);
				eval("\$htmlcode=\"$htmlcode\";");
				$htmlcode=$htmlcodeTOP=StripSlashes($htmlcode);
			}else{
				$i++;	//方便模板用序号
				//$htmlcode=addslashes($format[tplpart_1code]);
				$htmlcode=addslashes($rs[tpl_1code]);
				eval("\$htmlcode=\"$htmlcode\";");
				$htmlcode=StripSlashes($htmlcode);
			}
			$show.="<td width=$width%>$htmlcode</td>";
			$DivTpl.=$htmlcode;
		}
		$show.="</tr>";
	} 
	if($format[DivTpl]){
		//DIV布局
		return $DivTpl;
	}else{
		//table布局
		return "$htmlcodeTOP<table width='100%' border='0' cellspacing='0' cellpadding='0'>$show</table>";
	}
}

/**
*把$url,$listurl这两个通用网址做处理,以便获取其真实的网址
**/
function make_ture_path($format,$rs){
	global $ModuleDB,$webdb,$Html_Type,$showHtml_Type,$city_DB;
	
	if($format[SYS]=='fenlei'){
		$keyname=$format[wninfo];
		if($ModuleDB[$keyname][domain]){
			$list_url=$show_url=$ModuleDB[$keyname][domain]."/";
		}else{
			$list_url=$show_url="$webdb[www_url]/{$ModuleDB[$keyname][dirname]}/";
		}
		if( $ModuleDB[$keyname][id]==$webdb['module_id']&&function_exists('get_info_url') ){
			$list_url=get_info_url('',$rs[fid],$rs[city_id]);
			$show_url=get_info_url($rs[id],$rs[fid],$rs[city_id]);
		}else{
			$list_url.='list.php?city_id=$city_id&fid=$fid';
			$show_url.='bencandy.php?city_id=$city_id&fid=$fid&id=$id';
		}
		$tpl_1code=str_replace(array('{$url}','$url','{$list_url}','$list_url'),array($show_url,$show_url,$list_url,$list_url),$format[tplpart_1code]);

		$tpl_2code=str_replace(array('{$url}','$url','{$list_url}','$list_url'),array($show_url,$show_url,$list_url,$list_url),$format[tplpart_2code]);

		$array[tpl_1code]=$tpl_1code;
		$array[tpl_2code]=$tpl_2code;
	}

	//wn指万能模块,normal指5.0版中的图库.视频,下载,FLASH等频道的列表与内容页网址
	elseif($format[SYS]=='normal'||$format[SYS]=='wn'){
		$keyname=$format[SYS]=='normal'?$format[SYS_type]:$format[wninfo];
		if($city_DB[domain][$rs[city_id]]){		//城市二级域名
			$list_url=$show_url=$city_DB[domain][$rs[city_id]]."/{$ModuleDB[$keyname][dirname]}/";
		}elseif($ModuleDB[$keyname][domain]){	//频道二级域名
			$list_url=$show_url=$ModuleDB[$keyname][domain]."/";
		}else{									//频道二级目录
			$list_url=$show_url="$webdb[www_url]/{$ModuleDB[$keyname][dirname]}/";
		}
		$CF=unserialize($ModuleDB[$keyname][config]);
		if($CF[MakeHtml]==2){
			$list_url.=$CF[list_HtmlName2];
			$show_url.=$CF[show_HtmlName2];
		}elseif($CF[MakeHtml]==1){
			$list_url.=$CF[list_HtmlName][$rs[fid]]?$CF[list_HtmlName][$rs[fid]]:$CF[list_HtmlName1];
			$show_url.=$CF[show_HtmlName][$rs[fid]]?$CF[show_HtmlName][$rs[fid]]:$CF[show_HtmlName1];
			$list_url=preg_replace("/(.*)\/([^\/]+)/is","\\1/",$list_url);
		}else{
			$list_url.=$CF[list_PhpName];
			$show_url.=$CF[show_PhpName];
		}

		$tpl_1code=str_replace('{$url}',$show_url,$format[tplpart_1code]);
		$tpl_1code=str_replace('$url',$show_url,$tpl_1code);
		$tpl_1code=str_replace('{$list_url}',$list_url,$tpl_1code);
		$tpl_1code=str_replace('$list_url',$list_url,$tpl_1code);

		$tpl_2code=str_replace('{$url}',$show_url,$format[tplpart_2code]);
		$tpl_2code=str_replace('$url',$show_url,$tpl_2code);
		$tpl_2code=str_replace('{$list_url}',$list_url,$tpl_2code);
		$tpl_2code=str_replace('$list_url',$list_url,$tpl_2code);

		$array[tpl_1code]=$tpl_1code;
		$array[tpl_2code]=$tpl_2code;
	}

	//整站系统的文章列表与内容网址
	elseif($format[SYS]=='artcile'){
		$list_url=$show_url="$webdb[www_url]$webdb[path]/";
		if($webdb[NewsMakeHtml]==2){
			$list_url.=$webdb[list_filename2];
			$show_url.=$webdb[bencandy_filename2];
		}elseif($webdb[NewsMakeHtml]==1){
			$list_url=$show_url="$webdb[www_url]/";
			//以栏目自定义的文件名优先
			$filename_l=$Html_Type['list'][$rs[fid]]?$Html_Type['list'][$rs[fid]]:$webdb[list_filename];
			//以自定义的内容页文件名优先
			if($showHtml_Type[bencandy][$id]){
				$filename_b=$showHtml_Type[bencandy][$id];
			}elseif($Html_Type[bencandy][$rs[fid]]){
				$filename_b=$Html_Type[bencandy][$rs[fid]];
			}else{
				$filename_b=$webdb[bencandy_filename];
			}
			//自定义了栏目域名
			if($Html_Type[domain][$rs[fid]]&&$Html_Type[domain_dir][$rs[fid]]){
				$rule=str_replace("/","\/",$Html_Type[domain_dir][$rs[fid]]);
				$show_url=preg_replace("/^$rule/is","{$Html_Type[domain][$rs[fid]]}/",$filename_b);
				$list_url=preg_replace("/^$rule/is","{$Html_Type[domain][$rs[fid]]}/",$filename_l);
				//特别处理一下些自定义内容页文件名的情况.
				if(!eregi("^http:\/\/",$show_url)){
					$show_url="$webdb[www_url]/$filename_b";
				}
			}else{
				$list_url.=$filename_l;
				$show_url.=$filename_b;
			}			
			//把文件名去掉,访问默认/文档
			$list_url=preg_replace("/(.*)\/([^\/]+)/is","\\1/",$list_url);


			//对于内容页的首页把$page去除掉
			$show_url=preg_replace("/(.*)(-{\\\$page}|_{\\\$page})(.*)/is","\\1\\3",$show_url);
			//对于内容页的栏目小于1000篇文章时,把DIR分目录去除掉
			if(floor($rs[aid]/1000)==0){
				$show_url=preg_replace("/(.*)(-{\\\$dirid}|_{\\\$dirid})(.*)/is","\\1\\3",$show_url);
			}

		}else{
			$list_url.='list.php?fid={$fid}';
			$show_url.='bencandy.php?fid={$fid}&id={$aid}';
		}
		
		
		$tpl_1code=str_replace('{$url}',$show_url,$format[tplpart_1code]);
		$tpl_1code=str_replace('$url',$show_url,$tpl_1code);
		$tpl_1code=str_replace('{$list_url}',$list_url,$tpl_1code);
		$tpl_1code=str_replace('$list_url',$list_url,$tpl_1code);

		$tpl_2code=str_replace('{$url}',$show_url,$format[tplpart_2code]);
		$tpl_2code=str_replace('$url',$show_url,$tpl_2code);
		$tpl_2code=str_replace('{$list_url}',$list_url,$tpl_2code);
		$tpl_2code=str_replace('$list_url',$list_url,$tpl_2code);
		$array[tpl_1code]=$tpl_1code;
		$array[tpl_2code]=$tpl_2code;
	}

	//phpwind与DISCUZ论坛的贴子与列表网址
	elseif($format[SYS]=='pwbbs'||$format[SYS]=='dzbbs')
	{
		if($format[SYS]=='pwbbs'){
			$show_url='$webdb[passport_url]/read.php?tid=$tid&page=1';
			$list_url='$webdb[passport_url]/thread.php?fid=$fid';
		}else{
			$show_url='$webdb[passport_url]/viewthread.php?tid=$tid&page=1';
			$list_url='$webdb[passport_url]/forumdisplay.php?fid=$fid';
		}

		$tpl_1code=str_replace('{$url}',$show_url,$format[tplpart_1code]);
		$tpl_1code=str_replace('$url',$show_url,$tpl_1code);
		$tpl_1code=str_replace('{$list_url}',$list_url,$tpl_1code);
		$tpl_1code=str_replace('$list_url',$list_url,$tpl_1code);

		$tpl_2code=str_replace('{$url}',$show_url,$format[tplpart_2code]);
		$tpl_2code=str_replace('$url',$show_url,$tpl_2code);
		$tpl_2code=str_replace('{$list_url}',$list_url,$tpl_2code);
		$tpl_2code=str_replace('$list_url',$list_url,$tpl_2code);
		$array[tpl_1code]=$tpl_1code;
		$array[tpl_2code]=$tpl_2code;
	}
	else
	{
		$array[tpl_1code]=$format[tplpart_1code];
		$array[tpl_2code]=$format[tplpart_2code];
	}
	//主要针对幻灯片的内容网址
	$array[showurl]=$show_url;
	return $array;
}

//读出来的每条记录要格式化处理
function label_set_rs($format,$rs){
	global $db,$pre,$timestamp,$webdb,$TB_url;
	
	//分类的话,对于分表的情况,要特别处理,不支持其它频道调用,会出错
	if($format[SYS]=='fenlei'&&!$rs[posttime]){
		global $Fid_db;
		$_erp=$Fid_db[tableid][$rs[fid]];		
		$rs=$db->get_one("SELECT * FROM {$pre}{$format[wninfo]}content$_erp WHERE id='$rs[id]' ");
	}

	//读取自定义字段的表,方便调用,如果声明了noReadMid就不要读了
	if($format[wninfo]&&$rs[mid]&&!$format[noReadMid]){
		$_rss=$db->get_one("SELECT * FROM {$pre}{$format[wninfo]}content_{$rs[mid]} WHERE id='$rs[id]' ");
		$_rss && $rs=$rs+$_rss;
	//文章要读取自定义字段的表,方便调用
	}elseif($format[SYS]=='artcile'&&$rs[mid]){
		$_rss=$db->get_one("SELECT * FROM {$pre}article_content_{$rs[mid]} WHERE aid='$rs[aid]' ");
		$_rss && $rs=$rs+$_rss;
	}

	//扩展接口,少用
	if($format[eval_code]){
		eval($format[eval_code]);
	}

	//附件处理
	if($format[SYS]=='pwbbs'){
		//隐藏或出售贴
		if($ifhide||strstr($rs[content],'[sell=')){
			$rs[content]='******';
		}
		$rs[content]=preg_replace("/\[([^\]]+)\]/is","",$rs[content]);
		global $db_attachname;
		$rs[picurl]='';
		if($rs[attachurl]){
			//兼容旧版与非主题有图片的.
			if(is_file(ROOT_PATH."$webdb[passport_path]/$db_attachname/thumb/$rs[attachurl]")){
				$rs[picurl]="$webdb[passport_url]/$db_attachname/thumb/$rs[attachurl]";
			}else{
				$rs[picurl]="$webdb[passport_url]/$db_attachname/$rs[attachurl]";
			}
		}
		$dfont=explode("~",$rs[titlefont]);
		$rs[titlecolor]=$dfont[0];
	}elseif($format[SYS]=='dzbbs'){
		$rs[content]=preg_replace("/\[([^\]]+)\]/is","",$rs[content]);
		global $_DCACHE;
		$rs[picurl]='';
		$rs[attachment] && $rs[picurl]="$webdb[passport_url]/{$_DCACHE[settings][attachurl]}/$rs[attachment]";
	}

	$rs[full_time]=$rs[posttime];
	$rs[full_title]=$rs[title];
	//内容
	$rs[description] && $rs[content]=$rs[description];
	$rs[content]=preg_replace('/<([^<]*)>/is',"",$rs[content]);	//把HTML代码过滤掉
	$rs[content]=preg_replace('/ |　|&nbsp;/is',"",$rs[content]);	//把多余的空格去除掉
	$rs[full_content]=$rs[content];
	$rs[content]=get_word($rs[content],$format[content_num]);
	//标题样式
	$rs[fontweight]=$rs[fontcolor]='';
	$rs[fonttype]==1 && $rs[fontweight]='font-weight:bold;';
	$rs[titlecolor] && $rs[fontcolor]="color:$rs[titlecolor];";
	//标题
	$rs[smalltitle] && $rs[title] = $rs[smalltitle];	//如果有简短标题的话,就使用简短标题
	$rs[title]=preg_replace('/<([^<]*)>/is',"",$rs[title]);
	$rs[title]=get_word($rs[title],$format[titlenum],$format[titleflood]);
	if(!$format[timeformat]){
		$format[timeformat]="Y/m/d";
	}
	$rs[posttime]=date($format[timeformat],$rs[posttime]);
	if($rs[picurl]){
		$rs[picurl] = filtrate($rs[picurl]);
		$rs[picurl]=tempdir($rs[picurl]);		//4:3的图
		$rs[picurl2]="$rs[picurl].jpg";			//3:4的图
		$rs[picurl3]="$rs[picurl].jpg.jpg";		//1:1的图
	}else{
		$rs[picurl2]=$rs[picurl3]="";
	}
	
	//最新文章
	if(($timestamp-$rs[full_time])<($format[newhour]*3600)){
		$rs['new']="<img src='$webdb[www_url]/images/default/new.gif' border=0>";
	}else{
		$rs['new']="";
	}
	
	//热门文章
	if( $format[hothits]&&($rs[hits]>$format[hothits]) ){
		$rs[hot]="<img src='$webdb[www_url]/images/default/hot.gif' border=0>";
	}else{
		$rs[hot]="";
	}

	//V6以前的版本需要用到
	if($format[SYS]=='artcile'){
		$rs[id]=$rs[aid];
	}
			
	//主要是针对$url,$listurl这两个地址得到其真实网址
	$detail=make_ture_path($format,$rs);
	$rs[tpl_1code]=$detail[tpl_1code];

	$rs[showurl]=$detail[showurl];		//主要针对幻灯片

	$rs[tpl_2code]=$detail[tpl_2code];	//不一定都存在的

	$rs[dirid]=floor($rs[id]/1000);

	$rs[time_Y]=date("Y",$rs[full_time]);
	$rs[time_W]=date("W",$rs[full_time]);
	$rs[time_y]=date("y",$rs[full_time]);
	$rs[time_m]=date("m",$rs[full_time]);
	$rs[time_d]=date("d",$rs[full_time]);
	$rs[time_H]=date("H",$rs[full_time]);
	$rs[time_i]=date("i",$rs[full_time]);
	$rs[time_s]=date("s",$rs[full_time]);

	return $rs;
}

//专题当中,获取文章的数据
function get_sp_article($format,$rsdb,$Rows){
	global $db,$pre;

	if($format[order]=='list'){
		$order='A.aid';
	}elseif($format[order]=='hits'){
		$order='A.hits';
	}elseif($format[order]=='comments'){
		$order='A.comments';
	}else{
		$order='A.aid';
	}
	if($format[yz]==1){
		$_SQL=" AND A.yz=1 ";
	}
	

	//针对于辅助模板做的处理,因为有指定的ID,所以读多一条数据,效率影响不大
	if(strstr($format[tplpart_2code],'$picurl')){
		$_SQL2PIC=" AND A.ispic=1 ";
	}
	//排序处理,默认排序的话,如果不是读取图片的话,只读取第一个ID即可
	//如果是默认,然而有图片的话.处理起来就比较麻烦
	if(!$_SQL2PIC&&$format[order]=='default'){
		$string2id=preg_replace("/([0-9]+)(.*)/is","\\1",$rsdb[aids]);
		$_SQL2ORDER="";
	}else{
		$string2id=$rsdb[aids];
		//有图片,按专题设定排序时,要全部读出来.方便对图片进行排序处理
		if($_SQL2PIC&&$format[order]=='default'){
			$_SQL2ORDER="";
			$getpic++;
		}else{
			$_SQL2ORDER="ORDER BY $order DESC LIMIT 1";
		}		
	}
	if(strstr($format[tplpart_2code],'$content')){		
		$SQL2="SELECT A.*,A.aid AS id,B.content FROM {$pre}article A LEFT JOIN {$pre}reply B ON A.aid=B.aid WHERE A.aid IN ($string2id) AND B.topic=1 $_SQL $_SQL2PIC $_SQL2ORDER";
	}elseif($format[tplpart_2code]){
		$SQL2="SELECT A.*,A.aid AS id FROM {$pre}article A WHERE A.aid IN ($string2id) $_SQL $_SQL2PIC $_SQL2ORDER";
	}
	if($SQL2){
		//专题内可控排序的话.要全部读出来,才能排序.
		if($getpic){
			$query = $db->query($SQL2);
			while($rss = $db->fetch_array($query)){
				$Ls[$rss[aid]]=$rss;
			}
			$aidsdb=explode(",",$rsdb[aids]);
			foreach($aidsdb AS $key=>$value){
				if($Ls[$value]){
					$rs2=$Ls[$value];
					break;
				}
			}
		}else{
			$rs2=$db->get_one($SQL2);
		}		
		if($rs2){
			$_format=$format;
			$_format[SYS]='artcile';			//伪造,以便获取URL地址
			$rs2=label_set_rs($_format,$rs2);
		}			
	}

	//'rollpic','6'兼容V6以前的版本,r指幻灯片
	if(in_array($format[stype],array('rollpic','6','r','p','cp'))){ 
		$_SQL.=" AND A.ispic=1 ";
	}

	if(strstr($format[tplpart_1code],'$content')){
		$SQL="SELECT A.*,B.content,A.aid AS id FROM {$pre}article A LEFT JOIN {$pre}reply B ON A.aid=B.aid WHERE A.aid IN ($rsdb[aids]) AND B.topic=1 $_SQL ORDER BY $order DESC LIMIT $Rows";
	}else{
		$SQL="SELECT A.*,A.aid AS id FROM {$pre}article A WHERE A.aid IN ($rsdb[aids]) $_SQL ORDER BY $order DESC LIMIT $Rows";
	}
	$query = $db->query($SQL);
	while($rs = $db->fetch_array($query)){

		//针对辅助模板过滤雷同记录
		if($format[tplpart_2code]&&$rs[id]==$rs2[id]){
			$ck++;
			continue;
		}

		//务必注意::下面伪造信息,是为了得到文章的$url,$listurl地址
		$_format=$format;
		$_format[SYS]='artcile';
		$_listdb[$rs[aid]]=label_set_rs($_format,$rs);
	}
	//排序
	if($format[order]=='default'){
		$aidsdb=explode(",",$rsdb[aids]);
		foreach($aidsdb AS $key=>$value){
			if($_listdb[$value]){
				$listdb[]=$_listdb[$value];
			}
		}
	}else{
		foreach($_listdb AS $key=>$value){
			$listdb[]=$value;
		}
	}

	//针对辅助模板如果没有雷同记录,则要过滤最后一条记录.
	if($format[tplpart_2code]&&!$ck){
		//针对如果记录没有足够指定的条数,则不必去掉一条记录,否则就要去掉最后一条
		if(count($listdb)>($Rows-1)){
			array_pop($listdb);
		}
	}
	return array($listdb,$rs2);
}

//专题中获取PW论坛数据
function get_sp_pwbbs($format,$rsdb,$Rows2,$rs2){
	global $db,$pre,$TB_pre;

	if($format[order]=='list'){
		$order='A.tid';
	}elseif($format[order]=='hits'){
		if(ereg("^dzbbs",$webdb[passport_type])){
			$order='A.views';
		}else{
			$order='A.hits';
		}
	}elseif($format[order]=='comments'){
		$order='A.replies';
	}else{
		$order='A.tid';
	}
	$SQL="ORDER BY $order DESC ";
		
	//是否验证,没做处理
	if($format[yz]==1){			
	}

	//针对于辅助模板做的处理
	if($format[tplpart_2code]&&!$rs2){
		$_SQL1=$_SQL2='';
		if(strstr($format[tplpart_2code],'$fname')){
			$_SQL1=" ,F.name AS fname ";
			$_SQL2=" LEFT JOIN {$TB_pre}forums F ON F.fid=A.fid ";
		}
		//非图片,默认排序的话,只读取第一个ID即可.
		if(!strstr($format[tplpart_2code],'$picurl')&&$format[order]=='default'){
			$string2id=preg_replace("/([0-9]+)(.*)/is","\\1",$rsdb[tids]);
		}else{
			$string2id=$rsdb[tids];
		}
		if(strstr($format[tplpart_2code],'$content')&&strstr($format[tplpart_2code],'$picurl')){
			$getpic++;
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime,C.content,Att.attachurl$_SQL1 FROM {$TB_pre}attachs Att LEFT JOIN {$TB_pre}threads A ON Att.tid=A.tid LEFT JOIN {$TB_pre}tmsgs C ON A.tid=C.tid$_SQL2 WHERE A.tid IN ($string2id) AND Att.type='img' GROUP BY A.tid $SQL";
		}elseif(strstr($format[tplpart_2code],'$content')){
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime,C.content$_SQL1 FROM {$TB_pre}threads A LEFT JOIN {$TB_pre}tmsgs C ON A.tid=C.tid$_SQL2 WHERE A.tid IN ($string2id) $SQL LIMIT 1 ";
		}elseif(strstr($format[tplpart_2code],'$picurl')){
			$getpic++;
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime,Att.attachurl$_SQL1 FROM {$TB_pre}attachs Att LEFT JOIN {$TB_pre}threads A ON Att.tid=A.tid$_SQL2 WHERE A.tid IN ($string2id) AND Att.type='img' GROUP BY tid $SQL";
		}else{
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime$_SQL1 FROM {$TB_pre}threads A$_SQL2 WHERE A.tid IN ($string2id) $SQL LIMIT 1 ";
		}
		//专题内可控排序的话.要全部读出来,才能排序.
		if($getpic&&$format[order]=='default'){
			$query = $db->query($SQL2);
			while($rss = $db->fetch_array($query)){
				$Ls[$rss[tid]]=$rss;
			}
			$aidsdb=explode(",",$rsdb[tids]);
			foreach($aidsdb AS $key=>$value){
				if($Ls[$value]){
					$rs3=$Ls[$value];
					break;
				}
			}
		}else{
			$rs3=$db->get_one($SQL2);
		}
		if($rs3){
			$_format=$format;
			$_format[SYS]='pwbbs';	//伪造,以便获取URL地址
			$rs3=label_set_rs($_format,$rs3);
		}
	}

	//主模板如果要获取栏目名称的话.要读多一个表
	$_SQL1=$_SQL2='';
	if(strstr($format[tplpart_1code],'$fname')){
		$_SQL1=" ,F.name AS fname ";
		$_SQL2=" LEFT JOIN {$TB_pre}forums F ON F.fid=A.fid ";
	}
	if(strstr($format[tplpart_1code],'$picurl')&&strstr($format[tplpart_1code],'$content')){
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime,C.content,At.attachurl$_SQL1 FROM {$TB_pre}attachs At LEFT JOIN {$TB_pre}threads A ON At.tid=A.tid LEFT JOIN {$TB_pre}tmsgs C ON A.tid=C.tid$_SQL2 WHERE A.tid IN ($rsdb[tids]) AND At.type='img' GROUP BY At.tid $SQL LIMIT $Rows2 ";
	}elseif(strstr($format[tplpart_1code],'$content')){
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime,C.content$_SQL1 FROM {$TB_pre}threads A LEFT JOIN {$TB_pre}tmsgs C ON A.tid=C.tid$_SQL2 WHERE A.tid IN ($rsdb[tids]) $SQL LIMIT $Rows2 $rows ";
	}elseif($format[stype]=='r'||strstr($format[tplpart_1code],'$picurl')){
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime,At.attachurl$_SQL1 FROM {$TB_pre}attachs At LEFT JOIN {$TB_pre}threads A ON At.tid=A.tid$_SQL2 WHERE A.tid IN ($rsdb[tids]) AND At.type='img' GROUP BY At.tid $SQL LIMIT $Rows2 ";
	}else{
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.postdate AS posttime$_SQL1 FROM {$TB_pre}threads A $_SQL2 WHERE A.tid IN ($rsdb[tids]) $SQL LIMIT $Rows2 ";
	}
	$query = $db->query($SQL);
	while($rs = $db->fetch_array($query)){
		//针对辅助模板过滤雷同记录
		if($format[tplpart_2code]&&$rs[id]==$rs3[id]){
			continue;
		}
		$_format=$format;
		$_format[SYS]='pwbbs';	//伪造,以便获取URL地址
		$_listdb[$rs[tid]]=label_set_rs($_format,$rs);
	}
	
	return array($_listdb,$rs3);
}

//专题中获取DZ论坛数据
function get_sp_dzbbs($format,$rsdb,$Rows2,$rs2){
	global $db,$pre,$TB_pre;
	
	if($format[order]=='list'){
		$order='A.tid';
	}elseif($format[order]=='hits'){
		if(ereg("^dzbbs",$webdb[passport_type])){
			$order='A.views';
		}else{
			$order='A.hits';
		}
	}elseif($format[order]=='comments'){
		$order='A.replies';
	}else{
		$order='A.tid';
	}
	$SQL="ORDER BY $order DESC ";
		
	//是否验证,没做处理
	if($format[yz]==1){			
	}

	//针对于辅助模板做的处理
	if($format[tplpart_2code]&&!$rs2){
		$_SQL1=$_SQL2='';
		if(strstr($format[tplpart_2code],'$fname')){
			$_SQL1=" ,F.name AS fname ";
			$_SQL2=" LEFT JOIN {$TB_pre}forums F ON F.fid=T.fid ";
		}
		//非图片,默认排序的话,只读取第一个ID即可.
		if(!strstr($format[tplpart_2code],'$picurl')&&$format[order]=='default'){
			$string2id=preg_replace("/([0-9]+)(.*)/is","\\1",$rsdb[tids]);
		}else{
			$string2id=$rsdb[tids];
		}
		if(strstr($format[tplpart_2code],'$content')&&strstr($format[tplpart_2code],'$picurl')){
			$getpic++;
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime,C.message AS content,Att.attachment$_SQL1 FROM {$TB_pre}attachments Att LEFT JOIN {$TB_pre}threads A ON Att.tid=A.tid LEFT JOIN {$TB_pre}posts C ON A.tid=C.tid$_SQL2 WHERE C.first=1 AND A.tid IN ($string2id) AND Att.isimage='1' GROUP BY Att.tid $SQL  ";
		}elseif(strstr($format[tplpart_2code],'$content')){
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime,C.message AS content$_SQL1 FROM {$TB_pre}threads A LEFT JOIN {$TB_pre}posts C ON A.tid=C.tid$_SQL2 WHERE C.first=1 AND A.tid IN ($string2id) $SQL LIMIT 1 ";
		}elseif(strstr($format[tplpart_2code],'$picurl')){
			$getpic++;
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime,Att.attachment$_SQL1 FROM {$TB_pre}attachments Att LEFT JOIN {$TB_pre}threads A ON Att.tid=A.tid$_SQL2 WHERE A.tid IN ($string2id) AND Att.isimage='1' GROUP BY Att.tid $SQL  ";
		}else{
			$SQL2=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime$_SQL1 FROM {$TB_pre}threads A $_SQL2 WHERE A.tid IN ($string2id) $SQL LIMIT 1 ";
		}
		//专题内可控排序的话.要全部读出来,才能排序.
		if($getpic&&$format[order]=='default'){
			$query = $db->query($SQL2);
			while($rss = $db->fetch_array($query)){
				$Ls[$rss[tid]]=$rss;
			}
			$aidsdb=explode(",",$rsdb[tids]);
			foreach($aidsdb AS $key=>$value){
				if($Ls[$value]){
					$rs3=$Ls[$value];
					break;
				}
			}
		}else{
			$rs3=$db->get_one($SQL2);
		}
		if($rs3){
			$_format=$format;
			$_format[SYS]='dzbbs';	//伪造,以便获取URL地址
			$rs3=label_set_rs($_format,$rs3);
		}
	}

	//主模板如果要获取栏目名称的话.要读多一个表
	$_SQL1=$_SQL2='';
	if(strstr($format[tplpart_1code],'$fname')){
		$_SQL1=" ,F.name AS fname ";
		$_SQL2=" LEFT JOIN {$TB_pre}forums F ON F.fid=T.fid ";
	}
	if(strstr($format[tplpart_1code],'$picurl')&&strstr($format[tplpart_1code],'$content')){
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime,C.message AS content,At.attachment$_SQL1 FROM {$TB_pre}attachments At LEFT JOIN {$TB_pre}threads A ON At.tid=A.tid LEFT JOIN {$TB_pre}posts C ON A.tid=C.tid$_SQL2 WHERE C.first=1 AND A.tid IN ($rsdb[tids]) AND At.isimage='1' GROUP BY A.tid $SQL LIMIT $Rows2 ";
	}elseif(strstr($format[tplpart_1code],'$content')){
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime,C.message AS content$_SQL1 FROM {$TB_pre}threads A LEFT JOIN {$TB_pre}posts C ON A.tid=C.tid$_SQL2 WHERE C.first=1 AND A.tid IN ($rsdb[tids]) $SQL LIMIT $Rows2 $rows ";
	}elseif($format[stype]=='r'||strstr($format[tplpart_1code],'$picurl')){
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime,At.attachment$_SQL1 FROM {$TB_pre}attachments At LEFT JOIN {$TB_pre}threads A ON At.tid=A.tid$_SQL2 WHERE A.tid IN ($rsdb[tids]) AND At.isimage='1' GROUP BY A.tid $SQL LIMIT $Rows2 ";
	}else{
		$SQL=" SELECT A.*,A.tid AS id,A.author AS username,A.authorid AS uid,A.subject AS title,A.dateline AS posttime$_SQL1 FROM {$TB_pre}threads A$_SQL2 WHERE A.tid IN ($rsdb[tids]) $SQL LIMIT $Rows2 ";
	}
	$query = $db->query($SQL);
	while($rs = $db->fetch_array($query)){
		//针对辅助模板过滤雷同记录
		if($format[tplpart_2code]&&$rs[id]==$rs3[id]){
			continue;
		}
		$_format=$format;
		$_format[SYS]='dzbbs';	//伪造,以便获取URL地址
		$_listdb[$rs[tid]]=label_set_rs($_format,$rs);
	}
	
	return array($_listdb,$rs3);
}

//获取标签中的视频
function get_label_mv($string){
	global $jobs;
	preg_match_all("/\(mv,([\d]+),([\d]+),(false|true)\)([^\(]+)\(\/mv\)/is",$string,$array);
	foreach($array[4] AS $key=>$value){
		$value=str_replace("\r","",$value);
		$detail=explode("\n",$value);
		foreach( $detail AS $key2=>$value2){
			list($url,$name,$fen,$type)=explode("@@@",$value2);
			if(!$url||$fen){
				continue;
			}
			$url=tempdir($url);
			$string=preg_replace("/\(mv,([\d]+),([\d]+),(false|true)\)([^\(]+)\(\/mv\)/is","",$string);
			$playcode=player($url,$array[1][$key],$array[2][$key],$array[3][$key],$type);
			if($jobs=='show'){
				//视频会档住标签,所以要特别处理
				return "<div class='player' style='padding-top:20px;'>$playcode</div>$string";
			}
			return "<div class='player'>$playcode</div>$string";
		}
	}
}

?>