Changeset 4608 for temp/trunk/html/forgot

Timestamp:

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

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/forgot/index.php (modified) (3 diffs)

temp/trunk/html/forgot/index.php

@@ -25 +25 @@
     //¥á¥¢¥ÉÆþÎÏ»þ
     $_POST['email'] = strtolower($_POST['email']);
-    $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND status = 2 AND delete = 0";
+    $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND status = 2 AND del_flg = 0";
     $result = $conn->getAll($sql, array($_POST['email']) );
     
@@ -36 +36 @@
         $objPage->tpl_mainpage = 'forgot/secret.tpl';
     } else {
-        $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? AND status = 1 AND delete = 0";    //²¾ÅÐÏ¿Ãæ¤Î³Îǧ
+        $sql = "SELECT customer_id FROM dtb_customer WHERE email ILIKE ? AND status = 1 AND del_flg = 0";   //²¾ÅÐÏ¿Ãæ¤Î³Îǧ
         $result = $conn->getAll($sql, array($_POST['email']) );
         if ($result) {
@@ -51 +51 @@
         // ¥Ò¥ß¥Ä¤ÎÅú¤¨¤Î²óÅú¤¬Àµ¤·¤¤¤«¥Á¥§¥Ã¥¯
         
-        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND delete = 0";
+        $sql = "SELECT * FROM dtb_customer WHERE email ILIKE ? AND del_flg = 0";
         $result = $conn->getAll($sql, array($_SESSION['forgot']['email']) );
         $data = $result[0];