www.gusucode.com > 4158网博士成品网站管理系统 PHP网站源码程序 > 4158/4158/product/module/ProductGl.php
<?php function ProductGl(){ global $fsql,$tsql; $coltitle=$GLOBALS["PLUSVARS"]["coltitle"]; $tempname=$GLOBALS["PLUSVARS"]["tempname"]; $memberid=$_COOKIE["MEMBERID"]; $memberid=htmlspecialchars($memberid); $key=htmlspecialchars($_GET["key"]); $showcatid=htmlspecialchars($_GET["showcatid"]); $shownum=htmlspecialchars($_GET["shownum"]); $showpcatid=htmlspecialchars($_GET["showpcatid"]); $page=htmlspecialchars($_GET["page"]); $step=htmlspecialchars($_GET["step"]); if($step=="update"){ $id=htmlspecialchars($_GET["id"]); $now=time(); $fsql->query("update {P}_product_con set uptime='$now' where id='$id' and memberid='$memberid'"); } if($step=="del"){ $id=htmlspecialchars($_GET["id"]); //删除原图 $fsql->query("select src from {P}_product_con where memberid='$memberid' and id='$id'"); if($fsql->next_record()){ $oldsrc=$fsql->f('src'); if(file_exists(ROOTPATH.$oldsrc) && $oldsrc!="" && !strstr($oldsrc,"../")){ unlink(ROOTPATH.$oldsrc); } $candel="yes"; }else{ $candel="no"; } if($candel=="yes"){ //删除组图 $fsql->query("select src from {P}_product_pages where productid='$id'"); while($fsql->next_record()){ $oldsrc=$fsql->f('src'); if(file_exists(ROOTPATH.$oldsrc) && $oldsrc!="" && !strstr($oldsrc,"../")){ unlink(ROOTPATH.$oldsrc); } } $fsql->query("delete from {P}_product_pages where productid='$id'"); } $fsql->query("delete from {P}_product_con where id='$id' and memberid='$memberid'"); } //模板解释 $Temp=LoadTemp($tempname); $TempArr=SplitTblTemp($Temp); //自定义分类 $fsql -> query ("select * from {P}_product_pcat where memberid='$memberid' order by xuhao"); while ($fsql -> next_record ()) { $pcatid = $fsql -> f ("catid"); $pcat = $fsql -> f ("cat"); if($showpcatid==$pcatid){ $pcatlist.="<option value='".$pcatid."' selected>".$pcat."</option>"; }else{ $pcatlist.="<option value='".$pcatid."'>".$pcat."</option>"; } } //图片分类 $fsql -> query ("select * from {P}_product_cat order by catpath"); while ($fsql -> next_record ()) { $lpid = $fsql -> f ("pid"); $lcatid = $fsql -> f ("catid"); $cat = $fsql -> f ("cat"); $catpath = $fsql -> f ("catpath"); $lcatpath = explode (":", $catpath); for ($i = 0; $i < sizeof ($lcatpath)-2; $i ++) { $tsql->query("select catid,cat from {P}_product_cat where catid='$lcatpath[$i]'"); if($tsql->next_record()){ $ncatid=$tsql->f('cat'); $ncat=$tsql->f('cat'); $ppcat.=$ncat."/"; } } if($showcatid==$lcatid){ $catlist.="<option value='".$lcatid."' selected>".$ppcat.$cat."</option>"; }else{ $catlist.="<option value='".$lcatid."'>".$ppcat.$cat."</option>"; } $ppcat=""; } $var=array ('catlist' => $catlist,'pcatlist' => $pcatlist); $str=ShowTplTemp($TempArr["start"],$var); $scl=" memberid='$memberid' "; if($showcatid!="" && $showcatid!="0"){ $fmdpath=fmpath($showcatid); $scl.=" and catpath regexp '$fmdpath' "; } if($showpcatid!="" && $showpcatid!="0"){ $scl.=" and pcatid ='$showpcatid' "; } if($key!=""){ $scl.=" and (title regexp '$key' or body regexp '$key') "; } if($shownum==""){ $shownum="10"; } include(ROOTPATH."includes/pages.inc.php"); $pages=new pages; $totalnums=TblCount("_product_con","id",$scl); $pages->setvar(array("key" => $key,"shownum" => $shownum,"showcatid" => $showcatid,"showpcatid" => $showpcatid)); $pages->set($shownum,$totalnums); $pagelimit=$pages->limit(); $fsql->query("select * from {P}_product_con where $scl order by uptime desc limit $pagelimit"); while($fsql->next_record()){ $id=$fsql->f('id'); $title=$fsql->f('title'); $dtime=$fsql->f('dtime'); $src=$fsql->f('src'); $uptime=$fsql->f('uptime'); $iffb=$fsql->f('iffb'); $dtime=date("Y-m-d",$dtime); $uptime=date("Y-m-d",$uptime); if($iffb=="1"){ $check="<img src='".ROOTPATH."product/templates/images/yes.gif'>"; }else{ $check="<img src='".ROOTPATH."product/templates/images/no.gif'>"; } if($src!=""){ $icon="image.gif"; $src=ROOTPATH.$src; }else{ $icon="noimage.gif"; } $link=ROOTPATH."product/html/?".$id.".html"; $var=array ( 'page' => $page, 'title' => $title, 'dtime' => $dtime, 'src' => $src, 'icon' => $icon, 'uptime' => $uptime, 'check' => $check, 'target' => "_blank", 'link' => $link, 'id' => $id ); $str.=ShowTplTemp($TempArr["list"],$var); } $str.=$TempArr["end"]; $pagesinfo=$pages->ShowNow(); $var=array ( 'key' => $key, 'showcatid' => $showcatid, 'shownum' => $shownum, '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; } ?>