[Share] Quel'Danas Spawned

[Entr0py]

Que'Danas spawned!

Here is the release by Plexor - Qual'danas spawned!!

If you have a patch, to fix something in this query, submit it here:
http://forums.ascentemu.com/viewtopic.php?f=15&t=710

Stuff that is wrong with the patch, and needs to be fixed by YOU!:

Flying NPC's
Weapon Display ID's
Shattrah portal to Quel Danas
Spawn cleanup
Quests
Vendors
Creature_Proto



This, is a patch that basically just contains basic creature information, and spawns.

Shattrah 100% GO's & NPC's

Sunwell 50%

Magisters Terrace 90% (missing 2 groups of trash only)

Quel Danas 100% spawns , but it is very very messy, needs major cleanup

UPDATE #1 (This will make Shattrath portal to Qual'Danas works!):
Execute/query this file:

UPDATE `teleport_coords` SET `mapId`='530',`position_x`='13005.514648',`positio n_y`='-6910.902832',`position_z`='9.58423' WHERE (`id`='33');
UPDATE `gameobject_names` SET `spellfocus`='33' WHERE (`entry`='187056');

(You'll see positio n_y, cant change it to normal but it should be: position_y)
And now the portal works perfectly!
------------------------------------------------
If you better like LUA portal (The real one, use this):

portalqualdanas.lua:

function teleport (pUnit, Event, pMisc)
pMisc:Teleport(530, 13005.514648, -6910.902832, 9.58423)
end
RegisterGameObjectEvent(187056, 2, "teleport")

SQL:
Execute/query this:

UPDATE `gameobject_names` SET `spellfocus`='0' WHERE (`entry`='187056')

And now should portal works perfectly!
----------------------------------------
UPDATE #2 (This will fix vendors and repair on Qual'danas island):
Execute/query this:

UPDATE `creature_proto` SET npcflags = 130 WHERE entry=25032;
UPDATE `creature_proto` SET npcflags = 130 WHERE entry=25977;
UPDATE `creature_proto` SET npcflags = 130 WHERE entry=25976;
UPDATE `creature_proto` SET npcflags = 3 WHERE entry=24965;
UPDATE `creature_proto` SET npcflags = 3 WHERE entry=24813;
UPDATE `creature_proto` SET npcflags = 3 WHERE entry=24967;
UPDATE `creature_proto` SET npcflags = 4227 WHERE entry=25046;
UPDATE `creature_proto` SET npcflags = 3 WHERE entry=25057;
UPDATE `creature_proto` SET npcflags = 1 WHERE entry=25162;
------------------------------------------
UPDATE #3 (Execute this query to get the right HP and Mana amount on mobs in Magister's Terrace):

UPDATE creature_proto SET minhealth = 22000 WHERE entry = 24687;
UPDATE creature_proto SET maxhealth = 22000 WHERE entry = 24687;
UPDATE creature_proto SET minhealth = 27000 WHERE entry = 24684;
UPDATE creature_proto SET maxhealth = 27000 WHERE entry = 24684;
UPDATE creature_proto SET minhealth = 23000 WHERE entry = 24689;
UPDATE creature_proto SET maxhealth = 23000 WHERE entry = 24689;
UPDATE creature_proto SET minhealth = 23000 WHERE entry = 24688;
UPDATE creature_proto SET maxhealth = 23000 WHERE entry = 24688;
UPDATE creature_proto SET minhealth = 19000 WHERE entry = 24690;
UPDATE creature_proto SET maxhealth = 19000 WHERE entry = 24690;
UPDATE creature_proto SET minhealth = 5800 WHERE entry = 24761;
UPDATE creature_proto SET maxhealth = 5800 WHERE entry = 24761;
UPDATE creature_proto SET maxhealth = 23000 WHERE entry = 24697;
UPDATE creature_proto SET minhealth = 23000 WHERE entry = 24697;
UPDATE creature_proto SET minhealth = 23000 WHERE entry = 24696;
UPDATE creature_proto SET maxhealth = 23000 WHERE entry = 24696;
UPDATE creature_proto SET mana = 25848 WHERE entry = 24696;
UPDATE creature_proto SET minhealth = 22000 WHERE entry = 24686;
UPDATE creature_proto SET maxhealth = 22000 WHERE entry = 24686;
UPDATE creature_proto SET minhealth = 27000 WHERE entry = 24683;
UPDATE creature_proto SET maxhealth = 27000 WHERE entry = 24683;
UPDATE creature_proto SET minhealth = 22000 WHERE entry = 24685;
UPDATE creature_proto SET maxhealth = 22000 WHERE entry = 24685;
UPDATE creature_proto SET minhealth = 29000 WHERE entry = 24553;
UPDATE creature_proto SET maxhealth = 29000 WHERE entry = 24553;
UPDATE creature_proto SET minhealth = 28000 WHERE entry = 24557;
UPDATE creature_proto SET maxhealth = 28000 WHERE entry = 24557;
UPDATE creature_proto SET minhealth = 33000 WHERE entry = 24560;
UPDATE creature_proto SET maxhealth = 33000 WHERE entry = 24560;
UPDATE creature_proto SET mana = 18930 WHERE entry = 24560;
UPDATE creature_proto SET minhealth = 36000 WHERE entry = 24559;
UPDATE creature_proto SET maxhealth = 36000 WHERE entry = 24559;
UPDATE creature_proto SET minhealth = 29000 WHERE entry = 24555;
UPDATE creature_proto SET maxhealth = 29000 WHERE entry = 24555;
UPDATE creature_proto SET mana = 12620 WHERE entry = 24555;
UPDATE creature_proto SET minhealth = 16000 WHERE entry = 24552;
UPDATE creature_proto SET maxhealth = 16000 WHERE entry = 24552;
UPDATE creature_proto SET mana = 7123 WHERE entry = 24552;
UPDATE creature_proto SET minhealth = 29000 WHERE entry = 24698;
UPDATE creature_proto SET maxhealth = 29000 WHERE entry = 24698;
UPDATE creature_proto SET minhealth = 230000 WHERE entry = 24664;
UPDATE creature_proto SET maxhealth = 230000 WHERE entry = 24664;
------------------------------------------------------


DOWNLOAD:
RapidShare: 1-Click Webhosting
Filebeam - Free Fast File Hosting


All Credits to: Plexor

Enjoy!

This is not made by me, Im just sharing it.
ALL credits go to Plexor at Ac-web.org he is the one who made it.
Hope you like it!

[TheSpidey]

Ahem

Here is the release by Plexor - Qual'danas spawned!!

So dRACE made it or Plexor?
Proper credits please.

[Entr0py]

It was posted by dRACE on ac-web so i just put it as his, ill change it i guess.

[bsyburra]

wow u listed most things that ppl would like as messed up. who cares about spawns if the vendors, displays and stuff are messed

[Arthas117]

...+rep x2

[Entr0py]

...+rep x2

Thank ye, is it workin for every1?

[Tomatsuppen]

works fine for me

[dRACE]

Thanks to see someone respect my job!