Also these SQLs require support for NULL

[mailer.git] / inc / modules / admin / what-list_rallyes.php

diff --git a/inc/modules/admin/what-list_rallyes.php b/inc/modules/admin/what-list_rallyes.php
index ebaf99f9741518a9536050f43a40be6ddb0d3eb3..9310621f7f59e1e6565b21a60fc9ecd0e6ecc0a4 100644 (file)
--- a/inc/modules/admin/what-list_rallyes.php
+++ b/inc/modules/admin/what-list_rallyes.php
@@ -17,7 +17,7 @@
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
  * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -47,52 +47,52 @@ addYouAreHereLink('admin', __FILE__);
 $message = '';
 
 // Quick actions on a rallye
-if (isGetRequestParameterSet('rallye')) {
+if (isGetRequestElementSet('rallye')) {
        // Init SQL queries
        initSqls();
 
-       if (isGetRequestParameterSet('activate')) {
+       if (isGetRequestElementSet('activate')) {
                // Activate / deactivate
-               switch (getRequestParameter('activate')) {
+               switch (getRequestElement('activate')) {
                        case '1': // Activate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1",
-                                       array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
 
                        case '0': // Deactivate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1",
-                                       array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
                } // END - switch
-       } elseif (isGetRequestParameterSet('notify')) {
+       } elseif (isGetRequestElementSet('notify')) {
                // Automatic notification
-               switch (getRequestParameter('notify')) {
+               switch (getRequestElement('notify')) {
                        case '1': // Activate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1",
-                                       array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
 
                        case '0': // Deactivate
                                addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1",
-                                       array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
                } // END - switch
-       } elseif (isGetRequestParameterSet('auto')) {
+       } elseif (isGetRequestElementSet('auto')) {
                // Automatic adding of new members
-               switch (getRequestParameter('auto')) {
+               switch (getRequestElement('auto')) {
                        case '1': // Activate
                                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",
-                                       array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
 
                        case '0': // Deactivate
                                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",
-                                       array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__, false)
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
                                );
                                break;
                } // END - switch
@@ -107,7 +107,7 @@ if (isGetRequestParameterSet('rallye')) {
                initSqls();
 
                // Delete selected rallyes and all it's data
-               foreach (postRequestParameter('sel') as $id => $selected) {
+               foreach (postRequestElement('sel') as $id => $selected) {
                        // Remove selected rallye entirely...
                        addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1",
                                array(bigintval($id)), __FILE__, __LINE__, false));
@@ -133,13 +133,13 @@ if (isGetRequestParameterSet('rallye')) {
                initSqls();
 
                // Change selected rallyes and all it's data
-               foreach (postRequestParameter('title') as $id => $title) {
+               foreach (postRequestElement('title') as $id => $title) {
                        // Secure id number
                        $id = bigintval($id);
 
                        // Generate timestamps
-                       $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));
-                       $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)  );
+                       $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
                        addSql(SQL_QUERY_ESC("UPDATE
@@ -157,12 +157,12 @@ WHERE
 LIMIT 1",
                        array(
                                $title,
-                               postRequestParameter('descr', $id),
-                               postRequestParameter('templ', $id),
+                               postRequestElement('descr', $id),
+                               postRequestElement('templ', $id),
                                bigintval($START),
                                bigintval($END),
-                               bigintval(postRequestParameter('min_users', $id)),
-                               bigintval(postRequestParameter('min_prices', $id)),
+                               bigintval(postRequestElement('min_users', $id)),
+                               bigintval(postRequestElement('min_prices', $id)),
                                $id
                        ), __FILE__, __LINE__, false));
                }
@@ -180,10 +180,10 @@ if (isFormSent('edit')) {
        if (ifPostContainsSelections()) {
                // Make all selected and deactivated rallyes editable
                $OUT = '';
-               foreach (postRequestParameter('sel') as $id => $selected) {
+               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`
+       `title`,`descr`,`template`,`start_time`,`end_time`,`min_users`,`min_prices`
 FROM
        `{?_MYSQL_PREFIX?}_rallye_data`
 WHERE
@@ -226,20 +226,20 @@ LIMIT 1",
                // Nothing selected to edit
                displayMessage('{--RALLYE_NO_RALLYES_SELECTED--}');
        }
-} elseif ((getRequestParameter('sub') == 'users') && (getRequestParameter('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`
+       `userid`,`refs`,`curr_points`
 FROM
        `{?_MYSQL_PREFIX?}_rallye_users`
 WHERE
        `rallye_id`=%s
 ORDER BY
        `userid` ASC",
-               array(bigintval(getRequestParameter('rallye'))), __FILE__, __LINE__);
+               array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__);
        if (!SQL_HASZERONUMS($result)) {
                $OUT = '';
-               $content['rallye'] = getRequestParameter('rallye');
+               $content['rallye'] = getRequestElement('rallye');
                while ($row = SQL_FETCHARRAY($result)) {
                        // Check for referal count
                        $count = getReferalRallyeRefsCount($row['userid'], $row['refs']);
@@ -274,7 +274,7 @@ ORDER BY
 
                // Remember rows
                $content['rows']   = $OUT;
-               $content['rallye'] = getRequestParameter('rallye');
+               $content['rallye'] = getRequestElement('rallye');
 
                // Free memory
                SQL_FREERESULT($result);
@@ -288,8 +288,8 @@ ORDER BY
 } 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`
+       `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`
 ORDER BY