[other] V13.1 - Added missing spirit healers and corrected some chest drops

[TreeOfLife]

#Adds missing spirit healer in Loch Modan.
INSERT INTO
  emucoach_v131_vip_world.creature (id,`map`,`zone`,area,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags,walkmode,saiscriptflag)
  VALUES (987655,0,4922,5473,1,1,0,0,-4685.93,-4184.67,338.093,3.27938,120,0.0,0,585232,0,0,0,0,0,0.0,0.0);

#Adds missing spirit healer in Duskhaven.
INSERT INTO
  emucoach_v131_vip_world.creature (id,`map`,`zone`,area,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags,walkmode,saiscriptflag)
  VALUES (6491,654,4714,4786,1,65535,0,0,-1887.8,2320.82,39.6016,2.51171,300,0.0,0,4120,0,0,0,0,0,0.0,0.0);

#Replaces a chest in darkshore that drops +70 gear in favour of something more level appropriate.
REPLACE INTO emucoach_v131_vip_world.gameobject (guid, id,`map`,`zone`,area,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
      (289350,2849,1,148,455,1,65535,4672.0,82.099,65.3559,3.91503,0.0,0.0,0.926151,-0.377154,1200,0,1);

#Replaces a chest in Stonetalon Mountain that drops +70 gear in favour of something more level appropriate.
REPLACE INTO emucoach_v131_vip_world.gameobject (guid, id,`map`,`zone`,area,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
    (12010,2850,1,406,469,1,1,19.8646,-683.983,-17.2363,1.78023,0.0,0.0,0.0,1.0,3600,255,1);

#Replaces a chest in Stonetalon Mountain that drops +70 gear in favour of something more level appropriate.
REPLACE INTO emucoach_v131_vip_world.gameobject (guid, id,`map`,`zone`,area,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
    (12095,2850,1,406,4932,1,1,588.252,-156.646,22.1494,4.10152,0.0,0.0,0.0,1.0,3600,255,1);

 

[remamakiller]

A number is missing in the first line emucoach_v13_vip_world.creature


INSERTAR EN
emucoach_v131_vip_world.creature (id, `map`,` zone`, area, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientación, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflags, dynamicflags, unit_ walkmode, saiscriptflag)
VALORES (987655,0,4922,5473,1,1,0,0, -4685.93, -4184.67,338.093,3.27938,120,0.0,0,585232,0,0,0,0,0,0.0,0.0) ;

 

[TreeOfLife]

Thanks for the heads up! I edited the post.

 

[Blackvision]

#Adds missing spirit healer in Loch Modan.
INSERT INTO
  emucoach_v131_vip_world.creature (id,`map`,`zone`,area,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags,walkmode,saiscriptflag)
  VALUES (987655,0,4922,5473,1,1,0,0,-4685.93,-4184.67,338.093,3.27938,120,0.0,0,585232,0,0,0,0,0,0.0,0.0);

#Adds missing spirit healer in Duskhaven.
INSERT INTO
  emucoach_v131_vip_world.creature (id,`map`,`zone`,area,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType,npcflag,unit_flags,dynamicflags,walkmode,saiscriptflag)
  VALUES (6491,654,4714,4786,1,65535,0,0,-1887.8,2320.82,39.6016,2.51171,300,0.0,0,4120,0,0,0,0,0,0.0,0.0);

#Replaces a chest in darkshore that drops +70 gear in favour of something more level appropriate.
REPLACE INTO emucoach_v131_vip_world.gameobject (guid, id,`map`,`zone`,area,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
      (289350,2849,1,148,455,1,65535,4672.0,82.099,65.3559,3.91503,0.0,0.0,0.926151,-0.377154,1200,0,1);

#Replaces a chest in Stonetalon Mountain that drops +70 gear in favour of something more level appropriate.
REPLACE INTO emucoach_v131_vip_world.gameobject (guid, id,`map`,`zone`,area,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
    (12010,2850,1,406,469,1,1,19.8646,-683.983,-17.2363,1.78023,0.0,0.0,0.0,1.0,3600,255,1);

#Replaces a chest in Stonetalon Mountain that drops +70 gear in favour of something more level appropriate.
REPLACE INTO emucoach_v131_vip_world.gameobject (guid, id,`map`,`zone`,area,spawnMask,phaseMask,position_x,position_y,position_z,orientation,rotation0,rotation1,rotation2,rotation3,spawntimesecs,animprogress,state) VALUES
    (12095,2850,1,406,4932,1,1,588.252,-156.646,22.1494,4.10152,0.0,0.0,0.0,1.0,3600,255,1);

Thanks mate
keep it up

 

[ExO]

Executed, thank you!

 

[Jenniy]

Third comment on your posts for the acknowledgement - Thank you so much!