diff options
| -rw-r--r-- | sql/updates/world/master/2017_02_19_05_world.sql | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_19_05_world.sql b/sql/updates/world/master/2017_02_19_05_world.sql new file mode 100644 index 00000000000..c0e99617bd7 --- /dev/null +++ b/sql/updates/world/master/2017_02_19_05_world.sql @@ -0,0 +1,65 @@ +DELETE FROM `areatrigger_template` WHERE `Id` IN (12983, 12197, 12186, 11955, 13120, 13122, 10813, 13112, 13354, 13353, 13352, 12922, 13189, 13188, 13689, 12882, 12851, 12879, 12857, 12856, 12855, 12853, 12854, 12893, 12894, 12904, 12897, 12892, 12968, 11989, 11381, 11390, 11910, 12610, 13127, 13117, 7856, 11854, 10387, 10393, 13267, 11692, 11846, 10716, 10625, 6629, 11004, 10459); +INSERT INTO `areatrigger_template` (`Id`, `Type`, `Flags`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `VerifiedBuild`) VALUES +(12983, 0, 4, 100, 100, 0, 0, 0, 0, 22908), +(12197, 0, 4, 10, 10, 0, 0, 0, 0, 22908), +(12186, 1, 0, 7.5, 2.5, 5, 7.5, 2.5, 5, 22908), +(11955, 0, 4, 3, 3, 0, 0, 0, 0, 22908), +(13120, 0, 0, 4, 4, 0, 0, 0, 0, 22908), +(13122, 0, 0, 4, 4, 0, 0, 0, 0, 22908), +(10813, 0, 4, 20, 20, 0, 0, 0, 0, 22908), +(13112, 0, 0, 4, 4, 0, 0, 0, 0, 22908), +(13354, 3, 0, 0, 0, 0, 0, 0, 0, 22908), +(13353, 3, 0, 0, 0, 0, 0, 0, 0, 22908), +(13352, 3, 0, 0, 0, 0, 0, 0, 0, 22908), +(12922, 0, 2, 6, 6, 0, 0, 0, 0, 22908), +(13189, 1, 0, 5, 2.5, 7.5, 5, 2.5, 7.5, 22908), +(13188, 0, 0, 10, 10, 0, 0, 0, 0, 22908), +(13689, 0, 0, 10, 10, 0, 0, 0, 0, 22908), +(12882, 4, 4, 2, 2, 6, 6, 0.3, 0.3, 22908), +(12851, 3, 1, 0, 0, 0, 0, 0, 0, 22908), +(12879, 4, 0, 1, 1, 5, 5, 2.5, 2.5, 22908), +(12857, 0, 0, 4.5, 4.5, 0, 0, 0, 0, 22908), +(12856, 0, 0, 4.5, 4.5, 0, 0, 0, 0, 22908), +(12855, 0, 0, 4.5, 4.5, 0, 0, 0, 0, 22908), +(12853, 0, 0, 4.5, 4.5, 0, 0, 0, 0, 22908), +(12854, 0, 0, 4.5, 4.5, 0, 0, 0, 0, 22908), +(12893, 0, 4, 6, 6, 0, 0, 0, 0, 22908), +(12894, 0, 4, 35, 35, 0, 0, 0, 0, 22908), +(12904, 0, 0, 8, 8, 0, 0, 0, 0, 22908), +(12897, 1, 0, 22.5, 100, 3.5, 22.5, 100, 3.5, 22908), +(12892, 0, 2, 1, 1, 0, 0, 0, 0, 22908), +(12968, 1, 18, 2, 5.5, 2.5, 2, 5.5, 2.5, 22908), +(11989, 0, 4, 6, 6, 0, 0, 0, 0, 22908), +(11381, 4, 4, 3, 3, 6, 6, 0.3, 0.3, 22908), +(11390, 4, 4, 15, 15, 10, 10, -1, -1, 22908), +(11910, 0, 0, 5, 5, 0, 0, 0, 0, 22908), +(12610, 0, 0, 6, 6, 0, 0, 0, 0, 22908), +(13127, 4, 0, 5, 5, 8, 8, -2, -2, 22908), +(13117, 0, 0, 6, 6, 0, 0, 0, 0, 22908), +(7856, 0, 0, 2, 2, 0, 0, 0, 0, 22908), +(11854, 0, 2, 30, 30, 0, 0, 0, 0, 22908), +(10387, 3, 4, 0, 0, 0, 0, 0, 0, 22908), +(10393, 3, 4, 0, 0, 0, 0, 0, 0, 22908), +(13267, 1, 0, 5, 1, 2.5, 5, 1, 2.5, 22908), +(11692, 0, 0, 1, 1, 0, 0, 0, 0, 22908), +(11846, 0, 0, 1, 1, 0, 0, 0, 0, 22908), +(10716, 0, 0, 4, 4, 0, 0, 0, 0, 22908), +(10625, 0, 4, 12, 12, 0, 0, 0, 0, 22908), +(6629, 0, 0, 2, 2, 0, 0, 0, 0, 22908), +(11004, 0, 4, 20, 20, 0, 0, 0, 0, 22908), +(10459, 3, 4, 0, 0, 0, 0, 0, 0, 22908); + +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=11750; +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=11427; +UPDATE `areatrigger_template` SET `Type`=0, `Data0`=4, `Data1`=4, `Data2`=0, `Data3`=0, `Data4`=0, `Data5`=0, `VerifiedBuild`=22908 WHERE `Id`=6197; +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=11189; +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=11569; +UPDATE `areatrigger_template` SET `Flags`=4, `VerifiedBuild`=22908 WHERE `Id`=11338; +UPDATE `areatrigger_template` SET `Type`=0, `Data0`=1, `Data1`=1, `Data2`=0, `Data3`=0, `Data4`=0, `Data5`=0, `VerifiedBuild`=22908 WHERE `Id`=6197; +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=12446; +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=9397; +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=6212; +UPDATE `areatrigger_template` SET `Flags`=2, `VerifiedBuild`=22908 WHERE `Id`=9482; +UPDATE `areatrigger_template` SET `Type`=4, `Data0`=5, `Data1`=5, `Data2`=2, `Data3`=2, `Data4`=0.3, `Data5`=0.3, `VerifiedBuild`=22908 WHERE `Id`=0; +UPDATE `areatrigger_template` SET `Flags`=2, `Data0`=10, `Data1`=16, `VerifiedBuild`=22908 WHERE `Id`=12446; +UPDATE `areatrigger_template` SET `Flags`=4, `VerifiedBuild`=22908 WHERE `Id`=10003; |