Changeset 11571 for branches/dev/html/regist/index.php

Timestamp:

2007/03/07 16:14:48 (20 years ago)

Author:

uehara

Message:

 

File:

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

branches/dev/html/regist/index.php

@@ -112 +112 @@
     */
 
-    $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));
     
@@ -118 +118 @@
     // ²¾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;
-        break;
-    }
-
-    $objConn->autoExecute("dtb_customer_mail", $arrRegistMail, "email = '" .addslashes($email). "'");
+        $arrRegistMail["mailmaga_flg"] = $result;
+        break;
+    }
+
+    $objConn->update("dtb_customer", $arrRegistMail, "email = '" .addslashes($email). "' AND del_flg = 0");
     $objConn->query("COMMIT");