Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Server Code Submissions

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2011, 03:25 AM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 653
Default Class Titles by Level

This adds the needed level column so that additional titles based on level and class can be used.

zone\titles.cpp
Code:
bool TitleManager::LoadTitles()
{
	Titles.clear();

	TitleEntry Title;

	char errbuf[MYSQL_ERRMSG_SIZE];
	char *query = NULL;
	MYSQL_RES *result;
	MYSQL_ROW row;

	if (!database.RunQuery(query, MakeAnyLenString(&query,
-		"SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `class`, `gender`, "
-		"`char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set` from titles"), errbuf, &result))
+		"SELECT `id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, "
+		"`gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set` from titles"), errbuf, &result))
	{
		LogFile->write(EQEMuLog::Error, "Unable to load titles: %s : %s", query, errbuf);
		safe_delete_array(query);
		return(false);
	}

	safe_delete_array(query);

	while ((row = mysql_fetch_row(result))) {
		Title.TitleID = atoi(row[0]);
		Title.SkillID = (SkillType) atoi(row[1]);
		Title.MinSkillValue = atoi(row[2]);
		Title.MaxSkillValue = atoi(row[3]);
		Title.MinAAPoints = atoi(row[4]);
		Title.MaxAAPoints = atoi(row[5]);
+		Title.Level = atoi(row[6]);
-		Title.Class = atoi(row[6]);
+		Title.Class = atoi(row[7]);
-		Title.Gender = atoi(row[7]);
+		Title.Gender = atoi(row[8]);
-		Title.CharID = atoi(row[8]);
+		Title.CharID = atoi(row[9]);
-		Title.Status = atoi(row[9]);
+		Title.Status = atoi(row[10]);
-		Title.ItemID = atoi(row[10]);
+		Title.ItemID = atoi(row[11]);
-		Title.Prefix = row[11];
+		Title.Prefix = row[12];
-		Title.Suffix = row[12];
+		Title.Suffix = row[13];
-		Title.TitleSet = atoi(row[13]);
+		Title.TitleSet = atoi(row[14]);
		Titles.push_back(Title);
	}
	mysql_free_result(result);

	return(true);
}


bool TitleManager::IsClientEligibleForTitle(Client *c, vector<TitleEntry>::iterator Title)
{
		if((Title->CharID >= 0) && (c->CharacterID() != static_cast<int32>(Title->CharID)))
			return false;

		if((Title->Status >= 0) && (c->Admin() < Title->Status))
			return false;

		if((Title->Gender >= 0) && (c->GetBaseGender() != Title->Gender))
			return false;

+		if((Title->Level >= 0) && (c->GetLevel() < Title->Level))
+			return false;

		if((Title->Class >= 0) && (c->GetBaseClass() != Title->Class))
			return false;

		if((Title->MinAAPoints >= 0) && (c->GetAAPointsSpent() < static_cast<uint32>(Title->MinAAPoints)))
			return false;

		if((Title->MaxAAPoints >= 0) && (c->GetAAPointsSpent() > static_cast<uint32>(Title->MaxAAPoints)))
			return false;

		if(Title->SkillID >= 0)
		{
			if((Title->MinSkillValue >= 0)
			   && (c->GetRawSkill(static_cast<SkillType>(Title->SkillID)) < static_cast<uint32>(Title->MinSkillValue)))
				return false;

			if((Title->MaxSkillValue >= 0)
			   && (c->GetRawSkill(static_cast<SkillType>(Title->SkillID)) > static_cast<uint32>(Title->MaxSkillValue)))
				return false;

		}

		if((Title->ItemID >= 1) && (c->GetInv().HasItem(Title->ItemID, 0, 0xFF) == SLOT_INVALID))
			return false;

      	if((Title->TitleSet > 0) && (!c->CheckTitle(Title->TitleSet)))
         	return false;

		return true;
}

