X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fmailid_functions.php;h=7d1aeb7f14a737d877f6c78b7e8f3a4065a85c83;hp=c56b8614669811d0cf53a31a2941ab7d97c2bef3;hb=155492a5b96cec674846973a8524238b0365a848;hpb=da5c63bacddced77a951cbe7b223f314885a6c87;ds=sidebyside

diff --git a/inc/libs/mailid_functions.php b/inc/libs/mailid_functions.php
index c56b861466..7d1aeb7f14 100644
--- a/inc/libs/mailid_functions.php
+++ b/inc/libs/mailid_functions.php
@@ -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__);
 }