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

include "logincheck.inc.php";
if (!$_SESSION['s_cansearch']) {
    $error_page_code = "permission";
    include "errorpage.php";
    exit();
}

require "config.php";
include "languages.php";
include_once "functions.inc.php";
include "attributes.php";

makeheader(SHOW_TITLE);

// array for notices with ajax
$notice_array = array();
// array for reports with ajax
$report_array = array();

if (isset($_POST['entries'])) {
    unset($_SESSION['s_hits']);
    $_SESSION['s_hits'] = (int)$_POST['entries'];
}
$entries_per_page = $_SESSION['s_hits'];

if ((!isset($_GET['page']) && (!isset($_POST['searchbutton']) || !isset($_POST['bb_code'])) && !isset($_GET['ally']) && !isset($_GET['spieler'])) || isset($_GET['new'])) {
    // Sessionvars killen
    unset($_SESSION['s_allysuche']);
    unset($_SESSION['s_spielersuche']);
    unset($_SESSION['s_moonsearch']);
    unset($_SESSION['s_colonysearch']);
    unset($_SESSION['s_sorder1']);
    unset($_SESSION['s_sorder2']);
    unset($_SESSION['s_checked1']);
    unset($_SESSION['s_checked2']);
    unset($_SESSION['s_noticesearch']);
    unset($_SESSION['s_reportsearch']);
    unset($_SESSION['s_nchecked1']);
    unset($_SESSION['s_nchecked2']);
    unset($_SESSION['s_rchecked1']);
    unset($_SESSION['s_rchecked2']);
    unset($_SESSION['s_cchecked1']);
    unset($_SESSION['s_cchecked2']);
    unset($_SESSION['s_schecked1']);
    unset($_SESSION['s_schecked2']);
    unset($_SESSION['s_schecked3']);
    unset($_SESSION['s_schecked4']);
    unset($_SESSION['s_galaxie']);
    unset($_SESSION['s_system1']);
    unset($_SESSION['s_system2']);
    unset($_SESSION['s_planet1']);
    unset($_SESSION['s_planet2']);
    unset($_SESSION['s_status1']);
    unset($_SESSION['s_status2']);
    unset($_SESSION['s_status3']);
    unset($_SESSION['s_allystatus2']);
    unset($_SESSION['s_allystatus3']);
    unset($_SESSION['s_allystatus4']);
    unset($_SESSION['s_allystatus5']);
    unset($_SESSION['s_allystatus6']);
    unset($_SESSION['s_allystatus7']);
    unset($_SESSION['s_allystatus8']);
    unset($_SESSION['s_sort']);
    unset($_SESSION['s_datevalue']);
    unset($_SESSION['s_tyear']);
    unset($_SESSION['s_tmonth']);
    unset($_SESSION['s_tday']);
    unset($_SESSION['s_thour']);
    unset($_SESSION['s_minute']);
    unset($_SESSION['s_second']);
    unset($_SESSION['s_metal']);
    unset($_SESSION['s_crystal']);
    unset($_SESSION['s_both']);
    unset($_SESSION['s_minrank']);
    unset($_SESSION['s_minfrank']);
    unset($_SESSION['s_maxrank']);
    unset($_SESSION['s_maxfrank']);
    unset($_SESSION['s_bbcodes']);
}

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

$allysuche = "";
$spielersuche = "";
$galaxie = "";
$system1 = "";
$system2 = "";
$planet1 = "";
$planet2 = "";
$moonsearch = 0;
$noticesearch = 0;
$reportsearch = 0;
$colonysearch = 0;
$minrank = 0;
$minfrank = 0;
$maxrank = 1500;
$maxfrank = 1500;
$sortarray = array("Galaxie/System","Spielername","Allianzname");
if (isset($_GET['page']) && is_numeric($_GET['page'])) $page = (int)$_GET['page'];
else $page = 1;
$limit = " LIMIT ".(($page-1)*$entries_per_page).",".$entries_per_page;

if (isset($_POST['ally']) && !empty($_POST['ally'])) {
    $allysuche = trim(addslashes(strip_tags($_POST['ally'])));
    $allysuche = preg_replace("/[^a-zA-Z0-9\*\s-_.]/","", $allysuche);
}
if (isset($_GET['ally']) && !empty($_GET['ally'])) {
    $allysuche = trim(addslashes(strip_tags($_GET['ally'])));
    $allysuche = preg_replace("/[^a-zA-Z0-9\*\s-_.]/","", $allysuche);
}

if (isset($_POST['spieler']) && !empty($_POST['spieler'])) {
    $spielersuche = trim(addslashes(strip_tags($_POST['spieler'])));
    $spielersuche = preg_replace("/[^a-zA-Z0-9\*\s-_.]/","", $spielersuche);
}
if (isset($_GET['spieler']) && !empty($_GET['spieler'])) {
    $spielersuche = trim(addslashes(strip_tags($_GET['spieler'])));
    $spielersuche = preg_replace("/[^a-zA-Z0-9\*\s-_.]/","", $spielersuche);
}
if (isset($_POST['moonsearch']) && !empty($_POST['moonsearch'])) {
    $moonsearch = trim(addslashes(strip_tags($_POST['moonsearch'])));
}
if (isset($_POST['noticesearch']) && !empty($_POST['noticesearch'])) {
    $noticesearch = trim(addslashes(strip_tags($_POST['noticesearch'])));
}
if (isset($_POST['colonysearch']) && !empty($_POST['colonysearch'])) {
    $colonysearch = trim(addslashes(strip_tags($_POST['colonysearch'])));
}
if (isset($_POST['reportsearch']) && !empty($_POST['reportsearch'])) {
    $reportsearch = trim(addslashes(strip_tags($_POST['reportsearch'])));
}
if (isset($_POST['galaxie']) && !empty($_POST['galaxie'])) {
    $galaxie = $_POST['galaxie'];
    $galaxie  = preg_replace("/([^0-9])/","",$galaxie);
}
if (isset($_POST['system1']) && !empty($_POST['system1'])) {
    $system1 = $_POST['system1'];
    $system1  = preg_replace("/([^0-9])/","",$system1);
    if ($system1 > 498) $system1 = 498;
    if ($system1 < 1) $system1 = 1;
}
if (isset($_POST['system2']) && !empty($_POST['system2'])) {
    $system2 = $_POST['system2'];
    $system2  = preg_replace("/([^0-9])/","",$system2);
    if ($system2 > 499) $system2 = 499;
    if ($system2 < 2) $system2 = 2;
}
if (isset($_POST['planet1']) && !empty($_POST['planet1'])) {
    $planet1 = $_POST['planet1'];
    $planet1  = preg_replace("/([^0-9])/","",$planet1);
    if ($planet1 > 14) $planet1 = 14;
    if ($planet1 < 1) $planet1 = 1;
}
if (isset($_POST['planet2']) && !empty($_POST['planet2'])) {
    $planet2 = $_POST['planet2'];
    $planet2  = preg_replace("/([^0-9])/","",$planet2);
    if ($planet2 > 15) $planet2 = 15;
    if ($planet2 < 2) $planet2 = 2;
}

