[Wip] The Last Line Of Defense

So this is continuation on the http://www.trinityco…ng/page__st__20, you need to apply the stuff I listed on the 2nd page to able to get to this quest. This quest requires tons of work, can say it is around 70% complete, but keeping only this code for now, untill someone help up with the cannons. Here is the issue with the cannons:… /check under the first sql/. I can make it shoot, but the problem is a bit more complicated, basicly there are 2 effects on the main spell:

[SPOILER]ID - 57385 Argent Cannon

=================================================

Description: Fire into enemy Scourge and watch them burn.

Category = 0, SpellIconID = 2668, activeIconID = 0, SpellVisual = (12418,0)

Family SPELLFAMILY_GENERIC, flag 0x00000000 00000000 00000000

SpellSchoolMask = 4 (SPELL_SCHOOL_MASK_FIRE)

DamageClass = 1 (SPELL_DAMAGE_CLASS_MAGIC)

PreventionType = 1 (SPELL_PREVENTION_TYPE_SILENCE)

=================================================

Attributes: 0x20410000 (SPELL_ATTR0_NOT_SHAPESHIFT, SPELL_ATTR0_CAST_TRACK_TARGET, SPELL_ATTR0_UNAFFECTED_BY_INVULNERABILITY)

AttributesEx1: 0x00000400 (SPELL_ATTR1_NO_THREAT)

AttributesEx3: 0x00040000 (SPELL_ATTR3_IGNORE_HIT_RESULT)

=================================================

Targets Mask = 0x00000040 (TARGET_FLAG_DEST_LOCATION)

Spell Level = 0, base 0, max 0, maxTarget 0

Category = 0

DispelType = 0 (DISPEL_NONE)

Mechanic = 0 (MECHANIC_NONE)

SpellRange: (Id 37) “Extended Range”:

MinRange = 0, MinRangeFriendly = 0

MaxRange = 50, MaxRangeFriendly = 50

CastingTime (Id 1) = 0,00

RecoveryTime: 1000 ms, CategoryRecoveryTime: 0 ms

StartRecoveryCategory = 133, StartRecoveryTime = 0,00 ms

Interrupt Flags: 0x00000000, AuraIF 0x00000000, ChannelIF 0x00000000

Chance = 101, charges - 0

=================================================

Effect 0: Id 3 (SPELL_EFFECT_DUMMY)

BasePoints = 57387

Targets (89, 0) (TARGET_DEST_TRAJ, NO_TARGET)

Effect 1: Id 3 (SPELL_EFFECT_DUMMY)

BasePoints = 150

Targets (24, 0) (TARGET_UNIT_CONE_ENEMY_24, NO_TARGET)

Radius (Id 41) 150,00

Effect 2: NO EFFECT

[/SPOILER]
If want in short the problem is that can’t make the cannon do smth except aggroing unwanted mobs when it shoots or the other one is how to limit a radius cone of spell effect /without editing spell.dbc/.

So as you can see there are 2 dummy effects that require scripts. I managed to achieve 2 things /1 one of them makes it blizzlike, but in a way to overpowered way/. I used spell_script, the:

[CODE]DELETE FROM spell_scripts WHERE id=57385;
INSERT INTO spell_scripts (id, effindex, command,datalong,datalong2,dataint) VALUES
(57385,1,15,57542,0,0);[/sql]
Imo spell_link is not usable here or alteast I couldn’t find any effective use.

Or 57383 as the triggered spell on the specific effect. There are slight differences in the end animation, one of them

makes black smoking spot the other doesn’t, but in the end, both shoot and kill, the problem is that they follow up the

effect radius, which is 1500, so they kill half of the visible slayers, so the problem is how to make that specific effect to

trigger the spell on lower range TARGET_DEST_TRAJ, NO_TARGET, in other words specific 18-20 area. I know I can’t influence on the radius of the effect, except from spell.dbc, but then I’m also sure this effect is bugged, because it aggro

all mobs if left unused and in blizzlike they don’t get aggroed. There is an attribute to get no aggro, tried to use it, but

again slayers get aggroed. I tried all possible scenarious from spell_scripts and only effect 1 makes a change, when is

on datalong 2 with value 0. All rest cases and in normal untouched state the spell doesn’t do anything, appart aggroing

tons of mobs in 1500 cone radius. Note that when this spell is casted from char it don’t work fine again, but the triggered

