ecshop后台增加栏目查询会员是否重复注册_ecshop教程_php教程

ecshop的后台要查询哪些会员是否有重复注册时，可以利用特定的栏目来判断~ 譬如会员电话...

修改前请务必先备份下列档案!!!

admin/users.php
admin/templates/users_list.htm
languages/zh_cn/admin/users.php

开启 admin/users.php
找到

$ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) ."%'";

复制代码

替换

//$ex_where .= " AND user_name LIKE '%" . mysql_like_quote($filter['keywords']) ."%'";
$ex_where .= " AND (user_name LIKE '%" . mysql_like_quote($filter['keywords']) ."%' ";
$ex_where .= " OR email LIKE '%" . mysql_like_quote($filter['keywords']) ."%' ";
$ex_where .= " OR mobile_phone LIKE '%" . mysql_like_quote($filter['keywords']) ."%' ";
$ex_where .= " OR office_phone LIKE '%" . mysql_like_quote($filter['keywords']) ."%' ";
$ex_where .= " OR home_phone LIKE '%" . mysql_like_quote($filter['keywords']) ."%' ";
$ex_where .= " OR msn LIKE '%" . mysql_like_quote($filter['keywords']) ."%' ";
$ex_where .= " OR qq LIKE '%" . mysql_like_quote($filter['keywords']) ."%' ";
$ex_where .= ") ";

复制代码

此步骤为搜寻会员栏位(名称、邮件、手机、公司电话、家用电话、MSN、QQ...)
实际栏位还是得依你的资料表(ecs_users)为主，把想调整的栏位加进去即可... 需留意的是行2及行行9是不能删除的!
存档後关闭上传

开启 admin/templates/users_list.htm
找到