<?php

include('global.php');
ShowHeader();
include('download_soubory/files.php');

$Role = array('Hráč', 'Moderátor', 'Game master', 'Kontrolor chyb', 'Administrátor', 'Správce systému');

echo('<h3>GM tým</h3>');

$ChronosId = 11432;
$Database->select_db($Config['Mangos']['DatabaseRealmd']);
$Result = $Database->query('SELECT * FROM account WHERE (locked = 0) AND (id != '.$ChronosId.') AND (gmlevel > 0) ORDER BY gmlevel DESC');
echo('<table border="0">');
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>Přezdí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'];
*/
  $Database->select_db($Config['Mangos']['DatabaseCharacters']);
  echo('<tr><td><p>GM Postavy ve hře:</p></td>');
  echo('<td><p><b>');
  $ResultMangos = $Database->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>');
ShowFooter();

?>