Hero list PHP

[antara]

Hi all, I am using the last L2jServer and L2jDatapack epilogue version, and I want to modify a php code to show the hero list, but I don't know so much of php and javascript, can somebody help me please?
Heres the code.

Code: Select all

<?php//Script cirado por Rayder//www.portal1533.com.br//www.virtualmu.com.br $servidor = 'localhost';$usuario  = 'root';$senha    = 'contraseña';$db       = 'l2jdb'; $con = mysql_connect($servidor, $usuario, $senha) or die(mysql_error());mysql_select_db($db, $con) or die(mysql_error());?><h1>Heros</h1><div id="rank_geral">  <div id="barra_lateral">    <div id="borda_lateral_e"></div>    <ul id="topo_rank">      <li class="nomej">Nombre del PJ</li>      <li class="level">Level</li>      <li class="classe">Clase</li>      <li class="clanh">Clan</li>      <li class="vezes">Veces</li>    </ul>    <div id="barra_lateral_d"></div>  </div>  <?php $sql = mysql_query("SELECT * FROM heroes ORDER BY char_name") or die(mysql_error());$i = 1;while($c = mysql_fetch_array($sql)) {    $h = mysql_query("SELECT * FROM characters WHERE Obj_Id = '".$c['char_id']."'") or die(mysql_error());    $n = mysql_fetch_array($h);    $l = mysql_query("SELECT * FROM class_list WHERE id = '".$n['base_class']."'") or die(mysql_error());    $g = mysql_fetch_array($l);    $i = mysql_query("SELECT * FROM clan_data WHERE clan_id = '".$n['clanid']."'") or die(mysql_error());    $j = mysql_fetch_array($i);    $g['class_name'] = explode("_", $g['class_name']);    $n['class_name'] = explode("_", $n['char_name']);    $j['clan_name'] = empty($n['clanid']) ? 'Sin Clan.' : $j['clan_name'];?>  <div class="li_r_bl">    <ul class="list_rank">      <li class="nomej"><?php echo $n['char_name']; ?></li>      <li class="level"><?php echo $n['level']; ?></li>      <li class="classe"><?php echo ucwords($g['class_name'][1]); ?></li>      <li class="clanh"><?php echo $j['clan_name']; ?></li>      <li class="vezes"><?php echo $c['count']; ?></li>    </ul>    <div class="clear"></div>  </div>  <?php  $i++;}?>  <div class="clear"></div>  <div id="borda_e_cgr"></div>  <div id="barra_rodape_cg_3"></div>  <div id="borda_d_cgr"></div></div><div class="clear"></div>

Sory for my bad inglish ^_^"

[wonderweiss]

Olympiad.php

Code: Select all

<?php require("config/olymp.php");$activity = mysql_query("SELECT characters.$OBJ_ID, characters.char_name, characters.level, olympiad_nobles.char_id, olympiad_nobles.class_id, olympiad_nobles.char_name, olympiad_nobles.olympiad_points, olympiad_nobles.competitions_done, char_templates.ClassId, char_templates.ClassNameFROM charactersLEFT JOIN olympiad_nobles ON characters.$OBJ_ID = olympiad_nobles.char_idJOIN char_templates ON char_templates.ClassId = olympiad_nobles.class_idORDER BY olympiad_nobles.olympiad_points DESC,olympiad_nobles.competitions_doneDESC LIMIT $LIMIT");$i = 1;    while($row = mysql_fetch_array($activity)) {        if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>";        else        echo "<tr bgcolor='#161616' align='center'>";        echo "<td>"."<center>".$i."</center>"."</td>";        echo "<td>"."<center>".$row['char_name']."</center>"."</td>";        echo "<td>"."<center>".$row['level']."</center>"."</td>";        echo "<td>"."<center>".$row['ClassName']."</center>"."</td>";        echo "<td>"."<center>".$row['olympiad_points']."</center>"."</td>";        echo "<td>"."<center>".$row['competitions_done']."</center>"."</td>";        $i++;}?>

Olymp.php

Code: Select all

<?php$L2JBS_config["mysql_host"]="localhost";    // MySQL Host     ["localhost"]$L2JBS_config["mysql_port"]="3306";        // MySQL Port            ["3306"]$L2JBS_config["mysql_db"]="";        // MySQL Database    ["l2jdb"]$L2JBS_config["mysql_login"]="";        // MySQL User            ["root"]    $L2JBS_config["mysql_password"]="";    // MySQL Password            ["root"]$LIMIT="60";                    // TOP PAGE LIMIT$OBJ_ID="obj_Id";                // Characters Table object id field name$ACCS_LVL="accesslevel";            // Characters Table access level field name$minenchant="5";                // Safe Enchant of Server$maxenchant="20";                // Max Enchant of Server$ETCITEMS="4037,57";                // Top Items Ids$MAX_ACCESS="1";                // Full Access level$EGM_ACCESS="5";                // Event GM Access level$NORMAL_ACCESS="2";                // Normal GM Access levelinclude("config/_config_procs.php");error_reporting(0);?>

[antara]

Don't load in the servers page, I will try to fix it, thx ^^