2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 04/22/2010 *
4 * =================== Last change: 04/22/2010 *
6 * -------------------------------------------------------------------- *
7 * File : what-list_network_array_translation.php *
8 * -------------------------------------------------------------------- *
9 * Short description : List/manage network array index translations *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Verwaltet API-Abfrageparameter *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * -------------------------------------------------------------------- *
18 * Copyright (c) 2003 - 2009 by Roland Haeder *
19 * Copyright (c) 2009 - 2011 by Mailer Developer Team *
20 * For more information visit: http://mxchange.org *
22 * This program is free software; you can redistribute it and/or modify *
23 * it under the terms of the GNU General Public License as published by *
24 * the Free Software Foundation; either version 2 of the License, or *
25 * (at your option) any later version. *
27 * This program is distributed in the hope that it will be useful, *
28 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
29 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
30 * GNU General Public License for more details. *
32 * You should have received a copy of the GNU General Public License *
33 * along with this program; if not, write to the Free Software *
34 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
36 ************************************************************************/
38 // Some security stuff...
39 if ((!defined('__SECURITY')) || (!isAdmin())) {
43 // Add description as navigation point
44 addYouAreHereLink('admin', __FILE__);
46 // These are expert settings!
47 if (doVerifyExpertSettings() != 'agreed') {
52 // By default we should display list/add new forms
53 $GLOBALS['network_display'] = true;
56 doNetworkHandleForm();
59 if ($GLOBALS['network_display'] === false) {
64 // Do we have a network selected?
65 if (isGetRequestElementSet('network_id')) {
66 // Get its data for template
67 $networkData = getNetworkDataById(getRequestElement('network_id'));
70 $networkData['network_type_id'] = 0;
73 $GLOBALS['network_translation_disabled'] = array();
75 // Only show params from given type handler if choosen
77 if ((isPostRequestElementSet('network_type_id')) && (!is_array(postRequestElement('network_type_id')))) {
78 // Only show from current type handler
79 $ADD = sprintf(" AND p.`network_type_id`=%s", bigintval(postRequestElement('network_type_id')));
82 $networkData['network_type_id'] = bigintval(postRequestElement('network_type_id'));
85 displayMessage('{--ADMIN_LIST_NETWORK_ARRAY_TRANSLATION_LIMITED_TO_TYPE--}');
88 // Load all advert codes for given network
89 $result = SQL_QUERY_ESC("SELECT
92 t.`network_type_handler`,
93 p.`network_array_index`,
96 `{?_MYSQL_PREFIX?}_network_array_translation` AS p
98 `{?_MYSQL_PREFIX?}_network_types` AS t
100 p.`network_type_id`=t.`network_type_id`
105 t.`network_type_handler` ASC,
106 p.`network_array_id` ASC",
108 bigintval(getRequestElement('network_id'))
109 ), __FILE__, __LINE__);
111 // Do we have entries?
112 if (!SQL_HASZERONUMS($result)) {
115 while ($row = SQL_FETCHARRAY($result)) {
116 // Add it to network if the type matches selected
117 if ($row['network_type_id'] == postRequestElement('network_type_id')) {
118 // Matches, then add it for disabling this entry
119 $GLOBALS['network_translation_disabled'][$row['network_array_index']] = true;
122 // Add row template and switch color
123 $OUT .= loadTemplate('admin_list_network_array_translation_row', true, $row);
126 // Load main template
127 loadTemplate('admin_list_network_array_translation', false, $OUT);
130 displayMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_404=' . $networkData['network_title'] . '%}');
134 SQL_FREERESULT($result);
136 // Add form for adding new array_translation pair
137 loadTemplate('admin_add_network_array_translation', false, $networkData);
139 // Generate network list for this script
140 outputHtml(generateAdminNetworkList());