diff options
| author | megamage <none@none> | 2009-01-14 18:42:53 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-01-14 18:42:53 -0600 |
| commit | 14e38a3ddf27a7ced018c59864c81dd6eb35217f (patch) | |
| tree | d29e76ad51fea59cba9c808651929f549f7ba392 /sql/updates | |
| parent | 83e7f653fe6a1aad6121fa7606da620d14938e0c (diff) | |
*Update to Mangos 7093.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/2008_12_22_19_characters_item_instance.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/updates/2008_12_22_19_characters_item_instance.sql b/sql/updates/2008_12_22_19_characters_item_instance.sql index 96f31ff47d4..e737e24da29 100644 --- a/sql/updates/2008_12_22_19_characters_item_instance.sql +++ b/sql/updates/2008_12_22_19_characters_item_instance.sql @@ -4,8 +4,8 @@ UPDATE item_instance SET data = REPLACE(data,' ',' '); UPDATE item_instance SET data = CONCAT(TRIM(data),' '); UPDATE item_instance SET data= CONCAT( - SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',30),' ',-30),' 0 0 0 ', - SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',60),' ',-60+30),' 0 ') + SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',54),' ',-54),' 0 0 0 ', + SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',60),' ',-60+54),' 0 ') WHERE SUBSTRING_INDEX(data,' ',60) = data AND SUBSTRING_INDEX(data,' ',60-1) <> data; UPDATE item_instance SET data= CONCAT( |