From b5cb8843252b404b25bf2ca87192737a416f6442 Mon Sep 17 00:00:00 2001 From: Nay Date: Thu, 8 Sep 2011 19:43:33 +0100 Subject: DB/Items: Fix a couple of consumable items --- sql/updates/world/2011_09_07_00_world_spell_target_position.sql | 5 ----- sql/updates/world/2011_09_07_01_world_spell_script_names.sql | 1 - sql/updates/world/2011_09_08_01_world_spell_target_position.sql | 5 +++++ sql/updates/world/2011_09_08_02_world_spell_script_names.sql | 1 + sql/updates/world/2011_09_08_03_world_item_template.sql | 9 +++++++++ 5 files changed, 15 insertions(+), 6 deletions(-) delete mode 100644 sql/updates/world/2011_09_07_00_world_spell_target_position.sql delete mode 100644 sql/updates/world/2011_09_07_01_world_spell_script_names.sql create mode 100644 sql/updates/world/2011_09_08_01_world_spell_target_position.sql create mode 100644 sql/updates/world/2011_09_08_02_world_spell_script_names.sql create mode 100644 sql/updates/world/2011_09_08_03_world_item_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_09_07_00_world_spell_target_position.sql b/sql/updates/world/2011_09_07_00_world_spell_target_position.sql deleted file mode 100644 index 5b9fb09d14c..00000000000 --- a/sql/updates/world/2011_09_07_00_world_spell_target_position.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM `spell_target_position` WHERE `id` IN (46233,52462,54963); -INSERT INTO `spell_target_position` (`id` ,`target_map` ,`target_position_x` ,`target_position_y` ,`target_position_z` ,`target_orientation`) VALUES -(46233,571,3202.959961,5274.073730,46.887897,0.015704), -- Call Mammoth Orphan -(52462,609,2387.738525,-5898.617676,108.353539,4.354776), -- Hide In Mine Car -(54963,571,6153.721191,-1075.270142,403.517365,2.232988); -- Teleporter Power Cell diff --git a/sql/updates/world/2011_09_07_01_world_spell_script_names.sql b/sql/updates/world/2011_09_07_01_world_spell_script_names.sql deleted file mode 100644 index b97a1ef299a..00000000000 --- a/sql/updates/world/2011_09_07_01_world_spell_script_names.sql +++ /dev/null @@ -1 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_baltharus_enervating_brand'; diff --git a/sql/updates/world/2011_09_08_01_world_spell_target_position.sql b/sql/updates/world/2011_09_08_01_world_spell_target_position.sql new file mode 100644 index 00000000000..5b9fb09d14c --- /dev/null +++ b/sql/updates/world/2011_09_08_01_world_spell_target_position.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_target_position` WHERE `id` IN (46233,52462,54963); +INSERT INTO `spell_target_position` (`id` ,`target_map` ,`target_position_x` ,`target_position_y` ,`target_position_z` ,`target_orientation`) VALUES +(46233,571,3202.959961,5274.073730,46.887897,0.015704), -- Call Mammoth Orphan +(52462,609,2387.738525,-5898.617676,108.353539,4.354776), -- Hide In Mine Car +(54963,571,6153.721191,-1075.270142,403.517365,2.232988); -- Teleporter Power Cell diff --git a/sql/updates/world/2011_09_08_02_world_spell_script_names.sql b/sql/updates/world/2011_09_08_02_world_spell_script_names.sql new file mode 100644 index 00000000000..b97a1ef299a --- /dev/null +++ b/sql/updates/world/2011_09_08_02_world_spell_script_names.sql @@ -0,0 +1 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_baltharus_enervating_brand'; diff --git a/sql/updates/world/2011_09_08_03_world_item_template.sql b/sql/updates/world/2011_09_08_03_world_item_template.sql new file mode 100644 index 00000000000..c5809d798fa --- /dev/null +++ b/sql/updates/world/2011_09_08_03_world_item_template.sql @@ -0,0 +1,9 @@ +UPDATE `item_template` SET `BuyPrice` = 40000, `delay` = 0, `spellcharges_1` = -1, `spellcooldown_1` = 0, `spellcooldown_2` = 0, `spellcooldown_3` = 0, `spellcooldown_4` = 0, `spellcooldown_5` = 0, `spellcategory_1` = 79, `spellcategorycooldown_1` = 3000, `spellcategorycooldown_2` = 0, `spellcategorycooldown_3` = 0, `spellcategorycooldown_4` = 0, `spellcategorycooldown_5` = 0, `WDBVerified`=12340 WHERE `entry` = 45006; -- Jillian's Tonic of Endless Rage +UPDATE `item_template` SET `BuyPrice` = 40000, `delay` = 0, `spellcharges_1` = -1, `spellcooldown_1` = 0, `spellcooldown_2` = 0, `spellcooldown_3` = 0, `spellcooldown_4` = 0, `spellcooldown_5` = 0, `spellcategory_1` = 79, `spellcategorycooldown_1` = 3000, `spellcategorycooldown_2` = 0, `spellcategorycooldown_3` = 0, `spellcategorycooldown_4` = 0, `spellcategorycooldown_5` = 0, `WDBVerified`=12340 WHERE `entry` = 45007; -- Jillian's Tonic of Pure Mojo +UPDATE `item_template` SET `delay` = 0, `spellcooldown_1` = 0, `spellcooldown_2` = 0, `spellcooldown_3` = 0, `spellcooldown_4` = 0, `spellcooldown_5` = 0, `spellcategorycooldown_2` = 0, `spellcategorycooldown_3` = 0, `spellcategorycooldown_4` = 0, `spellcategorycooldown_5` = 0, `WDBVerified`=12340 WHERE `entry` = 45008; -- Jillian's Tonic of Stoneblood +UPDATE `item_template` SET `BuyPrice` = 40000, `delay` = 0, `spellcharges_1` = -1, `spellcooldown_1` = 0, `spellcooldown_2` = 0, `spellcooldown_3` = 0, `spellcooldown_4` = 0, `spellcooldown_5` = 0, `spellcategory_1` = 79, `spellcategorycooldown_1` = 3000, `spellcategorycooldown_2` = 0, `spellcategorycooldown_3` = 0, `spellcategorycooldown_4` = 0, `spellcategorycooldown_5` = 0, `WDBVerified`=12340 WHERE `entry` = 45009; -- Jillian's Tonic of the Frost Wyrm +UPDATE `item_template` SET `BuyPrice` = 200, `stackable` = 20, `delay` = 0, `spellcharges_1` = -1, `spellcooldown_1` = 0, `spellcooldown_2` = 0, `spellcooldown_3` = 0, `spellcooldown_4` = 0, `spellcooldown_5` = 0, `spellcategory_1` = 4, `spellcategorycooldown_1` = 60000, `spellcategorycooldown_2` = 0, `spellcategorycooldown_3` = 0, `spellcategorycooldown_4` = 0, `spellcategorycooldown_5` = 0, `WDBVerified`=12340 WHERE `entry` = 45276; -- Jillian's Genius Juice +UPDATE `item_template` SET `BuyPrice` = 200, `stackable` = 20, `delay` = 0, `spellcharges_1` = -1, `spellcooldown_1` = 0, `spellcooldown_2` = 0, `spellcooldown_3` = 0, `spellcooldown_4` = 0, `spellcooldown_5` = 0, `spellcategory_1` = 4, `spellcategorycooldown_1` = 60000, `spellcategorycooldown_2` = 0, `spellcategorycooldown_3` = 0, `spellcategorycooldown_4` = 0, `spellcategorycooldown_5` = 0, `WDBVerified`=12340 WHERE `entry` = 45277; -- Jillian's Savior Sauce +UPDATE `item_template` SET `BuyPrice` = 6, `delay` = 0, `spellcharges_1` = -1, `spellcooldown_1` = 0, `spellcategory_1` = 11, `spellcategorycooldown_1` = 1000, `WDBVerified`=12340 WHERE `entry` = 45279; -- Jillian's Gourmet Fish Feast +UPDATE `item_template` SET `WDBVerified`=12340 WHERE `entry` =46766; -- Red War Fuel +UPDATE `item_template` SET `Quality`=0,`Flags`=65538,`WDBVerified`=12340 WHERE `entry`=10791; -- Goblin Engineer Membership Card -- cgit v1.2.3