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 API query parameters *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Verwaltet API-Abfrageparameter *
12 * -------------------------------------------------------------------- *
13 * $Revision:: 1794 $ *
14 * $Date:: 2010-05-28 19:55:19 +0200 (Fri, 28 May 2010) $ *
15 * $Tag:: 0.2.1-FINAL $ *
16 * $Author:: quix0r $ *
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'));
71 // Is a network type selected?
72 if (!isGetRequestParameterSet('network_type')) {
73 // Then present a new selection form
74 outputHtml(generateAdminNetworkTypeList(getRequestParameter('network'), getRequestParameter('network_type')));
76 // Abort any other processing
81 $GLOBALS['network_array_translation_disabled'] = array();
83 // Load all advert codes for given network
84 $result = SQL_QUERY_ESC("SELECT
85 p.`network_array_id`, t.`network_type_id`, t.`network_type_handle`, p.`network_array_index`, p.`network_index_translation`
87 `{?_MYSQL_PREFIX?}_network_array_translation` AS p
89 `{?_MYSQL_PREFIX?}_network_types` AS t
91 p.`network_type_id`=t.`network_type_id`
94 p.`network_type_id`=%s
96 t.`network_type_handle` ASC,
97 p.`network_array_id` ASC",
99 bigintval(getRequestParameter('network')),
100 bigintval(getRequestParameter('network_type'))
101 ), __FILE__, __LINE__);
103 // Do we have entries?
104 if (SQL_NUMROWS($result) > 0) {
107 while ($row = SQL_FETCHARRAY($result)) {
108 // Add/translate some data
111 // Add it to network if the type matches selected
112 if ($row['network_type_id'] == getRequestParameter('network_type_id')) {
113 // Matches, then add it for disabling this entry
114 $GLOBALS['network_array_translation_disabled'][$row['network_array_index']] = true;
117 // Add row template and switch color
118 $OUT .= loadTemplate('admin_list_network_array_translation_row', true, $row);
122 // Prepare data for template
125 'network_id' => bigintval(getRequestParameter('network')),
126 'network_title' => $networkData['network_title'],
127 'network_reflink' => $networkData['network_reflink'],
130 // Load main template
131 loadTemplate('admin_list_network_array_translation', false, $content);
134 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_ARRAY_TRANSLATION_404', $networkData['network_title']));
138 SQL_FREERESULT($result);
140 // Add options list for network type
141 $networkData['type_options'] = generateNetworkTypeOptions(getRequestParameter('network_type_id'));
143 // Add form for adding new array_translation pair
144 loadTemplate('admin_add_network_array_translation', false, $networkData);
146 // Generate network list for this script
147 outputHtml(generateAdminNetworkList());