Should now work again, missed to fill out mask
[mailer.git] / inc / modules / admin / what-list_rallyes.php
index 8c46526..9a4c3b1 100644 (file)
@@ -56,33 +56,45 @@ if (isGetRequestElementSet('rallye')) {
                // Activate / deactivate
                switch (getRequestElement('activate')) {
                        case 1: // Activate
-                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1");
+                               addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='Y' WHERE `id`=%s AND `is_active`='N' LIMIT 1"
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+                               );
                                break;
 
                        case 0: // Deactivate
-                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1");
+                               addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `is_active`='N' WHERE `id`=%s AND `is_active`='Y' LIMIT 1"
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+                               );
                                break;
                }
        } elseif (isGetRequestElementSet('notify')) {
                // Automatic notification
                switch (getRequestElement('notify')) {
                        case 1: // Activate
-                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1");
+                               addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='Y' WHERE `id`=%s AND `send_notify`='N' LIMIT 1"
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+                               );
                                break;
 
                        case 0: // Deactivate
-                               addSql("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1");
+                               addSql(SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `send_notify`='N' WHERE `id`=%s AND `send_notify`='Y' LIMIT 1"
+                                       array(bigintval(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+                               );
                                break;
                }
        } elseif (isGetRequestElementSet('auto')) {
                // Automatic adding of new members
                switch (getRequestElement('auto')) {
                        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");
+                               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(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+                               );
                                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");
+                               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(getRequestElement('rallye'))), __FILE__, __LINE__, false)
+                               );
                                break;
                }
        }
@@ -100,11 +112,11 @@ if (isGetRequestElementSet('rallye')) {
                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));
+                               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));
+                               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));
+                               array(bigintval($id)), __FILE__, __LINE__, false));
                } // END - foreach
 
                // Run SQLS