[DB][Fix] Quest 12158: Hollowstone Mine

[tharaca-duplicate]

What steps will reproduce the problem?

1. Obtain the quest 'Hollowstone Mine' (http://www.wowhead.com/quest=12158)

What is supposed to happen? What do you see instead?
NPC 'Petrov' (http://www.wowhead.com/npc=26932) should be spawned near 53,20. Unfortunately the NPC isn't spawned and thus making this quest non completable.

Spawn Petrov with the following:
-- Spawn npc Petrov
DELETE FROM creature WHERE id = 26932
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,DeathState,MovementType) VALUES
(NULL, 26932, 571, 1, 1, 0, 0, 4697.33, -4004.72, 212.393, 3.78881, 300, 0, 0, 8326, 0, 0, 0)

TDB: 335.11.40 Win32

[tharaca]

Source: http://www.youtube.com/watch?v=W6ycghuedpk

[Svannon]

From Sniff

-- Spawn Petrov
SET @GUID=xxxxxx;
DELETE FROM `creature` WHERE `id`=26932;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`)  VALUES
(@GUID+0,26932,571,1,1,0,0,4698.392,-4004.781,212.3551,0.5061455,300,0,0,1,0,0,0,0,0);

-- Template updates for creature 26932 (Petrov)
UPDATE `creature_template` SET `baseattacktime`=1500,`unit_flags`=`unit_flags`|512 WHERE `entry`=26932; -- Petrov
-- Addon data for creature 26932 (Petrov)
DELETE FROM `creature_template_addon` WHERE `entry`=26932;
INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(26932,0,0,257,333, NULL); -- Petrov

[TheMaaster]

Confirmed, Petrov NOT found at mine.

Version: 3.3.5a (12340)
Core revision: Trinity Core 0b44649+