Changeset 11571

Timestamp:

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

Author:

uehara

Message:

 

Location:

branches/dev/html

Files:

• mypage/change.php (modified) (1 diff)
• regist/index.php (modified) (2 diffs)

branches/dev/html/mypage/change.php

@@ -272 +272 @@
 
     //¥á¥ë¥Þ¥¬¥Õ¥é¥°¼èÆÀ
-    $arrForm['mail_flag'] = $objQuery->get("dtb_customer_mail","mail_flag","email=?", array($objCustomer->getValue('email')));
+    //$arrForm['mail_flag'] = $objQuery->get("dtb_customer_mail","mail_flag","email=?", array($objCustomer->getValue('email')));
     
     //ÃÂÀ¸Æü¤Îǯ·îÆü¼èÆÀ

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");