X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_network_request_params.php;h=2fcadebed688f4e68b05d0863eaebeb4b2182e78;hb=4f7df133f736da124e6f7bd02008b9093f736451;hp=1831d44610303f3646943440a9174e8e8bb6e2c5;hpb=596c8ab32594401ca84abfbfe35513ddfff31bec;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 1831d44610..2fcadebed6 100644
--- a/inc/modules/admin/what-list_network_request_params.php
+++ b/inc/modules/admin/what-list_network_request_params.php
@@ -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'));
@@ -85,24 +85,24 @@ if (isGetRequestElementSet('network_id')) {
 
 	// 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`
+	`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",
-		array(getRequestElement('network_id')), __FILE__, __LINE__);
+	`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)) {
@@ -119,8 +119,14 @@ ORDER BY
 			$OUT .= loadTemplate('admin_list_network_request_params_row', TRUE, $row);
 		} // END - while
 
+		// Prepare content array
+		$content = array(
+			'rows'       => $OUT,
+			'network_id' => bigintval(getRequestElement('network_id'))
+		);
+
 		// Load main template
-		loadTemplate('admin_list_network_request_params', FALSE, $OUT);
+		loadTemplate('admin_list_network_request_params', FALSE, $content);
 	} else {
 		// No entries found
 		displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_404=' . $networkData['network_title'] . '%}');
@@ -133,7 +139,13 @@ ORDER BY
 	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]