one achieve exactly the effect we want, so I tried to spell link them, but still it shoot up all in a cone. Any ideas how to

limit this cone. As we can see it triggers normaly a spell on dummy effect 1, that triggers the one I’m using, but nothing happens. I also tried to make spell link chain reaction, but that damned cone effect makes spells hit all in 150 radius…

for the the spiders and drakes the battle requires a lot of work, but it is similar to the real quest, except some units

abuse the Z heigh sometimes and I need to script the crusaders, but that is easy. Another problem is that there is an

npc/object under the turret, which I can’t find on wowhead. It can be sniffed. It isn’t invisible platform, but real thing.

P.S.: Am a bit tired from triying to make this work, so can’t write good explanation, sorry for that.

Here is what I’ve done yesterday:

[spoiler]

[sql]-- Guid for inserts
SET @NEXT := 300000;
SET @PATH := @NEXT * 10;
– Forgotten Depths Slayer SAI ID: 30593
UPDATE creature_template SET speed_walk=5,movementtype=1,faction_A=2068, faction_H=2068,AIName= ‘SmartAI’ WHERE entry= 30593;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30593;
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
(30593,0,1,0,0,0,100,0,1000,5000,2500,6500,11,54185,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Combat - Claw Slash’);
– Adds 44 Forgotten Depths Slayers for phase 64 Id: 30593 /quest The Last line of Defense/
DELETE FROM creature WHERE id=30593;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+129, 30593, 571, 1, 64, 6442.551758, 222.894867, 397.353943, 2.7317, 5, 60, 0, 1),
(@NEXT+130, 30593, 571, 1, 64, 6437.940430, 215.351151, 397.798889, 0.929563, 5, 60, 0, 1),
(@NEXT+131, 30593, 571, 1, 64, 6419.338379, 239.908859, 396.095978, 2.1122, 5, 60, 0, 1),
(@NEXT+132, 30593, 571, 1, 64, 6428.831055, 239.908859, 396.763702, 3.5549, 5, 60, 0, 1),
(@NEXT+133, 30593, 571, 1, 64, 6400.702148, 236.755035, 395.685333, 1.32629, 5, 60, 0, 1),
(@NEXT+134, 30593, 571, 1, 64, 6410.955078, 249.759094, 396.454742, 2.77181, 5, 60, 0, 1),
(@NEXT+135, 30593, 571, 1, 64, 6367.340820, 183.807068, 391.614655, 0.501217, 5, 60, 0, 1),
(@NEXT+136, 30593, 571, 1, 64, 6382.062500, 176.836975, 393.132507, 1.22528, 5, 60, 0, 1),
(@NEXT+137, 30593, 571, 1, 64, 6357.964355, 158.979782, 391.124756, 2.99677, 5, 60, 0, 1),
(@NEXT+138, 30593, 571, 1, 64, 6373.327537, 146.681412, 392.788330, 3.35221, 5, 60, 0, 1),
(@NEXT+139, 30593, 571, 1, 64, 6343.335938, 173.300323, 389.862518, 4.18409, 5, 60, 0, 1),
(@NEXT+140, 30593, 571, 1, 64, 6335.788086, 148.828232, 389.702972, 3.19711, 5, 60, 0, 1),
(@NEXT+141, 30593, 571, 1, 64, 6347.954590, 129.882919, 3391.126984, 2.81552, 5, 60, 0, 1),
(@NEXT+142, 30593, 571, 1, 64, 6333.287109, 88.245689, 391.002228, 5.84132, 5, 60, 0, 1),
(@NEXT+143, 30593, 571, 1, 64, 6336.879395, 71.525627, 390.192871, 0.785398, 5, 60, 0, 1),
(@NEXT+144, 30593, 571, 1, 64, 6318.244629, 32.249405, 391.493988, 2.1325, 5, 60, 0, 1),
(@NEXT+145, 30593, 571, 1, 64, 6312.728320, 8.393217, 392.626587, 0.291176, 5, 60, 0, 1),
(@NEXT+146, 30593, 571, 1, 64, 6326.704590, 107.359123, 391.002045, 0.919091, 5, 60, 0, 1),
(@NEXT+147, 30593, 571, 1, 64, 6301.972656, 119.744209, 389.925903, 1.55615, 5, 60, 0, 1),
(@NEXT+148, 30593, 571, 1, 64, 6266.120117, 148.388809, 383.515961, 1.84373, 5, 60, 0, 1),
(@NEXT+149, 30593, 571, 1, 64, 6251.726074, 153.168182, 381.629669, 1.80125, 5, 60, 0, 1),
(@NEXT+150, 30593, 571, 1, 64, 6229.003418, 145.614822, 379.721741, 5.84095, 5, 60, 0, 1),
(@NEXT+151, 30593, 571, 1, 64, 6284.683082, 214.294250, 388.699188, 2.78648, 5, 60, 0, 1),
(@NEXT+152, 30593, 571, 1, 64, 6302.265625, 212.301346, 390.488556, 3.48219, 5, 60, 0, 1),
(@NEXT+153, 30593, 571, 1, 64, 6299.725098, 226.082626, 391.288788, 5.13205, 5, 60, 0, 1),
(@NEXT+154, 30593, 571, 1, 64, 6200.917969, 220.434753, 383.776184, 2.88047, 5, 60, 0, 1),
(@NEXT+155, 30593, 571, 1, 64, 6200.930664, 234.127823, 384.630798, 1.50529, 5, 60, 0, 1),
(@NEXT+156, 30593, 571, 1, 64, 6190.595703, 225.242371, 382.554016, 4.4761, 5, 60, 0, 1),
(@NEXT+157, 30593, 571, 1, 64, 6189.209961, 210.502823, 381.877960, 2.11574, 5, 60, 0, 1),
(@NEXT+158, 30593, 571, 1, 64, 6176.683594, 213.375336, 380.395172, 0.763302, 5, 60, 0, 1),
(@NEXT+159, 30593, 571, 1, 64, 6113.089844, 156.401672, 369.398804, 5.60417, 5, 60, 0, 1),
(@NEXT+160, 30593, 571, 1, 64, 6103.571289, 140.684174, 367.524414, 0.430917, 5, 60, 0, 1),
(@NEXT+161, 30593, 571, 1, 64, 6093.838867, 143.838867, 367.781097, 6.10437, 5, 60, 0, 1),
(@NEXT+162, 30593, 571, 1, 64, 6090.764160, 141.764160, 365.786255, 5.91518, 5, 60, 0, 1),
(@NEXT+163, 30593, 571, 1, 64, 6079.681641, 141.840958, 366.456573, 5.91108, 5, 60, 0, 1),
(@NEXT+164, 30593, 571, 1, 64, 6062.076660, 155.683197, 363.868896, 2.05191, 5, 60, 0, 1),
(@NEXT+165, 30593, 571, 1, 64, 6076.666016, 163.742477, 362.454651, 3.57468, 5, 60, 0, 1),
(@NEXT+166, 30593, 571, 1, 64, 6088.131348, 179.086304, 360.483307, 5.6035, 5, 60, 0, 1),
(@NEXT+167, 30593, 571, 1, 64, 6098.503418, 176.307312, 364.942688, 5.6035, 5, 60, 0, 1),
(@NEXT+168, 30593, 571, 1, 64, 6090.764160, 155.876968, 365.786255, 5.6035, 5, 60, 0, 1),
(@NEXT+169, 30593, 571, 1, 64, 6338.830566, 70.974663, 390.432343, 5.6035, 5, 60, 0, 1),
(@NEXT+170, 30593, 571, 1, 64, 6339.270508, 63.711479, 389.662994, 5.6035, 5, 60, 0, 1),
(@NEXT+171, 30593, 571, 1, 64, 6282.305176, 128.449188, 386.556244, 5.6035, 5, 60, 0, 1),
(@NEXT+172, 30593, 571, 1, 64, 6267.317383, 130.918854, 384.601959, 5.6035, 5, 60, 0, 1),
(@NEXT+173, 30593, 571, 1, 64, 6182.309082, 94.777863, 377.689959, 5.6035, 5, 60, 0, 1),
(@NEXT+174, 30593, 571, 1, 64, 6157.960383, 89.072354, 371.833959, 5.6035, 5, 60, 0, 1),
(@NEXT+175, 30593, 571, 1, 64, 6236.617383, 113.980854, 380.351959, 5.6035, 5, 60, 0, 1),
(@NEXT+176, 30593, 571, 1, 64, 6295.647383, 137.418854, 387.451959, 5.6035, 5, 60, 0, 1);

