inc/modules/admin/what-config_network_api.php

   1 <?php
   2 /************************************************************************
   3  * Mailer v0.2.1-FINAL                                Start: 08/12/2011 *
   4  * ===================                          Last change: 08/12/2011 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : what-config_network_api.php                      *
   8  * -------------------------------------------------------------------- *
   9  * Short description : API configuration for advertising networks       *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : API-Konfiguration zu den Werbenetzwerke          *
  12  * -------------------------------------------------------------------- *
  13  * $Revision::                                                        $ *
  14  * $Date::                                                            $ *
  15  * $Tag:: 0.2.1-FINAL                                                 $ *
  16  * $Author::                                                          $ *
  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                      *
  21  *                                                                      *
  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.                                  *
  26  *                                                                      *
  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.                         *
  31  *                                                                      *
  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,               *
  35  * MA  02110-1301  USA                                                  *
  36  ************************************************************************/
  37
  38 // Some security stuff...
  39 if ((!defined('__SECURITY')) || (!isAdmin())) {
  40         die();
  41 } // END - if
  42
  43 // Add description as navigation point
  44 addYouAreHereLink('admin', __FILE__);
  45
  46 // By default we should display list/add new forms
  47 $GLOBALS['network_display'] = TRUE;
  48
  49 // Handle form here
  50 doNetworkHandleForm();
  51
  52 // Display forms?
  53 if ($GLOBALS['network_display'] === FALSE) {
  54         // Abort here
  55         return;
  56 } // END - if
  57
  58 // Is there a network selected?
  59 if (isGetRequestElementSet('network_id')) {
  60         // Check all networks that doesn't have a configuration entry
  61         $result = SQL_QUERY_ESC('SELECT
  62         `network_id`,
  63         `network_short_name`,
  64         `network_title`,
  65         `network_reflink`,
  66         `network_query_amount`,
  67         `network_active`,
  68         NULL AS `network_api_affiliate_id`,
  69         NULL AS `network_api_password`,
  70         NULL AS `network_api_site_id`,
  71         NULL AS `network_api_active`,
  72         NULL AS `network_api_referral_link`,
  73         NULL AS `network_api_referral_button`,
  74         NULL AS `network_api_remaining_requests`
  75 FROM
  76         `{?_MYSQL_PREFIX?}_network_data`
  77 WHERE
  78         `network_id`=%s
  79 LIMIT 1',
  80                 array(
  81                         bigintval(getRequestElement('network_id'))
  82                 ), __FILE__, __LINE__);
  83
  84         // Is there an entry?
  85         if (SQL_NUMROWS($result) == 1) {
  86                 // Load data
  87                 $content = SQL_FETCHARRAY($result);
  88
  89                 // Is the network active?
  90                 if (($content['network_active'] == 'N') && (!isAdminsExpertWarningEnabled()) && (!isDebugModeEnabled())) {
  91                         // Not active
  92                         displayMessage('{--ADMIN_NETWORK_NOT_ACTIVE--}');
  93                         return;
  94                 } // END - if
  95
  96                 // Query for config table
  97                 $result_config = SQL_QUERY_ESC('SELECT
  98         `network_api_affiliate_id`,
  99         `network_api_password`,
 100         `network_api_site_id`,
 101         `network_api_active`,
 102         `network_api_referral_link`,
 103         `network_api_referral_button`,
 104         `network_api_remaining_requests`
 105 FROM
 106         `{?_MYSQL_PREFIX?}_network_api_config`
 107 WHERE
 108         `network_id`=%s
 109 LIMIT 1',
 110                         array(
 111                                 bigintval(getRequestElement('network_id'))
 112                         ), __FUNCTION__, __LINE__);
 113
 114                 // Is there an entry?
 115                 if (SQL_NUMROWS($result_config) == 1) {
 116                         // Load entries
 117                         $content = merge_array($content, SQL_FETCHARRAY($result_config));
 118                 } // END - if
 119
 120                 // Free result
 121                 SQL_FREERESULT($result_config);
 122
 123                 // Load main template (for "add" and "edit")
 124                 loadTemplate('admin_config_network_api', FALSE, $content);
 125         } else {
 126                 // Please setup some networks first
 127                 displayMessage('{--ADMIN_NETWORK_DATA_MISSING--}');
 128         }
 129
 130         // Free result
 131         SQL_FREERESULT($result);
 132 } else {
 133         // Generate network list for this script
 134         $OUT = generateAdminNetworkList(TRUE);
 135
 136         // Is it not empty?
 137         if (!empty($OUT)) {
 138                 // Output it
 139                 outputHtml($OUT);
 140         } // END - if
 141 }
 142
 143 // [EOF]
 144 ?>