<?php
header("content-type: text/html; charset=utf-8");
session_start();

include "logincheck.inc.php";

if (!isset($_SESSION['lang'])) $_SESSION['lang'] = "german";
if (isset($_GET['language'])) {
    switch ($_GET['language']) {
        case "german"    : $_SESSION['lang']="german"; break;
        case "english"   : $_SESSION['lang']="english"; break;
        case "spanish"   : $_SESSION['lang']="spanish"; break;
        case "dutch"     : $_SESSION['lang']="dutch"; break;
        case "balkan"    : $_SESSION['lang']="balkan"; break;
        case "french"    : $_SESSION['lang']="french"; break;
        case "portugues" : $_SESSION['lang']="portugues"; break;
        case "polish"    : $_SESSION['lang']="polish"; break;
        case "italian"   : $_SESSION['lang']="italian"; break;
        case "turkish"   : $_SESSION['lang']="turkish"; break;
        case "danish"    : $_SESSION['lang']="danish"; break;
        case "brazilian" : $_SESSION['lang']="brazilian"; break;
        case "russian"   : $_SESSION['lang']="russian"; break;
        case "swedish"   : $_SESSION['lang']="swedish"; break;
        case "greek"     : $_SESSION['lang']="greek"; break;
        case "romanian"  : $_SESSION['lang']="romanian"; break;
        case "hungarian" : $_SESSION['lang']="hungarian"; break;
        case "czech"     : $_SESSION['lang']="czech"; break;
        case "korean"    : $_SESSION['lang']="korean"; break;
        case "norwegian" : $_SESSION['lang']="norwegian"; break;
        case "taiwan"    : $_SESSION['lang']="taiwan"; break;
        case "japan"     : $_SESSION['lang']="japan"; break;
        case "chinese"   : $_SESSION['lang']="chinese"; break;
        case "bulgarian" : $_SESSION['lang']="bulgarian"; break;
        case "lithuanian" : $_SESSION['lang']="lithuanian"; break;
        case "latvian"   : $_SESSION['lang']="latvian"; break;
        case "finnish"   : $_SESSION['lang']="finnish"; break;
        default          : $_SESSION['lang']="german"; break;
    }
}
require "config.php";
include "languages.php";
include_once "functions.inc.php";
include "attributes.php";


mysql_connect($dbhost,$dbusername,$dbpassword) or die(PARSER_ERROR3);
mysql_select_db($dbname) or die(PARSER_ERROR2);

if (isset($_GET['delete']) && is_numeric($_GET['delete'])) {
    $id = (int)$_GET['delete'];
    $query = "DELETE FROM $shouttable WHERE id='$id' LIMIT 1";
    mysql_query($query) or die(mysql_error());
}

if (isset($_POST['comment']) && trim($_POST['comment']) != "") {
    $comment = mysql_real_escape_string(trim(strip_tags(stripslashes($_POST['comment']))));
    if (strlen($comment > 255)) $comment = substr($comment,0,255);

    if (!empty($comment)) {
        $query = "INSERT INTO $shouttable (username,shouttext,shoutdate) VALUES ('".$_SESSION['s_username']."','$comment',NOW())";
        $res = mysql_query($query) or die(mysql_error());
        $query = "SELECT id FROM $shouttable ORDER BY shoutdate ASC";
        $res = mysql_query($query) or die(mysql_error());
        if (mysql_num_rows($res) > $maxshouts) {
            $number = mysql_num_rows($res);
            $where = " id IN (";
            $i = 0;
            while ($line = mysql_fetch_object($res)) {
                if ($i < ($number-$maxshouts)) $where .= $line->id.",";
                else break;
                $i++;
            }
            $where = substr($where,0,strlen($where)-1).")";
            $query = "DELETE FROM $shouttable WHERE ".$where;
            $res = mysql_query($query) or die(mysql_error());
        }
    }
}

$query  = "SELECT count(*) as anzahl FROM $dbtablename WHERE planet=1";
$res = mysql_query($query);
if  (!$res) $_SESSION['s_systems'] = 0;
else {
    $line = mysql_fetch_object($res);
    $_SESSION['s_systems'] = number_format($line->anzahl,0,",",".");
}

