[Quest] The Plains of Nasam

[AniRB]

http://www.wowhead.com/quest=11652

Not use vehicle

Last rev trinitycore
base last rev TDB

[phantomdl]

CORE 2b1dd6
DB 335.11.44
No addons

Confirmed the tanks are not able to be used.
http://www.openwow.com/?quest=11652

[Merlin2010]

INSERT INTO `npc_spellclick_spells` VALUES (25334,46598,11652,1,11652,1,0,0,0);
DELETE FROM `conditions` WHERE SourceEntry = 25334 AND ConditionTypeOrReference = 23;

[Nevadas]

Confirm, with this changes it is possible to use the vehicles.
Has anybody fixxes for the spells?

Thx

[peycho]

Confirmed.

There is no vehicle and if you just kill them you don't get kill credit.

TrinityCore rev. 4f5f148
TDB 335.11.46+

[Nevadas]

@ALein
Vehicles are spawneble creature_id=25334.
Notice: Its only a example(without guids)

INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES (25334, 571, 1, 1, 0, 0, 2800.85, 6735.15, 7.55704, 4.27899, 600, 0, 0, 53892, 15775, 0);
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES (25334, 571, 1, 1, 0, 0, 2789.28, 6740.63, 7.70007, 4.29445, 600, 0, 0, 53892, 15775, 0);
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES (25334, 571, 1, 1, 0, 0, 2777.9, 6745.56, 7.80592, 4.29317, 600, 0, 0, 53892, 15775, 0);
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES (25334, 571, 1, 1, 0, 0, 2766.15, 6751.18, 7.19781, 4.34369, 600, 0, 0, 53892, 15775, 0);

[peycho]

Thanks.
I know that I can spawn them manual, but this still isn't added in official repo and I think vehicle spell still doesn't work.

[Nevadas]

Yes , thats right! I hope one have fix for spells than we can do all the things together to a completly fix.

[boujii]

watching thread :)

[dr-j]

I did not write this btw but this works for quest,

[Nevadas]

Thx Dr-J!
The Tanks are visible the complete time. Only you can use they when the Q are startet.
I will test this things and give a feedback.

[Nevadas]

Some thinks about your post Dr-J.

Some small errors and a little bit visuals but two great things i see.
First the rescue of the injured fighters is a hack. We should use the spell to get the kill credits.
Second thing is the wrong spell in the Tank, it must be 50672 the Demoralizer.
And this spell dosnt work.
Also it must be delete the quest_start_script.

[Zedron]

• UPDATE quest_template SET WHERE Id=11652;

what is this @dr-j XD

[dr-j]

I suggest you read 1st line in my post I did not write that sql hence (I did not write this btw but this works for quest), and as already pointed out its not perfect, just remove that line xd

[nelegalno]

The original workaround can be found @ http://pastebin.com/aHzCRiX5

[Nevadas]

Hmm, thx nelegalno, but this is not from TC, or?
I found some special table names. But its possible the Basic is good.

[nelegalno]

Definitely not for TC and it's a hack-fix.

[arvit]

Still bugged
Core revision: Trinity Core 52d0e9f+
Database revision: TDB 335.50

[Nevadas]

I tested some Solutions and make the best from them to merge this. (I think so ;-))
IT's not a complete fix!! One thing more is todo!

Here a snipe where are the most things fixed.
We have only one major issue "Scourge Leader identified" was not castet when i get 100 kills
First minor issue (i think) is that the spell http://www.wowhead.com/spell=45750 have no effect!
Second minor issue is the spell http://www.wowhead.com/spell=50672 he works fine, but the visual effect have randomly another target.

-- QUEST The Plains of Nasam
SET @GUID := xxx; -- set the guid for spawning 4 are required
Delete from creature where id =25334;
INSERT INTO `creature` (`guid`,`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES
(@GUID ,25334, 571, 1, 1, 0, 0, 2800.85, 6735.15, 7.55704, 4.27899, 600, 0, 0, 53892, 15775, 0),
(@GUID+1 ,25334, 571, 1, 1, 0, 0, 2789.28, 6740.63, 7.70007, 4.29445, 600, 0, 0, 53892, 15775, 0),
(@GUID+2 ,25334, 571, 1, 1, 0, 0, 2777.9, 6745.56, 7.80592, 4.29317, 600, 0, 0, 53892, 15775, 0),
(@GUID+3 ,25334, 571, 1, 1, 0, 0, 2766.15, 6751.18, 7.19781, 4.34369, 600, 0, 0, 53892, 15775, 0);

update creature_template set faction_A=1978,faction_A=1978, unit_flags=4096, dynamicflags=0 where entry=25334;

DELETE FROM `conditions` WHERE SourceEntry = 25334 AND ConditionTypeOrReference = 23;

REPLACE INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`)
VALUES 
('47917','4027','11652','11652','0','0','2','0'),
('47917','4130','11652','11652','0','0','2','0');

