Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Development

Archive::Development Archive area for Development's posts that were moved here after an inactivity period of 90 days.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-25-2002, 05:44 AM
Wiz
Dragon
 
Join Date: Feb 2002
Posts: 583
Default

What'd I'd need help with is data collection and insertion, obviously. Ergo:

BLOCK:

MONK skillcap: 1-50 Level*5+5 and whatever it is above 50
BEASTLORD: whatever they have
ELSE: 0

As for data insertion, the format will be:

CREATE TABLE skillcap (
class int(10) NOT NULL default '0',
level int(10) NOT NULL default '0',
skill int(10) NOT NULL default '0',
amount int(10) NOT NULL default '0',
) TYPE=MyISAM;

or so, so a data entry for level 1 block for a monk would be

INSERT INTO skillcap VALUES(7,1,11,10);

so it's a huge fucking DB. Alternatively, might be able to kill the level and have some kinda formula... like this

CREATE TABLE skillcap (
class int(10) NOT NULL default '0',
skill int(10) NOT NULL default '0',
formula varchar(40) NOT NULL default '',
max int(10) NOT NULL default '0',
) TYPE=MyISAM;

INSERT INTO skillcap VALUES(7,11,"level*5+5",200);

but it'd be kinda limited for skills that only get 1 per level after 50 and such.
Reply With Quote
 


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 05:17 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