[PacK]Ascent 4552 | v2.4.1 ++ Mall

ASCENT 4552 VERS 2.4.1 [Sunwell Plateau spawed + loot + q] -- Download --- http://www.mediafire.com/download.php?nmyfg4gvzmm

Optional mall -- Download --- http://www.mediafire.com/?emekjgkxtvz
(rulati in SQLYog/Navicat ; pt ".recall" : ".recall port mall", iar pt portal catre mall codul este "600005")

MoonScript Core r395 -- Download --- http://www.mediafire.com/?ih0wny5mbyj

SQL Querys:
Iar cine doreste sa il atace pe Illidan fara poarta sa ruleze urmatorul script in MySQL
Cod:
DELETE FROM creature_spawns WHERE entry = '22917';
INSERT INTO `creature_spawns` (`entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`) VALUES
(22917,564,'676.181','306.194','353.192','6.03186',0,'21135',1825,0,0,0,0,0,0,0,0,0);
DELETE FROM gameobject_spawns WHERE entry = '185905';

Pentru a numai ataca in Shattrath
Cod:
UPDATE creature_proto SET npcflags='1048577' WHERE entry='15103';
UPDATE creature_spawns SET flags='1048577' WHERE entry='15103';
UPDATE creature_spawns SET faction='1741' WHERE entry='15103';
UPDATE creature_proto SET npcflags='1048577' WHERE entry='15106';
UPDATE creature_spawns SET flags='1048577' WHERE entry='15106';
UPDATE creature_spawns SET faction='1741' WHERE entry='15106';
UPDATE creature_proto SET faction='35' WHERE entry='23131';
UPDATE creature_proto SET npcflags='0' WHERE entry='23131';
UPDATE creature_spawns SET flags='0' WHERE entry='23131';
UPDATE creature_spawns SET faction='35' WHERE entry='23131';

[UPDATE] Battlemasters FLAGS
Cod:
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='14942');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='15105');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20276');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20274');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20384');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='347');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='857');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='907');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='2302');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='2804');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='3890');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='5118');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='7410');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='7427');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='10360');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='12197');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='12198');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='14981');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='14982');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='15006');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='15007');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='15008');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='16694');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='16695');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='16696');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='16711');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='17506');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='17507');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19855');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19905');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19906');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19907');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19908');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19910');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20118');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20119');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20120');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20269');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20271');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20272');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20273');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20362');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20374');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20376');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20276');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20362');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20374');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20381');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20382');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20383');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20385');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20386');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20388');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='20390');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19911');
UPDATE creature_proto SET npcflags = '1048577' WHERE (entry='19858');
UPDATE creature_proto SET npcflags = '147' WHERE (entry='4217');