<?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);
$parse['avatar']          = $user['avatar'];
CheckPlanetUsedFields ($lunarow);

$mode = isset($_GET['mode']) ? $_GET['mode'] : '';
$_POST['deleteid'] = intval($_POST['deleteid']);
$pl = mysql_real_escape_string(isset($_GET['pl']) ? $_GET['pl'] : 0);



includeLang('resources');
includeLang('overview');
includeLang('general');

// chat //
    includeLang('chat');
    $BodyTPL = gettemplate('chat_body');
	$IdUser = intval($user['id']);
    $nick = $user['username'];
	

	   $NbreDaysDelMsg = 3;
    $QryDeleteOldMsg = <<<SQL
                                DELETE FROM {{table}} 
                                WHERE         `timestamp` <= UNIX_TIMESTAMP(NOW()) - (3600 * 24 * {$NbreDaysDelMsg});
SQL;
    
    // Les messages datant de plus de 3 jours
    // sont effacés
    doquery($QryDeleteOldMsg, 'chat');
    

	
    $QrySelectUsers = <<<SQL
                                SELECT         `id`, `username`, `authlevel` ,`ally_id`
                                FROM         {{table}} 
                                WHERE       
                                            `onlinetime` >= UNIX_TIMESTAMP(NOW()) - 300 
                                ORDER BY     `username` ASC;
SQL;

    $Result = doquery($QrySelectUsers, 'users');
	$IdAlli = intval($Result['ally_id']);
    // On récupère les joueurs qui sont sur le chat
    // il y a moins de 5 minutes

    
    $parse['UsersConnected'] = "";
    while( $TheUser = mysql_fetch_array($Result) )
    {
        // Couleur personnalisée selon
        // le rang du joueur
        
        if ($TheUser['authlevel'] == 3)
            $color = "#FF0000";
        elseif ($TheUser['authlevel'] == 2)
            $color = "#660066";
        elseif ($TheUser['authlevel'] == 1)
            $color = "#006600";
        else
            $color = "#FFFFFF";
			
          
        $parse['UsersConnected'] .= <<<TXT
                                            <tr align="left">
                                                <td class="c" style="background-image: none; border: 0px;"><a href="messages.php?mode=write&id={$TheUser['id']}" style="color: {$color};">{$TheUser['username']}</a></td>
                                            </tr>
TXT;

    }
    // On récupère les informations du message et de l'envoyeur
    if (isset($_POST["msg"]) && isset($user['username']))
    {
       $nick = trim (str_replace ("+","plus",$user['username']));
       $msg  = trim (str_replace ("+","plus",$_POST["msg"]));
       $msg  = addslashes ($_POST["msg"]);
       $nick = addslashes ($user['username']);
	   $allyid = addslashes ($user['ally_id']);
    }
    else {
       $msg="";
       $nick="";
    }

    // Ajout du message dans la database
    if ( !empty($msg) && !empty($nick) ) {
       $query = doquery("INSERT INTO {{table}}(user, message,ally_id, timestamp) VALUES ('".$nick."', '".$msg."','".$allyid."', '".time()."')", "chat");
    }
// On efface les anciens messages
$timemoment=time();
$time_1h=$timemoment - 3600;

// On selectionne les messages présents dans la base de donnée
$QrySelectMsg = <<<SQL
                            SELECT         c.user         AS `user`, 
                                        c.message     AS `message`, 
                                        c.timestamp AS `timestamp`, 
                                        u.authlevel AS `authlevel`, 
                                        u.id         AS `id` 
                            FROM         {{table}}chat AS c 
                            JOIN         {{table}}users AS u ON c.user = u.username 
                            ORDER BY     `messageid` ASC;
