From 3c43ef715754ba2762b7e4c9006957074c84366d Mon Sep 17 00:00:00 2001
From: maximius <none@none>
Date: Wed, 30 Sep 2009 04:18:07 -0700
Subject: *Better support for negatives.

--HG--
branch : trunk
---
 src/shared/Database/Database.cpp | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/shared/Database/Database.cpp')

diff --git a/src/shared/Database/Database.cpp b/src/shared/Database/Database.cpp
index 184a34fb2ce..b307444ff54 100644
--- a/src/shared/Database/Database.cpp
+++ b/src/shared/Database/Database.cpp
@@ -175,12 +175,12 @@ bool Database::PExecute(const char * format,...)
     return Execute(szQuery);
 }
 
-bool Database::_UpdateDataBlobValue(const uint32 guid, const uint32 field, const uint32 value)
+bool Database::_UpdateDataBlobValue(const uint32 guid, const uint32 field, const int32 value)
 {
     return PExecute(
         "UPDATE characters SET data="
         "CONCAT(SUBSTRING_INDEX(`data`,' ',%u),' ',"
-        "SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',%u),' ',-1)+%u,"
+        "GREATEST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',%u),' ',-1)+%u,0),"
         "' ',SUBSTRING_INDEX(`data`,' ',%u)) WHERE guid=%u",
         field, field+1, value, -int32(PLAYER_END-field)-1, guid);
 }
-- 
cgit v1.2.3