Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Development
Reload this Page Skill Caps & Item Skill Mods (snippet + SQL)

Development::Development Forum for development topics and for those interested in EQEMu development. (Not a support forum)

Reply
 
Thread Tools Display Modes
  #1  
Old 07-15-2003, 10:13 PM
Wiz
Dragon
  
Join Date: Feb 2002
Posts: 583
Default Skill Caps & Item Skill Mods (snippet + SQL)
This post includes a new GetSkill(), a new CheckIncreaseSkill(), and a new section in the database called skill caps. Note that the DB skill caps in these are not perfectly identic to EQLive, but will need some tweaking if you want it such.

For client.h
Code:
    inline int16	GetSkill(int skill_id, bool item_skill_mod = false) { assert(skill_id >= 0 && skill_id < 74); if (pp.skills[skill_id + 1] > 250) pp.skills[skill_id + 1] = 0; if (item_skill_mod) return pp.skills[skill_id + 1] + GetItemSkillMod(skill_id); else return pp.skills[skill_id + 1]; }
int16	GetSkillCap(int8 skillid);
For client.cpp

Code:
bool Client::CheckIncreaseSkill(int16 skillid, sint16 chancemod)
{
	if (GetSkill(skillid,false) < GetSkillCap(skillid))
	{
		if (rand()%100 < (5+chancemod))
		{
			SetSkill(skillid,GetSkill(skillid)+1);
			return true;
		}
	}
	else if (GetSkill(skillid,false) > GetSkillCap(skillid))
	{
		SetSkill(skillid,GetSkillCap(skillid));
	}
	return false;
}

int16 Client::GetSkillCap(int8 skillid)
{
	int8 skill_level = 0, skill_formula = 0;
	int16 base_cap = 0, skill_cap = 0, skill_cap2 = 0;
	char errbuf[MYSQL_ERRMSG_SIZE];
	char *query = 0;
	int32	affected_rows = 0;
	MYSQL_RES *result;
	MYSQL_ROW row;	
	//Fetch the data from DB.
	if (database.RunQuery(query, MakeAnyLenString(&query, "SELECT level, formula, pre50cap, post50cap from skillcaps where skill = %i && class = %i", skillid, GetClass()), errbuf, &result, &affected_rows))
	{
		if (affected_rows == 0)
		{
			delete[] query;
			mysql_free_result(result);
			return 0;
		}
		row = mysql_fetch_row(result);
		skill_level = atoi(row[0]);
		skill_formula = atoi(row[1]);
		skill_cap = atoi(row[2]);
		if (atoi(row[3]) > skill_cap)
			skill_cap2 = (atoi(row[3])-skill_cap)/10; //Split the post-50 skill cap into difference between pre-50 cap and post-50 cap / 10 to determine amount of points per level.
		delete[] query;
		mysql_free_result(result);
	}
	else
		return 0;
	//Too low level for this skill?
	if (GetLevel() < skill_level)
		return 0;
	//Determine pre-51 level-based cap
	base_cap = GetLevel()*skill_formula+skill_formula;
	if (base_cap > skill_cap)
		base_cap = skill_cap;
	//If post 50, add post 50 cap to base cap.
	if (GetLevel() > 50 && skill_cap2 > 0)
		base_cap += skill_cap2*(GetLevel()-50);
	//Base cap is now the max value at the person's level, return it!
	return base_cap;
}
A quick guide to the DB: Class and skill are self-explainatory. Level is the level the class gets the skill at. Formula is the formula*formula+formula that constitutes the pre-51 per level cap. pre50cap is the max cap previous to level 51+, post50cap is the level 60 cap, the difference between which and the pre50cap is split over the 51-60 levels. (So with a 200 pre50 and 250 post50, the max of the skill at 51 is 205)

SQL sourced:

Code:
CREATE TABLE skillcaps (
  class tinyint(2) NOT NULL default '',
  skill smallint(4) NOT NULL default '',
  level tinyint(2) NOT NULL default '',
  formula tinyint(2) NOT NULL default '',
  pre50cap smallint(4) NOT NULL default '',
  post50cap smallint(4) NOT NULL default ''
) TYPE=MyISAM;

