Changeset 11648 for branches/dev/html/mobile/magazine

Timestamp:

2007/03/09 10:25:02 (19 years ago)

Author:

uehara

Message:

 

File:

• branches/dev/html/mobile/magazine/confirm.php (modified) (3 diffs)

branches/dev/html/mobile/magazine/confirm.php

@@ -144 +144 @@
 
     $objQuery = new SC_Query();
-    $objQuery->insert("dtb_customer_mail", $arrRegist);
 
     //--¡¡´û¤Ë¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¤«¤ÎȽÄê
@@ -165 +164 @@
 
     $sql = "SELECT secret_key FROM dtb_customer_mail WHERE email = ?";
-    return $objConn->getOne($sql, array($email));
+    $uniqid = $objConn->getOne($sql, array($email));
+
+    if ($uniqid == '') {
+        $count = 1;
+        while ($count != 0) {
+            $uniqid = sfGetUniqRandomId("t");
+            $count = $objConn->getOne("SELECT COUNT(*) FROM dtb_customer_mail WHERE secret_key = ?", array($uniqid));
+        }
+
+        $objQuery = new SC_Query();
+        $objQuery->update("dtb_customer_mail", array('secret_key' => $uniqid), "email = '" .addslashes($email). "'");
+    }
+
+    return $uniqid;
 }
 
@@ -176 +188 @@
 
     // NULL¤â¹ØÆɤȤߤʤ¹
-    if (count($mailResult) == 0 or ($mailResult[1] != null and $mailResult[1] <= 2 )) {
+    if (count($mailResult) == 0 or ($mailResult[1] != null and $mailResult[1] != 2 )) {
         return false;
     } else {