EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Here's some LoY work for PEQ (https://www.eqemulator.org/forums/showthread.php?t=20898)

vales 08-12-2006 06:44 AM

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

Angelox 08-12-2006 07:41 AM

Quote:

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 10-20-2006 05:27 AM

Upgrade
 
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 10-20-2006 05:38 AM

Quote:

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 10-20-2006 09:17 AM

LOY and POP zones
 
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 10-20-2006 09:32 AM

Quote:

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 10-21-2006 01:17 PM

Optimize the database
 
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 10-21-2006 01:51 PM

Quote:

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.

Angelox 12-17-2006 12:46 AM

I'm bumping this "historical" thread , mainly because I'm back to working on these zones.
I've started in Gunthak, and have most quests started , also have stuff like wheels, barrels etc. in place, merchants fixed.
I'm about ready to post what I did, but first I want to complete at least one quest, which is the popular quest for the spell: Temperance.
If I get time today, I'll finish up and post.
If anyone has done/is doing Gunthak work, please say so, as it's pointless to have the same work done twice.

bufferofnewbies 12-17-2006 01:16 AM

Quote:

Originally Posted by Angelox
If anyone has done/is doing Gunthak work, please say so, as it's pointless to have the same work done twice.

I'm pretty sure most agree, when Ang says he is working on LoY zones... we wait for your updates 'just because'.

:)

Would have to be insane to try to do the detail you do on some of them.

Angelox 12-17-2006 12:11 PM

Gunthak Update posted
 
Most quests started, and quest for spell:Temperance finished. Also fixed merchants. placed pottery wheels, and other objects.
Note: It appears quest_globals is broken , the nearest version EqEmu I could find where it works is version 0.7.0-856. Many of my quests use global values, Including the temperance-quest. I suggest you revert to 0.7.0-856, until the quest_globals problem can be solved.

Angelox 12-17-2006 02:11 PM

Degrading to version 0.7.0-856 was not such a good idea; items poof when you zone! I guess I just have to hope for a fix.

Angelox 12-17-2006 03:04 PM

Quote:

Originally Posted by Angelox
Degrading to version 0.7.0-856 was not such a good idea; items poof when you zone! I guess I just have to hope for a fix.

Looking back through the threads, the "item poofing on zone" problem was a MySql5 issue that WildcardX fixed later on. So, if you use MySql4, 0.7.0-856 will work.

cavedude 12-18-2006 01:18 AM

Yeah, MySQL 5.0 shouldn't really be used anyway... 4.0 is still the best.

Angelox 12-18-2006 02:54 AM

Update to quest_globals problem - I spent the morning narrowing this down.
I was wrong about 0.7.0-856
problem with quest_globals starts with this version;
EQEmu-0.7.0-934
==12/03/2006
FatherNitwit: Fixed a few issues related to quest global expiration.
==========
If you use the one before; EQEmu-0.7.0-933, everything works fine.


EDIT:
The "poofing" bug in 0.7.0-856 , is un-related and fixed in 0.7.0-933 , the problem I'm talking about happens in all MySql versions.

Angelox 12-19-2006 11:20 AM

Database updated
 
Many updates and added quests to the LoY zones - also fixed some npcs, faction in these zones - Millius Darkwater (temperance quest) actually is involved in three quests that span through two LoY zones. They are all completed and working with this update.


All times are GMT -4. The time now is 04:28 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.