diff options
| author | teacher <none@none> | 2009-12-12 15:27:10 +0100 |
|---|---|---|
| committer | teacher <none@none> | 2009-12-12 15:27:10 +0100 |
| commit | 477e58f32137cbede732998f24fed96ca43fd0fa (patch) | |
| tree | 7b60d1681b4e16080d1e3df4d32e6fa622fc7046 /sql/updates/5860_characters.sql | |
| parent | 7fa5c67861a9fb9d34cd8a64a03e4be1f6ab0492 (diff) | |
Renamed sql update files to proper Trinity naming standard.
Moved files prior to 6381_world_script_texts.sql to 3.1.3_old folder.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/5860_characters.sql')
| -rw-r--r-- | sql/updates/5860_characters.sql | 6 |
1 files changed, 0 insertions, 6 deletions
diff --git a/sql/updates/5860_characters.sql b/sql/updates/5860_characters.sql deleted file mode 100644 index c8927604025..00000000000 --- a/sql/updates/5860_characters.sql +++ /dev/null @@ -1,6 +0,0 @@ --- 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); |