From 1210b6f2849d0fbfcc5581fa2ee18fc7e72f3f6e Mon Sep 17 00:00:00 2001
From: Machiavelli <none@none>
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/5860_characters.sql')

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

