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
找到
{$lang.label_user_name}
替換
{$lang.label_search}
存檔後關閉上傳
開啟 languages/zh_cn/admin/users.php
找到
$_LANG['label_rank_name'] = '...';
下面加入
$_LANG['label_search'] = '搜尋會員';
存檔後關閉上傳
新聞熱點
疑難解答