if (!isset($_SESSION['s_lastweek']) && strpos($_SERVER['SERVER_ADDR'],"192.168.2.2.galaxytool-hosting.eu") === false) {
    $query  = "SELECT count(*) as anzahl FROM $dbtablename WHERE planet=1 AND DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= last_update";
    $res = mysql_query($query) or die(mysql_error());
    if  (!$res) $_SESSION['s_lastweek'] = 0;
    else {
        $line = mysql_fetch_object($res);
        $_SESSION['s_lastweek'] = number_format($line->anzahl,0,",",".");
    }
}
if (!isset($_SESSION['s_too_old']) && strpos($_SERVER['SERVER_ADDR'],"192.168.2.2.galaxytool-hosting.eu") === false) {
    $query  = "SELECT count(*) as anzahl FROM $dbtablename WHERE planet=1 AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) > last_update";
    $res = mysql_query($query);
    if  (!$res) $$_SESSION['s_too_old'] = 0;
    else {
        $line = mysql_fetch_object($res);
        $_SESSION['s_too_old'] = number_format($line->anzahl,0,",",".");
    }
}

$query  = "SELECT count(*) as anzahl FROM $utablename";
$res = mysql_query($query);
if  (!$res) $_SESSION['s_req_user'] = 0;
else {
    $line = mysql_fetch_object($res);
    $_SESSION['s_req_user'] = number_format($line->anzahl,0,",",".");
}

$query  = "SELECT count(*) as anzahl FROM $noticetable";
$res = mysql_query($query);
if  (!$res) $_SESSION['s_notices'] = 0;
else {
    $line = mysql_fetch_object($res);
    $_SESSION['s_notices'] = number_format($line->anzahl,0,",",".");
}

$query  = "SELECT count(*) as anzahl FROM $playertable";
$res = mysql_query($query);
if  (!$res) $_SESSION['s_players'] = 0;
else {
    $line = mysql_fetch_object($res);
    $_SESSION['s_players'] = number_format($line->anzahl,0,",",".");
}

$query  = "SELECT count(*) as anzahl FROM $allytable";
$res = mysql_query($query);
if  (!$res) $_SESSION['s_allies'] = 0;
else {
    $line = mysql_fetch_object($res);
    $_SESSION['s_allies'] = number_format($line->anzahl,0,",",".");
}

$query  = "SELECT count(*) as anzahl FROM $reporttable";
$res = mysql_query($query);
if  (!$res) $_SESSION['s_reports'] = 0;
else {
    $line = mysql_fetch_object($res);
    $_SESSION['s_reports'] = number_format($line->anzahl,0,",",".");
}

if (!isset($_SESSION['s_umods'])) {
    $query  = "SELECT count(*) as anzahl FROM $playertable WHERE vacation='true'";
    $res = mysql_query($query);
    if  (!$res) $_SESSION['s_umods'] = 0;
    else {
        $line = mysql_fetch_object($res);
        $_SESSION['s_umods'] = number_format($line->anzahl,0,",",".");
    }
}
if (!isset($_SESSION['s_moons'])) {
    $query  = "SELECT count(*) as anzahl FROM $dbtablename WHERE moon='true'";
    $res = mysql_query($query);
    if  (!$res) $_SESSION['s_moons'] = 0;
    else {
        $line = mysql_fetch_object($res);
        $_SESSION['s_moons'] = number_format($line->anzahl,0,",",".");
    }
}
if (!isset($_SESSION['s_raidable'])) {
    $query  = "SELECT count(*) as anzahl FROM $dbtablename g, $playertable p WHERE g.player_id = p.id AND banned='false' AND vacation='false' AND noob='false'";
    $res = mysql_query($query);
    if  (!$res) $_SESSION['s_raidable'] = 0;
    else {
        $line = mysql_fetch_object($res);
        $_SESSION['s_raidable'] = number_format($line->anzahl,0,",",".");
    }
}
// these queries are much to slow for mysql as they cause filesort + temp_tables
//if (!isset($_SESSION['s_empty_systems']) && strpos($_SERVER['SERVER_ADDR'],"192.168.2.2.galaxytool-hosting.eu") === false) {
//    $query  = "SELECT concat(galaxy,':',system) as systems  FROM $dbtablename WHERE player_id = '0' GROUP BY systems HAVING count(*) = 15";
//    $res = mysql_query($query) or die(mysql_error());
//    if  (!$res) $_SESSION['s_empty_systems'] = 0;
//    else {
//        $_SESSION['s_empty_systems'] = number_format(mysql_num_rows($res),0,",",".");
//    }
//}
//if (!isset($_SESSION['s_full_systems']) && strpos($_SERVER['SERVER_ADDR'],"192.168.2.2.galaxytool-hosting.eu") === false) {
//    $query  = "SELECT concat(galaxy,':',system) as systems  FROM $dbtablename WHERE player_id != 0 GROUP BY systems HAVING count(*) = 15";
//    $res = mysql_query($query);
//    if  (!$res) $_SESSION['s_full_systems'] = 0;
//    else {
//        $_SESSION['s_full_systems'] = number_format(mysql_num_rows($res),0,",",".");
//    }
//}
$query = "SELECT u.username,p.id FROM $utablename u LEFT JOIN $playertable p ON (u.ingame=p.playername AND u.ingame!='') WHERE last_action > (NOW() - 300)";
$res = mysql_query($query) or die(mysql_error());
$online = array();
while ($line = mysql_fetch_object($res)) {
	if (trim($line->id) != "") {
		array_push($online,"<a href=\"playerinformation.php?id=".$line->id."\">".$line->username."</a>");
	} else {
    	array_push($online,$line->username);
	}
}

