Playon
Members-
Posts
4 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
Playon's Achievements
Newbie (1/3)
0
Reputation
-
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; + }
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®