Renamed ifSqlHasZeroNums() to ifSqlHasZeroNumRows() and improved some queries.

[mailer.git] / inc / libs / mailid_functions.php

diff --git a/inc/libs/mailid_functions.php b/inc/libs/mailid_functions.php
index 4ec9092ddf1fd4f35f0b4ae1fdd865d6151a6b3f..b7c66af82c141d2f9ba5f4b016b5e97c772aa327 100644 (file)
--- a/inc/libs/mailid_functions.php
+++ b/inc/libs/mailid_functions.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2015 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -93,7 +93,7 @@ function doMailIdAdd ($data) {
        // @TODO Rewrite this to a filter
        switch ($data['link_type']) {
                case 'NORMAL':
-                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1",
+                       sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1",
                                array(bigintval($data['id'])), __FILE__, __LINE__);
 
                        // Update mediadata as well
@@ -104,7 +104,7 @@ function doMailIdAdd ($data) {
                        break;
 
                case 'BONUS':
-                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_bonus` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1",
+                       sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_bonus` SET `clicks`=`clicks`+1 WHERE `id`=%s LIMIT 1",
                                array(bigintval($data['id'])), __FILE__, __LINE__);
 
                        // Update mediadata as well
@@ -123,13 +123,13 @@ function doMailIdAdd ($data) {
        // @TODO Rewrite these blocks to filter
        if (isExtensionInstalledAndNewer('user', '0.1.2')) {
                // Update counter
-               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `mails_confirmed`=`mails_confirmed`+1 WHERE `userid`=%s LIMIT 1",
+               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `mails_confirmed`=`mails_confirmed`+1 WHERE `userid`=%s LIMIT 1",
                        array(bigintval($data['userid'])), __FILE__, __LINE__);
 
                // Update random confirmed as well?
                if ((isExtensionInstalledAndNewer('user', '0.3.4')) && (isRandomReferralIdEnabled())) {
                        // Update second counter
-                       SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `rand_confirmed`=`rand_confirmed` + 1 WHERE `userid`=%s LIMIT 1",
+                       sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `rand_confirmed`=`rand_confirmed` + 1 WHERE `userid`=%s LIMIT 1",
                                array(bigintval($data['userid'])), __FILE__, __LINE__);
                } // END - if
        } // END - if
@@ -152,7 +152,7 @@ function doMailIdAdd ($data) {
                } // END - if
 
                // Count down ref_payout value
-               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ref_payout`=`ref_payout`-1 WHERE `userid`=%s AND `ref_payout` > 0 LIMIT 1",
+               sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `ref_payout`=`ref_payout`-1 WHERE `userid`=%s AND `ref_payout` > 0 LIMIT 1",
                        array(bigintval($data['userid'])), __FILE__, __LINE__);
 
                // Add points
@@ -197,7 +197,7 @@ function doMailIdAdd ($data) {
        }
 
        // Remove link from table
-       SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `id`=%s LIMIT 1",
+       sqlQueryEscaped("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `id`=%s LIMIT 1",
                array(bigintval($data['link_id'])), __FILE__, __LINE__);
 }
 
@@ -218,7 +218,6 @@ function doMailIdConfirm ($data) {
                        $templ = 'mailid_enter_code';
                } else {
                        // Disabled code
-                       $data['real_code'] = $realCode;
                        $templ = 'mailid_confirm_buttom';
                }