X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-earning.php;h=608078b99ecd0432d1799b8a2672aa26046f90ad;hb=5b90ab389309595fde01542842169d6cbd2fc562;hp=af3ea8b5aad64e0db2a47cc57d564a51917cfebc;hpb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86;p=mailer.git

diff --git a/inc/modules/member/what-earning.php b/inc/modules/member/what-earning.php
index af3ea8b5aa..608078b99e 100644
--- a/inc/modules/member/what-earning.php
+++ b/inc/modules/member/what-earning.php
@@ -56,7 +56,7 @@ if (isFormSent()) {
 } // END - if
 
 // Check for all earnings
-$result = SQL_QUERY('SELECT
+$result = sqlQuery('SELECT
 	`d`.`earning_id`,
 	`d`.`earning_group`,
 	`d`.`earning_provider`
@@ -66,14 +66,14 @@ ORDER BY
 	`d`.`earning_sorting` ASC', __FILE__, __LINE__);
 
 // Are there entries?
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNums($result)) {
 	// Init output
 	$OUT = '';
 
 	// List all entries
-	while ($content = SQL_FETCHARRAY($result)) {
+	while ($content = sqlFetchArray($result)) {
 		// Load user_earning data
-		$result2 = SQL_QUERY_ESC('SELECT
+		$result2 = sqlQueryEscaped('SELECT
 	`u`.`earning_active`,
 	UNIX_TIMESTAMP(`u`.`earning_added`) AS `earning_added`,
 	UNIX_TIMESTAMP(`u`.`earning_canceled`) AS `earning_canceled`,
@@ -91,13 +91,13 @@ LIMIT 1',
 			), __FILE__, __LINE__);
 
 		// Is there an entry?
-		if (SQL_NUMROWS($result2) == 1) {
+		if (sqlNumRows($result2) == 1) {
 			// Load it
-			$content = merge_array($content, SQL_FETCHARRAY($result2));
+			$content = merge_array($content, sqlFetchArray($result2));
 		} // END - if
 
 		// Free result
-		SQL_FREERESULT($result2);
+		sqlFreeResult($result2);
 
 		// Is there user_earning data available?
 		if (!isset($content['earning_active'])) {
@@ -117,7 +117,7 @@ LIMIT 1',
 }
 
 // Free result
-SQL_FREERESULT($result);
+sqlFreeResult($result);
 
 // [EOF]
 ?>