<?
/*
********************************************************************************
********************************************************************************
*                                                                              *
*        **************************************************************        *
*        * gllcTS2 for TeamSpeak 2 © Gryphon, LLC                     *        *
*        * www.gryphonllc.com                                         *        *
*        *                                                            *        *
*        * (c) Copyright TeamCom Team, Ralf Ludwig, Niels Werensteijn *        *
*        * All rights are reserved.                                   *        *
*        * Copying or other reproduction of this                      *        *
*        * program except for archival purposes is prohibited without *        *
*        * the prior written consent of TC-Team.                      *        *
*        **************************************************************        *
*                                                                              *
********************************************************************************
********************************************************************************
*/
  include_once("./admin/db_inc.php");
  clearinactive();

  if (isset($_GET["direction"])) {
    $direction = $_GET["direction"];
  }
  if (isset($_GET["page"])) {
    $page = $_GET["page"];
  }

  if (!isset($_GET["sort"])) {
    $version_direction = "void";
    $sort = "server_name";
  } else if ($_GET["sort"] == 'server_version') {
    $version_direction = "server_version";
    $sort = "server_version_major ".$direction.", server_version_minor ".$direction.", server_version_release ".$direction.", server_version_build";
  } else {
    $version_direction = "void";
    $sort = $_GET["sort"];
  }

  if ((!isset($_GET["showgroup"])) or ($_GET["showgroup"] == 'all')) {
    $showgroup = "all";
    $group = "WHERE 1";
  } else if ($_GET["showgroup"] == 'Private') {
    $group = "WHERE server_ispname='$showgroup' OR server_ispname=''";
  } else if ($_GET["showgroup"] != 'Private') {
    $group = "WHERE server_ispname='$_GET[showgroup]'";
  }

  include("tpl_listing_top.php");

  if (isset($_GET["direction"])) {
    $pagedirection = $_GET["direction"];
  }

  if (empty($pagedirection)) {
    $pagedirection = "asc";
  }

  if (empty($direction)) {
    $direction = "asc";
  }
  if (empty($page)) {
    $page = 1;
    $pagestart = $page -1;
  } else {
    $pagestart = (($page -1) * $setting["perpage"]);
  }

  $serverquery = query("SELECT * FROM $dbtable1 $group");
  $servercount = number_format(mysql_num_rows($serverquery));

  $request = query("SELECT * FROM $dbtable1 $group order by $sort $direction, server_name LIMIT $pagestart,$setting[perpage]");

  if ($direction == "asc") {
    $direction = "desc";
  } else if ($direction == "desc") {
    $direction = "asc";
  }

  if (!empty($_GET["detail"])) {
    $r = query("SELECT * FROM $dbtable1 WHERE server_ip='$_GET[detail]' AND server_port='$_GET[detailport]'");
    $row = mysql_fetch_object($r);

    include("tpl_serverdetail.php");
  }

  include("tpl_serverlist_top.php");

  if ($servercount > $setting["perpage"]) {
    include("tpl_serverlist_nav.php");
  }
  while ($row = mysql_fetch_object($request)) {

    if ($rowcolor == $setting["rowcolor2"]) {
      $rowcolor = $setting["rowcolor1"];
    } else {
      $rowcolor = $setting["rowcolor2"];
    }

    include("tpl_serverlist.php");

  }

  if ($servercount > $setting["perpage"]) {
    include("tpl_serverlist_nav.php");
  }

  include("tpl_serverlist_bot.php");
?>