SQL;

    $query = doquery($QrySelectMsg, '');
    while( $v = mysql_fetch_array($query) )
    {
// On se protège de certaines données
        // dangereuses
        $nick = htmlentities($v['user']);
        $msg = htmlentities(utf8_decode($v['message']));
        $timestamp = intval($v['timestamp']);
        $authlevel = intval($v['authlevel']);
        $id = intval($v['id']);
		

	// Les différentes polices (gras, italique, couleurs, etc...)
	$msg=preg_replace("#\[a=(ft|https?://)(.+)\](.+)\[/a\]#isU", "<a href=\"$1$2\" target=\"_blank\">$3</a>", $msg);
	$msg=preg_replace("#\[b\](.+)\[/b\]#isU","<b>$1</b>",$msg);
	$msg=preg_replace("#\[i\](.+)\[/i\]#isU","<i>$1</i>",$msg);
	$msg=preg_replace("#\[u\](.+)\[/u\]#isU","<u>$1</u>",$msg);
	$msg=preg_replace("#\[c=(blue|yellow|green|pink|red|orange)\](.+)\[/c\]#isU","<font color=\"$1\">$2</font>",$msg);

	// Les smileys avec leurs raccourcis
	$msg=preg_replace("#:c#isU","<img src=\"images/smileys/cry.png\" align=\"absmiddle\" title=\":c\" alt=\":c\">",$msg);
	$msg=preg_replace("#:/#isU","<img src=\"images/smileys/confused.png\" align=\"absmiddle\" title=\":/\" alt=\":/\">",$msg);
	$msg=preg_replace("#o0#isU","<img src=\"images/smileys/dizzy.png\" align=\"absmiddle\" title=\"o0\" alt=\"o0\">",$msg);
	$msg=preg_replace("#\^\^#isU","<img src=\"images/smileys/happy.png\" align=\"absmiddle\" title=\"^^\" alt=\"^^\">",$msg);
	$msg=preg_replace("#:D#isU","<img src=\"images/smileys/lol.png\" align=\"absmiddle\" title=\":D\" alt=\":D\">",$msg);
	$msg=preg_replace("#:\|#isU","<img src=\"images/smileys/neutral.png\" align=\"absmiddle\" title=\":|\" alt=\":|\">",$msg);
	$msg=preg_replace("#:\)#isU","<img src=\"images/smileys/smile.png\" align=\"absmiddle\" title=\":)\" alt=\":)\">",$msg);
	$msg=preg_replace("#:o#isU","<img src=\"images/smileys/omg.png\" align=\"absmiddle\" title=\":o\" alt=\":o\">",$msg);
	$msg=preg_replace("#:p#isU","<img src=\"images/smileys/tongue.png\" align=\"absmiddle\" title=\":p\" alt=\":p\">",$msg);
	$msg=preg_replace("#:\(#isU","<img src=\"images/smileys/sad.png\" align=\"absmiddle\" title=\":(\" alt=\":(\">",$msg);
	$msg=preg_replace("#;\)#isU","<img src=\"images/smileys/wink.png\" align=\"absmiddle\" title=\";)\" alt=\";)\">",$msg);
	$msg=preg_replace("#:s#isU","<img src=\"images/smileys/shit.png\" align=\"absmiddle\" title=\":s\" alt=\":s\">",$msg);
	$msg=preg_replace("#xnova#","<a href=\"http://www.xnova-ng.org\">XNova</a>",$msg);

	  // Couleur personnalisée selon
        // le rang du joueur

        if ($authlevel == 3)
            $color = "#FF0000";
        elseif ($authlevel == 2)
            $color = "#660066";
        elseif ($authlevel == 1)
            $color = "#006600";
        else
            $color = "#5e8743";
            
        date_default_timezone_set("Europe/Paris");        
        $TimeText = strftime("[%d/%m/%Y]", $timestamp) . ' ' . strftime("[%H:%M]", $timestamp);
	
	// Affichage du message

    }

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");
                    }
                }

            } 

            $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'];
			
			$parse['leftmenu']  	= ShowLeftMenu ();
            $page                  .= parsetemplate(gettemplate('overview_renameplanet'), $parse);

            // On affiche la page permettant d'abandonner OU de renomme une Colonie / Planete
            display($page, $lang['rename_planet']);
            break;
			
			case 'abandonplanet':
            // -----------------------------------------------------------------------------------------------
				if ($_POST['action'] == $lang['deleteplanet']) {
                // 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'];
	
				$parse['leftmenu']  	 = ShowLeftMenu ();
                $page                   .= parsetemplate(gettemplate('overview_deleteplanet'), $parse);
				display($page, $lang['colony_abandon']);
                // On affiche la forme pour l'abandon de la colonie
               

            } 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 !!
					
					$parse['leftmenu']  	 = ShowLeftMenu ();
					$page                   .= parsetemplate(gettemplate('overview_deleteok'), $parse);
					display($page, $lang['colony_abandon']);

                } 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 !!!
                    
					$parse['leftmenu']  	 = ShowLeftMenu ();
					$page                   .= parsetemplate(gettemplate('overview_deletepm'), $parse);
					display($page, $lang['colony_abandon']);
					
                } else {
                    // Erreur de saisie du mot de passe je n'efface pas !!!
                    
					$parse['leftmenu']  	 = ShowLeftMenu ();
					$page                   .= parsetemplate(gettemplate('overview_deletepass'), $parse);
					display($page, $lang['colony_abandon']);
				

                }
            }

            $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'];
			
			$parse['leftmenu']  	= ShowLeftMenu ();
            $page                  .= parsetemplate(gettemplate('overview_deleteplanet'), $parse);

            // On affiche la page permettant d'abandonner OU de renomme une Colonie / Planete
            display($page, $lang['colony_abandon']);
            break;

    default:
        if ($user['id'] != '') {
            // --- Gestion des messages ----------------------------------------------------------------------
            $Have_new_message = "";
            
            $query = <<<SQL
SELECT COUNT(*) AS `nbre`
FROM {{table}}
WHERE `message_owner` = '{$user['id']}' AND
`AccLecture` = '0'
SQL;
            $messages = doquery($query, 'messages', true);
            
            if ($messages['nbre'] != 0)
			 $Have_new_message .= "Vous n\'avez pas de nouveaux messages";
            { 
                $Have_new_message .= "<tr>";
                if ($messages['nbre'] == 1) {
                    $Have_new_message .= "<th colspan=4><a href=messages.php>" . $lang['Have_new_message'] . "</a></th>";
                } elseif ($messages['nbre'] > 1) {
                    $Have_new_message .= "<th colspan=4><a href=messages.php>";
                    $m = pretty_number($messages['nbre']);
                    $Have_new_message .= str_replace('%m', $m, $lang['Have_new_messages']);
                    $Have_new_message .= "</a></th>";
                }
                $Have_new_message .= "</tr>";
            } 
            // -----------------------------------------------------------------------------------------------
            // --- 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.". PHPEXT .">" . $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.". PHPEXT .">" . $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 ...
            $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`, `system`, `planet`, `planet_type` " . $Order;
            } elseif ($Sort == 2) {
                $QryPlanets .= "`name` " . $Order;
            }
            $planets_query = doquery ($QryPlanets, 'planets');
            $Colone = 2;
            $AllPlanets = "<tr>";
            while ($UserPlanet = mysql_fetch_array($planets_query)) {
                PlanetResourceUpdate ($user, $UserPlanet, time());
                if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3) {
                    $AllPlanets .= "<th>";
                    $AllPlanets .= "<a href=\"?cp=" . $UserPlanet['id'] . "&re=0\" title=\"" . $UserPlanet['name'] . "\"><img src=\"http://s425011127.onlinehome.fr/test2/skins/xnova/planeten/small/s_" . $UserPlanet['image'] . "\" height=\"40\" width=\"40\" ></a>";
                    $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 style=\"border:0px;border-top:1px #413e3e solid;\" colspan=\"3\">" . stripslashes($game_config['OverviewNewsText']) . "</th></tr>";
            }
            if ($game_config['OverviewExternChat'] == '1') {
                $parse['ExternalTchatFrame'] = "<tr><th style=\"border:0px;border-top:1px #413e3e solid;\" colspan=\"4\">" . stripslashes($game_config['OverviewExternChatCmd']) . "</th></tr>";
            }
            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 style=\"border:0px;border-top:1px #413e3e solid;\" 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>";
            }
            // --- Gestion de l'affichage d'une lune ---------------------------------------------------------
            if ($lunarow['id'] <> 0) {
                if ($planetrow['planet_type'] == 1) {
                    $lune = doquery ("SELECT * FROM {{table}} WHERE `galaxy` = '" . $planetrow['galaxy'] . "' AND `system` = '" . $planetrow['system'] . "' AND `planet` = '" . $planetrow['planet'] . "' AND `planet_type` = '3'", 'planets', true);
                    $parse['moon_img'] = "<a href=\"?cp=" . $lune['id'] . "&re=0\" title=\"" . $lune['name'] . "\"><img src=\"" . $dpath . "planeten/moon/" . $lune['image'] . ".jpg\" height=\"250\" width=\"250\"></a>";
                    $parse['moon'] = $lune['name'];
                } else {
                    $parse['moon_img'] = "";
                    $parse['moon'] = "";
                }
            } 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'];
	        
			
			//races image
			$selectavatar  = doquery("SELECT id_race AS `raceavatar`  FROM {{table}} WHERE `id` = '".$user['id']."';", 'users', true);
		$avatar_race     = $selectavatar['raceavatar'];	
		if ($avatar_race == -1) {
				$parse['avatar_race']     = "http://www.stargate-conflict.fr/skins/xnova/gebaeude/noavatar.png";
			}
		if ($avatar_race == 0) {
				$parse['avatar_race']     = "http://www.stargate-conflict.fr/skins/xnova/gebaeude/1000.jpg";
			}
		if ($avatar_race == 1) {
				$parse['avatar_race']     = "http://www.stargate-conflict.fr/skins/xnova/gebaeude/1001.jpg";
			}
		if ($avatar_race == 2) {
				$parse['avatar_race']     = "http://www.stargate-conflict.fr/skins/xnova/gebaeude/1002.jpg";
			}
		if ($avatar_race == 3) {
				$parse['avatar_race']     = "http://www.stargate-conflict.fr/skins/xnova/gebaeude/1003.jpg";
			}
		if ($avatar_race == 4) {
				$parse['avatar_race']     = "http://www.stargate-conflict.fr/skins/xnova/gebaeude/1004.jpg";
			}
		if ($avatar_race == 5) {
				$parse['avatar_race']     = "http://www.stargate-conflict.fr/skins/xnova/gebaeude/1005.jpg";
			}
   
			
			
			//races affichage
			if ($user['id_race'] == -1)
                $parse['race'] = 'Race : Inconnue | Contactez votre administrateur';
            if ($user['id_race'] == 0)
                $parse['race'] = 'Race : Asgard';
            if ($user['id_race'] == 1)
                $parse['race'] = 'Race : Tok\'ra';
            if ($user['id_race'] == 2)
                $parse['race'] = 'Race : Humain';
			if ($user['id_race'] == 3)
                $parse['race'] = 'Race : Wraith';
			if ($user['id_race'] == 4)
                $parse['race'] = 'Race : Ori';
            if ($user['id_race'] == 5)
                $parse['race'] = 'Race : Goa\'uld';
				
            $StatRecord = doquery("SELECT * FROM {{table}} WHERE `stat_type` = '1' AND `stat_code` = '1' AND `id_owner` = '" . $user['id'] . "';", 'statpoints', true);

            $parse['user_points'] = pretty_number($StatRecord['build_points']);
            $parse['user_fleet'] = pretty_number($StatRecord['fleet_points']);
			$parse['user_def'] = pretty_number($StatRecord['defs_points']);
			$parse['user_caserne'] = pretty_number($StatRecord['caserne_points']);
            $parse['player_points_tech'] = pretty_number($StatRecord['tech_points']);
            $parse['total_points'] = pretty_number($StatRecord['total_points']);

            $parse['user_rank'] = $StatRecord['total_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['user_username'] = $user['username'];
			$parse['user_avatar'] = $user['avatar'];
			$parse['alliance'] = $user['ally_name'];

            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'] = "<div id=\"dateheure\"></div>";
            $parse['dpath'] = $dpath;
            $parse['planet_image'] = $planetrow['image'];
            $parse['anothers_planets'] = $AllPlanets;
            $parse['max_users'] = $game_config['users_amount'];

            $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];
            // $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) * 4.0;
            // Couleur de la barre de remplissage
            if ($parse['case_barre'] > (100 * 4.0)) {
                $parse['case_barre'] = 400;
                $parse['case_barre_barcolor'] = '#C00000';
            } elseif ($parse['case_barre'] > (80 * 4.0)) {
                $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;
            // Nombre de raids, pertes, etc ...
            $parse['Raids'] = $lang['Raids'];
            $parse['NumberOfRaids'] = $lang['NumberOfRaids'];
            $parse['RaidsWin'] = $lang['RaidsWin'];
            $parse['RaidsLoose'] = $lang['RaidsLoose'];

            $parse['raids'] = $user['raids'];
            $parse['raidswin'] = $user['raidswin'];
            $parse['raidsloose'] = $user['raidsloose'];
			/********************************
			 *			MODE GENERAL		*
			 *******************************/
			$parse['your_com'] = $lang['your_com'];//votre commandant
			if(empty($verification_commandant['Description_general']))
			{
			$parse['your_description'] = "votre description";//votre commandant
			}
			else
			{
			$parse['your_description'] = $verification_commandant['Description_general'];//votre commandant
			}
			$parse['select_grade'] = $verification_commandant['general_arme'];			
			$parse['file'] = $lang['file'];//Fichier :
			$parse['upload_file'] = $lang['upload_file'];//Envoyer le fichier
			$parse['description'] = $lang['description'];//description:
			$parse['corp_arme'] = $lang['corp_arme'];//Corp d'armée:
			$parse['terre'] = $lang['terre'];//Terre
			$parse['Mer'] = $lang['Mer'];//Mer
			$parse['air'] = $lang['air'];//l air
			$parse['grade'] = $lang['grade'];//grade:
			$parse['point'] = $lang['point'];//Point:
			$parse['the_avatar'] = $lang['the_avatar'];//avatar:
			$parse['your_modif'] = "											<li>
					<a
						href='general.php?mode=modifier'
						onclick='mailConfirmationShow(); return false;'
						id='emailConfirmOpenBtn'
						class='premiumButton'
						onmouseover='Tip('V&eacute;rifier l\'e-mail')'
						onmouseout='UnTip()'
					>
						<span>Modifier Commandant</span>
					</a>
				</li>";
			if(empty($verification_commandant['avatar_general']))
			{
			$parse['noavatar'] = "images/No_Avatar.png";//url avatar
			}
			else
			{
			$parse['noavatar'] = $verification_commandant['avatar_general'];//url avatar	
			}
			$parse['your_grade'] = $grades[$verification_commandant['general_grade']];//le grade
			//ton corp d'armé
			if($verification_commandant['general_arme'] == 1){$parse['your_corp_arme'] = $lang['terre'];}
			if($verification_commandant['general_arme'] == 2){$parse['your_corp_arme'] = $lang['Mer'];}
			if($verification_commandant['general_arme'] == 3){$parse['your_corp_arme'] = $lang['air'];}
			if($verification_commandant['general_arme'] <=0){$parse['your_corp_arme'] = $lang['terre'];}
			$parse['your_point_general'] = intval($verification_commandant['point_general']);//les points accumulé			
			/********************************
			 *			MODE VOTE			*
			 *******************************/			
			$idvote = 2502;
			$IdUser = intval($user['id']);	
			//selection du champs verif_vote pour verifier si il est a 0 ou 1 par rapport a l'utilisateur
			$voting  = doquery("SELECT verif_vote AS `votes`  FROM {{table}} WHERE `id` = '".$user['id']."';", 'users', true);
			$votees     = $voting['votes'];

			//selection du champs time_vote par rapport a l'utilisateur
			$temps_next_vote  = doquery("SELECT time_vote AS `temp_vote`  FROM {{table}} WHERE `id` = '".$user['id']."';", 'users', true);
			$votetemp     = $temps_next_vote['temp_vote'];
			$calcule =  ($votetemp-3600)- time();
			$parse['test']= ($votetemp)- time();
			//selection du champs vote par rapport a l'utilisateur
			$nbvoting  = doquery("SELECT vote AS `nbvote`  FROM {{table}} WHERE `id` = '".$user['id']."';", 'users', true);
			$nbvotees     = $nbvoting['nbvote'];

			
			// si le temps actuel est plus petit ou egale au 2 heures il affiche le temps restant
			$parse['idvote']=$idvote;
			$parse['ov_text_vote']= $lang['ov_text_vote'];
			if($game_config['enable_tchat_over'] == 1)
			{
				$parse['tchat'] ="<tr>
						<th  style='border:0px;'colspan='4'>
							<div id='shoutbox' style='margin: 5px; vertical-align: text-top; height: 160px; overflow:auto;'></div>
				</th>
				</tr>
				<tr>
						<td style='border:0px;'  colspan='4' class='c'>".$lang['chat_message'].": <input name='msg' type='text' id='msg' size='44' maxlength='100' onKeyPress='if(event.keyCode == 13){ addMessage(); } if (event.keyCode==60 || event.keyCode==62) event.returnValue = false; if (event.which==60 || event.which==62) return false;'> <input type='button' name='send' value='".$lang['chat_send']."' id='send' onClick='addMessage()'></td style='border:0px;' >
				</tr>";
			}
			else
			{
			$parse['tchat']="";
}
			// sinon il affiche la banniere de vote

            // Compteur de Membres en ligne
            $OnlineUsers = doquery("SELECT COUNT(*) FROM {{table}} WHERE onlinetime>='" . (time()-15 * 60) . "'", 'users', 'true');
            $parse['NumberMembersOnline'] = $OnlineUsers[0];
			
			$parse['leftmenu']  = ShowLeftMenu ();
            $page = parsetemplate(gettemplate('overview_body'), $parse);

            display($page, $lang['Overview']);
            break;
        }
}

?>
