I was going through sql, I had an idea...
mysql> select * from zone_points where target_zone = 'vexthal';
+-----+--------+--------+---+---+---+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
| id | zone | number | y | x | z | heading | target_zone | target_y | target_x | target_z | target_heading | keep_x | keep_y | zoneinst |
+-----+--------+--------+---+---+---+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
| 785 | umbral | 45 | 0 | 0 | 0 | 0 | vexthal | 216 | -1664 | -35 | 2 | 0 | 0 | 0 |
+-----+--------+--------+---+---+---+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
1 row in set (0.00 sec)
mysql> select * from zone_points where target_zone = 'qrg';
+-----+------------+--------+---+---+---+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
| id | zone | number | y | x | z | heading | target_zone | target_y | target_x | target_z | target_heading | keep_x | keep_y | zoneinst |
+-----+------------+--------+---+---+---+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
| 704 | qeytoqrg | 4 | 0 | 0 | 0 | 0 | qrg | -611 | 114 | 5 | 999 | 0 | 0 | 0 |
| 645 | jaggedpine | 1 | 0 | 0 | 0 | 0 | qrg | 56 | -510 | 42 | 256 | 0 | 0 | 0 |
+-----+------------+--------+---+---+---+---------+-------------+----------+----------+----------+----------------+--------+--------+----------+
2 rows in set (0.00 sec)
If I were to change zone id 785 in umbral plains to be target zone qrg -611 114 5 in the appropriate x/y/z collumns like when zoning from 'qeytoqrg', would that turn the UP/VT zone to UP/Qrg?
Just a thought.
|