if (isset($_POST['datevalue']) && is_numeric($_POST['datevalue'])) {
    $date_value = (int)$_POST['datevalue'];
} else $date_value = 0;
if (isset($_POST['year']) && is_numeric($_POST['year'])) {
    $tyear = (int)$_POST['year'];
} else $tyear = date("Y")-1;
if (isset($_POST['month']) && is_numeric($_POST['month'])) {
    $tmonth = (int)$_POST['month'];
} else $tmonth = date("m");
if (isset($_POST['day']) && is_numeric($_POST['day'])) {
    $tday = (int)$_POST['day'];
} else $tday = date("d");
if (isset($_POST['hour']) && is_numeric($_POST['hour'])) {
    $thour = (int)$_POST['hour'];
} else $thour = date("H");
if (isset($_POST['minute']) && is_numeric($_POST['minute'])) {
    $tminute = (int)$_POST['minute'];
} else $tminute = date("i");
if (isset($_POST['second']) && is_numeric($_POST['second'])) {
    $tsecond = (int)$_POST['second'];
} else $tsecond = date("s");
if (isset($_POST['metal']) && is_numeric($_POST['metal'])) {
    $metal = (int)$_POST['metal'];
} else $metal = 0;
if (isset($_POST['crystal']) && is_numeric($_POST['crystal'])) {
    $crystal = (int)$_POST['crystal'];
} else $crystal = 0;
if (isset($_POST['both']) && is_numeric($_POST['both'])) {
    $both = (int)$_POST['both'];
} else $both = 0;
if (isset($_POST['minrank']) && is_numeric($_POST['minrank'])) {
    $minrank = (int)$_POST['minrank'];
} else $minrank = 0;
if (isset($_POST['minfrank']) && is_numeric($_POST['minfrank'])) {
    $minfrank = (int)$_POST['minfrank'];
} else $minfrank = 0;
if (isset($_POST['maxrank']) && is_numeric($_POST['maxrank'])) {
    $maxrank = (int)$_POST['maxrank'];
} else $maxrank = 0;
if (isset($_POST['maxfrank']) && is_numeric($_POST['maxfrank'])) {
    $maxfrank = (int)$_POST['maxfrank'];
} else $maxfrank = 0;
if (isset($_POST['bb_code'])) {
    $bb_code = 1;
} else $bb_code = 0;

if (isset($_POST['status1'])) $status1 = "checked"; elseif (!isset($_POST['done'])) $status1 = "checked"; else $status1 = "";
if (isset($_POST['status2'])) $status2 = "checked"; else $status2 = "";
if (isset($_POST['status3'])) $status3 = "checked"; else $status3 = "";
$allystatus2 = (isset($_POST['allystatus2'])) ? "checked" : "";
$allystatus3 = (isset($_POST['allystatus3'])) ? "checked" : "";
$allystatus4 = (isset($_POST['allystatus4'])) ? "checked" : "";
$allystatus5 = (isset($_POST['allystatus5'])) ? "checked" : "";
$allystatus6 = (isset($_POST['allystatus6'])) ? "checked" : "";
$allystatus7 = (isset($_POST['allystatus7'])) ? "checked" : "";
$allystatus8 = (isset($_POST['allystatus8'])) ? "checked" : "";
if (is_numeric($system1) && (!is_numeric($system2))) $system2= 499;
if (!is_numeric($system1) && (is_numeric($system2))) $system1= 1;
if (is_numeric($planet1) && (!is_numeric($planet2))) $planet2 = 15;
if (!is_numeric($planet1) && (is_numeric($planet2))) $planet1= 1;
if (($moonsearch==1 || $noticesearch == 1 || $reportsearch == 1) && (!is_numeric($system1))) $system1=1;
if (($moonsearch==1 || $noticesearch == 1 || $reportsearch == 1) && (!is_numeric($system2))) $system2=499;
if ($colonysearch == 1 && !is_numeric($planet1)) $planet1 = 1;
if ($colonysearch == 1 && !is_numeric($planet2)) $planet2 = 15;
if (isset($_POST['sort'])) $sort = $_POST['sort'];
else $sort = 0;
if (isset($_POST['sortorder'])) $sortorder = $_POST['sortorder'];
else $sortorder = 0;


// Spielersortierung
if ($sort == 0) {
    $sort = " ORDER BY galaxy,system,planet";
    $schecked1 = "checked";
    $schecked2 = "";
    $schecked3 = "";
    $schecked4 = "";
}
if ($sort == 1) {
    $sort = " ORDER BY playername";
    $schecked1 = "";
    $schecked2 = "checked";
    $schecked3 = "";
    $schecked4 = "";
}
if ($sort == 2) {
    $sort = " ORDER BY allyname";
    $schecked1 = "";
    $schecked2 = "";
    $schecked3 = "checked";
    $schecked4 = "";
}

$sorder1 = "";
$sorder2 = "";
if ($sortorder == 0) {
    $sort .= " ASC";
    $sorder1 = "checked";
} else {
    $sort .= " DESC";
    $sorder2 = "checked";
}

$date_checked0 = "";
$date_checked1 = "";
$date_checked2 = "";
if ($date_value == 0) {
    $date_checked0 = "checked";
} elseif ($date_value == 1) {
    $date_checked1 = "checked";
} elseif ($date_value == 2) {
    $date_checked2 = "checked";
}


$allysuche = (!isset($_POST['ally']) && !isset($_GET['ally']) && isset($_SESSION['s_allysuche'])) ? $_SESSION['s_allysuche'] : $allysuche;
$spielersuche = (!isset($_POST['spieler']) && !isset($_GET['spieler']) && isset($_SESSION['s_spielersuche'])) ? $_SESSION['s_spielersuche'] : $spielersuche;
$moonsearch = (!isset($_POST['moonsearch']) && isset($_SESSION['s_moonsearch'])) ? $_SESSION['s_moonsearch'] : $moonsearch;
$noticesearch = (!isset($_POST['noticesearch']) && isset($_SESSION['s_noticesearch'])) ? $_SESSION['s_noticesearch'] : $noticesearch;
$colonysearch = (!isset($_POST['s_colonysearch']) && isset($_SESSION['s_colonysearch'])) ? $_SESSION['s_colonysearch'] : $colonysearch;
$reportsearch = (!isset($_POST['reportsearch']) && isset($_SESSION['s_reportsearch'])) ? $_SESSION['s_reportsearch'] : $reportsearch;
$schecked1 = (!isset($_POST['sort']) && isset($_SESSION['s_schecked1'])) ? $_SESSION['s_schecked1'] : $schecked1;
$schecked2 = (!isset($_POST['sort']) && isset($_SESSION['s_schecked2'])) ? $_SESSION['s_schecked2'] : $schecked2;
$schecked3 = (!isset($_POST['sort']) && isset($_SESSION['s_schecked3'])) ? $_SESSION['s_schecked3'] : $schecked3;
$galaxie = (!isset($_POST['galaxie']) && isset($_SESSION['s_galaxie'])) ? $_SESSION['s_galaxie'] : $galaxie;
$system1 = (!isset($_POST['system1']) && isset($_SESSION['s_system1'])) ? $_SESSION['s_system1'] : $system1;
$system2 = (!isset($_POST['system2']) && isset($_SESSION['s_system2'])) ? $_SESSION['s_system2'] : $system2;
$planet1 = (!isset($_POST['planet1']) && isset($_SESSION['s_planet1'])) ? $_SESSION['s_planet1'] : $planet1;
$planet2 = (!isset($_POST['planet2']) && isset($_SESSION['s_planet2'])) ? $_SESSION['s_planet2'] : $planet2;
$status1 = (!isset($_POST['sort']) && isset($_SESSION['s_status1'])) ? $_SESSION['s_status1'] : $status1;
$status2 = (!isset($_POST['sort']) && isset($_SESSION['s_status2'])) ? $_SESSION['s_status2'] : $status2;
$status3 = (!isset($_POST['sort']) && isset($_SESSION['s_status3'])) ? $_SESSION['s_status3'] : $status3;
$allystatus2 = (!isset($_POST['allystatus2']) && isset($_SESSION['s_allystatus2'])) ? $_SESSION['s_allystatus2'] : $allystatus2;
$allystatus3 = (!isset($_POST['allystatus3']) && isset($_SESSION['s_allystatus3'])) ? $_SESSION['s_allystatus3'] : $allystatus3;
$allystatus4 = (!isset($_POST['allystatus4']) && isset($_SESSION['s_allystatus4'])) ? $_SESSION['s_allystatus4'] : $allystatus4;
$allystatus5 = (!isset($_POST['allystatus5']) && isset($_SESSION['s_allystatus5'])) ? $_SESSION['s_allystatus5'] : $allystatus5;
$allystatus6 = (!isset($_POST['allystatus6']) && isset($_SESSION['s_allystatus6'])) ? $_SESSION['s_allystatus6'] : $allystatus6;
$allystatus7 = (!isset($_POST['allystatus7']) && isset($_SESSION['s_allystatus7'])) ? $_SESSION['s_allystatus7'] : $allystatus7;
$allystatus8 = (!isset($_POST['allystatus8']) && isset($_SESSION['s_allystatus8'])) ? $_SESSION['s_allystatus8'] : $allystatus8;
$sort    = (!isset($_POST['sort']) && isset($_SESSION['s_sort'])) ? $_SESSION['s_sort'] : $sort;
$date_value = (!isset($_POST['datevalue']) && isset($_SESSION['s_datevalue'])) ? $_SESSION['s_datevalue'] : $date_value;
$tyear   = (!isset($_POST['year']) && isset($_SESSION['s_tyear'])) ? $_SESSION['s_tyear'] : $tyear;
$tmonth  = (!isset($_POST['month']) && isset($_SESSION['s_tmonth'])) ? $_SESSION['s_tmonth'] : $tmonth;
$tday    = (!isset($_POST['day']) && isset($_SESSION['s_tday'])) ? $_SESSION['s_tday'] : $tday;
$thour   = (!isset($_POST['hour']) && isset($_SESSION['s_thour'])) ? $_SESSION['s_thour'] : $thour;
$tminute = (!isset($_POST['minute']) && isset($_SESSION['s_tminute'])) ? $_SESSION['s_tminute'] : $tminute;
$tsecond = (!isset($_POST['second']) && isset($_SESSION['s_tsecond'])) ? $_SESSION['s_tsecond'] : $tsecond;
$metal   = (!isset($_POST['metal']) && isset($_SESSION['s_metal'])) ? $_SESSION['s_metal'] : $metal;
$crystal = (!isset($_POST['crystall']) && isset($_SESSION['s_crystall'])) ? $_SESSION['s_crystall'] : $crystal;
$both    = (!isset($_POST['both']) && isset($_SESSION['s_both'])) ? $_SESSION['s_both'] : $both;
$minrank    = (!isset($_POST['minrank']) && isset($_SESSION['s_minrank'])) ? $_SESSION['s_minrank'] : $minrank;
$minfrank   = (!isset($_POST['minfrank']) && isset($_SESSION['s_minfrank'])) ? $_SESSION['s_minfrank'] : $minfrank;
$maxrank    = (!isset($_POST['maxrank']) && isset($_SESSION['s_maxrank'])) ? $_SESSION['s_maxrank'] : $maxrank;
$maxfrank   = (!isset($_POST['maxfrank']) && isset($_SESSION['s_maxfrank'])) ? $_SESSION['s_maxfrank'] : $maxfrank;
$bb_code    = (!isset($_POST['bb_code']) && isset($_SESSION['s_bbcodes'])) ? $_SESSION['s_bbcodes'] : $bb_code;

