source: trunk/pages/gmteam.php@ 481

<?
include("inc/db.php");
$Role = array('Hráč', 'Moderátor', 'Game Master', 'Kontrolor chyb', 'Administrátor', 'Správce Systému');

echo('<h2 align="center">GM tým</h2>');

$ChronosId = 11432;

$db->select_db("$db_realmd");
$Result = $db->query('SELECT * FROM account WHERE (locked = 0) AND (id != '.$ChronosId.') AND (gmlevel > 0) ORDER BY gmlevel DESC');
echo('<table border="0" align="center">');
while($Line = $Result->fetch_array())
{
  $Line['username'] = strtoupper($Line['username'][0]).strtolower(substr($Line['username'], 1));
  if(substr($Line['username'], -2, 2) == 'gm') $Line['username'] = substr($Line['username'], 0, -2);
  
  echo '<tr><td><p>Prezdívka:</p></td>';
  echo '<td><p><b>'.$Line['username'].'</b></p></td>';
  echo '</tr>';
  echo '<tr><td><p>Funkce:</p></td>';
  echo '<td><p><b>'.$Role[$Line['gmlevel']].'</b></p></td>';
  echo '</tr>';
/*
  if ($Line['Email'] <> '') 
  {
    echo '<tr><td><p>Email:</p></td>';
    echo '<td><p><b>'.$Line['Email'].'</b></p></td>';
    echo '</tr>';
  }
  $Acc = $Line['AccID'];
*/
  $db->select_db("$db_characters");
  echo('<tr><td><p>GM Postavy ve hře:</p></td>');
  echo('<td><p><b>');
  $ResultMangos = $db->query('SELECT * FROM `characters` WHERE account = "'.$Line['id'].'"');
  while($LineMangos = $ResultMangos->fetch_array())
  {
    if($LineMangos['online'] == 1)
      echo($LineMangos['name'].'(online)  ');
    else
      echo($LineMangos['name'].'  ');
  }
  echo('</b></p></td></tr>');

//  $Database->select_db($Config['Mangos']['DatabaseRealmd']);
  if($Line['ForumId'] != 0)
  {
    echo('<tr><td><p>Profil na foru:</p></td>');
    echo('<td><p><b><a href="http://wow.zdechov.net/forum/profile.php?mode=viewprofile&u='.$Line['ForumId'].'">Profil</a></b></p></td>');
    echo '</tr>';
  }
  echo('<tr><td colspan="2"><hr></td></tr>');
}
echo('</table>');