Changeset 11411
- Timestamp:
- 2007/02/08 13:54:58 (17 years ago)
- Location:
- temp/branches/mobile
- Files:
-
- 7 edited
Legend:
- Unmodified
- Added
- Removed
-
temp/branches/mobile/data/class/SC_CheckError.php
r10358 r11411 711 711 } 712 712 } 713 714 /*¡¡·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹¤ÎȽÄê¡¡*/ 715 // value[0] = ¹àÌÜ̾ value[1] = ȽÄêÂоݥ᡼¥ë¥¢¥É¥ì¥¹ 716 function MOBILE_EMAIL_CHECK( $value ){ //¡¡¥á¡¼¥ë¥¢¥É¥ì¥¹¤òÀµµ¬É½¸½¤ÇȽÄꤹ¤ë 717 if(isset($this->arrErr[$value[1]])) { 718 return; 719 } 720 if(strlen($this->arrParam[$value[1]]) > 0 && !gfIsMobileMailAddress($this->arrParam[$value[1]])) { 721 $this->arrErr[$value[1]] = "¢¨ " . $value[0] . "¤Ï·ÈÂÓÅÅÏäΤâ¤Î¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£<br />"; 722 } 723 } 713 724 } 714 725 ?> -
temp/branches/mobile/data/class/SC_Customer.php
r11405 r11411 50 50 } 51 51 52 function getCustomerDataFromEmailPass( $pass, $email ) { 52 function getCustomerDataFromEmailPass( $pass, $email, $mobile = false ) { 53 $sql_mobile = $mobile ? ' OR email_mobile ILIKE ?' : ''; 54 $arrValues = array($email); 55 if ($mobile) { 56 $arrValues[] = $email; 57 } 53 58 // ËÜÅÐÏ¿¤µ¤ì¤¿²ñ°÷¤Î¤ß 54 $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ?AND del_flg = 0 AND status = 2";55 $result = $this->conn->getAll($sql, array($email));59 $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ?" . $sql_mobile . ") AND del_flg = 0 AND status = 2"; 60 $result = $this->conn->getAll($sql, $arrValues); 56 61 $data = $result[0]; 57 62 -
temp/branches/mobile/data/class/SC_FormParam.php
r10373 r11411 155 155 case 'DOMAIN_CHECK': 156 156 case 'FILE_NAME_CHECK': 157 case 'MOBILE_EMAIL_CHECK': 157 158 158 159 if(!is_array($this->param[$cnt])) { -
temp/branches/mobile/html/mobile/entry/index.php
r11409 r11411 259 259 $arrRegist["first_buy_date"] = ""; // ºÇ½é¤Î¹ØÆþÆü 260 260 261 // ·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹ 262 $arrRegist['email_mobile'] = $arrRegist['email']; 263 261 264 //-- ²¾ÅÐÏ¿¼Â¹Ô 262 265 $objConn->query("BEGIN"); … … 326 329 $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 327 330 $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 328 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK" ));331 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK")); 329 332 330 333 //¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉÔ²Ä 331 334 if (strlen($array["email"]) > 0) { 332 335 $objQuery = new SC_Query(); 333 $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email ILIKE ? OR DER BY del_flg", array($array["email"]));336 $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email ILIKE ? OR email_mobile ILIKE ? ORDER BY del_flg", array($array["email"], $array["email"])); 334 337 335 338 if(count($arrRet) > 0) { -
temp/branches/mobile/html/mobile/forgot/index.php
r11406 r11411 37 37 //¥á¥¢¥ÉÆþÎÏ»þ 38 38 $_POST['email'] = strtolower($_POST['email']); 39 $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ?AND status = 2 AND del_flg = 0";40 $result = $conn->getAll($sql, array($_POST['email'] ) );39 $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ? OR email_mobile ILIKE ?) AND status = 2 AND del_flg = 0"; 40 $result = $conn->getAll($sql, array($_POST['email'], $_POST['email']) ); 41 41 42 42 if ( $result[0]['reminder'] ){ // Ëܲñ°÷ÅÐÏ¿ºÑ¤ß¤Î¾ì¹ç … … 63 63 // ¥Ò¥ß¥Ä¤ÎÅú¤¨¤Î²óÅú¤¬Àµ¤·¤¤¤«¥Á¥§¥Ã¥¯ 64 64 65 $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ?AND del_flg = 0";66 $result = $conn->getAll($sql, array($_SESSION['forgot']['email'] ) );65 $sql = "SELECT * FROM dtb_customer WHERE (email ILIKE ? OR email_mobile ILIKE ?) AND del_flg = 0"; 66 $result = $conn->getAll($sql, array($_SESSION['forgot']['email'], $_SESSION['forgot']['email']) ); 67 67 $data = $result[0]; 68 68 -
temp/branches/mobile/html/mobile/regist/index.php
r11409 r11411 48 48 $email = $objQuery->get("dtb_customer", "email", "secret_key = ?", array($registSecretKey)); 49 49 $objCustomer->setLogin($email); 50 header("Location: ./complete.php");50 header("Location: " . gfAddSessionId("./complete.php")); 51 51 exit; 52 52 } -
temp/branches/mobile/html/mobile/shopping/deliv.php
r11409 r11411 72 72 // ¥í¥°¥¤¥óȽÄê 73 73 if(!$objCustomer->getCustomerDataFromMobilePhoneIdPass($arrForm['login_pass']) && 74 !$objCustomer->getCustomerDataFromEmailPass($arrForm['login_pass'], $arrForm['login_email'] )) {74 !$objCustomer->getCustomerDataFromEmailPass($arrForm['login_pass'], $arrForm['login_email'], true)) { 75 75 // ²¾ÅÐÏ¿¤ÎȽÄê 76 76 $objQuery = new SC_Query;
Note: See TracChangeset
for help on using the changeset viewer.