From 68bfe8c831c107ccdd43475ed2a89b7848b6ab32 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Tue, 15 May 2012 12:41:00 +0200 Subject: Core/Spell: Fix not using Shadowstep while rooted --- sql/updates/world/2012_05_15_00_world_spell_script_names.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/world/2012_05_15_00_world_spell_script_names.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_05_15_00_world_spell_script_names.sql b/sql/updates/world/2012_05_15_00_world_spell_script_names.sql new file mode 100644 index 00000000000..980aceff519 --- /dev/null +++ b/sql/updates/world/2012_05_15_00_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=36554; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(36554,'spell_rog_shadowstep'); -- cgit v1.2.3 From 8585df1c1946f5f4f61e80bf877821871a1fb364 Mon Sep 17 00:00:00 2001 From: w1sht0l1v3 Date: Thu, 9 Aug 2012 22:05:25 +0100 Subject: DB/SAI: Fix quest Territorial Trespass --- sql/updates/world/2012_08_09_01_world_sai.sql | 48 +++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) create mode 100644 sql/updates/world/2012_08_09_01_world_sai.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_09_01_world_sai.sql b/sql/updates/world/2012_08_09_01_world_sai.sql new file mode 100644 index 00000000000..94dce1bcc2c --- /dev/null +++ b/sql/updates/world/2012_08_09_01_world_sai.sql @@ -0,0 +1,48 @@ +-- Territorial Trespass (13051) + +SET @NPC_VERANUS := 30461; +SET @QUEST := 13051; +SET @EVENT := 19714; +SET @NPC_THORIM := 30462; +SET @SPELL_MOUNT := 43671; + +UPDATE `creature_template` SET `HoverHeight`=10.8,`speed_walk`=3.2,`speed_run`=1.42857146263123,`VehicleId`=237,`minlevel`=80,`faction_A`=14,`faction_H`=14,`unit_flags`=0x8140,`InhabitType`=5 WHERE `entry`=@NPC_VERANUS; + +DELETE FROM `creature_template_addon` WHERE `entry`=@NPC_VERANUS; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`auras`) VALUES +(@NPC_VERANUS,0,0x3000000,0x1,''); + +DELETE FROM `creature_text` WHERE `entry` IN (@NPC_VERANUS,@NPC_THORIM); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@NPC_VERANUS,0,0,'%s lets out a bellowing roar as she descends upon the nest.',16,0,100,15,0,0,'Veranus'), +(@NPC_THORIM,0,0,'Look out below!',14,0,100,0,0,0,'Thorim'), +(@NPC_THORIM,1,0,'Easy there, girl! Don''t you recognize your old master?',12,0,100,0,0,0,'Thorim'), +(@NPC_THORIM,2,0,'I will see you at the Temple of Storms. Looks like I''m going to have to break her in again.',12,0,100,0,0,0,'Thorim'); + +-- Veranus SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@NPC_VERANUS,@NPC_THORIM); +DELETE FROM `smart_scripts` WHERE (`entryorguid` IN (@NPC_VERANUS,@NPC_THORIM) AND `source_type`=0) OR (`entryorguid`=@NPC_THORIM*100 AND `source_type`=9); +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 +(@NPC_VERANUS,0,0,0,54,0,100,0,0,0,0,0,53,1,@NPC_VERANUS,0,@QUEST,0,0,1,0,0,0,0,0,0,0,'Veranus - On Summoned - Start WP-Movement'), +(@NPC_VERANUS,0,1,2,58,0,100,0,1,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Veranus - On WP-End - Talk(emote)'), +(@NPC_VERANUS,0,2,3,61,0,100,0,1,0,0,0,33,@NPC_VERANUS,0,0,0,0,0,7,0,0,0,0,0,0,0,'Veranus - On WP-End - Give quest credit'), +(@NPC_VERANUS,0,3,0,61,0,100,0,0,0,0,0,12,@NPC_THORIM,8,0,0,0,0,8,0,0,0,7096.863,-904.658,1119.904,2.338741,'Veranus - On WP-End - Summon Thorim'), +(@NPC_VERANUS,0,4,5,38,0,100,0,1,1,0,0,46,100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Veranus - On data - Move forward'), +(@NPC_VERANUS,0,5,0,61,0,100,0,0,0,0,0,41,10000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Veranus - On data - despawn'), +-- +(@NPC_THORIM,0,0,0,54,0,100,0,0,0,0,0,80,@NPC_THORIM*100,2,0,0,0,0,1,0,0,0,0,0,0,0,'Thorim - On Summoned - Start script'), +(@NPC_THORIM,0,1,0,38,0,100,0,1,1,0,0,41,10000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Thorim - On data - despawn'), +(@NPC_THORIM*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Thorim - On Script - Talk(yell)'), +(@NPC_THORIM*100,9,1,0,0,0,100,0,0,0,0,0,11,@SPELL_MOUNT,0,0,0,0,0,7,0,0,0,0,0,0,0,'Thorim - On Script - Cast spell mount'), +(@NPC_THORIM*100,9,2,0,0,0,100,0,10000,10000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Thorim - On Script - Talk(say)'), +(@NPC_THORIM*100,9,3,0,0,0,100,0,5000,5000,0,0,1,2,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Thorim - On Script - Talk(say)'), +(@NPC_THORIM*100,9,4,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,7,0,0,0,0,0,0,0,'Thorim - On Script - Set data'), +(@NPC_THORIM*100,9,5,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,1,0,0,0,0,0,0,0,'Thorim - On Script - Set data'); + +DELETE FROM `waypoints` WHERE `entry`=@NPC_VERANUS; +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +(@NPC_VERANUS,1,7083.224,-912.2372,1090.213,'Veranus - WP1'); + +DELETE FROM `event_scripts` WHERE `id`=@EVENT; +INSERT INTO `event_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES +(@EVENT,0,10,@NPC_VERANUS,600000,0,6947.481,-859.5176,1147.604,5.674867); -- cgit v1.2.3 From f57531376b9ae17f2f290604041ec4b2086621e5 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Fri, 10 Aug 2012 03:03:52 +0100 Subject: DB/Conditions: Fix startup db errors Closes #7334 --- sql/updates/world/2012_08_10_00_world_conditions.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2012_08_10_00_world_conditions.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_10_00_world_conditions.sql b/sql/updates/world/2012_08_10_00_world_conditions.sql new file mode 100644 index 00000000000..14c5c570b6e --- /dev/null +++ b/sql/updates/world/2012_08_10_00_world_conditions.sql @@ -0,0 +1,7 @@ +SET @ENTRY := 27482; -- Wounded Westfall Infantry npc +SET @SPELL := 48845; -- Renew Infantry spell +SET @ITEM := 37576; -- Renewing Bandage item +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceEntry`=@ITEM; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=@SPELL; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(17,0,@SPELL,0,31,1,3,@ENTRY,0,0,0,'', "Item Renewing Bandage target Wounded Westfall Infantry"); -- cgit v1.2.3 From 2f6b08807dbab89777c0d2f3ab015fc03c029cd7 Mon Sep 17 00:00:00 2001 From: nelegalno Date: Fri, 10 Aug 2012 03:06:32 +0100 Subject: DB/Loot: Loot fixes for Temple of Ahn'Qiraj boses Closes #7335 --- .../world/2012_08_10_01_world_loot_template.sql | 25 ++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 sql/updates/world/2012_08_10_01_world_loot_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_10_01_world_loot_template.sql b/sql/updates/world/2012_08_10_01_world_loot_template.sql new file mode 100644 index 00000000000..07d400dc0d7 --- /dev/null +++ b/sql/updates/world/2012_08_10_01_world_loot_template.sql @@ -0,0 +1,25 @@ +-- Emperor Vek'nilash update loot chance based on http://old.wowhead.com/npc=15275#drops:0+1-15 by nelegalno +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=11 WHERE `entry`=15275 AND `item`=21606; -- Belt of the Fallen Emperor +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=12 WHERE `entry`=15275 AND `item`=21604; -- Bracelets of Royal Redemption +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=11 WHERE `entry`=15275 AND `item`=21605; -- Gloves of the Hidden Temple +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=11 WHERE `entry`=15275 AND `item`=21607; -- Grasp of the Fallen Emperor +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`= 7 WHERE `entry`=15275 AND `item`=21679; -- Kalimdor's Revenge +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=11 WHERE `entry`=15275 AND `item`=21609; -- Regenerating Belt of Vek'nilash +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=63 WHERE `entry`=15275 AND `item`=20726; -- Formula: Enchant Gloves - Threat + +-- Emperor Vek'lor update loot chance based on http://old.wowhead.com/npc=15276#drops:0+1-15 by nelegalno +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=11 WHERE `entry`=15276 AND `item`=21600; -- Boots of Epiphany +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=13 WHERE `entry`=15276 AND `item`=21602; -- Qiraji Execution Bracers +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=13 WHERE `entry`=15276 AND `item`=21601; -- Ring of Emperor Vek'lor +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=14 WHERE `entry`=15276 AND `item`=21598; -- Royal Qiraji Belt +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`= 7 WHERE `entry`=15276 AND `item`=21597; -- Royal Scepter of Vek'lor +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=13 WHERE `entry`=15276 AND `item`=21599; -- Vek'lor's Gloves of Devastation +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=64 WHERE `entry`=15276 AND `item`=20735; -- Formula: Enchant Cloak - Subtlety + +-- Princess Huhuran update loot chance based on http://old.wowhead.com/npc=15509#drops:0+1-15 by nelegalno +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=15 WHERE `entry`=15509 AND `item`=21621; -- Cloak of the Golden Hive +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=15 WHERE `entry`=15509 AND `item`=21619; -- Gloves of the Messiah +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=16 WHERE `entry`=15509 AND `item`=21618; -- Hive Defiler Wristguards +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`= 8 WHERE `entry`=15509 AND `item`=21616; -- Huhuran's Stinger +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=17 WHERE `entry`=15509 AND `item`=21620; -- Ring of the Martyr +UPDATE `creature_loot_template` SET `ChanceOrQuestChance`=14 WHERE `entry`=15509 AND `item`=21617; -- Wasphide Gauntlets -- cgit v1.2.3 From 41682b59a39a6645c85098ec49fce29fba5a4f42 Mon Sep 17 00:00:00 2001 From: Kinzcool Date: Fri, 10 Aug 2012 03:07:46 +0100 Subject: DB/Scripts: Add missing sounds to npc 29309 Closes #7305 --- sql/updates/world/2012_08_10_02_world_script_texts.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/2012_08_10_02_world_script_texts.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_10_02_world_script_texts.sql b/sql/updates/world/2012_08_10_02_world_script_texts.sql new file mode 100644 index 00000000000..0b97df592e1 --- /dev/null +++ b/sql/updates/world/2012_08_10_02_world_script_texts.sql @@ -0,0 +1,6 @@ +UPDATE `script_texts` SET `sound`=14036 WHERE `entry` = -1619015; +UPDATE `script_texts` SET `sound`=14037 WHERE `entry` = -1619016; +UPDATE `script_texts` SET `sound`=14038 WHERE `entry` = -1619017; +UPDATE `script_texts` SET `sound`=14039 WHERE `entry` = -1619018; +UPDATE `script_texts` SET `sound`=14034 WHERE `entry` = -1619019; +UPDATE `script_texts` SET `sound`=14035 WHERE `entry` = -1619020; -- cgit v1.2.3 From 76f0e87263a17d648f37be727954066ad6055f0a Mon Sep 17 00:00:00 2001 From: nelegalno Date: Fri, 10 Aug 2012 03:18:04 +0100 Subject: DB/Quests: Zandalar Tribe Quests Required Class/Race FIX Closes #7322 --- .../world/2012_08_10_03_world_quest_template.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 sql/updates/world/2012_08_10_03_world_quest_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_10_03_world_quest_template.sql b/sql/updates/world/2012_08_10_03_world_quest_template.sql new file mode 100644 index 00000000000..c4aebf5ba16 --- /dev/null +++ b/sql/updates/world/2012_08_10_03_world_quest_template.sql @@ -0,0 +1,18 @@ +-- Zandalar Tribe Quests Required Class/Race fix by nelegalno + +-- Maywiki of Zuldazar Quests Required Class +UPDATE `quest_template` SET `RequiredClasses` = 64 WHERE `Id` IN (8056,8074,8075,8116,8117,8118,8119); -- Shaman +UPDATE `quest_template` SET `RequiredClasses` = 1024 WHERE `Id` IN (8057,8064,8065,8110,8111,8112,8113); -- Druid + +-- Al'tabim the All-Seeing Quests Required Class +UPDATE `quest_template` SET `RequiredClasses` = 16 WHERE `Id` IN (8049,8050,8051,8052,8061,8070,8071); -- Priest +UPDATE `quest_template` SET `RequiredClasses` = 128 WHERE `Id` IN (8060,8068,8069,8101,8102,8103,8104); -- Mage +UPDATE `quest_template` SET `RequiredClasses` = 256 WHERE `Id` IN (8059,8076,8077,8106,8107,8108,8109); -- Warlock + +-- Falthir the Sightless Quests Required Class +UPDATE `quest_template` SET `RequiredClasses` = 4 WHERE `Id` IN (8062,8066,8067,8145,8146,8147,8148); -- Hunter +UPDATE `quest_template` SET `RequiredClasses` = 8 WHERE `Id` IN (8063,8072,8073,8141,8142,8143,8144); -- Rogue +UPDATE `quest_template` SET `RequiredRaces` = 152 WHERE `Id` = 8144; -- Night Elf, Undead and Troll + +-- Jin'rokh the Breaker +UPDATE `quest_template` SET `RequiredRaces` = 513 WHERE `Id` = 8048; -- Human and Blood Elf -- cgit v1.2.3 From 6dd1e198cdd306be524de9f5274684033578b0ca Mon Sep 17 00:00:00 2001 From: RedSonja Date: Fri, 10 Aug 2012 03:24:45 +0100 Subject: DB/NPCs: Fix Barim Splithoof leather trainer gossip options Closes #2677 --- sql/updates/world/2012_08_10_04_world_gossip.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2012_08_10_04_world_gossip.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_10_04_world_gossip.sql b/sql/updates/world/2012_08_10_04_world_gossip.sql new file mode 100644 index 00000000000..a2082447dfc --- /dev/null +++ b/sql/updates/world/2012_08_10_04_world_gossip.sql @@ -0,0 +1,5 @@ +-- -18754 Barim Splithoof Leather working trainer +DELETE FROM `gossip_menu_option` WHERE `menu_id`=7816; +INSERT INTO `gossip_menu_option` VALUES +(7816,0,3, 'I would like to train.', 5,16,0,0,0,0,NULL), +(7816,1,1, 'Let me browse your goods.', 3,128,0,0,0,0,NULL); -- cgit v1.2.3 From 68453c69b7577f6b17aedd82b8c177dcead2cc7d Mon Sep 17 00:00:00 2001 From: gecko32 Date: Fri, 10 Aug 2012 03:37:03 +0100 Subject: DB/Quests: Fix a typo in Message to Freewind Post description Closes #7340 --- sql/updates/world/2012_08_10_05_world_quest_template.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2012_08_10_05_world_quest_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_10_05_world_quest_template.sql b/sql/updates/world/2012_08_10_05_world_quest_template.sql new file mode 100644 index 00000000000..a65e7e76a44 --- /dev/null +++ b/sql/updates/world/2012_08_10_05_world_quest_template.sql @@ -0,0 +1,2 @@ +-- Change $B$$B at end of details text to $B$B +UPDATE `quest_template` SET `Details`='Brave traveler, the centaurs have increased their attacks in this area. Freewind Post must know about this renewed harassment immediately! Seek Cliffwatcher Longhorn at Freewind Post to the southeast and give him this urgent message.$b$bBe warned, avoid the Grimtotem Clan nearby... they have been acting strange toward us lately.$B$B' WHERE `Id`=4542; -- cgit v1.2.3 From 53bc7c2ff5facfe0abddbba4d26ed6462974052c Mon Sep 17 00:00:00 2001 From: Svannon Date: Fri, 10 Aug 2012 03:59:12 +0100 Subject: DB/NPCs: Add missing Tracker Val'zij spawn Closes #2662 --- sql/updates/world/2012_08_10_06_world_creature.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2012_08_10_06_world_creature.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_08_10_06_world_creature.sql b/sql/updates/world/2012_08_10_06_world_creature.sql new file mode 100644 index 00000000000..3d59f06db78 --- /dev/null +++ b/sql/updates/world/2012_08_10_06_world_creature.sql @@ -0,0 +1,16 @@ +SET @CGUID:=42571; -- Need 2 +DELETE FROM `creature` WHERE `id` IN (30395,30469); +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES +(@CGUID+0,30395,571,1,1,0,0,8348.886,-2509.476,1147.369,3.700098,120,0,0,12600,0,0,0,0,0), +(@CGUID+1,30469,571,1,1,0,0,7620.369,-1609.421,969.6507,0.767944,120,0,0,12600,0,0,0,0,0); + +-- Template updates +UPDATE `creature_template` SET `npcflag`=`npcflag`|3 WHERE `entry`=30395; -- Chieftain Swiftspear +UPDATE `creature_template` SET `faction_A`=1978,`faction_H`=1978 WHERE `entry`=30469; -- Tracker Val'zij +-- Model data +UPDATE `creature_model_info` SET `bounding_radius`=0.6076385,`combat_reach`=2.625,`gender`=0 WHERE `modelid`=27004; -- Chieftain Swiftspear +-- Addon data +DELETE FROM `creature_template_addon` WHERE `entry`IN (30395,30469); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(30395,0,0,1,0, NULL), -- Chieftain Swiftspear +(30469,0,8,1,0, NULL); -- Tracker Val'zij -- cgit v1.2.3