Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-28-2007, 06:01 AM
Amra's Avatar
Amra
Hill Giant
 
Join Date: May 2006
Posts: 117
Default Food

Anyone know what string controls food power? As in snack - miraculous meal. I've been comparing some food items and I can't tell what string it is.

I bet it's right in front of my face

Thanks
Reply With Quote
  #2  
Old 02-01-2008, 08:48 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

Well I am about to earn the "holy necro" title, but I have been curious since day one- how do we control our food/drinks?
Reply With Quote
  #3  
Old 02-01-2008, 09:48 AM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

From the Wiki:
Quote:
casttime

For items that have a castable effect, the cast time of the spell (in milliseconds).
On food/drink items, this determines how long they last before they are consumed:
o -1 - 5: "This is a snack." | "This is a whistle wetter."
o 6 - 20: "This is a meal." | "This is a drink."
o 21 - 30: "This is a hearty meal." | "This is a refreshing drink."
o 31 - 40: "This is a banquet size meal." | "This is a lasting drink."
o 41 - 50: "This meal is a feast!" | "This is a flowing drink!"
o 51 - 60: "This is an enduring meal!" | "This is an enduring drink!"
o 70+: "This is a miraculous meal!" | "This is a miraculous drink!"
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote
  #4  
Old 02-01-2008, 10:14 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

oh nice - that defently wasnt there a year ago =)
thanks!

do you by any chace also know if recastdelay on items now working?
and what do recasttypes mean?
Reply With Quote
  #5  
Old 02-01-2008, 10:21 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

oh do you know what is a diffirence bewten: "casttime" and "casttime_"?
Reply With Quote
  #6  
Old 02-01-2008, 10:33 AM
ChaosSlayer
Demi-God
 
Join Date: May 2007
Posts: 1,032
Default

NM the recast type question.. found it..
Reply With Quote
  #7  
Old 02-01-2008, 10:45 AM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

Quote:
Originally Posted by ChaosSlayer View Post
oh do you know what is a diffirence bewten: "casttime" and "casttime_"?
At first look, they look to be the same (read: redundant). Just to double check, I ran this query:
Code:
SELECT id, name, casttime, casttime_ FROM items WHERE casttime != casttime_
And got no results. Therefore, it is redundant. However, the question then becomes, which is required? That, unfortunately, I don't know.
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote
  #8  
Old 02-01-2008, 11:02 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

The redundancy was my doing, the columns were merged together. When collected from 13th floor, either both columns had an identical value, or one column had a value and the other was 0. There were no exceptions to this, and since our code only uses one of the columns (I'm sorry but for the life I me I can't remember which, though a quick look in the code will answer that) I figured it was best to merge them. So far, the players on TGC haven't reported any errors with casting in this sense so it appears the decision was the right one.
Reply With Quote
Reply


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 03:09 PM.


 

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