From 2a371bb2240d10904dd22f511eb4e47ad75c4f7e Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 31 Jul 2010 10:17:49 +0200 Subject: Hopefully the last fix for revision 3849fdebbcc7 (9090) - use proper field to pull random properties --HG-- branch : trunk --- sql/updates/9090_characters_item_instance.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/updates/9090_characters_item_instance.sql b/sql/updates/9090_characters_item_instance.sql index db6e3928d72..8492b7f30f6 100644 --- a/sql/updates/9090_characters_item_instance.sql +++ b/sql/updates/9090_characters_item_instance.sql @@ -68,8 +68,8 @@ length(SUBSTRING_INDEX(`data`,' ',22))+2, length(SUBSTRING_INDEX(`data`,' ',57+1))-length(SUBSTRING_INDEX(data,' ',22))-1), `randomPropertyId` = uint32toint32(SUBSTRING(`data`, -length(SUBSTRING_INDEX(`data`,' ',58))+2, -length(SUBSTRING_INDEX(`data`,' ',58+1))-length(SUBSTRING_INDEX(data,' ',58))-1)), +length(SUBSTRING_INDEX(`data`,' ',59))+2, +length(SUBSTRING_INDEX(`data`,' ',59+1))-length(SUBSTRING_INDEX(data,' ',59))-1)), `durability` = SUBSTRING(`data`, length(SUBSTRING_INDEX(`data`,' ',60))+2, -- cgit v1.2.3