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

Subject: [PacK]Ascent 4552 | v2.4.1 ++ Mall Sun Nov 16, 2008 2:45 am

ASCENT 4552 VERS 2.4.1 [Sunwell Plateau spawed + loot + q] -- Download

Optional mall -- Download

(rulati in SQLYog/Navicat ; pt ".recall" : ".recall port mall", iar pt portal catre mall codul este "600005")

MoonScript Core r395 -- Download

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

Pentru a scapa de buguri executati SQL Querys.
_________________
DanNy.

» C4 Server Pack Starmedia
» [Ascent]Cum puneti 2 realm-uri!
» Server wow ascent 2.3.x Emulator