$date = $tyear."-".$tmonth."-".$tday." ".
$thour.":".$tminute.":".$tsecond." GMT";
$time = strtotime($date);
$operator = substr($_SESSION['s_timezone_offset'],0,1);
$hours    = substr($_SESSION['s_timezone_offset'],2,2);
$minutes  = substr($_SESSION['s_timezone_offset'],3,2);
if ($operator == "-") {
	$time -= 60 * 60 * $hours;
	$time -= 60 * $minutes;
} else {
	$time += 60 * 60 * $hours;
	$time += 60 * $minutes;
}

// Gerinfgügige Ungenauigkeit durch Sommmer/Winterzeit gegeben (+-1 Stunde)

?>
<form name="suche" method="post" action="show.php"  accept-charset="utf-8">
<table cellpadding="1" cellspacing="0" border="0" align="center" width="95%"><tr><td>
<table class="standard" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr class="tblhead"><td colspan="2"><?php echo SHOW_SEARCH; ?></td></tr>
<tr class="firstcolor"><td><?php echo SHOW_ALLYSYMBOL; ?></td>

<td><input class="textfield" name="ally" type="" value="<?php echo $allysuche; ?>" /></td>
</tr>
<tr class="firstcolor"><td><?php echo SHOW_PLAYERNAME; ?></td>
<td><input class="textfield" name="spieler" type="" value="<?php echo $spielersuche; ?>" /></td>
</tr>
<tr class="firstcolor"><td colspan="2" align="right">
<img alt="hide or unhide extended search 1" src="../images/options.gif" onclick="hideUnhideObject('extended1')" onmouseover='this.T_WIDTH=150;return escape("<?php echo utf8_encode(SHOW_EXT_OPTIONS1); ?>")' />&nbsp;
<img alt="hide or unhide extended search 2" src="../images/options.gif" onclick="hideUnhideObject('extended2')" onmouseover='this.T_WIDTH=150;return escape("<?php echo utf8_encode(SHOW_EXT_OPTIONS2); ?>")' />&nbsp;
<img alt="hide or unhide extended search 3" src="../images/options.gif" onclick="hideUnhideObject('extended3')" onmouseover='this.T_WIDTH=150;return escape("<?php echo utf8_encode(SHOW_EXT_OPTIONS3); ?>")' />
</td></tr>
</table>
<table id="extended1" class="standard" style="display:none" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr class="firstcolor"><td><?php echo SHOW_SEARCHRANGE; ?></td>
<td><?php echo SHOW_SEARCH_IN; ?> <input class="textfield" name="galaxie" type="text" size="3" maxlength="2" value="<?php echo $galaxie; ?>"> <?php echo SHOW_FROM_SYSTEM; ?> <input class="textfield" name="system1" type="text" size="5" maxlength="3" value="<?php echo $system1; ?>"> <?php echo SHOW_TO; ?> <input class="textfield" name="system2" type="text" size="5" maxlength="3" value="<?php echo $system2; ?>"></td>
</tr>

<tr class="firstcolor"><td><?php echo SHOW_RANK; ?></td>
<td><?php echo VIEW_TOP; ?>: <input class="textfield" style="text-align:right;" name="minrank" type="text" size="4" maxlength="4" value="<?php echo $minrank; ?>"> - <input class="textfield" style="text-align:right;" name="maxrank" type="text" size="4" maxlength="4" value="<?php echo $maxrank; ?>"></td>
</tr>

<tr class="firstcolor"><td><?php echo SHOW_FRANK; ?></td>
<td><?php echo VIEW_TOP; ?>: <input class="textfield" style="text-align:right;" name="minfrank" type="text" size="4" maxlength="4" value="<?php echo $minfrank; ?>"> - <input class="textfield" style="text-align:right;" name="maxfrank" type="text" size="4" maxlength="4" value="<?php echo $maxfrank; ?>"></td>
</tr>

<tr class='firstcolor' valign='top'><td colspan='2'><?php echo SHOW_DESCRIPTION; ?></td></tr>
<tr class="firstcolor">
<td><?php echo SHOW_DATE; ?>:</td>
<td>
<input class="textfield" name="datevalue" type="radio" value="0" <?php echo $date_checked0; ?>  /><?php echo SHOW_DATE_0; ?>&nbsp;&nbsp;
<input class="textfield" name="datevalue" type="radio" value="1" <?php echo $date_checked1; ?>  /><?php echo SHOW_DATE_1; ?>&nbsp;&nbsp;
<input class="textfield" name="datevalue" type="radio" value="2" <?php echo $date_checked2; ?>  /><?php echo SHOW_DATE_2; ?>
<br>
<?php
// Tag
pulldowncode("day",1,31,1, $tday);
echo "&nbsp;";
// Monat
pulldowncode("month",1,12,1, $tmonth);
echo "&nbsp;";
// Jahr
pulldowncode("year",2004,date("Y"),1, $tyear);
echo "&nbsp;";
// Stunde
pulldowncode("hour",0,23,1, $thour);
echo "&nbsp;";
// Minute
pulldowncode("minute",0,59,1, $tminute);
echo "&nbsp;";
// Sekunde
pulldowncode("second",0,59,1, $tsecond);
echo "&nbsp;";

?>
</td></tr>

