[Release]Qual'danas spawned! (Credits to: Plexor)

[Chroem]

Qual'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:
Ascent Forums • View topic - 2.4 Patches ~Submit only SQL patches 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 (http://rapidshare.com/files/108832343/2.4.zip)
Filebeam - Free Fast File Hosting (http://filebeam.com/0f029fbdb4852495d7388792c261bbeb)


All Credits to: Plexor

Enjoy!


------------------------------------------------------

[welshtotem]

can you put in more mirrors ? Rapidshare not working for me

[rockside]

Holy crap man this is awesome, This will give my server alot of players

[Chroem]

rockside it will.. but like i said.. you gonna move some npcs.. and try repair that stuff in it like npcs weapon model is a box.. thats im sorry about..
@welshtotem: There is not space for that sorry.

[rockside]

Yea I know how to script and stuff I should have everything cleaned up in about an hour =D

And drace if I could +rep you I would, I am starting a SQL pack for a funserver than a Blizzlike one with T7 and 8 with vendors + Other fun items Hopefully get me away from newbie

[ogchaos]

what is the new

.recall port <id> to get to this island ??

and what is the portals id that we can spawn?

[Chroem]

About the portal its buggy - So dont use make you own! MUCH BETTER!

About the recall its easy:

INSERT INTO `recall` VALUES ('7555', 'Sunwell', '530', '13004.5', '-6910.25', '9.58423');

Execute/query that restart server:

And now its:

.recall port Sunwell


Hope it helped!


Best regard, dRACE

[ogchaos]

About the portal its buggy - So dont use make you own! MUCH BETTER!

About the recall its easy:

INSERT INTO `recall` VALUES ('7555', 'Sunwell', '530', '13004.5', '-6910.25', '9.58423');

Execute/query that restart server:

And now its:

.recall port Sunwell


Hope it helped!


Best regard, dRACE

yes

thank you

[Chroem]

;)

[Terrorblade]

Holy Shit!!!!!!! No Scripts Im Going To Cry :( Lol

[capizzle]

very nice, i will set it up and post a review about it.

If I can I will edit the NPC's and move them around and fix the weapon bug.

[f3honda4me]

pardon the noobie question. but how do i add this in to my AC repack I'm using?

[birdofdeath]

to answer the person above me...
go into navicat and do "execute batch file" for the 2-4.sql file in the zip..
then click continue on errors.
restart and your done



Just wanted to say thanks.. added to my server Lunar Wow and my players are very happy.. Kudos

[flarg]

i got the scripts for brutallus vellxus Selin Fireheart too

[Blackboy0]

Thank you soooooooo much dRace :P Now lets just hope my Computer gets through this Execution lol :P VERY big SQL Script right there... I hope my Database doesn't f*** over because of this... I'll Post what happens when it happens :D

[metehan]

It will fuckup, this DB has so much fucking errors, just check the ascent emu thread...

[flarg]

yeah this thing takes forEVER! to load into ur Database

[Blackboy0]

Well, the thing worked, except there's no freaking Mobs anywhere >.<

[Chroem]

Hello Blackboy0 its should you'll find in the script creature_spawns and gameobject_spawns try copy all that with creature_spawns and query it tell me if it works.. did it gave error when execute?


- Hope it helped!

@flarg: Just.. query it.. or use sqlyog, navicat lite! Hope it helped you alot! - It took notime for me..

[painejake]

The mobs are spawned?? :O OMG lol hmmm is the instance open as well if so me thinks me will grabs this :D

[Chroem]

Yep mobs are spawned. :)
But dont open Sunwell Platue since! No mobs there its 0% Finnish all other are finnish!
Like Magisters' Tarrace 90%
Qual'danas 100%
Sunwell 50%
-----
For open Magisters' Tarrance here execute this little script:


INSERT INTO worldmap_info VALUES (585,585,4,5,70,0,0,0,0,"Magister's Terrace",3,7200,0,0,0,0,0,80,0);
INSERT INTO areatriggers VALUES (4887,1,585,585,"Magister's Terrace Enter",-0.594530,-0.123698,-2.803230,0,0,70);
INSERT INTO areatriggers VALUES (4885,4,530,530,"Magister's Terrace Exit",12885,-7331.740234,65.530998,1.0021,0,70);




Hope this worked!


Best Regard, dRACE

[painejake]

Ahh brill thanks mate i suppose tho nothing stops us from spawning our own mobs in the instance right? lol :D + Rep dRACE

[Chroem]

Yeah.. :P hehe! :p - But painejake look on the first post on page 1 where download is.. there is a update there will fix the portal! ;)

