diff options
| author | leak <leakzx@googlemail.com> | 2011-01-19 14:04:33 +0100 |
|---|---|---|
| committer | leak <leakzx@googlemail.com> | 2011-01-19 14:04:33 +0100 |
| commit | c306acf298ade5547512e04351a8f9ae4fdbae6d (patch) | |
| tree | 48762ec5b5769a2e6a0095f614064962c0dbf87c /src/server/game/Entities | |
| parent | b8210f4396cd266137ad69ea0ae4efe715072926 (diff) | |
SQL: Characters db storage type cleanup No. 2
Diffstat (limited to 'src/server/game/Entities')
| -rwxr-xr-x | src/server/game/Entities/Player/Player.cpp | 26 |
1 files changed, 16 insertions, 10 deletions
diff --git a/src/server/game/Entities/Player/Player.cpp b/src/server/game/Entities/Player/Player.cpp index d8dfecdb70c..89b81282e36 100755 --- a/src/server/game/Entities/Player/Player.cpp +++ b/src/server/game/Entities/Player/Player.cpp @@ -16070,10 +16070,12 @@ void Player::_LoadBGData(PreparedQueryResult result) Field* fields = result->Fetch(); // Expecting only one row - /* bgInstanceID, bgTeam, x, y, z, o, map, taxi[0], taxi[1], mountSpell */ + // 0 1 2 3 4 5 6 7 8 9 + // SELECT instance_id, team, join_x, join_y, join_z, join_o, join_map, taxi_start, taxi_end, mount_spell FROM character_battleground_data WHERE guid = ? + m_bgData.bgInstanceID = fields[0].GetUInt32(); - m_bgData.bgTeam = fields[1].GetUInt32(); - m_bgData.joinPos = WorldLocation(fields[6].GetUInt32(), // Map + m_bgData.bgTeam = fields[1].GetUInt16(); + m_bgData.joinPos = WorldLocation(fields[6].GetUInt16(), // Map fields[2].GetFloat(), // X fields[3].GetFloat(), // Y fields[4].GetFloat(), // Z @@ -16845,7 +16847,11 @@ void Player::_LoadAuras(PreparedQueryResult result, uint32 timediff) { sLog->outDebug("Loading auras for player %u",GetGUIDLow()); - //QueryResult *result = CharacterDatabase.PQuery("SELECT caster_guid,spell,effect_mask,recalculate_mask,stackcount,amount0,amount1,amount2,base_amount0,base_amount1,base_amount2,maxduration,remaintime,remaincharges FROM character_aura WHERE guid = '%u'",GetGUIDLow()); + /* 0 1 2 3 4 5 6 7 8 9 10 + QueryResult *result = CharacterDatabase.PQuery("SELECT caster_guid,spell,effect_mask,recalculate_mask,stackcount,amount0,amount1,amount2,base_amount0,base_amount1,base_amount2, + 11 12 13 + maxduration,remaintime,remaincharges FROM character_aura WHERE guid = '%u'",GetGUIDLow()); + */ if (result) { @@ -23963,12 +23969,12 @@ void Player::_LoadGlyphs(PreparedQueryResult result) if (spec >= m_specsCount) continue; - m_Glyphs[spec][0] = fields[1].GetUInt32(); - m_Glyphs[spec][1] = fields[2].GetUInt32(); - m_Glyphs[spec][2] = fields[3].GetUInt32(); - m_Glyphs[spec][3] = fields[4].GetUInt32(); - m_Glyphs[spec][4] = fields[5].GetUInt32(); - m_Glyphs[spec][5] = fields[6].GetUInt32(); + m_Glyphs[spec][0] = fields[1].GetUInt16(); + m_Glyphs[spec][1] = fields[2].GetUInt16(); + m_Glyphs[spec][2] = fields[3].GetUInt16(); + m_Glyphs[spec][3] = fields[4].GetUInt16(); + m_Glyphs[spec][4] = fields[5].GetUInt16(); + m_Glyphs[spec][5] = fields[6].GetUInt16(); } while (result->NextRow()); } |