From 674eb55e632aa233976d821f6a53262cbadfea26 Mon Sep 17 00:00:00 2001 From: Killyana Date: Mon, 20 Feb 2017 10:34:30 +0100 Subject: DB: Fix some DB errors --- sql/updates/world/3.3.5/2017_02_20_01_world_335.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_02_20_01_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_02_20_01_world_335.sql b/sql/updates/world/3.3.5/2017_02_20_01_world_335.sql new file mode 100644 index 00000000000..b05b81cc2f4 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_02_20_01_world_335.sql @@ -0,0 +1,14 @@ +-- +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (-136528,-136525,-131059,-131058,-131056,-131055,-105495,-105489,-105488,-105487) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_param2`=1000,`event_param3`=3000 ,`event_param4`=3000 WHERE `entryorguid` IN (314) AND `source_type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `event_param3`=2000 ,`event_param4`=2000 WHERE `entryorguid` IN (2318) AND `source_type`=0 AND `id`=6; +UPDATE `smart_scripts` SET `event_param3`=4000 ,`event_param4`=4000 WHERE `entryorguid` IN (2762) AND `source_type`=0 AND `id`=4; +UPDATE `smart_scripts` SET `event_param3`=2000 ,`event_param4`=2000 WHERE `entryorguid` IN (2762) AND `source_type`=0 AND `id`=8; +UPDATE `smart_scripts` SET `event_param3`=3000 ,`event_param4`=3000 WHERE `entryorguid` IN (2762) AND `source_type`=0 AND `id`=9; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (3771) AND `source_type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid` IN (3771) AND `source_type`=0 AND `id`=3; +UPDATE `smart_scripts` SET `event_param3`=3000 ,`event_param4`=3000 WHERE `entryorguid` IN (3840) AND `source_type`=0 AND `id`=7; +UPDATE `smart_scripts` SET `event_param1`=1000 ,`event_param2`=1000, `event_param3`=60000 ,`event_param4`=60000 WHERE `entryorguid` IN (4420) AND `source_type`=0 AND `id`=1; +UPDATE `smart_scripts` SET `event_param3`=2000 ,`event_param4`=2000 WHERE `entryorguid` IN (4421) AND `source_type`=0 AND `id`=8; +UPDATE `smart_scripts` SET `event_param1`=1000 ,`event_param2`=1000, `event_param3`=60000 ,`event_param4`=60000 WHERE `entryorguid` IN (4424) AND `source_type`=0 AND `id`=0; +UPDATE `smart_scripts` SET `event_param1`=2000 ,`event_param2`=2000 WHERE `entryorguid` IN (5808) AND `source_type`=0 AND `id`=0; -- cgit v1.2.3