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.
|