Data for revamped zones does not exist in the DB I'm using live. The zoneidnumber is 34 for nro and 10 for freporte.
This particular issue is not a game-breaker. I was hoping someone who uses old zones and has these transitions working properly to chime in with their experience.
The other zone and spawn issues are related to above in that I was hoping someone could share their data for these troubled zones.
What remains of my questions from previous is how things work or the purpose of something, without repeating myself from above.
Thanks for the response.
EDIT: I have a couple of other databases not exactly "peq-style" which I use for reference. I was in the process of taking data from those DB and plugging it into my live peq DB. As can be imagined, this isn't as simple as it sounds. The table schema is different in many cases. The indexes and peq-specific values are causing problems.
What I am trying to do is, take spawn2 coords from a different DB and plug them into the peq DB but only if the npc_types.name exists in both DB and corresponding to those npc_types. The above issue with varying ids is presenting quite a challenge. I've made a few temp tables for this process.
So far, I've been able to assign the spawn2 coords and spawnentry.npcid's properly. I am stuck on plugging in the correct spawngroupid's into a temp spawn2 where the coords already exist. I don't know if it's possible or if I'm using improper syntax. My final results are less than desirable.
If anyone knows what I am trying to do and has experience doing it please respond or PM me.
Thanks
|