X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_network_request_params.php;h=2fcadebed688f4e68b05d0863eaebeb4b2182e78;hp=514b8a1e08122b26a285c12b50efa3ec7bc1256e;hb=4f7df133f736da124e6f7bd02008b9093f736451;hpb=fb9a9090248ca810eab3028c660cc0fa429cf854 diff --git a/inc/modules/admin/what-list_network_request_params.php b/inc/modules/admin/what-list_network_request_params.php index 514b8a1e08..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,23 +85,23 @@ 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", + `t`.`network_type_handler` ASC, + `p`.`network_request_param_id` ASC", array(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__); // Are there entries?