2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 04/22/2010 *
4 * =================== Last change: 04/22/2010 *
6 * -------------------------------------------------------------------- *
7 * File : what-list_network_api_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, 2010 by Mailer Developer Team *
20 * For more information visit: http://www.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 addMenuDescription('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 (isGetRequestParameterSet('network')) {
66 // Get its data for template
67 $networkData = getNetworkDataById(getRequestParameter('network'));
70 $networkData['network_type_id'] = 0;
73 $GLOBALS['network_translation_disabled'] = array();
75 // Only show params from given type handler if choosen
77 if ((isPostRequestParameterSet('network_type_id')) && (!is_array(postRequestParameter('network_type_id')))) {
78 // Only show from current type handler
79 $ADD = sprintf(" AND p.`network_type_id`=%s", bigintval(postRequestParameter('network_type_id')));
82 $networkData['network_type_id'] = bigintval(postRequestParameter('network_type_id'));
85 loadTemplate('admin_settings_saved', false, '{--ADMIN_NETWORK_API_TRANSLATION_LIST_LIMITED_TO_TYPE--}');
88 // Load all advert codes for given network
89 $result = SQL_QUERY_ESC("SELECT
90 p.`network_api_id`, t.`network_type_id`, t.`network_type_handle`, p.`network_api_index`, p.`sort`
92 `{?_MYSQL_PREFIX?}_network_api_translation` AS p
94 `{?_MYSQL_PREFIX?}_network_types` AS t
96 p.`network_type_id`=t.`network_type_id`
101 t.`network_type_handle` ASC,
102 p.`network_api_id` ASC",
104 bigintval(getRequestParameter('network'))
105 ), __FILE__, __LINE__);
107 // Do we have entries?
108 if (SQL_NUMROWS($result) > 0) {
111 while ($row = SQL_FETCHARRAY($result)) {
112 // Add it to network if the type matches selected
113 if ($row['network_type_id'] == postRequestParameter('network_type_id')) {
114 // Matches, then add it for disabling this entry
115 $GLOBALS['network_translation_disabled'][$row['network_api_index']] = true;
118 // Add row template and switch color
119 $OUT .= loadTemplate('admin_list_network_api_translation_row', true, $row);
122 // Load main template
123 loadTemplate('admin_list_network_api_translation', false, $OUT);
126 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_API_TRANSLATION_404', $networkData['network_title']));
130 SQL_FREERESULT($result);
132 // Add form for adding new array_translation pair
133 loadTemplate('admin_add_network_api_translation', false, $networkData);
135 // Generate network list for this script
136 outputHtml(generateAdminNetworkList());