diff options
| author | maximius <none@none> | 2009-10-02 02:40:35 -0700 |
|---|---|---|
| committer | maximius <none@none> | 2009-10-02 02:40:35 -0700 |
| commit | a73b03b7ea7ee7e217299f7938fb2bd80571f876 (patch) | |
| tree | 7401d73edcc753f9ec0d1d34f284ca622db15d0b /sql | |
| parent | 2b555a1ab962025b83661d14fabba234a20838a7 (diff) | |
*New SQL to fix broken data blobs, if any. Must be run manually.
*Cleanup, fix some typos, and fix the final heal of Lifebloom. Thanks ogeraisi.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/5804_characters.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/5804_characters.sql b/sql/updates/5804_characters.sql new file mode 100644 index 00000000000..5a221622bc9 --- /dev/null +++ b/sql/updates/5804_characters.sql @@ -0,0 +1,5 @@ + +/* +-- Broken character data blobs lately? Run this! +-- UPDATE `characters` SET `data`=CONCAT(SUBSTRING_INDEX(`data`,' ',1248), ' ',SUBSTRING_INDEX(`data`,' ',-(1295-1248))) WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',1295+1),' ',-1) IS NOT NULL; +*/ |