Does anyone want some custom zones?

[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) VALUES
(1468, 'ruja', 1, 1750, -288, -180, 1354, 709, -541.1, 0, 0, 0, 0, 235),
(1469, 'rujb', 2, -83, 1476, -259, 0, 0, -111, 0, 0, 0, 0, 230),
(1470, 'rujb', 1, -83, 1476, -259, 1131, 968, -710, 0, 0, 0, 0, 245),
(1471, 'rujd', 1, 1136, 921, -700, -1423, -2567, -265, 0, 0, 0, 0, 235),
(1472, 'ruje', 2, 4953, -5200, -1000, -5295, -5030, -1063.9, 64, 0, 0, 0, 255),
(1473, 'ruje', 1, -300, 5657, -1000, 270, -4550, -90.3, 0, 0, 0, 0, 265),
(1474, 'rujf', 2, -5570, -5200, -1000, 4831.7, -5269.2, -1061, 192, 0, 0, 0, 250),
(1475, 'rujf', 1, 3900, 5920, -1000, 3342, -5862, -1187, 128, 0, 0, 0, 260),
(1476, 'rujg', 2, 3350, -5888, -1000, 3474, 5862, -1197, 128, 0, 0, 0, 255),
(1477, 'rujg', 1, -5696, 1100, -1000, 5900, 925, -1198, 192, 0, 0, 0, 265),
(1478, 'rujh', 1, 450, -5253, -1000, -178, 5182, -308, 128, 0, 0, 0, 250),
(1479, 'rujh', 2, 6015, 1000, -1000, -5439, 1027, -1141, 92, 0, 0, 0, 260),
(1484, 'rujj', 1, 929, 0, 0, 999999, 910, 999999, 999, 0, 0, 0, 269),
(1485, 'ruji', 1, 929, 0, 0, 999999, 940, 999999, 999, 0, 0, 0, 273);

[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.

[quadroplex]

ahh thanks ironicly lol all idid was use your sql files so i have no idea how that one happened

[quadroplex]

actually the db structure is y,x,z ? Dont uinderstand lol now im really confused

[quadroplex]

Foiund the problem!

All my target_zone fields are set to 0

buffer and targetzone got swapped when i ran the sql queries that was the problem

[quadroplex]

In the screenshots of some of the zones i saw some custom creatures any chance any of those source files are going to be released as well or do the designers of those want to keep those to themselves?

[Scorpious2k]

The only custom creature we used is one that comes with OpenZone. All the rest are eqlive.