Here's some LoY work for PEQ

[Angelox]

Originally Posted by vales

Wow! Thanks a lot Angelox. Your efforts are much appreciated. Going to give it a shot now.

Oh, I had a question as well. Which version of PEQ's database did you use? They have a new release from July 17th 2006 (Luclin RC1), and I'm not sure what they added or if you're using a much later release since the last release was back in March, iirc. Might want to double check theirs just in case - you might be doing work they've already done. Excluding LoY stuff, of course. :P

I guess that's why I couldn't figure out where to download it (It's posted some where else in IRC) - But no matter anyways, if there isn't any way to source it into what I have, then it's useless to me. I've done a lot of work in a lot of areas (not just what you see posted), and will not start over again.
What they should be doing is posting data that can be sourced into what we have.
I'd much rather find people willing to do what I'm doing. and with good comunication , together we can get a lot more done.

[cannon]

I just sourced the pok.sql (posted by angelox) upgrade pulled from cavedudes db that installed all the doors , mobs ect. into pok. (by the way excellent job, worked great) Do you have a similar file for the LOY and POP zones? I would really appreciate it. I did find your website, but I couldnt figure out how to source the AX_TABLE into my peq database with the cavedude pok.sql > hope im making some sense.

I would like to say thanks to all of the people that make this happen as well. cavedude, angelox, fathernitwit and anyone I didnt mention.

[Angelox]

Originally Posted by cannon

I just sourced the pok.sql (posted by angelox) upgrade pulled from cavedudes db that installed all the doors , mobs ect. into pok. (by the way excellent job, worked great) Do you have a similar file for the LOY and POP zones? I would really appreciate it. I did find your website, but I couldnt figure out how to source the AX_TABLE into my peq database with the cavedude pok.sql > hope im making some sense.

I would like to say thanks to all of the people that make this happen as well. cavedude, angelox, fathernitwit and anyone I didnt mention.

Hi
Actually, I already had POK populated and working , and also had some additional stuff there like a zoner to nexus and some LoY transprotation.
If you're working from a basic PEQ DB, you're probaly better off starting with my DB as a base (as it already uses the PEQ DB as its base). I add CaveDude stuff a little at a time, so I can fix the zones as I go, but haven't latelly becuase I've been working on the older zones.

[cannon]

Ah ok, I got a pretty decent start to a database atm, I tweaked the tutorial zone which had mobs all at the 0 0 0 location and then added the pok books and spawn , doors ect to pok. I sourced the pok_7.0 zip and it worked great. (almost too easy) just wondered if you had something so easy for the LOY zones. I guess I can try to pull them out of cavemans and try it that way. Thanks alot for the quick response. Great work.

[Angelox]

Originally Posted by cannon

Ah ok, I got a pretty decent start to a database atm, I tweaked the tutorial zone which had mobs all at the 0 0 0 location and then added the pok books and spawn , doors ect to pok. I sourced the pok_7.0 zip and it worked great. (almost too easy) just wondered if you had something so easy for the LOY zones. I guess I can try to pull them out of cavemans and try it that way. Thanks alot for the quick response. Great work.

This is old, like my first SQL posts,I still may have the sqls laying around somewhere - I took them off because I was starting to turn everyones database into "memory hogs". At the end, if you're merging data, you'll have to optimize your database; unless you have gigs of RAM to throw away.

[cannon]

When you say optimize the database. I was reading where the gaps in numbers cause for memory loss (dont quote me on this) or something to that effect. Would you suggest sourcing any new info in the open spaces? (example the spawn2 entries that jump from 5000 to 30000 with nothing in between) or does this not matter? Also is there only certain tables that this would effect? I was just wondering if say you had all of the mobs from one zone together in the database in sequence so to say almost like defragmenting a hard drive would this effect the memory usage. I have 1024 ram and dont have much issues at this time. But I would like to be building up the database with all intentions of doing it the most effective way. Guess im getting into a long story that should have been short. Any insight would be helpful. Thanks again for all your help.

[Angelox]

Originally Posted by cannon

When you say optimize the database. I was reading where the gaps in numbers cause for memory loss (dont quote me on this) or something to that effect. Would you suggest sourcing any new info in the open spaces? (example the spawn2 entries that jump from 5000 to 30000 with nothing in between) or does this not matter? Also is there only certain tables that this would effect? I was just wondering if say you had all of the mobs from one zone together in the database in sequence so to say almost like defragmenting a hard drive would this effect the memory usage. I have 1024 ram and dont have much issues at this time. But I would like to be building up the database with all intentions of doing it the most effective way. Guess im getting into a long story that should have been short. Any insight would be helpful. Thanks again for all your help.

What happens is, your DB becomes a big memory hog and eats up a lot of memory - it probably slows down too.
I explained how I optimzed my database here;
http://www.eqemulator.net/forums/sho...455#post125455
and here;
http://www.eqemulator.net/forums/sho...462#post125462

These are just examples of what you need to do - If you can understand what I did, you will have no problem optimizing your DB.