[Borean Tundra] A Race Against Time #1074

click opened this Issue May 16, 2011 · 7 comments


None yet
6 participants

click commented May 16, 2011

[Borean Tundra] [A Race Against Time] http://www.wowhead.com/quest=11671[]

In this quest you must go to [Beryl Point] http://www.wowwiki.com/Beryl_Point [] and use an item called [Beryl Shield Detonator] http://www.wowhead.com/item=34897[] to bring down the shield.
Once shield is down, You are then to defeat [Inquisitor Salrand] http://www.wowhead.com/npc=25584[ ] and collect the [Salrand's Key] http://www.wowhead.com/item=34948[] she holds.

the problem with this quest is when i use the [Beryl Shield Detonator] it doesnt count that i used it, it gives me a message "requires beryl force shield" even when im too close to it.

In addition players can also go thew the force shield, its not supposed to be like this as its supposed to block players from entering it.

Pictures here :



Ryan4322120 / AKA Ryanburd1


click commented May 16, 2011

Author: supabad

SET @GUID = xxxx;
DELETE FROM `gameobject` WHERE `guid`=@guid;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES

the item is missing a spell focus object. this wil spawn that specific TEMP object.
though this requires more scripting and research.

well... fingers crossed it would be nice if this could be fixed =P


w1sht0l1v3 commented Aug 7, 2012

try this

-- A Race Against Time (11671)

SET @NPC_SALRAND                := 25584; -- Inquisitor Salrand
SET @NPC_BERYL_INVISMAN         := 25594; -- Beryl Point InvisMan
SET @GOB_BERYL_SHIELD           := 187773; -- Beryl Shield
SET @GOB_BERYL_SHIELD_FOCUS     := 300176; -- TEMP Beryl Force Shield
SET @SPELL_BEAM                 := 45777; -- Salrand's Beam
SET @SPELL_THROW_DETONATOR      := 45780; -- Throw Beryl Shield Detonator
SET @SPELL_SUMMON_DETONATOR     := 45791; -- Summon Beryl Detonator
SET @SPELL_EXPLOSION            := 45796; -- Beryl Shield Explosion
SET @SPELL_LOCKBOX              := 45809; -- Summon Salrand's Lockbox
SET @GUID                       := 60441; -- used for a wrong go spawn,will reuse

UPDATE `gameobject_template` SET `data1`=80 WHERE  `entry`=300176; -- spell focus radius
UPDATE `gameobject_template` SET `flags`=32 WHERE  `entry`=187773; -- shield:nodespawn flag

-- missing spell focus
DELETE FROM `gameobject` WHERE `guid`=@GUID;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES

UPDATE `creature_template` SET `InhabitType`=0x4,`unit_flags`=0x100,`AIName`='SmartAI' WHERE `entry`=@NPC_SALRAND;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@NPC_BERYL_INVISMAN;

DELETE FROM `creature_template_addon` WHERE `entry`=@NPC_SALRAND;
INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`auras`) VALUES

DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@NPC_SALRAND;
DELETE FROM `smart_scripts` WHERE (`source_type`=0 AND `entryorguid` IN (@NPC_SALRAND,@NPC_BERYL_INVISMAN)) OR (`source_type`=9 AND `entryorguid` IN (@NPC_SALRAND*100,@NPC_BERYL_INVISMAN*100));
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_SALRAND,0,0,0,38,0,100,1,1,1,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'On data 1 1 - Say'),
(@NPC_SALRAND,0,1,2,38,0,100,1,1,2,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'On data 1 2 - Say'),
(@NPC_SALRAND,0,2,0,61,0,100,1,0,0,0,0,80,@NPC_SALRAND*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'On link - Run script'),
(@NPC_SALRAND,0,3,4,6,0,100,1,0,0,0,0,11,@SPELL_LOCKBOX,0,0,0,0,0,1,0,0,0,0,0,0,0,'On death - Cast spell'),
(@NPC_SALRAND,0,4,0,61,0,100,1,0,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'On death - Say'),
(@NPC_SALRAND,0,5,0,11,0,100,1,0,0,0,0,24,0,0,0,0,0,0,15,0,0,0,0,0,0,0,'On respawn - Evade'),
(@NPC_SALRAND*100,9,0,0,0,0,100,0,0,0,0,0,60,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'On script - set fly off'),
(@NPC_SALRAND*100,9,1,0,0,0,100,0,0,0,0,0,69,0,0,0,0,0,0,8,0,0,0,3392.852,6161.092,79.83095,0,'On script - Move to pos'),
(@NPC_SALRAND*100,9,2,0,0,0,100,0,3000,3000,0,0,19,256,0,0,0,0,0,1,0,0,0,0,0,0,0,'On script - Set unit flags'),
(@NPC_BERYL_INVISMAN,0,0,0,8,0,100,0,@SPELL_THROW_DETONATOR,0,0,0,80,@NPC_BERYL_INVISMAN*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'On spellhit - Run Script'),
(@NPC_BERYL_INVISMAN*100,9,0,0,0,0,100,0,0,0,0,0,11,@SPELL_SUMMON_DETONATOR,0,0,0,0,0,1,0,0,0,0,0,0,0,'On script - Cast Spell'),
(@NPC_BERYL_INVISMAN*100,9,1,0,0,0,100,0,0,0,0,0,45,1,1,0,0,0,0,19,@NPC_SALRAND,100,0,0,0,0,0,'On script - Set Data'),
(@NPC_BERYL_INVISMAN*100,9,2,0,0,0,100,0,8000,8000,0,0,45,1,2,0,0,0,0,19,@NPC_SALRAND,100,0,0,0,0,0,'On script - Set Data'),
(@NPC_BERYL_INVISMAN*100,9,3,0,0,0,100,0,2000,2000,0,0,11,@SPELL_EXPLOSION,0,0,0,0,0,1,0,0,0,0,0,0,0,'On script - Cast Spell');

