Changeset 16972 for branches/beta/data/lib/slib.php

Timestamp:

2008/01/11 12:54:22 (15 years ago)

Author:

satou

Message:

#160 会員登録時付与ポイントが反映されない不具合を改修

File:

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

branches/beta/data/lib/slib.php

@@ -1342 +1342 @@
     }
     return $ret;
+}
+
+/* ²ñ°÷ÅÐÏ¿¥Ý¥¤¥ó¥ÈÉÕÍ¿ */
+function sfSetWelcomePoint($secret_key, $CONF) {
+    $objQuery = new SC_Query();
+    
+    // ¥Ý¥¤¥ó¥ÈÉÕÍ¿
+    $col = "point";
+    $where = "secret_key = ? AND status = 2";
+    $arrRet = $objQuery->select($col, "dtb_customer", $where, array($secret_key));
+    $sqlval['point'] = $arrRet[0]['point'] + $CONF['welcome_point'];
+    
+    // ¥Ý¥¤¥ó¥È¤¬ÉÔ­¤·¤Æ¤¤¤ë¾ì¹ç
+    if($sqlval['point'] < 0) {
+        $objQuery->rollback();
+        sfDispSiteError(LACK_POINT);
+    }
+    
+    $objQuery->update("dtb_customer", $sqlval, $where, array($secret_key));
 }