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 - 2013 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 // Is there a network selected?
65 if (isGetRequestElementSet('network_id')) {
66 // Get its data for template
67 $networkData = getNetworkDataFromId(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`,
89 `t`.`network_type_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(bigintval(getRequestElement('network_id'))), __FILE__, __LINE__);
107 // Are there 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 // Add row template and switch color
119 $OUT .= loadTemplate('admin_list_network_request_params_row', TRUE, $row);
122 // Prepare content array
125 'network_id' => bigintval(getRequestElement('network_id'))
128 // Load main template
129 loadTemplate('admin_list_network_request_params', FALSE, $content);
132 displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_404=' . $networkData['network_title'] . '%}');
136 SQL_FREERESULT($result);
138 // Add form for adding new params
139 loadTemplate('admin_add_network_request_param', FALSE, $networkData);
141 // Generate network list for this script
142 $OUT = generateAdminNetworkList();