diff options
| -rw-r--r-- | sql/updates/world/master/2023_01_14_00_world.sql | 72 |
1 files changed, 72 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_01_14_00_world.sql b/sql/updates/world/master/2023_01_14_00_world.sql new file mode 100644 index 00000000000..1634d31652c --- /dev/null +++ b/sql/updates/world/master/2023_01_14_00_world.sql @@ -0,0 +1,72 @@ +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=21292 WHERE `source_type`=0 AND `entryorguid` IN (-74618, -69716, -69715, -69714) AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=20939, `target_param2`=10 WHERE `source_type`=0 AND `entryorguid`=4880 AND `id`=27; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=103680, `target_param2`=30 WHERE `source_type`=0 AND `entryorguid`=6546 AND `id` IN (1, 2); +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=141980, `target_param2`=10 WHERE `source_type`=0 AND `entryorguid`=7750 AND `id`=1; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=176306, `target_param2`=10 WHERE `source_type`=0 AND `entryorguid`=11016 AND `id`=1; +UPDATE `smart_scripts` SET `target_type`=20 WHERE `source_type`=0 AND `entryorguid`=11598 AND `id` IN (11, 12, 13, 14, 15, 16); +UPDATE `smart_scripts` SET `target_type`=1 WHERE `source_type`=0 AND `entryorguid`=12277 AND `id`=1; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=23905, `target_param2`=100 WHERE `source_type`=0 AND `entryorguid`=23899 AND `id`=9; + +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=150138, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=17156 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=150137, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=17157 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=18971, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=18899 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=18934, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=18900 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=18936, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=18901 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=90566, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=90567 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=18935, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=101811 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=18935, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=101812 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=13965, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=101831 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=17153, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=101832 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=16397, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=101833 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=17153, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=101834 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=173266, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=173265 AND `id` IN (0, 4); +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=175369, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=175432 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=174626, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=176767 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=177188, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=179507 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=177189, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=179508 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=177192, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=179510 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=177198, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=179513 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=5635, `target_param2`=30 WHERE `source_type`=1 AND `entryorguid`=179911 AND `id`=0; + +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=27620, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=4990 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=38065, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5703 AND `id`=1; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=48573, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5705 AND `id`=1; +UPDATE `smart_scripts` SET `action_param3`=19, `action_param4`=38340, `action_param5`=30 WHERE `source_type`=2 AND `entryorguid`=5710 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=38340, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5710 AND `id`=1; +UPDATE `smart_scripts` SET `action_param3`=19, `action_param4`=38341, `action_param5`=30 WHERE `source_type`=2 AND `entryorguid`=5711 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=38341, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5711 AND `id`=1; +UPDATE `smart_scripts` SET `action_param3`=19, `action_param4`=38342, `action_param5`=30 WHERE `source_type`=2 AND `entryorguid`=5712 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=38342, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5712 AND `id`=1; +UPDATE `smart_scripts` SET `action_param3`=19, `action_param4`=38341, `action_param5`=30 WHERE `source_type`=2 AND `entryorguid`=5714 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=38341, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5714 AND `id`=1; +UPDATE `smart_scripts` SET `action_param3`=19, `action_param4`=38340, `action_param5`=30 WHERE `source_type`=2 AND `entryorguid`=5715 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=38340, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5715 AND `id`=1; +UPDATE `smart_scripts` SET `action_param3`=19, `action_param4`=38342, `action_param5`=30 WHERE `source_type`=2 AND `entryorguid`=5716 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=38342, `target_param2`=30 WHERE `source_type`=2 AND `entryorguid`=5716 AND `id`=1; +DELETE FROM `smart_scripts` WHERE `source_type`=2 AND `entryorguid` IN (3746, 3766) AND `id`=0; +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (3746, 3766); + +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=270, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=137300 AND `id`=3; +UPDATE `smart_scripts` SET `target_type`=15, `target_param1`=7510, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=208001 AND `id`=8; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=208001 AND `id` IN (9, 10) AND `action_type`=70; +UPDATE `smart_scripts` SET `id`=9 WHERE `source_type`=9 AND `entryorguid`=208001 AND `id`=11; +UPDATE `smart_scripts` SET `id`=10 WHERE `source_type`=9 AND `entryorguid`=208001 AND `id`=12; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=162024, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=344200 AND `id`=1; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=4429, `target_param2`=10 WHERE `source_type`=9 AND `entryorguid`=463000 AND `id`=2; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=4429, `target_param2`=10 WHERE `source_type`=9 AND `entryorguid`=463001 AND `id`=2; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=179888, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=472000 AND `id`=3; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=20805, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=472000 AND `id`=4; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=178571, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=472100 AND `id`=2; +UPDATE `smart_scripts` SET `target_param1`=296490 WHERE `source_type`=9 AND `entryorguid`=497303 AND `id`=2; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=106528, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=700700 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=106529, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=700700 AND `id`=2; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=162024, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=931600 AND `id`=1; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=164729, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=946700 AND `id`=5; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=176225, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=1101601 AND `id`=2; +UPDATE `smart_scripts` SET `target_type`=1 WHERE `source_type`=9 AND `entryorguid`=1490804 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=19, `target_param1`=23905, `target_param2`=100 WHERE `source_type`=9 AND `entryorguid`=2389901 AND `id`=5; +UPDATE `smart_scripts` SET `target_type`=15, `target_param1`=186432, `target_param2`=100 WHERE `source_type`=9 AND `entryorguid`=2390500 AND `id`=17; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=2390500 AND `id` IN (18, 19); +UPDATE `smart_scripts` SET `target_type`=1 WHERE `source_type`=9 AND `entryorguid`=5754101 AND `id`=9; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=106528, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=11379100 AND `id`=0; +UPDATE `smart_scripts` SET `target_type`=20, `target_param1`=106529, `target_param2`=30 WHERE `source_type`=9 AND `entryorguid`=11379100 AND `id`=1; |