<put type="hidden" name="channeltype" value="1">

var $Sphx;复制

var $addJo;复制

• 1

$hascode = md5($cquery);复制

if($this->ChannelType > 0)
{
	$this->AddSql = jo(' AND ',$ksqls) . " AND ( CONCAT(addf.body,arc.title) LIKE '%{$this->Keyword}%') ";
	$row = $this->dsql->GetOne("SELECT addtable FROM `58pic_channeltype` WHERE id={$this->ChannelType}");
	$addtable = trim($row['addtable']);
	$this->addJo = " LEFT JOIN `{$addtable}` addf ON arc.id=addf.aid ";
	$cquery = "SELECT arc.,addf. FROM `{$this->AddTable}` arc {$this->addJo} WHERE ".$this->AddSql;
}

WHERE {$this->AddSql} $ordersql LIMIT $limitstart,$row";

if($this->ChannelType > 0)
{
	$query = "SELECT arc.,act.typedir,act.typename,act.isdefault,act.defaultname,act.namerule,
	act.namerule2,act.ispart,act.moresite,act.siteurl,act.sitepath,addf.
	FROM `{$this->AddTable}` arc LEFT JOIN `58pic_arctype` act ON arc.typeid=act.id {$this->addJo}
	WHERE {$this->AddSql} $ordersql LIMIT $limitstart,$row";
}