<td align="center"><strong><?echo ($sort == 4) ? "Zone <img src='images/sort_red.bmp' border='0' width='8' height='8'/>" : "<a href='index.php?editor=qglobal&sort=4" . (($filter['status'] == "on") ? $filter['url'] : "") . "'>Zone <img src='images/sort_green.bmp' border='0' width='8' height='8' title='Sort by Zone'/></a>";?></strong></td>
          <td align="center"><strong>Expires</strong></td>
          <td width="5%">&nbsp;</td>
        </tr>
<?$x=0;
foreach($qglobals as $qglobal):?>
        <tr bgcolor="#<? echo ($x % 2 == 0) ? "BBBBBB" : "AAAAAA";?>">
          <td align="center"><?php 
echo $qglobal['name'];
?>
</td>
          <td align="center"><?php 
echo $qglobal['value'];
?>
</td>
          <td align="center"><?echo ($qglobal['charid'] > 0) ? '<a href="index.php?editor=player&playerid=' . $qglobal['charid'] . '">' . getPlayerName($qglobal['charid']) . '</a>' : "ANY";?></td>
          <td align="center"><?echo ($qglobal['npcid'] > 0) ? '<a href="index.php?editor=npc&npcid=' . $qglobal['npcid'] . '">' . getNPCName($qglobal['npcid']) . '</a>' : "ANY";?></td>
          <td align="center"><?echo ($qglobal['zoneid'] > 0) ? getZoneName($qglobal['zoneid']) : "ANY";?></td>
          <td align="center"><?echo ($qglobal['expdate'] != '') ? get_real_time($qglobal['expdate']) : "NEVER";?></td>
          <td align="right"><a href="index.php?editor=qglobal&name=<?php 
echo $qglobal['name'];
?>
&charid=<?php 
echo $qglobal['charid'];
?>
&npcid=<?php 
echo $qglobal['npcid'];
?>
&zoneid=<?php 
echo $qglobal['zoneid'];
?>

  <div class="table_container" style="width:250px;">
    <div class="table_header">Search Results</div>
    <div class="table_content">
<?php 
if ($search_results != '') {
    $x = 0;
    foreach ($search_results as $result) {
        extract($result);
        ?>
      <a href="index.php?editor=inv&action=1&playerid=<?php 
        echo $result['charid'];
        ?>
"><?php 
        echo getPlayerName($result['charid']);
        ?>
 - (<?php 
        echo $result['charid'];
        ?>
)</a><br/>
<?php 
        $x++;
    }
    if ($x == $list_limit) {
        echo "<br/>List limited to " . $list_limit . " results.";
    }
} else {
    ?>
      Your search produced no results!
<?php 
}
?>

        <div class="table_header">
          Guild Search Results
        </div>
        <div class="table_content">
          <?php 
if ($results != '') {
    ?>
            <?php 
    foreach ($results as $result) {
        extract($result);
        ?>
              <a href="index.php?editor=guild&guildid=<?php 
        echo $guild_id;
        ?>
"><?php 
        echo getPlayerName($char_id) . " (" . $char_id . ") - " . getGuildName($guild_id) . " (" . $guild_id . ")" . "</a><br />";
        ?>
            <?php 
    }
    ?>
          <?php 
}
?>
          <?php 
if ($results == '') {
    ?>
            Your search produced no results!
          <?php 
}
?>
        </div>

            <ul class="nav nav-pills pull-right">
                <li role="presentation" class="active"><a href="#">Hlavní stránka</a></li>
                <li role="presentation"><a href="#">Vývojáři</a></li>
                <li role="presentation"><a href="#">Kontakt</a></li>
            </ul>
        </nav>
        <h3 class="text-muted">Minecore Times</h3>
    </div>


    <h1><?php 
print $name;
?>
 <?php 
$status = questStatus($uId, $qId, $mysqli);
echo niceStatus($status) . " <small>od hráče " . getPlayerName($uId, $mysqli) . "</small>";
?>
</h1>

    <blockquote>

        <p><?php 
print $description;
?>
</p>
        <footer>Doporučené materiály: <?php 
