[Release] MySQL Driven Teleporter

[waymirec]

This is a mysql driven teleporter that I through together for my own use and figured i'd release it out. It's just a first draft and has definite room for improvement, including storing the menu items into a data structure at startup rather than performing db queries for each request. Included in the zip is the source for the teleporter as well as a mysqldump of the table I use.

The table is pretty self explanatory but if anyone has any questions i'm happy to answer them.

There are 2 define's at the top of the Custom_Teleporters.cpp that define the maximum number of entries allowed per request as well as the creature id of your teleporter. Change as needed.

Credit goes out to whomever coded the original version of the Teleporter that I am using. It was provided to me by someone else so i'm not sure who the person is.

The package can be downloaded from http://www.funserver.cc/Teleporter.zip

[EDIT]
I noticed that i noobishly set the map field to tinyint(3) unsigned resulting in none of the TBC maps working. I corrected it and here is the fix.
http://www.funserver.cc/custom_teleporter.sql
[/EDIT]

[*Alexz*]

what is this and what dose it do xD

[waymirec]

I thought the post was explanatory but maybe not. It is an addon for a Teleporter NPC just like all of the others you see posted on here but rather than having all of the coordinates/locations stored in the c++ code they are stored in a mysql table within the world database. The benefit is that you can add/edit/delete entries within your teleporter without having recompile the addon or even (at this state) reload the server. It includes functionality for being able to specify criteria whether an entry is displayed; minimum level, maximum level and team (horde vs alliance).

[knaur]

very very genial =) this saves us alot of compile time =)

+4 rep from me

[Cursed]

WoW cool thing +rep 3x

[*TraPStaR*]

do you still need a warp npc

[vb4evr]

Very nice waymirec.
Looks like a lot of hard work when into this.

[warxhead]

do you still need a warp npc

Just use the code that was included in the file he put up.
You don't need your old Warp NPC.

[knaur]

or you can edit the source and sql to use your old warper npc
if you want to use that. you still use a npc yes, But you can change
locations and cords easy inside the database instead of in source dll,
and you dont have to restart after adding/deleting locations

[Darkelfin]

lol im a n00b how do i install this?

[latruwski]

great release !

[Etherealamd]

lol im a n00b how do i install this?

Me too....

Hmmm... I can't seem to find the character spawn number for naga warp master from norweigans 4.0???

Found it 100000...... I think...

[Noobcraft]

would anyone mind complieing the actul dll for me

[Chrispee]

omg this is so amazing good job mate +rep

[Darkelfin]

Can someone compile it plz!?