/**
* BuildFlyingFleetTable.php
*
* @version 1
* @copyright 2008 By Chlorel for XNova
*/
function BuildFlyingFleetTable()
{
global $lang;
$TableTPL = gettemplate('admin/fleet_rows');
$FlyingFleets = doquery("SELECT * FROM {{table}} ORDER BY `fleet_end_time` ASC;", 'fleets');
while ($CurrentFleet = mysql_fetch_assoc($FlyingFleets)) {
$FleetOwner = doquery("SELECT `username` FROM {{table}} WHERE `id` = '" . $CurrentFleet['fleet_owner'] . "';", 'users', true);
$TargetOwner = doquery("SELECT `username` FROM {{table}} WHERE `id` = '" . $CurrentFleet['fleet_target_owner'] . "';", 'users', true);
$Bloc['Id'] = $CurrentFleet['fleet_id'];
$Bloc['Mission'] = CreateFleetPopupedMissionLink($CurrentFleet, $lang['type_mission'][$CurrentFleet['fleet_mission']], '');
$Bloc['Mission'] .= "<br>" . ($CurrentFleet['fleet_mess'] == 1 ? "R" : "A");
$Bloc['Fleet'] = CreateFleetPopupedFleetLink($CurrentFleet, $lang['tech'][200], '');
$Bloc['St_Owner'] = "[" . $CurrentFleet['fleet_owner'] . "]<br>" . $FleetOwner['username'];
$Bloc['St_Posit'] = "[" . $CurrentFleet['fleet_start_galaxy'] . ":" . $CurrentFleet['fleet_start_system'] . ":" . $CurrentFleet['fleet_start_planet'] . "]<br>" . ($CurrentFleet['fleet_start_type'] == 1 ? "[P]" : ($CurrentFleet['fleet_start_type'] == 2 ? "D" : "L")) . "";
$Bloc['St_Time'] = date('G:i:s d/n/Y', $CurrentFleet['fleet_start_time']);
if (is_array($TargetOwner)) {
$Bloc['En_Owner'] = "[" . $CurrentFleet['fleet_target_owner'] . "]<br>" . $TargetOwner['username'];
} else {
$Bloc['En_Owner'] = "";
}
$Bloc['En_Posit'] = "[" . $CurrentFleet['fleet_end_galaxy'] . ":" . $CurrentFleet['fleet_end_system'] . ":" . $CurrentFleet['fleet_end_planet'] . "]<br>" . ($CurrentFleet['fleet_end_type'] == 1 ? "[P]" : ($CurrentFleet['fleet_end_type'] == 2 ? "D" : "L")) . "";
if ($CurrentFleet['fleet_mission'] == 15) {
$Bloc['Wa_Time'] = date('G:i:s d/n/Y', $CurrentFleet['fleet_stay_time']);
} else {
$Bloc['Wa_Time'] = "";
}
$Bloc['En_Time'] = date('G:i:s d/n/Y', $CurrentFleet['fleet_end_time']);
$table .= parsetemplate($TableTPL, $Bloc);
}
return $table;
}
define('INSIDE', true);
define('INSTALL', false);
define('IN_ADMIN', true);
require '../common.' . substr(strrchr(__FILE__, '.'), 1);
if ($user['authlevel'] < 2) {
AdminMessage($lang['adm_err_denied']);
}
$TableTPL = gettemplate('admin/fleet_rows');
$FlyingFleets = doquery("SELECT * FROM `{{fleets}}` ORDER BY `fleet_end_time` ASC;");
while ($CurrentFleet = mysql_fetch_assoc($FlyingFleets)) {
$FleetOwner = doquery("SELECT `username` FROM `{{users}}` WHERE `id` = '" . $CurrentFleet['fleet_owner'] . "';", '', true);
$TargetOwner = doquery("SELECT `username` FROM `{{users}}` WHERE `id` = '" . $CurrentFleet['fleet_target_owner'] . "';", '', true);
$Bloc['Id'] = $CurrentFleet['fleet_id'];
$Bloc['Mission'] = CreateFleetPopupedMissionLink($CurrentFleet, $lang['type_mission'][$CurrentFleet['fleet_mission']], '');
$Bloc['Mission'] .= "<br>" . ($CurrentFleet['fleet_mess'] == 1 ? "R" : "A");
$Bloc['Fleet'] = CreateFleetPopupedFleetLink($CurrentFleet, $lang['tech'][200], '', $FleetOwner['username']);
$Bloc['St_Owner'] = "[" . $CurrentFleet['fleet_owner'] . "]<br>" . $FleetOwner['username'];
$Bloc['St_Posit'] = "[" . $CurrentFleet['fleet_start_galaxy'] . ":" . $CurrentFleet['fleet_start_system'] . ":" . $CurrentFleet['fleet_start_planet'] . "]<br>" . ($CurrentFleet['fleet_start_type'] == 1 ? "[P]" : ($CurrentFleet['fleet_start_type'] == 2 ? "D" : "L")) . "";
$Bloc['St_Time'] = date(FMT_DATE_TIME, $CurrentFleet['fleet_start_time']);
if (is_array($TargetOwner)) {
$Bloc['En_Owner'] = "[" . $CurrentFleet['fleet_target_owner'] . "]<br>" . $TargetOwner['username'];
} else {
$Bloc['En_Owner'] = "";
}
$Bloc['En_Posit'] = "[" . $CurrentFleet['fleet_end_galaxy'] . ":" . $CurrentFleet['fleet_end_system'] . ":" . $CurrentFleet['fleet_end_planet'] . "]<br>" . ($CurrentFleet['fleet_end_type'] == 1 ? "[P]" : ($CurrentFleet['fleet_end_type'] == 2 ? "D" : "L")) . "";
if ($CurrentFleet['fleet_mission'] == 15) {
$Bloc['Wa_Time'] = date(FMT_DATE_TIME, $CurrentFleet['fleet_stay_time']);
} else {
$Bloc['Wa_Time'] = "";
}
$Bloc['En_Time'] = date(FMT_DATE_TIME, $CurrentFleet['fleet_end_time']);
function BuildFleetEventTable($FleetRow, $Status, $Owner, $Label, $Record)
{
global $lang;
$FleetStyle = array(1 => 'attack', 2 => 'federation', 3 => 'transport', 4 => 'deploy', 5 => 'hold', 6 => 'espionage', 7 => 'colony', 8 => 'harvest', 9 => 'destroy', 10 => 'missile', 15 => 'transport');
$FleetStatus = array(0 => 'flight', 1 => 'holding', 2 => 'return');
if ($Owner == true) {
$FleetPrefix = 'own';
} else {
$FleetPrefix = '';
}
$RowsTPL = gettemplate('overview_fleet_event');
$MissionType = $FleetRow['fleet_mission'];
$FleetContent = CreateFleetPopupedFleetLink($FleetRow, $lang['ov_fleet'], $FleetPrefix . $FleetStyle[$MissionType]);
$FleetCapacity = CreateFleetPopupedMissionLink($FleetRow, $lang['type_mission'][$MissionType], $FleetPrefix . $FleetStyle[$MissionType]);
$StartPlanet = doquery("SELECT `name` FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_start_system'] . "' AND `planet` = '" . $FleetRow['fleet_start_planet'] . "' AND `planet_type` = '" . $FleetRow['fleet_start_type'] . "';", 'planets', true);
$StartType = $FleetRow['fleet_start_type'];
$TargetPlanet = doquery("SELECT `name` FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_end_system'] . "' AND `planet` = '" . $FleetRow['fleet_end_planet'] . "' AND `planet_type` = '" . $FleetRow['fleet_end_type'] . "';", 'planets', true);
$TargetType = $FleetRow['fleet_end_type'];
if ($Status != 2) {
if ($StartType == 1) {
$StartID = $lang['ov_planet_to'];
} elseif ($StartType == 3) {
$StartID = $lang['ov_moon_to'];
}
$StartID .= $StartPlanet['name'] . " ";
$StartID .= GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
if ($MissionType != 15) {
if ($TargetType == 1) {
$TargetID = $lang['ov_planet_to_target'];
} elseif ($TargetType == 2) {
$TargetID = $lang['ov_debris_to_target'];
} elseif ($TargetType == 3) {
$TargetID = $lang['ov_moon_to_target'];
}
} else {
$TargetID = $lang['ov_explo_to_target'];
}
$TargetID .= $TargetPlanet['name'] . " ";
$TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
} else {
if ($StartType == 1) {
$StartID = $lang['ov_back_planet'];
} elseif ($StartType == 3) {
$StartID = $lang['ov_back_moon'];
}
$StartID .= $StartPlanet['name'] . " ";
$StartID .= GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
if ($MissionType != 15) {
if ($TargetType == 1) {
$TargetID = $lang['ov_planet_from'];
} elseif ($TargetType == 2) {
$TargetID = $lang['ov_debris_from'];
} elseif ($TargetType == 3) {
$TargetID = $lang['ov_moon_from'];
}
} else {
$TargetID = $lang['ov_explo_from'];
}
$TargetID .= $TargetPlanet['name'] . " ";
$TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
}
if ($Owner == true) {
$EventString = $lang['ov_une'];
$EventString .= $FleetContent;
} else {
$EventString = $lang['ov_une_hostile'];
$EventString .= $FleetContent;
$EventString .= $lang['ov_hostile'];
$EventString .= BuildHostileFleetPlayerLink($FleetRow);
}
if ($Status == 0) {
$Time = $FleetRow['fleet_start_time'];
$Rest = $Time - time();
$EventString .= $lang['ov_vennant'];
$EventString .= $StartID;
$EventString .= $lang['ov_atteint'];
$EventString .= $TargetID;
$EventString .= $lang['ov_mission'];
} elseif ($Status == 1) {
$Time = $FleetRow['fleet_end_stay'];
$Rest = $Time - time();
$EventString .= $lang['ov_vennant'];
$EventString .= $StartID;
$EventString .= $lang['ov_explo_stay'];
$EventString .= $TargetID;
$EventString .= $lang['ov_explo_mission'];
} elseif ($Status == 2) {
$Time = $FleetRow['fleet_end_time'];
$Rest = $Time - time();
$EventString .= $lang['ov_rentrant'];
$EventString .= $TargetID;
$EventString .= $StartID;
$EventString .= $lang['ov_mission'];
}
$EventString .= $FleetCapacity;
$bloc['fleet_status'] = $FleetStatus[$Status];
$bloc['fleet_prefix'] = $FleetPrefix;
$bloc['fleet_style'] = $FleetStyle[$MissionType];
$bloc['fleet_javai'] = InsertJavaScriptChronoApplet($Label, $Record, $Rest, true);
$bloc['fleet_order'] = $Label . $Record;
$bloc['fleet_time'] = gmdate("H:i:s", $Time + 1 * 60 * 60);
$bloc['fleet_descr'] = $EventString;
$bloc['fleet_javas'] = InsertJavaScriptChronoApplet($Label, $Record, $Rest, false);
return parsetemplate($RowsTPL, $bloc);
}
/**
* BuildFleetEventTaple.php
* @Licence GNU (GPL)
* @version 3.0
* @copyright 2009
* @Team Space Beginner
*
**/
function BuildFleetEventTable($FleetRow, $Status, $Owner, $Label, $Record)
{
global $lang;
$FleetStyle = array(1 => 'attack', 2 => 'federation', 3 => 'transport', 4 => 'deploy', 5 => 'hold', 6 => 'espionage', 7 => 'colony', 8 => 'harvest', 9 => 'destroy', 10 => 'missile', 15 => 'transport');
$FleetStatus = array(0 => 'flight', 1 => 'holding', 2 => 'return');
if ($Owner == true) {
$FleetPrefix = 'own';
} else {
$FleetPrefix = '';
}
$RowsTPL = gettemplate('ubersicht/ubersicht_02');
$MissionType = $FleetRow['fleet_mission'];
$FleetContent = CreateFleetPopupedFleetLink($FleetRow, $lang['over']['1022'], $FleetPrefix . $FleetStyle[$MissionType]);
$FleetCapacity = CreateFleetPopupedMissionLink($FleetRow, $lang['type_mission'][$MissionType], $FleetPrefix . $FleetStyle[$MissionType]);
$StartPlanet = doquery("SELECT `name` FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_start_system'] . "' AND `planet` = '" . $FleetRow['fleet_start_planet'] . "' AND `planet_type` = '" . $FleetRow['fleet_start_type'] . "';", 'planets', true);
$StartType = $FleetRow['fleet_start_type'];
$TargetPlanet = doquery("SELECT `name` FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_end_system'] . "' AND `planet` = '" . $FleetRow['fleet_end_planet'] . "' AND `planet_type` = '" . $FleetRow['fleet_end_type'] . "';", 'planets', true);
$TargetType = $FleetRow['fleet_end_type'];
if ($Status != 2) {
if ($StartType == 1) {
$StartID = $lang['over']['1001'];
} elseif ($StartType == 3) {
$StartID = $lang['over']['1002'];
}
$StartID .= $StartPlanet['name'] . " ";
$StartID .= GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
if ($MissionType != 15) {
if ($TargetType == 1) {
$TargetID = $lang['over']['1003'];
} elseif ($TargetType == 2) {
$TargetID = $lang['over']['1004'];
} elseif ($TargetType == 3) {
$TargetID = $lang['over']['1005'];
}
} else {
$TargetID = $lang['over']['1006'];
}
$TargetID .= $TargetPlanet['name'] . " ";
$TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
} else {
if ($StartType == 1) {
$StartID = $lang['over']['1007'];
} elseif ($StartType == 3) {
$StartID = $lang['over']['1007'];
}
$StartID .= $StartPlanet['name'] . " ";
$StartID .= GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
if ($MissionType != 15) {
if ($TargetType == 1) {
$TargetID = $lang['over']['1009'];
} elseif ($TargetType == 2) {
$TargetID = $lang['over']['1010'];
} elseif ($TargetType == 3) {
$TargetID = $lang['over']['1011'];
}
} else {
$TargetID = $lang['over']['1012'];
}
$TargetID .= $TargetPlanet['name'] . " ";
$TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
}
if ($Owner == true) {
$EventString = $lang['over']['1013'];
$EventString .= $FleetContent;
} elseif ($Owner == false and $MissionType == 5) {
$EventString = $lang['ov_one_stranger'];
$EventString .= $FleetContent;
$EventString .= $lang['over']['1014'];
$EventString .= BuildHostileFleetPlayerLink($FleetRow);
} elseif ($Owner == false and $MissionType == 2) {
$EventString = $lang['ov_one_stranger'];
$EventString .= $FleetContent;
$EventString .= $lang['over']['1014'];
$EventString .= BuildHostileFleetPlayerLink($FleetRow);
} else {
$EventString = $lang['over']['1015'];
$EventString .= $FleetContent;
$EventString .= $lang['ov_hostile'];
$EventString .= BuildHostileFleetPlayerLink($FleetRow);
}
if ($Status == 0) {
$Time = $FleetRow['fleet_start_time'];
$Rest = $Time - time();
$EventString .= $lang['over']['1016'];
// ' venant '
$EventString .= $StartID;
$EventString .= $lang['over']['1017'];
// ' atteint '
$EventString .= $TargetID;
$EventString .= $lang['over']['1021'];
// '. Elle avait pour mission: '
} elseif ($Status == 1) {
$Time = $FleetRow['fleet_end_stay'];
$Rest = $Time - time();
$EventString .= $lang['over']['1016'];
// ' venant '
$EventString .= $StartID;
$EventString .= $lang['over']['1018'];
// ' explore '
$EventString .= $TargetID;
$EventString .= $lang['over']['1019'];
// '. Elle a pour mission: '
} elseif ($Status == 2) {
$Time = $FleetRow['fleet_end_time'];
$Rest = $Time - time();
$EventString .= $lang['over']['1020'];
// ' rentrant '
$EventString .= $TargetID;
$EventString .= $StartID;
$EventString .= $lang['over']['1021'];
// '. Elle avait pour mission: '
}
$EventString .= $FleetCapacity;
$bloc['fleet_status'] = $FleetStatus[$Status];
$bloc['fleet_prefix'] = $FleetPrefix;
$bloc['fleet_style'] = $FleetStyle[$MissionType];
$bloc['fleet_javai'] = InsertJavaScriptChronoApplet($Label, $Record, $Rest, true);
$bloc['fleet_order'] = $Label . $Record;
$bloc['fleet_time'] = date("H:i:s", $Time);
$bloc['fleet_descr'] = $EventString;
$bloc['fleet_javas'] = InsertJavaScriptChronoApplet($Label, $Record, $Rest, false);
return parsetemplate($RowsTPL, $bloc);
}
