留言管理

query("delete from {$dbtbpre}enewsmembergbook where gid='$gid'"); if($sql) { //操作日志 insert_dolog("gid=".$gid); printerror("DelMemberGbookSuccess",EcmsGetReturnUrl()); } else { printerror("DbError","history.go(-1)"); } } //批量删除留言 function hDelMemberGbook_All($add,$userid,$username){ global $empire,$dbtbpre; $gid=$add['gid']; $count=count($gid); if(empty($count)) { printerror("NotDelMemberGbookid","history.go(-1)"); } for($i=0;$i<$count;$i++) { $addsql.="gid='".intval($gid[$i])."' or "; } $addsql=substr($addsql,0,strlen($addsql)-4); $sql=$empire->query("delete from {$dbtbpre}enewsmembergbook where (".$addsql.")"); if($sql) { //操作日志 insert_dolog(""); printerror("DelMemberGbookSuccess",EcmsGetReturnUrl()); } else { printerror("DbError","history.go(-1)"); } } $enews=$_GET['enews']; if(empty($enews)) {$enews=$_POST['enews'];} if($enews) { hCheckEcmsRHash(); } if($enews=="hDelMemberGbook") { hDelMemberGbook($_GET,$logininid,$loginin); } elseif($enews=="hDelMemberGbook_All") { hDelMemberGbook_All($_POST,$logininid,$loginin); } include("../../member/class/user.php"); include "../".LoadLang("pub/fun.php"); $page=(int)$_GET['page']; $page=RepPIntvar($page); $start=0; $line=12;//每页显示条数 $page_line=12;//每页显示链接数 $offset=$page*$line;//总偏移量 //搜索 $search=''; $search.=$ecms_hashur['ehref']; $and=''; if($_GET['sear']) { $keyboard=RepPostVar2($_GET['keyboard']); if($keyboard) { $show=RepPostStr($_GET['show'],1); if($show==1)//留言内容 { $and.=" where gbtext like '%$keyboard%'"; } elseif($show==2)//回复内容 { $and.=" where retext like '%$keyboard%'"; } elseif($show==3)//留言者 { $and.=" where uname like '%$keyboard%'"; } elseif($show==4)//空间主人用户ID { $and.=" where userid='$keyboard'"; } elseif($show==5)//留言者IP { $and.=" where ip like '%$keyboard%'"; } $search.="&sear=1&keyboard=$keyboard&show=$show"; } } $query="select gid,isprivate,uid,uname,ip,addtime,gbtext,retext,userid,eipport from {$dbtbpre}enewsmembergbook".$and; $totalquery="select count(*) as total from {$dbtbpre}enewsmembergbook".$and; $num=$empire->gettotal($totalquery);//取得总条数 $query=$query." order by gid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page2($num,$line,$page_line,$start,$page,$search); $url="会员空间 > 管理留言"; ?> 留言管理

位置:

搜索：

fetch($sql)) { $ur=$empire->fetch1("select ".egetmf('username')." from ".eReturnMemberTable()." where ".egetmf('userid')."='$r[userid]'"); if($r['uid']) { $r['uname']="$r[uname]"; } $username=$ur['username']; $private=''; if($r['isprivate']) { $private='[悄悄话]'; } ?>

回复:

空间主人:

操作: [删除]

分页: