General: zone_points, spawn2, grid, pathing issues

[AdrianD]

Various issues familiar to many, no doubt. I've searched and read up on these but resolution has been elusive.

I use old zones and I'm trying to build a classic DB. I updated everything except the DB about a month ago.

I'll paste my notes and follow them with comments/questions:

1. Zoning

	
ToDo: Figure out zone_points for nro/efp

		nro 4160, 280, -24, 0, -1275, -700, -50, 254
		fre-1200, -670, -50, 0, 3875, 380, -27, 128
			y,x,z,heading		y,x,z,heading
		(lack of continuity with coordinates is inefficient)

I've fixed many other zones but, I'm stuck on this. I zone to the same spot no matter where I come from. Both directions.

Zone_points nro/oasis still messed up - put z at 999999 and its a little better but still get stuck
	- put y and target_y closer together - little better not fixed

'oasis', 2535, -765, 7, 0, -1856, 999999, 999999, 0
'nro', -1876, -765, 7, 0, 2515, 999999, 999999, 134
	y,x,z,heading		y,x,z,heading

A majority portion of zoning is fine but some areas I get stuck under the terrain.

** Fixed

2. Spawn/Grid

ToDo: look into lavastorm spawn and grid stuff - check eqclassic DB
	- eqclassic table schema is different - easy fix
	- eqclassic data is vastly different - spawngroupid's
		- I don't think queries would line up eqclassic coords with peq ids at the scale I need
		- I'm also not sure how accurate the coords are

The npcs show up on track but I can not see any on the map. I know the spawn2 table has values for the newer zone. I would like to get data for the old zone. Where can I find this?

ToDo: look into nektulos spawn and grid stuff - spawn2 has two versions - version 0 uses old zone
	- changed spawn2 query and added `where version = 0` - commented out for now - looking into weird spawn occurances
	- can't attack many npcs
	- spawn2 points are both to low or too high by up to ~20
	- is there a way to #spawnfix an entire zone; same with grid_entries

Nektulos is in much better shape than lavastorm. There are many spawns and grids which are in bad shape but, most of the data is salvageable, in my opinion. Replacing the data would be easier if it's available. Like my notes say: is there a way to #spawnfix an entire zone so the npcs spawn on "solid ground" and take to their grids on solid ground?

3. Possibly relating to #2 - four rules each ruleset

rule_values of `Map:FixPathingZMaxDeltaXXX..` from 12 to 20 and 45 to match what was shown on the wiki
	- I don't know what this does but it sounds like it could correct bad spawn2/grid
	- I still don't know what this does and I didn't notice a difference

4. Is the underworld like the bottom of the ocean? What issues does changing the underworld value help to resolve?

For every issue I bring here, I fix ten on my own. I have notes for everything. I admit I am running out of things to fix on my own. Most of these issues have been present for months or since I started back in March of 2014. I don't want you to think I'm being lazy.

Thanks