diff options
author | maximius <none@none> | 2009-10-01 13:34:06 -0700 |
---|---|---|
committer | maximius <none@none> | 2009-10-01 13:34:06 -0700 |
commit | 62ed2e0ef4107ca32b7d1da649c9d72918b417fd (patch) | |
tree | 27b1d618a8eb2a06871343c26b3ecf13916929f0 /src/shared/Database/Database.cpp | |
parent | 5ab96a29f1b36405babf473560067be0fb64f91e (diff) |
*Better support for signed input. I'm not sure if this will fix anything.
--HG--
branch : trunk
Diffstat (limited to 'src/shared/Database/Database.cpp')
-rw-r--r-- | src/shared/Database/Database.cpp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/shared/Database/Database.cpp b/src/shared/Database/Database.cpp index b307444ff54..ce8554d5092 100644 --- a/src/shared/Database/Database.cpp +++ b/src/shared/Database/Database.cpp @@ -180,8 +180,8 @@ bool Database::_UpdateDataBlobValue(const uint32 guid, const uint32 field, const return PExecute( "UPDATE characters SET data=" "CONCAT(SUBSTRING_INDEX(`data`,' ',%u),' '," - "GREATEST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',%u),' ',-1)+%u,0)," - "' ',SUBSTRING_INDEX(`data`,' ',%u)) WHERE guid=%u", + "SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',%u),' ',-1)+%i," + "' ',SUBSTRING_INDEX(`data`,' ',%i)) WHERE guid=%u", field, field+1, value, -int32(PLAYER_END-field)-1, guid); } @@ -190,7 +190,7 @@ 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`,' ',%u))," + "%u,' ',SUBSTRING_INDEX(`data`,' ',%i))," "WHERE guid=%u", field, value, -int32(PLAYER_END-field)-1, guid); } |