From 17061cb9e52d409f70dbe063b73cae9cd02c7db3 Mon Sep 17 00:00:00 2001 From: Trista Date: Fri, 8 Mar 2013 04:45:15 +0200 Subject: Scripts/Icecrown: Add script* support for Borrowed Technology/Volatility quests * There are heavy core problems that make it not fully functional for now. 1) Enter vehicle of 31578 is being overriding the vehicle aura of the accessory so it kicks it out. (both get applied to 1, but instead decoy should be to 0). 2) Even if mentioned above get fixed the accessory is supposed to implicitly hit another passenger with explosion and no seat flags for it even unknown. 3) Armored Decoy doesn't keep emote from freeze mechanic when enter vehicle connected with a not supported flag. 4) Vehicle speed seems too fast (there is some general vehicle not correct speed problem with spline being involved). Connected with: #5757 --- .../2013_03_08_00_world_borrowed_technology.sql | 58 ++++++++++++++++++++++ 1 file changed, 58 insertions(+) create mode 100644 sql/updates/world/2013_03_08_00_world_borrowed_technology.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_03_08_00_world_borrowed_technology.sql b/sql/updates/world/2013_03_08_00_world_borrowed_technology.sql new file mode 100644 index 00000000000..06363183836 --- /dev/null +++ b/sql/updates/world/2013_03_08_00_world_borrowed_technology.sql @@ -0,0 +1,58 @@ +-- Fix quests Borrowed Technology, The Solution Solution /Daily/, Volatility, Volatility /Daily/ +-- thanks to genjush for corrections on wrong quest ids +SET @Skytalon := 31583; -- Frostbrood Skytalon +SET @Decoy := 31578; -- Armored Decoy +SET @QuestCredit := 59329; -- Fake Soldier Kill Credit +SET @Stun := 59292; -- Freeze animation to look like Decoy +SET @Explosion := 59335; -- The spell that should kill Skytalon and Decoy +SET @Summon := 59303; -- Summon Skyatalon +SET @Immolation := 54690; -- Skytalon burning animation spell +SET @Grab := 59318; +SET @Bunny := 31630; +SET @PingBunny := 59375; -- Skytalon cast on accessory bunny to tell it to explode after 6 seconds +SET @Script := @Bunny * 100; -- Explosion bunny timed action list + +-- Set inhabit type only 4 to Explosion Bunny that is a vehicle accessory of the Skytalon, otherwise it falls and add "Smart_AI" +UPDATE `creature_template` SET `InhabitType`=4,`AIName`='SmartAI',`flags_extra`=flags_extra|128 WHERE `entry`=@Bunny; +UPDATE `creature_template` SET `unit_flags`=unit_flags|0x00000100|0x00008000,`faction_A`=974,`faction_H`=974,`vehicleId`=279,`InhabitType`=4,`AIName`='',`ScriptName`='npc_frostbrood_skytalon',`HoverHeight`=5 WHERE `entry`=@Skytalon; +UPDATE `creature_template` SET `unit_flags`=unit_flags|0x00000100|0x00008000,`faction_A`=190,`faction_H`=190,`AIName`='SmartAI' WHERE `entry`=@Decoy; + +-- Add missing equipment +DELETE FROM `creature_equip_template` WHERE `entry`=@Decoy; +INSERT INTO `creature_equip_template` (`entry`,`id`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES +(@Decoy,1,21573,0,0); -- Armored Decoy -> Monster - Sword, 1H Alliance PvP + +-- Add creature_addon data +DELETE FROM `creature_template_addon` WHERE `entry`=@Skytalon; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(@Skytalon,0,0,50331648,1,0, '60534'); + +-- Insert spell_script names +DELETE FROM `spell_script_names` WHERE `spell_id` IN (@Grab,@Summon); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(@Grab, 'spell_q13291_q13292_q13239_q13261_frostbrood_skytalon_grab_decoy'), +(@Summon, 'spell_q13291_q13292_q13239_q13261_armored_decoy_summon_skytalon'); + +-- Quests relations +UPDATE `quest_template` SET `PrevQuestId`=13290,`NextQuestId`=13383 WHERE `id`=13291; -- Borrowed Technology +UPDATE `quest_template` SET `PrevQuestId`=13291,`NextQuestId`=0 WHERE `id`=13292; -- The Solution Solution /Daily/ +UPDATE `quest_template` SET `PrevQuestId`=13238,`NextQuestId`=13379 WHERE `id`=13239; -- Volatility +UPDATE `quest_template` SET `PrevQuestId`=13329,`NextQuestId`=0 WHERE `id`=13261; -- Volatiliy /Daily/ + +-- Add SAI support for Explosion bunny and Decoy +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (@Bunny,@Decoy); +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@Script; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@Bunny,0,0,0,8,0,100,0,@PingBunny,0,0,0,80,@Script,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Explosion Bunny - On hit by ping bunny - Start timed action list'), +(@Script,9,0,0,0,0,100,0,6000,6000,0,0,11,@Explosion,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Explosion Bunny - Action 0 - Cast explosion on self'), +(@Decoy,0,0,1,54,0,100,0,0,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Armored Decoy - On just summoned - Store invoker /since target summoner fails/'), +(@Decoy,0,1,2,61,0,100,0,0,0,0,0,11,@Stun,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Armored Decoy - Linked - Cast Freeze animation on self'), +(@Decoy,0,2,0,61,0,100,0,0,0,0,0,11,@Summon,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Armored Decoy - Linked - Cast summon Skytalon behind'), +(@Decoy,0,3,0,8,0,100,0,@Explosion,0,0,0,11,@QuestCredit,0,0,0,0,0,12,1,0,0,0,0,0,0, 'Armored Decoy - On hit by explosion - Cast kill credit to stored target'); + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (@Explosion,@PingBunny); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,@Explosion,0,0,31,0,3,@Decoy,0,0,0,0,'', 'Explosion Bunny can hit Armored Decoy'), +(13,1,@Explosion,0,1,31,0,3,@Skytalon,0,0,0,0,'', 'Explosion Bunny can hit Skytalon'), +(13,1,@PingBunny,0,0,31,0,3,@Bunny,0,0,0,0,'', 'Ping Bunny can hit only Explosion Bunny'); -- cgit v1.2.3 From 987826bc0db002a7c2727738adb20c924718ab68 Mon Sep 17 00:00:00 2001 From: Spp Date: Fri, 8 Mar 2013 13:58:15 +0100 Subject: Core/RBAC: Change default db permissions to behave like a server with default config before RBAC conversion (Missing change from previous commit) To enable any of the removed config option you should now add the proper role to the proper groups IE: AllowTwoSide.Interaction.Mail = 1 --> Add role 19 to group 1 (Add it to players) --- sql/updates/auth/2013_03_08_00_auth_misc.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/auth/2013_03_08_00_auth_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/2013_03_08_00_auth_misc.sql b/sql/updates/auth/2013_03_08_00_auth_misc.sql new file mode 100644 index 00000000000..85d61beff3d --- /dev/null +++ b/sql/updates/auth/2013_03_08_00_auth_misc.sql @@ -0,0 +1,9 @@ +-- Delete 'Two side mail interaction', 'Allow say chat between factions' and 'Allow channel chat between factions' from Player group +DELETE FROM `rbac_group_roles` WHERE `groupId` = 1 AND `roleId` IN (19, 28, 30); + +-- Delete 'Join channels withou announce' from Moderators group +DELETE FROM `rbac_group_roles` WHERE `groupId` = 2 AND `roleId` IN (31); + +-- Add 'Allow two side charater accounts' +DELETE FROM `rbac_group_roles` WHERE `roleId` = 34; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (1, 34); -- cgit v1.2.3 From 524a10d6286473afc3216b184738c81379479b74 Mon Sep 17 00:00:00 2001 From: Spp Date: Fri, 8 Mar 2013 14:05:51 +0100 Subject: Typo fix... ¬¬ MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- sql/updates/auth/2013_03_08_00_auth_misc.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql/updates') diff --git a/sql/updates/auth/2013_03_08_00_auth_misc.sql b/sql/updates/auth/2013_03_08_00_auth_misc.sql index 85d61beff3d..46e687b5da5 100644 --- a/sql/updates/auth/2013_03_08_00_auth_misc.sql +++ b/sql/updates/auth/2013_03_08_00_auth_misc.sql @@ -1,8 +1,8 @@ -- Delete 'Two side mail interaction', 'Allow say chat between factions' and 'Allow channel chat between factions' from Player group DELETE FROM `rbac_group_roles` WHERE `groupId` = 1 AND `roleId` IN (19, 28, 30); --- Delete 'Join channels withou announce' from Moderators group -DELETE FROM `rbac_group_roles` WHERE `groupId` = 2 AND `roleId` IN (31); +-- Delete 'Join channels without announce' from Moderators+ group +DELETE FROM `rbac_group_roles` WHERE `roleId` = 31; -- Add 'Allow two side charater accounts' DELETE FROM `rbac_group_roles` WHERE `roleId` = 34; -- cgit v1.2.3