members_del.php

程序安装简便容易

<?php
!$_SERVER['PHP_SELF'] && $_SERVER['PHP_SELF']=$_SERVER['SCRIPT_NAME'];
substr($_SERVER['PHP_SELF'],-9,-4)!=='admin' && exit('Forbidden');

if(!empty($_GET['do'])) {
	if($_GET['do']=='do') {
		$name=$_POST['schname'];
		$email=$_POST['schemail'];
		$postnum=$_POST['postnum'];
		$userip=$_POST['userip'];
		$regdate=$_POST['regdate'];
		$lastlogin=$_POST['schlastlogin'];
		$orderway=$_POST['orderway'];
		$asc=$_POST['asc'];
		$perpage=$_POST['perpage'];
		$direct=!empty($_POST['direct']) ? $_POST['direct'] : 0;

		if(!$name && !$email && !$postnum && !$userip && !$regdate && !$lastlogin) {
			echo "<script language=\"javascript\">alert(\"没有提供足够的条件！请填写搜索条件！\")</script>";
			echo "<meta http-equiv='refresh' content='0;url=admin.php?job=members_del'>";
			exit;
		} else {
			if($direct) {
				$sql='';
				if($name) {
					$name=addslashes(str_replace('*','%',$name));
					$sql.=" AND (username LIKE '%$name%')";
				}
				if($email!='') {
					$email==str_replace('*','%',$email);
					$sql.=" AND (email LIKE '%$email')";
				}
				if($postnum) {
					$sql.=" AND postnum<'$postnum'";
				}
				if($userip){
					$userip=str_replace('*','%',$userip);
					$sql.=" AND (userip LIKE '$userip') ";
				}
				if($regdate) {
					$schtime=$timestamp-$regdate;
					$sql.=" AND regdate<'$schtime'";
				}
				if($lastlogin) {
					$schtime=$timestamp-$lastlogin;
					$sql.=" AND lastlogin<'$schtime'";
				}
				if($orderway) {
					$order=" ORDER BY $orderway";
					$asc && $order.=$asc;
				}
				$query=query("SELECT uid FROM duoxun_members WHERE groupid!=1 $sql");
				while($rs=fetch_array($query)) {
					$uids[]=$rs;
				}
				if(!empty($uids)) {
					foreach($uids as $uid) {
						query("DELETE FROM duoxun_members WHERE uid=$uid");
					}
					echo "<script language=\"javascript\">alert(\"用户删除成功！\")</script>";
					echo "<meta http-equiv='refresh' content='0;url=admin.php?job=members_del'>";
					exit;
				} else {
					echo "<script language=\"javascript\">alert(\"没有找到符合搜索条件的记录！\")</script>";
					echo "<meta http-equiv='refresh' content='0;url=admin.php?job=members_del'>";
					exit;
				}			
			} else {
				$addurl="admin.php?job=members_del&do=show";
				$name && $addurl.="&name=$name";
				$email && $addurl.="&email=$email";
				$postnum && $addurl.="&postnum=$postnum";
				$userip && $addurl.="&userip=$userip";
				$regdate && $addurl.="&regdate=$regdate";
				$lastlogin && $addurl.="&lastlogin=$lastlogin";
				$orderway && $addurl.="&orderway=$orderway";
				$asc && $addurl.="&asc=$asc";
				$perpage && $addurl.="&perpage=$perpage";

				echo "<meta http-equiv='refresh' content='0;url=$addurl'>";
				exit;
			}					
		}				
	} elseif($_GET['do']=='show') {
		$name=!empty($_GET['name']) ? $_GET['name'] : 0;
		$email=!empty($_GET['email']) ? $_GET['email'] : 0;
		$postnum=!empty($_GET['postnum']) ? $_GET['postnum'] : 0;
		$userip=!empty($_GET['userip']) ? $_GET['userip'] : 0;
		$regdate=!empty($_GET['regdate']) ? $_GET['regdate'] : 0;
		$lastlogin=!empty($_GET['lastlogin']) ? $_GET['lastlogin'] : 0;
		$orderway=!empty($_GET['orderway']) ? $_GET['orderway'] : 0;
		$asc=!empty($_GET['asc']) ? $_GET['asc'] : 0;
		$perpage=!empty($_GET['perpage']) ? $_GET['perpage'] : 30;

		$addurl='';
		$name && $addurl.="&name=$name";
		$email && $addurl.="&email=$email";
		$postnum && $addurl.="&postnum=$postnum";
		$userip && $addurl.="&userip=$userip";
		$regdate && $addurl.="&regdate=$regdate";
		$lastlogin && $addurl.="&lastlogin=$lastlogin";
		$orderway && $addurl.="&orderway=$orderway";
		$asc && $addurl.="&asc=$asc";
		$perpage && $addurl.="&perpage=$perpage";
		
		$sql='';
		if($name) {
			$name=addslashes(str_replace('*','%',$name));
			$sql.=" AND (username LIKE '%$name%')";
		}
		if($email!='') {
			$email==str_replace('*','%',$email);
			$sql.=" AND (email LIKE '%$email')";
		}
		if($postnum) {
			$sql.=" AND postnum<'$postnum'";
		}
		if($userip){
			$userip=str_replace('*','%',$userip);
			$sql.=" AND (userip LIKE '$userip') ";
		}
		if($regdate) {
			$schtime=$timestamp-$regdate;
			$sql.=" AND regdate<'$schtime'";
		}
		if($lastlogin) {
			$schtime=$timestamp-$lastlogin;
			$sql.=" AND lastlogin<'$schtime'";
		}
		if($orderway) {
			$order=" ORDER BY $orderway";
			$asc && $order.=$asc;
		}
		$rs=get_one("SELECT COUNT(*) AS count FROM duoxun_members WHERE groupid!=1 $sql");
		$num=$rs['count'];
		$pages=ceil($num/$perpage);
		$mpurl='admin.php?job=members_del&do=show'.$addurl;
		if(empty($_GET['page']) || $_GET['page']<1) {
			$page=1;
			$start=0;
		} elseif($_GET['page']>$pages) {
			$page=$pages;
			$start=($page-1)*$perpage;
		} else {
			$page=$_GET['page'];
			$start=($page-1)*$perpage;
		}
		$fenye=admin_fenye($num,$perpage,$page,$mpurl,0);
		$query=query("SELECT * FROM duoxun_members WHERE groupid!=1 $sql LIMIT $start,$perpage");
		while($rs=fetch_array($query)) {
			$catedb[]=$rs;
		}
		$u='admin.php?'.$_SERVER['QUERY_STRING'];
		setcookie('u','',$timestamp-86400);
		setcookie('u',$u,$timestamp+86400);
	} elseif($_GET['do']=='del') {
		$uids=$_POST['uids'];
		$addurl=$_POST['addurl'];
		foreach($uids as $uid) {
			query("DELETE FROM duoxun_members WHERE uid='$uid'");
		}
		echo "<script language=\"javascript\">alert(\"删除成功！\")</script>";
		echo "<meta http-equiv='refresh' content='0;url=admin.php?job=members_del&do=show$addurl'>";
		exit;
	}			
}

require_once template('members_del','admin');

?>