⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 members.php

📁 全新且完善的强大网上商店系统
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<?php

/*
  [SOOBIC!] admin/members.php 

	Version: 1.5
	Author: soolan (soolan@qq.com)
	Copyright: soolan (www.soobic.com)
	Last Modified: 2005/4/1 10:00

*/


if(!defined("IN_SOOBIC")) {
	exit("Access Denied");
}

cpheader();

if($act == 'addmember') {

	if(!$addsubmit) {

?>
<br><form method="post" action="<?=tep_href_link('admincp.php','act=addmember')?>">
<table cellspacing="0" cellpadding="0" border="0" width="100%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">

<tr><td class="header" colspan="2">添加新用户</td></tr>

<tr><td bgcolor="<?=ALTBG1?>">头衔：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><select name="newstatus">
<option value="Member">正式会员</option>
<option value="Admin">管理员</option>
<option value="ViceAdmin">副管理员</option>
<option value="Operator">操作员</option>
</td></tr>

<tr><td bgcolor="<?=ALTBG1?>">用户姓名：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="text" name="newname"></td></tr>

<tr><td bgcolor="<?=ALTBG1?>">Email：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="text" name="newemail"></td></tr>

<tr><td bgcolor="<?=ALTBG1?>">密码：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="text" name="newpassword"></td></tr>

<tr><td bgcolor="<?=ALTBG1?>">发送通知到上述地址：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="checkbox" name="emailnotify" value="yes" checked></td></tr>

</table></td></tr></table>
<br><center><input type="submit" name="addsubmit" value="添加用户"></center>
</form>
<?

	} else {

		if(!trim($newpassword)) {
			cpmsg('您没有填写用户密码，请返回修改。');
		}

		if(!trim($newemail)) {
			 cpmsg('您没有填写 Email 地址，请返回修改。');
		}
    
    if (tep_validate_email($newemail) == false) {
        cpmsg(ENTRY_EMAIL_ADDRESS_CHECK_ERROR);

    } else {
        $check_email_query = $db->query("select count(*) as total from $table_customers where customers_email_address = '" . safe_input($newemail) . "'");
        $check_email = $db->fetch_array($check_email_query);
        if ($check_email['total'] > 0) {
             $error = true;
             cpmsg(ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
         }
    }
    $sql_data_array = array('customers_firstname' => $name,
                              'customers_email_address' => $newemail,
                              'customers_newsletter' => 1,
                              'status'=>$newstatus, 
                              'customers_password' => md5($newpassword));
                              
		tep_db_perform($table_customers, $sql_data_array);
		
		if($emailnotify == 'yes') {
			tep_mail($name,$newemail,STORE_NAME ,"[SOOBIC!]您被 ".TITLE." 添加为会员", "您好，我是 ".TITLE." 管理员，\n".
				"您已被添加成为我们网上商店的会员，欢迎您用以下账号登录：\n".
				"账号：$newemail\n".
				"密码：$newpassword\n".
				"欢迎光临 ".TITLE." ($shopurl)",STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
		}

		updatecache('settings');
		cpmsg('用户添加成功。');
	}

} elseif($act == 'members') {
	if(!$searchsubmit && !$deletesubmit && !$editsubmit && !$exportsubmit) {

?>
<br><form method="post" action="<?=tep_href_link('admincp.php','act=members')?>">
<table cellspacing="0" cellpadding="0" border="0" width="80%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">

<tr><td class="header" colspan="2">搜索用户</td></tr>

<tr><td bgcolor="<?=ALTBG1?>">直接删除符合条件的用户：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="checkbox" name="deletesubmit" value="1"></td></tr>

<tr><td bgcolor="<?=ALTBG1?>">头衔：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><select name="userstatus">
<option value="">任何头衔</option>
<option value="Admin">管 理 员</option>
<option value="ViceAdmin">副管理员</option>
<option value="MOperator">操作员</option>
<option value="Member">正式会员</option>

</select></td></tr>

<tr><td bgcolor="<?=ALTBG1?>">姓名包含：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="text" name="name" size="40"></td></tr>

<tr><td bgcolor="<?=ALTBG1?>">eamil包含：</td>
<td align="right" bgcolor="<?=ALTBG2?>"><input type="text" name="email" size="40"></td></tr>

</table></td></tr></table><br><center>
<input type="submit" name="searchsubmit" value="搜索用户"> &nbsp; 
<input type="submit" name="deletesubmit" value="删除用户"> &nbsp; 
<input type="submit" name="exportsubmit" value="导出 Email"></center></form>
<?

	} elseif($searchsubmit || $deletesubmit || $exportsubmit) {

		if(!$page) {
			$page = 1;
		}
		$offset = ($page - 1) * MAX_DISPLAY_SEARCH_RESULTS;

		$conditions = "";
		$conditions .= $name != "" ? " AND (customers_firstname LIKE '%$name%' OR customers_firstname='$name')" : NULL;
		$conditions .= $email != "" ? " AND (customers_email_address LIKE '%$email%' OR customers_email_address='$email')" : NULL;
		$conditions .= $userstatus != "" ? " AND status='$userstatus'" : NULL;

		if($conditions) {

			$conditions = substr($conditions, 5);
			if($searchsubmit) {
				$query = $db->query("SELECT COUNT(*) FROM $table_customers WHERE $conditions");
				$num = $db->result($query, 0);
				$multipage = multi($num, MAX_DISPLAY_SEARCH_RESULTS, $page, "admincp.php?act=members&searchsubmit=yes&name=$name&email=$email&userstatus=$userstatus");

				$query = $db->query("SELECT * FROM $table_customers WHERE $conditions LIMIT $offset, ".MAX_DISPLAY_SEARCH_RESULTS);
				while($member = $db->fetch_array($query)) {
					$select = array($member[status] => "selected=\"selected\"");
					$members .= "<tr align=\"center\" bgcolor=\"".ALTBG2."\" align=\"center\">\n".
						"<td><input type=\"checkbox\" name=\"delete[]\" value=\"$member[customers_id]\"></td>\n".
						"<td>$member[customers_email_address]</td>\n".
						"<td><input type=\"text\" size=\"10\" name=\"namenew[$member[customers_id]]\" value=\"$member[customers_firstname]\"></td>\n".
						"<td><input type=\"text\" size=\"5\" name=\"creditnew[$member[customers_id]]\" value=\"$member[credit]\"> $creditunit</td>\n".
						"<td><input type=\"text\" size=\"10\" name=\"passwdnew[$member[customers_id]]\"></td>\n".
						"<td><select name=\"statusnew[$member[customers_id]]\">\n".
						"<option value=\"Member\">未知头衔</option>\n".
						"<option value=\"Admin\" ".$select['Admin'].">管 理 员</option>\n".
						"<option value=\"ViceAdmin\" ".$select['ViceAdmin'].">副管理员</option>\n".
						"<option value=\"Operator\" ".$select['Operator'].">操作员</option>\n".
						"<option value=\"Member\" ".$select['Member'].">正式会员</option></select></td>\n".
						"<td><a href=\"".tep_href_link('admincp.php','act=memberprofile&customers_email_address='.rawurlencode($member[customers_email_address]))."\">[编辑]</a></tr>\n";
				}
						
?>
<form method="post" action="<?=tep_href_link('admincp.php','act=members')?>">
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td class="multi"><?=$multipage?></td></tr>
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr align="center" class="header">
<td width="45"><input type="checkbox" name="chkall" class="header" onclick="checkall(this.form)">删?</td>
<td>顾客eamil</td><td>用户姓名</td><td>积分</td><td>密码</td><td>系统头衔</td><td>详细</td></tr>
<?=$members?>
</table></td></tr>
<tr><td class="multi"><?=$multipage?></td></tr>
</table><br><center>
<input type="submit" name="editsubmit" value="修改用户资料"></center>
</form>
<?

			} elseif($deletesubmit) {
				if(!$confirmed) {
					cpmsg("本操作不可恢复，您确定要删除符合条件的会员吗？", tep_href_link('admincp.php','act=members&deletesubmit=yes&name='.$name.'&email='.$email.'&userstatus='.$userstatus), "form");
				} else {
					$query = $db->query("DELETE FROM $table_customers WHERE $conditions");
					$numdeleted = $db->affected_rows();
					updatecache('settings');
					cpmsg("符合条件的 $numdeleted 个用户被成功删除。");
				}
			} elseif($exportsubmit) {
				$export = $comma = '';
				$query = $db->query("SELECT customers_firstname,customers_email_address  FROM $table_customers WHERE $conditions");
				while($member = $db->fetch_array($query)) {
					$export .= "$comma$member[customers_firstname] &lt;$member[customers_email_address]&gt;";
					$comma = ', ';
				}

?>
<table cellspacing="0" cellpadding="0" border="0" width="95%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr class="header"><td>用户 Email 地址导出</td></tr>
<tr bgcolor="<?=ALTBG1?>"><td><?=$export?>
</td></tr></table></td></tr></table>
<?

			}
		} else {
			cpmsg("您没有提供搜索的条件，请返回修改。");
		}
	} elseif($editsubmit) {
		if(is_array($delete)) {
			$ids = $comma = '';
			foreach($delete as $id) {
				$ids .= "$comma'$id'";
				$comma = ', ';
			}
			$db->query("DELETE FROM $table_customers WHERE customers_id IN ($ids)");
			//$db->query("DELETE FROM $table_customers_info WHERE customers_id IN ($ids)");
			updatecache('settings');
		}
		if(is_array($statusnew)) {
			foreach($statusnew as $id => $val) {
				$passwdadd = $passwdnew[$id] != "" ? ", customers_password='".md5($passwdnew[$id])."'" : NULL;
				$db->query("UPDATE $table_customers SET status='$statusnew[$id]', credit='$creditnew[$id]' ,customers_firstname='$namenew[$id]' $passwdadd WHERE customers_id='$id'");
				unset($mytemp110, $my_query111, $my_temper);
			}
		}
		cpmsg("符合条件的用户被成功编辑。");
	}

} elseif($act == 'memberprofile') {

	if(!$editsubmit) {

		$customers_email_address = empty($customers_email_address) ? $extr : $customers_email_address;
		$query = $db->query("SELECT * FROM $table_customers WHERE customers_email_address='$customers_email_address'");
		if($member = $db->fetch_array($query)) {

			$check = array($member[status] => "selected=\"selected\"");
			if($member[showemail]) {
					$emailchecked = "checked=\"checked\"";
			}
			if($member[customers_newsletter]) {
				$newschecked = "checked=\"checked\"";
			}

			$regdate = explode("-", gmdate("Y-n-j", $member[regdate] + ($timeoffset * 3600)));
			$lastvisittime = explode("-", gmdate("Y-n-j", $member[lastvisit] + ($timeoffset * 3600)));
			$username = stripslashes($username);
// the next 2 lines fix edit a special username
?>
<form method="post" action="<?=tep_href_link('admincp.php','act=memberprofile&customers_email_address='.rawurlencode($customers_email_address))?>">
<table cellspacing="0" cellpadding="0" border="0" width="90%" align="center">
<tr><td bgcolor="<?=BORDERCOLOR?>">
<table border="0" cellspacing="<?=BORDERWIDTH?>" cellpadding="<?=TABLESPACE?>" width="100%">
<tr><td colspan="2" class="header">编辑顾客资料 - 基本项目</td></tr>

<tr><td bgcolor="<?=ALTBG1?>">系统头衔：</td>
<td bgcolor="<?=ALTBG2?>"><select name="statusnew">
<option value="Member">未知头衔</option>
<option value="Admin" <?=$check[Admin]?>>管 理 员</option>
<option value="ViceAdmin" <?=$check[SuperMod]?>>副管理员</option>
<option value="Operator" <?=$check[Moderator]?>>操作员</option>
<option value="Member" <?=$check[Member]?>>正式会员</option>
</select></td></tr>

<tr><td bgcolor="<?=ALTBG1?>">姓名：</td>
<td bgcolor="<?=ALTBG2?>"><input type="text" name="newname" size="25" value="<?=$member[customers_firstname]?>"></td></tr>

<tr><td bgcolor="<?=ALTBG1?>" width="21%">Email账号：</td>
<td bgcolor="<?=ALTBG2?>"><input type="text" name="emailnew" size="25" value="<?=$member[customers_email_address ]?>">如不是特别需要，请不要修改用户名</td></tr>


<tr><td bgcolor="<?=ALTBG1?>">新密码：</td>
<td bgcolor="<?=ALTBG2?>"><input type="password" name="newpassword" size="25"> 请输入新密码，如果不更改密码此处请留空</td></tr>


</table></td></tr></table><br>
<center><input type="submit" name="editsubmit" value="编辑个人资料"></center>
</form><br>
<?

		} else {
			cpmsg("指定用户不存在。");
		}

	} else {

		if($newpassword) {
			$password = md5($newpassword);
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -