Mostrar lista de heroes

[Swarlog]

Código [Seleccionar] Expandir

<?php       // Server Database Config      $db_host      = '1.1.1.1';      $db_user      = 'user';      $db_pass      = 'pass';      $db_database   = 'l2jgs';      // Try to make connection.      $connection = new PDO("mysql:host=$db_host;dbname=$db_database;charset=utf8", $db_user, $db_pass);      $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);$class_name = array(               '88' => "Duelist",               '89' => "Dread Nought",               '90' => "Phoenix Knight",               '91' => "Hell Knight",               '92' => "Sagittarius",               '93' => "Adventurer",               '94' => "Archmage",               '95' => "Soul Taker",               '96' => "Arcane 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 Khauatari",               '115' => "Dominator",               '116' => "Doomcryer",               '117' => "Fortune Seeker",               '118' => "Maestro",            );            // Get data from heroes and character table            $character_row = $connection->prepare('SELECT heroes.charId, heroes.class_id, characters.char_name FROM heroes , characters WHERE heroes.charId =  characters.charId ');                        echo '<b>Hero list</b><br>';                        echo '<table>';            if ($character_row->execute())               {                   while ($row = $character_row->fetch(PDO::FETCH_ASSOC))                     {                        echo '<tr><td>', $row['char_name'],'</td><td>', $class_name[$row['class_id']], '</td></tr>' ;                     }               }            echo '</table>';            $connection = null;?>