";
if ($user['new_message'] == 1) {
$Have_new_message .= "| ". $lang['Have_new_message']." | ";
} elseif ($user['new_message'] > 1) {
$Have_new_message .= "";
$m = pretty_number($user['new_message']);
$Have_new_message .= str_replace('%m', $m, $lang['Have_new_messages']);
$Have_new_message .= " | ";
}
$Have_new_message .= "";
}
// -----------------------------------------------------------------------------------------------
// --- Gestion Officiers -------------------------------------------------------------------------
// Passage au niveau suivant, ajout du point de compétence et affichage du passage au nouveau level
$XpMinierUp = $user['lvl_minier'] * 100000;
$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 = "";
$HaveNewLevelMineur .= "| ". $lang['Have_new_level_mineur']." | ";
}
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 = "
";
$HaveNewLevelMineur .= "| ". $lang['Have_new_level_raid']." | ";
}
}
// -----------------------------------------------------------------------------------------------
// --- 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 = "
";
while ($UserPlanet = mysql_fetch_array($planets_query)) {
if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3) {
$AllPlanets .= "". $UserPlanet['name'] ."
";
$AllPlanets .= "![](\"".)
";
$AllPlanets .= "";
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 .= "
(". $BuildRestTime .")";
} else {
CheckPlanetUsedFields ($UserPlanet);
$AllPlanets .= $lang['Free'];
}
} else {
$AllPlanets .= $lang['Free'];
}
$AllPlanets .= " | ";
if ($Colone <= 2) {
$Colone++;
} else {
$AllPlanets .= "
";
$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']] .= "
| " . gmdate("H:i:s", $irak['zeit'] + 1 * 60 * 60) . " | Une attaque de missiles (" . $irak['anzahl'] . ") de " . $user_planet['name'] . " ";
$fpage[$irak['zeit']] .= '[' . $irak["galaxy_angreifer"] . ':' . $irak["system_angreifer"] . ':' . $irak["planet_angreifer"] . ']';
$fpage[$irak['zeit']] .= ' arrive sur la planète' . $planet["name"] . ' ';
$fpage[$irak['zeit']] .= '[' . $irak["galaxy"] . ':' . $irak["system"] . ':' . $irak["planet"] . ']';
$fpage[$irak['zeit']] .= '';
$fpage[$irak['zeit']] .= InsertJavaScriptChronoApplet ( "fm", $Record, $time, false );
$fpage[$irak['zeit']] .= " | ";
}
}
// -----------------------------------------------------------------------------------------------
$parse = $lang;
// -----------------------------------------------------------------------------------------------
// News Frame ...
// External Chat Frame ...
// Banner ADS Google (meme si je suis contre cela)
if ($game_config['OverviewNewsFrame'] == '1') {
$parse['NewsFrame'] = "
|---|
| ". $lang['ov_news_title'] ." | ". stripslashes($game_config['OverviewNewsText']) ." |
|---|
";
}
if ($game_config['OverviewExternChat'] == '1') {
$parse['ExternalTchatFrame'] = "| ". stripslashes( $game_config['OverviewExternChatCmd'] ) ." |
|---|
";
}
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'] = "![](\"{$dpath}planeten/{$lunarow['image']}.jpg\")
";
$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'];
$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['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'] = "+" . $ile . "";
} elseif ($ile < 0) {
$parse['ile'] = "-" . $ile . "";
} elseif ($ile == 0) {
$parse['ile'] = "" . $ile . "";
}
$parse['u_user_rank'] = $StatRecord['total_rank'];
$parse['user_username'] = $user['username'];
// Bewegte Resourcen
$moved_query = doquery("SELECT `fleet_owner`,`fleet_mission`,SUM(`fleet_resource_metal`) as metal,SUM(`fleet_resource_crystal`) as crystal,SUM(`fleet_resource_deuterium`)as deuterium FROM {{table}} WHERE fleet_owner = ".$user['id']." GROUP BY fleet_mission",'fleets');
// Gesamte bewegte Resourcen
$g_metal= 0;
$g_crystal= 0;
$g_deuterium= 0;
$g_debris= 0;
$parse['res_atk_metal']= 0;
$parse['res_atk_crystal']= 0;
$parse['res_atk_deuterium']= 0;
$parse['res_trans_metal']= 0;
$parse['res_trans_crystal']= 0;
$parse['res_trans_deuterium']= 0;
$parse['res_statio_metal']= 0;
$parse['res_statio_crystal']= 0;
$parse['res_statio_deuterium']= 0;
$parse['res_debris_metal']= 0;
$parse['res_debris_crystal']= 0;
$parse['res_debris_deuterium']= 0;
while($moved = mysql_fetch_assoc($moved_query)) {
switch($moved['fleet_mission']) {
// Angriff
case 1:
$parse['res_atk_metal']= pretty_number($moved['metal']);
$parse['res_atk_crystal']= pretty_number($moved['crystal']);
$parse['res_atk_deuterium']= pretty_number($moved['deuterium']);
$g_metal+= $moved['metal'];
$g_crystal+= $moved['crystal'];
$g_deuterium+= $moved['deuterium'];
break;
// Transport
case 3:
$parse['res_trans_metal']= pretty_number($moved['metal']);
$parse['res_trans_crystal']= pretty_number($moved['crystal']);
$parse['res_trans_deuterium']= pretty_number($moved['deuterium']);
$g_metal+= $moved['metal'];
$g_crystal+= $moved['crystal'];
$g_deuterium+= $moved['deuterium'];
break;
// Stationieren
case 4:
$parse['res_statio_metal']= pretty_number($moved['metal']);
$parse['res_statio_crystal']= pretty_number($moved['crystal']);
$parse['res_statio_deuterium']= pretty_number($moved['deuterium']);
$g_metal+= $moved['metal'];
$g_crystal+= $moved['crystal'];
$g_deuterium+= $moved['deuterium'];
break;
// Trümmerfeld
case 8:
$parse['res_debris_metal']= pretty_number($moved['metal']);
$parse['res_debris_crystal']= pretty_number($moved['crystal']);
$parse['res_debris_deuterium']= pretty_number($moved['deuterium']);
$g_metal+= $moved['metal'];
$g_crystal+= $moved['crystal'];
$g_deuterium+= $moved['deuterium'];
break;
}
}
$parse['res_all_metal']= pretty_number($g_metal);
$parse['res_all_crystal']= pretty_number($g_crystal);
$parse['res_all_deuterium']= pretty_number($g_deuterium);
// Bewegte Resourcen ENDE
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'];
$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'] = " (". $lang['type_mission'][8] .")";
} 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 .= "
". pretty_time( $RestTime ) ."
";
$Build .= "\n\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 * 100000;
$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'];
//Extras
$parse['avatar'] = $user['avatar'];
//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;
}
?>