– Frostbrood Destroyers
UPDATE creature_template SET maxlevel=80,minlevel=80,exp=2,InhabitType=5,speed_walk=3,mindmg = 1170,dmg_multiplier = 2,attackpower = 342,maxdmg = 3470,movementtype=1,faction_A=2068, faction_H=2068,AIName= ‘SmartAI’ WHERE entry= 30575;
DELETE FROM creature WHERE id=30575;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, MovementType) VALUES
(@NEXT+177, 30575,571,1,64,6097.870117, 58.331299, 370.506012, 0.138359, 75,20,1),
(@NEXT+178, 30575,571,1,64,6243.700195, 183.362000, 382.515015, 4.594332, 75,20,1),
(@NEXT+179, 30575,571,1,64,6313.589844, 154.557999, 387.022003, 4.739780, 75,20,1),
(@NEXT+180, 30575,571,1,64,6331.450195, 53.939301, 389.138000, 2.973792, 75,20,1),
(@NEXT+181, 30575,571,1,64,6187.290039, 131.792999, 376.451996, 3.173792, 75,20,1);
– Pathing
– Slayers reinforcements left on main path
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+129;
DELETE FROM creature_addon WHERE guid=@NEXT+129;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+129,@PATH+129,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+129;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+129,1,6442.551758, 222.894867, 397.353943,0,2,0,100,0),
(@PATH+129,2,6337.383789,113.591568,391.210876,6000,2,0,100,0),
(@PATH+129,3,6299.144531,126.174286,391.081909,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+130;
DELETE FROM creature_addon WHERE guid=@NEXT+130;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+130,@PATH+130,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+130;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+130,1,6437.940430,215.351151,397.798889,0,2,0,100,0),
(@PATH+130,2,6327.383789,143.591568,391.210876,6000,2,0,100,0),
(@PATH+130,3,6296.544531,76.174286,391.081909,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+131;
DELETE FROM creature_addon WHERE guid=@NEXT+131;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+131,@PATH+131,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+131;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+131,1,6419.338379,239.908859,396.095978,0,2,0,100,0),
(@PATH+131,2,6317.383789,115.591568,391.210876,6000,2,0,100,0),
(@PATH+131,3,6294.144531,126.174286,391.081909,6000,2,0,100,0);

