WoW-Info — информационный World of Warcraft портал

DELETE FROM `creature_ai_scripts` WHERE `id` = 2612703;
DELETE FROM `spell_script_target` WHERE `entry` = 46704;
INSERT INTO `spell_script_target` SET `entry` = 46704, `type` = 1, `targetentry` = 26117;
UPDATE `creature` SET `position_x` = 3570.79, `position_y` = 6650.47, `position_z` = 195.181, `orientation` = 0.646218 WHERE `guid` = 118396;

UPDATE `creature_template` SET `scriptname` = 'npc_raelorasz' WHERE `entry` = 26117;
UPDATE `creature_template` SET `scriptname` = 'npc_nexus_drake_hatchling' WHERE `entry` = 26127;

INSERT INTO `script_texts` (`entry`, `content_default`, `comment`) VALUES
(-1000015, 'Nexus Drake Hatchling', 'SAY_RAELORASZ_1');
UPDATE `script_texts` SET `content_loc8` = 'Hatchling Dragon Nexus'WHERE `entry` =- 1000015;