Changeset 22580

Timestamp:

2013/02/22 14:28:41 (11 years ago)

Author:

habu

Message:

#2159 意味が無いLIKE

File:

• branches/version-2_12-dev/data/class/pages/forgot/LC_Page_Forgot.php (modified) (2 diffs)

branches/version-2_12-dev/data/class/pages/forgot/LC_Page_Forgot.php

@@ -155 +155 @@
         $errmsg = NULL;
         $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $where = '(email Like ? OR email_mobile Like ?) AND name01 Like ? AND name02 Like ? AND del_flg = 0';
+        $where = '(email = ? OR email_mobile = ?) AND name01 = ? AND name02 = ? AND del_flg = 0';
         $arrVal = array($arrForm['email'], $arrForm['email'], $arrForm['name01'], $arrForm['name02']);
         $result = $objQuery->select('reminder, status', 'dtb_customer', $where, $arrVal);
@@ -205 +205 @@
         $cols = 'customer_id, reminder, reminder_answer, salt';
         $table = 'dtb_customer';
-        $where = '(email Like ? OR email_mobile Like ?)'
-                    . ' AND name01 Like ? AND name02 Like ?'
+        $where = '(email = ? OR email_mobile = ?)'
+                    . ' AND name01 = ? AND name02 = ?'
                     . ' AND status = 2 AND del_flg = 0';
         $arrVal = array($arrForm['email'], $arrForm['email'],