From 2e34af64cf83d79b7352636da71b60132b512106 Mon Sep 17 00:00:00 2001 From: QAston Date: Tue, 4 Aug 2009 01:44:14 +0200 Subject: *Allow ItemExpire events to be scripted. *Add .debug itemexpire command *Add script for Disgusting Jar and Mysterious Egg - original patch by Elron. --HG-- branch : trunk --- sql/FULL/world_scripts_full.sql | 2 ++ sql/FULL/world_spell_full.sql | 1 - sql/updates/4748_world.sql | 2 ++ 3 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 sql/updates/4748_world.sql (limited to 'sql') diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 21c295d748c..1b1dfdf5281 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -84,6 +84,8 @@ UPDATE `item_template` SET `ScriptName`='item_zezzaks_shard' WHERE `entry`=31463 UPDATE `item_template` SET `ScriptName`='item_only_for_flight' WHERE `entry` IN (34475, 34489, 24538); UPDATE `item_template` SET `ScriptName`='item_inoculating_crystal' WHERE `entry`=22962; UPDATE `item_template` SET `ScriptName`='item_incendiary_explosives' WHERE (`entry`=35704); +UPDATE `item_template` SET `ScriptName`='item_mysterious_egg' WHERE `entry` IN(39878); +UPDATE `item_template` SET `ScriptName`='item_disgusting_jar' WHERE `entry` IN(44717); /* NPC (usually creatures to be found in more than one specific zone) */ UPDATE `creature_template` SET `ScriptName`='npc_air_force_bots' WHERE `entry` IN (2614, 2615, 21974, 21993, 21996, 21997, 21999, 22001, 22002, 22003, 22063, 22065, 22066, 22068, 22069, 22070, 22071, 22078, 22079, 22080, 22086, 22087, 22088, 22090, 22124, 22125, 22126); diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index 13c84b10b25..b3ee1183160 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -1409,7 +1409,6 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 64343, 0x00, 3, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Impact ( 64976, 0x00, 4, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Juggernaut ( 64914, 0x00, 8, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Rogue T8 2P Bonus -( 64928, 0x00, 11, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Item - Shaman T8 Elemental 4P Bonus ( 64938, 0x00, 4, 0x00200040, 0x00000000, 0x00000000, 0x00000000, 0x00000002, 0, 0, 0), -- Item - Warrior T8 Melee 2P Bonus ( 64952, 0x00, 7, 0x00000000, 0x00000440, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Druid T8 Feral Relic ( 64964, 0x00, 15, 0x00000000, 0x20000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Death Knight T8 Tank Relic diff --git a/sql/updates/4748_world.sql b/sql/updates/4748_world.sql new file mode 100644 index 00000000000..00834293554 --- /dev/null +++ b/sql/updates/4748_world.sql @@ -0,0 +1,2 @@ +UPDATE `item_template` SET `ScriptName`='item_mysterious_egg' WHERE `entry` IN(39878); +UPDATE `item_template` SET `ScriptName`='item_disgusting_jar' WHERE `entry` IN(44717); -- cgit v1.2.3