Some variable rewrites

[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 98b6f61d1785faa8541c81c7dc32c15cf8861ca3..2eca0754592c72f5338ebac304eef6bbaf3b1726 100644 (file)
--- a/inc/modules/admin/what-list_rallyes.php
+++ b/inc/modules/admin/what-list_rallyes.php
@@ -47,17 +47,17 @@ $MSG = "";
 if (REQUEST_ISSET_GET(('rallye')))
 {
        // Activate / deactivate
 if (REQUEST_ISSET_GET(('rallye')))
 {
        // Activate / deactivate

-       $SQL = "";
+       $sql = "";

        if (REQUEST_ISSET_GET(('activate')))
        {
                switch (REQUEST_GET('activate'))
                {
                case "1": // Activate
        if (REQUEST_ISSET_GET(('activate')))
        {
                switch (REQUEST_GET('activate'))
                {
                case "1": // Activate

-                       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='Y' WHERE id=%s AND is_active='N' LIMIT 1";
+                       $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='Y' WHERE id=%s AND is_active='N' LIMIT 1";

                        break;
 
                case "0": // Deactivate
                        break;
 
                case "0": // Deactivate

-                       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='N' WHERE id=%s AND is_active='Y' LIMIT 1";
+                       $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET is_active='N' WHERE id=%s AND is_active='Y' LIMIT 1";

                        break;
                }
        }
                        break;
                }
        }


@@ -68,11 +68,11 @@ if (REQUEST_ISSET_GET(('rallye')))
                switch (REQUEST_GET('notify'))
                {
                case "1": // Activate
                switch (REQUEST_GET('notify'))
                {
                case "1": // Activate

-                       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='Y' WHERE id=%s AND send_notify='N' LIMIT 1";
+                       $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='Y' WHERE id=%s AND send_notify='N' LIMIT 1";

                        break;
 
                case "0": // Deactivate
                        break;
 
                case "0": // Deactivate

-                       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='N' WHERE id=%s AND send_notify='Y' LIMIT 1";
+                       $sql = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET send_notify='N' WHERE id=%s AND send_notify='Y' LIMIT 1";

                        break;
                }
        }
                        break;
                }
        }


@@ -83,19 +83,19 @@ if (REQUEST_ISSET_GET(('rallye')))
                switch (REQUEST_GET('auto'))
                {
                case "1": // Activate
                switch (REQUEST_GET('auto'))
                {
                case "1": // Activate

-                       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='Y' WHERE id=%s AND auto_add_new_user='N' LIMIT 1";
+                       $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 "0": // Deactivate
                        break;
 
                case "0": // Deactivate

-                       $SQL = "UPDATE `{!_MYSQL_PREFIX!}_rallye_data` SET auto_add_new_user='N' WHERE id=%s AND auto_add_new_user='Y' LIMIT 1";
+                       $sql = "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
                        break;
                }
        }
 
        // Run SQL command

-       if (!empty($SQL))
+       if (!empty($sql))

        {
        {

-               $result = SQL_QUERY_ESC($SQL, array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);
+               $result = SQL_QUERY_ESC($sql, array(bigintval(REQUEST_GET('rallye'))), __FILE__, __LINE__);

        }
 }
  elseif (REQUEST_ISSET_POST(('remove')))
        }
 }
  elseif (REQUEST_ISSET_POST(('remove')))