members_search.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') {
		$username=$_POST['schname'];
		$schname_s=!empty($_POST['schname_s']) ? $_POST['schname_s'] : 0;
		$email=$_POST['schemail'];
		$userip=$_POST['userip'];
		$regdate=$_POST['regdate'];
		$lastlogin=$_POST['schlastvisit'];
		$order=$_POST['orderway'];
		$asc=$_POST['asc'];
		$perpage=!empty($_POST['perpage']) ? $_POST['perpage'] : 100;
		if(!$username && !$email && !$userip && $regdate=='all' && $lastlogin=='all') {
			echo "<script language=\"javascript\">alert(\"没有提供足够的查找条件！\")</script>";
			echo "<meta http-equiv='refresh' content='0;url=admin.php?job=members_search'>";
			exit;
		} else {
			$urladd='';
			$username=trim($username);
			if($username!=''){
				$username=addslashes(str_replace('*','%',$username));
				$urladd.=$schname_s==1 ? "&username=$username&schname_s=1" : "&username=$username";
			}
			if($email!=''){
				$email=str_replace('*','%',$email);
				$urladd.="&email=$email";
			}
			if($userip!=''){
				$userip=str_replace('*','%',$userip);
				$userip.="&userip=$userip";
			}	
			if($regdate!='all' && is_numeric($regdate)){
				$urladd.="&regdate=$regdate";
			}
			if($lastlogin!='all' && is_numeric($lastlogin)){
				$urladd.="&lastlogin=$lastlogin";
			}
			if($order){
				$urladd.="&order=$order";
				$asc && $urladd.="&asc=$asc";
			}
			$urladd.="&perpage=$perpage";
			echo "<meta http-equiv='refresh' content='0;url=admin.php?job=members_search&do=show$urladd'>";
			exit;
		}
	} elseif($_GET['do']=='show') {
		$username=!empty($_GET['username']) ? $_GET['username'] : 0;
		$schname_s=!empty($_GET['schname_s']) ? $_GET['schname_s'] : 0;
		$email=!empty($_GET['email']) ? $_GET['email'] : 0;
		$userip=!empty($_GET['userip']) ? $_GET['userip'] : 0;
		$regdate=!empty($_GET['regdate']) ? $_GET['regdate'] : 0;
		$lastlogin=!empty($_GET['lastlogin']) ? $_GET['lastlogin'] : 0;
		$order=!empty($_GET['order']) ? $_GET['order'] : 0;
		$asc=!empty($_GET['asc']) ? $_GET['asc'] : 0;
		$perpage=!empty($_GET['perpage']) ? $_GET['perpage'] : 100;

		$sqladd='WHERE groupid=0';
		$urladd='';
		if($username){
			$sqladd.=$schname_s==1 ? " AND username LIKE '$username'" : " AND (username LIKE '%$username%')";
			$urladd.=$schname_s==1 ? "&username=$username&schname_s=1" : "&username=$username";
		}
		if($email){
			$sqladd.=" AND (email LIKE '%$email%')";
			$urladd.="&email=$email";
		}
		if($userip){
			$sqladd.=" AND (lastip LIKE '%$userip%')";
			$urladd.="&userip=$userip";
		}	
		if($regdate){
			$schtime=$timestamp-$regdate;
			$sqladd.=" AND regdate<'$schtime'";
			$urladd.="&regdate=$regdate";
		}
		if($lastlogin){
			$schtime=$timestamp-$lastlogin;
			$sqladd.=" AND lastlogin<'$schtime'";
			$urladd.="&lastlogin=$lastlogin";
		}
		if($order){
			$sqladd.=" ORDER BY '$order'";
			$urladd.="&order=$order";
		}
		if($asc){
			$sqladd.=' '.$asc;
			$urladd.="&asc=$asc";
		}
		$urladd.="&perpage=$perpage";

		$rs=get_one("SELECT COUNT(*) AS count FROM duoxun_members $sqladd");
		$num=$rs['count'];
		$pages=ceil($num/$perpage);
		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;
		}
		$query=query("SELECT * FROM duoxun_members $sqladd LIMIT $start,$perpage");
		while($rs=fetch_array($query)) {
			$catedb[]=$rs;
		}
		$mpurl="admin.php?job=members_search&do=show$urladd";
		$fenye=admin_fenye($num,$perpage,$page,$mpurl,0);

		$u='admin.php?'.$_SERVER['QUERY_STRING'];
		setcookie('u','',$timestamp-86400);
		setcookie('u',$u,$timestamp+86400);
	}
}

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

?>