Ascent 2552 Vers 2.4.1

ASCENT 4552 VERS 2.4.1

http://www.mediafire.com/download.php?nmyfg4gvzmm

Sunwell Plateau spawnat + loot+q

Optional mall
http://www.mediafire.com/?emekjgkxtvz
rulati cu SQLyog
Ptr mall .recall port mall iar portal e 600005

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

Iar ptr ilidan cine doreste sal poata ataca si fara poarta rulati

CODE
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';

Si sa nu mai atace in Shattrath

CODE
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';

-- All Battlemaster Flag Updates --

CODE
-- All Battlemaster Flag Updates --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');

Puteti updata cu ceva mai nou si scapati de bugu cu spelurile care se inlokuiesc

Thanks for the article! I'm from Ukraine we have a rather difficult to find useful interesting information.