EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Server Code Submissions (https://www.eqemulator.org/forums/forumdisplay.php?f=669)
-   -   Class Titles by Level (https://www.eqemulator.org/forums/showthread.php?t=34582)

blackdragonsdg 12-08-2011 03:25 AM
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.

blackdragonsdg 12-09-2011 05:13 PM
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.


All times are GMT -4. The time now is 07:47 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.