ChaosEMU/ChaosCore — Issue #126: [Quest/Fix] The Frost Wyrm and its Master
Author: Aestra
Created: 2012-01-25 16:03:12+00:00
State: open

[code]SET @CreGuid := XXXXX;
SET @GOGuid := XXXXXX;
DELETE FROM `creature` WHERE id IN (24029,24019);
INSERT INTO `creature` VALUES
(@CreGuid,24029,571,1,1,0,613,2816.98,-3607.67,246.053,3.77733,300,0.0,0,9291,3231,0,0,0,0);

DELETE FROM `gameobject` WHERE id='300161';
INSERT INTO `gameobject` VALUES
(@GOGuid,300161,571,1,1, '2805.15', '-3613.83', '247.795', '3.90142',0.0,0.0, '0.928696', '-0.370841',300,0,1),
(@GOGuid+1,300161,571,1,1, '2804.32', '-3601.11', '247.686', '0.68679',0.0,0.0, '0.336686', '0.941617',300,0,1),
(@GOGuid+2,300161,571,1,1, '2818.71', '-3619.43', '247.504', '1.72037',0.0,0.0, '0.757965', '0.652295',300,0,1),
(@GOGuid+3,300161,571,1,1, '2816.61', '-3607.82', '246.088', '0.583118',0.0,0.0, '0.287446', '0.957797',300,0,1);

DELETE FROM `conditions` WHERE SourceEntry='42817';
INSERT INTO `conditions` VALUES
('17', '0', '42817', '0', '9', '11267', '0', '0', '0', '', NULL);[/code]