[painejake]

I KNOW :O lol cheers gonna actually portal there properly when i get home and execute these xD

Also could you upload it somewhere else to those damn cats on Rapidshare wont let me download! lol There so hard to tell apart

[Chroem]

- I know.. but sorry.. like i said not enough space.. but hwat is ypu problem with Rapidshare..

(THERE ARE MORE UPDATES ON THE FIRST THREAD!)

[painejake]

Hmm might be cos im on a proxy server at work so ill try when i get home

[Chroem]

Yeah do that.. and on rapidshare.. for get the right word - Only where you can see the cat on the letter.. just you know :P

[geko]

but no loot :S

[Chroem]

Yep.. i know there is know use Sectorseven and 2dgreengidant's 2.4 sql!

[Kokka96]

Can't wait to see that Isle.

How do you get there? FP? Portal in Shatt?
And if there's a Shatt port but its not spawned, whats the ID of that portal?

Thanks,

[Chroem]

The portal id is:
.gobject spawn 187056 1 (1) makes it be there forever

[Kokka96]

I know. :P

However, i executed the updates too, but the Magister's Terrace-script (the last one you posted) doesn't work for some reason. First it said "Duplicate entry for 585". And then it complained about Duplicate ID's. Can you fix it? :S

[mageboy46]

Dude...Amazing. Tyvm +Rep if i could. Awesome job. Hope to see some major fixes and advancments with this.

[Chroem]

It works perfectly for me Kokka96. :)!

[n0_name]

can u upload it somewhere else pls??

[Chroem]

n0_name like i said.. there is not enough space!
:/

[Kokka96]

Well, i can still enter so there's no problem. :P

Why did you upload it to Rapidshare in the first place? Filebeam of Mediafire is way better.

[Chroem]

I know.. - Just that came in my mind first! :s

[ratke]

