[Guide] Solving the Dun Morogh Spawn Problem

First of all, I did NOT come up with this solution. I just wrote this guide with information from another forum and posted it here.

The Problem

The problem is that in almost any DB the graveyards are given their respective ZoneId, this is what causes the problem. If you die on 'the Eastern Kingdom side' the server will search for the highest ZoneId because it thinks that's the nearest. That's why you'll always spawn in Dun Morogh.

The Solution

Run this query which will set all ZoneId's to 1. Now you'll spawn by the nearest graveyard.

Code:

---

UPDATE graveyards SET ZoneId = 1

---

NOTE: It's recommended to make a backup of your graveyards table before updating it.