How To Fix The Instance AreaTriggers for WOTLK by Simontheking
Difficulty Level : Normal
(If there is a guide like this out there i havent "Stolen it" I did this myself since i got tired of this not getting fixed)
Intro :
A problem i've seen on alot of private servers is that when you enter Utgarde keep for an example you get ported out immediatly. But i've found a solution to this. I might take some time (Unless some kind soul makes a SQL file).
Requirements = Wow, DB handler program (Navicat for an example)
In this im going to take Utgarde keep as an example but it works with all the other ones too.
1. Go into navicat or whatever you use
2. In the world DB open up "Area trigger"
3. Search for "Utgarde Keep"
4. You should see something like "Utgarde-Enter"
5. Next to it is som X,Y,Z Coordinates.
6. Get into the instance (If you know how to go directly to step 7)
6b. How to get in to an instance if you dont got teleports =
You see the X Y Z info next to the areatrigger name? That's the info you're going to need. We are going to use the ".worldport MapID X Y Z" command. But we are going change some so we dont end up the same place and get ported out again.
6c. For me it was .worldport 574 147 -88 12 but i changed it into .worldport 574 147 -58 12 and then i started falling trough the ground. So be prepared that wont probably wont endup in the instance. .cheat fly into the instance and get close to the exit (Not to close you'll get ported out again xD)
7. Type .gps where you want the people who enters to endup.. Should be near the exit ofc.
8. Go into the Areatrigger table in navicat and change the X,Y,Z positions to the once you got from typing .gps (You may want to make the Z +1 so you dont fall trought the ground.
9. Save up and restart and then you're done! :]
Pics :
Sorry that the Z position is not included on the top one but you get the point.
The End (: