A lot texts rewritten and exclamation signs removed
[mailer.git] / inc / modules / admin / what-list_rallyes.php
index 9794b452293657ede6bf51c00277df100b708aba..f7fdcdc321f4f138089edf4144c59cb3be4a05a8 100644 (file)
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Bestehende Rallyes auflisten                     *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $Date::                                                            $ *
+ * $Tag:: 0.2.1-FINAL                                                 $ *
+ * $Author::                                                          $ *
+ * Needs to be in all Files and every File needs "svn propset           *
+ * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  ************************************************************************/
 
 // Some security stuff...
-if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
-       $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
-       require($INC);
+if ((!defined('__SECURITY')) || (!isAdmin())) {
+       die();
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", __FILE__);
+addMenuDescription('admin', __FILE__);
 
-if (!REQUEST_ISSET_GET(('sub'))) REQUEST_SET_GET('sub', "");
-$MSG = "";
+if (!isGetRequestElementSet('sub')) setRequestGetElement('sub', '');
+$message = '';
 
 // Quick actions on a rallye
-if (REQUEST_ISSET_GET(('rallye'))) {
+if (isGetRequestElementSet(('rallye'))) {
        // Init SQL queries
-       INIT_SQLS();
+       initSqls();
 
-       if (REQUEST_ISSET_GET(('activate'))) {
+       if (isGetRequestElementSet(('activate'))) {
                // Activate / deactivate
-               switch (REQUEST_GET('activate'))
+               switch (getRequestElement('activate'))
                {
-               case "1": // Activate
-                       ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='Y' WHERE id=%s AND is_active='N' LIMIT 1");
-                       break;
+                       case 1: // Activate
+                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET is_active='Y' WHERE `id`=%s AND is_active='N' LIMIT 1");
+                               break;
 
-               case "0": // Deactivate
-                       ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='N' WHERE id=%s AND is_active='Y' LIMIT 1");
-                       break;
+                       case 0: // Deactivate
+                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET is_active='N' WHERE `id`=%s AND is_active='Y' LIMIT 1");
+                               break;
                }
-       } elseif (REQUEST_ISSET_GET(('notify'))) {
+       } elseif (isGetRequestElementSet('notify')) {
                // Automatic notification
-               switch (REQUEST_GET('notify'))
+               switch (getRequestElement('notify'))
                {
-               case "1": // Activate
-                       ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='Y' WHERE id=%s AND send_notify='N' LIMIT 1");
-                       break;
+                       case 1: // Activate
+                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET send_notify='Y' WHERE `id`=%s AND send_notify='N' LIMIT 1");
+                               break;
 
-               case "0": // Deactivate
-                       ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='N' WHERE id=%s AND send_notify='Y' LIMIT 1");
-                       break;
+                       case 0: // Deactivate
+                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET send_notify='N' WHERE `id`=%s AND send_notify='Y' LIMIT 1");
+                               break;
                }
-       } elseif (REQUEST_ISSET_GET(('auto'))) {
+       } elseif (isGetRequestElementSet(('auto'))) {
                // Automatic adding of new members
-               switch (REQUEST_GET('auto'))
+               switch (getRequestElement('auto'))
                {
-               case "1": // Activate
-                       ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='Y' WHERE id=%s AND auto_add_new_user='N' LIMIT 1");
-                       break;
+                       case 1: // Activate
+                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET auto_add_new_user='Y' WHERE `id`=%s AND auto_add_new_user='N' LIMIT 1");
+                               break;
 
-               case "0": // Deactivate
-                       ADD_SQL("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='N' WHERE id=%s AND auto_add_new_user='Y' LIMIT 1");
-                       break;
+                       case 0: // Deactivate
+                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET auto_add_new_user='N' WHERE `id`=%s AND auto_add_new_user='Y' LIMIT 1");
+                               break;
                }
        }
 
        // Run SQL command
        runFilterChain('run_sqls');
-} elseif (REQUEST_ISSET_POST(('remove'))) {
+} elseif (isPostRequestElementSet('remove')) {
        // Delete rallyes
-       $SEL = SELECTION_COUNT(REQUEST_POST('sel'));
+       $SEL = countPostSelection();
        if ($SEL > 0) {
                // Init SQLs
-               INIT_SQLS();
+               initSqls();
 
                // Delete selected rallyes and all it's data
-               foreach (REQUEST_POST('sel') as $id => $selected) {
+               foreach (postRequestElement('sel') as $id => $selected) {
                        // Remove selected rallye entirely...
-                       ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_data` WHERE id=%s LIMIT 1",
-                               array(bigintval($id)), __FILE__, __LINE__, false));
-                       ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_prices` WHERE rallye_id=%s",
-                               array(bigintval($id)), __FILE__, __LINE__, false));
-                       ADD_SQL(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s",
-                               array(bigintval($id)), __FILE__, __LINE__, false));
+                       addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1",
+                       array(bigintval($id)), __FILE__, __LINE__, false));
+                       addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE rallye_id=%s",
+                       array(bigintval($id)), __FILE__, __LINE__, false));
+                       addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE rallye_id=%s",
+                       array(bigintval($id)), __FILE__, __LINE__, false));
                } // END - foreach
 
                // Run SQLS
                runFilterChain('run_sqls');
 
                // Output message
