Changeset 4608 for temp/trunk/data/class/SC_Customer.php

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/class/SC_Customer.php (modified) (3 diffs)

temp/trunk/data/class/SC_Customer.php

@@ -46 +46 @@
     function getCustomerDataFromEmailPass( $pass, $email ) {
         // ËÜÅÐÏ¿¤µ¤ì¤¿²ñ°÷¤Î¤ß
-        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND delete = 0 AND status = 2";
+        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2";
         $result = $this->conn->getAll($sql, array($email));
         $data = $result[0];
@@ -62 +62 @@
     function setLogin($email) {
         // ËÜÅÐÏ¿¤µ¤ì¤¿²ñ°÷¤Î¤ß
-        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND delete = 0 AND status = 2";
+        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0 AND status = 2";
         $result = $this->conn->getAll($sql, array($email));
         $data = $result[0];
@@ -71 +71 @@
     // ¥»¥Ã¥·¥ç¥ó¾ðÊó¤òºÇ¿·¤Î¾ðÊó¤Ë¹¹¿·¤¹¤ë
     function updateSession() {
-        $sql = "SELECT * FROM dtb_customer WHERE customer_id = ? AND delete = 0";
+        $sql = "SELECT * FROM dtb_customer WHERE customer_id = ? AND del_flg = 0";
         $customer_id = $this->getValue('customer_id');
         $arrRet = $this->conn->getAll($sql, array($customer_id));