Quote:
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?
|
I have been able to insert data from the other DB through a process referred to as mapping. It's quite a process but, not as involved as what I was trying to do with futility. I was trying to get a bit more precise in combining data from both databases than I have knowledge of sql or that is even possible in sql.
The result, although, is not perfect, as I was expecting. Lavastorm has npcs on solid ground and none in the underworld that I can tell. This zone still needs work but, that will be for a time when I can tolerate massive tedium.
Nektulos, on the other hand, had a mixed bag of results. Some were improvements, some a wash and some would create more work than the previous data. Of course, I only tested this on the live DB so nothing was permanent. This basically leads me to where I was, seeking a willing, generous person to share this specific DB information.
I'd still like to know what the purpose of `underworld` is and the function of the rules stated in 3/4 in the OP.
Thanks for reading as it seems that is all that's being done here.