$query = "SELECT u.username,p.id FROM $utablename u LEFT JOIN $playertable p ON (u.ingame=p.playername AND u.ingame!='') WHERE last_action > '".date("Y-m-d")." 00:00:00'";
$res = mysql_query($query) or die(mysql_error());
$today = array();
while ($line = mysql_fetch_object($res)) {
	if (trim($line->id) != "") {
		array_push($today,"<a href=\"playerinformation.php?id=".$line->id."\">".$line->username."</a>");
	} else {
    	array_push($today,$line->username);
	}
}

$query = "SELECT sum(logins) as overall FROM $utablename";
$res = mysql_query($query) or die(mysql_error());
$line = mysql_fetch_object($res);
$overall = $line->overall;


makeheader(INDEX_TITLE);


if (isset($_GET['versionscheck'])) {
    $version = VERSION;
    $latest_version = @file_get_contents("http://www.galaxietool.de/version.txt");
}

?>
<table cellpadding="1" cellspacing="0" border="0" align="center" width="90%"><tr><td>
<table class="standard" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr class="tblhead"><td colspan="2"><?php echo INDEX_INFO; ?></td></tr>
<?php
if (isset($latest_version) && !empty($latest_version) && (("v".$latest_version) != $version)) {
    echo '<tr class="firstcolor"><td><a href="http://www.galaxytool.eu/" class="link" target="extern">'.INDEX_VERSION.'</a></td><td><a href="http://www.galaxytool.eu/" class="link" target="extern">'.$latest_version."</a></td>\n";
} elseif (isset($latest_version)) {
    echo '<tr class="firstcolor"><td colspan="2">'.INDEX_LATEST_VERSION."</td></tr>\n";
}

