Does anyone want some custom zones?

[quadroplex]

Im having some issues with manhattan, juno and nektropos and Tutorialb...

The zone lines when you hit them try zoning me into "Unknown zone" and puts me back to the zone in point of the zone im in, and sometimes right on the zoneline causing a neverending loop of zoning...

[Scorpious2k]

Originally Posted by quadroplex

Im having some issues with manhattan, juno and nektropos and Tutorialb...

The zone lines when you hit them try zoning me into "Unknown zone" and puts me back to the zone in point of the zone im in, and sometimes right on the zoneline causing a neverending loop of zoning...

Did you restart the server and making the changes?

Can you paste the numbers from the DB - select * from zone_points where zone like 'ruj%';

That would give manhattan and juno (and others) if you used the same zones we did.

[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