Need help fixing this hero php code

disorder25 · September 8, 2009

Can anybody help me fix this code to make it work with L2j database.

Right now I got it to show the table with name, class, etc but I don't get the hero info.

Please if you can help I will appreciate.

Thank you.

<html>
 <head>
   <title>Heroes</title>
   <style>
   body {
     margin: 0px;
     padding: 0px;
     background: #2E0601;
     color: #ffffff;
     font-family: tahoma, verdana;
     font-size: 8pt;        
   }
   
   td {
     font-family: tahoma, verdana;
     font-size: 8pt;
     margin: 0;
     color: #ffffff;
   }
   
   b {
     font-weight: bold;
     color: #84c3f8;
   }
   
   A {
     color: #ffe155;
     text-decoration: none;
   }
   
   A:link { color: #ffe155; }
   A:visited { color:#e8a400; }
   A:active { color: #ffff99; }
   A:hover { color: #ffff99; text-decoration: underline; }
   
   .tabletitle {
     color: #FFFFFF;
     background-color: #4B150E;
     border-width: 2; border-style: solid;
     border-color: #000000;
   }
   </style>
 </head>
 <body>
   <center>
   <table class='info'>
     <tr class='info'><td align='center'><b>Current Heroes</b></td></tr>
   </table>
<?
$class_list=array(
   0=>"Fighter",1=>"Warrior",2=>"Gladiator",3=>"Warlord",4=>"Knight",5=>"Paladin",6=>"Dark Avenger",7=>"Rogue",
   8=>"Treasure Hunter",9=>"Hawkeye",10=>"Mage",11=>"Wizard",12=>"Sorcerer",13=>"Necromancer",14=>"Warlock",15=>"Cleric",
   16=>"Bishop",17=>"Prophet",18=>"Elven Fighter",19=>"Elven Knight",20=>"Temple Knight",21=>"Swordsinger",22=>"Elven Scout",23=>"Plains Walker",
   24=>"Silver Ranger",25=>"Elven Mage",26=>" Elven Wizard",27=>" Spellsinger",28=>"Elemental Summoner ",29=>"Oracle",
   30=>"Elder",31=>"Dark Fighter",32=>"Palus Knightr",33=>"Shillien Knight",34=>"Bladedancer",35=>"Assasin",36=>"Abyss Walker",
   37=>"Phantom Ranger",38=>"Dark Mage",39=>"Dark Wizard",40=>"Spellhowler",41=>"Phantom Summoner",42=>"Shillien Oracle",43=>"Shilien Elder",
   44=>"Orc Fighter",45=>"Orc Raider",46=>"Destroyer",47=>"Orc Monk",48=>"Tyrant",49=>"Orc Mage",50=>"Orc Shaman",51=>"Overlord",
   52=>"Warcryer",53=>"Dwarven Fighter",54=>"Scavenger",55=>"Bounty Hunter",56=>"Artisan", 57=> "Warsmith",
   88=>"Duelist",89=>"Dreadnought",90=>"Phoenix Knight",91=>"Hell Knight",92=>"Sagittarius",93=>"Adventurer",94=>"Archmage",95=>"Soultaker",
   96=>"Arcana Lord",97=>"Cardinal",98=>"Hierophant",99=>"Evas Templar",100=>"Sword Muse",101=>"Wind Rider",102=>"Moonlight Sentinel",
   103=>"Mystic Muse",104=>"Elemental Master",105=>"Evas Saint",106=>"Shillien Templar",107=>"Spectral Dancer",108=>"Ghost Hunter",
   109=>"Ghost Sentinel",110=>"Storm Screamer",111=>"Spectral Master",112=>"Shillien Saint",113=>"Titan",114=>"Grand Khavatari",
   115=>"Dominator",116=>"Doomcryer",117=>"Fortune Seeker",118=>"Maestro",
   123=>"Male Soldier",124=>"Female Soldier",125=>"Trooper",126=>"Warder",127=>"Berserker",
   128=>"Male Soulbreaker",129=>"Female Soulbreaker",130=>"Arbalester",131=>"Doombringer",
   132=>"Male Soulhound",133=>"Female Soulhound",134=>"Trickster",135=>"Inspector",136=>"Judicator"
);



// db config
$db_user = "root"; //your sql username goes here
$db_pass = ""; //your sql password goes here
$db_name = "l2jdb";    //your database name goes here
$db_serv = "localhost"; //the address of the database goes here

// db connection!
$db = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]");
mysql_select_db ( $db_name );

function do_query($query) {
 $arr = array();
 $result = mssql_query($query) or die("Error SQL: ".mssql_get_last_message());
 for ($x=0; $arr[$x] = mssql_fetch_assoc($result); $x++);
 unset($arr[count($arr)-1]);
 return $arr;
}

$query = mysql_query("SELECT char_name,subjob0_class,pledge.name as 'pname',alliance.name as 'aname',pledge.crest_id as 'pcrest',alliance.crest_id as 'acrest',win_count,race
FROM user_data
LEFT JOIN pledge ON pledge.pledge_id = user_data.pledge_id
INNER JOIN user_nobless ON user_nobless.char_id = user_data.char_id
LEFT JOIN alliance ON alliance.id = pledge.alliance_id
WHERE hero_type > 0
AND win_count > 0
AND builder = 0
AND account_id > 0
ORDER BY subjob0_class
");

$heroes_actuales = mysql_query($query);

if (sizeof($heroes_actuales) == 0) echo "No heros found.";
else {
 echo "
 <table class='info'><tr bgcolor='333333' align='center'>\n
 <tr bgcolor='333333' align='center'>
 <td width='24%' align='left'><b>Name</b></td>
 <td width='24%' align='left'><b>Class</b></td>
 <td width='24%' align='left'><b>Clan</b></td>
 <td width='24%' align='left'><b>Alliance</b></td>
 <td width='4%' align='left'><b>Wins</b></td>
 </tr>
 ";
 
 $i=0;
 foreach($heroes_actuales as $hero) {
   if (!($i%2)) echo "<tr bgcolor='000000' align='center'>";
   else echo "<tr bgcolor='333333' align='center'>";
   
   echo "
   <td align='left'>".$hero['char_name']."</td>
   <td align='left'>".$class_list[$hero['subjob0_class']]."</td>
   <td align='left'>
   ";
   if ($hero['pcrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['pcrest']."'> ";
   echo $hero['pname']."</td><td align='left'>";
   if ($hero['acrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['acrest']."'> ";
   echo $hero['aname']."</td><td align='left'>".$hero['win_count']."</td></tr>";
     
   $i++;
 }
 
 echo "</table>";
}

?>

 <body>
</html>

hoangnhan · September 8, 2009

Move to Help Section.

where User_data table in you database?

disorder25 · September 8, 2009

What do you mean? user data is the characters table isn't it?

This code I think is for L2 OFF, need to convert it to L2j database>

Need help fixing this hero php code

Question

disorder25

2 answers to this question

Recommended Posts

hoangnhan

disorder25

Posts

Topics

Browse

Activity

Store