if (isset($_SESSION['s_systems'])) echo '<tr class="firstcolor"><td>'.INDEX_ENTRIES.'</td><td>'.$_SESSION['s_systems'].'</td>';
if (isset($_SESSION['s_lastweek'])) echo '<tr class="firstcolor"><td>'.INDEX_ENTRIES_LASTWEEK.'</td><td>'.$_SESSION['s_lastweek'].'</td>';
if (isset($_SESSION['s_too_old'])) echo '<tr class="firstcolor"><td>'.INDEX_ENTRIES_TO_OLD.'</td><td>'.$_SESSION['s_too_old'].'</td>';
if (isset($_SESSION['s_req_user'])) echo '<tr class="firstcolor"><td>'.INDEX_REGISTERED_USERS.'</td><td>'.$_SESSION['s_req_user'].'</td>';
if (isset($_SESSION['s_notices'])) echo '<tr class="firstcolor"><td>'.INDEX_NOTICES.'</td><td>'.$_SESSION['s_notices'].'</td>';
if (isset($_SESSION['s_players'])) echo '<tr class="firstcolor"><td>'.INDEX_PLAYERS.'</td><td>'.$_SESSION['s_players'].'</td>';
if (isset($_SESSION['s_allies'])) echo '<tr class="firstcolor"><td>'.INDEX_ALLIES.'</td><td>'.$_SESSION['s_allies'].'</td>';
if (isset($_SESSION['s_reports'])) echo '<tr class="firstcolor"><td>'.INDEX_REPORTS.'</td><td>'.$_SESSION['s_reports'].'</td>';
if (isset($_SESSION['s_umods'])) echo '<tr class="firstcolor"><td>'.INDEX_UMOD.'</td><td>'.$_SESSION['s_umods'].'</td>';
if (isset($_SESSION['s_moons'])) echo '<tr class="firstcolor"><td>'.INDEX_NO_MOONS.'</td><td>'.$_SESSION['s_moons'].'</td>';
if (isset($_SESSION['s_raidable'])) echo '<tr class="firstcolor"><td>'.INDEX_NO_TARGETS.'</td><td>'.$_SESSION['s_raidable'].'</td>';
if (isset($_SESSION['s_empty_systems'])) echo '<tr class="firstcolor"><td>'.INDEX_NO_EMPTY_SYSTEMS.'</td><td>'.$_SESSION['s_empty_systems'].'</td>';
if (isset($_SESSION['s_full_systems'])) echo '<tr class="firstcolor"><td>'.INDEX_NO_FULL_SYSTEMS.'</td><td>'.$_SESSION['s_full_systems'].'</td>';
?>
</tr>
</table>

<form action="index.php" method="POST"  accept-charset="utf-8">
<table class="standard" cellpadding="4" cellspacing="0" border="0" width="100%" style="margin-top:50px;">
<tr class="tblhead"><td colspan="2"><?php echo INDEX_SHOUTBOX; ?></td></tr>
<?php
$query = "SELECT *,CONVERT_TZ(shoutdate, '+00:00', '".$_SESSION['s_timezone_offset']."') as shoutdate FROM $shouttable ORDER BY shoutdate DESC";
$res = mysql_query($query) or die(mysql_error());
while ($line = mysql_fetch_object($res)) {
    if ($_SESSION['s_userman']) {
        echo '<tr class="firstcolor"><td valign="middle" style="width:150px;"><a href="index.php?delete='.$line->id.'"><img src="../images/delete.gif" border="0" style="vertical-align: middle;" /></a>['.substr($line->shoutdate,5,11).'] '.$line->username.':</td><td>'.$line->shouttext.'</td></tr>'."\n";
    } else {
        echo '<tr class="firstcolor"><td valign="top" style="width:150px;">['.substr($line->shoutdate,5,11).'] '.$line->username.':</td><td>'.$line->shouttext.'</td></tr>'."\n";
    }

}
if (mysql_num_rows($res) == 0) {
    echo '<tr class="firstcolor"><td colspan="2">'.INDEX_NOENTRY.'</td></tr>';
}
echo '<tr class="firstcolor"><td colspan="2">'.INDEX_COMMENT.':
	  <input type="text" class="textfield" maxlength="255" style="width:350px;" name="comment" value="" />
	  <input type="submit" class="button" name="'.urlencode(INDEX_INSERT).'" value="'.INDEX_INSERT.'" />
	  </td></tr>';

?>
</table>
</form>
<table class="standard" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr class="tblhead"><td colspan="2"><?php echo INDEX_USERINFO; ?></td></tr>
<tr class="firstcolor"><td><?php echo INDEX_ONLINE.": <strong>"; echo count($online); ?></strong></td><td><?php echo implode(", ",$online); ?></td>
</tr>
<tr class="firstcolor"><td><?php echo INDEX_TODAY.": <strong>"; echo count($today); ?></strong></td><td><?php echo implode(", ",$today); ?></td>
</tr>
<tr class="firstcolor"><td colspan="2"><?php echo INDEX_ALL.": <strong>"; echo $overall; ?></strong></td>
</tr>
</table>
</td></tr>
</table>

<?php
makefooter();
?>