– Slayers reinforcements right on main path
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+132;
DELETE FROM creature_addon WHERE guid=@NEXT+132;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+132,@PATH+132,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+132;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+132,1, 6428.831055, 239.908859, 396.763702,0,2,0,100,0),
(@PATH+132,2,6346.144531,126.174286,391.081909,6000,2,0,100,0),
(@PATH+132,3,6297.353789,80.591568,391.210876,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+133;
DELETE FROM creature_addon WHERE guid=@NEXT+133;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+133,@PATH+133,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+133;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+133,1, 6400.702148, 236.755035, 395.685333,0,2,0,100,0),
(@PATH+133,2,6356.144531,106.174286,391.081909,6000,2,0,100,0),
(@PATH+133,3,6398.383789,70.591568,391.210876,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+134;
DELETE FROM creature_addon WHERE guid=@NEXT+134;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+134,@PATH+134,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+134;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+134,1, 6410.955078, 249.759094, 396.454742,0,2,0,100,0),
(@PATH+134,2,6376.144531,116.174286,391.081909,6000,2,0,100,0),
(@PATH+134,3,6295.383789,65.591568,391.210876,6000,2,0,100,0);

– Slayers reinforcements on the rear
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+159;
DELETE FROM creature_addon WHERE guid=@NEXT+159;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+159,@PATH+135,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+135;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+135,1, 6113.089844, 156.401672, 369.398804,0,2,0,100,0),
(@PATH+135,2,6175.009766,125.577263,369.434753,6000,2,0,100,0),
(@PATH+135,3,6109.930176,49.710854,369.404419,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+160;
DELETE FROM creature_addon WHERE guid=@NEXT+160;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+160,@PATH+136,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+136;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+136,1, 6103.571289, 140.684174, 368.524414,0,2,0,100,0),
(@PATH+136,2,6165.009766,119.577263,369.434753,6000,2,0,100,0),
(@PATH+136,3,6118.930176,64.710854,369.404419,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+161;
DELETE FROM creature_addon WHERE guid=@NEXT+161;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+161,@PATH+137,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+137;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+137,1, 6093.838867, 143.838867, 368.781097,0,2,0,100,0),
(@PATH+137,2,6171.009766,114.577263,369.434753,6000,2,0,100,0),
(@PATH+137,3,6114.930176,61.710854,369.404419,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+162;
DELETE FROM creature_addon WHERE guid=@NEXT+162;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+162,@PATH+138,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+138;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+138,1, 6090.764160, 141.764160, 369.786255,0,2,0,100,0),
(@PATH+138,2,6183.009766,109.577263,369.434753,6000,2,0,100,0),
(@PATH+138,3,6109.930176,57.710854,369.404419,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+163;
DELETE FROM creature_addon WHERE guid=@NEXT+163;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+163,@PATH+139,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+139;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+139,1, 6079.681641, 141.840958, 369.456573,0,2,0,100,0),
(@PATH+139,2,6180.009766,121.577263,369.434753,6000,2,0,100,0),
(@PATH+139,3,6124.930176,70.710854,369.404419,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+164;
DELETE FROM creature_addon WHERE guid=@NEXT+164;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+164,@PATH+140,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+140;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+140,1, 6062.076660, 155.683197, 369.868896,0,2,0,100,0),
(@PATH+140,2,6114.930176,74.710854,368.404419,6000,2,0,100,0),
(@PATH+140,3,6187.009766,111.577263,369.434753,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+165;
DELETE FROM creature_addon WHERE guid=@NEXT+165;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+165,@PATH+141,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+141;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+141,1, 6076.666016, 163.742477, 369.454651,0,2,0,100,0),
(@PATH+141,2,6117.930176,55.710854,369.404419,6000,2,0,100,0),
(@PATH+141,3,6178.009766,112.577263,369.434753,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+166;
DELETE FROM creature_addon WHERE guid=@NEXT+166;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+166,@PATH+142,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+142;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+142,1, 6088.131348, 179.086304, 372.483307,0,2,0,100,0),
(@PATH+142,2,6115.930176,73.710854,369.404419,6000,2,0,100,0),
(@PATH+142,3,6185.009766,119.577263,369.434753,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+167;
DELETE FROM creature_addon WHERE guid=@NEXT+167;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+167,@PATH+143,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+143;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+143,1, 6098.503418, 176.307312, 369.942688,0,2,0,100,0),
(@PATH+143,2,6115.930176,51.710854,369.404419,6000,2,0,100,0),
(@PATH+143,3,6185.009766,110.577263,369.434753,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+168;
DELETE FROM creature_addon WHERE guid=@NEXT+168;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+168,@PATH+144,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+144;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+144,1, 6090.764160, 155.876968, 368.786255,0,2,0,100,0),
(@PATH+144,2,6112.930176,61.710854,369.404419,6000,2,0,100,0),
(@PATH+144,3,6176.009766,114.577263,370.434753,6000,2,0,100,0);

