<?php
/**
 * Tis file is part of XNova:Legacies
 *
 * @license http://www.gnu.org/licenses/gpl-3.0.txt
 * @see http://www.xnova-ng.org/
 *
 * Copyright (c) 2009-Present, XNova Support Team <http://www.xnova-ng.org>
 * All rights reserved.
 *
 * 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 3 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.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 *                                --> NOTICE <--
 *  This file is part of the core development branch, changing its contents will
 * make you unable to use the automatic updates manager. Please refer to the
 * documentation for further information about customizing XNova.
 *
 */

define('INSIDE' , true);
define('INSTALL' , false);
require_once dirname(__FILE__) .'/common.php';

    $lunarow   = doquery("SELECT * FROM {{table}} WHERE `id_owner` = '".$planetrow['id_owner']."' AND `galaxy` = '".$planetrow['galaxy']."' AND `system` = '".$planetrow['system']."' AND `lunapos` = '".$planetrow['planet']."';", 'lunas', true);

    CheckPlanetUsedFields ($lunarow);

    $mode = $_GET['mode'];
    $pl = mysql_escape_string($_GET['pl']);
    $_POST['deleteid'] = intval($_POST['deleteid']);

    includeLang('resources');
    includeLang('overview');

    switch ($mode) {
        case 'renameplanet':
            // -----------------------------------------------------------------------------------------------
            if ($_POST['action'] == $lang['namer']) {
                // Reponse au changement de nom de la planete
                $UserPlanet     = CheckInputStrings ( $_POST['newname'] );
                $newname        = mysql_escape_string(strip_tags(trim( $UserPlanet )));
                if ($newname != "") {
                    // Deja on met jour la planete qu'on garde en memoire (pour le nom)
                    $planetrow['name'] = $newname;
                    // Ensuite, on enregistre dans la base de données
                    doquery("UPDATE {{table}} SET `name` = '".$newname."' WHERE `id` = '". $user['current_planet'] ."' LIMIT 1;", "planets");
                    // Est ce qu'il sagit d'une lune ??
                    if ($planetrow['planet_type'] == 3) {
                        // Oui ... alors y a plus qu'a changer son nom dans la table des lunes aussi !!!
                        doquery("UPDATE {{table}} SET `name` = '".$newname."' WHERE `galaxy` = '".$planetrow['galaxy']."' AND `system` = '".$planetrow['system']."' AND `lunapos` = '".$planetrow['planet']."' LIMIT 1;", "lunas");
                    }
                }

            } elseif ($_POST['action'] == $lang['colony_abandon']) {
                // Cas d'abandon d'une colonie
                // Affichage de la forme d'abandon de colonie
                $parse                   = $lang;
                $parse['planet_id']      = $planetrow['id'];
                $parse['galaxy_galaxy']  = $galaxyrow['galaxy'];
                $parse['galaxy_system']  = $galaxyrow['system'];
                $parse['galaxy_planet']  = $galaxyrow['planet'];
                $parse['planet_name']    = $planetrow['name'];

                $page                   .= parsetemplate(gettemplate('overview_deleteplanet'), $parse);

                // On affiche la forme pour l'abandon de la colonie
                display($page, $lang['rename_and_abandon_planet']);

            } elseif ($_POST['kolonieloeschen'] == 1 && $_POST['deleteid'] == $user['current_planet']) {
                // Controle du mot de passe pour abandon de colonie
                if (md5($_POST['pw']) == $user["password"] && $user['id_planet'] != $user['current_planet']) {
                    $destruyed        = time() + 60 * 60 * 24;

                    $QryUpdatePlanet  = "UPDATE {{table}} SET ";
                    $QryUpdatePlanet .= "`destruyed` = '".$destruyed."', ";
                    $QryUpdatePlanet .= "`id_owner` = '0' ";
                    $QryUpdatePlanet .= "WHERE ";
                    $QryUpdatePlanet .= "`id` = '".$user['current_planet']."' LIMIT 1;";
                    doquery( $QryUpdatePlanet , 'planets');

                    $QryUpdateUser    = "UPDATE {{table}} SET ";
                    $QryUpdateUser   .= "`current_planet` = `id_planet` ";
                    $QryUpdateUser   .= "WHERE ";
                    $QryUpdateUser   .= "`id` = '". $user['id'] ."' LIMIT 1";
                    doquery( $QryUpdateUser, "users");

                    // Tout s'est bien passé ! La colo a été effacée !!
                    message($lang['deletemessage_ok']   , $lang['colony_abandon'], 'overview.php?mode=renameplanet');

                } elseif ($user['id_planet'] == $user["current_planet"]) {
                    // Et puis quoi encore ??? On ne peut pas effacer la planete mere ..
                    // Uniquement les colonies crées apres coup !!!
                    message($lang['deletemessage_wrong'], $lang['colony_abandon'], 'overview.php?mode=renameplanet');

                } else {
                    // Erreur de saisie du mot de passe je n'efface pas !!!
                    message($lang['deletemessage_fail'] , $lang['colony_abandon'], 'overview.php?mode=renameplanet');

                }
            }

            $parse = $lang;

            $parse['planet_id']     = $planetrow['id'];
            $parse['galaxy_galaxy'] = $galaxyrow['galaxy'];
            $parse['galaxy_system'] = $galaxyrow['system'];
            $parse['galaxy_planet'] = $galaxyrow['planet'];
            $parse['planet_name']   = $planetrow['name'];

            $page                  .= parsetemplate(gettemplate('overview_renameplanet'), $parse);

            // On affiche la page permettant d'abandonner OU de renomme une Colonie / Planete
            display($page, $lang['rename_and_abandon_planet']);
            break;

        default:
            // --- Gestion des messages ----------------------------------------------------------------------
            $Have_new_message = "";
            if ($user['new_message'] != 0) {
                $Have_new_message .= "<tr>";
                if       ($user['new_message'] == 1) {
                    $Have_new_message .= "<th colspan=4><a href=messages.php>". $lang['Have_new_message']."</a></th>";
                } elseif ($user['new_message'] > 1) {
                    $Have_new_message .= "<th colspan=4><a href=messages.php>";
                    $m = pretty_number($user['new_message']);
                    $Have_new_message .= str_replace('%m', $m, $lang['Have_new_messages']);
                    $Have_new_message .= "</a></th>";
                }
                $Have_new_message .= "</tr>";
            }
            // -----------------------------------------------------------------------------------------------
$alliancerow = doquery("SELECT * FROM {{table}} WHERE id={$user['ally_id']}",'alliance',true);
            // --- Gestion Officiers -------------------------------------------------------------------------
            // Passage au niveau suivant, ajout du point de compétence et affichage du passage au nouveau level
            $XpMinierUp  = $user['lvl_minier'] * 5000;
            $XpRaidUp    = $user['lvl_raid']   * 10;
            $XpMinier    = $user['xpminier'];
            $XPRaid      = $user['xpraid'];

            $LvlUpMinier = $user['lvl_minier'] + 1;
            $LvlUpRaid   = $user['lvl_raid']   + 1;

            if( ($LvlUpMinier + $LvlUpRaid) <= 100 ) {
                if ($XpMinier >= $XpMinierUp) {
                    $QryUpdateUser  = "UPDATE {{table}} SET ";
                    $QryUpdateUser .= "`lvl_minier` = '".$LvlUpMinier."', ";
                    $QryUpdateUser .= "`rpg_points` = `rpg_points` + 1 ";
                    $QryUpdateUser .= "WHERE ";
                    $QryUpdateUser .= "`id` = '". $user['id'] ."';";
                    doquery( $QryUpdateUser, 'users');
                    $HaveNewLevelMineur  = "<tr>";
                    $HaveNewLevelMineur .= "<th colspan=4><a href=officier.$phpEx>". $lang['Have_new_level_mineur']."</a></th>";
                }
                if ($XPRaid >= $XpRaidUp) {
                    $QryUpdateUser  = "UPDATE {{table}} SET ";
                    $QryUpdateUser .= "`lvl_raid` = '".$LvlUpRaid."', ";
                    $QryUpdateUser .= "`rpg_points` = `rpg_points` + 1 ";
                    $QryUpdateUser .= "WHERE ";
                    $QryUpdateUser .= "`id` = '". $user['id'] ."';";
                    doquery( $QryUpdateUser, 'users');
                    $HaveNewLevelMineur  = "<tr>";
                    $HaveNewLevelMineur .= "<th colspan=4><a href=officier.$phpEx>". $lang['Have_new_level_raid']."</a></th>";
                }
            }
            // -----------------------------------------------------------------------------------------------

            // --- Gestion des flottes personnelles ---------------------------------------------------------
            // Toutes de vert vetues
            $OwnFleets       = doquery("SELECT * FROM {{table}} WHERE `fleet_owner` = '". $user['id'] ."';", 'fleets');
            $Record          = 0;
            while ($FleetRow = mysql_fetch_array($OwnFleets)) {
                $Record++;

                $StartTime   = $FleetRow['fleet_start_time'];
                $StayTime    = $FleetRow['fleet_end_stay'];
                $EndTime     = $FleetRow['fleet_end_time'];

                // Flotte a l'aller
                $Label = "fs";
                if ($StartTime > time()) {
                    $fpage[$StartTime] = BuildFleetEventTable ( $FleetRow, 0, true, $Label, $Record );
                }

                if ($FleetRow['fleet_mission'] <> 4) {
                    // Flotte en stationnement
                    $Label = "ft";
                    if ($StayTime > time()) {
                        $fpage[$StayTime] = BuildFleetEventTable ( $FleetRow, 1, true, $Label, $Record );
                    }

                    // Flotte au retour
                    $Label = "fe";
                    if ($EndTime > time()) {
                        $fpage[$EndTime]  = BuildFleetEventTable ( $FleetRow, 2, true, $Label, $Record );
                    }
                }
            } // End While

            // -----------------------------------------------------------------------------------------------

            // --- Gestion des flottes autres que personnelles ----------------------------------------------
            // Flotte ennemies (ou amie) mais non personnelles
            $OtherFleets     = doquery("SELECT * FROM {{table}} WHERE `fleet_target_owner` = '".$user['id']."';", 'fleets');

            $Record          = 2000;
            while ($FleetRow = mysql_fetch_array($OtherFleets)) {
                if ($FleetRow['fleet_owner'] != $user['id']) {
                    if ($FleetRow['fleet_mission'] != 8) {
                        $Record++;
                        $StartTime = $FleetRow['fleet_start_time'];
                        $StayTime  = $FleetRow['fleet_end_stay'];

                        if ($StartTime > time()) {
                            $Label = "ofs";
                            $fpage[$StartTime] = BuildFleetEventTable ( $FleetRow, 0, false, $Label, $Record );
                        }
                        if ($FleetRow['fleet_mission'] == 5) {
                            // Flotte en stationnement
                            $Label = "oft";
                            if ($StayTime > time()) {
                                $fpage[$StayTime] = BuildFleetEventTable ( $FleetRow, 1, false, $Label, $Record );
                            }
                        }
                    }
                }
            }

            // -----------------------------------------------------------------------------------------------

            // --- Gestion de la liste des planetes ----------------------------------------------------------
            // Planetes ...
            $planets_query = doquery("SELECT * FROM {{table}} WHERE id_owner='{$user['id']}'", "planets");
            $Colone  = 1;

            $AllPlanets = "<tr>";
            while ($UserPlanet = mysql_fetch_array($planets_query)) {
                if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3 && $UserPlanet['planet_type'] != 5) {
                    $AllPlanets .= "<th>". $UserPlanet['name'] ."<br>";
                    $AllPlanets .= "<a href=\"?cp=". $UserPlanet['id'] ."&re=0\" title=\"". $UserPlanet['name'] ."\"><img src=\"". $dpath ."planeten/small/s_". $UserPlanet['image'] .".jpg\" height=\"50\" width=\"50\"></a><br>";
                    $AllPlanets .= "<center>";

                    if ($UserPlanet['b_building'] != 0) {
                        UpdatePlanetBatimentQueueList ( $UserPlanet, $user );
                        if ( $UserPlanet['b_building'] != 0 ) {
                            $BuildQueue      = $UserPlanet['b_building_id'];
                            $QueueArray      = explode ( ";", $BuildQueue );
                            $CurrentBuild    = explode ( ",", $QueueArray[0] );
                            $BuildElement    = $CurrentBuild[0];
                            $BuildLevel      = $CurrentBuild[1];
                            $BuildRestTime   = pretty_time( $CurrentBuild[3] - time() );
                            $AllPlanets     .= '' . $lang['tech'][$BuildElement] . ' (' . $BuildLevel . ')';
                            $AllPlanets     .= "<br><font color=\"#7f7f7f\">(". $BuildRestTime .")</font>";
                        } else {
                            CheckPlanetUsedFields ($UserPlanet);
                            $AllPlanets     .= $lang['Free'];
                        }
                    } else {
                        $AllPlanets    .= $lang['Free'];
                    }

                    $AllPlanets .= "</center></th>";
                    if ($Colone <= 6) {
                        $Colone++;
                    } else {
                        $AllPlanets .= "</tr><tr>";
                        $Colone      = 6;
                    }
                }
            }
            // -----------------------------------------------------------------------------------------------

            // --- Gestion des attaques missiles -------------------------------------------------------------
            $iraks_query = doquery("SELECT * FROM {{table}} WHERE owner = '" . $user['id'] . "'", 'iraks');
            $Record = 4000;
            while ($irak = mysql_fetch_array ($iraks_query)) {
                $Record++;
                $fpage[$irak['zeit']] = '';

                if ($irak['zeit'] > time()) {
                    $time = $irak['zeit'] - time();

                    $fpage[$irak['zeit']] .= InsertJavaScriptChronoApplet ( "fm", $Record, $time, true );

                    $planet_start = doquery("SELECT * FROM {{table}} WHERE
                    galaxy = '" . $irak['galaxy'] . "' AND
                    system = '" . $irak['system'] . "' AND
                    planet = '" . $irak['planet'] . "' AND
                    planet_type = '1'", 'planets');

                    $user_planet = doquery("SELECT * FROM {{table}} WHERE
                    galaxy = '" . $irak['galaxy_angreifer'] . "' AND
                    system = '" . $irak['system_angreifer'] . "' AND
                    planet = '" . $irak['planet_angreifer'] . "' AND
                    planet_type = '1'", 'planets', true);

                    if (mysql_num_rows($planet_start) == 1) {
                        $planet = mysql_fetch_array($planet_start);
                    }

                    $fpage[$irak['zeit']] .= "<tr><th><div id=\"bxxfs$i\" class=\"z\"></div><font color=\"lime\">" . gmdate("H:i:s", $irak['zeit'] + 1 * 60 * 60) . "</font> </th><th colspan=\"3\"><font color=\"#0099FF\">Une attaque de missiles (" . $irak['anzahl'] . ") de " . $user_planet['name'] . " ";
                    $fpage[$irak['zeit']] .= '<a href="galaxy.php?mode=3&galaxy=' . $irak["galaxy_angreifer"] . '&system=' . $irak["system_angreifer"] . '&planet=' . $irak["planet_angreifer"] . '">[' . $irak["galaxy_angreifer"] . ':' . $irak["system_angreifer"] . ':' . $irak["planet_angreifer"] . ']</a>';
                    $fpage[$irak['zeit']] .= ' arrive sur la plan&egrave;te' . $planet["name"] . ' ';
                    $fpage[$irak['zeit']] .= '<a href="galaxy.php?mode=3&galaxy=' . $irak["galaxy"] . '&system=' . $irak["system"] . '&planet=' . $irak["planet"] . '">[' . $irak["galaxy"] . ':' . $irak["system"] . ':' . $irak["planet"] . ']</a>';
                    $fpage[$irak['zeit']] .= '</font>';
                    $fpage[$irak['zeit']] .= InsertJavaScriptChronoApplet ( "fm", $Record, $time, false );
                    $fpage[$irak['zeit']] .= "</th>";
                }
            }

            // -----------------------------------------------------------------------------------------------

            $parse                         = $lang;

            // -----------------------------------------------------------------------------------------------
            // News Frame ...
            // External Chat Frame ...
            // Banner ADS Google (meme si je suis contre cela)
            if ($game_config['OverviewNewsFrame'] == '1') {
                $parse['NewsFrame']          = "<tr><th>". $lang['ov_news_title'] ."</th><th colspan=\"3\">". stripslashes($game_config['OverviewNewsText']) ."</th></tr>";
            }
            if ($game_config['OverviewExternChat'] == '1') {
                $parse['ExternalTchatFrame'] = "<tr><th colspan=\"4\">". stripslashes( $game_config['OverviewExternChatCmd'] ) ."</th></tr>";
            }
            if ($game_config['OverviewClickBanner'] != '') {
                $parse['ClickBanner'] = stripslashes( $game_config['OverviewClickBanner'] );
            }

            // --- Gestion de l'affichage d'une lune ---------------------------------------------------------
            if ($planetrow['galaxy'] == $lunarow['galaxy'] && $planetrow['system'] == $lunarow['system'] && $planetrow['planet'] == $lunarow['lunapos'] && $planetrow['planet_type'] != 3) {
                $lune = doquery("SELECT * FROM {{table}} WHERE galaxy={$lunarow['galaxy']} AND system={$lunarow['system']} AND planet={$lunarow['lunapos']} AND planet_type='3'", 'planets', true);
                $parse['moon_img'] = "<a href=\"?cp={$lune['id']}&re=0\" title=\"{$UserPlanet['name']}\"><img src=\"{$dpath}planeten/{$lunarow['image']}.jpg\" height=\"50\" width=\"50\"></a>";
                $parse['moon'] = $lunarow['name'];
            } else {
                $parse['moon_img'] = "";
                $parse['moon'] = "";
            }
            // Moon END

            $parse['planet_name']          = $planetrow['name'];
            $parse['planet_diameter']      = pretty_number($planetrow['diameter']);
            $parse['planet_field_current'] = $planetrow['field_current'];
            $parse['planet_field_max']     = CalculateMaxPlanetFields($planetrow);
            $parse['planet_temp_min']      = $planetrow['temp_min'];
            $parse['planet_temp_max']      = $planetrow['temp_max'];
            $parse['galaxy_galaxy']        = $planetrow['galaxy'];
            $parse['galaxy_planet']        = $planetrow['planet'];
            $parse['galaxy_system']        = $planetrow['system'];

            if ($user['id_race'] == 0)
                $parse['race'] = 'Race : Aucune race allez dans Option pour en choisir une !';
            if ($user['id_race'] == 1)
                $parse['race'] = 'Race : Clone';
            if ($user['id_race'] == 2)
                $parse['race'] = 'Race : Sith';
            if ($user['id_race'] == 3)
                $parse['race'] = 'Race : Jedi';
            if ($user['id_race'] == 4)
                $parse['race'] = 'Race : Rebelle'; 

            $StatRecord = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '". $user['id'] ."';", 'statpoints', true);

            $parse['bat']          = $StatRecord['build_points'] ;
            $parse['fleet']           = $StatRecord['fleet_points'] ;
            $parse['tech']   = $StatRecord['tech_points'] ;
            $parse['general']         = $StatRecord['total_points'] ;
            $parse['def']         = $StatRecord['defs_points'] ;
            $parse['user_rank']            = $StatRecord['total_rank'];
            $parse['bat_rank']            = $StatRecord['build_rank'];
            $parse['fleet_rank']            = $StatRecord['fleet_rank'];
            $parse['tech_rank']            = $StatRecord['tech_rank'];
            $parse['def_rank']            = $StatRecord['defs_rank'];
            $ile = $StatRecord['total_old_rank'] - $StatRecord['total_rank'];
            if ($ile >= 1) {
                $parse['ile']              = "<font color=lime>+" . $ile . "</font>";
            } elseif ($ile < 0) {
                $parse['ile']              = "<font color=red>-" . $ile . "</font>";
            } elseif ($ile == 0) {
                $parse['ile']              = "<font color=lightblue>" . $ile . "</font>";
            }
            $parse['u_user_rank']          = $StatRecord['total_rank'];
            $parse['username']        = $user['username'];

            if (count($fpage) > 0) {
                ksort($fpage);
                foreach ($fpage as $time => $content) {
                    $flotten .= $content . "\n";
                }
            }

            $parse['fleet_list']  = $flotten;
            $parse['energy_used'] = $planetrow["energy_max"] - $planetrow["energy_used"];

            $parse['Have_new_message']      = $Have_new_message;
            $parse['Have_new_level_mineur'] = $HaveNewLevelMineur;
            $parse['Have_new_level_raid']   = $HaveNewLevelRaid;
            $parse['time']                  = 'Nous sommes le '.$jour.' '.date('j').' '.$mois.' 20'.date('y').' et il est '.date('H\h i\m s\s');
            $numero_jour = date('w');
            $jours_semaine = array('Dimanche','Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi');
            $jour = $jours_semaine[$numero_jour];
            $numero_mois = date('w', $time);
            $mois_annee = array('Janvier', 'Fevrier','Mars', 'avril', 'Mai', 'Juin', 'Juillet', 'Aout', 'Septembre', 'Octobre', 'novembre', 'Decembre');
            $mois = $mois_annee[$numero_mois];
            $parse['dpath']                 = $dpath;
            $parse['planet_image']          = $planetrow['image'];
            $parse['anothers_planets']      = $AllPlanets;
            $parse['max_users']             = $game_config['users_amount'];
            
// Pour le jour
if(date('w') == '1')
{
$jour = 'Lundi';
}
if(date('w') == '2')
{
$jour = 'mardi';
}
if(date('w') == '3')
{
$jour = 'mercredi';
}
if(date('w') == '4')
{
$jour = 'jeudi';
}
if(date('w') == '5')
{
$jour = 'vendredi';
}
if(date('w') == '6')
{
$jour = 'Samedi';
}
if(date('w') == '7')
{
$jour = 'Dimanche';
}

// Pour le mois
if(date('m') == '01')
{
$mois = 'Janvier';
}
if(date('m') == '02')
{
$mois = 'Fevrier';
}
if(date('m') == '03')
{
$mois = 'Mars';
}
if(date('m') == '04')
{
$mois = 'Avril';
}
if(date('m') == '05')
{
$mois = 'Mai';
}
if(date('m') == '06')
{
$mois = 'Juin';
}
if(date('m') == '07')
{
$mois = 'Juillet';
}
if(date('m') == '08')
{
$mois = 'Aout';
}
if(date('m') == '09')
{
$mois = 'Septembre';
}
if(date('m') == '10')
{
$mois = 'Octobre';
}
if(date('m') == '11')
{
$mois = 'Novembre';
}
if(date('m') == '12')
{
$mois = 'Decembre';
}

$parse['time'] = 'Nous sommes le '.$jour.' '.date('d').' '.$mois.' '.date('Y').' et il est '.date('H \H\e\u\r\e\s\ : i \M\i\n\u\t\e\s\ : s \s\e\c');


            $parse['metal_debris']          = pretty_number($galaxyrow['metal']);
            $parse['crystal_debris']        = pretty_number($galaxyrow['crystal']);
            if (($galaxyrow['metal'] != 0 || $galaxyrow['crystal'] != 0) && $planetrow[$resource[209]] != 0) {
                $parse['get_link'] = " (<a href=\"quickfleet.php?mode=8&g=".$galaxyrow['galaxy']."&s=".$galaxyrow['system']."&p=".$galaxyrow['planet']."&t=2\">". $lang['type_mission'][8] ."</a>)";
            } else {
                $parse['get_link'] = '';
            }

            if ( $planetrow['b_building'] != 0 ) {
                UpdatePlanetBatimentQueueList ( $planetrow, $user );
                if ( $planetrow['b_building'] != 0 ) {
                    $BuildQueue = explode (";", $planetrow['b_building_id']);
                    $CurrBuild  = explode (",", $BuildQueue[0]);
                    $RestTime   = $planetrow['b_building'] - time();
                    $PlanetID   = $planetrow['id'];
                    $Build  = InsertBuildListScript ( "overview" );
                    $Build .= $lang['tech'][$CurrBuild[0]] .' ('. ($CurrBuild[1]) .')';
                    $Build .= "<br /><div id=\"blc\" class=\"z\">". pretty_time( $RestTime ) ."</div>";
                    $Build .= "\n<script language=\"JavaScript\">";
                    $Build .= "\n    pp = \"". $RestTime ."\";\n";  // temps necessaire (a compter de maintenant et sans ajouter time() )
                    $Build .= "\n    pk = \"". 1 ."\";\n";          // id index (dans la liste de construction)
                    $Build .= "\n    pm = \"cancel\";\n";           // mot de controle
                    $Build .= "\n    pl = \"". $PlanetID ."\";\n";  // id planete
                    $Build .= "\n    t();\n";
                    $Build .= "\n</script>\n";

                    $parse['building'] = $Build;
                } else {
                    $parse['building'] = $lang['Free'];
                }
            } else {
                $parse['building'] = $lang['Free'];
            }
            { // Vista normal
                $query = doquery('SELECT username FROM {{table}} ORDER BY register_time DESC', 'users', true);
                $parse['last_user'] = $query['username'];
                $query = doquery("SELECT COUNT(DISTINCT(id)) FROM {{table}} WHERE onlinetime>" . (time()-900), 'users', true);
                $parse['online_users'] = $query[0];
                // $count = doquery(","users",true);
                $parse['users_amount'] = $game_config['users_amount'];
            }
            // Rajout d'une barre pourcentage
            // Calcul du pourcentage de remplissage
            $parse['case_pourcentage'] = floor($planetrow["field_current"] / CalculateMaxPlanetFields($planetrow) * 100) . $lang['o/o'];
            // Barre de remplissage
            $parse['case_barre'] = floor($planetrow["field_current"] / CalculateMaxPlanetFields($planetrow) * 100) * 2.5;
            // Couleur de la barre de remplissage
            if ($parse['case_barre'] > (100 * 2.5)) {
                $parse['case_barre'] = 250;
                $parse['case_barre_barcolor'] = '#C00000';
            } elseif ($parse['case_barre'] > (80 * 2.5)) {
                $parse['case_barre_barcolor'] = '#C0C000';
            } else {
                $parse['case_barre_barcolor'] = '#00C000';
            }

            //Mode Améliorations
            $parse['xpminier']= $user['xpminier'];
            $parse['xpraid']= $user['xpraid'];
            $parse['lvl_minier'] = $user['lvl_minier'];
            $parse['lvl_raid'] = $user['lvl_raid'];

            $LvlMinier = $user['lvl_minier'];
            $LvlRaid = $user['lvl_raid'];

            $parse['lvl_up_minier'] = $LvlMinier * 5000;
            $parse['lvl_up_raid']   = $LvlRaid * 10;

    $parse['credit'] = $user['credit'];
    $parse['statut'] = $user['statut'];
    $parse['style'] = $user['style'];
    $parse['ally'] = $alliancerow['ally_tag'];
    $parse['ar'] = pretty_number($user['military_tech']*10);
    $parse['bl'] = pretty_number($user['defence_tech']*10);
    $parse['bo'] = pretty_number($user['shield_tech']*10); 

//Statut.
    if($user['lvl_minier'] <= 50) {
            $parse['statut'] = 'Mineur'; }
    elseif($user['lvl_minier'] <= 100) {
            $parse['statut'] = 'Commendant De Mine'; }
    else{
            $parse['statut'] = 'Prospecteur De Haut Niveau'; }
            
    //Style.
    if($user['lvl_raid'] <= 50) {
            $parse['style'] = 'Petit raideur'; }
    elseif($user['lvl_raid'] <= 100) {
            $parse['style'] = 'Hoffeur'; }
    else{
            $parse['style'] = 'L&eacute;gende De Destructeur'; } 

         //Meilleur joueur
		   $Sql = <<<SQL
            SELECT u.username
            FROM {{table}}users u
            JOIN {{table}}statpoints s ON ( u.id = s.id_owner ) 
            WHERE s.total_rank =1 AND s.stat_type =1
SQL;
            $result = doquery($Sql,'','true');
            $parse['PremierJoueur'] = $result['username'];

			//Compteur de Membres en lign
            $OnlineUsers = doquery("SELECT COUNT(*) FROM {{table}} WHERE onlinetime>='".(time()-15*60)."'",'users', 'true');
            $parse['NumberMembersOnline'] = $OnlineUsers[0];

            $page = parsetemplate(gettemplate('overview_body'), $parse);

            display($page, $lang['Overview']);
            break;
    }
      if($StatRecord['total_points'] >= 0 && $StatRecord['total_points'] < 100000) {
                $parse['rankgame'] = "N00B";

                } elseif ($StatRecord['total_points'] >= 1000 && $StatRecord['total_points'] < 25000) {
                $parse['rankgame'] = "Clone";

                } elseif ($StatRecord['total_points'] >= 25000 && $StatRecord['total_points'] < 50000) {
                $parse['rankgame'] = "padawan";

                } elseif ($StatRecord['total_points'] >= 50000 && $StatRecord['total_points'] < 1000000) {
                $parse['rankgame'] = "Jedi";

                } elseif ($StatRecord['total_points'] >= 100000 && $StatRecord['total_points'] < 2500000) {
                $parse['rankgame'] = "Maitre Jedi";

                } elseif ($StatRecord['total_points'] >= 250000 && $StatRecord['total_points'] < 5000000) {
                $parse['rankgame'] = "Seigneur Sith";

                } elseif ($StatRecord['total_points'] >= 500000 && $StatRecord['total_points'] < 10000000000000) {
                $parse['rankgame'] = "Empereur"; 

			return display(templates(templates('OpenGame/overview_body'), $parse));
			break;
	}
  if ($game_config['OverviewClickBanner'] != '') {
                $parse['ClickBanner'] = stripslashes($game_config['OverviewClickBanner']);
            }
            if ($game_config['ForumBannerFrame'] == '1') {

                $BannerURL = "".dirname($_SERVER["HTTP_REFERER"])."/scripts/createbanner.php?id=".$user['id']."";

                $parse['bannerframe'] = "<th colspan=\"4\"><img src=\"scripts/createbanner.php?id=".$user['id']."\"><br>".$lang['InfoBanner']."<br><input name=\"bannerlink\" type=\"text\" id=\"bannerlink\" value=\"[img]".$BannerURL."[/img]\" size=\"62\"></th></tr>";
            }


?>