aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-03-12 00:31:04 +0100
committerShauren <shauren.trinity@gmail.com>2021-09-06 19:51:57 +0200
commitbb772416bfa7a6833931e1a0993523d49dc549b8 (patch)
treef6611aee50e849b39b89ce8082bbd05971b283dd
parentffae92edd23a37d63aeed01544018944716b4a83 (diff)
DB/SAI: Add an extra param "player only" for los_ooc event
(cherry picked from commit 995a4fb8bb2ee77351a8029e13d5087c44f6cac9)
-rw-r--r--sql/updates/world/master/2021_09_06_02_world_2018_03_12_00_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_09_06_02_world_2018_03_12_00_world.sql b/sql/updates/world/master/2021_09_06_02_world_2018_03_12_00_world.sql
new file mode 100644
index 00000000000..8bc1cad596d
--- /dev/null
+++ b/sql/updates/world/master/2021_09_06_02_world_2018_03_12_00_world.sql
@@ -0,0 +1,11 @@
+--
+UPDATE `smart_scripts` SET `event_param5`=1 WHERE event_type=10 AND `source_type`=0;
+UPDATE `smart_scripts` SET `event_param2`=30, `event_param5`=1 WHERE `entryorguid`=24248 AND `source_type`=0;
+UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=24938 AND event_type=10 AND `source_type`=0;
+UPDATE `smart_scripts` SET `event_param1`=1 WHERE `entryorguid`in (27376,27378,27379,27381) AND event_type=10 AND `source_type`=0;
+UPDATE `smart_scripts` SET `event_param1`=1, `event_param2`=20, `event_param5`=0 WHERE `entryorguid`=30313 AND `event_type`=10 AND `source_type`=0;
+UPDATE `creature_template` SET `AIName`="" WHERE `entry`=32582;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (32582) AND `source_type`=0;
+UPDATE `smart_scripts` SET `event_flags`=0, `event_param2`=10, `event_param3`=60000, `event_param4`=60000, `event_param5`=1 WHERE `entryorguid`=5917 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_flags`=0, `event_param1`=1, `event_param2`=20, `event_param3`=40000, `event_param4`=60000, `event_param5`=1 WHERE `entryorguid`=9021 AND `source_type`=0 AND `id`=0;
+UPDATE `smart_scripts` SET `event_param5`=0 WHERE `entryorguid` IN (27246, 2775, 23370, 23760, 24845, 23675, 23673, 23672, 24271, 24364, 24468, 24510, 24527, 24718, 24938,24979,25063,30313) AND event_type=10 AND `source_type`=0;