All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

[mailer.git] / inc / extensions / ext-iso3166.php

diff --git a/inc/extensions/ext-iso3166.php b/inc/extensions/ext-iso3166.php
index eaab53f82b29822b47c18b6c9c0c6bed26c3c110..c323d115093d4704da0ae1f05ac0465d2fb3599c 100644 (file)
--- a/inc/extensions/ext-iso3166.php
+++ b/inc/extensions/ext-iso3166.php
@@ -53,26 +53,26 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
 
 case "remove": // Do stuff when removing extension
        // SQL commands to run
-       $SQLs[] = "DELETE FROM `"._MYSQL_PREFIX."_countries` WHERE provider = 'ext-iso3166';";
-       $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_countries` DROP `provider`;";
+       $SQLs[] = "DELETE FROM `{!MYSQL_PREFIX!}_countries` WHERE provider = 'ext-iso3166';";
+       $SQLs[] = "ALTER TABLE `{!MYSQL_PREFIX!}_countries` DROP `provider`;";
        break;
 
 case "activate": // Do stuff when admin activates this extension
        // SQL commands to run
-       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_countries` SET is_active = 'Y' WHERE provider = 'ext-iso3166';";
+       $SQLs[] = "UPDATE `{!MYSQL_PREFIX!}_countries` SET is_active = 'Y' WHERE provider = 'ext-iso3166';";
        break;
 
 case "deactivate": // Do stuff when admin deactivates this extension
        // SQL commands to run
-       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_countries` SET is_active='N' WHERE provider = 'ext-iso3166';";
+       $SQLs[] = "UPDATE `{!MYSQL_PREFIX!}_countries` SET is_active='N' WHERE provider = 'ext-iso3166';";
        break;
 
 case "update": // Update an extension
        switch ($EXT_VER)
        {
        case "0.0.1": // SQL queries for v0.0.2
-               $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_countries` ADD `provider` ENUM( 'user', 'ext-iso3166' ) NOT NULL DEFAULT 'user';";
-               $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_countries` (`code` , `descr`, `provider`)
+               $SQLs[] = "ALTER TABLE `{!MYSQL_PREFIX!}_countries` ADD `provider` ENUM( 'user', 'ext-iso3166' ) NOT NULL DEFAULT 'user';";
+               $SQLs[] = "INSERT INTO `{!MYSQL_PREFIX!}_countries` (`code` , `descr`, `provider`)
 VALUES ('AD', 'Andorra', 'ext-iso3166'),
 ('AE', 'Vereinigte Arabische Emirate', 'ext-iso3166'),
 ('AF', 'Afghanistan', 'ext-iso3166'),