Playon

For trinity core patch ( wowarmory_arena_chart.patch ) after changeset 9871: /** World of Warcraft Armory **/ uint32 maxChartID; [color=red]- QueryResult_AutoPtr result = CharacterDatabase.PQuery("SELECT MAX(gameid) FROM armory_game_chart");[/color] [color=seagreen]+ QueryResult result = CharacterDatabase.PQuery("SELECT MAX(gameid) FROM armory_game_chart");[/color] if(!result) maxChartID = 0; For wowarmory_patch.patch : if (type == 3) // Do not write same bosses many times - just update counter. { uint8 Difficulty = GetMap()->GetDifficulty(); [color="red"]- QueryResult_AutoPtr result = CharacterDatabase.PQuery("SELECT counter FROM character_feed_log WHERE guid='%u' AND type=3 AND data='%u' AND difficulty='%u' LIMIT 1", pGuid, data, Difficulty);[/color] [color="seagreen"]+ QueryResult result = CharacterDatabase.PQuery("SELECT counter FROM character_feed_log WHERE guid='%u' AND type=3 AND data='%u' AND difficulty='%u' LIMIT 1", pGuid, data, Difficulty);[/color] if (result) { CharacterDatabase.PExecute("UPDATE character_feed_log SET counter=counter+1, date=UNIX_TIMESTAMP(NOW()) WHERE guid='%u' AND type=3 AND data='%u' AND difficulty='%u' LIMIT 1", pGuid, data, Difficulty); } else { CharacterDatabase.PExecute("INSERT INTO character_feed_log (guid, type, data, date, counter, difficulty) VALUES('%u', '%d', '%u', UNIX_TIMESTAMP(NOW()), 1, '%u')", pGuid, type, data, Difficulty); } }

character_arena_stats table is part of trinity rev. 9632 (9632_characters_character_arena_stats.sql).

Don`t forget to apply the tools/trinity_core/characters_patch.sql to characters DB. Your welcome!

Complied fine TC2 rev. 9709 with these changes: + else + { + maxChartID = (*result)[0].GetUInt32(); [color=Red]- delete result;[/color] [color=SeaGreen]+ result.release();[/color] + } + if (plTeamID == winner_arena_team->GetId()) + { + changeType = 1; //win [color=Red]- [/color][color=Red]resultRating = winner_rating;[/color] [color=SeaGreen]+ resultRating = winner_team_rating;[/color] + resultTeamID = plTeamID; + ratingChange = winner_change; + } + else + { + changeType = 2; //lose [color=Red]- resultRating = loser_rating;[/color] [color=SeaGreen]+ resultRating = loser_team_rating;[/color] + resultTeamID = loser_arena_team->GetId(); + ratingChange = loser_change; + }