<tr class="firstcolor">
<td><?php echo SHOW_DF_LONG; ?></td>
<td>
<?php echo SHOW_METAL_LONG." ".SHOW_AT_LEAST; ?>: <input class="textfield" name="metal" type="text" size="8" maxlength="10" value="<?php echo $metal; ?>">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<?php echo SHOW_CRYSTAL_LONG." ".SHOW_AT_LEAST; ?>: <input class="textfield" name="crystal" type="text" size="8" maxlength="10" value="<?php echo $crystal; ?>"><br>
<?php echo SHOW_BOTH." ".SHOW_AT_LEAST; ?>: <input class="textfield" name="both" type="text" size="8" maxlength="10" value="<?php echo $both; ?>">
</td>
</tr>
</table>
<table id="extended2" class="standard" style="display:none" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr class="firstcolor"><td><?php echo SHOW_MOONS; ?></td>
<?php
if ($moonsearch==1) {
    $checked1="checked";
    $checked2="";
} else {
    $checked1="";
    $checked2="checked";
}
$checked1 = (!isset($_POST['moonsearch']) && isset($_SESSION['s_checked1'])) ? $_SESSION['s_checked1'] : $checked1;
$checked2 = (!isset($_POST['moonsearch']) && isset($_SESSION['s_checked2'])) ? $_SESSION['s_checked2'] : $checked2;
$sorder1 = (!isset($_POST['sortorder']) && isset($_SESSION['s_sorder1'])) ? $_SESSION['s_sorder1'] : $sorder1;
$sorder2 = (!isset($_POST['sortorder']) && isset($_SESSION['s_sorder2'])) ? $_SESSION['s_sorder2'] : $sorder2;

?>
<td><input name="moonsearch" type="radio" value="1"  <?php echo $checked1; ?> /><?php echo SHOW_YES; ?>
<input name="moonsearch" type="radio" value="0" <?php echo $checked2; ?> /><?php echo SHOW_NO; ?> </td>
</tr>
<tr class="firstcolor"><td><?php echo SHOW_NOTICES; ?></td>
<?php
if ($noticesearch == 1) {
    $nchecked1="checked";
    $nchecked2="";
} else {
    $nchecked1="";
    $nchecked2="checked";
}
$nchecked1 = (!isset($_POST['noticesearch']) && isset($_SESSION['s_nchecked1'])) ? $_SESSION['s_nchecked1'] : $nchecked1;
$nchecked2 = (!isset($_POST['noticesearch']) && isset($_SESSION['s_nchecked2'])) ? $_SESSION['s_nchecked2'] : $nchecked2;
?>
<td><input name="noticesearch" type="radio" value="1"  <?php echo $nchecked1; ?> /><?php echo SHOW_YES; ?>
<input name="noticesearch" type="radio" value="0" <?php echo $nchecked2; ?> /><?php echo SHOW_NO; ?></td>
</tr>
<tr class="firstcolor"><td><?php echo SHOW_REPORTS; ?></td>
<?php
if ($reportsearch == 1) {
    $rchecked1="checked";
    $rchecked2="";
} else {
    $rchecked1="";
    $rchecked2="checked";
}
$rchecked1 = (!isset($_POST['reportsearch']) && isset($_SESSION['s_rchecked1'])) ? $_SESSION['s_rchecked1'] : $rchecked1;
$rchecked2 = (!isset($_POST['reportsearch']) && isset($_SESSION['s_rchecked2'])) ? $_SESSION['s_rchecked2'] : $rchecked2;
?>
<td><input name="reportsearch" type="radio" value="1"  <?php echo $rchecked1; ?> /><?php echo SHOW_YES; ?>
<input name="reportsearch" type="radio" value="0" <?php echo $rchecked2; ?> /><?php echo SHOW_NO; ?></td>
</tr>

<tr class="firstcolor"><td><?php echo SHOW_COLONIES; ?></td>
<?php
if ($colonysearch == 1) {
    $cchecked1="checked";
    $cchecked2="";
} else {
    $cchecked1="";
    $cchecked2="checked";
}
$cchecked1 = (!isset($_POST['colonysearch']) && isset($_SESSION['s_cchecked1'])) ? $_SESSION['s_cchecked1'] : $cchecked1;
$cchecked2 = (!isset($_POST['colonysearch']) && isset($_SESSION['s_cchecked2'])) ? $_SESSION['s_cchecked2'] : $cchecked2;
?>
<td><input name="colonysearch" type="radio" value="1"  <?php echo $cchecked1; ?> /><?php echo SHOW_YES; ?>
<input name="colonysearch" type="radio" value="0" <?php echo $cchecked2; ?> /><?php echo SHOW_NO; ?>
&nbsp;&nbsp;&nbsp;<?php echo SHOW_FROM_PLANET; ?> <input class="textfield" name="planet1" type="text" size="3" maxlength="2" value="<?php echo $planet1; ?>">
<?php echo SHOW_TO; ?> <input class="textfield" name="planet2" type="text" size="3" maxlength="2" value="<?php echo $planet2; ?>">
</td>
</tr>

<tr class="firstcolor"><td><?php echo SHOW_PLAYER_STATUS; ?></td>
<td><input name="status1" type="checkbox" <?php echo $status1; ?>  /><?php echo SHOW_PLAYER_STATUS1; ?>
<input name="status2" type="checkbox" <?php echo $status2; ?>  /><?php echo SHOW_PLAYER_STATUS2; ?>
<input name="status3" type="checkbox" <?php echo $status3; ?>  /><?php echo SHOW_PLAYER_STATUS3; ?>
<input type="hidden" name="done" value="true" />
</td></tr>
<tr class="firstcolor"><td><?php echo SHOW_ALLIANCE_STATUS; ?></td>
<td>
<table>
<tr class="firstcolor">
<td><input name="allystatus2" type="checkbox" <?php echo $allystatus2; ?>  /><?php echo SHOW_NAP; ?></td>
<td><input name="allystatus3" type="checkbox" <?php echo $allystatus3; ?>  /><?php echo SHOW_ALLIED; ?></td>
<td><input name="allystatus4" type="checkbox" <?php echo $allystatus4; ?>  /><?php echo SHOW_WAR; ?></td>
</tr>
<tr class="firstcolor">
<td><input name="allystatus5" type="checkbox" <?php echo $allystatus5; ?>  /><?php echo SHOW_BOYCOTT; ?></td>
<td><input name="allystatus6" type="checkbox" <?php echo $allystatus6; ?>  /><?php echo SHOW_NEUTRAL; ?></td>
<td><input name="allystatus7" type="checkbox" <?php echo $allystatus7; ?>  /><?php echo SHOW_OWN; ?></td>
</tr>
<tr class="firstcolor">
<td><input name="allystatus8" type="checkbox" <?php echo $allystatus8; ?>  /><?php echo SHOW_WING; ?></td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
</td></tr>
<tr class="firstcolor"><td><?php echo SHOW_RESULTS; ?></td>
<td><select name="entries" class="pulldown_code">
<option value="10" <?php if ($_SESSION['s_hits'] == 10) echo "selected"; ?>>10</option>
<option value="20" <?php if ($_SESSION['s_hits'] == 20) echo "selected"; ?>>20</option>
<option value="50" <?php if ($_SESSION['s_hits'] == 50) echo "selected"; ?>>50</option>
<option value="100" <?php if ($_SESSION['s_hits'] == 100) echo "selected"; ?>>100</option>
</select>
</td></tr>
</table>

<table  id="extended3" class="standard" style="display:none" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr class="firstcolor"><td><?php echo SHOW_SORT_BY; ?></td>
<td><input name="sort" type="radio" value="0" <?php echo $schecked1; ?>  /><?php echo SHOW_GALASYSTEM; ?>
<input name="sort" type="radio" value="1" <?php echo $schecked2; ?>  /><?php echo SHOW_PLAYERNAME; ?>
<input name="sort" type="radio" value="2" <?php echo $schecked3; ?>  /><?php echo SHOW_ALLYNAME; ?>
<br>
<input name="sortorder" type="radio" value="0" <?php echo $sorder1; ?>  /><?php echo SHOW_ASC; ?>
<input name="sortorder" type="radio" value="1" <?php echo $sorder2; ?>  /><?php echo SHOW_DESC; ?>
</td></tr>
</table>

<table class="standard" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr class="firstcolor" valign="top">
<td align="right"><input class="button" type="submit" name="searchbutton" value="<?php echo SHOW_SEARCHBUTTON; ?>" /></td>
<td><input class="button" type="submit" name="bb_code" value="BB-Code" /></td>
</tr></table>
</td></tr>
</table>
</form>


