X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-top10.php;h=db0913f2a81d2fb3b6b9c8611f73212c63ca79e6;hb=c6e62b16b4474ead6b180a5b9648906459d846da;hp=335801b1c66dd321e28df39872b4aa24187cc2e4;hpb=9725980ca9c052e5c1a9edb8b815e8506b876448;p=mailer.git diff --git a/inc/extensions/ext-top10.php b/inc/extensions/ext-top10.php index 335801b1c6..db0913f2a8 100644 --- 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