2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 11/26/2009 *
4 * =================== Last change: 11/26/2009 *
6 * -------------------------------------------------------------------- *
7 * File : what-list_network_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 * 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_params_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, getMessage('ADMIN_NETWORK_REQUEST_PARAMETER_LIST_LIMITED_TO_TYPE'));
84 // Load all advert types for given network
85 $result = SQL_QUERY_ESC("SELECT
86 p.`network_param_id`, t.`network_type_id`, t.`network_type_handle`, p.`request_param_key`, p.`request_param_value`, p.`request_param_default`
88 `{?_MYSQL_PREFIX?}_network_request_params` AS p
90 `{?_MYSQL_PREFIX?}_network_types` AS t
92 p.`network_type_id`=t.`network_type_id`
94 p.`network_id`=%s".$ADD."
96 t.`network_type_handle` ASC,
97 p.`network_param_id` ASC",
98 array(getRequestParameter('network')), __FILE__, __LINE__);
100 // Do we have entries?
101 if (SQL_NUMROWS($result) > 0) {
104 while ($row = SQL_FETCHARRAY($result)) {
105 // Add/translate some data
108 // Add it to network if the type matches selected
109 if ($row['network_type_id'] == postRequestParameter('network_type_id')) {
110 // Matches, then add it for disabling this entry
111 $GLOBALS['network_params_disabled'][$row['request_param_key']] = true;
114 // Is default value empty or null?
115 $row['request_param_default'] = fixNullEmptyToDashes($row['request_param_default'], 3);
117 // Add row template and switch color
118 $OUT .= loadTemplate('admin_list_network_params_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_params', false, $content);
134 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_404', $networkData['network_title']));
138 SQL_FREERESULT($result);
140 // Add form for adding new params
141 loadTemplate('admin_add_network_params', false, $networkData);
143 // Generate network list for this script
144 outputHtml(generateAdminNetworkList());