-               $MSG = getMessage('RALLYE_DELETED');
+               $message = getMessage('RALLYE_DELETED');
        } else {
                // No rallye selected to delete!
-               $MSG = getMessage('RALLYE_DELETE_NOTHING_SELECTED');
+               $message = getMessage('RALLYE_DELETE_NOTHING_SELECTED');
        }
-} elseif (REQUEST_ISSET_POST(('change'))) {
+} elseif (isPostRequestElementSet('change')) {
        // Change rallye
-       $SEL = SELECTION_COUNT(REQUEST_POST('title'));
+       $SEL = countSelection(postRequestElement('title'));
        if ($SEL > 0) {
                // Init SQLs
-               INIT_SQLS();
+               initSqls();
 
                // Change selected rallyes and all it's data
-               foreach (REQUEST_POST('title') as $id => $title) {
-                       // Secure ID number
+               foreach (postRequestElement('title') as $id => $title) {
+                       // Secure id number
                        $id = bigintval($id);
 
                        // Generate timestamps
-                       $START = mktime(REQUEST_POST('start_hour', $id), REQUEST_POST('start_min', $id), REQUEST_POST('start_sec', $id), REQUEST_POST('start_month', $id), REQUEST_POST('start_day', $id), REQUEST_POST('start_year', $id));
-                       $END   = mktime(REQUEST_POST('end_hour', $id)  , REQUEST_POST('end_min', $id)  , REQUEST_POST('end_sec', $id)  , REQUEST_POST('end_month', $id)  , REQUEST_POST('end_day', $id)  , REQUEST_POST('end_year', $id)  );
+                       $START = mktime(postRequestElement('start_hour', $id), postRequestElement('start_min', $id), postRequestElement('start_sec', $id), postRequestElement('start_month', $id), postRequestElement('start_day', $id), postRequestElement('start_year', $id));
+                       $END   = mktime(postRequestElement('end_hour', $id)  , postRequestElement('end_min', $id)  , postRequestElement('end_sec', $id)  , postRequestElement('end_month', $id)  , postRequestElement('end_day', $id)  , postRequestElement('end_year', $id)  );
 
                        // Update entry
-                       ADD_SQL(SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET
+                       addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET
 title='%s',
 descr='%s',
 template='%s',
@@ -140,40 +144,40 @@ start_time='%s',
 end_time='%s',
 min_users='%s',
 min_prices='%s'
-WHERE id='".$id."' LIMIT 1",
-                               array(
-                                       $title,
-                                       REQUEST_POST('descr', $id),
-                                       REQUEST_POST('templ', $id),
-                                       bigintval($START),
-                                       bigintval($END),
-                                       bigintval(REQUEST_POST('min_users', $id)),
-                                       bigintval(REQUEST_POST('min_prices', $id)),
-                                       $id
-                               ), __FILE__, __LINE__, false));
+WHERE `id`='".$id."' LIMIT 1",
+                       array(
+                       $title,
+                       postRequestElement('descr', $id),
+                       postRequestElement('templ', $id),
+                       bigintval($START),
+                       bigintval($END),
+                       bigintval(postRequestElement('min_users', $id)),
+                       bigintval(postRequestElement('min_prices', $id)),
+                       $id
+                       ), __FILE__, __LINE__, false));
                }
 
                // Run SQLS
                runFilterChain('run_sqls');
 
                // Output message