<?php

$whereclause = "WHERE";
$wheres = 0;
if (!empty($allysuche) || !empty($spielersuche) || ($moonsearch==1) || ($noticesearch==1) || ($reportsearch == 1) || ($colonysearch==1) ||
($status2=="checked") || ($status3=="checked") || isset($_SESSION['s_query']) || !empty($metal) || !empty($crystal) || !empty($both) ||
!empty($allystatus2) || !empty($allystatus3) || !empty($allystatus4) || !empty($allystatus5) ||
!empty($allystatus6) || !empty($allystatus7) || !empty($allystatus8) ) {

    if (!empty($allysuche)) {
        $allysuche = str_replace("*","%",$allysuche);
        if ($wheres == 0) $whereclause.=" a.allyname LIKE '$allysuche' ";
        else $whereclause.=" AND a.allyname LIKE '$allysuche' ";
        $wheres++;
    }
    if (!empty($spielersuche)) {
        $spielersuche = str_replace("*","%",$spielersuche);
        if ($wheres == 0) $whereclause.=" p.playername LIKE '$spielersuche' ";
        else $whereclause.=" AND p.playername LIKE '$spielersuche' ";
        $wheres++;
    }
    if ($moonsearch == 1) {
        if ($wheres == 0) $whereclause.=" g.moon='true' ";
        else $whereclause.=" AND g.moon='true' ";
        $wheres++;
    }
    if ($noticesearch ==1) {
        if ($wheres == 0) $whereclause.=" (n.id>0) ";
        else $whereclause.=" AND (n.id>0) ";
        $wheres++;
    }
    if ($reportsearch ==1) {
        if ($wheres == 0) $whereclause.=" (r.id>0) ";
        else $whereclause.=" AND (r.id>0) ";
        $wheres++;
    }
    if ($colonysearch ==1) {
        if ($wheres == 0) $whereclause.=" g.player_id='0' ";
        else $whereclause.=" AND (g.player_id='0') ";
        $wheres++;
    }
    if (is_numeric($galaxie)) {
        if ($wheres == 0) $whereclause.=" g.galaxy='$galaxie' ";
        else $whereclause.=" AND g.galaxy='$galaxie' ";
        $wheres++;
    }
    if (is_numeric($system1)) {
        if ($wheres == 0) $whereclause.=" (g.system BETWEEN '$system1' AND '$system2') ";
        else $whereclause.=" AND (g.system BETWEEN '$system1' AND '$system2') ";
        $wheres++;
    }
    if (is_numeric($planet1)) {
        if ($wheres == 0) $whereclause.=" (g.planet BETWEEN '$planet1' AND '$planet2') ";
        else $whereclause.=" AND (g.planet BETWEEN '$planet1' AND '$planet2') ";
        $wheres++;
    }
    if ($status1 != "checked") {
        if ($status2 == "checked") {
            if ($wheres == 0) $whereclause.=" (banned='false' AND vacation='false' AND noob='false') AND (g.player_id > 0) ";
            else $whereclause.=" AND (banned='false' AND vacation='false' AND noob='false') AND (g.player_id > 0) ";
            $wheres+=2;
        }
        if ($status3 == "checked") {
            if ($wheres == 0) $whereclause.=" (inactive='true') AND (g.player_id > 0) ";
            else $whereclause.=" AND (inactive='true') AND (g.player_id > 0) ";
            $wheres+=2;
        }
    } else {
        if ($colonysearch != 1) {
            if ($wheres == 0) $whereclause.=" (g.player_id > 0) ";
            else $whereclause.=" AND (g.player_id > 0) ";
            $wheres++;
        }
    }

    // start for alliance status
    $wheres2 = 0;
    if ($allystatus2 == "checked") {
        if ($wheres2 == 0) $whereclause .=" AND ( a.diplomatic_status = 'nap' ";
        else $whereclause.=" OR a.diplomatic_status = 'nap' ";
        $wheres2++;
    }
    if ($allystatus3 == "checked") {
        if ($wheres2 == 0) $whereclause .=" AND ( a.diplomatic_status = 'ally' ";
        else $whereclause.=" OR a.diplomatic_status = 'ally' ";
        $wheres2++;
    }
    if ($allystatus4 == "checked") {
        if ($wheres2 == 0) $whereclause .=" AND ( a.diplomatic_status = 'war' ";
        else $whereclause.=" OR a.diplomatic_status = 'war' ";
        $wheres2++;
    }
    if ($allystatus5 == "checked") {
        if ($wheres2 == 0) $whereclause .=" AND ( a.diplomatic_status = 'boycott' ";
        else $whereclause.=" OR a.diplomatic_status = 'boycott' ";
        $wheres2++;
    }
    if ($allystatus6 == "checked") {
        if ($wheres2 == 0) $whereclause .=" AND ( a.diplomatic_status = 'neutral' ";
        else $whereclause.=" OR a.diplomatic_status = 'neutral' ";
        $wheres2++;
    }
    if ($allystatus7 == "checked") {
        if ($wheres2 == 0) $whereclause .=" AND ( a.diplomatic_status = 'own' ";
        else $whereclause.=" OR a.diplomatic_status = 'own' ";
        $wheres2++;
    }
    if ($allystatus8 == "checked") {
        if ($wheres2 == 0) $whereclause .=" AND ( a.diplomatic_status = 'wing' ";
        else $whereclause.=" OR a.diplomatic_status = 'wing' ";
        $wheres2++;
    }
    if ($wheres2 > 0) $whereclause .= " ) ";

    if ($date_value == 1) {
        if ($wheres == 0) $whereclause.=" (g.last_update < $time) ";
        else $whereclause.=" AND (g.last_update < $time) ";
        $wheres++;
    } elseif ($date_value == 2) {
        if ($wheres == 0) $whereclause.=" (g.last_update > $time) ";
        else $whereclause.=" AND (g.last_update > $time) ";
        $wheres++;
    }
    if ($metal > 0) {
        if ($wheres == 0) $whereclause.=" (g.metal > $metal) ";
        else $whereclause.=" AND (g.metal > $metal) ";
        $wheres++;
    }
    if ($crystal > 0) {
        if ($wheres == 0) $whereclause.=" (g.crystal > $crystal) ";
        else $whereclause.=" AND (g.crystal > $crystal) ";
        $wheres++;
    }
    if ($both > 0) {
        if ($wheres == 0) $whereclause.=" (g.metal+g.crystal > $both) ";
        else $whereclause.=" AND (g.metal+g.crystal > $both) ";
        $wheres++;
    }
    if ($minrank > 0) {
        if ($wheres == 0) $whereclause.=" (p.rank >= $minrank AND p.rank != 0) ";
        else $whereclause.=" AND (p.rank >= $minrank AND p.rank != 0) ";
        $wheres++;
    }
    if ($minfrank > 0) {
        if ($wheres == 0) $whereclause.=" (p.frank >= $minfrank) ";
        else $whereclause.=" AND (p.frank >= $minfrank) ";
        $wheres++;
    }
    if ($maxrank > 0) {
        if ($wheres == 0) $whereclause.=" (p.rank <= $maxrank AND p.rank != 0) ";
        else $whereclause.=" AND (p.rank <= $maxrank AND p.rank != 0) ";
        $wheres++;
    }
    if ($maxfrank > 0) {
        if ($wheres == 0) $whereclause.=" (p.frank <= $maxfrank AND p.frank != 0) ";
        else $whereclause.=" AND (p.frank <= $maxfrank AND p.frank != 0) ";
        $wheres++;
    }

    $from_part = "FROM $dbtablename g ".
    "LEFT JOIN $playertable p ON (g.player_id=p.id) ".
    "LEFT JOIN $allytable a ON (p.alliance_id=a.id) ".
    "LEFT JOIN $noticetable n ON (g.player_id = n.player_id) ".
    "LEFT JOIN $reporttable r ON (g.galaxy = r.galaxy AND g.system = r.system AND g.planet = r.planet AND r.moon='false') ";


    $gesamtquery = "SELECT count(*) as anzahl $from_part $whereclause";

    $allyquery = "SELECT g.galaxy,g.system,g.planet,g.moon,g.moonsize,g.metal,g.crystal,
				  a.allyname,g.planetname,p.playername,p.noob,p.banned,p.vacation,p.inactive,p.long_inactive,DATE_FORMAT(CONVERT_TZ(g.last_update, '+00:00', '".$_SESSION['s_timezone_offset']."'), '%H:%i:%s <br /> %d. %m. %Y') as glastupdate,n.id as notice_id ,r.id as report_id,
				  p.rank,p.frank,p.rrank,p.points,p.fpoints,p.rpoints,g.player_id, p.alliance_id,
				  a.rank as arank,a.frank as afrank, a.rrank as arrank,
				  a.points as apoints, a.fpoints as afpoints, a.rpoints as arpoints, a.diplomatic_status as allystatus,
				  a.members ".$from_part." ".$whereclause." ".$sort." ".$limit;

    $res   = mysql_query($gesamtquery) or die(mysql_error());
    $line = mysql_fetch_object($res);
    $anzahl = $line->anzahl;

    $res   = mysql_query($allyquery) or die(mysql_error());

    unset($_SESSION['s_allysuche']);
    unset($_SESSION['s_spielersuche']);
    unset($_SESSION['s_moonsearch']);
    unset($_SESSION['s_noticesearch']);
    unset($_SESSION['s_reportsearch']);
    unset($_SESSION['s_colonysearch']);
    unset($_SESSION['s_checked1']);
    unset($_SESSION['s_checked2']);
    unset($_SESSION['s_nchecked1']);
    unset($_SESSION['s_nchecked2']);
    unset($_SESSION['s_rchecked1']);
    unset($_SESSION['s_rchecked2']);
    unset($_SESSION['s_cchecked1']);
    unset($_SESSION['s_cchecked2']);
    unset($_SESSION['s_sorder1']);
    unset($_SESSION['s_sorder2']);
    unset($_SESSION['s_schecked1']);
    unset($_SESSION['s_schecked2']);
    unset($_SESSION['s_schecked3']);
    unset($_SESSION['s_schecked4']);
    unset($_SESSION['s_galaxie']);
    unset($_SESSION['s_system1']);
    unset($_SESSION['s_system2']);
    unset($_SESSION['s_planet1']);
    unset($_SESSION['s_planet2']);
    unset($_SESSION['s_status1']);
    unset($_SESSION['s_status2']);
    unset($_SESSION['s_status3']);
    unset($_SESSION['s_allystatus2']);
    unset($_SESSION['s_allystatus3']);
    unset($_SESSION['s_allystatus4']);
    unset($_SESSION['s_allystatus5']);
    unset($_SESSION['s_allystatus6']);
    unset($_SESSION['s_allystatus7']);
    unset($_SESSION['s_allystatus8']);
    unset($_SESSION['s_sort']);
    unset($_SESSION['s_datevalue']);
    unset($_SESSION['s_tyear']);
    unset($_SESSION['s_tmonth']);
    unset($_SESSION['s_tday']);
    unset($_SESSION['s_thour']);
    unset($_SESSION['s_minute']);
    unset($_SESSION['s_second']);
    unset($_SESSION['s_metal']);
    unset($_SESSION['s_crystal']);
    unset($_SESSION['s_both']);
    unset($_SESSION['s_minrank']);
    unset($_SESSION['s_minfrank']);
    unset($_SESSION['s_maxrank']);
    unset($_SESSION['s_maxfrank']);
    unset($_SESSION['s_bbcodes']);

    if ($anzahl > $entries_per_page) {
        $_SESSION['s_allysuche'] = str_replace("%","*",$allysuche);
        $_SESSION['s_spielersuche'] = str_replace("%","*",$spielersuche);
        $_SESSION['s_moonsearch']   = $moonsearch;
        $_SESSION['s_noticesearch'] = $noticesearch;
        $_SESSION['s_reportsearch'] = $reportsearch;
        $_SESSION['s_colonysearch'] = $colonysearch;
        $_SESSION['s_checked1']  = $checked1;
        $_SESSION['s_checked2']  = $checked2;
        $_SESSION['s_nchecked1'] = $nchecked1;
        $_SESSION['s_nchecked2'] = $nchecked2;
        $_SESSION['s_rchecked1'] = $rchecked1;
        $_SESSION['s_rchecked2'] = $rchecked2;
        $_SESSION['s_cchecked1'] = $cchecked1;
        $_SESSION['s_cchecked2'] = $cchecked2;
        $_SESSION['s_sorder1']   = $sorder1;
        $_SESSION['s_sorder2']   = $sorder2;
        $_SESSION['s_schecked1'] = $schecked1;
        $_SESSION['s_schecked2'] = $schecked2;
        $_SESSION['s_schecked3'] = $schecked3;
        $_SESSION['s_schecked4'] = $schecked4;
        $_SESSION['s_galaxie'] = $galaxie;
        $_SESSION['s_system1'] = $system1;
        $_SESSION['s_system2'] = $system2;
        $_SESSION['s_planet1'] = $planet1;
        $_SESSION['s_planet2'] = $planet2;
        $_SESSION['s_status1'] = $status1;
        $_SESSION['s_status2'] = $status2;
        $_SESSION['s_status3'] = $status3;
        $_SESSION['s_allystatus2'] = $allystatus2;
        $_SESSION['s_allystatus3'] = $allystatus3;
        $_SESSION['s_allystatus4'] = $allystatus4;
        $_SESSION['s_allystatus5'] = $allystatus5;
        $_SESSION['s_allystatus6'] = $allystatus6;
        $_SESSION['s_allystatus7'] = $allystatus7;
        $_SESSION['s_allystatus8'] = $allystatus8;
        $_SESSION['s_sort']    = $sort;
        $_SESSION['s_datevalue'] = $date_value;
        $_SESSION['s_tyear']   = $tyear;
        $_SESSION['s_tmonth']  = $tmonth;
        $_SESSION['s_tday']    = $tday;
        $_SESSION['s_thour']   = $thour;
        $_SESSION['s_minute']  = $tminute;
        $_SESSION['s_second']  = $tsecond;
        $_SESSION['s_metal']   = $metal;
        $_SESSION['s_crystal'] = $crystal;
        $_SESSION['s_both']    = $both;
        $_SESSION['s_minrank']    = $minrank;
        $_SESSION['s_minfrank']   = $minfrank;
        $_SESSION['s_maxrank']    = $maxrank;
        $_SESSION['s_maxfrank']   = $maxfrank;
        $_SESSION['s_bbcodes']   = $bb_code;
    }

    if ($anzahl > 0) {


        if (isset($_POST['searchbutton']) || $bb_code == 0) {
            starttable($anzahl,$page,true);
            $i = 1;
            while ($line = mysql_fetch_object($res)) {
                $playerstatus = "";
                if ($line->noob          == "true") $playerstatus .= "n";
                if ($line->vacation      == "true") $playerstatus .= "u";
                if ($line->banned        == "true") $playerstatus .= "g";
                if ($line->inactive      == "true") $playerstatus .= "i";
                if ($line->long_inactive == "true") $playerstatus .= "I";

                displayresult(false,$line->galaxy,$line->system,$line->planet,$line->moon,$line->moonsize,$line->metal,
                $line->crystal,$line->allyname,$line->planetname,$line->playername,$playerstatus,
                $line->glastupdate,$line->rank,$line->frank,$line->rrank,$line->points,$line->fpoints,$line->rpoints,
                $line->arank,$line->afrank,$line->arrank,$line->apoints,$line->afpoints,$line->arpoints,
                $line->members,$line->notice_id,$line->report_id,$line->allystatus,$line->player_id,$i,$line->alliance_id);
                $i++;
            }
            echo "<tr class=\"firstcolor\"><td colspan=\"10\" align=\"center\">";
            if ($anzahl > $entries_per_page) draw_pagenumbers($page,$anzahl,$entries_per_page,$_SERVER['PHP_SELF'],"page");
            echo "</td></tr>";
            closetable();
        } elseif ($bb_code == 1) {
            starttable($anzahl,$page,false);
            echo '
				<tr class="firstcolor">
	   			<td width="100" colspan="10">
	   			<textarea class="textfield" style="width:600px; height:400px;">';
            $i = 1;
            while ($line = mysql_fetch_object($res)) {
                $playerstatus = "";
                if ($line->noob          == "true") $playerstatus .= "n";
                if ($line->vacation      == "true") $playerstatus .= "u";
                if ($line->banned        == "true") $playerstatus .= "g";
                if ($line->inactive      == "true") $playerstatus .= "i";
                if ($line->long_inactive == "true") $playerstatus .= "I";

                displayresult(true,$line->galaxy,$line->system,$line->planet,$line->moon,$line->moonsize,$line->metal,
                $line->crystal,$line->allyname,$line->planetname,$line->playername,$playerstatus,
                $line->glastupdate,$line->rank,$line->frank,$line->rrank,$line->points,$line->fpoints,$line->rpoints,
                $line->arank,$line->afrank,$line->arrank,$line->apoints,$line->afpoints,$line->arpoints,
                $line->members,$line->notice_id,$line->report_id,$line->allystatus,$line->player_id,$i,$line->alliance_id);
                echo "\n";
                $i++;
            }
            echo "</textarea>";
            closetable();
        }

    } else {
        echo "<div align=\"center\">".SHOW_NOTHING."</div>\n";
    }

}


