List of skill caps

[Wiz]

I'm thinking of compiling a DB of skill caps, sorted by level and class. The EQemu skill caps are kinda scattered, and integrated into the code, making them hard to modify.

What's the interest for this? And also, who could consider helping out? In most cases, it's simple enough, but the caps do vary a lot, especially after 50.

[tamarae]

I'd be willing to help out with this as I am able.

Edit: I can put them into a csv file or something for you to manipulate as you wish if ya like. Maybe that would be some help to ya?

[Wiz]

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.

[tamarae]

Oky, I understand for the most part what you've posted so far.

Here's the drawbacks to my being a dummy.

A.) I've never messed much with databases, or mysql, but I really want to learn.
B.) I do have a high capacity to learn quickly (a plus!)
C.) Where do you find the equation for the skillcaps for each class? (I've only ever seen posted in my meager looking about a max skillcap for each skill for up to level 50 and then 50+)
D.) How do I get started?

I know, I'm such a n00b, but all us n00bs started somewhere, right? If you're willing to teach a bit, I'm more than willing to learn and help ya out some. If not, no biggie either.

[Wiz]

A) Just get me the skill data, SQL is easy anyways.
B) Good. :p
C) eq.castersrealm.com... other eq fansites like monkly business maybe. There's no collected effort like this, which makes it harder. :\
D) Get the max of all skills from castersrealm per class, for starters... the absolute max. Then try to break it down as per level.

[tamarae]

I'll see what I can put together this afternoon later. First, must finish my gimpy perl script for class... then the afternoon is all mine!

[tamarae]

Here's another question:

Did skill caps change with PoP? I know max levels did.

[Wiz]

They did, but let's limit this to L60.

[tamarae]

Here's what I've collected so far for you. Info sources are cited in the spreadsheet. I'll post up more as I get it, but maybe this will give ya something to start working with in the meantime.

[tamarae]

Hey Wiz.. I'm having no luck finding the other classes listed anywhere to produce more information. Been looking for several days now. :(

I'll keep looking.

[Wiz]

Been away for a bit, getting back on this now. Thanks for your help sofar!