-               $MSG = getMessage('RALLYE_CHANGED');
+               $message = getMessage('RALLYE_CHANGED');
        }
 }
 
-if (REQUEST_ISSET_POST('edit')) {
+if (isPostRequestElementSet('edit')) {
        // Check for selections
-       $SEL = SELECTION_COUNT(REQUEST_POST('sel'));
+       $SEL = countPostSelection();
        if ($SEL > 0) {
                // Make all selected and deactivated rallyes editable
-               $OUT = ""; $SW = 2;
-               foreach (REQUEST_POST('sel') as $id => $selected) {
+               $OUT = ''; $SW = 2;
+               foreach (postRequestElement('sel') as $id => $selected) {
                        // Load rallye basic data
                        $result = SQL_QUERY_ESC("SELECT title, descr, template, start_time, end_time, min_users, min_prices
-FROM `{!_MYSQL_PREFIX!}_rallye_data`
+FROM `{?_MYSQL_PREFIX?}_rallye_data`
 WHERE `id`=%s
 LIMIT 1",
-                               array(bigintval($id)), __FILE__, __LINE__);
+                       array(bigintval($id)), __FILE__, __LINE__);
                        // Fetch an array
                        $content = SQL_FETCHARRAY($result);
 
@@ -181,209 +185,206 @@ LIMIT 1",
                        SQL_FREERESULT($result);
 
                        // Starting day
-                       $content['s_sec']   = ADD_SELECTION("sec"  , date("s", $content['start_time']), "start", $id);
-                       $content['s_min']   = ADD_SELECTION("min"  , date("i", $content['start_time']), "start", $id);
-                       $content['s_hour']  = ADD_SELECTION("hour" , date("G", $content['start_time']), "start", $id);
-                       $content['s_day']   = ADD_SELECTION("day"  , date("d", $content['start_time']), "start", $id);
-                       $content['s_month'] = ADD_SELECTION("month", date("m", $content['start_time']), "start", $id);
-                       $content['s_year']  = ADD_SELECTION("year" , date('Y', $content['start_time']), "start", $id);
+                       $content['s_sec']   = addSelectionBox('sec'  , date('s', $content['start_time']), 'start', $id);
+                       $content['s_min']   = addSelectionBox('min'  , date('i', $content['start_time']), 'start', $id);
+                       $content['s_hour']  = addSelectionBox('hour' , date('G', $content['start_time']), 'start', $id);
+                       $content['s_day']   = addSelectionBox('day'  , date('d', $content['start_time']), 'start', $id);
+                       $content['s_month'] = addSelectionBox('month', date('m', $content['start_time']), 'start', $id);
+                       $content['s_year']  = addSelectionBox('year' , date('Y', $content['start_time']), 'start', $id);
 
                        // Ending day
-                       $content['e_sec']   = ADD_SELECTION("sec"  , date("s", $content['end_time'])  , "end"  , $id);
-                       $content['e_min']   = ADD_SELECTION("min"  , date("i", $content['end_time'])  , "end"  , $id);
-                       $content['e_hour']  = ADD_SELECTION("hour" , date("G", $content['end_time'])  , "end"  , $id);
-                       $content['e_day']   = ADD_SELECTION("day"  , date("d", $content['end_time'])  , "end"  , $id);
-                       $content['e_month'] = ADD_SELECTION("month", date("m", $content['end_time'])  , "end"  , $id);
-                       $content['e_year']  = ADD_SELECTION("year" , date('Y', $content['end_time'])  , "end"  , $id);
+                       $content['e_sec']   = addSelectionBox('sec'  , date('s', $content['end_time'])  , 'end'  , $id);
+                       $content['e_min']   = addSelectionBox('min'  , date('i', $content['end_time'])  , 'end'  , $id);
+                       $content['e_hour']  = addSelectionBox('hour' , date('G', $content['end_time'])  , 'end'  , $id);
+                       $content['e_day']   = addSelectionBox('day'  , date('d', $content['end_time'])  , 'end'  , $id);
+                       $content['e_month'] = addSelectionBox('month', date('m', $content['end_time'])  , 'end'  , $id);
+                       $content['e_year']  = addSelectionBox('year' , date('Y', $content['end_time'])  , 'end'  , $id);
 
                        // Remember other values
-                       $content['templ']      = RALLYE_TEMPLATE_SELECTION("templ[".$id."]", $content['template']);
+                       $content['templ']      = addReferalRallyeTemplateSelection('templ['.$id.']', $content['template']);
                        $content['sw']         = $SW;
                        $content['id']         = $id;
 
                        // Output row
-                       $OUT .= LOAD_TEMPLATE("admin_edit_rallyes_row", true, $content);
+                       $OUT .= loadTemplate('admin_edit_rallyes_row', true, $content);
 
                        // Color switching
                        $SW = 3 - $SW;
                }
 
-               // Remember rows in constant
-               define('__RALLYE_ROWS', $OUT);
-
                // Load final template
-               LOAD_TEMPLATE("admin_edit_rallyes");
+               loadTemplate('admin_edit_rallyes', false, $OUT);
        } else {
                // Nothing selected to edit
-               LOAD_TEMPLATE("admin_settings_saved", false, LOAD_TEMPLATE("admin_list_rallye_noselect", true));
+               loadTemplate('admin_settings_saved', false, loadTemplate('admin_list_rallye_noselect', true));
        }
-} elseif ((REQUEST_GET('sub') == "users") && (REQUEST_GET('rallye') > 0)) {
+} elseif ((getRequestElement('sub') == 'users') && (getRequestElement('rallye') > 0)) {
        // List users and their refs before start and current
-       $result = SQL_QUERY_ESC("SELECT userid, refs, curr_points FROM `{!_MYSQL_PREFIX!}_rallye_users` WHERE rallye_id=%s ORDER BY userid",
-               array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);
+       $result = SQL_QUERY_ESC("SELECT userid, refs, curr_points FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE rallye_id=%s ORDER BY `userid` ASC",
+       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
-               $OUT = ""; $SW = 2;
-               // @TODO Rewrite this constant
-               define('__RALLYE_VALUE', REQUEST_GET('rallye'));
-               while ($content = SQL_FETCHARRAY($result)) {
+               $OUT = ''; $SW = 2;
+               $content['rallye'] = getRequestElement('rallye');
+               while ($row = SQL_FETCHARRAY($result)) {
                        // Check for referal count
-                       $cnt = RALLYE_GET_REFCOUNT($content['userid'], $content['refs']);
+                       $cnt = getReferalRallyeRefsCount($row['userid'], $row['refs']);
 
                        // Init variables
-                       $bl = "";
-                       $br = "";
+                       $bl = '';
+                       $br = '';
 
                        // Output row
-                       if (($content['curr_points'] > 0) && ($cnt > 0)) { $bl = "<strong>"; $br = "</strong>"; }
-                       if (($content['refs'] > 0) || ($cnt > 0)) {
+                       if (($row['curr_points'] > 0) && ($cnt > 0)) { $bl = "<strong>"; $br = "</strong>"; }
+                       if (($row['refs'] > 0) || ($cnt > 0)) {
                                // Insert link to referal list
-                               //* DEBUG: */ echo "-".$content['userid']."/".$cnt."/".$content['refs']."-<br />";
-                               $cnt = ADMIN_USER_PROFILE_LINK($content['userid'], $cnt, "list_refs");
-                               $content['refs'] = ADMIN_USER_PROFILE_LINK($content['userid'], $content['refs'], "list_refs");
+                               //* DEBUG: */ outputHtml('-'.$row['userid'].'/'.$cnt.'/'.$row['refs']."-<br />");
+                               $cnt = generateUserProfileLink($row['userid'], $cnt, 'list_refs');
+                               $row['refs'] = generateUserProfileLink($row['userid'], $row['refs'], 'list_refs');
                        } // END - if
 
                        // Get user points
-                       $points = GET_TOTAL_DATA($content['userid'], "user_points", "points", "userid", false, " AND ref_depth=1 LIMIT 1");
-                       //* DEBUG: */ echo basename(__FILE__).":uid={$content['userid']},points={$points},opoints={$content['curr_points']}<br />\n";
+                       $points = countSumTotalData($row['userid'], 'user_points', 'points', 'userid', false, " AND `ref_depth`=1 LIMIT 1");
+                       //* DEBUG: */ outputHtml(basename(__FILE__).":userid={$row['userid']},points={$points},opoints={$row['curr_points']}<br />");
 
                        // Prepare content
-                       // @TODO Rewritings: uid->userid,opoints->curr_points,old->refs in template
-                       $content = array(
+                       // @TODO Rewritings: userid->userid,opoints->curr_points,old->refs in template
+                       $row = array(
                                'sw'      => $SW ,
-                               'uid'     => $content['userid'],
+                               'userid'     => $row['userid'],
                                'bold_l'  => $bl ,
                                'bold_r'  => $br ,
-                               'old'     => $content['refs'],
+                               'old'     => $row['refs'],
                                'cnt'     => $cnt,
-                               'opoints' => TRANSLATE_COMMA($points - $content['curr_points']),
+                               'opoints' => translateComma($points - $row['curr_points']),
                        );
 
                        // Load row template and switch color
-                       $OUT .= LOAD_TEMPLATE("admin_list_rallye_usr_row", true, $content);
+                       $OUT .= loadTemplate('admin_list_rallye_usr_row', true, $row);
                        $SW = 3 - $SW;
                } // END - while
 
                // Free memory
                SQL_FREERESULT($result);
-               define('__RALLYE_USER_ROWS', $OUT);
 
                // Load template
-               LOAD_TEMPLATE("admin_list_rallye_usr");
+               loadTemplate('admin_list_rallye_usr', false, $OUT);
        } else {
                // No entries found?
-               LOAD_TEMPLATE("admin_settings_saved", false, getMessage('RALLYE_ADMIN_USERS_404'));
+               loadTemplate('admin_settings_saved', false, getMessage('RALLYE_ADMIN_USERS_404'));
        }
 } else {
        // Start listing rallyes
        $result = SQL_QUERY("SELECT id, admin_id, title, descr, template, start_time, end_time, auto_add_new_user, is_active, send_notify, notified, min_users, min_prices
-FROM `{!_MYSQL_PREFIX!}_rallye_data`
+FROM `{?_MYSQL_PREFIX?}_rallye_data`
 ORDER BY start_time DESC",
-               __FILE__, __LINE__);
+       __FILE__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
                // List found rallyes
-               $OUT = ""; $SW = 2;
-               while ($content = SQL_FETCHARRAY($result)) {
+               $OUT = ''; $SW = 2;
+               while ($row = SQL_FETCHARRAY($result)) {
                        // Load admin login
-                       $content['alogin'] = GET_ADMIN_LOGIN($content['admin_id']);
+                       $row['login'] = getAdminLogin($row['admin_id']);
 
                        // Count joined userids
-                       $joined = GET_TOTAL_DATA($content['id'], "rallye_users", "id", "rallye_id", true);
+                       $joined = countSumTotalData($row['id'], "rallye_users", 'id', "rallye_id", true);
 
                        // Did some users joined this rallye?
                        if ($joined > 0) {
                                // List joined users
-                               $joined = "<a href=\"{!URL!}/modules.php?module=admin&amp;what=list_rallyes&amp;sub=users&amp;rallye=".$content['id']."\" title=\"{--RALLYE_LIST_USERS_TITLE--}\">".$joined."</a>";
+                               $joined = "<a href=\"{?URL?}/modules.php?module=admin&amp;what=list_rallyes&amp;sub=users&amp;rallye=".$row['id']."\" title=\"{--RALLYE_LIST_USERS_TITLE--}\">".$joined."</a>";
                        } // END - if
 
                        // Alter some variables
-                       if (empty($content['alogin']))   $content['alogin']    = "???";
-                       if (empty($content['template'])) $content['template']  = "---";
-                       if (empty($content['descr']))    $content['descr']     = "---";
+                       if (empty($row['login']))   $row['login']    = '???';
+                       if (empty($row['template'])) $row['template']  = '---';
+                       if (empty($row['descr']))    $row['descr']     = '---';
 
                        // Transfer data into array for the template
-                       // @TODO Rewritings: aid->admin_id in template
-                       $content = array(
-                               'select'     => "<input type=\"checkbox\" name=\"sel[".$content['id']."]\" class=\"admin_normal\" value=\"1\" />",
-                               'aid'        => $content['admin_id'],
-                               'email_link' => CREATE_EMAIL_LINK($content['admin_id']),
-                               'alogin'     => $content['alogin'],
-                               'id'         => $content['id'],
+                       // @TODO Rewritings: admin_id->admin_id in template
+                       $row = array(
+                               'select'     => "<input type=\"checkbox\" name=\"sel[".$row['id']."]\" class=\"admin_normal\" value=\"1\" />",
+                               'admin_id'        => $row['admin_id'],
+                               'email_link' => generateEmailLink($row['admin_id']),
+                               'login'      => $row['login'],
+                               'id'         => $row['id'],
                                'sw'         => $SW,
-                               'title'      => $content['title'],
-                               'template'   => $content['template'],
+                               'title'      => $row['title'],
+                               'template'   => $row['template'],
                                'joined'     => $joined,
-                               'start_date' => MAKE_DATETIME($content['start_time'], "2"),
-                               'end_date'   => MAKE_DATETIME($content['end_time']  , "2"),
-                               'active_lnk' => TRANSLATE_YESNO($content['is_active']),
-                               'notify_lnk' => TRANSLATE_YESNO($content['send_notify']),
-                               'auto_lnk'   => TRANSLATE_YESNO($content['auto_add_new_user']),
-                               'notified'   => TRANSLATE_YESNO($content['notified']),
-                               'prices_cnt' => GET_TOTAL_DATA($content['id'], "rallye_prices", "id", "rallye_id", true),
-                               'descr'      => COMPILE_CODE($content['descr']),
-                               'min_users'  => $content['min_users'],
-                               'min_prices' => $content['min_prices'],
+                               'start_date' => generateDateTime($row['start_time'], 2),
+                               'end_date'   => generateDateTime($row['end_time']  , 2),
+                               'active_lnk' => translateYesNo($row['is_active']),
+                               'notify_lnk' => translateYesNo($row['send_notify']),
+                               'auto_lnk'   => translateYesNo($row['auto_add_new_user']),
+                               'notified'   => translateYesNo($row['notified']),
+                               'prices_cnt' => translateComma(countSumTotalData($row['id'], 'rallye_prices', 'id', 'rallye_id', true)),
+                               'descr'      => $row['descr'],
+                               'min_users'  => $row['min_users'],
+                               'min_prices' => $row['min_prices'],
                        );
 
                        // Is the rallye active or not?
-                       switch ($content['is_active'])
+                       switch ($row['is_active'])
                        {
-                       case "Y":
-                               // Rallye is active so do not edit it!
-                               $content['select'] = "<div class=\"big\">".$content['id']."</div>";
-                               $content['active_title'] = getMessage('RALLYE_DEACTIVATE_NOW');
-                               $content['active'] = 0;
-                               break;
-
-                       case "N":
-                               $content['active_title'] = getMessage('RALLYE_ACTIVATE_NOW');
-                               $content['active'] = "1";
-                               break;
+                               case 'Y':
+                                       // Rallye is active so do not edit it!
+                                       $row['select'] = "<div class=\"big\">".$row['id']."</div>";
+                                       $row['active_title'] = getMessage('RALLYE_DEACTIVATE_NOW');
+                                       $row['active'] = 0;
+                                       break;
+
+                               case 'N':
+                                       $row['active_title'] = getMessage('RALLYE_ACTIVATE_NOW');
+                                       $row['active'] = 1;
+                                       break;
                        }
 
                        // Notification to members?
-                       switch ($content['send_notify'])
+                       switch ($row['send_notify'])
                        {
-                       case "Y":
-                               $content['notify_title'] = getMessage('RALLYE_STOP_NOTIFY_NOW');
-                               $content['notify'] = 0;
-                               break;
-
-                       case "N":
-                               $content['notify_title'] = getMessage('RALLYE_START_NOTIFY_NOW');
-                               $content['notify'] = "1";
-                               break;
+                               case 'Y':
+                                       $row['notify_title'] = getMessage('RALLYE_STOP_NOTIFY_NOW');
+                                       $row['notify'] = 0;
+                                       break;
+
+                               case 'N':
+                                       $row['notify_title'] = getMessage('RALLYE_START_NOTIFY_NOW');
+                                       $row['notify'] = 1;
+                                       break;
                        }
 
                        // Auto-add of new joined members?
-                       switch ($content['auto_add_new_user'])
+                       switch ($row['auto_add_new_user'])
                        {
-                       case "Y":
-                               $content['auto_title'] = getMessage('RALLYE_STOP_AUTO_ADD_NOW');
-                               $content['auto'] = 0;
-                               break;
-
-                       case "N":
-                               $content['auto_title'] = getMessage('RALLYE_START_AUTO_ADD_NOW');
-                               $content['auto'] = "1";
-                               break;
+                               case 'Y':
+                                       $row['auto_title'] = getMessage('RALLYE_STOP_AUTO_ADD_NOW');
+                                       $row['auto'] = 0;
+                                       break;
+
+                               case 'N':
+                                       $row['auto_title'] = getMessage('RALLYE_START_AUTO_ADD_NOW');
+                                       $row['auto'] = 1;
+                                       break;
                        }
 
                        // Output row
-                       $OUT .= LOAD_TEMPLATE("admin_list_rallyes_row", true, $content);
+                       $OUT .= loadTemplate('admin_list_rallyes_row', true, $row);
                        $SW = 3 - $SW;
                }
 
                // Free memory
                SQL_FREERESULT($result);
-               define('__RALLYE_ROWS', $OUT);
+
+               // Remember rows in array
+               $content['rows'] = $OUT;
 
                // Load template
-               LOAD_TEMPLATE("admin_list_rallyes");
+               loadTemplate('admin_list_rallyes', false, $content);
        } else {
                // No rallyes setup so far
-               LOAD_TEMPLATE("admin_settings_saved", false, getMessage('RALLYE_NO_RALLYES_SETUP'));
+               loadTemplate('admin_settings_saved', false, getMessage('RALLYE_NO_RALLYES_SETUP'));
        }
 }
 
-//
+// [EOF]
 ?>