aboutsummaryrefslogtreecommitdiff
path: root/src/shared/Database/Database.cpp
diff options
context:
space:
mode:
authormaximius <none@none>2009-10-01 13:34:06 -0700
committermaximius <none@none>2009-10-01 13:34:06 -0700
commit62ed2e0ef4107ca32b7d1da649c9d72918b417fd (patch)
tree27b1d618a8eb2a06871343c26b3ecf13916929f0 /src/shared/Database/Database.cpp
parent5ab96a29f1b36405babf473560067be0fb64f91e (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.cpp6
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);
}