diff options
| -rw-r--r-- | sql/updates/5860_characters.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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); |