aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <none@none>2010-07-31 10:17:49 +0200
committerShauren <none@none>2010-07-31 10:17:49 +0200
commit2a371bb2240d10904dd22f511eb4e47ad75c4f7e (patch)
treec903eb5e88acdc2bef0f16e5ab29d995501b20e8
parentfd03b78fe6c42530afd86cdf34d08f512f8604e7 (diff)
Hopefully the last fix for revision 3849fdebbcc7 (9090) - use proper field to pull random properties
--HG-- branch : trunk
-rw-r--r--sql/updates/9090_characters_item_instance.sql4
1 files changed, 2 insertions, 2 deletions
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,