INSERT INTO skillcaps VALUES (1, 0, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 1, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 2, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 3, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 7, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (1, 15, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 28, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 30, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 33, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 36, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 73, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 51, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (1, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (1, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (1, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (1, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (1, 10, 6, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 19, 6, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 34, 10, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 22, 13, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 20, 15, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 37, 35, 5, 200, 250);
INSERT INTO skillcaps VALUES (1, 16, 35, 5, 200, 200);


INSERT INTO skillcaps VALUES (2, 0, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (2, 2, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (2, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (2, 15, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (2, 28, 1, 4, 110, 150);
INSERT INTO skillcaps VALUES (2, 33, 1, 4, 150, 190);
INSERT INTO skillcaps VALUES (2, 4, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (2, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (2, 14, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (2, 18, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (2, 24, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (2, 13, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (2, 31, 8, 5, 200, 250);
INSERT INTO skillcaps VALUES (2, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (2, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (2, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (2, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (2, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (2, 10, 25, 4, 150, 200);
INSERT INTO skillcaps VALUES (2, 19, 10, 4, 120, 180);
INSERT INTO skillcaps VALUES (2, 43, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (2, 44, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (2, 45, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (2, 46, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (2, 47, 30, 4, 150, 200);

INSERT INTO skillcaps VALUES (3, 0, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 1, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 2, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 3, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 7, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (3, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (3, 15, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 28, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 30, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 33, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (3, 36, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 73, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (3, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (3, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (3, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (3, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (3, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (3, 10, 6, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 19, 10, 5, 175, 225);
INSERT INTO skillcaps VALUES (3, 34, 17, 5, 175, 225);
INSERT INTO skillcaps VALUES (3, 20, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 37, 30, 5, 175, 225);
INSERT INTO skillcaps VALUES (3, 16, 40, 5, 80, 80);
INSERT INTO skillcaps VALUES (3, 4, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 5, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 14, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 18, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 24, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 13, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (3, 31, 12, 5, 200, 250);

INSERT INTO skillcaps VALUES (4, 0, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 1, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 2, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 3, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 7, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (4, 15, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (4, 28, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 30, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 33, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 36, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 73, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (4, 53, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (4, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (4, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (4, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (4, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (4, 27, 3, 5, 200, 200);
INSERT INTO skillcaps VALUES (4, 10, 6, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 19, 10, 5, 175, 225);
INSERT INTO skillcaps VALUES (4, 42, 10, 5, 75, 75);
INSERT INTO skillcaps VALUES (4, 34, 17, 5, 175, 225);
INSERT INTO skillcaps VALUES (4, 22, 17, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 20, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 29, 25, 5, 75, 75);
INSERT INTO skillcaps VALUES (4, 37, 30, 5, 175, 225);
INSERT INTO skillcaps VALUES (4, 16, 40, 5, 120, 120);
INSERT INTO skillcaps VALUES (4, 4, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 5, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 14, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 18, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 24, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 13, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (4, 31, 12, 5, 200, 250);

INSERT INTO skillcaps VALUES (5, 0, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 1, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 2, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 3, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 7, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (5, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (5, 15, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 28, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 30, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 33, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (5, 36, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 73, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (5, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (5, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (5, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (5, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (5, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (5, 10, 6, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 19, 10, 5, 175, 225);
INSERT INTO skillcaps VALUES (5, 34, 17, 5, 175, 225);
INSERT INTO skillcaps VALUES (5, 20, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 37, 30, 5, 175, 225);
INSERT INTO skillcaps VALUES (5, 16, 40, 5, 80, 80);
INSERT INTO skillcaps VALUES (5, 4, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 5, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 14, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 18, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 24, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 13, 9, 5, 200, 250);
INSERT INTO skillcaps VALUES (5, 31, 12, 5, 200, 250);

INSERT INTO skillcaps VALUES (6, 0, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (6, 2, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (6, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (6, 15, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (6, 28, 1, 4, 110, 150);
INSERT INTO skillcaps VALUES (6, 33, 1, 4, 150, 190);
INSERT INTO skillcaps VALUES (6, 4, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (6, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (6, 14, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (6, 18, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (6, 24, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (6, 13, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (6, 31, 8, 5, 200, 250);
INSERT INTO skillcaps VALUES (6, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (6, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (6, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (6, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (6, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (6, 27, 15, 4, 150, 200);
INSERT INTO skillcaps VALUES (6, 53, 20, 4, 150, 200);
INSERT INTO skillcaps VALUES (6, 19, 10, 4, 120, 180);
INSERT INTO skillcaps VALUES (6, 43, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (6, 44, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (6, 45, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (6, 46, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (6, 47, 30, 4, 150, 200);

INSERT INTO skillcaps VALUES (7, 0, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 2, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 9, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 15, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 19, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 22, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 28, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 30, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 32, 1, 5, 100, 100);
INSERT INTO skillcaps VALUES (7, 33, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 51, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 39, 3, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 38, 5, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 42, 8, 5, 75, 75);
INSERT INTO skillcaps VALUES (7, 52, 10, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 11, 12, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 20, 15, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 25, 17, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 71, 18, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 23, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 21, 25, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 16, 25, 5, 200, 200);
INSERT INTO skillcaps VALUES (7, 26, 30, 5, 200, 250);
INSERT INTO skillcaps VALUES (7, 37, 35, 5, 175, 225);
INSERT INTO skillcaps VALUES (7, 27, 12, 5, 50, 50);

INSERT INTO skillcaps VALUES (8, 0, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (8, 1, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (8, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (8, 15, 1, 4, 150, 200);
INSERT INTO skillcaps VALUES (8, 28, 1, 4, 150, 200);
INSERT INTO skillcaps VALUES (8, 33, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (8, 36, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (8, 51, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (8, 41, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (8, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (8, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (8, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (8, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (8, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (8, 70, 5, 5, 200, 250);
INSERT INTO skillcaps VALUES (8, 49, 49, 8, 200, 250);
INSERT INTO skillcaps VALUES (8, 19, 10, 5, 175, 225);
INSERT INTO skillcaps VALUES (8, 31, 10, 3, 100, 130);
INSERT INTO skillcaps VALUES (8, 12, 11, 5, 200, 250);
INSERT INTO skillcaps VALUES (8, 27, 12, 5, 50, 50);
INSERT INTO skillcaps VALUES (8, 54, 14, 5, 200, 250);
INSERT INTO skillcaps VALUES (8, 22, 17, 5, 200, 250);
INSERT INTO skillcaps VALUES (8, 42, 17, 5, 75, 75);
INSERT INTO skillcaps VALUES (8, 62, 20, 5, 70, 120);
INSERT INTO skillcaps VALUES (8, 39, 24, 5, 50, 50);
INSERT INTO skillcaps VALUES (8, 29, 25, 5, 75, 75);
INSERT INTO skillcaps VALUES (8, 71, 26, 5, 75, 75);
INSERT INTO skillcaps VALUES (8, 17, 30, 5, 70, 120);
INSERT INTO skillcaps VALUES (8, 53, 35, 5, 70, 120);
INSERT INTO skillcaps VALUES (8, 35, 40, 5, 70, 120);
INSERT INTO skillcaps VALUES (8, 34, 53, 5, 175, 175);
INSERT INTO skillcaps VALUES (8, 37, 53, 5, 150, 150);

INSERT INTO skillcaps VALUES (9, 0, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 1, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 7, 1, 5, 150, 200);
INSERT INTO skillcaps VALUES (9, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (9, 15, 1, 5, 175, 225);
INSERT INTO skillcaps VALUES (9, 28, 1, 5, 150, 200);
INSERT INTO skillcaps VALUES (9, 33, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 36, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 51, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 42, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 29, 3, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 19, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 35, 6, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 62, 6, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 8, 10, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 34, 12, 5, 175, 225);
INSERT INTO skillcaps VALUES (9, 39, 12, 5, 75, 75);
INSERT INTO skillcaps VALUES (9, 22, 13, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 20, 15, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 6, 18, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 56, 20, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 17, 21, 5, 200, 250);
INSERT INTO skillcaps VALUES (9, 71, 22, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 16, 27, 5, 200, 200);
INSERT INTO skillcaps VALUES (9, 37, 30, 5, 175, 225);

INSERT INTO skillcaps VALUES (10, 0, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (10, 2, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (10, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (10, 15, 1, 4, 140, 190);
INSERT INTO skillcaps VALUES (10, 28, 1, 4, 110, 150);
INSERT INTO skillcaps VALUES (10, 33, 1, 4, 150, 190);
INSERT INTO skillcaps VALUES (10, 4, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (10, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (10, 14, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (10, 18, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (10, 24, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (10, 13, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (10, 31, 8, 5, 200, 250);
INSERT INTO skillcaps VALUES (10, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (10, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (10, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (10, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (10, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (10, 59, 25, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 19, 10, 4, 140, 190);
INSERT INTO skillcaps VALUES (10, 43, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (10, 44, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (10, 45, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (10, 46, 30, 4, 150, 200);
INSERT INTO skillcaps VALUES (10, 47, 30, 4, 150, 200);

INSERT INTO skillcaps VALUES (11, 0, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (11, 2, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (11, 36, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (11, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (11, 15, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (11, 28, 1, 3, 90, 120);
INSERT INTO skillcaps VALUES (11, 33, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (11, 4, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 14, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 18, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 24, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 13, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 31, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (11, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (11, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (11, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (11, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (11, 19, 22, 3, 120, 150);
INSERT INTO skillcaps VALUES (11, 43, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 44, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 45, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 46, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 47, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (11, 58, 16, 0, 250, 250);

INSERT INTO skillcaps VALUES (12, 0, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (12, 2, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (12, 36, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (12, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (12, 15, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (12, 28, 1, 3, 90, 120);
INSERT INTO skillcaps VALUES (12, 33, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (12, 4, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 14, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 18, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 24, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 13, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 31, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (12, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (12, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (12, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (12, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (12, 19, 22, 3, 120, 150);
INSERT INTO skillcaps VALUES (12, 43, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 44, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 45, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 46, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 47, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (12, 58, 16, 0, 250, 250);

INSERT INTO skillcaps VALUES (13, 0, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (13, 2, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (13, 36, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (13, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (13, 15, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (13, 28, 1, 3, 90, 120);
INSERT INTO skillcaps VALUES (13, 33, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (13, 4, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 14, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 18, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 24, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 13, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 31, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (13, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (13, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (13, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (13, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (13, 19, 22, 3, 120, 150);
INSERT INTO skillcaps VALUES (13, 43, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 44, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 45, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 46, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 47, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (13, 58, 16, 0, 250, 250);

INSERT INTO skillcaps VALUES (14, 0, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (14, 2, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (14, 36, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (14, 9, 1, 5, 100, 150);
INSERT INTO skillcaps VALUES (14, 15, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (14, 28, 1, 3, 90, 120);
INSERT INTO skillcaps VALUES (14, 33, 1, 3, 120, 150);
INSERT INTO skillcaps VALUES (14, 4, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 5, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 14, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 18, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 24, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 13, 1, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 31, 4, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 67, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (14, 66, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (14, 55, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (14, 50, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (14, 40, 1, 5, 200, 200);
INSERT INTO skillcaps VALUES (14, 19, 22, 3, 120, 150);
INSERT INTO skillcaps VALUES (14, 43, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 44, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 45, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 46, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 47, 20, 5, 200, 250);
INSERT INTO skillcaps VALUES (14, 58, 16, 0, 250, 250);

# Trade skills;
INSERT INTO skillcaps VALUES (1, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (1, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (1, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (1, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (1, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (1, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (1, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (2, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (2, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (2, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (2, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (2, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (2, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (2, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (3, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (3, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (3, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (3, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (3, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (3, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (3, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (4, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (4, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (4, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (4, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (4, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (4, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (4, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (5, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (5, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (5, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (5, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (5, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (5, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (5, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (6, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (6, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (6, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (6, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (6, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (6, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (6, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (7, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (7, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (7, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (7, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (7, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (7, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (7, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (8, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (8, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (8, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (8, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (8, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (8, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (8, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (9, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (10, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (11, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (11, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (11, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (11, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (11, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (11, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (11, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (12, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (12, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (12, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (12, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (12, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (12, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (12, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (13, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (13, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (13, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (13, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (13, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (13, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (13, 61, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (14, 60, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (14, 63, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (14, 65, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (14, 64, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (14, 68, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (14, 69, 1, 0, 250, 250);
INSERT INTO skillcaps VALUES (14, 61, 1, 0, 250, 250);
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 02:48 PM.

EQEmulator - Archive - Top

 

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