diff options
| author | maximius <none@none> | 2009-10-02 01:26:36 -0700 |
|---|---|---|
| committer | maximius <none@none> | 2009-10-02 01:26:36 -0700 |
| commit | 9bb508ae199a85de39c6f6e52f77328a4c746ff2 (patch) | |
| tree | 4b9f9238ff11e605d48b3de507969093b5e36d6e | |
| parent | 3c270f97ee35d2b8e363c6ac2c9cb0e40a533041 (diff) | |
*Proper data blob updating, thanks ogeraisi.
--HG--
branch : trunk
| -rw-r--r-- | src/shared/Database/Database.cpp | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/src/shared/Database/Database.cpp b/src/shared/Database/Database.cpp index de53990b5a7..572d3db6f1d 100644 --- a/src/shared/Database/Database.cpp +++ b/src/shared/Database/Database.cpp @@ -182,7 +182,7 @@ bool Database::_UpdateDataBlobValue(const uint32 guid, const uint32 field, const "CONCAT(SUBSTRING_INDEX(`data`,' ',%u),' '," "GREATEST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',%u),' ',-1)+%i,0)," "' ',SUBSTRING_INDEX(`data`,' ',%i)) WHERE guid=%u", - field, field+1, value, -int32(PLAYER_END-field)-1, guid); + field, field+1, value, -int32(PLAYER_END-field), guid); } bool Database::_SetDataBlobValue(const uint32 guid, const uint32 field, const uint32 value) @@ -190,9 +190,8 @@ bool Database::_SetDataBlobValue(const uint32 guid, const uint32 field, const ui return PExecute( "UPDATE characters SET data=" "CONCAT(SUBSTRING_INDEX(`data`,' ',%u),' '," - "%u,' ',SUBSTRING_INDEX(`data`,' ',%i))" - "WHERE guid=%u", - field, value, -int32(PLAYER_END-field)-1, guid); + "%u,' ',SUBSTRING_INDEX(`data`,' ',%i)) WHERE guid=%u", + field, value, -int32(PLAYER_END-field), guid); } bool Database::DirectPExecute(const char * format,...) |