Changeset 11577 for branches/dev/data/lib/slib.php

Timestamp:

2007/03/08 09:33:33 (19 years ago)

Author:

uehara

Message:

 

File:

• branches/dev/data/lib/slib.php (modified) (1 diff)

branches/dev/data/lib/slib.php

@@ -1773 +1773 @@
 /* ²ñ°÷¤Î¥á¥ë¥Þ¥¬ÅÐÏ¿¤¬¤¢¤ë¤«¤É¤¦¤«¤Î¥Á¥§¥Ã¥¯(²¾²ñ°÷¤ò´Þ¤Þ¤Ê¤¤) */
 function sfCheckCustomerMailMaga($email) {
-    $col = "T1.email, T1.mail_flag, T2.customer_id";
-    $from = "dtb_customer_mail AS T1 LEFT JOIN dtb_customer AS T2 ON T1.email = T2.email";
-    $where = "T1.email = ? AND T2.status = 2";
+    $col = "email, mailmaga_flg, customer_id";
+    $from = "dtb_customer";
+    $where = "email = ? AND status = 2";
     $objQuery = new SC_Query();
     $arrRet = $objQuery->select($col, $from, $where, array($email));