– Slayers from West to both parts
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+154;
DELETE FROM creature_addon WHERE guid=@NEXT+154;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+154,@PATH+145,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+145;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+146,1, 6200.917969, 220.434753, 372.776184,0,2,0,100,0),
(@PATH+146,2,6346.144531,126.174286,372.081909,6000,2,0,100,0),
(@PATH+146,3,6287.383789,80.591568,372.210876,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+155;
DELETE FROM creature_addon WHERE guid=@NEXT+155;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+155,@PATH+146,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+146;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+147,1, 6200.917969, 220.434753, 372.776184,0,2,0,100,0),
(@PATH+147,2,6356.144531,106.174286,372.081909,6000,2,0,100,0),
(@PATH+147,3,6395.383789,70.591568,372.210876,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+156;
DELETE FROM creature_addon WHERE guid=@NEXT+156;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+156,@PATH+147,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+147;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+147,1, 6190.595703, 225.242371, 372.554016,0,2,0,100,0),
(@PATH+147,2,6175.009766,125.577263,372.434753,6000,2,0,100,0),
(@PATH+147,3,6104.930176,59.710854,372.404419,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+157;
DELETE FROM creature_addon WHERE guid=@NEXT+157;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+157,@PATH+148,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+148;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+148,1, 6189.209961, 210.502823, 372.877960,0,2,0,100,0),
(@PATH+148,2,6171.009766,119.577263,372.434753,6000,2,0,100,0),
(@PATH+148,3,6118.930176,64.710854,372.404419,6000,2,0,100,0);
UPDATE creature SET spawndist=0,MovementType=2 WHERE guid=@NEXT+158;
DELETE FROM creature_addon WHERE guid=@NEXT+158;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NEXT+158,@PATH+149,1,0, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH+137;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH+149,1, 6176.683594, 213.375336, 372.395172,0,2,0,100,0),
(@PATH+149,2,6173.009766,117.577263,372.434753,6000,2,0,100,0),
(@PATH+149,3,6118.930176,63.710854,372.404419,6000,2,0,100,0);
– Turrets
UPDATE creature_template SET faction_A=2231,faction_H=2231,unit_flags=16777220,npcflag=16777216,vehicleid=292 WHERE entry=30236;
DELETE FROM npc_spellclick_spells WHERE npc_entry=30236;
INSERT INTO npc_spellclick_spells (npc_entry, spell_id, quest_start, quest_start_active, quest_end, cast_flags, aura_required, aura_forbidden, user_type) VALUES
(30236, 57573, 0, 0, 0, 1, 0, 0, 0);
– Links the spells /this is dev state, keeping it up to discuss, since is the source of problems for now/
– DELETE FROM spell_linked_spell WHERE spell_trigger=57385;
– INSERT INTO spell_linked_spell (spell_trigger,spell_effect,type,comment) VALUES
– (57385,57387,1,‘Required blizzlike spell’);
– DELETE FROM spell_linked_spell WHERE spell_trigger=57387;
– INSERT INTO spell_linked_spell (spell_trigger,spell_effect,type,comment) VALUES
– 57387,57542,1,‘Required blizzlike spell’);
– DELETE FROM spell_scripts WHERE id=57385;
– INSERT INTO spell_scripts (id, effindex, command,datalong,datalong2,dataint) VALUES
– (57385,1,15,57542,0,0);
[/CODE]

