$value) { if (!is_array($value)) { $array[$key] = addslashes($value); $array[$key] = htmlspecialchars($array[$key]); } else { Add_S($array[$key]); } } } } require_once(dirname(__FILE__)."/../include/config_base.php"); require_once(dirname(__FILE__)."/../include/inc_typelink.php"); $sid = (isset($sid) && is_numeric($sid)) ? $sid : 0; $note = (isset($note)) ? $note : ""; $kw = (isset($kw)) ? $kw : ""; $cid = (isset($cid)) ? $cid : ""; if($kw!="") $note = "Null"; if($sid == 0 || $note == "") { echo "非法地址!"; exit; } else { $sql = "select * from #@__addonspec where aid = $sid"; $row = $dsql->GetOne($sql); $allnote = $row['note']; $notes = explode("{/dede:specnote}",$allnote); for($i=0;$i 0) break; } $gets = explode(" ",$notes[$i]); $kids = str_replace("'","",str_replace("keywords=","",$gets[13])); $typeid = str_replace("}","",str_replace("'","",str_replace("typeid=","",$gets[14]))); if($kids != "" && $note!= "Null") { $sql = "select id from #@__archives where (typeid2 like '%$typeid%' or typeid=$typeid) and keywords like '%$kids%'"; //echo $sql; $dsql->setquery($sql); $dsql->execute(); while($row=$dsql->getarray()) { $ids = $ids.$row[0].","; } if(strlen($ids)>0) $ids = substr($ids,0,strlen($ids)-1); } if($kw != "") $kids = $kw; if($cid != "") $tl = new TypeLink($cid); if($kw != "" && $cid != "") { $kids = $kw; $tl = new TypeLink($cid); $typeids = explode("{/dede:specnote}",$allnote); for($i=0;$i"; } echo $typeid; $sql = "select id from #@__archives where keywords like '%$kw%'"; //echo $sql; $dsql->setquery($sql); $dsql->execute(); while($row=$dsql->getarray()) { $ids1 = $ids1.$row[0].","; } if(strlen($ids1)>0) $ids1 = substr($ids1,0,strlen($ids1)-1); if(strlen($ids)>0) $ids = $ids.",".$ids1; else $ids = $ids1; } if(strlen(str_replace("'","",str_replace("idlist=","",$gets[6])))>0) $ids = $ids.",".str_replace("idlist=","",$gets[6]); //echo $ids; $ids = str_replace("'","",$ids); $idss = explode(",",$ids); } $sql ="SELECT title FROM `ky_archivesspec` WHERE id = $sid "; $spec = $dsql->GetOne($sql); ?> <? echo $spec['title']?><? if($kids!="") echo "-".$kids?> 更多文章列表
GetOne($sql); ?>
    GetSunID($cid,"arcs",0); $wsql = "(" . $wsql . " or " . str_replace("' ","%' ",str_replace("typeid='","typeid2 like '%",$wsql)) . ")"; $sql = "select arcs.ID as id,arcs.title,arcs.pubdate from #@__archives as arcs where keywords like '%$kw%' And ".$wsql." and arcrank>-1 order by arcs.pubdate desc "; }else if($kw == "" && $cid != "") { $wsql = $tl->GetSunID($cid,"arcs",0); $wsql = "(" . $wsql . " or " . str_replace("' ","%' ",str_replace("typeid='","typeid2 like '%",$wsql)) . ")"; $sql = "select arcs.ID as id,arcs.title,arcs.pubdate from #@__archives as arcs where ".$wsql." and arcrank>-1 order by arcs.pubdate desc "; }else { $sql = "select id,title,pubdate from #@__archives where id in($ids) order by pubdate desc"; } $dsql->SetQuery($sql); //echo $sql; $dsql->Execute(); while($arc = $dsql->GetArray()) { ?>
  • ()