TrinityCore/sql/old/3.1.3/05804_characters_characters.sql at 3.3.5 - TrinityCore - Gitea: Git with a cup of tea

araxiaonline/TrinityCore

mirror of https://github.com/araxiaonline/TrinityCore.git synced 2026-06-13 11:43:18 -04:00

Files

runningnak3d 0a5d8711e5 Misc: Restructuring directory layout to accomodate the fact that we will

be pushing DB content. We will no longer have a seperate DB repo.

2011-02-02 07:50:21 -07:00

5 lines

254 B

SQL

Raw Permalink Blame History

 /*
 -- 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;
 */