Creating Teleporting Items (The Easy Way)

[Conceded]

Ok this is a guide on how to create an item that will teleport players to a designated area. Example, if you have a new area you want someone special to go to, add the item to them. So lets get started,

Things you will need:

1.) Some sort of Sql manager, Navicat, HeidiSql, or SQLyog.
2.) Some sort of MySql system running at the time of you making the item.
3.) Some sort of database knowledge or something. (optional, having this would make it less frustrating for you.)
Ok, Lets begin

How to Modify the Spell

1.) Start your MySql system.
2.) Login to your database.
3.) Open the "teleport_coords" table.
4.) Look for a teleporting spell that is hardly ever use, like Teleport: Anvilmar. (You can rename it to whatever you want, it isn't shown so no big deal.)
5.) Now start up your server.
6.) Go to the spot in-game you want your players to be ported to when they use the item.
7.) Type .gps
8.) Copy the numbers in the following order: Map, X, Y, Z.
9.) Go back to the "teleport_coords" table and put in the number you got from .gps in the correct labeled locations.
10.) Once that is done close the table "teleport_coords"

To Make The Item

1.) Start your MySql system.
2.) Login to your database.
3.) Open the database table "Items".
4.) Use a template similar to this one for the item:

**--Start Template--**

ID (Modifiable) - 98741
Class (Not-Modifiable) - 15
Field4 (Not-Modifiable) - (-1)
Name (Modifiable) - SuperSonicBoomTransport
Display ID (Modifiable, Just do whatever floats your boat for this one.) - 26772
Flags (Not-Modifiable) - 64
AllowableClass (Modifiable) - (-1)
AllowableRace (Modifiable) - (-1)
Maxcount (Modifiable, The amount of this item the player may have, 0 is for any amount.) - 1
spellid_1 - (The ID from the "teleport_coords table, mine is 1936.) - 1936
Bonding (Modifiable, To make it BoP, BoE, BoU, or No Bind change the "Bonding" row to:
0 = No Bind
1 = On Pickup
2 = On Equip
3 = On Use

**--End Template--**

Now that you have made the item and edited the spell all you have to do is restart your server and go in-game and .char additem 98741 while targeting someone.

To add it to a vendor follow this command line:
.npc vendoradditem (ID HERE) 1

If liked I will be offering a vendor making service with the item spawned in the vendor on spawn for people. Any comments or questions should be directed towards My Email. I hope this helped you and more will be coming soon!

The Item in SQL file

Well here are some download links to the Sql file, I did this to help some people out. It follows the exact same template as my guide.

Rapidshare Download
FileBeam Download (This is in .txt format, to get it in a executable query form open it and save it as "SuperSonicBoomTransporter.sql")
And Here is the MediaFire Download

The Item in a Vendor in SQL file


Well here are some download links to the Sql file, I did this one to help people and make this more convenient.

Rapidshare Download
FileBeam Download (This is in .txt format, to get it in a executable query form open it and save it as "Unique Junk.sql".)
MediaFire Download

The Npc's spawn ID is - 98742

[innan]

woot first post looks nice

[Lightorius]

Nice and clean..unfortunately there are quite a few of these tutorials.

Still, +rep for a nice tutorial

[Conceded]

Thank You

[aciidtrojan]

Hey, i made this item and it works perfectly, but is there a way so that it asks you where you want to go from the one item?

[luket1]

Originally Posted by Conceded

The Npc's spawn ID is - 98742

It's 98741

But still +Rep

[Conceded]

Originally Posted by aciidtrojan

Hey, i made this item and it works perfectly, but is there a way so that it asks you where you want to go from the one item?

So you want it to ask you where you want to go? Like when you get summoned somewhere?

Originally Posted by luket1

It's 98741

But still +Rep

The Item is ID is 98741
The NPC ID is 98742

[aciidtrojan]

Originally Posted by Conceded

So you want it to ask you where you want to go? Like when you get summoned somewhere?

I want it to display a menu when you use the items, listing a variety of locations you can go (ie horde cities, mall etc etc.)

[Conceded]

Originally Posted by aciidtrojan

I want it to display a menu when you use the items, listing a variety of locations you can go (ie horde cities, mall etc etc.)

Thats another tutorial but yeah I will make one for that. Just give me a few days, I broke my wrist this week so I have to do some other things to help that.

[ninjaman91]

does this mean that theoretically you can create a new custom teleport_coord? or does it HAVE to already be a spell as such?

[devilcry]

looks kinda kol, could make a VIP key type thing so thay can get to special areas ty