Missing NPC Thread

[Anz69]

Met Siang Bang GM yang cakep,

mau lapor bang, sekalian belajar dikit-dikit,
Missing NPC di lokasi

1. Wyrmcaller Vile FIXED
Objective : The Frost Wyrm and Its Master

Info NPC :
id : 24029
map : 571 ( Northrend )
Coordinat map : Gjalerbron, Howling fjord, [36.6 , 7.4]
curhealth : 9,291
curmana : 3,231

Kode Alternatif SQL nya apakah seperti ini ? maklum lagi belajar dikit-dikit hehe blm ngerti position x,y,z, orientation dll

DELETE FROM `creature` WHERE `id` IN (24029);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `spawndist`, `curhealth`, 'curmana') VALUES 
(unknown , 24029, 571 , 1 , 1, unknown , unknown, unknown, 180 , 0 , 9291 , 3231)

2. Queen Angerboda Spawned but Friendly FIXED
Objective : The Slumbering King

Info NPC :
id : 24023
map : 571 ( Northrend)
Coordinat map : Winter's Terrace, Howling fjord, [41.0 , 6.3]
curhealth : 9,291
curmana : 3,231

DELETE FROM `creature` WHERE `id` IN (24023);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `spawntimesecs`, `spawndist`, `curhealth`, 'curmana') VALUES 
(unknown , 24023, 571 , 1 , 1, unknown , unknown, unknown, 150 , 0 , 9291 , 3231)

Trims very much

[Anz69]

Makasih bang di spawnin, tapi default corenya mungkin friendly ternyata TT

Queen Angerboda Spawned but Friendly FIXED

Error : Friendly Status
Fix : harusnya Hostile

Objective : The Slumbering King

UPDATE `creature_template` SET `faction_A`=14, `faction_H`=14, `mechanic_immune_mask` = 1 WHERE `entry` = 24023;

Demikian Bang GM
Trimsss