diff options
| author | Killyana <morphone1@gmail.com> | 2018-03-12 00:31:04 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2018-03-12 00:31:04 +0100 |
| commit | 995a4fb8bb2ee77351a8029e13d5087c44f6cac9 (patch) | |
| tree | 080d8ded789eada69678fed8dca92158fd477416 | |
| parent | f555a67bf850e1a9659c89551d7bb69cc812f161 (diff) | |
DB/SAI: Add an extra param "player only" for los_ooc event
| -rw-r--r-- | sql/updates/world/3.3.5/2018_03_12_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_03_12_00_world.sql b/sql/updates/world/3.3.5/2018_03_12_00_world.sql new file mode 100644 index 00000000000..8bc1cad596d --- /dev/null +++ b/sql/updates/world/3.3.5/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; |