enjoy for who cant download from rapidshare ;p
Filebeam - Free Fast File Hosting (http://filebeam.com/0f029fbdb4852495d7388792c261bbeb)

[Blackboy0]

Hello Blackboy0 its should you'll find in the script creature_spawns and gameobject_spawns try copy all that with creature_spawns and query it tell me if it works.. did it gave error when execute?


- Hope it helped!

@flarg: Just.. query it.. or use sqlyog, navicat lite! Hope it helped you alot! - It took notime for me..

I executed the whole Query, no errors. There are only Mobs spawned in Shattrah City, nowhere else >.<

[Chroem]

Thats odd! Try download again and execute the query again remember to be sure creature_spawns will be executed/query

I have putted filebeam mirror so them who got problems with "Rapidshare" can now download from filebeam!

Enjoy!!!! :P

[flarg]

ehy dRACE can you get the other 50% of the Sunwell done please? I want to do the rest of the instance because I got the scripts for some of the bosses you don't have.

[Blackboy0]

I'd like for the first 50% of my Sunwell to be done atleast :P I'm Executing it all again, its at like 65% right now... It doesn't have any Dawnblade Mobs yet, just the Shattered Sun and whatnot >.< The only Mobs spawned are at Shattrah, and they are perfectly Spawned (Waypoints, Text and Emotes all work).

Just need the SUNWELL Mobs to accually be Spawned there... I don't wanna manually Spawn them, that'd suck :(

[Just1nkr3d1bl3]

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

And now the portal works perfectly!
------------------------------------------------

You have to fix the MySQL query. Update this section to the following.

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

And now the portal works perfectly!

You have position_y set to "positio n_y"

And if anyone hasn't done it yet, I'll fix the island so you don't get ganked by fifty mobs at once. Although It'll still be a challange. (3-4 mobs at once, if you can't do that then I suggest you play retail some more.) Also, the Shattered Sun Offence faction STILL attacks me even when I'm exalted with them, or at least I thought I was. One problem is that that specific faction doesn't show up in your faction tab. You can easily fix this by making your own faction(?).

[Chroem]

Blackboy0, Dawnblade is spawned! ;)
@Justin:
It show positio n_y but in edit form and when i putted in it show normal! Soooo...

[pawaox]

Good Job !

[Chroem]

Thanks pawaox :=)

[rockside]

When i execute it into my database... it goes through with no errors at all, But it is not staying in my database.. Why is this like I can keep extractin the same SQL over and over again but it still doesnt stick

[Yerney]

The dawnblade mobs aren't working well tho, they "teleport" to the attacker and don't walk normal, if you script them...(no matter what spell) it will crash the server.

Core/Database are screwing it up, don't you think ? :P

[Chroem]

Yerney.. it works perfectly on mine.. but like i sayd "DELETE DOWNBLADES"!

[Yerney]

are they walking normal instead of that wierd teleport? (dawnblades?)

[firefuse]

Ok i know this sound soooooooooo noob... but how do i get the new items to work in my server? like to get them in the database :P yes im a noob

[Chroem]

Yerney.. "like posting in the start thread that need to be fixed:
by your!:
creature_proto!

So it can be something with the speed in creature_proto so they really, really fast!!!

[Yerney]

ow didn't read that. :) But the doesn't support the spells either tho, scripted dawnbladed = crash ^^

[zorbs]

dRACE thanks for all of this , but I have a problem with the spawns... You said 50% of sunwell was spawned and I there are no mobs in sunwell. Could you help me? Thanks

[Blackboy0]

Yes, there are ALOT of bugs wrong with this and the Repacks around here lol. I use Howling's Repack and it comes with about 4 of the Shattered Sun mobs (Trainee, Veteran, Magi, Cleric) and they're Spawned in Shattrah but nowhere on Quel'Danas.

When I downloaded your Database and Executed it, all those Mobs were deleted and the Mobs in your Query were added, leaving Shattrah filled with only a couple Mobs (There was a Drill Sergeant, a Veteran and a couple Magi around... And that Grand Anchorite). Along with deleting the mobs in Shattrah, Quel'Danas was spawned, but madly :O There were 2 mobs Spawned ontop of eachother every square inch rofl. So I went through them all, Deleting what I didn't want and totally reconfiguring the Isle of Quel'Danas :)

Oh yes and also, this is missing about 6 Quest-Givers and like 12 Vendors :P

[deine mudda]

hey can someone help me...i have no ideas how to install it o.O
what must i do????? :-O

[Chroem]

Helo all like i said! This : Is very very messy need a major clean by you! Yep i dont know about that scripted dawnblade maybe yeah!
50% Sunwell

I think you júst need to ignore! Its nothing.. Sunwell Platue is not spawned!!

[Macksen]

I have fixed those Postition x,y,z and MapID, Id spellfocus and Entry, but it still dosen't work. When i spawn it in the game, then i press it but nothing happens

[zealot588]

does this work with heidi SQL?

[Chroem]

zealot sure ;)

[Kyoshiro]

It Sucks Balls The Npc Get Killed In One F U C K I N G Hit And I Killed Them At Lvl 1 With A Hit Of 36

[Lorda93]

Ok i do what u say but the npcs in Qual have 1hp aggain !? pla help can u give me yours creaturse_proto.sql?

[luraguttn]

hey where do u put this folder to "update" it i am new on this private server thing so could u please tell me? and whats the command to go to sunwell?

[thomas1995]

Hey so were do i extract it to

[Chroem]

Hello, sorry for not answer i was on a holiday!

Like i said in the first thread:
Who need to be fixed by you!:
Creature_proto
It very, very messy!


Best regard, dRACE

[thomas1995]

what do i do with the SQL files and where am i ment to extract it to im not a wiz at stuff like this :(

[Chroem]

Just execute via. navicat

[pawaox]

He have said it several Times now. YOU need to fix the Creature_Proto. That's their damage, health, mana and whatnot. Asking is fine, but read first plx :P

(This is not a flame)

[Lorda93]

Ok i fix the healt of the mobs but they don't drop anything anlu 50silver pls help

[Chroem]

Lorda read my first thread.. all is readed there..

[Micas]

HeidiSQL keeps freezing when I start patching the file :X

Any suggestions? :[

[Lorda93]

OK i read it again and again but i didn't see anywhere how to fix the drop on the Island pls help

[thomas1995]

Just execute via. navicat

i cant execute it with navicat i use heildieSQL

[phoenix]

I found that the NPCS are spawned but there are no quests? whats with that? and the portal in shat doesnt work.. you got an executable file to fix this drace?

[SilentHill]

I executed the sql on my database but there are still no spawns. any ideas?

[duen1992]

had same problem Micas, but if i dont open any programs , or exit heidiSQL i manage to get it done

[sgcsn]

if heidisql is crashing try selecting no when it gives you the option of not loading into text field, that way it loads into text field then execute and no error

[flarg]

it isnt working

[argonian]

hmm... is this for ascent? cuz when im exicute it my computer locks up at like 96%...

[Chroem]

Yep its for ascent! and it should work very very messy! But should work! Remember to fix creature_proto and all that stuff i writed by youself. ;)

[Hurkulez]

dRace what are the chances of there being a release with all the updates incorperated?
you can do it 2 ways:
Very big sql files, or zip the db data folder.... Just a thought...
or 3 ways to include "not at all"... just a little forum humor :)
OBTW +REP!

