2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 11/26/2009 *
4 * =================== Last change: 11/26/2009 *
6 * -------------------------------------------------------------------- *
7 * File : what-list_network_request_params.php *
8 * -------------------------------------------------------------------- *
9 * Short description : List/manage network API query parameters *
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 - 2012 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'));
68 $networkData['network_type_id'] = 0;
71 $GLOBALS['network_request_params_disabled'] = array();
73 // Only show params from given type handler if choosen
75 if ((isPostRequestElementSet('network_type_id')) && (!is_array(postRequestElement('network_type_id')))) {
76 // Only show from current type handler
77 $ADD = sprintf(" AND p.`network_type_id`=%s", bigintval(postRequestElement('network_type_id')));
80 $networkData['network_type_id'] = bigintval(postRequestElement('network_type_id'));
83 displayMessage('{--ADMIN_NETWORK_REQUEST_PARAMETER_LIST_LIMITED_TO_TYPE--}');
86 // Load all advert types for given network
87 $result = SQL_QUERY_ESC("SELECT
88 p.`network_request_param_id`,
90 t.`network_type_handler`,
91 p.`network_request_param_key`,
92 p.`network_request_param_value`,
93 p.`network_request_param_default`
95 `{?_MYSQL_PREFIX?}_network_request_params` AS p
97 `{?_MYSQL_PREFIX?}_network_types` AS t
99 p.`network_type_id`=t.`network_type_id`
101 p.`network_id`=%s".$ADD."
103 t.`network_type_handler` ASC,
104 p.`network_request_param_id` ASC",
105 array(getRequestElement('network_id')), __FILE__, __LINE__);
107 // Do we have entries?
108 if (!SQL_HASZERONUMS($result)) {
111 while ($row = SQL_FETCHARRAY($result)) {
112 // Add it to network if the type matches selected
113 if ($row['network_type_id'] == postRequestElement('network_type_id')) {
114 // Matches, then add it for disabling this entry
115 $GLOBALS['network_request_params_disabled'][$row['network_request_param_key']] = true;
118 // Is default value empty or null?
119 $row['network_request_param_default'] = fixNullEmptyToDashes($row['network_request_param_default'], 3);
121 // Add row template and switch color
122 $OUT .= loadTemplate('admin_list_network_request_params_row', true, $row);
125 // Load main template
126 loadTemplate('admin_list_network_request_params', false, $OUT);
129 displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_404=' . $networkData['network_title'] . '%}');
133 SQL_FREERESULT($result);
135 // Add form for adding new params
136 loadTemplate('admin_add_network_request_param', false, $networkData);
138 // Generate network list for this script
139 outputHtml(generateAdminNetworkList());