X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_network_array_translation.php;h=1ef12fe8096c0d2526a85534f1a1a0c07b3713ea;hb=095f5ab59b539834d2c67e5d409d01820e10d8be;hp=dfc1bdaf221e97e6ab87d49bfafb1f54aec07aa9;hpb=995488beda665a1fc3de65df95f2d1ae236d1245;p=mailer.git diff --git a/inc/modules/admin/what-list_network_array_translation.php b/inc/modules/admin/what-list_network_array_translation.php index dfc1bdaf22..1ef12fe809 100644 --- a/inc/modules/admin/what-list_network_array_translation.php +++ b/inc/modules/admin/what-list_network_array_translation.php @@ -14,12 +14,10 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2016 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -43,7 +41,7 @@ if ((!defined('__SECURITY')) || (!isAdmin())) { } // END - if // Add description as navigation point -addMenuDescription('admin', __FILE__); +addYouAreHereLink('admin', __FILE__); // These are expert settings! if (doVerifyExpertSettings() != 'agreed') { @@ -52,103 +50,106 @@ if (doVerifyExpertSettings() != 'agreed') { } // END - if // By default we should display list/add new forms -$GLOBALS['network_display'] = true; +$GLOBALS['network_display'] = TRUE; // Handle form here doNetworkHandleForm(); // Display forms? -if ($GLOBALS['network_display'] === false) { +if ($GLOBALS['network_display'] === FALSE) { // Abort here return; } // END - if -// Do we have a network selected? -if (isGetRequestParameterSet('network')) { +// Is there a network selected? +if (isGetRequestElementSet('network_id')) { // Get its data for template - $networkData = getNetworkDataById(getRequestParameter('network')); + $networkData = getNetworkDataFromId(getRequestElement('network_id')); - // Is a network type selected? - if (!isGetRequestParameterSet('network_type')) { - // Then present a new selection form - outputHtml(generateAdminNetworkTypeList(getRequestParameter('network'), getRequestParameter('network_type'))); - - // Abort any other processing - return; - } // END - if + // Init type + $networkData['network_type_id'] = 0; // Init disabled list $GLOBALS['network_array_translation_disabled'] = array(); + // Only show params from given type handler if choosen + $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'))); + + // Overwrite type + $networkData['network_type_id'] = bigintval(postRequestElement('network_type_id')); + + // Display message + displayMessage('{--ADMIN_LIST_NETWORK_ARRAY_TRANSLATION_LIMITED_TO_TYPE--}'); + } // END - if + // Load all advert codes for given network - $result = SQL_QUERY_ESC("SELECT - p.`network_array_id`, t.`network_type_id`, t.`network_type_handle`, p.`network_array_index`, p.`network_index_translation` + $result = sqlQueryEscaped('SELECT + `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 AND - p.`network_type_id`=%s + `p`.`network_id`=%s + ' . $ADD . ' ORDER BY - t.`network_type_handle` ASC, - p.`network_array_id` ASC", + `t`.`network_type_handler` ASC, + `p`.`network_array_sort` ASC', array( - bigintval(getRequestParameter('network')), - bigintval(getRequestParameter('network_type')) + bigintval(getRequestElement('network_id')) ), __FILE__, __LINE__); - // Remember the rows - $rows = SQL_NUMROWS($result); - - // Do we have entries? - if ($rows > 0) { + // Are there entries? + if (!ifSqlHasZeroNumRows($result)) { // List all entries - $OUT = ''; $SW = 2; - while ($row = SQL_FETCHARRAY($result)) { - // Add color switching - $row['sw'] = $SW; - + $OUT = ''; + while ($row = sqlFetchArray($result)) { // Add it to network if the type matches selected - if ($row['network_type_id'] == getRequestParameter('network_type_id')) { + if ($row['network_type_id'] == postRequestElement('network_type_id')) { // Matches, then add it for disabling this entry - $GLOBALS['network_array_translation_disabled'][$row['network_array_index']] = true; + $GLOBALS['network_array_translation_disabled'][$row['network_array_index']] = TRUE; } // END - if // Add row template and switch color - $OUT .= loadTemplate('admin_list_network_array_translation_row', true, $row); - $SW = 3 - $SW; + $OUT .= loadTemplate('admin_list_network_array_translation_row', TRUE, $row); } // END - while - // Prepare data for template + // Prepare array with generic elements $content = array( - 'rows' => $OUT, - 'network_id' => bigintval(getRequestParameter('network')), - 'network_title' => $networkData['network_title'], - 'network_reflink' => $networkData['network_reflink'], + 'rows' => $OUT, + 'network_id' => bigintval(getRequestElement('network_id')) ); // Load main template - loadTemplate('admin_list_network_array_translation', false, $content); + loadTemplate('admin_list_network_array_translation', FALSE, $content); } else { // No entries found - loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_ARRAY_TRANSLATION_404', $networkData['network_title'])); + displayMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_404=' . $networkData['network_title'] . '%}'); } // Free result - SQL_FREERESULT($result); - - // Add options list for network type - $networkData['translation_index'] = ($rows + 1); - $networkData['type_options'] = generateNetworkTypeOptions(getRequestParameter('network_type_id')); + sqlFreeResult($result); // Add form for adding new array_translation pair - loadTemplate('admin_add_network_array_translation', false, $networkData); + 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]