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)) {
 255                                 $bl = '<strong>';
 256                                 $br = '</strong>';
 257                         } // END - if
 258
 259                         // Get user points
 260                         $points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1 LIMIT 1");
 261                         //* DEBUG: */ debugOutput(basename(__FILE__).':userid='.$row['userid'].',points='.$points.',opoints='.$row['curr_points']);
 262
 263                         // Prepare content
 264                         $row = array(
 265                                 'userid'  => $row['userid'],
 266                                 'bold_l'  => $bl ,
 267                                 'bold_r'  => $br ,
 268                                 'refs'    => $row['refs'],
 269                                 'cnt'     => $cnt,
 270                                 'opoints' => ($points - $row['curr_points']),
 271                         );
 272
 273                         // Load row template and switch color
 274                         $OUT .= loadTemplate('admin_list_rallye_usr_row', true, $row);
 275                 } // END - while
 276
 277                 // Remember rows
 278                 $content['rows']   = $OUT;
 279                 $content['rallye'] = getRequestParameter('rallye');
 280
 281                 // Free memory
 282                 SQL_FREERESULT($result);
 283
 284                 // Load template
 285                 loadTemplate('admin_list_rallye_usr', false, $content);
 286         } else {
 287                 // No entries found?
 288                 loadTemplate('admin_settings_saved', false, '{--RALLYE_ADMIN_USERS_404--}');
 289         }
 290 } else {
 291         // Start listing rallyes
 292         $result = SQL_QUERY("SELECT
 293         `id`, `admin_id`, `title`, `descr`, `template`, `start_time`, `end_time`,
 294         `auto_add_new_user`, `is_active`, `send_notify`, `notified`, `min_users`, `min_prices`
 295 FROM
 296         `{?_MYSQL_PREFIX?}_rallye_data`
 297 ORDER BY
 298         `start_time` DESC", __FILE__, __LINE__);
 299
 300         // Records found?
 301         if (!SQL_HASZERONUMS($result)) {
 302                 // List found rallyes
 303                 $OUT = '';
 304                 while ($data = SQL_FETCHARRAY($result)) {
 305                         // Load admin login
 306                         $data['login'] = getAdminLogin($data['admin_id']);
 307
 308                         // Count joined userids
 309                         $users = countSumTotalData($data['id'], 'rallye_users', 'id', 'rallye_id', true);
 310
 311                         // Did some users joined this rallye?
 312                         if ($users > 0) {
 313                                 // List joined users
 314                                 $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>';
 315                         } // END - if
 316
 317                         // Alter some variables
 318                         if (empty($data['login']))    $data['login']     = '???';
 319
 320                         // Transfer data into array for the template
 321                         $row = array(
 322                                 'select'            => '<input type="checkbox" name="sel[' . $data['id'] . ']" class="admin_normal" value="1" />',
 323                                 'admin_id'          => $data['admin_id'],
 324                                 'login'             => $data['login'],
 325                                 'id'                => $data['id'],
 326                                 'title'             => $data['title'],
 327                                 'template'          => $data['template'],
 328                                 'users_content'     => $users,
 329                                 'start_date'        => generateDateTime($data['start_time'], 2),
 330                                 'end_date'          => generateDateTime($data['end_time']  , 2),
 331                                 'is_active'         => $data['is_active'],
 332                                 'send_notify'       => $data['send_notify'],
 333                                 'auto_add_new_user' => $data['auto_add_new_user'],
 334                                 'notified'          => $data['notified'],
 335                                 'prices_cnt'        => countSumTotalData($data['id'], 'rallye_prices', 'id', 'rallye_id', true),
 336                                 'descr'             => $data['descr'],
 337                                 'min_users'         => $data['min_users'],
 338                                 'min_prices'        => $data['min_prices'],
 339                         );
 340
 341                         // Is the rallye active or not?
 342                         switch ($data['is_active']) {
 343                                 case 'Y':
 344                                         // Rallye is active so do not edit it!
 345                                         $row['select']       = '<div class="big">' . $row['id'] . '</div>';
 346                                         $row['active_title'] = '{--RALLYE_DEACTIVATE_NOW--}';
 347                                         $row['active']       = '0';
 348                                         break;
 349
 350                                 case 'N':
 351                                         $row['active_title'] = '{--RALLYE_ACTIVATE_NOW--}';
 352                                         $row['active']       = 1;
 353                                         break;
 354                         } // END - switch
 355
 356                         // Notification to members?
 357                         switch ($data['send_notify']) {
 358                                 case 'Y':
 359                                         $row['notify_title'] = '{--RALLYE_STOP_NOTIFY_NOW--}';
 360                                         $row['notify']       = '0';
 361                                         break;
 362
 363                                 case 'N':
 364                                         $row['notify_title'] = '{--RALLYE_START_NOTIFY_NOW--}';
 365                                         $row['notify']       = 1;
 366                                         break;
 367                         } // END - switch
 368
 369                         // Auto-add of new joined members?
 370                         switch ($data['auto_add_new_user']) {
 371                                 case 'Y':
 372                                         $row['auto_title'] = '{--RALLYE_STOP_AUTO_ADD_NOW--}';
 373                                         $row['auto']       = '0';
 374                                         break;
 375
 376                                 case 'N':
 377                                         $row['auto_title'] = '{--RALLYE_START_AUTO_ADD_NOW--}';
 378                                         $row['auto']       = 1;
 379                                         break;
 380                         } // END - switch
 381
 382                         // Output row
 383                         $OUT .= loadTemplate('admin_list_rallyes_row', true, $row);
 384                 } // END - while
 385
 386                 // Free memory
 387                 SQL_FREERESULT($result);
 388
 389                 // Remember rows in array
 390                 $content['rows'] = $OUT;
 391
 392                 // Load template
 393                 loadTemplate('admin_list_rallyes', false, $content);
 394         } else {
 395                 // No rallyes setup so far
 396                 loadTemplate('admin_settings_saved', false, '{--RALLYE_NO_RALLYES_SETUP--}');
 397         }
 398 }
 399
 400 // [EOF]
 401 ?>