[Fix] Даларан (порталы БГ)

[Винсент]

Порталы на БГ (Даларан):
#-- Alterac Valley
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32616, 7);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32617, 7);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29669;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29674;
#поменял местами были попутаны
UPDATE `creature` SET `id`=29669 WHERE `guid` = 137926;
UPDATE `creature` SET `id`=29674 WHERE `guid` = 113465;

#-- Strand of the Ancients
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32622, 9);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32623, 9);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29671;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29676;
#орды и альянса стояли в одной точке спауна, перенес на свое место орды
DELETE FROM `creature` WHERE `id`=29676;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modeli d`,`equipment_id`,`position_x`,`position_y`,`posit ion_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,` DeathState`,`MovementType`) VALUES
(113664, 29676, 571, 1, 1, 0, 0, 5974.76, 544.652, 661.779, 1.97222, 300, 0, 0, 5342, 0, 0, 0);

#-- Eye of the Storm
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32620, 1);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32621, 1);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29670;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29675;

#-- Arathi Basin
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32618, 3);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32619, 3);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534 WHERE `entry` = 29668;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714 WHERE `entry` = 29673;

#-- Strand of the Ancients
#Wintergrasp
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32624, 2);
INSERT INTO `battlemaster_entry` (`entry`, `bg_template`) VALUES
(32625, 2);
#Dalaran
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 534, `faction_H` = 534, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29667;
UPDATE `creature_template` SET `IconName` = 'Interact', `faction_A` = 714, `faction_H` = 714, `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` = 29672;

#-- расстановка флагов (так как gossip_ом туго поставил все-таки 1048576)
#чтобы отключить ставим `npcflag` = 1048577 будет просто приветствовать
UPDATE `creature_template` SET `npcflag` = 1048576, `unit_flags` = 4096, `flags_extra` = 2 WHERE `entry` in (29667, 29668, 29670, 29671,29672, 29673, 29675, 29676, 32616, 32617,32618,32619,32620,32621,32622,32623,32624,32 625);