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_del_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_del_do_surfbar_urls');
  77 } elseif (isFormSent('lock')) {
  78         // Un-/lock selected URLs. This does not work for pending URLs
  79         adminLockEntriesConfirm(
  80                 postRequestParameter('url_id'),
  81                 'surfbar_urls',
  82                 array(
  83                         'url_id',
  84                         'url_userid',
  85                         'url',
  86                         'url_registered',
  87                         'url_status'
  88                 ),
  89                 array(
  90                         'bigintval',
  91                         'generateUserProfileLink',
  92                         'generateFrametesterUrl',
  93                         '',
  94                         'translateSurfbarUrlStatus'
  95                 ),
  96                 array(
  97                         '',
  98                         '',
  99                         '',
 100                         '',
 101                         ''
 102                 ),
 103                 false,
 104                 'url_id',
 105                 'url_userid',
 106                 'url_userid'
 107         );
 108
 109         // Do not show the list of URLs after this template
 110         $show = false;
 111 } elseif (isFormSent('do_lock')) {
 112         // Un-/lock selected URLs. This does not work for pending URLs
 113         adminLockEntriesConfirm(
 114                 postRequestParameter('url_id'),
 115                 'surfbar_urls',
 116                 array(),
 117                 array(),
 118                 array(),
 119                 array(
 120                         'url_status' => array(
 121                                 'ACTIVE' => 'LOCKED',
 122                                 'LOCKED' => 'ACTIVE'
 123                         )
 124                 ),
 125                 true,
 126                 'url_id',
 127                 'url_userid',
 128                 'url_userid'
 129         );
 130 } elseif (isFormSent('undelete')) {
 131         // Undelete selected URLs. This does only work for deleted URLs... ;-)
 132         adminUndeleteEntriesConfirm(
 133                 postRequestParameter('url_id'),
 134                 'surfbar_urls',
 135                 array(
 136                         'url_id',
 137                         'url_userid',
 138                         'url',
 139                         'url_registered',
 140                         'url_status'
 141                 ),
 142                 array(
 143                         'bigintval',
 144                         'generateUserProfileLink',
 145                         'generateFrametesterUrl',
 146                         '',
 147                         'translateSurfbarUrlStatus'
 148                 ),
 149                 array(
 150                         '',
 151                         '',
 152                         '',
 153                         '',
 154                         ''
 155                 ),
 156                 false,
 157                 'url_id',
 158                 'url_userid',
 159                 'url_userid'
 160         );
 161         $show = false;
 162 } elseif (isFormSent('do_undelete')) {
 163         // Undelete selected URLs. This does only work for deleted URLs... ;-)
 164         adminUndeleteEntriesConfirm(
 165                 postRequestParameter('url_id'),
 166                 'surfbar_urls',
 167                 array(),
 168                 array(),
 169                 array(),
 170                 array(
 171                         'url_status' => array(
 172                                 'DELETED' => 'ACTIVE'
 173                         )
 174                 ),
 175                 true,
 176                 'url_id',
 177                 'url_userid',
 178                 'url_userid'
 179         );
 180 }
 181
 182 // Show entries?
 183 if ($show === false) {
 184         // No, a form has already been show
 185         return false;
 186 } // END - if
 187
 188 // List all URLs
 189 $result = SQL_QUERY("SELECT
 190         `url_id`, `url_userid`, `url`, `url_views_total`, `url_status`,
 191         UNIX_TIMESTAMP(`url_registered`) AS `url_registered`,
 192         UNIX_TIMESTAMP(`url_last_locked`) AS `url_last_locked`,
 193         `url_lock_reason`
 194 FROM
 195         `{?_MYSQL_PREFIX?}_surfbar_urls`
 196 ORDER BY
 197         `url_id` ASC", __FILE__, __LINE__);
 198
 199 // Do we have some URLs left?
 200 if (!SQL_HASZERONUMS($result)) {
 201         // List all URLs
 202         $OUT = '';
 203         while ($content = SQL_FETCHARRAY($result)) {
 204                 // "Translate"/add content
 205                 $content['url_registered']  = generateDateTime($content['url_registered'], 2);
 206                 $content['url_last_locked'] = generateDateTime($content['url_last_locked'], 2);
 207
 208                 // Load row template
 209                 $OUT .= loadTemplate('admin_list_surfbar_urls_row', true, $content);
 210         } // END - while
 211
 212         // Load main template
 213         loadTemplate('admin_list_surfbar_urls', false, $OUT);
 214 } else {
 215         // No URLs in surfbar
 216         displayMessage('{--ADMIN_SURFBAR_NO_URLS_FOUND--}');
 217 }
 218
 219 // Free result
 220 SQL_FREERESULT($result);
 221
 222 // [EOF]
 223 ?>