Alright well with a combination of information I managed to set a different starting point for new players (woot). I am going to delve into setting NPCs and such now... You're sure right there's a lot of information out there.
I was steamed last night when NOTHING I did was fixing the database to at least work the way it had before toying with it. I even did a fresh clean download and install with winCVS of fresh database files which caused zone.exe to error on tables that were sourced and existed in the database (npc factions).
I ended up sourcing a dump of my old database from when I transfered this lil project from a different computer over to a dedicated always-online machine. This dump seemed to have fixed the problem and the database now runs again (thank god my father taught me to always back stuff up from the time I was 3 to 21).
Now.. zone.exe seems to take longer loading the loot tables.. but eventually gets through it and I'm not going to complain.. an extra minute or so on loading up the server shouldn't be a problem especially if i end up loading a lot more into it later on =)
Thank you for all your patience folks, I appreciate it and will look through these links for any info that might help me in my endeavor to not screw up another database! lol.
|