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 * Needs to be in all Files and every File needs "svn propset *
18 * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
19 * -------------------------------------------------------------------- *
20 * Copyright (c) 2003 - 2009 by Roland Haeder *
21 * Copyright (c) 2009, 2010 by Mailer Developer Team *
22 * For more information visit: http://www.mxchange.org *
24 * This program is free software; you can redistribute it and/or modify *
25 * it under the terms of the GNU General Public License as published by *
26 * the Free Software Foundation; either version 2 of the License, or *
27 * (at your option) any later version. *
29 * This program is distributed in the hope that it will be useful, *
30 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
31 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
32 * GNU General Public License for more details. *
34 * You should have received a copy of the GNU General Public License *
35 * along with this program; if not, write to the Free Software *
36 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
38 ************************************************************************/
40 // Some security stuff...
41 if ((!defined('__SECURITY')) || (!isAdmin())) {
45 // Add description as navigation point
46 addMenuDescription('admin', __FILE__);
48 // These are expert settings!
49 if (doVerifyExpertSettings() != 'agreed') {
54 // By default we should display list/add new forms
55 $GLOBALS['network_display'] = true;
58 doNetworkHandleForm();
61 if ($GLOBALS['network_display'] === false) {
66 // Do we have a network selected?
67 if (isGetRequestParameterSet('network')) {
68 // Get its data for template
69 $networkData = getNetworkDataById(getRequestParameter('network'));
72 $GLOBALS['network_translation_disabled'] = array();
74 // Only show params from given type handler if choosen
76 if ((isPostRequestParameterSet('network_type_id')) && (!is_array(postRequestParameter('network_type_id')))) {
77 // Only show from current type handler
78 $ADD = sprintf(" AND p.`network_type_id`=%s", bigintval(postRequestParameter('network_type_id')));
81 loadTemplate('admin_settings_saved', false, '{--ADMIN_NETWORK_API_TRANSLATION_LIST_LIMITED_TO_TYPE--}');
85 // Load all advert codes for given network
86 $result = SQL_QUERY_ESC("SELECT
87 p.`network_api_id`, t.`network_type_id`, t.`network_type_handle`, p.`network_api_index`
89 `{?_MYSQL_PREFIX?}_network_api_translation` AS p
91 `{?_MYSQL_PREFIX?}_network_types` AS t
93 p.`network_type_id`=t.`network_type_id`
98 t.`network_type_handle` ASC,
99 p.`network_api_id` ASC",
101 bigintval(getRequestParameter('network'))
102 ), __FILE__, __LINE__);
104 // Do we have entries?
105 if (SQL_NUMROWS($result) > 0) {
108 while ($row = SQL_FETCHARRAY($result)) {
109 // Add it to network if the type matches selected
110 if ($row['network_type_id'] == getRequestParameter('network_type_id')) {
111 // Matches, then add it for disabling this entry
112 $GLOBALS['network_translation_disabled'][$row['network_api_index']] = true;
115 // Add row template and switch color
116 $OUT .= loadTemplate('admin_list_network_api_translation_row', true, $row);
119 // Load main template
120 loadTemplate('admin_list_network_api_translation', false, $OUT);
123 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_API_TRANSLATION_404', $networkData['network_title']));
127 SQL_FREERESULT($result);
129 // Add form for adding new array_translation pair
130 loadTemplate('admin_add_network_api_translation', false, $networkData);
132 // Generate network list for this script
133 outputHtml(generateAdminNetworkList());