[phpBB Debug] PHP Warning: in file [ROOT]/includes/crs/crs_misc_functions.php on line 37: mime_content_type(): Empty filename or path
[phpBB Debug] PHP Warning: in file [ROOT]/includes/crs/crs_misc_functions.php on line 37: mime_content_type(): Empty filename or path
Zen Cart 源代码 functions_gvcoupons.php

Zen Cart 源代码 functions_gvcoupons.php




下载文件

文件名: functions_gvcoupons.php
文件类型: PHP文件
文件大小: 2.79 KiB
MD5: d5d4e7aca68a939adecaae2e101290f9

functions_gvcoupons.php - 关闭高亮
  1. <?php
  2. /**
  3.  * functions_gvcoupons.php
  4.  * Functions related to processing Gift Vouchers/Certificates and coupons
  5.  *
  6.  * @package functions
  7.  * @copyright Copyright 2003-2008 Zen Cart Development Team
  8.  * @copyright Portions Copyright 2003 osCommerce
  9.  * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
  10.  * @version $Id: functions_gvcoupons.php 8844 2008-07-05 03:47:09Z drbyte $
  11.  */
  12.  
  13. ////
  14. // Update the Customers GV account
  15.   function zen_gv_account_update($c_id, $gv_id) {
  16.     global $db;
  17.     $customer_gv_query = "select amount
  18.                          from " . TABLE_COUPON_GV_CUSTOMER . "
  19.                          where customer_id = '" . (int)$c_id . "'";
  20.  
  21.     $customer_gv = $db->Execute($customer_gv_query);
  22.     $coupon_gv_query = "select coupon_amount
  23.                        from " . TABLE_COUPONS . "
  24.                        where coupon_id = '" . (int)$gv_id . "'";
  25.  
  26.     $coupon_gv = $db->Execute($coupon_gv_query);
  27.  
  28.     if ($customer_gv->RecordCount() > 0) {
  29.  
  30.       $new_gv_amount = $customer_gv->fields['amount'] + $coupon_gv->fields['coupon_amount'];
  31.       $gv_query = "update " . TABLE_COUPON_GV_CUSTOMER . "
  32.                   set amount = '" . $new_gv_amount . "' where customer_id = '" . (int)$c_id . "'";
  33.  
  34.       $db->Execute($gv_query);
  35.  
  36.     } else {
  37.  
  38.       $gv_query = "insert into " . TABLE_COUPON_GV_CUSTOMER . "
  39.                                   (customer_id, amount)
  40.                          values ('" . (int)$c_id . "', '" . $coupon_gv->fields['coupon_amount'] . "')";
  41.  
  42.       $db->Execute($gv_query);
  43.     }
  44.   }
  45.  
  46.     function zen_user_has_gv_account($c_id) {
  47.       global $db;
  48.       if ($_SESSION['customer_id']) {
  49.         $gv_result = $db->Execute("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . (int)$c_id . "'");
  50.         if ($gv_result->RecordCount() > 0) {
  51.           if ($gv_result->fields['amount'] > 0) {
  52.             return $gv_result->fields['amount'];
  53.           }
  54.         }
  55.         return '0.00';
  56.       } else {
  57.         return '0.00';
  58.       }
  59.     }
  60.  
  61. ////
  62. // Create a Coupon Code. length may be between 1 and 16 Characters
  63. // $salt needs some thought.
  64.  
  65.   function zen_create_coupon_code($salt="secret", $length = SECURITY_CODE_LENGTH) {
  66.     global $db;
  67.     $ccid = md5(uniqid("", $salt));
  68.     $ccid .= md5(uniqid("", $salt));
  69.     $ccid .= md5(uniqid("", $salt));
  70.     $ccid .= md5(uniqid("", $salt));
  71.     srand((double)microtime()*1000000); // seed the random number generator
  72.     $random_start = @rand(0, (128-$length));
  73.     $good_result = 0;
  74.     while ($good_result == 0) {
  75.       $id1=substr($ccid, $random_start,$length);
  76.       $query = "select coupon_code
  77.                from " . TABLE_COUPONS . "
  78.                where coupon_code = '" . $id1 . "'";
  79.  
  80.       $rs = $db->Execute($query);
  81.  
  82.       if ($rs->RecordCount() == 0) $good_result = 1;
  83.     }
  84.     return $id1;
  85.   }
  86. ?>