Open Echinaceax opened 3 years ago
DELETE FROM creature_addon
WHERE guid
= 65572;
DELETE FROM creature
WHERE guid
= 65572;
INSERT INTO creature
(guid
, id
, spawnMask
, PhaseId
, PhaseGroup
, terrainSwapMap
, phaseUseFlags
, phaseMask
, position_x
, position_y
, position_z
, orientation
, spawntimesecs
, wander_distance
, MovementType
, ScriptName
, VerifiedBuild
, map
, zoneId
, areaId
, modelid
, equipment_id
, currentwaypoint
, curhealth
, curmana
, npcflag
, unit_flags
, dynamicflags
) VALUES
(65572, 18281, 1, 169, 0, -1, 0, 1, -566.173, 5350.9, 17.5357, 2.69483, 300, 0, 2, '', 0, 530, 3521, 3521, 0, 0, 0, 15474, 0, 0, 0, 0);
INSERT INTO creature_addon
(guid
, waypointPathId
, cyclicSplinePathId
, mount
, StandState
, AnimTier
, VisFlags
, SheathState
, PvPFlags
, emote
, visibilityDistanceType
, auras
, aiAnimKit
, meleeAnimKit
, movementAnimKit
) VALUES
(65572, 655720, 0, 0, 0, 0, 0, 1, 0, 0, 0, NULL, 0, 0, 0);
DELETE FROM waypoint_data
WHERE id
= 655720;
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,1,-599.054,5366.65,17.501,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,2,-614.275,5357.16,17.6243,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,3,-625.116,5342.09,17.4993,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,4,-644.018,5331.33,18.5012,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,5,-677.398,5321.68,17.6211,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,6,-685.358,5303.08,17.6211,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,7,-697.722,5260.44,17.8797,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,8,-685.358,5303.08,17.6211,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,9,-677.398,5321.68,17.6211,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,10,-644.018,5331.33,18.5012,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,11,-625.116,5342.09,17.4993,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,12,-614.275,5357.16,17.6243,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,13,-599.054,5366.65,17.501,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,14,-566.173,5350.9,17.5357,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,15,-544.966,5344.5,17.7857,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,16,-527.839,5356.74,18.125,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,17,-511.706,5366.04,18,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,18,-490.089,5365.22,17.8798,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,19,-511.706,5366.04,18,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,20,-527.839,5356.74,18.125,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,21,-544.966,5344.5,17.7857,NULL,0,0,0,0,0,100,0);
INSERT INTO waypoint_data
(id
,point
,position_x
,position_y
,position_z
,orientation
,velocity
,delay
,smoothTransition
,move_type
,action
,action_chance
,wpguid
) VALUES (655720,22,-566.173,5350.9,17.5357,NULL,0,0,0,0,0,100,0);
Links:
npc https://cata-twinhead.twinstar.cz/?npc=18281 quest https://cata-twinhead.twinstar.cz/?quest=9895
What is happening:
What should happen: Locate and deal with Boglash, then return to Lethyn Moonfire at Cenarion Refuge.
Reported by player, confirmed by GM