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