diff options
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; +*/ |