aboutsummaryrefslogtreecommitdiff
path: root/src/shared/Database/Database.cpp
diff options
context:
space:
mode:
authormaximius <none@none>2009-10-01 13:35:39 -0700
committermaximius <none@none>2009-10-01 13:35:39 -0700
commit340db23ea99bb642d5a9631d7dab562778c29f44 (patch)
tree8b393272af5bacfa8521523c70197fe950c6d11d /src/shared/Database/Database.cpp
parent62ed2e0ef4107ca32b7d1da649c9d72918b417fd (diff)
*Didn't mean to remove that.. there shouldn't be negative values in the data blob, unless I'm mistaken.
--HG-- branch : trunk
Diffstat (limited to 'src/shared/Database/Database.cpp')
-rw-r--r--src/shared/Database/Database.cpp2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/shared/Database/Database.cpp b/src/shared/Database/Database.cpp
index ce8554d5092..f28e4988989 100644
--- a/src/shared/Database/Database.cpp
+++ b/src/shared/Database/Database.cpp
@@ -180,7 +180,7 @@ bool Database::_UpdateDataBlobValue(const uint32 guid, const uint32 field, const
return PExecute(
"UPDATE characters SET data="
"CONCAT(SUBSTRING_INDEX(`data`,' ',%u),' ',"
- "SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',%u),' ',-1)+%i,"
+ "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);
}