Repairing Zone Points
 

Hello! I am fixing the few broken zone points on my server (I am running PEQ_Kunark_Latest DB). But I have a question...

Between soldunga and soldungb there are a total of 4 common zones that connect those 2 together. However in the DB, There are a total of 9 zonepoints that refer to these 4 common "zone walls".. Why 9? There should be only 4 right? So 5 of these 9 are just garbage right? Also, why do so many of these x y z coords have 999999 for a cord? Its clearly invalid right? Or does the server interpret 999999 to mean something?

+------+----------+--------+------+------+--------+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
| id | zone | number | y | x | z | heading | target_zone | target_y | target_x | target_z | target_heading | keep_x | keep_y | zoneinst |
+------+----------+--------+------+------+--------+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
| 1157 | soldungb | 11 | 0 | 0 | 0 | 0 | soldunga | -361 | 999999 | 999999 | 999 | 0 | 0 | 0 |
| 1156 | soldungb | 10 | 0 | 0 | 0 | 0 | soldunga | 999999 | -454 | 999999 | 999 | 0 | 0 | 0 |
| 1155 | soldungb | 9 | 0 | 0 | 0 | 0 | soldungc | 780 | -712 | -49 | 256 | 0 | 0 | 0 |
| 1154 | soldungb | 8 | 0 | 0 | 0 | 0 | soldunga | 999999 | -570 | 21 | 999 | 0 | 0 | 0 |
| 1153 | soldungb | 7 | 0 | 0 | 0 | 0 | soldunga | -284 | 999999 | 999999 | 999 | 0 | 0 | 0 |
| 1152 | soldungb | 6 | 0 | 0 | 0 | 0 | soldunga | 999999 | -398 | 999999 | 999 | 0 | 0 | 0 |
| 1151 | soldungb | 5 | 0 | 0 | 0 | 0 | soldunga | -361 | 999999 | 999999 | 999 | 0 | 0 | 0 |
| 1150 | soldungb | 4 | 0 | 0 | 0 | 0 | soldunga | 999999 | -454 | 999999 | 999 | 0 | 0 | 0 |
| 1149 | soldungb | 3 | 0 | 0 | 0 | 0 | soldunga | 999999 | -538 | 999999 | 999 | 0 | 0 | 0 |
| 1148 | soldungb | 2 | 0 | 0 | 0 | 0 | soldunga | 999999 | -495 | 999999 | 999 | 0 | 0 | 0 |
| 1147 | soldungb | 1 | -413 | -265 | -109.8 | 1 | lavastorm | 901.4 | 485.4 | 53.9 | 2.2 | 0 | 0 | 0 |
+------+----------+--------+------+------+--------+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+

can you post your zone fixes as an SQL file ?
 

I to have noticed the zone lines as 9999999 but don't understand it. Also when I zone from freportw to ecommons I end up in the sky somewhere... how do i fix these zonelines. I have changed the target location to safe info I got from doing a /loc. But it didn't seem to work.

Also if someone has fixed these errors can you please post these xonefixes for everyone.