www.gusucode.com > 4102网博士成品网站管理系统 PHP网站源码程序 > 4102/4102/guestbook/module/GuestBookQuery.php
<?php /* [插件名称] 企业留言检索 [适用范围] 全站 */ function GuestBookQuery(){ global $fsql,$msql; global $strHomePage,$strEmail,$strInfo1; $shownums=$GLOBALS["PLUSVARS"]["shownums"]; $cutword=$GLOBALS["PLUSVARS"]["cutword"]; $cutbody=$GLOBALS["PLUSVARS"]["cutbody"]; $tempname=$GLOBALS["PLUSVARS"]["tempname"]; $key=$_GET["key"]; $page=$_GET["page"]; //管理员身份验证 if(isset($_COOKIE["SYSUSER"]) || $_COOKIE["SYSUSER"]!=""){ $msql->query("select * from {P}_base_admin where user='".$_COOKIE["SYSUSER"]."'"); if($msql->next_record()){ $psd=$msql->f('password'); $needmd5=md5($_COOKIE["SYSUSER"]."l0aZXUYJ876Mn5rQoL55B".$psd.$_COOKIE["SYSTM"]); if($needmd5==$_COOKIE["SYSZC"]){ $fsql->query("select id from {P}_base_adminrights where user='".$_COOKIE["SYSUSER"]."' and auth='231'"); if($fsql->next_record()){ $mrights="yes"; }else{ $mrights="no"; } }else{ $mrights="no"; } }else{ $mrights="no"; } } //模版解释 $Temp=LoadTemp($tempname); $TempArr=SplitTblTemp($Temp); $str=$TempArr["start"]; //默认条件 $scl=" iffb='1' "; if($key!=""){ $scl.=" and (title regexp '$key' or body regexp '$key' or body regexp '$key') "; } include(ROOTPATH."includes/pages.inc.php"); $pages=new pages; $totalnums=TblCount("_guestbook","id",$scl); $pages->setvar(array("key" => $key)); $pages->set($shownums,$totalnums); $pagelimit=$pages->limit(); $fsql->query("select * from {P}_guestbook where $scl order by id desc limit $pagelimit"); while($fsql->next_record()){ $id=$fsql->f('id'); $title=$fsql->f('title'); $name=$fsql->f('name'); $headpic=$fsql->f('headpic'); $email=$fsql->f('email'); $qq=$fsql->f('qq'); $homepage=$fsql->f('homepage'); $mood=$fsql->f('mood'); $body=$fsql->f('body'); $answer=$fsql->f('answer'); $secret=$fsql->f('secret'); $dtime=$fsql->f('dtime'); $uptime=$fsql->f('uptime'); $answertime=$fsql->f('answertime'); $ip=$fsql->f('ip'); $xuhao=$fsql->f('xuhao'); $iffb=$fsql->f('iffb'); $ifanswer=$fsql->f('ifanswer'); $dtime=date("Y-m-d H:i:s",$dtime); $uptime=date("Y-m-d",$uptime); //$headpic=ROOTPATH.$headpic; if($homepage!='' || $homepage!='http://'){ $homepageurl="<a href='" . $homepage . "'>$strHomePage</a>"; }else{ $homepageurl=$strHomePage; } if(eregi("^[_.0-9a-z-]+@([0-9a-z][0-9a-z-]+.)+[a-z]{2,3}$",$email)) { $emailurl="<a href='mailto:" . $email . "'>$strEmail</a>"; }else{ $emailurl=$strEmail; } if($mood!=''){ $moodurl=$mood; //$mooddiv='<div class="mood"><img src="' . $moodurl . '" border="0" /></div>'; } if($mrights=="yes"){ $body='<div class="bdinfo2">' . $body . '</div>'; }else{ if($secret=="1"){ $body='<div class="bdinfo">' . $strInfo1 . '</div>'; }else{ $body='<div class="bdinfo2">' . $body . '</div>'; } } if($ifanswer==1){ $hfdisplay="block"; }else{ $hfdisplay="none"; } if($qq!='' && $qq!=0 && intval($qq) && strlen($qq)>=5){ $qqinfo='<a target="_blank" href="http://wpa.qq.com/msgrd?V=1&Uin=' . $qq . '&Site=&Menu=yes" title="' . $strInfo2 . '"><img src="' . ROOTPATH . 'guestbook/templates/images/qq.gif" border="0" /> QQ</a>'; }else{ $qqinfo='<img src="' . ROOTPATH . 'guestbook/templates/images/qq.gif" border="0" /> QQ'; } //姓名长度截取 $namelen=utf8_strlen($name, 1); if($namelen>12){ $name=hsubstr($name,12); } $body=nl2br($body); $answer=nl2br($answer); $var=array ( 'id' => $id, 'title' => $title, 'name' => $name, 'headpic' => $headpic, 'emailurl' => $emailurl, 'qq' => $qq, 'homepageurl' => $homepageurl, 'moodurl' => $moodurl, 'body' => $body, 'answer' => $answer, 'secret' => $secret, 'dtime' => $dtime, 'uptime' => $uptime, 'answertime' => $answertime, 'ip' => $ip, 'hfdisplay' => $hfdisplay, 'qqinfo' => $qqinfo ); $str.=ShowTplTemp($TempArr["list"],$var); $name=''; } $str.=$TempArr["end"]; $pagesinfo=$pages->ShowNow(); $var=array ( '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; } ?>