解决lists标签中，加上where后其他条件失效的问题

发表于2013-11-25 15:32:01来源于创想网页设计工作室

次点击[大] [中] [小] [打印] [关闭窗口] [评论]

{pc:content action="lists" catid="$catid" where="posids`!='0'" thumb="1" num="10"}

if(isset($data['where'])) {

$sql = $data['where'];

} else {

$thumb = intval($data['thumb']) ? " AND thumb != ''" : '';

if($this->category[$catid]['child']) {

$catids_str = $this->category[$catid]['arrchildid'];

$pos = strpos($catids_str,',')+1;

$catids_str = substr($catids_str, $pos);

$sql = "status=99 AND catid IN ($catids_str)".$thumb;

} else {

$sql = "status=99 AND catid='$catid'".$thumb;

}

}

/*以下为创想工作室修改开始*/

if(isset($data['where'])) {

$where = (isset($data['where'])&&(!empty($data['where'])))?' AND '.$data['where']:'';

$thumb = intval($data['thumb']) ? " AND thumb != ''" : '';

if($this->category[$catid]['child']) {

$catids_str = $this->category[$catid]['arrchildid'];

$pos = strpos($catids_str,',')+1;

$catids_str = substr($catids_str, $pos);

$sql = "status=99".$where." AND catid IN ($catids_str)".$thumb;

} else {

$sql = "status=99".$where." AND catid='$catid'".$thumb;

}

} else {

$thumb = intval($data['thumb']) ? " AND thumb != ''" : '';

if($this->category[$catid]['child']) {

$catids_str = $this->category[$catid]['arrchildid'];

$pos = strpos($catids_str,',')+1;

$catids_str = substr($catids_str, $pos);

$sql = "status=99 AND catid IN ($catids_str)".$thumb;

} else {

$sql = "status=99 AND catid='$catid'".$thumb;

}

}

/*以上为创想工作室修改结束*/

相关热词搜索：listswhere标签

上一篇：升级到v9.4.0（20130828）后台无法打开的解决办法

下一篇：解决{$url}标签在内容页需要编辑或重新生成内容页才显示