DELETE FROM `creature_text` WHERE `entry`=@NPC_SALRAND;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(@NPC_SALRAND,0,0,'What is the meaning of this disturbance?!',14,0,100,0,0,0,'Inquisitor Salrand to Beryl Point InvisMan'),
(@NPC_SALRAND,1,0,'Who dares interrupt my work!? Show yourself, coward!',14,0,100,0,0,0,'Inquisitor Salrand to Beryl Point InvisMan'),
(@NPC_SALRAND,2,0,'I''ve destroyed the key! Your cherished archmage belongs to Malygos!',12,0,100,0,0,0,'Inquisitor Salrand');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@SPELL_DETONATOR;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(13,1,@SPELL_DETONATOR,0,0,31,0,3,@NPC_BERYL_INVISMAN,0,0,0,'','Throw Beryl Shield Detonator target npc');

@DDuarte DDuarte closed this in 543ec0c Aug 27, 2012

DDuarte added a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014

This one may have regressed.
I keep getting "Target is not in line of sight" after she drops down.
I tried a few things without success.

TDB 335.58 + latest updates (up to 13-06-2015)


Killyana commented Jun 17, 2015


DELETE FROM `smart_scripts` WHERE `entryorguid` IN (2558400) AND `source_type`=9 AND `id`>2;
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
(2558400, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 28, 45775, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0,'Inquisitor Salrand - On Script - Remove Aura'),
(2558400, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 30, 0, 0, 0, 0, 0, 0,'Inquisitor Salrand - On Script - Start attack');

Nope. She drops down after the first bomb explodes but even after all of them have been detonated I still can't hit her.


Killyana commented Jun 17, 2015

Updated: This will fix the problem.

Aokromes added a commit that referenced this issue Jun 28, 2015

DDuarte added a commit that referenced this issue Jul 12, 2015

DB/World: Cherry-pick 27 commits from 3.3.5
221a874 DB/Quest: Rivenwood Captives By Killyana, closes #3648
dbaf885 DB/Text: Fix wrong broadcast text id
f5530c7 DB/Misc: Megzeg Nukklebust By @tkrokli Closes #14863
d08524c DB/Path: Sunreaver Hawkrider in Crystalsong Forest
b067f20 DB: Fix date for file
0d66b19 DB/Path: Silver Covenant Horseman in Crystalsong Forest/Windrunner's Overlook
89c6e5d DB/Misc: Various fixes * Quest rewards for Kael'thas and the Verdant Sphere - Closes #14452 * Quest rewards for The Cipher of Damnation - Closes #14879 * VOA Meeting stone - Closes #10502 * Fix a db error
6af3bc6 Fix file name
170ba68 DB/Quest: Hellfire Fortifications By tkrokli, closes #14887
d5c84d5 DB/Path: Gundrak Savage pathing
20e3da1 Fix file name
c8ee638 DB/Quest: Fix 2 swapped values of midsummer event
a29433f DB/Quest: I've Got a Flying Machine Closes #14965 By Killyana
791356c DB/Oculus: mob missing spells / visuals
e243df4 DB/Oculus: typo in sql
813a903 DB/Misc: Fix startup errors By Killyana, updates #14730
7e5307b DB/Creature: Innkeeper Keldamyr By MrSmite, closes #12474
77d083e DB/Quest: The Perfect Dissemblance By Killyana, closes #12439
9132cfe DB/Quest: A Race Against Time By Killyana, closes #1074
d3590f9 DB/Quest: Master the Storm By Killyana, closes #1883
3720be3 DB/Gameobject: Silithyst Mound By Killyana, closes #14637
5b6cbe8 Update 2015_06_28_02_world.sql
6527046 DB/Misc: Fix a runtime error By Killyana, updates #14730
5ff8073 DB/Creature: Fixing some auras set with a wrong event By Killyana, closes #14875
7c7d258 DB/Misc: Brewfest - Wrong item in vendors By sirikfoll, closes #14989
fd299c5 DB/Misc: Spawn several missing gameobjects and creatures in The Eye - Several pack of mobs and triggers spawned - Spawned doors at Kael's room - Corrected spawn coords for Kael'thas and his advisors from sniffs - Removed improper spawns of Ember of Alar
b4a293f SQL: Quickfix a typo
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment