[Scorpious2k]

Originally Posted by quadroplex

INSERT INTO zone_points (id, zone, number, y, x, z, heading, target_y, target_x, target_z, target_heading, zoneinst, target_zone_id, buffer)

In my DB the order is x, y, z and target_x, target_y, target_z. See below:

+-------+------+--------+-------+-------+-------+----------+----------+----------+----------------+---------+----------+--------+----------------+
| id    | zone | number | x     | y     | z     | target_x | target_y | target_z | target_heading | heading | zoneinst | buffer | target_zone_id |
+-------+------+--------+-------+-------+-------+----------+----------+----------+----------------+---------+----------+--------+----------------+
|  1000 | ruja |      1 |  1750 |  -288 |  -180 |     1354 |      709 |   -541.1 |              0 |       0 |        0 |      0 |            235 |
|  1005 | rujb |      1 |   -83 |  1476 |  -259 |     1131 |      968 |     -710 |              0 |       0 |        0 |      0 |            245 |
|  1001 | rujb |      2 |   -83 |  1476 |  -259 |        0 |        0 |     -111 |              0 |       0 |        0 |      0 |            230 |
|  1010 | rujd |      1 |  1136 |   921 |  -700 |    -1423 |    -2567 |     -265 |              0 |       0 |        0 |      0 |            235 |
|  1003 | ruje |      1 |  -300 |  5657 | -1000 |      270 |    -4550 |    -90.3 |              0 |       0 |        0 |      0 |            265 |
|  1002 | ruje |      2 |  4953 | -5200 | -1000 |    -5295 |    -5030 |  -1063.9 |             64 |       0 |        0 |      0 |            255 |
|  1004 | rujf |      2 | -5570 | -5200 | -1000 |   4831.7 |  -5269.2 |    -1061 |            192 |       0 |        0 |      0 |            250 |
|  1006 | rujf |      1 |  3900 |  5920 | -1000 |     3342 |    -5862 |    -1187 |            128 |       0 |        0 |      0 |            260 |
|  1007 | rujg |      2 |  3350 | -5888 | -1000 |     3474 |     5862 |    -1197 |            128 |       0 |        0 |      0 |            255 |
|  1009 | rujg |      1 | -5696 |  1100 | -1000 |     5900 |      925 |    -1198 |            192 |       0 |        0 |      0 |            265 |
|  1013 | rujh |      2 |  6015 |  1000 | -1000 |    -5439 |     1027 |    -1141 |             92 |       0 |        0 |      0 |            260 |
|  1012 | rujh |      1 |   450 | -5253 | -1000 |     -178 |     5182 |     -308 |            128 |       0 |        0 |      0 |            250 |
| 10018 | ruji |      1 |   929 |     0 |     0 |   999999 |      940 |   999999 |            999 |       0 |        0 |      0 |            273 |
| 10019 | rujj |      1 |   929 |     0 |     0 |   999999 |      910 |   999999 |            999 |       0 |        0 |      0 |            269 |
+-------+------+--------+-------+-------+-------+----------+----------+----------+----------------+---------+----------+--------+----------------+

So the x/y and target_x/target_y values need to be reversed.