X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=beg.php;fp=beg.php;h=81cb992df91506515a35ccca35dc888c2177bb46;hb=155492a5b96cec674846973a8524238b0365a848;hp=d585e56cfc6a407d95e68b87f0b30c1cd9f07dd7;hpb=da5c63bacddced77a951cbe7b223f314885a6c87;p=mailer.git

diff --git a/beg.php b/beg.php
index d585e56cfc..81cb992df9 100644
--- a/beg.php
+++ b/beg.php
@@ -96,11 +96,11 @@ if (isGetRequestElementSet('userid')) {
 	// User id valid and not webmaster's id?
 	if ((isValidId(getUserData('userid'))) && (getBegUserid() != getUserData('userid'))) {
 		// Update counter
-		SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `beg_clicks`=`beg_clicks`+1 WHERE `userid`=%s LIMIT 1",
+		sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `beg_clicks`=`beg_clicks`+1 WHERE `userid`=%s LIMIT 1",
 			array(getUserData('userid')), __FILE__, __LINE__);
 
 		// Check for last entry for userid w/o IP number                            12              33                               2    23              44            3                                          21     1                              1
-		$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_beg_ips` WHERE ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_timeout?} OR ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_userid_timeout?} AND `userid`=%s)) AND (`remote_ip`='%s' OR `sid`='%s') LIMIT 1",
+		$result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_beg_ips` WHERE ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_timeout?} OR ((UNIX_TIMESTAMP() - `timeout`) >= {?beg_userid_timeout?} AND `userid`=%s)) AND (`remote_ip`='%s' OR `sid`='%s') LIMIT 1",
 			array(
 				getUserData('userid'),
 				determineRealRemoteAddress(),
@@ -109,7 +109,7 @@ if (isGetRequestElementSet('userid')) {
 
 		// Entry not found, points set and not logged in?
 		//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'SQL_HASZERONUMS()=' . intval(SQL_HASZERONUMS($result)) . ',isAdmin()=' . intval(isAdmin()) . ',points=' . $points . ',isMember()=' . intval(isMember()) . ',getBegPayMode()=' . getBegPayMode());
-		if ((SQL_HASZERONUMS($result)) && ($points > 0) && (getBegPayMode() == 'NONE') && ((!isMember()) || (isAdmin()))) {
+		if ((ifSqlHasZeroNums($result)) && ($points > 0) && (getBegPayMode() == 'NONE') && ((!isMember()) || (isAdmin()))) {
 			// Default is result from isAdmin(), mostly false
 			$isPayed = isAdmin();
 
@@ -120,7 +120,7 @@ if (isGetRequestElementSet('userid')) {
 				 * but only when there is no admin begging.
 				 * Admins shall be able to test it!
 				 */
-				SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_beg_ips` (`userid`, `remote_ip`, `sid`, `timeout`) VALUES ('%s','%s','%s', UNIX_TIMESTAMP())",
+				sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_beg_ips` (`userid`, `remote_ip`, `sid`, `timeout`) VALUES ('%s','%s','%s', UNIX_TIMESTAMP())",
 					array(
 						getUserData('userid'),
 						determineRealRemoteAddress(),
@@ -128,7 +128,7 @@ if (isGetRequestElementSet('userid')) {
 					), __FILE__, __LINE__);
 
 				// Was is successfull?
-				$isPayed = (!SQL_HASZEROAFFECTED());
+				$isPayed = (!ifSqlHasZeroAffectedRows());
 			} // END - if
 
 			// Pay points?
@@ -159,7 +159,7 @@ if (isGetRequestElementSet('userid')) {
 		}
 
 		// Free memory
-		SQL_FREERESULT($result);
+		sqlFreeResult($result);
 
 		// Include header
 		loadIncludeOnce('inc/header.php');