function displayresult($show_as_bb_code,$galaxie,$system,$planetnummer,$moon,$moonsize,$metall,$kristall,$ally,$planetname,$spielername,$spielerstatus,$zeit,
$rank,$frank,$rrank,$points,$fpoints,$rpoints,$arank,$afrank,$arrank,$apoints,$afpoints,$arpoints,
$members,$notice,$report,$allystats,$player_id,$entry_number,$alliance_id) {

    global $notice_array, $report_array;

    if ($moon == "true") {
        $moon = "M";
        if ($moonsize > 0) $moonsize = number_format($moonsize,0,",",".")." km";
        else $moonsize = SHOW_UKMOONSIZE;
    } else {
        $moon = "&nbsp;";
        $moonsize = "&nbsp;";
    }
    if ($metall > 0 || $kristall > 0) {
        $tf = 'M:'.number_format($metall,0,",",".").' <br>K:'.number_format($kristall,0,",",".");
    } else {
        $tf = '';
    }

    if (!empty($members)) $a_alt = SHOW_RANK.": $arank / ".SHOW_MEMBERS.": $members";
    else $a_alt = "";
    if ($rank > 0) $p_alt = SHOW_RANK.": $rank / $frank";
    else $p_alt = SHOW_NOTRANKED;

    if ($show_as_bb_code) {
        echo "[[COLOR=".$_SESSION['s_bb_coordinates']."]".$galaxie.':'.$system.':'.$planetnummer;
        echo "[/COLOR]]";

        if ($moonsize != "&nbsp;") echo "[[COLOR=".$_SESSION['s_bb_moon']."]".$moon." ".$moonsize."[/COLOR]]";
        if (!empty($tf)) echo "[[COLOR=".$_SESSION['s_bb_debris']."]".strip_tags($tf)."[/COLOR]]";
        if (!empty($ally)) echo "[[COLOR=".$_SESSION['s_bb_ally']."]".$ally."[/COLOR]]";
        if (!empty($members) && !empty($arank)) echo "[[COLOR=".$_SESSION['s_bb_allydetails']."](".$members."/".$arank.")[/COLOR]]";
    } else {
        echo'
	   <tr class="firstcolor">
	    <td width="100" align="center"><a class="resultlink" href="view.php?gala='.$galaxie.'&amp;system='.$system.'&amp;from=show"><span style="white-space: nowrap;">'.$galaxie.':'.$system.':'.$planetnummer.'</span></a></td>
	    ';
        if ($moonsize != "&nbsp;") {
            echo '<td align="center" onmouseover=\'this.T_WIDTH=150;return escape("'.$moonsize.'")\'>'.$moon.'</td>';
        } else {
            echo '<td align="center">&nbsp;</td>';
        }
        echo '
	    <td align="center" style="font-size:6pt;">'.$tf.'</td>';
        if (!empty($ally)) {
            echo '
	    <td align="center"><table width="100%"><tr class="firstcolor"><td align="center"><a class="resultlink" href="allyinformation.php?id='.$alliance_id.'"';
            if (!empty($members) && !empty($arank)) {
                if (!empty($arank)) {
                    echo ' onmouseover=\'this.T_WIDTH=250;return escape("'.htmlentities('<div style=\"font-size:10pt;\">').utf8_encode(STATS_ALLYSTATS).htmlentities(":</div><br>").utf8_encode(STATS_MEMBERS).htmlentities(": ".$members."<br>").utf8_encode(SHOW_RANK).htmlentities(": #".$arank." - ").utf8_encode(STATS_SCORE).htmlentities(": ".number_format($apoints,0,",",".")."<br>").utf8_encode(STATS_FLEET).htmlentities(": #".$afrank." - ").utf8_encode(STATS_SCORE).htmlentities(": ".number_format($afpoints,0,",",".")."<br>").utf8_encode(STATS_RESEARCH).htmlentities(": #".$arrank." - ").utf8_encode(STATS_SCORE).htmlentities(": ".number_format($arpoints,0,",",".")).'")\' >';
                } else {
                    echo ' onmouseover=\'this.T_WIDTH=250;return escape("'.utf8_encode(SHOW_NOTRANKED).'")\' >';
                }
            } else {
                echo " >";
            }
            echo '<span class="'.$allystats.'" style="white-space: nowrap;">'.$ally.'</span></a></td>';
            echo "</tr></table>";
        } else {
            echo "<td>&nbsp;";
        }
        echo '</td>
	    <td align="center"><span style="white-space: nowrap;">'.$planetname.'</span></td>
	    <td align="center"><table width="100%"><tr class="firstcolor"><td align="center"><a ';
        if (!empty($rank)) {
            echo ' onmouseover=\'this.T_WIDTH=250;return escape("'.htmlentities('<div style=\"font-size:10pt;\">').utf8_encode(STATS_PLAYERSTATS).htmlentities(":</div><br>").utf8_encode(SHOW_RANK).htmlentities(": #".$rank." - ").utf8_encode(STATS_SCORE).htmlentities(": ".number_format($points,0,",",".")."<br>").utf8_encode(STATS_FLEET).htmlentities(": #".$frank." - ").utf8_encode(STATS_SCORE).htmlentities(": ".number_format($fpoints,0,",",".")."<br>").utf8_encode(STATS_RESEARCH).htmlentities(": #".$rrank." - ").utf8_encode(STATS_SCORE).htmlentities(": ".number_format($rpoints,0,",",".")).'")\' ';
        } else {
            echo ' onmouseover=\'this.T_WIDTH=250;return escape("'.utf8_encode(SHOW_NOTRANKED).'")\' ';
        }
    }

    if (!$show_as_bb_code) {
        echo ' class="resultlink" href="playerinformation.php?id='.$player_id.'"><span style="white-space: nowrap;">';
        // Status
        $openspans = 0;
        if (strpos($spielerstatus,"g") !== false) {
            echo "<span class=\"banned\">";
            $openspans++;
        }
        if (strpos($spielerstatus,"u") !== false) {
            echo "<span class=\"vacation\">";
            $openspans++;
        } elseif (strpos($spielerstatus,"n") !== false) {
            echo "<span class=\"noob\">";
            $openspans++;
        } elseif (strpos($spielerstatus,"i") !== false) {
            echo "<span class=\"longinactive\">";
            $openspans++;
        } elseif (strpos($spielerstatus,"I") !== false) {
            echo "<span class=\"inactive\">";
            $openspans++;
        }
    }

    if (!$show_as_bb_code) {
        echo $spielername;
        for ($i=$openspans;$i>0;$i--) {
            echo "</span>";
        }
        // endstatus
        echo '</span></a></td>';
        echo "</tr></table>";
        echo '</td>
	<td width="20" align="center">';
    } else {
        echo "[[COLOR=".$_SESSION['s_bb_playername']."]".$spielername."[/COLOR] ";
    }
    switch ($_SESSION['lang']) {
        case "german" :
            print_status($show_as_bb_code,$spielerstatus);  // banned, vacation, noob, inactive, long inactive
            break;
        case "polish" :
            print_status($show_as_bb_code,$spielerstatus,"g","u","s"); // banned, vacation, noob, inactive, long inactive
            break;
        case "english" :
            print_status($show_as_bb_code,$spielerstatus,"b","v"); // banned, vacation, noob, inactive, long inactive
            break;
        case "spanish" :
            print_status($show_as_bb_code,$spielerstatus,"s","v","d"); // banned, vacation, noob, inactive, long inactive
            break;
        case "dutch" :
            print_status($show_as_bb_code,$spielerstatus,"g","v","z"); // banned, vacation, noob, inactive, long inactive
            break;
        case "balkan" :
            print_status($show_as_bb_code,$spielerstatus,"k","o","s"); // banned, vacation, noob, inactive, long inactive
            break;
        case "french" :
            print_status($show_as_bb_code,$spielerstatus,"b","v","d"); // banned, vacation, noob, inactive, long inactive
            break;
        case "portugues" :
            print_status($show_as_bb_code,$spielerstatus,"b","m","f"); // banned, vacation, noob, inactive, long inactive
            break;
        case "italian" :
            print_status($show_as_bb_code,$spielerstatus,"b","v","d"); // banned, vacation, noob, inactive, long inactive
            break;
        case "turkish" :
            print_status($show_as_bb_code,$spielerstatus,"c","t","z"); // banned, vacation, noob, inactive, long inactive
            break;
        case "danish" :
            print_status($show_as_bb_code,$spielerstatus,"s","f","n"); // banned, vacation, noob, inactive, long inactive
            break;
        case "brazilian" :
            print_status($show_as_bb_code,$spielerstatus,"b","m","f"); // banned, vacation, noob, inactive, long inactive
            break;
        case "russian" :
            print_status($show_as_bb_code,$spielerstatus,"з","РО","н"); // banned, vacation, noob, inactive, long inactive
            break;
        case "swedish" :
            print_status($show_as_bb_code,$spielerstatus,"b","s","k"); // banned, vacation, noob, inactive, long inactive
            break;
        case "greek" :
            print_status($show_as_bb_code,$spielerstatus,"b","v"); // banned, vacation, noob, inactive, long inactive
            break;
        case "romanian" :
            print_status($show_as_bb_code,$spielerstatus,"b","v"); // banned, vacation, noob, inactive, long inactive
            break;
        case "hungarian" :
            print_status($show_as_bb_code,$spielerstatus,"b","v"); // banned, vacation, noob, inactive, long inactive
            break;
        case "czech" :
            print_status($show_as_bb_code,$spielerstatus,"b","z"); // banned, vacation, noob, inactive, long inactive
            break;
        case "korean" :
            print_status($show_as_bb_code,$spielerstatus,"b","v"); // banned, vacation, noob, inactive, long inactive
            break;
        case "norwegian" :
            print_status($show_as_bb_code,$spielerstatus,"b","v"); // banned, vacation, noob, inactive, long inactive
            break;
        case "taiwan" :
            print_status($show_as_bb_code,$spielerstatus,"g","u"); // banned, vacation, noob, inactive, long inactive
            break;
        case "japan" :
            print_status($show_as_bb_code,$spielerstatus,"b","v"); // banned, vacation, noob, inactive, long inactive
            break;
        case "chineese" :
            print_status($show_as_bb_code,$spielerstatus,"g","u"); // banned, vacation, noob, inactive, long inactive
            break;
        default: break;
    }
    if ($show_as_bb_code) {
        echo "]";
    }  else {
        echo '</td>
		<td width="250" align="center">'.$zeit.'</td>
		';
        if ($notice != NULL) {
            if (!isset($notice_array[$player_id])) $notice_array[$player_id] = $player_id;
            echo '<td align="center"><a href="notices.php?player_id='.$player_id.'&amp;action=view" onmouseover="ShowObject(\'notice'.$player_id.'\',\'ajax_notices.php?player_id='.$player_id.'\',true)"><img alt="notice" src="../images/notice.gif" border="0"></a></td>';
        } else {
            echo '<td align="center"><a href="notices.php?player_id='.$player_id.'&amp;action=edit"><img alt="no notice" src="../images/no_notice.gif" border="0"></a></td>';
        }
        if ($report != NULL) {
            array_push($report_array,$entry_number);
            echo '<td align="center"><a href="reports.php?coordinates='."$galaxie:$system:$planetnummer".'&amp;moon=0" onmouseover="ShowObject(\'report'.$entry_number.'\',\'ajax_reports.php?coordinates='.$galaxie.':'.$system.':'.$planetnummer.'&amp;moon=0\',true)"><img alt="report" src="../images/spio.gif" border="0"></a></td>';
        } else {
            echo '<td align="center"><img alt="no report" src="../images/no_spio.gif" border="0"></td>';
        }
        echo "</tr>\n";
    }
}


