adm_members.php

这个版本只是修正了一些BUG

<?php
/************************************************
	adm_members.php

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/08/20
	Modified : 2004/03/31
*************************************************/

require "./common.php";
require "../include/multi.php";
$file_name='./adm_members.php';

if ((!$editsubmit)&&(!$srhsubmit)&&(!$listsubmit))  //未发送表单
{
	if ($action == 'chg')      //修改页面
    	{
 		$query = $db->query("SELECT * FROM $table_members WHERE userid=$userid");
 		if($dbq_rec = $db->fetch_array($query))
        	{
    			$username = $dbq_rec['username']; $password = '';  
    			$email = $dbq_rec['email'];
    			$regdate = gmdate($dateformat,$dbq_rec['regdate']);
            		$regip = $dbq_rec['regip'];
            		$realname=$dbq_rec['realname'];
    			$oicq=$dbq_rec['oicq'];$icq=$dbq_rec['icq'];$msn=$dbq_rec['msn'];
    			$addr=$dbq_rec['addr'];$postalcode=$dbq_rec['postalcode'];
    			$tel=$dbq_rec['tel'];$mobile=$dbq_rec['mobile'];
    			$credits=$dbq_rec['credits'];
  		}
 		 
 		$display = 'edit';
	}
	else  // 查询页面
	{
    		$query=$db->query("select * from $table_groups where status<>'Member' order by groupid");
        	$grouplist=array();
        	while($dbq_rec=$db->fetch_array($query))
        	{
        		$grouplist[]=$dbq_rec;
        	}
        	unset($dbq_rec);unset($query);
  		$display = 'search';
	}
}
elseif ($editsubmit)           //发送表单处理
{
	if ($isdelete == 'ON')
  	{
    		$sqlstr="DELETE FROM $table_members WHERE userid = $userid";
   		if($query = $db->query($sqlstr))		gotourl($language['delsuccess'],$file_name);
    		else						        	gotourl($language['db_err'].":<br>".$sqlstr);
    	}
  	if (empty($password))
  	{
  		$sqlstr="update  $table_members set  username='$username',
    				email='$email',realname='$realname',regip='$regip',
    				oicq='$oicq',icq='$icq',msn='$msn',addr='$addr',postalcode='$postalcode',
    				tel='$tel',mobile='$mobile',credits=$credits 
    				where userid = $userid";
  	}
  	else
    	{
  		$npassword=md5($password);
  		$sqlstr="update	$table_members set  username='$username',password='$npassword',
    				email='$email',realname='$realname',regip='$regip',
    				oicq='$oicq',icq='$icq',msn='$msn',addr='$addr',postalcode='$postalcode',
    				tel='$tel',mobile='$mobile',credits=$credits 
    				where userid = $userid";
  	}
  	if($query = @$db->query($sqlstr,1))
   		gotourl($language['editsuccess'],$file_name."?srhsubmit=yes&srh_username=$username&srh_status=%");
 	else
  		gotourl($language['db_err'].":<br>".$sqlstr);

}
elseif ($srhsubmit)
{
	$reclist = array();
	$condition ="where username like '%$srh_username%'  and status like '$srh_status' ";
	if(!empty($srh_creditslower))  $condition.="and credits >= $srh_creditslower ";
	if(!empty($srh_creditshigher)) $condition.="and credits <= $srh_creditshigher ";
	if(!empty($srh_regip))		    $condition.="and regip like '$srh_regip%'";
    	
    	$query = $db->query("SELECT COUNT(*) FROM $table_members $condition");
	$count=$db->result($query,0);
	$perpage=10;
	if ($count <= $perpage)
	{
		$maxpage=1;
	}
	else
	{
   		$maxpage=($count - ($count % $perpage))/$perpage;
   		$maxpage=$maxpage+1;
	}

	if(!empty($page))
	{
		$start_limit=($page-1) * $perpage;
		$startnum = ($page-1) * $perpage + 1;
		$endnum = $page * $perpage;
	}
	else
	{
		$startnum = 1;
		$endnum = $perpage;
		$start_limit=0;
		$page = 1;
	}

	$multipage = multi($count, $perpage, $page, "adm_members.php?srhsubmit=yes&srh_username=$srh_username&srh_creditslower=$srh_creditslower&srh_creditshigher=$srh_creditshigher&srh_regip=$srh_regip&srh_lastvisit=$srh_lastvisit&srh_status=$srh_status");
	    	
    	$sqlstr="select userid,username,password,status,credits from $table_members ".$condition." LIMIT $start_limit,$perpage";
    	$query = @$db->query($sqlstr,1);
    	while($dbq_rec = @$db->fetch_array($query))
    	{
    		$query1=$db->query("select * from $table_groups where status<>'Member' order by groupid");
        	$status_select="";
        	if($dbq_rec[status]=='Member')  $isselect = "selected";
        	else							 $isselect = "";
        	$status_select.="<option $isselect value='Member'>$language[regmember]</option>";
        	while($dbq_rec1=$db->fetch_array($query1))
        	{
        		if($dbq_rec[status]==$dbq_rec1[status])  $isselect = "selected"; 
        		else    $isselect = "";
        		$status_select.="<option $isselect value='$dbq_rec1[status]'>$dbq_rec1[grouptitle]</option>";
        	}
        	unset($dbq_rec1);unset($query1);
        	$dbq_rec[status_select]=$status_select;
  		$display = 'search';
    		$reclist[] = $dbq_rec;
	}
  	$display = 'list';
}
elseif ($listsubmit)
{
	if(is_array($delete))
    	{
  		$ids = $comma = "";
  		foreach($delete as $id)
        	{
    			$ids .= "$comma'$id'";
			$comma = ", ";
   		}
   		@$db->query("DELETE FROM $table_members WHERE userid IN ($ids)",1);
 		gotourl($language['delsuccess']);
  		exit;
 	}
 	if(is_array($upd_userid))
    	{
    		foreach($upd_userid as $userid)
    		{
    			 
    			if(!empty($upd_password[$userid]))
    			{
    				$new_password=md5($upd_password[$userid]);
    				$sqlstr="update $table_members set password='$new_password',credits=$upd_credits[$userid],status='$upd_status[$userid]' where userid=$userid";
    			}
    			else
    			{
    				$sqlstr="update $table_members set  credits=$upd_credits[$userid],status='$upd_status[$userid]' where userid=$userid";
    			}
    			$query=@$db->query($sqlstr,1);
    		}
    	}
    	gotourl($language['editsuccess']);
 	 
}

include template('member');
?>