$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
$networkData['network_type_id'] = bigintval(postRequestElement('network_type_id'));
// Load all advert codes for given network
$result = SQL_QUERY_ESC("SELECT
- p.`network_array_id`,
- t.`network_type_id`,
- t.`network_type_handler`,
- p.`network_array_index`,
- p.`network_array_sort`
+ `p`.`network_array_id`,
+ `t`.`network_type_id`,
+ `t`.`network_type_handler`,
+ `p`.`network_array_index`,
+ `p`.`network_array_sort`
FROM
- `{?_MYSQL_PREFIX?}_network_array_translation` AS p
+ `{?_MYSQL_PREFIX?}_network_array_translation` 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
+ `p`.`network_id`=%s
".$ADD."
ORDER BY
- t.`network_type_handler` ASC,
- p.`network_array_id` ASC",
+ `t`.`network_type_handler` ASC,
+ `p`.`network_array_sort` ASC",
array(
bigintval(getRequestElement('network_id'))
), __FILE__, __LINE__);
$OUT .= loadTemplate('admin_list_network_array_translation_row', TRUE, $row);
} // END - while
+ // Prepare array with generic elements
+ $content = array(
+ 'rows' => $OUT,
+ 'network_id' => bigintval(getRequestElement('network_id'))
+ );
+
// Load main template
- loadTemplate('admin_list_network_array_translation', FALSE, $OUT);
+ loadTemplate('admin_list_network_array_translation', FALSE, $content);
} else {
// No entries found
displayMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_404=' . $networkData['network_title'] . '%}');
loadTemplate('admin_add_network_array_translation', 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]