From ede2a1c5edd81d46f218dc09d1c3e1e707e44921 Mon Sep 17 00:00:00 2001 From: Shocker Date: Mon, 27 Sep 2010 02:57:01 +0300 Subject: Core/Quests: Make sure itemcount doesn't get to be negative. Since this is an old issue and probably there are various entries with huge values as itemcounts already, a cleanup must be done before changing structure of character_queststatus which was done in r9be097c482, thus I'll include the SQL cleanup in that revision's .sql file or MySQL will thrown an error regarding out of bounds values --HG-- branch : trunk --- sql/updates/10084_characters_character_queststatus.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'sql/updates') diff --git a/sql/updates/10084_characters_character_queststatus.sql b/sql/updates/10084_characters_character_queststatus.sql index 9b541553eb2..81ce948598e 100644 --- a/sql/updates/10084_characters_character_queststatus.sql +++ b/sql/updates/10084_characters_character_queststatus.sql @@ -1,3 +1,8 @@ +UPDATE `character_queststatus` SET `itemcount1` = 0 WHERE `itemcount1` > 65535; +UPDATE `character_queststatus` SET `itemcount2` = 0 WHERE `itemcount2` > 65535; +UPDATE `character_queststatus` SET `itemcount3` = 0 WHERE `itemcount3` > 65535; +UPDATE `character_queststatus` SET `itemcount4` = 0 WHERE `itemcount4` > 65535; + ALTER TABLE `character_queststatus` CHANGE `status` `status` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0, CHANGE `mobcount1` `mobcount1` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, CHANGE `mobcount2` `mobcount2` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, -- cgit v1.2.3