Dont use spell_scripts table, it is to be deprecated and removed soon™

I’d suggest to use spell_scripts as long as SmartSpellAI isn’t implemented. If it’ll be one day the existing scripts can be ported like creature_ai_scripts…

For the objects below the cannons I can do a sniff tomorrow if u like. Just let me know…

Will, appreciate it a lot. WIll be able to put the cannons.

Am sorta busy right now. I’ll do the sniff as soon as possibly (probably after weekend).

Ok I did the sniff. There are several objects that might be these barrels:

192657,192658,192767,192768,192769,192770,192771,192772

They all have the same model, type and no name…

Yeah, thanks, they are all needed it seems. Adjusting them turned out to be quite a bother, it is 1 big + 2x small and most likely the big ones are stucked in the ground a bit.

If you need further data from sniff just let me know.

https://github.com/TrinityCore/TrinityCore/commit/704a563fcde577efd01363b1286b2502b31d3706

Anyone care to check the targeting issues with the cannon spells?

Hello. I’ve made 2 scripts for the cannon spells, they function - but they might be a bit incorrect.

Here they are:

class spell_argent_cannon : public SpellScriptLoader
{
public:
spell_argent_cannon() : SpellScriptLoader(“spell_argent_cannon”) { }
class spell_argent_cannon_SpellScript : public SpellScript
{
PrepareSpellScript(spell_argent_cannon_SpellScript);
void HandleCast()
{
// Mana regeneration code here
GetCaster()->CastSpell(GetTargetDest()->GetPositionX(), GetTargetDest()->GetPositionY(), GetTargetDest()->GetPositionZ(), GetSpellInfo()->Effects[EFFECT_0].BasePoints + 1, true);
}
void Register()
{
OnCast += SpellCastFn(spell_argent_cannon_SpellScript::HandleCast);
}
};
SpellScript* GetSpellScript() const
{
return new spell_argent_cannon_SpellScript();
}
};
class spell_reckoning_bomb : public SpellScriptLoader
{
public:
spell_reckoning_bomb() : SpellScriptLoader(“spell_reckoning_bomb”) { }
class spell_reckoning_bomb_SpellScript : public SpellScript
{
PrepareSpellScript(spell_reckoning_bomb_SpellScript);
void HandleCast()
{
GetCaster()->CastSpell(GetTargetDest()->GetPositionX(), GetTargetDest()->GetPositionY(), GetTargetDest()->GetPositionZ(), GetSpellInfo()->Effects[EFFECT_0].BasePoints + 1, true);
}
void Register()
{
OnCast += SpellCastFn(spell_reckoning_bomb_SpellScript::HandleCast);
}
};
SpellScript* GetSpellScript() const
{
return new spell_reckoning_bomb_SpellScript();
}
};

I also done the basic C++ (Sorry, I bloody love C++) scripts for Tirion yelling around. If that’s useful, I can also paste it here ;p

Cheers.