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-30-2010, 03:52 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

Quote:
Originally Posted by ChaosSlayerZ View Post
The RestRegenTimeToActivate is in mili seconds, so 30000 is 30 seconds
Looking back through previous posts and the code, I believe Drakelord originally had this in milliseconds when he submitted it, but I changed it to seconds when I comnitted it.

Certainly 434_optional_rest_state_rules.sql has 30 seconds as the default:
Code:
INSERT INTO rule_values VALUES(0,'Character:RestRegenPercent',0);
INSERT INTO rule_values VALUES(0,'Character:RestRegenTimeToActivate',30);
and the default in the code is 30, so this is maybe just a mistake in the PEQ database.

I've not tested it recently, but I am *fairly* sure it is in seconds.

Last edited by Derision; 03-30-2010 at 03:59 PM..
Reply With Quote
  #2  
Old 03-30-2010, 04:08 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Does the PEQ DB not have the notes field in the rules table? The notes fields help a lot and should have answered most of your questions here.

The regen percent is a percentage regen every tick. So, if you want people to gain back 2% of their total health per tick (no matter how many HPs they have), you would set the percentage rule to 2. By setting this rule, you can determine the max amount of time people will need to reset for.

Yes, the time field is in seconds, not milliseconds.

I really don't quite understand all of the experience setting rules, but I would suggest trying it as-is and adjusting as needed.

I am sure some are missing from here now, but here was the original addition of the notes field that I think should make your table a bit easier to understand:

http://code.google.com/p/projecteqem...lues_notes.sql
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #3  
Old 03-30-2010, 04:25 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

Quote:
Originally Posted by trevius View Post
Does the PEQ DB not have the notes field in the rules table? The notes fields help a lot and should have answered most of your questions here.
It does and this is the relevant row which caused the OP the confusion:
Code:
INSERT INTO `rule_values` VALUES ('1', 'Character:RestRegenTimeToActivate', '30000', 'Time in seconds for rest state regen to kick in.');
I think the fact that I changed Drakelord's original code is probably how the 30000 got into the PEQ database instead of 30.
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 06:25 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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3