Go Back   EQEmulator Home > EQEmulator Forums > General > General::General Discussion

General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #16  
Old 02-22-2016, 12:36 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Quote:
Originally Posted by AdrianD View Post
Glad to see others doing this.

I've always wondered why this wasn't in the standard peq databse.
One size does not fit all. You have a lot of custom servers out there that would have zero use for this. In my case I have a dire need for it. When I first started my server I was having to go and remove drops like the newbie starter gear, if I would have done this from the start I could have just flagged those items for Luclin or LoY, whatever era they came out. Instead I deleted those items, since we are progression I will have to add them back. The next stage, which is a long ways off, is to expose the expansion settings to the quest if there is not already a way to grab that (have not looked). This way you can still use the same NPC quest no matter what era your server is in.
Reply With Quote
  #17  
Old 02-22-2016, 01:17 PM
AdrianD
Discordant
 
Join Date: Dec 2013
Posts: 297
Default

Quote:
One size does not fit all.
Sure thing.

The quests would take quite a bit of work but the same idea can be used. As you, I haven't bothered to try to figure that out yet although, ideas are noted.
Reply With Quote
  #18  
Old 02-28-2016, 12:52 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

After working on this further I have found the spawn table will not just need an end date, it will need an expansion_start and expansion_end both. There are instances when you may have a mob that only existed during a certain period. For the majority of it you can just leave the expansion start for 0 and the end for the last expansion, I am of course defaulting those columns to the first and last expansion. Also picking 99 as a developmental setting. There will be times this will be needed because you are just not ready for the expansion to go live yet, or working midstream, you basically need a staging setting.
Reply With Quote
  #19  
Old 03-11-2016, 10:19 AM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

I have split up my spells by era now, currently putting in Luclin spells. This is working very well and I have not seen any issues. Of course the export utility has to be modified to export the era of spells your server is currently on. I may change the way it is done but I am really thinking of sticking to one set of spells per expansion. There is really not that many spells per expansion and spells were constantly changing. My thinking is just a set of spells per expansion using a compound primary key.

Items are a different story though and I am still not happy with the items table. I wish there was a way to get full list of the items at certain eras. Unlike spells Lucy has no downloads for the items table. No API exist that I can find to download or query their database. Scraping the site would be painstaking the way the history page is for each item. It could be done but it would be horribly tedious to do.
Reply With Quote
  #20  
Old 03-11-2016, 02:01 PM
demonstar55
Demi-God
 
Join Date: Apr 2008
Location: MA
Posts: 1,165
Default

Quote:
Originally Posted by AdrianD View Post
I've always wondered why this wasn't in the standard peq databse.
It's not part of the item packet and is a crap ton of extra work that isn't needed to get shit working.
Reply With Quote
  #21  
Old 03-11-2016, 02:06 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Quote:
Originally Posted by demonstar55 View Post
It's not part of the item packet and is a crap ton of extra work that isn't needed to get shit working.
Correct. The majority of servers do not need this. It is extra work and will make the database much larger, and more complicated. One size does not fit all.
Reply With Quote
  #22  
Old 08-25-2016, 02:19 AM
zhangshen147
Fire Beetle
 
Join Date: Nov 2009
Posts: 17
Default

Quote:
Originally Posted by provocating View Post
Correct. The majority of servers do not need this. It is extra work and will make the database much larger, and more complicated. One size does not fit all.
However, there will be a lot of people need, this is a good project!
Reply With Quote
  #23  
Old 08-25-2016, 07:21 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Sounds like you just volunteered!
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

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


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3