大分类显示置顶修改方法
原创作者:对猪谈情
齐博分类信息(地方门户),,大分类显示置顶修改方法
===================
修改f\template\default\bigsort.php
找到//分表后要特别处理
if($Fid_db[tableid]){
$query = $db->query("SELECT SQL_CALC_FOUND_ROWS C.* FROM {$_pre}db C LEFT JOIN {$_pre}sort S ON C.fid=S.fid WHERE S.fup='$fidDB[fid]' AND C.city_id='$city_id' ORDER BY C.id DESC LIMIT $min,$rows");
$RS=$db->get_one("SELECT FOUND_ROWS()");
while($rs = $db->fetch_array($query)){
$_erp=$Fid_db[tableid][$rs[fid]];
$rs=$db->get_one("SELECT * FROM {$_pre}content$_erp WHERE id=$rs[id]");
if(del_EndTimeInfo($rs)){ //自动删除过期信息
continue;
}
$rs[picurl] && $rs[picurl]=tempdir($rs[picurl]);
$rs[posttime]=date("y-m-d H:i",$rs[posttime]);
$rs[url]=get_info_url($rs[id],$rs[fid],$rs[city_id]);
$listdb[]=$rs;
}
}else{
$SQL='';
$zone_id && $SQL .= " AND C.zone_id='$zone_id' ";
$street_id && $SQL .= " AND C.street_id='$street_id' ";
下面增加
if(!$webdb[Info_ShowNoYz]){
$SQL .=" AND C.yz='1' ";
}
if($page<1){
$page=1;
}
if($fidDB[listorder]==1){
$sql_list="C.posttime";
$sql_order="DESC";
}elseif($fidDB[listorder]==2){
$sql_list="C.posttime";
$sql_order="ASC";
}elseif($fidDB[listorder]==3){
$sql_list="C.hits";
$sql_order="DESC";
}elseif($fidDB[listorder]==4){
$sql_list="C.hits";
$sql_order="ASC";
}elseif($fidDB[listorder]==5){
$sql_list="C.lastview";
$sql_order="DESC";
}else{
$sql_list="C.list";
$sql_order="DESC";
}
再找到 $query = $db->query("SELECT SQL_CALC_FOUND_ROWS C.* FROM {$_pre}content C LEFT JOIN {$_pre}sort S ON C.fid=S.fid WHERE S.fup='$fidDB[fid]' AND C.city_id='$city_id' $SQL ORDER BY C.id DESC LIMIT $min,$rows");
$RS=$db->get_one("SELECT FOUND_ROWS()");
while($rs = $db->fetch_array($query)){
if(del_EndTimeInfo($rs)){ //自动删除过期信息
continue;
}
增加
$rs[content]=@preg_replace('/<([^>]*)>/is',"",$rs[content]); //把HTML代码过滤掉
$rs[content]=get_word($rs[full_content]=$rs[content],100);
$rs[title]=get_word($rs[full_title]=$rs[title],$leng);
if($rs['list']>$timestamp){
$rs[title]=" <font color='$webdb[Info_TopColor]'>$rs[title]</font> <img src='$webdb[www_url]/images/default/icotop.gif' border=0>";
}elseif($rs['list']>$rs[posttime]){
//置顶过期的信息,需要恢复原来发布日期以方便排序,放在后面
$db->query("UPDATE {$_pre}content SET list='$rs[posttime]' WHERE id='$rs[id]'");
}
再修改f\template\default\bigsort.htm
找到<?php
@include(dirname(__FILE__)."/bigsort.php");
$priceColordb["c$price1$price2"]='red';
$orderColordb["$ordertype"]='red';
print <<<EOT
-->
<link rel="stylesheet" type="text/css" href="$webdb[www_url]/images/yellow/fenlie_list.css">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" class="MainContainer">
<tr>
<td class="MainL" valign="top">
<div class="MainLeftTitle">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!--
EOT;
foreach($Fid_db[$fidDB[fup]] AS $key=>$value){
$url=get_info_url('',$key,$city_id);
print <<<EOT
-->
<span><a href="$url" target="_blank">{$Fid_db[name][$key]}</a></span>
<!--
EOT;
}
print <<<EOT
-->
</td>
</tr>
</table>
</div>
下面增加
<div class="MainLeftTitle">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<!--
EOT;
$array=array_flip($Fid_db[$fid]);
foreach($array AS $key=>$rs){
$url=get_info_url('',$rs,$city_id);
print <<<EOT
-->
<span><a href="$url">{$Fid_db[name][$rs]}</a></span>
<!--
EOT;
}
print <<<EOT
-->
</td>
</tr>
</table>
</div>
|
点击率:1256
|
|