From 39d29edf93574d0f133a66f44f059938c4de7a98 Mon Sep 17 00:00:00 2001 From: pete318 Date: Mon, 12 Oct 2015 20:07:40 +0200 Subject: Merge pull request #15707 from ShinDarth/pvpstats Core/BG fix .character changefaction pvpstats victories amount (cherry picked from commit 69941864efa9e40a787f53f055c79336378b8d4d) Conflicts: sql/base/characters_database.sql src/server/game/Battlegrounds/Battleground.cpp --- .../2015_11_06_00_characters_2015_10_12_00.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/characters/2015_11_06_00_characters_2015_10_12_00.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2015_11_06_00_characters_2015_10_12_00.sql b/sql/updates/characters/2015_11_06_00_characters_2015_10_12_00.sql new file mode 100644 index 00000000000..d7d4fb90f02 --- /dev/null +++ b/sql/updates/characters/2015_11_06_00_characters_2015_10_12_00.sql @@ -0,0 +1,17 @@ +-- Add new winner field, bound to player +ALTER TABLE `pvpstats_players` + ADD COLUMN `winner` BIT(1) NOT NULL AFTER `character_guid`; + +-- Resolve horde players victories +UPDATE `pvpstats_players` SET `winner` = 1 WHERE `battleground_id` IN ( + SELECT `id` FROM `pvpstats_battlegrounds` WHERE `winner_faction` = 0 +) AND `character_guid` IN ( + SELECT `guid` FROM `characters` WHERE `race` IN (2, 5, 6, 8, 9, 10) +); + +-- Resolve alliance players victories +UPDATE `pvpstats_players` SET `winner` = 1 WHERE `battleground_id` IN ( + SELECT `id` FROM `pvpstats_battlegrounds` WHERE `winner_faction` = 1 +) AND `character_guid` IN ( + SELECT `guid` FROM `characters` WHERE `race` IN (1, 3, 4, 7, 11, 22) +); -- cgit v1.2.3