0 Потребители и 2 Гости преглежда(т) тази тема.
DELETE FROM `creature` WHERE `id`=23872;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(NULL,23872,230,1,1,0,0,890.618,-130.363,-49.7448,5.17385,300,0,0,302400,0,0,0,0,0);DELETE FROM `gameobject` WHERE `id` IN (189989,189990);INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES(NULL,189990,1,1,1,1213.47,-4327.53,21.1917,1.9878,0,0,0.83816,0.545424,300,0,1),(NULL,189989,0,1,1,-5172.38,-580.041,397.471,1.16898,0,0,0.551776,0.833993,300,0,1);
UPDATE `quest_template` SET `LimitTime`=240,`PrevQuestId`=0 WHERE `id` IN (11294,11407,11408);UPDATE `creature_template` SET `ainame`='SmartAI' WHERE `entry` IN (24202,24203,24204,24205);DELETE FROM `smart_scripts` WHERE `entryorguid` IN (24202,24203,24204,24205) AND `source_type`=0;INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES(24202,0,0,0,10,0,100,0,1,20,200,200,11,43259,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit'),(24203,0,0,0,10,0,100,0,1,20,200,200,11,43260,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit'),(24204,0,0,0,10,0,100,0,1,20,200,200,11,43261,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit'),(24205,0,0,0,10,0,100,0,1,20,200,200,11,43262,0,0,0,0,0,7,0,0,0,0,0,0,0,'On Target In Range - Quest Credit');DELETE FROM `creature` WHERE `id` IN (24202,24203,24204,24205);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(NULL,24202,1,1,1,0,0,1650.9,-4413.9,16.8934,0.475121,300,0,0,42,0,0,0,0,0),(NULL,24202,0,1,1,0,0,-4910.58,-945.233,501.494,4.28465,300,0,0,42,0,0,0,0,0),(NULL,24203,1,1,1,0,0,1933.13,-4673.86,27.5538,5.49774,300,0,0,42,0,0,0,0,0),(NULL,24203,0,1,1,0,0,-4970.87,-1210.18,503.625,0.954555,300,0,0,42,0,0,0,0,0),(NULL,24204,1,1,1,0,0,1922.97,-4287.9,28.8533,2.99625,300,0,0,42,0,0,0,0,0),(NULL,24204,0,1,1,0,0,-4695.36,-1231.63,503.9,0.636425,300,0,0,42,0,0,0,0,0),(NULL,24205,1,1,1,0,0,1576.06,-4208.81,43.669,2.88944,300,0,0,42,0,0,0,0,0),(NULL,24205,0,1,1,0,0,-4662.75,-958.585,500.377,1.9473,300,0,0,42,0,0,0,0,0);
DELETE FROM `smart_scripts` WHERE `entryorguid`=24657 AND `source_type`=0 AND `id` IN (2,3);INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES(24657,0,2,3,62,0,100,0,9016,1,0,0,11,66592,0,0,0,0,0,7,0,0,0,0,0,0,0,'Glodrak Huntsniper - On gossip option select - cast spell'),(24657,0,3,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Glodrak Huntsniper - On gossip option select - close gossip');DELETE FROM `gossip_menu_option` WHERE `menu_id`=9016 AND `id`=1;INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES(9016,1,0,'I\'d like a pair of Synthebrew Goggles.',1,1,0,0,0,0,NULL);
INSERT INTO `creature_questender` (`id`, `quest`) VALUES(24657,11431); INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES(24657,11431);
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup`=23872;INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES(1,23872,38280,0,0,16,0,1101,0,0,0,0,0,'',NULL),(1,23872,38281,0,0,16,0,690,0,0,0,0,0,'',NULL);UPDATE `quest_template` SET `PrevQuestId`=0 WHERE `Id`=12491;
DELETE FROM `creature_loot_template` WHERE `entry`=23872 AND `item`=37829;INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES(23872,37829,100,1,0,2,2);
DELETE FROM `creature` WHERE `id`=27478;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(NULL,27478,0,1,1,22396,1,-4849.64,-862.325,501.916,4.79358,300,0,0,2215,0,0,0,0,0);