inc/modules/admin/what-list_surfbar_urls.php

   1 <?php
   2 /************************************************************************
   3  * Mailer v0.2.1-FINAL                                Start: 08/31/2008 *
   4  * ===================                          Last change: 08/31/2008 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : what-list_surfbar_urls.php                       *
   8  * -------------------------------------------------------------------- *
   9  * Short description : List all URLs in surfbar and sync from mail pool *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : Alle URLs in Surfbar auflisten und syncen        *
  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 - 2011 by Mailer Developer Team                   *
  20  * For more information visit: http://www.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 show the list...
  47 $show = true;
  48
  49 // Check for 'url_id' element
  50 if ((countRequestPost() > 0) && ((!isPostRequestParameterSet('url_id')) || (!is_array(postRequestParameter('url_id'))) || (count(postRequestParameter('url_id')) == 0))) {
  51         // Not found so output message
  52         displayMessage('{--ADMIN_SURFBAR_NO_SELECTIONS--}');
  53
  54         // Abort here
  55         return;
  56 } // END - if
  57
  58 // Edit or delete button hit?
  59 if (isFormSent('edit')) {
  60         // Show entries for editing
  61         showEntriesByXmlCallback('admin_edit_show_surfbar_urls');
  62
  63         // Do not show the list of URLs after this template
  64         $show = false;
  65 } elseif (isFormSent('do_edit')) {
  66         // Change data of entries
  67         showEntriesByXmlCallback('admin_edit_do_surfbar_urls');
  68 } elseif (isFormSent('delete')) {
  69         // Show entries for deletion
  70         showEntriesByXmlCallback('admin_delete_show_surfbar_urls');
  71
  72         // Do not show the list of URLs after this template
  73         $show = false;
  74 } elseif (isFormSent('do_delete')) {
  75         // Remove entries from database
  76         showEntriesByXmlCallback('admin_delete_do_surfbar_urls');
  77 } elseif (isFormSent('lock')) {
  78         // Un-/lock selected URLs. This does not work for pending URLs
  79         showEntriesByXmlCallback('admin_lock_show_surfbar_urls');
  80
  81         // Do not show the list of URLs after this template
  82         $show = false;
  83 } elseif (isFormSent('do_lock')) {
  84         // Un-/lock selected URLs. This does not work for pending URLs
  85         showEntriesByXmlCallback('admin_lock_do_surfbar_urls');
  86 } elseif (isFormSent('undelete')) {
  87         // Undelete selected URLs. This does only work for deleted URLs... ;-)
  88         showEntriesByXmlCallback('admin_undelete_show_surfbar_urls');
  89
  90         // Do not show the list of URLs after this template
  91         $show = false;
  92 } elseif (isFormSent('do_undelete')) {
  93         // Undelete selected URLs. This does only work for deleted URLs... ;-)
  94         showEntriesByXmlCallback('admin_undelete_del_surfbar_urls');
  95 }
  96
  97 // Show entries?
  98 if ($show === false) {
  99         // No, a form has already been show
 100         return false;
 101 } // END - if
 102
 103 // List all URLs
 104 $result = SQL_QUERY("SELECT
 105         `url_id`,
 106         `url_userid`,
 107         `url`,
 108         `url_views_total`,
 109         `url_status`,
 110         UNIX_TIMESTAMP(`url_registered`) AS `url_registered`,
 111         UNIX_TIMESTAMP(`url_last_locked`) AS `url_last_locked`,
 112         `url_lock_reason`
 113 FROM
 114         `{?_MYSQL_PREFIX?}_surfbar_urls`
 115 ORDER BY
 116         `url_id` ASC", __FILE__, __LINE__);
 117
 118 // Do we have some URLs left?
 119 if (!SQL_HASZERONUMS($result)) {
 120         // List all URLs
 121         $OUT = '';
 122         while ($content = SQL_FETCHARRAY($result)) {
 123                 // "Translate" content
 124                 $content['url_registered']  = generateDateTime($content['url_registered'], '2');
 125                 $content['url_last_locked'] = generateDateTime($content['url_last_locked'], '2');
 126
 127                 // Load row template
 128                 $OUT .= loadTemplate('admin_list_surfbar_urls_row', true, $content);
 129         } // END - while
 130
 131         // Load main template
 132         loadTemplate('admin_list_surfbar_urls', false, $OUT);
 133 } else {
 134         // No URLs in surfbar
 135         displayMessage('{--ADMIN_SURFBAR_NO_URLS_FOUND--}');
 136 }
 137
 138 // Free result
 139 SQL_FREERESULT($result);
 140
 141 // [EOF]
 142 ?>