Ru-MaNGOS - [QUEST=11633,12003]Открытие территории

Тема на форуме СД2:
http://www.scriptdev2.com/project.php?issueid=877

Для базы:

Код:

REPLACE INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES

(4857, 'at_spire_of_decay'),

(4858, 'at_spire_of_blood'),

(4860, 'at_spire_of_pain'),

(4946, 'at_north_building'),

(4947, 'at_east_building'),

(4948, 'at_south_building');

Для удаления нпц-киллкредитов, если они были расставлены в мире:

Код:

#q11633

DELETE FROM `creature_template_addon` WHERE `entry` IN (25471,25472,25473);

DELETE FROM `creature` WHERE `id` IN (25471,25472,25473);

DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (25471,25472,25473);



#q12003

DELETE FROM `creature_template_addon` WHERE `entry` IN (26468,26470,26469);

DELETE FROM `creature` WHERE `id` IN (26468,26470,26469);

DELETE FROM `creature_ai_scripts` WHERE `creature_id` IN (26468,26470,26469);