From 9f9d88d5c69948a0306c3d362b42793ae59c8553 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Fri, 8 Jul 2011 06:37:13 +0000 Subject: [PATCH] LIMIT 1 added --- inc/extensions/ext-grade.php | 1 + inc/extensions/ext-rallye.php | 4 ++-- inc/extensions/ext-transfer.php | 4 ++-- 3 files changed, 5 insertions(+), 4 deletions(-) diff --git a/inc/extensions/ext-grade.php b/inc/extensions/ext-grade.php index acc1b5f3dc..b595c1e854 100644 --- a/inc/extensions/ext-grade.php +++ b/inc/extensions/ext-grade.php @@ -56,6 +56,7 @@ switch (getExtensionMode()) { addCreateTableSql('grade_data', "( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `grade_name` VARCHAR(255) NOT NULL DEFAULT '', +`grade_description` TINYTEXT NOT NULL, `grade_parent_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX (`grade_parent_id`) diff --git a/inc/extensions/ext-rallye.php b/inc/extensions/ext-rallye.php index 0d32548946..f61119bbce 100644 --- a/inc/extensions/ext-rallye.php +++ b/inc/extensions/ext-rallye.php @@ -108,8 +108,8 @@ PRIMARY KEY (`id`) // Remove menus addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='rallye'"); - addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='rallyes'"); - addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='rallyes'"); + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `what`='rallyes' LIMIT 1"); + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='rallyes' LIMIT 1"); // Unregister filter unregisterFilter(__FUNCTION__, __LINE__, 'extra_autopurge', 'RALLYE_EXTRA_AUTOPURGE', true, isExtensionDryRun()); diff --git a/inc/extensions/ext-transfer.php b/inc/extensions/ext-transfer.php index d16035aa43..8185e746b5 100644 --- a/inc/extensions/ext-transfer.php +++ b/inc/extensions/ext-transfer.php @@ -103,7 +103,7 @@ PRIMARY KEY (`id`) addDropTableSql('user_transfers_in'); addDropTableSql('user_transfers_out'); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='transfer'"); - addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='transfer'"); + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='transfer' LIMIT 1"); addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` DROP `opt_in`"); break; @@ -247,7 +247,7 @@ PRIMARY KEY (`id`) addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_member_menu` SET `action`='extras', `sort`=5 WHERE `what`='transfer' LIMIT 1"); // Update notes (these will be set as task text!) - setExtensionUpdateNotes("Mitgliedsmenü komplett geändert."); + setExtensionUpdateNotes("Eintrag im Mitgliedsmenü verschoben."); break; case '0.2.6': // SQL queries for v0.2.6 -- 2.39.2