gusucode.com > 电脑配件公司电子商务网站源码程序 > 电脑配件公司电子商务网站源码程序/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" />&nbsp;QQ</a>';
		}else{
			$qqinfo='<img src="' . ROOTPATH . 'guestbook/templates/images/qq.gif" border="0" />&nbsp;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;


}
?>