EQEmulator Forums - Here is cavedudes POK for 7.0

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Here is cavedudes POK for 7.0 (https://www.eqemulator.org/forums/showthread.php?t=21048)

Quote:

Originally Posted by EliteSting

Perhaps Ive been up too long and it's going in one ear and out the other , but how exactly do you take the NPC info of one zone and turn it into a SQL file that someone else can source into thier database ? And how could you do that with NPC loot tables if two people are using the same version database , just giving them a SQL file to be able to update the loot tables of npc's in a particular zone ? I've been trying to come up with a SQL file that can just be sourced into an existing database that updates loot tables that Ive done. I've been working on getting loot tables of zones to be as close to live as I can , but just don't know enough about SQL to get it to work I guess. Thanks in advance for any help !!! It's very much appreciated !

All of this can be done, you just have to navigate these forums better. To me, loot tables are the toughest, but Sesmar also posted a solution to that in this same thread. I think we are all staying cose to live as can be , without packet collectors.
What you need to keep in mind is how to keep your work easy to access. On my last Dulak dump, I easily picked off my loot-table work, since I tagged them all with the zone-id.

tallerin;

Im not sure which it is, i used cavedudes installer with the option for the 7.0 server and the peq database.

You will have to grab cavedudes installer for 0.7.823 for this .SQL to source into the PEQ database. You might have to add the changes to the PEQ databse from the change log but doubt it.

This worked perfectly!!

Thank you Thristam for posting your work, and I'll keep an eye out as you make more planar zones available. Great job!

Jeff

Just installed this on 833. Installed and ran flawlessly. Little surprised that I didn't have to redo any of the changelog fixes. But it aint broke so I aint fixin' it. Very nice work :)

what version of 7.0 is in cavedudes 3.52 installer. that is what i installed with peqs database and cannot get this to merge into my database because of the above mentioned error. Am kind of stumped here

Greg

Quote:

Originally Posted by GregorMc

After you are done with the install and are sure it's all working, next,you have to go here;
http://www.eqemulator.net/download.php
download and manually install the latest binaries - NOTE: you have go through all the changelogs and source in sql lines posted when you see them. If you don't, NOTHING WILL WORK.
If you haven't done this yet, then that's your problem.

That's correct, schema changes since 0.7.0 makes this a bit of a headache. As mentioned you have to run the sql changes since 0.7.0 in the downloads section, one at a time....

GeorgeS

Adjusted for Titanium

I found out when I downloaded the .sql fix for the pok mobs that the updated-for-titanium peq database had more fields than what the original fix had. I fixed the fix, but am not sure where to upload it to share with the community.

I am relatively new to all this, but figured with all the work going on out there, the least I could do was save someone else the time and share the changes. To be more specific on what the error was, I originally got an error that said something along the lines that the number of columns didn't match.

I am using the version of peq that is compatable with Titanium.
Thanks!
Venecha

(Be nice to a n00b)