Changeset 11672

Timestamp:

2007/03/09 13:32:09 (17 years ago)

Author:

uehara

Message:

 

File:

• branches/dev/html/mobile/regist/index.php (modified) (2 diffs)

branches/dev/html/mobile/regist/index.php

@@ -107 +107 @@
     */
 
-    $sql = "SELECT mail_flag FROM dtb_customer_mail WHERE email = ?";
+    $sql = "SELECT mailmaga_flg FROM dtb_customer WHERE email = ?";
     $result = $objConn->getOne($sql, array($email));
     
@@ -113 +113 @@
     // ²¾HTML
     case '4':
-        $arrRegistMail["mail_flag"] = 1;
+        $arrRegistMail["mailmaga_flg"] = 1;
         break;
     // ²¾TEXT
     case '5':
-        $arrRegistMail["mail_flag"] = 2;
+        $arrRegistMail["mailmaga_flg"] = 2;
         break;
     // ²¾¤Ê¤·
     case '6':
-        $arrRegistMail["mail_flag"] = 3;
+        $arrRegistMail["mailmaga_flg"] = 3;
         break;
     default:
-        $arrRegistMail["mail_flag"] = $result;
+        $arrRegistMail["mailmaga_flg"] = $result;
         break;
     }
 
-    $objConn->autoExecute("dtb_customer_mail", $arrRegistMail, "email = '" .addslashes($email). "'");
+    $objQuery->update("dtb_customer", $arrRegistMail, "email = '" .addslashes($email). "' AND del_flg = 0");
     $objConn->query("COMMIT");