inc/modules/admin/what-list_rallyes.php

   1 <?php
   2 /************************************************************************
   3  * Mailer v0.2.1-FINAL                                Start: 06/29/2004 *
   4  * ===================                          Last change: 02/11/2005 *
   5  *                                                                      *
   6  * -------------------------------------------------------------------- *
   7  * File              : what-list_rallyes.php                            *
   8  * -------------------------------------------------------------------- *
   9  * Short description : List existing rallyes                            *
  10  * -------------------------------------------------------------------- *
  11  * Kurzbeschreibung  : Bestehende Rallyes auflisten                     *
  12  * -------------------------------------------------------------------- *
  13  * $Revision::                                                        $ *
  14  * $Date::                                                            $ *
  15  * $Tag:: 0.2.1-FINAL                                                 $ *
  16  * $Author::                                                          $ *
  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                  *
  23  *                                                                      *
  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.                                  *
  28  *                                                                      *
  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.                         *
  33  *                                                                      *
  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,               *
  37  * MA  02110-1301  USA                                                  *
  38  ************************************************************************/
  39
  40 // Some security stuff...
  41 if ((!defined('__SECURITY')) || (!isAdmin())) {
  42         die();
  43 } // END - if
  44
  45 // Add description as navigation point
  46 addMenuDescription('admin', __FILE__);
  47
  48 // Init message
  49 $message = '';
  50
  51 // Quick actions on a rallye
  52 if (isGetRequestParameterSet('rallye')) {
  53         // Init SQL queries
  54         initSqls();
  55
  56         if (isGetRequestParameterSet('activate')) {
  57                 // Activate / deactivate
  58                 switch (getRequestParameter('activate')) {
  59                         case '1': // Activate
  60                                 addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1",
  61                                         array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
  62                                 );
  63                                 break;
  64
  65                         case '0': // Deactivate
  66                                 addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1",
  67                                         array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
  68                                 );
  69                                 break;
  70                 } // END - switch
  71         } elseif (isGetRequestParameterSet('notify')) {
  72                 // Automatic notification
  73                 switch (getRequestParameter('notify')) {
  74                         case '1': // Activate
  75                                 addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1",
  76                                         array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
  77                                 );
  78                                 break;
  79
  80                         case '0': // Deactivate
  81                                 addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1",
  82                                         array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
  83                                 );
  84                                 break;
  85                 } // END - switch
  86         } elseif (isGetRequestParameterSet('auto')) {
  87                 // Automatic adding of new members
  88                 switch (getRequestParameter('auto')) {
  89                         case '1': // Activate
  90                                 addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='Y' WHERE `id`=%s AND `auto_add_new_user`='N' LIMIT 1",
  91                                         array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
  92                                 );
  93                                 break;
  94
  95                         case '0': // Deactivate
  96                                 addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `auto_add_new_user`='N' WHERE `id`=%s AND `auto_add_new_user`='Y' LIMIT 1",
  97                                         array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
  98                                 );
  99                                 break;
 100                 } // END - switch
 101         }
 102
 103         // Run SQL command
 104         runFilterChain('run_sqls');
 105 } elseif (isFormSent('remove')) {
 106         // Delete rallyes
 107         if (ifPostContainsSelections()) {
 108                 // Init SQLs
 109                 initSqls();
 110
 111                 // Delete selected rallyes and all it's data
 112                 foreach (postRequestParameter('sel') as $id => $selected) {
 113                         // Remove selected rallye entirely...
 114                         addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1",
 115                                 array(bigintval($id)), __FILE__, __LINE__, false));
 116                         addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s",
 117                                 array(bigintval($id)), __FILE__, __LINE__, false));
 118                         addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s",
 119                                 array(bigintval($id)), __FILE__, __LINE__, false));
 120                 } // END - foreach
 121
 122                 // Run SQLS
 123                 runFilterChain('run_sqls');
 124
 125                 // Output message
 126                 $message = '{--RALLYE_DELETED--}';
 127         } else {
 128                 // No rallye selected to delete!
 129                 $message = '{--RALLYE_DELETE_NOTHING_SELECTED--}';
 130         }
 131 } elseif (isFormSent('change')) {
 132         // Change rallye
 133         if (ifPostContainsSelections('title')) {
 134                 // Init SQLs
 135                 initSqls();
 136
 137                 // Change selected rallyes and all it's data
 138                 foreach (postRequestParameter('title') as $id => $title) {
 139                         // Secure id number
 140                         $id = bigintval($id);
 141
 142                         // Generate timestamps
 143                         $START = mktime(postRequestParameter('start_hour', $id), postRequestParameter('start_min', $id), postRequestParameter('start_sec', $id), postRequestParameter('start_month', $id), postRequestParameter('start_day', $id), postRequestParameter('start_year', $id));
 144                         $END   = mktime(postRequestParameter('end_hour', $id)  , postRequestParameter('end_min', $id)  , postRequestParameter('end_sec', $id)  , postRequestParameter('end_month', $id)  , postRequestParameter('end_day', $id)  , postRequestParameter('end_year', $id)  );
 145
 146                         // Update entry
 147                         addSql(SQL_QUERY_ESC("UPDATE
 148         `{?_MYSQL_PREFIX?}_rallye_data`
 149 SET
 150         `title`='%s',
 151         `descr`='%s',
 152         `template`='%s',
 153         `start_time`=%s,
 154         `end_time`=%s,
 155         `min_users`=%s,
 156         `min_prices`=%s
 157 WHERE
 158         `id`=%s
 159 LIMIT 1",
 160                         array(
 161                                 $title,
 162                                 postRequestParameter('descr', $id),
 163                                 postRequestParameter('templ', $id),
 164                                 bigintval($START),
 165                                 bigintval($END),
 166                                 bigintval(postRequestParameter('min_users', $id)),
 167                                 bigintval(postRequestParameter('min_prices', $id)),
 168                                 $id
 169                         ), __FILE__, __LINE__, false));
 170                 }
 171
 172                 // Run SQLS
 173                 runFilterChain('run_sqls');
 174
 175                 // Output message
 176                 $message = '{--RALLYE_CHANGED--}';
 177         }
 178 }
 179
 180 if (isFormSent('edit')) {
 181         // Check for selections
 182         if (ifPostContainsSelections()) {
 183                 // Make all selected and deactivated rallyes editable
 184                 $OUT = '';
 185                 foreach (postRequestParameter('sel') as $id => $selected) {
 186                         // Load rallye basic data
 187                         $result = SQL_QUERY_ESC("SELECT
 188         `title`, `descr`, `template`, `start_time`, `end_time`, `min_users`, `min_prices`
 189 FROM
 190         `{?_MYSQL_PREFIX?}_rallye_data`
 191 WHERE
 192         `id`=%s
 193 LIMIT 1",
 194                                 array(bigintval($id)), __FILE__, __LINE__);
 195                         // Fetch an array
 196                         $content = SQL_FETCHARRAY($result);
 197
 198                         // Free result
 199                         SQL_FREERESULT($result);
 200
 201                         // Starting day
 202                         $content['s_sec']   = addSelectionBox('sec'  , getSecond($content['start_time'])   , 'start', $id);
 203                         $content['s_min']   = addSelectionBox('min'  , getMinute($content['start_time'])   , 'start', $id);
 204                         $content['s_hour']  = addSelectionBox('hour' , getShortHour($content['start_time']), 'start', $id);
 205                         $content['s_day']   = addSelectionBox('day'  , getDay($content['start_time'])      , 'start', $id);
 206                         $content['s_month'] = addSelectionBox('month', getMonth($content['start_time'])    , 'start', $id);
 207                         $content['s_year']  = addSelectionBox('year' , getYear($content['start_time'])     , 'start', $id);
 208
 209                         // Ending day
 210                         $content['e_sec']   = addSelectionBox('sec'  , getSecond($content['end_time'])     , 'end'  , $id);
 211                         $content['e_min']   = addSelectionBox('min'  , getMinute($content['end_time'])     , 'end'  , $id);
 212                         $content['e_hour']  = addSelectionBox('hour' , getShortHour($content['end_time'])  , 'end'  , $id);
 213                         $content['e_day']   = addSelectionBox('day'  , getDay($content['end_time'])        , 'end'  , $id);
 214                         $content['e_month'] = addSelectionBox('month', getMonth($content['end_time'])      , 'end'  , $id);
 215                         $content['e_year']  = addSelectionBox('year' , getYear($content['end_time'])       , 'end'  , $id);
 216
 217                         // Remember other values
 218                         $content['templ']      = addReferalRallyeTemplateSelection('templ['.$id.']', $content['template']);
 219                         $content['id']         = $id;
 220
 221                         // Output row
 222                         $OUT .= loadTemplate('admin_edit_rallyes_row', true, $content);
 223                 } // END - foreach
 224
 225                 // Load final template
 226                 loadTemplate('admin_edit_rallyes', false, $OUT);
 227         } else {
 228                 // Nothing selected to edit
 229                 loadTemplate('admin_settings_saved', false, '{--RALLYE_NO_RALLYES_SELECTED--}');
 230         }
 231 } elseif ((getRequestParameter('sub') == 'users') && (getRequestParameter('rallye') > 0)) {
 232         // List users and their refs before start and current
 233         $result = SQL_QUERY_ESC("SELECT
 234         `userid`, `refs`, `curr_points`
 235 FROM
 236         `{?_MYSQL_PREFIX?}_rallye_users`
 237 WHERE
 238         `rallye_id`=%s
 239 ORDER BY
 240         `userid` ASC",
 241                 array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__);
 242         if (!SQL_HASZERONUMS($result)) {
 243                 $OUT = '';
 244                 $content['rallye'] = getRequestParameter('rallye');
 245                 while ($row = SQL_FETCHARRAY($result)) {
 246                         // Check for referal count
 247                         $cnt = getReferalRallyeRefsCount($row['userid'], $row['refs']);
 248
 249                         // Init variables
 250                         $bl = '';
 251                         $br = '';
 252
 253                         // Output row
 254                         if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = '<strong>'; $br = '</strong>'; }
 255
 256                         // Get user points
 257                         $points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1 LIMIT 1");
 258                         //* DEBUG: */ debugOutput(basename(__FILE__).':userid='.$row['userid'].',points='.$points.',opoints='.$row['curr_points']);
 259
 260                         // Prepare content
 261                         $row = array(
 262                                 'userid'  => $row['userid'],
 263                                 'bold_l'  => $bl ,
 264                                 'bold_r'  => $br ,
 265                                 'refs'    => $row['refs'],
 266                                 'cnt'     => $cnt,
 267                                 'opoints' => ($points - $row['curr_points']),
 268                         );
 269
 270                         // Load row template and switch color
 271                         $OUT .= loadTemplate('admin_list_rallye_usr_row', true, $row);
 272                 } // END - while
 273
 274                 // Remember rows
 275                 $content['rows']   = $OUT;
 276                 $content['rallye'] = getRequestParameter('rallye');
 277
 278                 // Free memory
 279                 SQL_FREERESULT($result);
 280
 281                 // Load template
 282                 loadTemplate('admin_list_rallye_usr', false, $content);
 283         } else {
 284                 // No entries found?
 285                 loadTemplate('admin_settings_saved', false, '{--RALLYE_ADMIN_USERS_404--}');
 286         }
 287 } else {
 288         // Start listing rallyes
 289         $result = SQL_QUERY("SELECT
 290         `id`, `admin_id`, `title`, `descr`, `template`, `start_time`, `end_time`,
 291         `auto_add_new_user`, `is_active`, `send_notify`, `notified`, `min_users`, `min_prices`
 292 FROM
 293         `{?_MYSQL_PREFIX?}_rallye_data`
 294 ORDER BY
 295         `start_time` DESC", __FILE__, __LINE__);
 296
 297         // Records found?
 298         if (!SQL_HASZERONUMS($result)) {
 299                 // List found rallyes
 300                 $OUT = '';
 301                 while ($data = SQL_FETCHARRAY($result)) {
 302                         // Load admin login
 303                         $data['login'] = getAdminLogin($data['admin_id']);
 304
 305                         // Count joined userids
 306                         $users = countSumTotalData($data['id'], 'rallye_users', 'id', 'rallye_id', true);
 307
 308                         // Did some users joined this rallye?
 309                         if ($users > 0) {
 310                                 // List joined users
 311                                 $users = '<a href="{%url=modules.php?module=admin&amp;what=list_rallyes&amp;sub=users&amp;rallye=' . $data['id'] . '%}" title="{--RALLYE_LIST_USERS_TITLE--}">' . $users . '</a>';
 312                         } // END - if
 313
 314                         // Alter some variables
 315                         if (empty($data['login']))    $data['login']     = '???';
 316
 317                         // Transfer data into array for the template
 318                         $row = array(
 319                                 'select'            => '<input type="checkbox" name="sel[' . $data['id'] . ']" class="admin_normal" value="1" />',
 320                                 'admin_id'          => $data['admin_id'],
 321                                 'login'             => $data['login'],
 322                                 'id'                => $data['id'],
 323                                 'title'             => $data['title'],
 324                                 'template'          => $data['template'],
 325                                 'users_content'     => $users,
 326                                 'start_date'        => generateDateTime($data['start_time'], 2),
 327                                 'end_date'          => generateDateTime($data['end_time']  , 2),
 328                                 'is_active'         => $data['is_active'],
 329                                 'send_notify'       => $data['send_notify'],
 330                                 'auto_add_new_user' => $data['auto_add_new_user'],
 331                                 'notified'          => $data['notified'],
 332                                 'prices_cnt'        => countSumTotalData($data['id'], 'rallye_prices', 'id', 'rallye_id', true),
 333                                 'descr'             => $data['descr'],
 334                                 'min_users'         => $data['min_users'],
 335                                 'min_prices'        => $data['min_prices'],
 336                         );
 337
 338                         // Is the rallye active or not?
 339                         switch ($data['is_active']) {
 340                                 case 'Y':
 341                                         // Rallye is active so do not edit it!
 342                                         $row['select']       = '<div class="big">' . $row['id'] . '</div>';
 343                                         $row['active_title'] = '{--RALLYE_DEACTIVATE_NOW--}';
 344                                         $row['active']       = '0';
 345                                         break;
 346
 347                                 case 'N':
 348                                         $row['active_title'] = '{--RALLYE_ACTIVATE_NOW--}';
 349                                         $row['active']       = 1;
 350                                         break;
 351                         } // END - switch
 352
 353                         // Notification to members?
 354                         switch ($data['send_notify']) {
 355                                 case 'Y':
 356                                         $row['notify_title'] = '{--RALLYE_STOP_NOTIFY_NOW--}';
 357                                         $row['notify']       = '0';
 358                                         break;
 359
 360                                 case 'N':
 361                                         $row['notify_title'] = '{--RALLYE_START_NOTIFY_NOW--}';
 362                                         $row['notify']       = 1;
 363                                         break;
 364                         } // END - switch
 365
 366                         // Auto-add of new joined members?
 367                         switch ($data['auto_add_new_user']) {
 368                                 case 'Y':
 369                                         $row['auto_title'] = '{--RALLYE_STOP_AUTO_ADD_NOW--}';
 370                                         $row['auto']       = '0';
 371                                         break;
 372
 373                                 case 'N':
 374                                         $row['auto_title'] = '{--RALLYE_START_AUTO_ADD_NOW--}';
 375                                         $row['auto']       = 1;
 376                                         break;
 377                         } // END - switch
 378
 379                         // Output row
 380                         $OUT .= loadTemplate('admin_list_rallyes_row', true, $row);
 381                 } // END - while
 382
 383                 // Free memory
 384                 SQL_FREERESULT($result);
 385
 386                 // Remember rows in array
 387                 $content['rows'] = $OUT;
 388
 389                 // Load template
 390                 loadTemplate('admin_list_rallyes', false, $content);
 391         } else {
 392                 // No rallyes setup so far
 393                 loadTemplate('admin_settings_saved', false, '{--RALLYE_NO_RALLYES_SETUP--}');
 394         }
 395 }
 396
 397 // [EOF]
 398 ?>