Help to get all Zones Working Perfect

[radcode]

Hi everyone.
Like many of you I've been playing around with different versions of EQEmu and different databases. You run this patch and that fix and they all seem to fix one thing and break the other. So many times I already deleted my database and started from scratch. Lately I've been on a mission to get all the zones to work properly so I made new database only with the zone related tables.

zone, zone_points and zonepoints_raw

My hope is to get all zone lines, coordinates and direction facing at zoning squared away. All other things like items, spawns and other crap can be customized based on specific preference. But as a base to having good server you need to have working zone points so that when your friend plays, he/she doesn't get warped under world or drops from sky and dies at the zone. After all the experimenting I think this is the way tables should be working.

1) table 'zone' defines short/long names safe coordinates which are x,y,z and probably would be nicer if they would be y,x,z to avoid confusion, since in-game they should coordinates as y,x,z

(often I've seen that after zoning I would end up at safe coords rather then one in zone_points table.)

2) table 'zone_points' I believe should be working as (zonename warping from), (zone line y,x,z ), (zonename warping to),(y,x,z,(face direction y,x)

3) table 'zonepoints_raw' I believe actual data that defines zone lines, borders e.t.c I am still not sure how to mess around with that since the data seems to be encrypted.

So I am hoping (with some help) to get these things straightened out and perhapse with couple people (who are willing ) to test all zones/ zonepoings and get all dafenitions for zoning put into a clean good database. Then we can do test and post it here and work on next part.

I am also hoping to get boats to work, though I realize that we'll probably need at least port zones running in real-time. Or so I think for the boats to work they way they do on real EQ server since they're running on schedule. If that can't be done without real-time each zone emulation then maybe get translocators working at the docks where the boats supposed to be so that each zone can be traveled to without the need to use #zone.

Thanks ahead of time for all the assistance.