diff options
| author | silinoron <none@none> | 2010-09-05 16:34:38 -0700 |
|---|---|---|
| committer | silinoron <none@none> | 2010-09-05 16:34:38 -0700 |
| commit | 66cc9a5d67b56327ff39a992a43dea0ce89df9a5 (patch) | |
| tree | 4dc715ce620a0af8c20f15e03583b0139539a1ff | |
| parent | e6450df9c4bdd0e1b2133a455930f02c9faa0fbc (diff) | |
Fix a typo in race and faction transfers - reported by 0xFuture
Fixes issue #3844
Fix a SQL collision in race and faction transfers - reported by Aokromes
--HG--
branch : trunk
| -rw-r--r-- | src/server/game/Server/Protocol/Handlers/CharacterHandler.cpp | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/server/game/Server/Protocol/Handlers/CharacterHandler.cpp b/src/server/game/Server/Protocol/Handlers/CharacterHandler.cpp index 0d25742fff1..d92ed89eb29 100644 --- a/src/server/game/Server/Protocol/Handlers/CharacterHandler.cpp +++ b/src/server/game/Server/Protocol/Handlers/CharacterHandler.cpp @@ -1592,6 +1592,8 @@ void WorldSession::HandleCharFactionOrRaceChange(WorldPacket& recv_data) { uint32 achiev_alliance = it->first; uint32 achiev_horde = it->second; + trans->PAppend("DELETE FROM `character_achievement WHERE `achievement`=%u AND `guid`=%u", + team == BG_TEAM_ALLIANCE ? achiev_alliance : achiev_horde, GUID_LOPART(guid)); trans->PAppend("UPDATE `character_achievement` SET achievement = '%u' where achievement = '%u' AND guid = '%u'", team == BG_TEAM_ALLIANCE ? achiev_alliance : achiev_horde, team == BG_TEAM_ALLIANCE ? achiev_horde : achiev_alliance, GUID_LOPART(guid)); } @@ -1601,7 +1603,7 @@ void WorldSession::HandleCharFactionOrRaceChange(WorldPacket& recv_data) { uint32 item_alliance = it->first; uint32 item_horde = it->second; - trans->PAppend("UPDATE `character_inventory` SET item = '%u' where item = '%u' AND guid = '%u'", + trans->PAppend("UPDATE `character_inventory` SET item_template = '%u' where item_template = '%u' AND guid = '%u'", team == BG_TEAM_ALLIANCE ? item_alliance : item_horde, team == BG_TEAM_ALLIANCE ? item_horde : item_alliance, guid); } |