From 1210b6f2849d0fbfcc5581fa2ee18fc7e72f3f6e Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sun, 11 Oct 2009 22:52:36 +0200 Subject: Remove watch flag (1) from characters that are watching a faction from the opposing team. Since r5857, these factions will no longer be flagged for watching if they are from the opposing team. All we need to do is clean up the data from when it was still bugged. NOTE: running this may take a while depending on the size of your character database. --HG-- branch : trunk --- sql/updates/5860_characters.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/5860_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/5860_characters.sql b/sql/updates/5860_characters.sql new file mode 100644 index 00000000000..c8927604025 --- /dev/null +++ b/sql/updates/5860_characters.sql @@ -0,0 +1,6 @@ +-- Remove watch flag (1) from characters that are watching a faction from the opposing team +-- since r5857, these factions will no longer be flagged for watching if they are from the opposing team +-- all we need to do is clean up the data from when it was still bugged. +-- NOTE: running this may take a while depending on the size of your character database +UPDATE `character_reputation` SET `flags` = `flags` &~ 1 WHERE `guid` IN (SELECT `guid` from `characters` WHERE `race` IN(3,7,1,4,11)) AND `faction` IN(1052,1067,1124,947); +UPDATE `character_reputation` SET `flags` = `flags` &~ 1 WHERE `guid` IN (SELECT `guid` from `characters` WHERE `race` IN(2,6,8,5,10)) AND `faction` IN(1126,946,978); -- cgit v1.2.3