zone\titles.h
Code:
struct TitleEntry
{
	int TitleID;
	int SkillID;
	int MinSkillValue;
	int MaxSkillValue;
	int MinAAPoints;
	int MaxAAPoints;
+	int Level;
	int Class;
	int Gender;
	int CharID;
	int Status;
	int ItemID;
	string Prefix;
	string Suffix;
	int TitleSet;
};
required sql
Code:
ALTER TABLE `titles`  ADD COLUMN `level` INT(11) NOT NULL Default '-1' AFTER `max_aa_points`;
added titles for testing purposes
Code:
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (382, -1, -1, -1, -1, -1, 51, 8, -1, -1, -1, -1, 'Minstrel', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (383, -1, -1, -1, -1, -1, 55, 8, -1, -1, -1, -1, 'Troubadour', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (384, -1, -1, -1, -1, -1, 60, 8, -1, -1, -1, -1, 'Virtuoso', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (385, -1, -1, -1, -1, -1, 65, 8, -1, -1, -1, -1, 'Maestro', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (386, -1, -1, -1, -1, -1, 70, 8, -1, -1, -1, -1, 'Herald', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (387, -1, -1, -1, -1, -1, 75, 8, -1, -1, -1, -1, 'Lyricist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (388, -1, -1, -1, -1, -1, 51, 15, -1, -1, -1, -1, 'Primalist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (389, -1, -1, -1, -1, -1, 55, 15, -1, -1, -1, -1, 'Animist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (390, -1, -1, -1, -1, -1, 60, 15, -1, -1, -1, -1, 'Savage Lord', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (391, -1, -1, -1, -1, -1, 65, 15, -1, -1, -1, -1, 'Feral Lord', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (392, -1, -1, -1, -1, -1, 70, 15, -1, -1, -1, -1, 'Wildblood', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (393, -1, -1, -1, -1, -1, 75, 15, -1, -1, -1, -1, 'Frostblood', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (394, -1, -1, -1, -1, -1, 51, 16, -1, -1, -1, -1, 'Brawler', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (395, -1, -1, -1, -1, -1, 55, 16, -1, -1, -1, -1, 'Vehement', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (396, -1, -1, -1, -1, -1, 60, 16, -1, -1, -1, -1, 'Rager', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (397, -1, -1, -1, -1, -1, 65, 16, -1, -1, -1, -1, 'Fury', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (398, -1, -1, -1, -1, -1, 70, 16, -1, -1, -1, -1, 'Ravager', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (399, -1, -1, -1, -1, -1, 75, 16, -1, -1, -1, -1, 'Juggernaut', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (401, -1, -1, -1, -1, -1, 51, 2, -1, -1, -1, -1, 'Vicar', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (402, -1, -1, -1, -1, -1, 55, 2, -1, -1, -1, -1, 'Templar', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (403, -1, -1, -1, -1, -1, 60, 2, -1, -1, -1, -1, 'High Priest', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (404, -1, -1, -1, -1, -1, 65, 2, -1, -1, -1, -1, 'Archon', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (405, -1, -1, -1, -1, -1, 70, 2, -1, -1, -1, -1, 'Prelate', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (406, -1, -1, -1, -1, -1, 75, 2, -1, -1, -1, -1, 'Exemplar', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (407, -1, -1, -1, -1, -1, 51, 6, -1, -1, -1, -1, 'Wanderer', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (408, -1, -1, -1, -1, -1, 55, 6, -1, -1, -1, -1, 'Preserver', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (409, -1, -1, -1, -1, -1, 60, 6, -1, -1, -1, -1, 'Hierophant', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (410, -1, -1, -1, -1, -1, 65, 6, -1, -1, -1, -1, 'Storm Warden', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (411, -1, -1, -1, -1, -1, 70, 6, -1, -1, -1, -1, 'Natureguard', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (412, -1, -1, -1, -1, -1, 75, 6, -1, -1, -1, -1, 'Storm Caller', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (413, -1, -1, -1, -1, -1, 51, 14, -1, -1, -1, -1, 'Illusionist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (414, -1, -1, -1, -1, -1, 55, 14, -1, -1, -1, -1, 'Beguiler', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (415, -1, -1, -1, -1, -1, 60, 14, -1, -1, -1, -1, 'Phantasmist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (416, -1, -1, -1, -1, -1, 65, 14, -1, -1, -1, -1, 'Coercer', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (417, -1, -1, -1, -1, -1, 70, 14, -1, -1, -1, -1, 'Bedazzler', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (418, -1, -1, -1, -1, -1, 75, 14, -1, -1, -1, -1, 'Entrancer', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (419, -1, -1, -1, -1, -1, 51, 13, -1, -1, -1, -1, 'Elementalist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (420, -1, -1, -1, -1, -1, 55, 13, -1, -1, -1, -1, 'Conjurer', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (421, -1, -1, -1, -1, -1, 60, 13, -1, -1, -1, -1, 'Arch Mage', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (422, -1, -1, -1, -1, -1, 65, 13, -1, -1, -1, -1, 'Arch Convoker', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (423, -1, -1, -1, -1, -1, 70, 13, -1, -1, -1, -1, 'Arch Magus', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (424, -1, -1, -1, -1, -1, 75, 13, -1, -1, -1, -1, 'Grand Summoner', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (425, -1, -1, -1, -1, -1, 51, 7, -1, -1, -1, -1, 'Disciple', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (426, -1, -1, -1, -1, -1, 55, 7, -1, -1, -1, -1, 'Master', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (427, -1, -1, -1, -1, -1, 60, 7, -1, -1, -1, -1, 'Grandmaster', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (428, -1, -1, -1, -1, -1, 65, 7, -1, -1, -1, -1, 'Transcendent', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (429, -1, -1, -1, -1, -1, 70, 7, -1, -1, -1, -1, 'Stone Fist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (430, -1, -1, -1, -1, -1, 75, 7, -1, -1, -1, -1, 'Ashenhand', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (431, -1, -1, -1, -1, -1, 51, 11, -1, -1, -1, -1, 'Heretic', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (432, -1, -1, -1, -1, -1, 55, 11, -1, -1, -1, -1, 'Defiler', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (433, -1, -1, -1, -1, -1, 60, 11, -1, -1, -1, -1, 'Warlock', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (434, -1, -1, -1, -1, -1, 65, 11, -1, -1, -1, -1, 'Arch Lich', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (435, -1, -1, -1, -1, -1, 70, 11, -1, -1, -1, -1, 'Wraith', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (436, -1, -1, -1, -1, -1, 75, 11, -1, -1, -1, -1, 'Deathcaller', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (437, -1, -1, -1, -1, -1, 51, 3, -1, -1, -1, -1, 'Cavalier', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (438, -1, -1, -1, -1, -1, 55, 3, -1, -1, -1, -1, 'Knight', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (439, -1, -1, -1, -1, -1, 60, 3, -1, -1, -1, -1, 'Crusader', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (440, -1, -1, -1, -1, -1, 65, 3, -1, -1, -1, -1, 'Lord Protector', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (441, -1, -1, -1, -1, -1, 70, 3, -1, -1, -1, -1, 'Saint', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (442, -1, -1, -1, -1, -1, 75, 3, -1, -1, -1, -1, 'Holy Defender', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (443, -1, -1, -1, -1, -1, 51, 4, -1, -1, -1, -1, 'Pathfinder', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (444, -1, -1, -1, -1, -1, 55, 4, -1, -1, -1, -1, 'Outrider', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (445, -1, -1, -1, -1, -1, 60, 4, -1, -1, -1, -1, 'Warder', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (446, -1, -1, -1, -1, -1, 65, 4, -1, -1, -1, -1, 'Forest Stalker', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (447, -1, -1, -1, -1, -1, 70, 4, -1, -1, -1, -1, 'Plainswalker', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (448, -1, -1, -1, -1, -1, 75, 4, -1, -1, -1, -1, 'Huntmaster', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (449, -1, -1, -1, -1, -1, 51, 9, -1, -1, -1, -1, 'Rake', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (450, -1, -1, -1, -1, -1, 55, 9, -1, -1, -1, -1, 'Blackguard', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (451, -1, -1, -1, -1, -1, 60, 9, -1, -1, -1, -1, 'Assassin', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (452, -1, -1, -1, -1, -1, 65, 9, -1, -1, -1, -1, 'Deceiver', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (453, -1, -1, -1, -1, -1, 70, 9, -1, -1, -1, -1, 'Nemesis', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (454, -1, -1, -1, -1, -1, 75, 9, -1, -1, -1, -1, 'Shadowblade', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (455, -1, -1, -1, -1, -1, 51, 5, -1, -1, -1, -1, 'Reaver', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (456, -1, -1, -1, -1, -1, 55, 5, -1, -1, -1, -1, 'Revenant', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (457, -1, -1, -1, -1, -1, 60, 5, -1, -1, -1, -1, 'Grave Lord', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (458, -1, -1, -1, -1, -1, 65, 5, -1, -1, -1, -1, 'Dread Lord', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (459, -1, -1, -1, -1, -1, 70, 5, -1, -1, -1, -1, 'Scourge Knight', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (460, -1, -1, -1, -1, -1, 75, 5, -1, -1, -1, -1, 'Bloodreaver', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (461, -1, -1, -1, -1, -1, 51, 10, -1, -1, -1, -1, 'Mystic', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (462, -1, -1, -1, -1, -1, 55, 10, -1, -1, -1, -1, 'Luminary', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (463, -1, -1, -1, -1, -1, 60, 10, -1, -1, -1, -1, 'Oracle', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (464, -1, -1, -1, -1, -1, 65, 10, -1, -1, -1, -1, 'Prophet', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (465, -1, -1, -1, -1, -1, 70, 10, -1, -1, -1, -1, 'Soothsayer', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (466, -1, -1, -1, -1, -1, 75, 10, -1, -1, -1, -1, 'Spiritwatcher', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (467, -1, -1, -1, -1, -1, 51, 1, -1, -1, -1, -1, 'Champion', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (468, -1, -1, -1, -1, -1, 55, 1, -1, -1, -1, -1, 'Myrmidon', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (469, -1, -1, -1, -1, -1, 60, 1, -1, -1, -1, -1, 'Warlord', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (470, -1, -1, -1, -1, -1, 65, 1, -1, -1, -1, -1, 'Overlord', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (471, -1, -1, -1, -1, -1, 70, 1, -1, -1, -1, -1, 'Vanquisher', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (472, -1, -1, -1, -1, -1, 75, 1, -1, -1, -1, -1, 'Imperator', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (473, -1, -1, -1, -1, -1, 51, 12, -1, -1, -1, -1, 'Channeler', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (474, -1, -1, -1, -1, -1, 55, 12, -1, -1, -1, -1, 'Evoker', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (475, -1, -1, -1, -1, -1, 60, 12, -1, -1, -1, -1, 'Sorcerer', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (476, -1, -1, -1, -1, -1, 65, 12, -1, -1, -1, -1, 'Archanist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (477, -1, -1, -1, -1, -1, 70, 12, -1, -1, -1, -1, 'Grand Archanist', '', 0);
INSERT INTO `titles` (`id`, `skill_id`, `min_skill_value`, `max_skill_value`, `min_aa_points`, `max_aa_points`, `level`, `class`, `gender`, `char_id`, `status`, `item_id`, `prefix`, `suffix`, `title_set`) VALUES (478, -1, -1, -1, -1, -1, 75, 12, -1, -1, -1, -1, 'Pyromancer', '', 0);
Worked fine when I tested it but let me know if any changes are needed or any errors are found.
Reply With Quote
  #2  
Old 12-09-2011, 05:13 PM
blackdragonsdg
Dragon
 
Join Date: Dec 2008
Location: Tennessee
Posts: 653
Default

While slaughtering spiders in Velks with my ranger I realized why this was never done. Because it is completely incorrect. I still like the idea but it should be implemented on server by server basis if desired and not project wide. Sorry for the stupid post.

Someone delete all of this.
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 05:47 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