root/trunk/sql/updates/5651_characters_characters.sql @ 2

Revision 2, 0.7 kB (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00
Line 
1UPDATE characters
2SET data = CONCAT(
3  SUBSTRING_INDEX(data,' ',225+1),
4  ' 1 0 ',
5  SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',315+1),' ',225-315),
6  ' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',
7  SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',621+1),' ',315-621),
8  ' 0 ',
9  SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',822+1),' ',621-822),
10  ' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',
11  SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',1319+1),' ',822-1319),
12  ' 0 ',
13  SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',1351+1),' ',1319-1351),
14  ' 0 ',
15  SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',1447+1),' ',1351-1447),
16  ' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',
17  SUBSTRING_INDEX(data,' ',-1449+1447+1)
18)
19WHERE SUBSTRING_INDEX(data,' ',1448)=data;
Note: See TracBrowser for help on using the browser.