function starttable($number,$page,$show_tablehead = true) {
    global $entries_per_page;
    $to = ($page*$entries_per_page < $number) ? $page*$entries_per_page : $number;
    echo '<table width="95%" border="0" cellspacing="2" cellpadding="0" align="center">';
    echo "<tr class=\"firstcolor\"><td colspan=\"10\" align=\"center\">";
    if ($number > $entries_per_page) draw_pagenumbers($page,$number,$entries_per_page,$_SERVER['PHP_SELF'],"page");
    echo "</td></tr>";
    if ($show_tablehead) {
        echo "<tr class=\"firstcolor\"><td align=\"center\" colspan=\"10\">";
        // Colors
	?>
	<span class="bg_nothing">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_NOTHING; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<span class="bg_neutral">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_NEUTRAL; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<span class="bg_boycott">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_BOYCOTT; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<span class="bg_nap">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_NAP; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<span class="bg_ally">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_ALLIED; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<span class="bg_war">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_WAR; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<span class="bg_own">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_OWN; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<span class="bg_wing">&nbsp;&nbsp;&nbsp;&nbsp;</span> <?php echo STATS_WING; ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<?php
	echo "</td></tr>\n";
	echo "<tr><td align=\"center\" class=\"tblhead\" colspan=\"10\">".SHOW_HITS.": ".(($page-1)*$entries_per_page+1)."-".$to." ".SHOW_OF." $number</td></tr>\n";
	echo'
	<tr>
	<td width="90" align="center" class="tblhead">'.SHOW_ADDRESS.'</td>
	<td width="90" align="center" class="tblhead">'.SHOW_MOON.'</td>
	<td width="90" align="center" class="tblhead">'.SHOW_DF.'</td>
	<td align="center"class="tblhead">'.SHOW_ALLYSORT.'</td>
	<td align="center"class="tblhead">'.SHOW_PLANET.'</td>
	<td align="center"class="tblhead">'.SHOW_PLAYERNAME.'</td>
	<td width="20" align="center"class="tblhead">'.SHOW_STATUS.'</td>
	<td width="250" align="center"class="tblhead">'.SHOW_CURRENTNESS.'</td>
	<td width="250" align="center"class="tblhead">'.SHOW_NOTICERES.'</td>
	<td width="250" align="center"class="tblhead">'.SHOW_REPORTS_SHORT.'</td>
	</tr>';
    }
}

function closetable() {
    echo "</table>";
}

function pulldowncode($name,$startval,$endval,$interval,$selected=0) {
    echo "<select name=\"$name\" class=\"pulldown_code\">\n";
    for ($i=$startval;$i<=$endval;$i += $interval) {
        echo "<option value=\"$i\"";
        if ($selected == $i) echo "selected";
        echo ">$i</option>\n";
    }
    echo "</select>\n";
}

echo'
<div class="firstcolor" style="position:absolute; top:50px; left:10px; display: none; z-index: 998" id="loading" ><img alt="loading..." src="../images/loading_small.gif" border="0" /> Loading...</div>'."\n";
foreach($notice_array as $key => $value) {
    echo '<div class="reports" id="notice'.$value.'" ></div>'."\n";
}
foreach($report_array as $key => $value) {
    echo '<div class="reports" id="report'.$value.'" ></div>'."\n";
}

makefooter();
?>