X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_network_request_params.php;h=1f2487e30bae5e2121f871bc711688345797b340;hb=e5527fd38a6585c8466dc28d013f12d21eb7c07a;hp=aa369cd69c63d113795f3773e0a451a132fb7161;hpb=7052cc3bd3ca07281078acbbce6ce595d753def1;p=mailer.git

diff --git a/inc/modules/admin/what-list_network_request_params.php b/inc/modules/admin/what-list_network_request_params.php
index aa369cd69c..1f2487e30b 100644
--- a/inc/modules/admin/what-list_network_request_params.php
+++ b/inc/modules/admin/what-list_network_request_params.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 *
@@ -64,7 +64,7 @@ if ($GLOBALS['network_display'] === FALSE) {
 // Is there a network selected?
 if (isGetRequestElementSet('network_id')) {
 	// Get its data for template
-	$networkData = getNetworkDataById(getRequestElement('network_id'));
+	$networkData = getNetworkDataFromId(getRequestElement('network_id'));
 	$networkData['network_type_id'] = 0;
 
 	// Init disabled list
@@ -74,7 +74,7 @@ if (isGetRequestElementSet('network_id')) {
 	$ADD = '';
 	if ((isPostRequestElementSet('network_type_id')) && (!is_array(postRequestElement('network_type_id')))) {
 		// Only show from current type handler
-		$ADD = sprintf(" AND p.`network_type_id`=%s", bigintval(postRequestElement('network_type_id')));
+		$ADD = sprintf(" AND `p`.`network_type_id`=%s", bigintval(postRequestElement('network_type_id')));
 
 		// Overwrite type id
 		$networkData['network_type_id'] = bigintval(postRequestElement('network_type_id'));
@@ -84,31 +84,31 @@ if (isGetRequestElementSet('network_id')) {
 	} // END - if
 
 	// Load all advert types for given network
-	$result = SQL_QUERY_ESC("SELECT
-	p.`network_request_param_id`,
-	t.`network_type_id`,
-	t.`network_type_handler`,
-	p.`network_request_param_key`,
-	p.`network_request_param_value`,
-	p.`network_request_param_default`
+	$result = sqlQueryEscaped("SELECT
+	`p`.`network_request_param_id`,
+	`t`.`network_type_id`,
+	`t`.`network_type_handler`,
+	`p`.`network_request_param_key`,
+	`p`.`network_request_param_value`,
+	`p`.`network_request_param_default`
 FROM
-	`{?_MYSQL_PREFIX?}_network_request_params` AS p
+	`{?_MYSQL_PREFIX?}_network_request_params` AS `p`
 INNER JOIN
-	`{?_MYSQL_PREFIX?}_network_types` AS t
+	`{?_MYSQL_PREFIX?}_network_types` AS `t`
 ON
-	p.`network_type_id`=t.`network_type_id`
+	`p`.`network_type_id`=`t`.`network_type_id`
 WHERE
-	p.`network_id`=%s" . $ADD . "
+	`p`.`network_id`=%s" . $ADD . "
 ORDER BY
-	t.`network_type_handler` ASC,
-	p.`network_request_param_id` ASC",
+	`t`.`network_type_handler` ASC,
+	`p`.`network_request_param_id` ASC",
 		array(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__);
 
 	// Are there entries?
-	if (!SQL_HASZERONUMS($result)) {
+	if (!ifSqlHasZeroNums($result)) {
 		// List all entries
 		$OUT = '';
-		while ($row = SQL_FETCHARRAY($result)) {
+		while ($row = sqlFetchArray($result)) {
 			// Add it to network if the type matches selected
 			if ($row['network_type_id'] == postRequestElement('network_type_id')) {
 				// Matches, then add it for disabling this entry
@@ -133,13 +133,19 @@ ORDER BY
 	}
 
 	// Free result
-	SQL_FREERESULT($result);
+	sqlFreeResult($result);
 
 	// Add form for adding new params
 	loadTemplate('admin_add_network_request_param', FALSE, $networkData);
 } else {
 	// Generate network list for this script
-	outputHtml(generateAdminNetworkList());
+	$OUT = generateAdminNetworkList();
+
+	// Is it not empty?
+	if (!empty($OUT)) {
+		// Output it
+		outputHtml($OUT);
+	} // END - if
 }
 
 // [EOF]