www.gusucode.com > 2060网博士成品网站管理系统 PHP网站源码程序 > 2060/2060/photo/module/PhotoGlobalQuery.php
<?php /* [插件名称] 全站图片列表+翻页 [适用范围] 全站 */ function PhotoGlobalQuery(){ global $fsql,$msql; $shownums=$GLOBALS["PLUSVARS"]["shownums"]; $ord=$GLOBALS["PLUSVARS"]["ord"]; $sc=$GLOBALS["PLUSVARS"]["sc"]; $showtj=$GLOBALS["PLUSVARS"]["showtj"]; $cutword=$GLOBALS["PLUSVARS"]["cutword"]; $cutbody=$GLOBALS["PLUSVARS"]["cutbody"]; $target=$GLOBALS["PLUSVARS"]["target"]; $catid=$GLOBALS["PLUSVARS"]["catid"]; $projid=$GLOBALS["PLUSVARS"]["projid"]; $tags=$GLOBALS["PLUSVARS"]["tags"]; $pagename=$GLOBALS["PLUSVARS"]["pagename"]; $tempname=$GLOBALS["PLUSVARS"]["tempname"]; $picw=$GLOBALS["PLUSVARS"]["picw"]; $pich=$GLOBALS["PLUSVARS"]["pich"]; $fittype=$GLOBALS["PLUSVARS"]["fittype"]; //默认条件 $scl=" iffb='1' and catid!='0' "; if($showtj!="" && $showtj!="0"){ $scl.=" and tj='1' "; } //显示分类规则:如果后台不指定分类,则显示当前所在分类,否则不限分类 if($catid!=0 && $catid!=""){ $catid=fmpath($catid); $scl.=" and catpath regexp '$catid' "; } //匹配专题 if($projid!=0 && $projid!=""){ $projid=fmpath($projid); $scl.=" and proj regexp '$projid' "; } //判断匹配标签 if($tags!=""){ $tags=$tags.","; $scl.=" and tags regexp '$tags' "; } //模版解释 $Temp=LoadTemp($tempname); $TempArr=SplitTblTemp($Temp); $str=$TempArr["start"]; //翻页 include(ROOTPATH."includes/pages.inc.php"); $pages=new pages; $totalnums=TblCount("_photo_con","id",$scl); $pages->setvar(array("key" => $key)); $pages->set($shownums,$totalnums); $pagelimit=$pages->limit(); $picnum=1; $fsql->query("select * from {P}_photo_con where $scl order by $ord $sc limit $pagelimit"); while($fsql->next_record()){ $id=$fsql->f('id'); $title=$fsql->f('title'); $catpath=$fsql->f('catpath'); $dtime=$fsql->f('dtime'); $nowcatid=$fsql->f('catid'); $ifnew=$fsql->f('ifnew'); $ifred=$fsql->f('ifred'); $ifbold=$fsql->f('ifbold'); $author=$fsql->f('author'); $source=$fsql->f('source'); $cl=$fsql->f('cl'); $src=$fsql->f('src'); $cl=$fsql->f('cl'); $prop1=$fsql->f('prop1'); $prop2=$fsql->f('prop2'); $prop3=$fsql->f('prop3'); $prop4=$fsql->f('prop4'); $prop5=$fsql->f('prop5'); $prop6=$fsql->f('prop6'); $prop7=$fsql->f('prop7'); $prop8=$fsql->f('prop8'); $prop9=$fsql->f('prop9'); $prop10=$fsql->f('prop10'); $prop11=$fsql->f('prop11'); $prop12=$fsql->f('prop12'); $prop13=$fsql->f('prop13'); $prop14=$fsql->f('prop14'); $prop15=$fsql->f('prop15'); $prop16=$fsql->f('prop16'); $prop17=$fsql->f('prop17'); $prop18=$fsql->f('prop18'); $prop19=$fsql->f('prop19'); $prop20=$fsql->f('prop20'); $memo=$fsql->f('memo'); if($GLOBALS["CONF"]["CatchOpen"]=="1" && file_exists(ROOTPATH."photo/html/".$id.".html")){ $link=ROOTPATH."photo/html/".$id.".html"; }else{ $link=ROOTPATH."photo/html/?".$id.".html"; } $dtime=date("Y-m-d",$dtime); if($ifbold=="1"){$bold=" style='font-weight:bold' ";}else{$bold="";} if($ifred!="0"){$red=" style='color:".$ifred."' ";}else{$red="";} if($cutword!="0"){$title=csubstr($title,0,$cutword);} if($cutbody!="0"){$memo=csubstr($memo,0,$cutbody);} if($src==""){$src="photo/pics/nopic.gif";} $src=ROOTPATH.$src; //参数列 $i=1; $msql->query("select * from {P}_photo_prop where catid='$nowcatid' order by xuhao"); while($msql->next_record()){ $pn="propname".$i; $$pn=$msql->f('propname'); $i++; } //模版标签解释 $var=array ( 'title' => $title, 'memo' => $memo, 'dtime' => $dtime, 'red' => $red, 'bold' => $bold, 'link' => $link, 'target' => $target, 'author' => $author, 'source' => $source, 'cat' => $cat, 'src' => $src, 'picw' => $picw, 'pich' => $pich, 'cl' => $cl, 'prop1' => $prop1, 'prop2' => $prop2, 'prop3' => $prop3, 'prop4' => $prop4, 'prop5' => $prop5, 'prop6' => $prop6, 'prop7' => $prop7, 'prop8' => $prop8, 'prop9' => $prop9, 'prop10' => $prop10, 'prop11' => $prop11, 'prop12' => $prop12, 'prop13' => $prop13, 'prop14' => $prop14, 'prop15' => $prop15, 'prop16' => $prop16, 'prop17' => $prop17, 'prop18' => $prop18, 'prop19' => $prop19, 'prop20' => $prop20, 'propname1' => $propname1, 'propname2' => $propname2, 'propname3' => $propname3, 'propname4' => $propname4, 'propname5' => $propname5, 'propname6' => $propname6, 'propname7' => $propname7, 'propname8' => $propname8, 'propname9' => $propname9, 'propname10' => $propname10, 'propname11' => $propname11, 'propname12' => $propname12, 'propname13' => $propname13, 'propname14' => $propname14, 'propname15' => $propname15, 'propname16' => $propname16, 'propname17' => $propname17, 'propname18' => $propname18, 'propname19' => $propname19, 'propname20' => $propname20 ); $str.=ShowTplTemp($TempArr["list"],$var); $picnum++; } $str.=$TempArr["end"]; $pagesinfo=$pages->ShowNow(); $var=array ( 'fittype' => $fittype, 'showpages' => $pages->output(1), 'pagestotal' => $pagesinfo["total"], 'pagesnow' => $pagesinfo["now"], 'pagesshownum' => $pagesinfo["shownum"], 'pagesfrom' => $pagesinfo["from"], 'pagesto' => $pagesinfo["to"], 'totalnums' => $totalnums ); $str=ShowTplTemp($str,$var); return $str; } ?>