<?php

	/**
	* overview.php
	*
	* @version 3 (avec heure mother et tout waaaa)
	* @copyright 2008 By Chlorel for XNova and remix by jtb1 ^^ en 2008 :P en 2009 aussi ^^
	*/
	ini_set('display_errors', true);
	define('INSIDE'  , true);
	define('INSTALL' , false);

	$xnova_root_path = './';
	include($xnova_root_path . 'extension.inc');
	include($xnova_root_path . 'common.' . $phpEx);

    $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 (!empty($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;
            
		case 'mothership':  
			if ($_POST['action'] == $lang['namer'])
			{
				// Reponse au changement de nom de la planete
				$UserPlanet = addslashes(CheckInputStrings ($_POST['newname']));
				$newname = mysql_real_escape_string(trim($UserPlanet));
				
				if (!empty($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");
                    
					}
				}
			}
      
			$parse = $lang;

			$parse['planet_id'] = $planetrow['id'];
			$parse['galaxy_galaxy'] = $planetrow['galaxy'];
			$parse['galaxy_system'] = $planetrow['system'];
			$parse['galaxy_planet'] = $planetrow['planet'];
			$parse['planet_name'] = $planetrow['name'];
			$parse['your_planet'] = $lang['mothership'];

			$page .= parsetemplate(gettemplate('overview_base'), $parse);
			
			// On affiche la page permettant d'abandonner OU de renomme une Colonie / Planete
			display($page, $lang['rename_and_abandon_planet']);

            break;

        default:
			//---Fin de la suppression automatiques des inactifs (By Crispo)
			// --- 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.$phpEx>". $lang['Have_new_message']."</a></th>";
                } elseif ($user['new_message'] > 1) {
                    $Have_new_message .= "<th colspan=4><a href=messages.$phpEx>";
                    $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);
			
			// --- Nouvelle Gestion Des Officiers ------------------------------------------------------------
			// --- Conçu par Winjet --------------------------------------------------------------------------
                
			$HaveNewLevelMineur = "";
			$HaveNewLevelRaid = "";
                
			$ProgressionXpMinier = 5000;     // Valeur par défaut
			$ProgressionXpRaid = 10;     // Valeur par défaut
                
			$IdOwner = intval($user['id']);
			$LevelMineurUp = floor(( $user['xpminier'] - $user['lvl_minier'] * $ProgressionXpMinier ) / $ProgressionXpMinier) + 1;
			$LevelRaidUp = floor(( $user['xpraid'] - $user['lvl_raid'] * $ProgressionXpRaid ) / $ProgressionXpRaid) + 1;    
    
			if ( $LevelMineurUp > 0 || $LevelRaidUp > 0 )
			{
				$Qry = <<<SQL
UPDATE 	{{table}}
SET 	`lvl_minier` = `lvl_minier` + '{$LevelMineurUp}',
		`lvl_raid` = `lvl_raid` + '{$LevelRaidUp}',
		`rpg_points` = `rpg_points` + '{$LevelMineurUp}' + '{$LevelRaidUp}'
WHERE 	`id` = '{$IdOwner}';
SQL;
				doquery($Qry, "users");
                
				$user['lvl_minier'] += $LevelMineurUp;
				$user['lvl_raid'] += $LevelRaidUp;
                
				if ($LevelMineurUp > 0)
				{
					$HaveNewLevelMineur  = "<tr>";
					$HaveNewLevelMineur .= "<th colspan=4><a href=officier.$phpEx>Vous avez gagn&eacute; {$LevelMineurUp} niveau(x) en Mineur !</a></th></tr>";
				}
                    
				if ($LevelRaidUp > 0)
				{
					$HaveNewLevelRaid  = "<tr>";
					$HaveNewLevelRaid .= "<th colspan=4><a href=officier.$phpEx>Vous avez gagn&eacute; {$LevelRaidUp} niveau(x) en Raideur !</a></th></tr>";
				}
			}
            
			// -----------------------------------------------------------------------------------------------
            // --- 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 );
                }
            }

			// -----------------------------------------------------------------------------------------------
            // --- 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 ----------------------------------------------------------
            // -----------------------------------------------------------------------------------------------
			
			$Order = ( $user['planet_sort_order'] == 1 ) ? "DESC" : "ASC";
			$Sort  = $user['planet_sort'];
            
			$QryPlanets = "SELECT * FROM {{table}} WHERE `id_owner` = '".$user['id']."' ORDER BY ";
			
			if( $Sort == 0 )
				$QryPlanets .= "`id` ". $Order;
			elseif ( $Sort == 1 )
				$QryPlanets .= "`galaxy` ". $Order." , `system` ". $Order." , `planet` ". $Order." , `planet_type` ". $Order;
			elseif ( $Sort == 2 )
				$QryPlanets .= "`name` ". $Order;

			$planets_query = doquery($QryPlanets, 'planets');

            $Colone  = 1;

            $AllPlanets = "<tr>";
			
            while ($UserPlanet = mysql_fetch_array($planets_query))
			{
				if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3)
				{
					$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 <= 1)
						$Colone++;
					else
					{
						$AllPlanets .= "</tr><tr>";
						$Colone      = 1;
                    }
                }
            }
			
			// -----------------------------------------------------------------------------------------------
			// --- 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 ---------------------------------------------------------
			$lune = doquery("SELECT * FROM {{table}} WHERE galaxy={$lunarow['galaxy']} AND system={$lunarow['system']} AND planet={$lunarow['lunapos']} AND planet_type='3'", 'planets', true);
			
			if (!empty($lune))
			{
				$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'];
			
			$Race = array('Humain', 'Archj', 'Laetis', 'Arkanien', 'Helghast');
			
			if ($user['id_race'] == -1)
				$parse['race'] = 'Inconnue | Contactez votre administrateur';
			else
				$parse['race'] = $Race[$user['id_race']];

            $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']                  = date("D M d H:i:s", time());
            $parse['dpath']                 = $dpath;
            $parse['planet_image']          = $planetrow['image'];
            $parse['anothers_planets']      = $AllPlanets;
            $parse['max_users']             = $game_config['users_amount'];
			
			$day = array('Lundi', 'Mardi', 'Mercredi', 'Jeudi', 'Vendredi', 'Samedi', 'Dimanche');			
			$jour = $day[date('w') - 1];

			$month = array('Janvier', 'F&eacute;vrier', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Aout', 'Septembre', 'Octobre', 'Novembre', 'D&eacute;cembre');
			$mois = $month[date('m') - 1];

			$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'];
         
			$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];
            $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+($LvlRaid*0));
			$parse['bl'] = pretty_number($user['defence_tech']*10+($LvlRaid*0));
			$parse['bo'] = pretty_number($user['shield_tech']*10+($LvlRaid*0));

			//Compteur de Membres en lign
			$OnlineUsers = doquery("SELECT COUNT(*) FROM {{table}} WHERE onlinetime>='".(time()-15*60)."'",'users', 'true');
			$parse['NumberMembersOnline'] = $OnlineUsers[0];

			if($planetrow['planet_type'] == 5)
			{
				$parse['LinkRename'] = 'overview.php?mode=mothership';
				$parse['Planet'] = $lang['mothership'];
			}
			else
				$parse['LinkRename'] = 'overview.php?mode=renameplanet';

			$page = parsetemplate(gettemplate('overview_body'), $parse);

			display($page, $lang['Overview']);
			break;
	}
  

?>