This is the most fool proof way of making a new "Recall" location
1) Open up a new notepad file and copy the code below into it vvvvvv
Code:
INSERT INTO recall
(`id`, `name`, `MapId`, `positionX`, `positionY`, `positionZ`)
VALUES
(ID,'NAME',MAPID,X_COORD,Y_COORD,Z_COORD);
**Note: ONLY edit the RED text... make sure everything else stays in tact
2) For ID Put any number not currently used by any other recall spells (usually any number above 800)
3) For NAME Name it anything you want but remember you will use .recall "Name you chose here" to get to your destination
4) For these next few steps you will want to go to where you want this recall point to take you to ingame. When you are there type .GPS
5) For MAPID type the map id that showed up in the ".gps" command
6) For X_COORD type the X coordinate that showed up in the ".gps" command
7) For Y_COORD type the Y coordinate that showed up in the ".gps" command
For Z_COORD type the Z coordinate that showed up in the ".gps" command
9) Now... on your notepad file... click FILE... SAVE AS...
And save it as anything you want BUT make sure it has .SQL at the end of it
(ex) nameyouchose.SQL
10) Open up your database editor (SQLYOG / NAVICAT / ECT) and exicute your newly made sql file.
11) Restart your server... log in and .recall NAME
12) BOOM! Done : ]
THIS GUIDE WAS MADE BY GANORAN... NO STEALING!!