Introduced padLeftZero()

[mailer.git] / inc / modules / admin / what-send_coupon.php

diff --git a/inc/modules/admin/what-send_coupon.php b/inc/modules/admin/what-send_coupon.php
index f259265150ec1476edc952c4fb1cff8c1da3ddca..5d8ec24a8254d25303bb63603161de92747f47bd 100644 (file)
--- a/inc/modules/admin/what-send_coupon.php
+++ b/inc/modules/admin/what-send_coupon.php
@@ -72,7 +72,7 @@ ORDER BY
                        $expirationTime = time() + createEpocheTimeFromSelections('coupon_default_time', postRequestArray());
 
                        // Insert coupon data
-                       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_coupon_data` (`coupon_expired`,`total_created`,`points`,`coupon_description`) VALUES ('{%%pipe,SQL_EPOCHE_TO_TIMESTAMP=%s%%}', %s,%s,'%s')",
+                       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_coupon_data` (`coupon_expired`, `total_created`, `points`, `coupon_description`) VALUES ('{%%pipe,SQL_EPOCHE_TO_TIMESTAMP=%s%%}', %s,%s,'%s')",
                                array(
                                        $expirationTime,
                                        SQL_NUMROWS($result),
@@ -84,27 +84,33 @@ ORDER BY
                        // Get the insert id from the table
                        $couponId = SQL_INSERTID();
 
+                       // Init userid array
+                       $adminUserids = array();
+
                        // Load entry
                        while (list($userid) = SQL_FETCHROW($result)) {
+                               // Debug message
+                               //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'NUMS=' . SQL_NUMROWS($result) . ',userid=' . $userid);
+
                                // By default no code is unique
-                               $isUnique = false;
+                               $isUnique = FALSE;
                                $couponCode = '';
 
                                // Look for a unique id
                                while (!$isUnique) {
                                        /*
-                                        * Add a coupon for this user, first we need to create a
-                                        * table-unique "id". The function generatePassword() can do
-                                        * this job for us but we want to exclude some characters.
+                                        * Add a coupon for this user, first generate a
+                                        * "table-unique" id number. generatePassword() can do this
+                                        * but with some characters excluded.
                                         */
                                        $couponCode = generatePassword(30, array('-', '+', '_', '/', '.'));
 
                                        // Is it really unique?
-                                       $isUnique = (countSumTotalData($couponCode, 'user_coupons', 'id', 'coupon_code', true) == 0);
+                                       $isUnique = (countSumTotalData($couponCode, 'user_coupons', 'id', 'coupon_code', TRUE) == 0);
                                } // END - while
 
                                // The above loop should always set $couponCode, so we can now insert it
-                               SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_coupons` (`coupon_id`,`userid`,`coupon_code`) VALUES (%s,%s,'%s')",
+                               SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_coupons` (`coupon_id`, `userid`, `coupon_code`) VALUES (%s,%s,'%s')",
                                        array(
                                                $couponId,
                                                $userid,
@@ -158,7 +164,7 @@ ORDER BY
        $content['coupon_default_time_selection'] = createConfigurationTimeSelections('coupon_default_time', 'WDh');
 
        // Load template
-       loadTemplate('admin_send_coupon', false, $content);
+       loadTemplate('admin_send_coupon', FALSE, $content);
 }
 
 // [EOF]