UPDATE `creature_template` SET `spell1`=47849, `spell2`=50676,`spell3`=50672, `spell4`=45750, `spell5`=47962, `Health_mod`=5, `Mana_mod`=5 WHERE `entry`=25334;
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=25334 AND `spell_id`=46598;
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`) VALUES (25334, 46598, 1);

DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (27106, 27107, 27108, 27110);
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (27106, 27107, 27108, 27110);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27106, 27107, 27108, 27110) AND `source_type`=0;
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 
(27106, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Warrior - On Spell hit - Cast Killcredit on Invoker'),
(27106, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Warrior - On Spell hit - Despawn after 1sec'),
(27107, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Mage - On Spell hit - Cast Killcredit on Invoker'),
(27107, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Mage - On Spell hit - Despawn after 1sec'),
(27108, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Shaman - On Spell hit - Cast Killcredit on Invoker'),
(27108, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Shaman - On Spell hit - Despawn after 1sec'),
(27110, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Ingenieur - On Spell hit - Cast Killcredit on Invoker'),
(27110, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Ingenieur - On Spell hit - Despawn after 1sec');

-- NPC Scourge Plague Spreader
UPDATE `creature_template` SET `faction_A`=35, `faction_H`=35, `unit_flags`=`unit_flags`|2|33554432 WHERE `entry`=25349;
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|64 WHERE `entry` IN (25333, 25469, 25332);
-- NPC Abandoned Fuel Tank 
UPDATE `creature_template` SET `faction_A`=1978, `faction_H`=1978, `unit_flags`=`unit_flags`|2|33554432, `AIName`='SmartAI' WHERE `entry`=27064;    
DELETE FROM `smart_scripts` WHERE `entryorguid`=27064 AND `source_type`=0;
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
(27064, 0, 0, 1, 10, 0, 100, 0, 1, 2, 30000, 35000, 85, 47916, 2, 0, 0, 0, 0, 11, 25334, 2, 0, 0, 0, 0, 0, 'Abandoned Fuel Tank - On OOC LOS 2yd - Cast Fuel');

I hope it is blizzlike enough to take this and anybody can help me to bring the codestyle to trinitystyle.

Thx

[Nevadas]

I must comment my comment ;-)
The last thing that are open for ending the quest is "Identify Scourge Leader"

I read in some comments this:
Ride to the boss in the middle to identify Scourge Leader
Can anybody confirm this?

When it is true i found a area_trigger=4112 that must be scripted?

Thx

[arvit]

Ye somewhere in that area is Kel'Thuzad ( he is the Scourge leader you need to Identify )

[Nevadas]

The areatrigger 4112 is not useble for this quest.
Is used in Naxxramas near the NPC with the same name.

[Nevadas]

I foun a entry on areatrigger_involvedrelation with entry 4963 and i will test it again!

Edit: Yeah i can confirm thats the right areatrigger and he is included in thae actual DB+Core but (only on me? he dosnt work.

[Nevadas]

..... I must say sorry ! When we have all the other things for the Q completet than also the areatrigger was countet!
So i can (must) say for me works the quets now fine!

[ZxBiohazardZx]

so last fix is required or not?

[Nevadas]

it works fine! with this fix no other fix are needed!

[nerv234]

Yes, but it isn't complete. When you rescure npc"hit by spell" it should be passenger on demolisher and use spells.

[Nevadas]

Ok nerv234, thats right. have you any idea whats kind of mechanic he used?
Any spells to add this?

[nerv234]

I think npc's are scripted(don't check), but if you want to know:
http://www.wowhead.com/npc=27110#abilities
http://www.wowhead.com/npc=27108#abilities
http://www.wowhead.com/npc=27107#abilities
http://www.wowhead.com/npc=27106#abilities

They need to use these spells while they are on demolisher.

[Nevadas]

Thx, the npcs have only the Q script inside nothing other script things.
But my question was how is the mechanic to add this on a vehicle?

[nerv234]

I think change action 41(despawn) to 11 cast spell 46598(ride vehicle) With action invoker as a target. It should be right way.

[xlain]

@Nevadas Ohhh you fix work very well! Thanks you!! :D

[ghost]

Quest: The Plains of Nasam
Quest ID: 11652
Problem: Tanks do not spawn for quest.

[Aokromes]

So, this can be pushed? if it needs fixes from multiple posts, please post a single fix.

[dr-j]

Ok updating on this, updating on what Nevadas did,

• There are actually 6 tanks not 4, spawns are from sniff
• Horde Siege tank is meant to be faction 1981 not 1978 (From sniff)
• Abandoned Fuel tank is meant to be hostile, faction which was already set in clean tdb was correct, adjusted script to work with hostile npc rather than using faction 1978 which was incorrect
• Corrected walk/run speed of horde siege tank (from sniff)
• Conditions so vehicle is only usable in areas where it is intended to be used and only while on the quest
• Conditions for The Demoralizer so you dont end up killing yourself (tank survived with it) when used at close range
• Tried looking at Land Mine Barrier, using spell linking got it to drop the 8 mines surrounding the tank, there was a seperate spell for each mine ie front, front left, front right, right, left, back, back left and back right, linked these spells to the main spell and it does actually place the mines now rather than appearing to do nothing, mines just despawn when mobs walk over them though ie dont detonate, the go is type 6 (Trap) and the spell specified in data3 does appear to work but does not trigger for some reason, mine just despawns when mobs go over it.

-- QUEST The Plains of Nasam
SET @GUID := xxxxxx; -- set the guid for spawning 6 are required
DELETE FROM `creature` WHERE id =25334;

INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(@GUID, 25334, 571, 1, 1, 2792.044, 6738.573, 7.797749, 4.34587, 120, 0, 0), -- 25334 (Area: 4130)
(@GUID+1, 25334, 571, 1, 1, 2798.961, 6735.21, 7.625851, 4.276057, 120, 0, 0), -- 25334 (Area: 4130)
(@GUID+2, 25334, 571, 1, 1, 2784.335, 6742.207, 7.92973, 4.29351, 120, 0, 0), -- 25334 (Area: 4130)
(@GUID+3, 25334, 571, 1, 1, 2766.58, 6751.198, 7.29528, 4.258604, 120, 0, 0), -- 25334 (Area: 4130)
(@GUID+4, 25334, 571, 1, 1, 2777.034, 6745.713, 7.899116, 4.29351, 120, 0, 0), -- 25334 (Area: 4130)
(@GUID+5, 25334, 571, 1, 1, 2807.21, 6730.922, 7.841674, 4.433136, 120, 0, 0); -- 25334 (Area: 4130)

UPDATE `creature_template` SET `faction`=1981, `unit_flags`=4096, `dynamicflags`=0,`speed_walk`=1.2, `speed_run`=2 WHERE `entry`=25334;

DELETE FROM `spell_area` WHERE `spell`=47917 AND  `area` IN(4027,4130);
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES 
(47917, 4027, 11652, 11652, 0, 0, 2, 0, 64, 11),
(47917, 4130, 11652, 11652, 0, 0, 2, 0, 64, 11);

UPDATE `creature_template` SET `spell1`=50672, `spell2`=45750,`spell3`=50677, `spell4`=47849, `spell5`=47962, `Health_mod`=5, `Mana_mod`=5 WHERE `entry`=25334;
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=25334 AND `spell_id`=46598;
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`) VALUES (25334, 46598, 1);

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (27106, 27107, 27108, 27110);
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27106, 27107, 27108, 27110) AND `source_type`=0;
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 
(27106, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Warrior - On Spell hit - Cast Killcredit on Invoker'),
(27106, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Warrior - On Spell hit - Despawn after 1sec'),
(27107, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Mage - On Spell hit - Cast Killcredit on Invoker'),
(27107, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Mage - On Spell hit - Despawn after 1sec'),
(27108, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Shaman - On Spell hit - Cast Killcredit on Invoker'),
(27108, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Shaman - On Spell hit - Despawn after 1sec'),
(27110, 0, 0, 1, 8, 0, 100, 1, 47962, 0, 0, 0, 85, 47967, 1, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Ingenieur - On Spell hit - Cast Killcredit on Invoker'),
(27110, 0, 1, 0, 61, 0, 100, 1, 47962, 0, 0, 0, 41, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Injured Warsong Ingenieur - On Spell hit - Despawn after 1sec');

-- NPC Scourge Plague Spreader
UPDATE `creature_template` SET `faction`=974, `unit_flags`=`unit_flags`|2|33554432 WHERE `entry`=25349;
UPDATE `creature_template` SET `flags_extra`=`flags_extra`|64 WHERE `entry` IN (25333, 25469, 25332);
-- NPC Abandoned Fuel Tank 
UPDATE `creature_template` SET `faction`=2022, `unit_flags`=`unit_flags`|2|4|33554432, `AIName`='SmartAI' WHERE `entry`=27064;    
DELETE FROM `smart_scripts` WHERE `entryorguid`=27064 AND `source_type`=0;
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
(27064, 0, 0, 1, 9, 0, 100, 0, 0, 5, 30000, 35000, 85, 47916, 2, 0, 0, 0, 0, 11, 25334, 5, 0, 0, 0, 0, 0, 'Abandoned Fuel Tank - On Range 2yd - Cast Fuel'),
(27064, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 25334, 0, 0, 0, 0, 0, 0, 'Abandoned Fuel Tank - Linked with Previous Event - Say'),
(27064, 0, 2, 3, 11, 0, 100, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Abandoned Fuel Tank - On Respawn - Disable Auto Attack'),
(27064, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Abandoned Fuel Tank - On Respawn - Disable Combat Movement');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=27064 AND `SourceId`=0;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(22, 1, 27064, 0, 1, 29, 0, 25334, 5, 0, 0, 0, 0, '', 'Execute SAI only if there is Horde Siege Tank within 2 yards');


UPDATE `creature_template` SET `npcflag`=16777216 WHERE  `entry`=25334;

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=25334;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(16, 0, 25334, 0, 0, 23, 0, 4027, 0, 0, 0, 0, 0, '', 'Horde Siege Tank (Vehicle) Allowed in Coast of Echoes'),
(16, 0, 25334, 0, 1, 23, 0, 4130, 0, 0, 0, 0, 0, '', 'Horde Siege Tank (Vehicle) Allowed in Plains of Nasam');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup`=25334;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(18, 25334, 46598, 0, 0, 9, 0, 11652, 0, 0, 0, 0, 0, '', 'Player must have The Plains of Nasam taken but not completed to use Horde Siege tank');

DELETE FROM `creature_template_addon` WHERE `entry` IN(25334,27064);
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
(25334, 0, 0x0, 0x101, ''), -- 25334
(27064, 0, 0x0, 0x1, '50162'); -- 27064 - 50162

-- Updated 14-06-22 - Kinzcool
DELETE FROM `creature_text` WHERE `entry`=25334;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES 
(25334, 0, 0, '%s gains fuel.', 41, 0, 100, 0, 0, 0, 'Horde Siege Tank', 26171);

DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=45750;
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES 
(45750, 45749, 0, 'Land Mine Barrier'), -- Front
(45750, 45751, 0, 'Land Mine Barrier'), -- Front, Right
(45750, 45752, 0, 'Land Mine Barrier'), -- Front, Left
(45750, 45753, 0, 'Land Mine Barrier'), -- Back
(45750, 45754, 0, 'Land Mine Barrier'), -- Back, Left
(45750, 45755, 0, 'Land Mine Barrier'), -- Back, Right
(45750, 45756, 0, 'Land Mine Barrier'), -- Left
(45750, 47839, 0, 'Land Mine Barrier'); -- Right

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`IN(50674);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
(13, 1, 50674, 0, 0, 31, 0, 3, 0, 0, 0, 0, 0, '', 'The Demoralizer only hits unit'),
(13, 1, 50674, 0, 0, 31, 0, 3, 25334, 0, 1, 0, 0, '', 'The Demoralizer does not hit horde siege tank');

[Nevadas]

Great work @dr-j !! Thx!
Now for me works only the Demoralizer Spell not right!
He shoot(visual) to the left hills and the damage on the npcs are not right, i think.
The other spells works good.

[mihawk90]

Nice work!
Works pretty well, the only thing I noticed is that the tank isn't always being attacked by the Scourge when you only shoot at them at range with "The Demoralizer", they constantly reset. They only seem to aggro when you drive into Melee range.

The mines don't explode, but I guess this is a minor issue sinceit's still possible to kill those Mobs.

The Aiming with The Demoralizer is a little off but I think that's a general Vehicle Issue and has nothing to do with the quest.

[MadmanRook]

How do i go about applying this. can anyone tell me

[untaught]

@MadmanRook it's the same way as you import your database and sql updates.

[Rushor]

note that u must set any number for the XXXX for 'SET @Guid := XXXX;' If not u get errors :D

[untaught]

Any number but not duplicate and must have free 5 more in a row after it. For example you set it to 500, but 500,501,502,503,504,505 must be free.

[dr-j]

Will probably generate errors at the moment due to recent changes to creature_template ie merging of faction fields, I need to update d:

[Rushor]

There is just another problem:
After the respawn of the tanks(25334), player cannot jump in. The npcflag for the spellclick fades away after respawn. Can someone confirm that issue?

[dr-j]

yes confirm but thats a generic vehicle bug also effects other vehicles like shredders in grizzly hills,

hack fix is to add the spellclick flag to npc flags in creature_template

but the above issue is not specific to this vehicle.

also the flying machines for ive got a flying machine in howling fjord once used once wont let you mount again when they respawn,