print $materials;
?>
</footer>
    </blockquote>
    <h3>Podrobný popis questu</h3>

             $body->set('pages', 0);
         }
     }
     break;
 case 1:
     // Edit Player Profile
     check_admin_authorization();
     $body = new Template("templates/player/player.edit.tmpl.php");
     $body->set('playerid', $playerid);
     $body->set('classes', $classes);
     $body->set('genders', $genders);
     $body->set('bodytypes', $bodytypes);
     $body->set('races', $races);
     $body->set('yesno', $yesno);
     $body->set('skilltypes', $skilltypes);
     $body->set('player_name', getPlayerName($playerid));
     $vars = player_info();
     if ($vars) {
         foreach ($vars as $key => $value) {
             $body->set($key, $value);
         }
     }
     break;
 case 2:
     // Search Players
     check_admin_authorization();
     $body = new Template("templates/player/player.searchresults.tmpl.php");
     if (isset($_POST['playerid']) && $_POST['playerid'] != "Player ID") {
         $results = search_players_by_id();
     } else {
         $results = search_players_by_name();

include '../db.php';
include '../util.php';
include '../pages/player-list-getter.php';
include '../queries.php';
if (!isset($_GET['page'])) {
    die(json_encode("POST not correct, " . var_dump($_GET)));
}
$page = $_GET['page'];
$totalPlayers = getAmountOfPlayers($mysqli, $mysql_table_prefix, 0);
$totalPages = (int) ($totalPlayers / 15) + ($totalPlayers % 15 != 0 ? 1 : 0);
if ($page > $totalPages) {
    $page = $totalPages;
}
if (!is_numeric($page)) {
    die(json_encode("Page is not a number (???)"));
}
$players = getPlayerList($mysqli, $mysql_table_prefix, $player_list_sort_by, $player_list_sort_order, $page);
if (!$players || empty($players)) {
    die(json_encode("Query failed, or no players are found"));
}
$arr = array();
array_push($arr, $totalPages);
while ($player = $players->fetch_array()) {
    $newPlayer = array();
    $newPlayer['player_id'] = $player['player_id'];
    $newPlayer['name'] = getPlayerName($mysqli, $mysql_table_prefix, $player['player_id']);
    $newPlayer['lastjoin'] = $player['lastjoin'];
    $newPlayer['lastleave'] = $player['lastleave'];
    array_push($arr, $newPlayer);
}
echo json_encode($arr);

function handleTimeOut($playerId)
{
    $gameName = getGameName($gameId);
    $playerEmail = getPlayerName($playerId);
    sendTimeOut($playerEmail, $gameName);
}

        //Save stat data
        file_put_contents("{$statDataDir}/" . $id, serialize($stat['ranking']));
    }
}
//Save player stats
foreach ($playerStats as $id => $pstat) {
    echo "Saving data for {$id} ...\n";
    file_put_contents("{$playerDataDir}/" . $id, serialize($pstat));
}
//Save awards
echo "Saving awards ...\n";
file_put_contents($awardsFile, serialize($awards));
//Create award output
if ($awardOutputFile) {
    echo "Generating award output ...\n";
    $f = fopen($awardOutputFile, 'w');
    foreach ($stats as $id => $stat) {
        if (array_key_exists($id, $awards)) {
            $award = $awards[$id];
            fwrite($f, str_replace('%A%', $stat['award'], str_replace('%D%', $stat['desc'], str_replace('%W%', getPlayerName($award['id']), str_replace('%S%', getStatDisplayValue($stat, $award['score']), $awardOutputFormat)))));
        }
    }
    fclose($f);
}
//Sort and save Hall of Fame
echo "Saving hall of fame\n";
uasort($hof, 'compareRankingEntries');
file_put_contents($hofFile, serialize($hof));
//Save last update
echo "Saving last update time ...\n";
file_put_contents($lastUpdateFile, serialize(time()));

             foreach ($page_stats as $key => $value) {
                 $body->set($key, $value);
             }
         } else {
             $body->set('page', 0);
             $body->set('pages', 0);
         }
     }
     break;
 case 1:
     // Edit Account Details
     check_admin_authorization();
     $body = new Template("templates/account/account.edit.tmpl.php");
     $body->set('acctid', $acctid);
     $body->set('yesno', $yesno);
     $body->set('acctname', getPlayerName($acctid));
     $vars = account_info();
     if ($vars) {
         foreach ($vars as $key => $value) {
             $body->set($key, $value);
         }
     }
     break;
 case 2:
     // Search Accounts
     check_admin_authorization();
     $body = new Template("templates/account/account.searchresults.tmpl.php");
     if (isset($_POST['lsaccount_id']) && $_POST['lsaccount_id'] != "LS Acct ID") {
         $results = search_accounts_by_id();
     } else {
         $results = search_accounts_by_name();

      <tr>
        <td align="center" width="35%"><strong>Character</strong></td>
        <td align="center" width="35%"><strong>Currency</strong></td>
        <td align="center" width="20%"><strong>Amount</strong></td>
        <td width="10%">&nbsp;</td>
      </tr>
<?php 
    $x = 0;
    foreach ($altcur_characters as $character) {
        ?>
      <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
        <td align="center" width="35%"><?php 
        echo getPlayerName($character['char_id']);
        ?>
 (<?php 
        echo $character['char_id'];
        ?>
)</td>
        <td align="center" width="35%"><?php 
        echo get_currency_name($character['currency_id']);
        ?>
 (<?php 
        echo $character['currency_id'];
        ?>
)</td>
        <td align="center" width="20%"><?php 
        echo $character['amount'];
        ?>

 * Copyright (c) 1998-2008 John Morrison.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 */
?>

<?php 
$name = getPlayerName($mc->getPid());
?>
<table border="0" width=100%>
<tr><td><div class="subheading"><b>Navigation</b></div></td></tr><tr>
<td>
<div class="bodytext">
<?php 
if ($mc->getId() != '') {
    include "{$BASE_FILES}/inc_mapcollection_location.php";
} else {
    echo "Welcome to WinBolo.net players map collections. You can navigate the map collection by clicking on the folders section below. To move back up a folder click on the folder name in the navigation section or click the back button on your web browser.<P>To download a map simply click on the map picture or click on the map name. To bring up more information click on the word info next to the map. If you are logged in you can write reviews of maps.<P>To create a map collection login and goto your profile. At the bottom of the page you will find a create map collection button. Press it to create a collection. After creating a collection you will be able to browse the map collection and add maps and folders into your own map collection. Please only upload maps that you have created or modified, this will save on resources. <P>For more information about features to come as well as feedback please see the forums";
    echo "<P>";
    echo "It is now possible to <a href='mapcollectionsearch.php'>Search the map collection</a>.";
    echo "<P><P>";
}
echo "Path: ";

             if ($attr_count > 2) {
                 printf("<td>%s</td>", $row['attr_3']);
                 if ($attr_count > 3) {
                     printf("<td>%s</td>", $row['attr_4']);
                     if ($attr_count > 4) {
                         printf("<td>%s</td>", $row['attr_5']);
                     }
                 }
             }
         }
         printf("</tr>");
     }
 } else {
     while (($row = $result->fetch_array()) != null) {
         printf("<tr>");
         $player_name = sprintf("<a style=\"color: %s; \" target=\"_blank\" href=\"%s%s\"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $armory_url, getPlayerName($row['character_guid']), getPlayerName($row['character_guid']));
         printf("<td>%s</td>", $player_name);
         printf("<td style=\"min-width: 49px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td>", getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']));
         printf("<td>%s</td>", $row['score_killing_blows']);
         printf("<td>%s</td>", $row['score_deaths']);
         printf("<td>%s</td>", $row['score_honorable_kills']);
         printf("<td>%s</td>", $row['score_bonus_honor']);
         printf("<td>%s</td>", $row['score_damage_done']);
         printf("<td>%s</td>", $row['score_healing_done']);
         printf("<td>%s</td>", $row['attr_1']);
         if ($attr_count > 1) {
             printf("<td>%s</td>", $row['attr_2']);
             if ($attr_count > 2) {
                 printf("<td>%s</td>", $row['attr_3']);
                 if ($attr_count > 3) {
                     printf("<td>%s</td>", $row['attr_4']);

      <table class="edit_form" width="300px">
        <tr>
          <td class="edit_form_header">
            Inventory item located at <?php 
echo getPlayerName($inv_item['charid']);
?>
's <?php 
echo $slots[$inv_item['slotid']];
?>
          </td>
        </tr>
        <tr>
          <td class="edit_form_content">
            <form name="inventory" id="inventory" method="POST" action="index.php?editor=inv&playerid=<?php 
echo $inv_item['charid'];
?>
&slotid=<?php 
echo $inv_item['slotid'];
?>
&action=7">
              <table width="100%" cellpadding="3" cellspacing="0">
                <tr>
                  <td>
                    Player ID:<br/>
                    <input type="text" size="5" name="charid" value="<?php 
echo $inv_item['charid'];
?>
" readonly="true">
                  </td>
                  <td>
                    <a title="22-29: Main Inventory Slots">Slot ID:</a><br/>

              <td align="center" width="20%"><strong>Value</strong></td>
              <td width="10%">&nbsp;</td>
            </tr>
<?php 
    $x = 0;
    foreach ($player_factions as $player_faction) {
        ?>
            <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
              <td align="center" width="20%"><a title="Character ID: <?php 
        echo $player_faction['char_id'];
        ?>
"><?php 
        echo getPlayerName($player_faction['char_id']);
        ?>
</a></td>
              <td align="center" width="20%"><a title="Faction: <?php 
        echo getFactionName($player_faction['faction_id']);
        ?>
"><?php 
        echo $player_faction['faction_id'];
        ?>
</a></td>
              <td align="center" width="20%"><?php 
        echo $player_faction['current_value'];
        ?>
</td>
              <td align="right"><a href="index.php?editor=faction&char_id=<?php 
        echo $player_faction['char_id'];

    foreach ($mail as $message) {
        ?>
            <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
              <td align="center" width="10%"><?php 
        echo $message['msgid'];
        ?>
</td>
              <td align="center" width="15%"><?php 
        echo $message['from'];
        ?>
</td>
              <td align="center" width="15%"><?php 
        echo getPlayerName($message['charid']);
        ?>
</td>
              <td align="center" width="35%"><?php 
        echo $message['subject'];
        ?>
</td>
              <td align="center" width="20%"><?php 
        echo get_real_time($message['timestamp']);
        ?>
</td>
              <td align="right"><a href="index.php?editor=mail&msg_id=<?php 
        echo $message['msgid'];
        ?>
&action=1"><img src="images/mail.gif" width="13" height="13" border="0" title="View Message"></a>&nbsp;<a onClick="return confirm('Really delete message <?php 
        echo $message['msgid'];

          <td align="center" width="50%"><strong>Recipe</strong></td>
          <td align="center" width="20%"><strong>Count</strong></td>
        </tr>
<?php 
    $x = 0;
    foreach ($recipes as $recipe => $v) {
        ?>
        <tr bgcolor="#<?php 
        echo $x % 2 == 0 ? "BBBBBB" : "AAAAAA";
        ?>
">
          <td align="center" width="25%"><a href="index.php?editor=player&playerid=<?php 
        echo $v['char_id'];
        ?>
"><?php 
        echo getPlayerName($v['char_id']);
        ?>
</a></td>
          <td align="center" width="50%"><?php 
        echo getRecipeName($v['recipe_id']);
        ?>
</td>
          <td align="center" width="20%"><?php 
        echo $v['madecount'];
        ?>
</td>
        </tr>
<?php 
        $x++;
    }
}

}
if ($npcid != '' && $npcid != 'ID' && $editor != 'altcur' && $editor != 'qglobal') {
    $breadcrumbs .= " >> " . getNPCName($npcid) . " ({$npcid})";
}
if ($fid != '') {
    $breadcrumbs .= " >> " . getFactionName($fid);
}
if ($tskid != '') {
    $breadcrumbs .= " >> " . getTaskTitle($tskid);
}
if ($ts != '') {
    $breadcrumbs .= " >> " . "<a href='index.php?editor=" . $editor . "&ts=" . $ts . "'>" . $tradeskills[$ts] . "</a>";
}
if ($rec != '0') {
    $breadcrumbs .= " >> " . getRecipeName($rec);
}
if ($spellset != '') {
    $breadcrumbs .= " >> " . getSpellsetName($spellset);
}
if ($playerid != '' && $playerid != 'Player ID') {
    $breadcrumbs .= " >> <a href='index.php?editor=" . $editor . "&playerid=" . $playerid . "'>" . getPlayerName($playerid) . " ({$playerid})</a>";
}
if ($acctid != '') {
    $breadcrumbs .= " >> " . getAccountName($acctid) . " ({$acctid})";
}
if ($guildid != '') {
    $breadcrumbs .= " >> " . getGuildName($guildid) . " ({$guildid})";
}
if ($aaid != '') {
    $breadcrumbs .= " >> " . getAAName($aaid) . " ({$aaid})";
}

              <td align="center"><?php 
        echo "<a href='index.php?editor=tradeskill&rec=" . $recipe['recipe_id'] . "'>" . getRecipeName($recipe['recipe_id']);
        ?>
</a> (<?php 
        echo $recipe['recipe_id'];
        ?>
)</td>
              <td align="center"><?php 
        echo $recipe['madecount'];
        ?>
</td>
              <td align="right"><a onClick="return confirm('Really delete <?php 
        echo getRecipeName($recipe['recipe_id']);
        ?>
 from <?php 
        echo getPlayerName($recipe['char_id']);
        ?>
?');" href="index.php?editor=tradeskill&recipe_id=<?php 
        echo $recipe['recipe_id'];
        ?>
&char_id=<?php 
        echo $recipe['char_id'];
        ?>
&action=14"><img src="images/remove3.gif" border="0" title="Delete Learned Recipe"></a></td>
            </tr>
<?php 
        $x++;
    }
} else {
    ?>
            <tr>

        echo $task['taskid'];
        ?>
)</td>
              <td align="center"><?php 
        echo $task['activityid'];
        ?>
</td>
              <td align="center"><?php 
        echo get_real_time($task['completedtime']);
        ?>
</td>
              <td align="right"><a onClick="return confirm('Really delete task (<?php 
        echo $task['taskid'];
        ?>
) from <?php 
        echo getPlayerName($task['charid']);
        ?>
?');" href="index.php?editor=tasks&tskid=<?php 
        echo $task['taskid'];
        ?>
&charid=<?php 
        echo $task['charid'];
        ?>
&action=38"><img src="images/remove3.gif" border="0" title="Delete Completed Task"></a></td>
            </tr>
<?php 
        $x++;
    }
} else {
    ?>
            <tr>

            <table cellspacing="0" border="0" width="100%">
              <tr>
                <td align="center">Rank</td>
                <td>Name</td>
                <td align="center">Total Tribute</td>
                <td align="center">Last Donation</td>
                <td align="center">Tribute Active</td>
                <td align="center">Banker</td>
                <td align="center">Alt</td>
                <td align="center">Public Note</td>
              </tr>
<?
  foreach ($guild_members as $guild_member) {
    echo '<tr>';
    echo '<td align="center">' . $guild_member['rank'] . '</td>';
    echo '<td><a href="index.php?editor=player&playerid=' . $guild_member['char_id'] . '">' . getPlayerName($guild_member['char_id']) . '</a></td>';
    echo '<td align="center">' . $guild_member['total_tribute'] . '</td>';
    echo '<td align="center">' . $guild_member['last_tribute'] . '</td>';
    echo '<td align="center">' . $yesno[$guild_member['tribute_enable']] . '</td>';
    echo '<td align="center">' . $yesno[$guild_member['banker']] . '</td>';
    echo '<td align="center">' . $yesno[$guild_member['alt']] . '</td>';
    echo '<td align="center"><img src="images\note.gif" title="' . (($guild_member['public_note'] != '') ? $guild_member['public_note'] : 'No Public Note') . '"/></td>';
    echo '</tr>';
  }
?>
            </table>
          </fieldset>
        </td>
      </tr>
      <tr>
        <td colspan="2">