//取得相关链接 function GetKeyboard($keyboard,$keyid,$classid,$id,$link_num){ global $empire,$public_r,$class_r,$fun_r,$dbtbpre; if($keyid&&$link_num) { $add=”id in (“.$keyid.”)”; $tr=$empire->fetch1(“select otherlinktemp,otherlinktempsub,otherlinktempdate from “.GetTemptb(“enewspubtemp”).” limit 1″);//取得相关链接模板 $temp_r=explode(“[!–empirenews.listtemp–]”,$tr[otherlinktemp]); $key_sql=$empire->query(“select id,newstime,title,isurl,titleurl,classid,titlepic,lastvolume from {$dbtbpre}ecms_”.$class_r[$classid][tbname].” where “.$add.” order by newstime desc limit $link_num”); while($link_r=$empire->fetch($key_sql)) { //=========================================================2012-12-25 4usky.com $text=RepOtherTemp($temp_r[1],$link_r,$tr); $text=str_replace(‘[!–no–]’,$i,$text); $text=str_replace(‘[!–state–]’,$link_r[state],$text); $text=str_replace(‘[!–lastvolume–]’,$link_r[lastvolume],$text); $keyboardtext.=$text; //$keyboardtext.=RepOtherTemp($temp_r[1],$link_r,$tr); }
$keyboardtext=$temp_r[0].$keyboardtext.$temp_r[2]; } else { //————-生成的时候加载一次keyid zhuxianfei.com 2013/5/17 星期五 $keyid=GetKeyid($keyboard,$classid,0,$link_num); if($keyid) { $fsql=$empire->query(“update {$dbtbpre}ecms_”.$class_r[$classid][tbname].”_data_1 set keyid=’$keyid’ where id=’$id'”); $add=”id in (“.$keyid.”)”; $tr=$empire->fetch1(“select otherlinktemp,otherlinktempsub,otherlinktempdate from “.GetTemptb(“enewspubtemp”).” limit 1″);//取得相关链接模板 $temp_r=explode(“[!–empirenews.listtemp–]”,$tr[otherlinktemp]); $key_sql=$empire->query(“select id,newstime,title,isurl,titleurl,classid,titlepic,lastvolume from {$dbtbpre}ecms_”.$class_r[$classid][tbname].” where “.$add.” order by newstime desc limit $link_num”); while($link_r=$empire->fetch($key_sql)) { //=========================================================2012-12-25 4usky.com $text=RepOtherTemp($temp_r[1],$link_r,$tr); $text=str_replace(‘[!–no–]’,$i,$text); $text=str_replace(‘[!–state–]’,$link_r[state],$text); $text=str_replace(‘[!–lastvolume–]’,$link_r[lastvolume],$text); $keyboardtext.=$text; //$keyboardtext.=RepOtherTemp($temp_r[1],$link_r,$tr); }
$keyboardtext=$temp_r[0].$keyboardtext.$temp_r[2]; } else //没有关键字的时候读取人气最高的几条信息 2013/5/17 星期五 zhuxianfei.com { $add=””; $tr=$empire->fetch1(“select otherlinktemp,otherlinktempsub,otherlinktempdate from “.GetTemptb(“enewspubtemp”).” limit 1″);//取得相关链接模板 $temp_r=explode(“[!–empirenews.listtemp–]”,$tr[otherlinktemp]); $key_sql=$empire->query(“select id,newstime,title,isurl,titleurl,classid,titlepic,lastvolume from {$dbtbpre}ecms_”.$class_r[$classid][tbname].” where order by onclick desc limit $link_num”); while($link_r=$empire->fetch($key_sql)) { //=========================================================2012-12-25 4usky.com $text=RepOtherTemp($temp_r[1],$link_r,$tr); $text=str_replace(‘[!–no–]’,$i,$text); $text=str_replace(‘[!–state–]’,$link_r[state],$text); $text=str_replace(‘[!–lastvolume–]’,$link_r[lastvolume],$text); $keyboardtext.=$text; //$keyboardtext.=RepOtherTemp($temp_r[1],$link_r,$tr); }
评论0