X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-guest_add.php;h=bd90a45c389b842fabddf8dfe8e33625f2520230;hp=fd1e10ed35788e96aec4427bb83c3f6e7f208545;hb=155492a5b96cec674846973a8524238b0365a848;hpb=da5c63bacddced77a951cbe7b223f314885a6c87

diff --git a/inc/modules/admin/what-guest_add.php b/inc/modules/admin/what-guest_add.php
index fd1e10ed35..bd90a45c38 100644
--- a/inc/modules/admin/what-guest_add.php
+++ b/inc/modules/admin/what-guest_add.php
@@ -54,7 +54,7 @@ if (!isFormSent()) {
 	$menus = array(); $titles = array(); $below = array();
 
 	// Get all available main menus
-	$result_menu = SQL_QUERY("SELECT
+	$result_menu = sqlQuery("SELECT
 	`action`, `title`, `sort`
 FROM
 	`{?_MYSQL_PREFIX?}_guest_menu`
@@ -62,10 +62,10 @@ WHERE
 	(`what`='' OR `what` IS NULL)
 ORDER BY
 	`sort` ASC", __FILE__, __LINE__);
-	if (!SQL_HASZERONUMS($result_menu)) {
+	if (!ifSqlHasZeroNums($result_menu)) {
 		// Read menu structure
 		// @TODO Cant this be rewritten?
-		while ($content = SQL_FETCHARRAY($result_menu)) {
+		while ($content = sqlFetchArray($result_menu)) {
 			// Menu actions
 			array_push($menus, $content['action']);
 
@@ -97,7 +97,7 @@ ORDER BY
 		// Load sub menus :)
 		foreach ($menus as $key_main => $value_main) {
 			// Query for sub menus
-			$result = SQL_QUERY_ESC("SELECT
+			$result = sqlQueryEscaped("SELECT
 	`what`, `title`, `sort`
 FROM
 	`{?_MYSQL_PREFIX?}_guest_menu`
@@ -107,14 +107,14 @@ WHERE
 	`what` IS NOT NULL
 ORDER BY `sort` ASC",
 				array($value_main), __FILE__, __LINE__);
-			if (!SQL_HASZERONUMS($result)) {
+			if (!ifSqlHasZeroNums($result)) {
 				// Initialize arrays
 				$menus[$value_main] = array();
 				$titles[$value_main] = array();
 				$below[$value_main] = array();
 
 				// Read menu structure
-				while ($content = SQL_FETCHARRAY($result)) {
+				while ($content = sqlFetchArray($result)) {
 					// Menu actions
 					array_push($menus[$value_main], $content['what']);
 
@@ -145,12 +145,12 @@ ORDER BY `sort` ASC",
 			} // END - if
 
 			// Free memory
-			SQL_FREERESULT($result);
+			sqlFreeResult($result);
 		} // END - foreach
 	} // END - if
 
 	// Free memory
-	SQL_FREERESULT($result_menu);
+	sqlFreeResult($result_menu);
 
 	$OUT = '<select class="form_select" name="sort" size="1">
       <option value="0">{--ADMIN_IS_FIRST_MENU--}</option>';
@@ -181,7 +181,7 @@ ORDER BY `sort` ASC",
 } elseif (!isDemoModeActive()) {
 	// Insert new menu entry
 	if (isPostRequestElementSet('menu')) {
-		SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`, `what`, `title`, `sort`, `visible`, `locked`) VALUES ('%s','%s','%s','%s','%s','%s')",
+		sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`, `what`, `title`, `sort`, `visible`, `locked`) VALUES ('%s','%s','%s','%s','%s','%s')",
 			array(
 				postRequestElement('menu'),
 				postRequestElement('name'),
@@ -191,7 +191,7 @@ ORDER BY `sort` ASC",
 				postRequestElement('active'),
 			), __FILE__, __LINE__);
 	} else {
-		SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`, `title`, `sort`, `visible`, `locked`) VALUES ('%s','%s','%s','%s','%s')",
+		sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`, `title`, `sort`, `visible`, `locked`) VALUES ('%s','%s','%s','%s','%s')",
 			array(
 				postRequestElement('name'),
 				postRequestElement('title'),