| 
06-30-2008
Are you a noob at C++ ? Just wanna get a teleporter you can carry around but you simply cant, and the ones you download offline you dont know how to add you mall location? This all comes to an end now!
This guide will show you how to make a teleporter that you can carry in your bag in minutes, and it requires NO C++ or scripting in any way.
How to:
1.Go into Navicat,SqlYog,HidiSql, or any program you use to work on your database.
2.Connect to your database and open your 'World" database. [This database contains tables like items,creature_names,quests,gameobject_names etc.]
3.Now you need to find your Teleport_coords table. Open this
4.Inside you will see things like Teleport Goldshire under name etc. These are names of spells that teleport you somewhere.
5.You need to now go online and goto the place you want this item to teleport you to. Type in this .gps a list of your X,Y,Z coords should come up. I reccomend typing these numbers out ingame. [Example: -432.2332 42323.22 .122322.2] Copy and paste these into a notepad file so you dont loose them.
6. Now you need to choose a spell that you dont think is needed and you want to change its teleport coords. Make sure you read the name of what the spell is. You do not want to choose Teleport Ironforge. For this we will choose teleport goldshire.
7.Scroll over to Were you see position X position Y position Z, place the coordinates for each that you copied into a notepad file.
8.Now you need to make sure the zone is rite. Go over to MapID it should say a number there like 0,1, or 530. 0 is Eastern Kingdoms, 1 is Kalimdor, and 530 is Outlands or any area TBC. Place either a 0,1 or 530 in this spot depending on were you coordinates are at.
9.Before name it should say ID, make sure you write this down it is the spellID you will need it.
10.Close out of teleport_coords and open up Items table.
11.We are now going to make a new item.
12.On the bottom find the little + sign click that. This will make a new blank Query. Fill in this query as listed below
Entry:This is the ID of the item [Example .additem 100, 100 is the ID],Do not go over 999999
Class:Put a 7
Subclass:Put a 5
Field4:Put a -1
Name1:The name of your item
Name2,3,and 4:Same as Name1
DisplayID:The DisplayID of the item.What it will loook like in your bag.
Quality:The quality of your item [0=Grey,1=White,2=Green,3=Blue,4=Purple,5=Red,6=orange]
Flags:0
buyprice:Whatever you want.
sellprice:Whatever you want.
Inventorytype:0
Allowableclass:-1
Allowablerace:-1
Itemlevel:the level of the item.
Requiredlevel:The level required to use the item.
Requiredskillrank:0
requiredskillsubrank;0
requiredplayerrank1:0
requiredplayerrank2:0
requiredfaction:0
requiredfactionstanding:0
unique:0
maxcount: 1
containerslots:0
stat-type1-10:0
dmg_min1-5:0
dmg_max1-5:0
dmg_type1-5:0
armor:0
holy_res:0
fire_res:0
nature_res:0
frost_res:0
shadow-res:0
arcane_res:0
delay:0
ammo_type:0
range:0
spellid_1:the spellID you wrote down [Example 31 (teleport Goldshire Spell)]
spelltrigger_1:0
spellcharges_1:0
spellcategory_1:1141
spellcategorycooldown_1:0
spellid_2-5:0
spelltrigger_2-5:0
spellcharges_2-5:0
spellcategory_2-5:0
spellcategorycooldown_2-5:0
bonding:0
description:Whatever you want for the description
page_id:0
page_language:0
page_material:0
quest_id:0
lock_material:-1
sheathID:0
randomprop:0
unk203_1:0
block;0
itemset:0
maxDurability:0
ZoneNameID:0
MapID:0
bagfamily:0
totemcategory:0
socket-color-1:0
put in the rest of them 0
Now exit out of that table,restart your server,log in and test it out.
Sorry if this is a repost i just figured out that it worked so I figured id post cus it seemed cool.Leave comments on if it workered or if u need help!
-Mr.FlySquirrel
Lol did this help any1?
Last edited by 2dgreengiant; 07-04-2008 at 05:48 PM.
Reason: double post, merged
| 