[Meanox]

Please help if i execute Sunwell the HeidySQL get stuck and says the program dont work he stops always at 5 bars.
Please help me

[seanleyla]

About the portal its buggy - So dont use make you own! MUCH BETTER!

About the recall its easy:

INSERT INTO `recall` VALUES ('7555', 'Sunwell', '530', '13004.5', '-6910.25', '9.58423');

Execute/query that restart server:

And now its:

.recall port Sunwell


Hope it helped!


Best regard, dRACE

uhm... where do i set `recall` VALUES ('7555', 'Sunwell', '530', '13004.5', '-6910.25', '9.58423'); ??? :confused:

[druidx]

will this work with howlings repack? last time i tried illidan (morph npc) grew 5 times the size, and i lost alot of his custom Tiers, so any way i can install it without losing those things?

[shellac]

quick question...

why is it that in your screenshots there is pictures of Sunwell boss's and trash? I have tried to spawn these myself and I get invalid ID's error which means they are not released in your files?

I am trying to get those boss's to spawn, are the pictures misleading? or am I doing something wrong?

[Hurkulez]

uhm... where do i set `recall` VALUES ('7555', 'Sunwell', '530', '13004.5', '-6910.25', '9.58423'); ??? :confused:

Run is as a DB Query... to update your world recall db table

[Marasz]

Erm mate.. It doesn't seem to work for me. It worked before, but now my mobs etc are just gone..

[Fujosej]

Hi dRace i have a strange problem with this update.
I correctly install and enter to the isle then i see a strange thing.in every mob on two mob.(( same thing with bosses , on boss= three bosses . how fix this problem please tell me. If you want i can make screenshot.

[druidx]

dRace, you got a bunch of questions you havent answeared yet, 4 acctaully, help us use your Release

[asvati]

emm, how do i make the mobs move less "laggy"?:P have fixed teh health, attack etc, but i havent found anything that includes that, except i have tryed changing walking speed and run speed, but it looks like it have no effect.

[madthunder3]

I applied this fix and nearly All the Friendly NPCs are red named.

[mrsunhill]

Ahh omg i hate rapidshare :( cant even download 7.7 -.-

[Danox]

this is for ascent or mangos?

[Chroem]

Danox@: This is for ascent.

ascati@: Its a fix in the database: movement_speed or speed is it called a column in creature_protos.

madthunder@: I know, its a messy thing fix in database the faction!

[rjy]

Once your there once get the flight path! or as a GM type .cheat taxi1 and go to the person next to the dead scar with the bats and fly there!

[flarg]

yah this doesnt work

[codifier]

Hey, I'm using Navicat MySQL 8.0, I made a query and I cleaned all from "Query Editor" and I typed these there: 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'); But it's saying: Unknown column 'positio n_y' in 'field list' , please help me!

[Chroem]

codofier@

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

The fail is because its space: positio n_y cant change but it not gonna be space between o and n. Cant fix on this forum! :/

Hope this helped you!

HERE
! ;)

[sckizman]

Lol... no vendors work! u made my server mess up :O :'( i created like 156 custom vendors.

[hope2140214]

IF you never used this b4.. download the repack again and set the .conf correctly and use the NEW DB and test it out on there

[teheric]

iv tried 3 times to put the sql file in, and hiedisql crashes about half way through everytime. is there a different way to do this?

[Nichlas93]

how do I install it?
(I'm a noob in this :P)

[Elfandor]

srry the id for spawn a portal to sunnwell .go spawn id???'

[oliverkidd]

How was i ment to do this?

Because i downloaded and the just Executed and it didn't work :S