source: branches/posledni/pages/gmteam.php

<?php

function ShowGMList($Realm)
{
  global $db, $db2, $Config;
  
  $Result = $db->query('SELECT * FROM `GmTeam` WHERE (`RealmId` = '.$Realm['Id'].') AND (`TimeTo` IS NULL) ORDER BY `RealmId`, `Nick`');
  if($Realm['Id'] == 0) $Output = '<h3 class="PageTitle">'.$Realm['Name'].'</h3>';
    else $Output = '<h3 class="PageTitle">Svět '.$Realm['Name'].'</h3>';
  $Output .= '<table class="BaseTable">'.
    '<tr><th>Jméno</th><th>Pověření</th><th>Postavy</th></tr>';
  if($Result->num_rows == 0) return('');
  
  while($Line = $Result->fetch_array())
  {  
    // Create link from name if ForumId defined
    if($Line['ForumId'] != 0) $Line['Nick'] = '<a href="'.$Config['Web']['BaseURL'].'forum/memberlist.php?mode=viewprofile&amp;u='.$Line['ForumId'].'">'.$Line['Nick'].'</a>';
    
    $Output .= '<tr><td>'.$Line['Nick'].'</td>'.
      '<td>'.$Line['Delegation'].'</td>';
    $Output .= '<td>';
    $Characters = array();
    $ResultMangos = $db2->query('SELECT * FROM `characters` WHERE `account` = "'.$Line['AccountId'].'"');
    while($LineMangos = $ResultMangos->fetch_array())
    { 
      if($LineMangos['online'] == 1) $Characters[] = $LineMangos['name'].'(online)';
        else $Characters[] = $LineMangos['name'];
    }
    $Output .= implode(', ', $Characters);
    $Output .= '</td>';

/*
 * //  $Database->select_db($Config['Mangos']['DatabaseRealmd']);
  if($Line['ForumId'] != 0)
  {
    echo('<tr><th>Profil na foru:</th>');
    echo('<td><strong><a href="'.$Config['Web']['BaseURL'].'forum/memberlist.php?mode=viewprofile&u='.$Line['ForumId'].'">Profil</a></strong></td>');
    echo '</tr>';
  }
  //echo('<tr><td colspan="2"><hr></td></tr>');
  */
    $Output .= '</tr>';
  }
  $Output .= '</table>';
  return($Output);
}

//$Role = array('Hráč', 'Moderátor', 'Game Master', 'Kontrolor chyb', 'Vedoucí Tábora', 'Administrátor', 'Správce Systému');
//$_COOKIE['RealmIndex']

$Realm = new Realm($System, $_COOKIE['RealmIndex']);
$db2 = $Realm->CharactersDatabase;

$Output = '<h2 class="PageTitle">GM tým</h2>';

$Output .= ShowGMList(array('Id' => 0, 'Name' => 'Všechny světy'));
$DbResult = $System->Database->query('SELECT * FROM Realm WHERE Enabled=1');
while($Realm = $DbResult->fetch_assoc())
{
  $Output .= ShowGMList($Realm);
}
$Output .= '<br />'.$server->RealmSelection();

$Output .= '<h3 class="PageTitle">Dřívější GM</h3>';
$List = array();
$DbResult = $db->query('SELECT * FROM `GmTeam` WHERE `TimeTo` IS NOT NULL');
while($DbRow = $DbResult->fetch_assoc())
{
  $List[] = $DbRow['Nick'].' ('.$server->HumanDate($DbRow['TimeFrom'], 0).' - '.$server->HumanDate($DbRow['TimeTo'], 0).')';
}
$Output .= implode(', ', $List);

echo($Output);

?>