I was searching the codes related to a class for each craracter, but i didnt found it.
So, a like to share mi own script whit you (php to make rankings like, top level, pvp, pk, etc)
Here it is:
First: get data from your database:
Code: Select all
//invoque a conection from your databas first!!, using: mysql_connect() ...$query = "SELECT pj.char_name as char_name, pj.level as level, pj.classid as classid, clan.clan_name as clan_name, clan.ally_name as ally_name, clan.crest_id as pcrest, clan.ally_crest_id as acrest FROM characters pj LEFT JOIN clan_data clan ON pj.clanid = clan.clan_id LEFT JOIN accounts acc ON pj.account_name = acc.login WHERE pj.accesslevel <1 AND acc.accessLevel NOT IN (-100) ORDER BY pj.level DESC, pj.exp DESC LIMIT 20"; $result=mysql_query($query); $num=mysql_num_rows($result); for ($i=0; $i<$num; $i++) { $row=mysql_fetch_array($result); $nick=$row["char_name"]; $raza=$row["classid"]; //This variable is used on this example $clan=$row["clan_name"]; $ally=$row["ally_name"]; $LVL=$row["level"]; $clan_crest_id = $row["pcrest"]; $ally_crest_id = $row["acrest"]; ?>
Code: Select all
<? switch($raza) { //HUMANS case 0: $clase='Human Fighter'; break; case 1: $clase='Human Warrior'; break; case 2: $clase='Gladiator'; break; case 3: $clase='Warlord'; break; case 4: $clase='Human Knight'; break; case 5: $clase='Paladin'; break; case 6: $clase='Dark Avenger'; break; case 7: $clase='Rogue'; break; case 8: $clase='Treasure Hunter'; break; case 9: $clase='Hawkeye'; break; case 10: $clase='Human Mage'; break; case 11: $clase='Human Wizard'; break; case 12: $clase='Sorcerer'; break; case 13: $clase='Necromancer'; break; case 14: $clase='Warlock'; break; case 15: $clase='Cleric'; break; case 16: $clase='Bishop'; break; case 17: $clase='Prophet'; break; //ELVES case 18: $clase='Elven Fighter'; break; case 19: $clase='Elven Knight'; break; case 20: $clase='Temple Knight'; break; case 21: $clase='Swordsinger'; break; case 22: $clase='Elven Scout'; break; case 23: $clase='Plainswalker'; break; case 24: $clase='Silver Ranger'; break; case 25: $clase='Elven Mage'; break; case 26: $clase='Elven Wizard'; break; case 27: $clase='Spellsinger'; break; case 28: $clase='Elemental Summoner'; break; case 29: $clase='Elven Oracle'; break; case 30: $clase='Elven Elder'; break; //DARK ELVES case 31: $clase='Dark Elven Fighter'; break; case 32: $clase='Pallus Knight'; break; case 33: $clase='Shillien Knight'; break; case 34: $clase='Bladedancer'; break; case 35: $clase='Assasin'; break; case 36: $clase='Abyss Walker'; break; case 37: $clase='Phantom Ranger'; break; case 38: $clase='Dark Elven Mage'; break; case 39: $clase='Dark Wizard'; break; case 40: $clase='Spellhowler'; break; case 41: $clase='Phantom Summoner'; break; case 42: $clase='Shillien Oracle'; break; case 43: $clase='Shillien Elder'; break; //ORCS case 44: $clase='Orc Fighter'; break; case 45: $clase='Orc Raider'; break; case 46: $clase='Destroyer'; break; case 47: $clase='Monk'; break; case 48: $clase='Tyrant'; break; case 49: $clase='Orc Mage'; break; case 50: $clase='Orc Shaman'; break; case 51: $clase='Overlord'; break; case 52: $clase='Warcryer'; break; //DWARVES case 53: $clase='Dwarven Fighter'; break; case 54: $clase='Scavenger'; break; case 55: $clase='Bounty Hunter'; break; case 56: $clase='Artisan'; break; case 57: $clase='Warsmith'; break; //HUMANS 3rd Professions case 88: $clase='Duelist'; break; case 89: $clase='Dread Nought'; break; case 90: $clase='Phoenix Knight'; break; case 91: $clase='Hell Knight'; break; case 92: $clase='Sagittarius'; break; case 93: $clase='Adventurer'; break; case 94: $clase='Archmage'; break; case 95: $clase='Soul Traker'; break; case 96: $clase='Arcane Lord'; break; case 97: $clase='Cardinal'; break; case 98: $clase='Hierophant'; break; //ELVES 3rd Professions case 99: $clase='Evas Templar'; break; case 100: $clase='Sword Muse'; break; case 101: $clase='Wind Rider'; break; case 102: $clase='Moonlight Sentinel'; break; case 103: $clase='Mystic Muse'; break; case 104: $clase='Elemental Master'; break; case 105: $clase='Evas Saint'; break; //DARK ELVES 3rd Professions case 106: $clase='Shillien Templar'; break; case 107: $clase='Spectral Dancer'; break; case 108: $clase='Ghost Hunter'; break; case 109: $clase='Ghost Sentinel'; break; case 110: $clase='Storm Screamer'; break; case 111: $clase='Spectral Master'; break; case 112: $clase='Shillien Saint'; break; //ORCS 3rd Professions case 113: $clase='Titan'; break; case 114: $clase='Grand Khauatari'; break; case 115: $clase='Dominator'; break; case 116: $clase='Doomcryer'; break; //DWARVES 3rd Professions case 117: $clase='Fortune Seeker'; break; case 118: $clase='Maestro'; break; } echo $clase; //Here the race is showed?>
^^