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 | |
| parent | 83e7f653fe6a1aad6121fa7606da620d14938e0c (diff) | |
*Update to Mangos 7093.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/TBC-WLK converter/TBC-WLK_characters.sql | 4 | ||||
| -rw-r--r-- | sql/updates/2008_12_22_19_characters_item_instance.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/sql/TBC-WLK converter/TBC-WLK_characters.sql b/sql/TBC-WLK converter/TBC-WLK_characters.sql index bc381e0f964..582b4f10112 100644 --- a/sql/TBC-WLK converter/TBC-WLK_characters.sql +++ b/sql/TBC-WLK converter/TBC-WLK_characters.sql @@ -326,8 +326,8 @@ WHERE length(SUBSTRING_INDEX(data, ' ', 1592)) < length(data) and length(SUBSTRI 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( SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',30),' ',-30),' 0 0 0 ', 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( |