Encapsulated adding configuration entries with new wrapper function addConfigAddSql()

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

diff --git a/inc/extensions/ext-top10.php b/inc/extensions/ext-top10.php
index 335801b1c66dd321e28df39872b4aa24187cc2e4..db0913f2a81d2fb3b6b9c8611f73212c63ca79e6 100644 (file)
--- a/inc/extensions/ext-top10.php
+++ b/inc/extensions/ext-top10.php
@@ -51,13 +51,13 @@ switch (getExtensionMode()) {
                // SQL commands to run
                addGuestMenuSql('main','top10','TOP-10','Y','Y', 7);
                addAdminMenuSql('setup','config_top10','TOP-10 Listen','Stellen Sie hier ein, wie lang die TOP-Listen sein sollen, also wie viele Plätze angezeigt werden sollen.', 8);
-               addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD top10_max TINYINT(3) UNSIGNED NOT NULL DEFAULT 10");
+               addConfigAddSql('top10_max', "TINYINT(3) UNSIGNED NOT NULL DEFAULT 10");
                break;
 
        case 'remove': // Do stuff when removing extension
                // SQL commands to run
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='top10'");
-               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_top10'");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='top10' LIMIT 1");
+               addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what`='config_top10' LIMIT 1");
                break;
 
        case 'activate': // Do stuff when admin activates this extension