[Release] Kael'Thalas Sunstrider - Reborn

[Ground Zero]

Wow.....That is Amazing....Seriously. How long did it take you?

+Rep

Brilliant Job

[stoneharry]

Wow.....That is Amazing....Seriously. How long did it take you?

+Rep

Brilliant Job

It took me about 4-5 hours non-stop once I had my sound id's and spell id's ready. Just having problems with idea's at the moment and getting fed up with the thousands of different database compatablities, which limits me to what I can do

And thanks everyone else Your feedback is apreciated

[willkill]

How do I insert the SQL part?

[Fireblast]

Thank you very much!

[Karyuudo]

Nice! this is going right in my server +Rep if i can

[Remus]

How do I insert the SQL part?

Shouldnt even be here if you cant do a simple SQL insertion into the DB man...

[stoneharry]

How do I insert the SQL part?

Yeah I didn't see your post
You insert it the same way you install a repack/compile a server. Just go into database and restore from sql dump or execute manually. (insert into world/ascent/mangos)

[Hellgawd]

Only flaw is the numerous spelling errors within the script.

[stoneharry]

Yeah I always did suck at english :P Think I got a C for my gcse, ah well.
Anyone can just edit it easily
I'll edit it a bit... Google ftw

Edit: Fixed all spelling mistakes.

[worfking]

+rep given for this and thanks for the link as well

[willkill]

Thats really good!!!! I'm speechless! Tha'ts why Im typing lol ^^ Where did you find the sound IDs and the visuals?

[stoneharry]

Thats really good!!!! I'm speechless! Tha'ts why Im typing lol ^^ Where did you find the sound IDs and the visuals?

Going on thottbot and typing in things like "DND", "simen" and "visual" looking for decent names and there console effects, then .admin castall, or .castall the spell id to see what it does, for visuals.
For sound id's, i randomly play .playall till i find a good one or:
Halestorm's SoudID List Share
which has all the sound id's extracted.

[willkill]

Just realised he's not dropping anything but gold. Does he have a loot table? WOW! Great help man! You've really taught me a lot! +rep to you =D

[stoneharry]

Just realised he's not dropping anything but gold. Does he have a loot table? WOW! Great help man! You've really taught me a lot! +rep to you =D

I never add loot because it would vary from server to server. If it dropped T5 on and epic trash, it would be great on blizzlike, for a funserver, you might need much stronger gear; but you can do this all by your self.

Just go into your database, find creature_loot or something similer in the world/ascent database, id (some 6 didget random number, not to small) entry (id of the npc) item (item it's going to drop) drop chance (in % times by your drop rates) heroic (in heroics) free for all (1 so it's like badges of justice, anyone can loot) and I think thats all of them.

Good luck!