X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-guest_add.php;h=bd90a45c389b842fabddf8dfe8e33625f2520230;hb=6b1e55213d76a67e9aa3d9f1e4dcb55e0bbf12ee;hp=8e7c9ca55c964d39060d4f1bca025eb32f3ca52a;hpb=63f159414369b5ea19a8ca75d8cd8033c45d8341;p=mailer.git

diff --git a/inc/modules/admin/what-guest_add.php b/inc/modules/admin/what-guest_add.php
index 8e7c9ca55c..bd90a45c38 100644
--- a/inc/modules/admin/what-guest_add.php
+++ b/inc/modules/admin/what-guest_add.php
@@ -16,7 +16,7 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2012 by Mailer Developer Team                   *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
  * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
@@ -54,18 +54,18 @@ if (!isFormSent()) {
 	$menus = array(); $titles = array(); $below = array();
 
 	// Get all available main menus
-	$result_menu = SQL_QUERY("SELECT
-	`action`,`title`,`sort`
+	$result_menu = sqlQuery("SELECT
+	`action`, `title`, `sort`
 FROM
 	`{?_MYSQL_PREFIX?}_guest_menu`
 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,8 +97,8 @@ ORDER BY
 		// Load sub menus :)
 		foreach ($menus as $key_main => $value_main) {
 			// Query for sub menus
-			$result = SQL_QUERY_ESC("SELECT
-	`what`,`title`,`sort`
+			$result = sqlQueryEscaped("SELECT
+	`what`, `title`, `sort`
 FROM
 	`{?_MYSQL_PREFIX?}_guest_menu`
 WHERE
@@ -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>';
@@ -177,11 +177,11 @@ ORDER BY `sort` ASC",
 	$content['action_selection'] = adminAddMenuSelectionBox('guest', 'action', 'menu');
 
 	// Display form
-	loadTemplate('admin_add_guest_menu', false, $content);
+	loadTemplate('admin_add_guest_menu', FALSE, $content);
 } 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'),