function ReturnEvent()
 {
     $LNG = $this->GetUserLang($this->_fleet['fleet_owner']);
     $Message = sprintf($LNG['sys_tran_mess_owner'], $TargetName, GetStartAdressLink($this->_fleet, ''), pretty_number($this->_fleet['fleet_resource_metal']), $LNG['Metal'], pretty_number($this->_fleet['fleet_resource_crystal']), $LNG['Crystal'], pretty_number($this->_fleet['fleet_resource_deuterium']), $LNG['Deuterium']);
     SendSimpleMessage($this->_fleet['fleet_owner'], '', $this->_fleet['fleet_end_time'], 4, $LNG['sys_mess_tower'], $LNG['sys_mess_fleetback'], $Message);
     $this->RestoreFleet();
 }
 function ReturnEvent()
 {
     $LNG = $this->GetUserLang($this->_fleet['fleet_owner']);
     $Message = sprintf($LNG['sys_tran_mess_back'], $StartName, GetStartAdressLink($this->_fleet, ''));
     SendSimpleMessage($this->_fleet['fleet_owner'], '', $this->_fleet['fleet_end_time'], 5, $LNG['sys_mess_tower'], $LNG['sys_mess_fleetback'], $Message);
     $this->RestoreFleet();
 }
/**
 * MissionCaseStayAlly @todo description
 *
 * @global array $lang @see common.php
 * @param array $fleetRow @see common.php
 * @return bool true.
 */
function missionCaseStayAlly($fleetRow)
{
    global $lang;
    $readConnection = Nova::getSingleton('core/database_connection_pool')->getConnection('core_read');
    $startPlanet = $readConnection->select(array('name', 'id_owner'))->from($readConnection->getDeprecatedTable('planets'))->where('galaxy =?', $fleetRow['fleet_start_galaxy'])->where('system =?', $fleetRow['fleet_start_system'])->where('planet =?', $fleetRow['fleet_start_planet'])->query()->fetch();
    $endPlanet = $readConnection->select(array('name', 'id_owner'))->from($readConnection->getDeprecatedTable('planets'))->where('galaxy =?', $fleetRow['fleet_end_galaxy'])->where('system =?', $fleetRow['fleet_end_system'])->where('planet =?', $fleetRow['fleet_end_planet'])->query()->fetch();
    $fleetStartLink = GetStartAdressLink($fleetRow, '');
    $fleetEndLink = GetTargetAdressLink($fleetRow, '');
    if ($fleetRow['fleet_mess'] == 0) {
        if ($fleetRow['fleet_end_stay'] <= time()) {
            $readConnection->update($readConnection->getDeprecatedTable('fleets'), array('fleet_mess' => 1), array('fleet_id =?' => $fleetRow['fleet_id']));
        } else {
            if ($fleetRow['fleet_start_time'] <= time()) {
                $message = sprintf($lang['sys_tran_mess_owner'], $endPlanet['name'], $fleetEndLink, $fleetRow['fleet_resource_metal'], $lang['Metal'], $fleetRow['fleet_resource_crystal'], $lang['Crystal'], $fleetRow['fleet_resource_deuterium'], $lang['Deuterium']);
                SendSimpleMessage($startPlanet['id_owner'], '', $fleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $message);
                $message = sprintf($lang['sys_tran_mess_user'], $startPlanet['name'], $fleetStartLink, $endPlanet['name'], $fleetEndLink, $fleetRow['fleet_resource_metal'], $lang['Metal'], $fleetRow['fleet_resource_crystal'], $lang['Crystal'], $fleetRow['fleet_resource_deuterium'], $lang['Deuterium']);
                SendSimpleMessage($endPlanet['id_owner'], '', $fleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $message);
            }
        }
    } else {
        if ($fleetRow['fleet_end_time'] <= time()) {
            $message = sprintf($lang['sys_tran_mess_back'], $startPlanet['name'], $fleetStartLink);
            SendSimpleMessage($startPlanet['id_owner'], '', $fleetRow['fleet_end_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_fleetback'], $message);
            RestoreFleetToPlanet($fleetRow, true);
            $readConnection->delete($readConnection->getDeprecatedTable('fleets'), array('fleet_id =?' => $fleetRow['fleet_id']));
        }
    }
    return true;
}
 function ReturnEvent()
 {
     $LNG = $this->getLanguage(NULL, $this->_fleet['fleet_owner']);
     $Message = sprintf($LNG['sys_stat_mess'], GetStartAdressLink($this->_fleet, ''), pretty_number($this->_fleet['fleet_resource_metal']), $LNG['tech'][901], pretty_number($this->_fleet['fleet_resource_crystal']), $LNG['tech'][902], pretty_number($this->_fleet['fleet_resource_deuterium']), $LNG['tech'][903]);
     PlayerUtil::sendMessage($this->_fleet['fleet_owner'], 0, $LNG['sys_mess_tower'], 4, $LNG['sys_mess_fleetback'], $Message, $this->_fleet['fleet_end_time'], NULL, 1, $this->_fleet['fleet_universe']);
     $this->RestoreFleet();
 }
 function ReturnEvent()
 {
     $LNG = $this->getLanguage(NULL, $this->_fleet['fleet_owner']);
     $StartName = $GLOBALS['DATABASE']->getFirstCell("SELECT name FROM " . PLANETS . " WHERE id = " . $this->_fleet['fleet_start_id'] . ";");
     $Message = sprintf($LNG['sys_tran_mess_back'], $StartName, GetStartAdressLink($this->_fleet, ''));
     SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_end_time'], 5, $LNG['sys_mess_tower'], $LNG['sys_mess_fleetback'], $Message);
     $this->RestoreFleet();
 }
 function ReturnEvent()
 {
     $LNG = $this->getLanguage(NULL, $this->_fleet['fleet_owner']);
     $TargetUserID = $this->_fleet['fleet_target_owner'];
     $TargetMessage = sprintf($LNG['sys_stat_mess'], GetStartAdressLink($this->_fleet, ''), pretty_number($this->_fleet['fleet_resource_metal']), $LNG['tech'][901], pretty_number($this->_fleet['fleet_resource_crystal']), $LNG['tech'][902], pretty_number($this->_fleet['fleet_resource_deuterium']), $LNG['tech'][903]);
     SendSimpleMessage($TargetUserID, 0, $this->_fleet['fleet_end_time'], 5, $LNG['sys_mess_tower'], $LNG['sys_stat_mess_stay'], $TargetMessage);
     $this->RestoreFleet();
 }
Beispiel #7
0
 function ReturnEvent()
 {
     global $LANG;
     $LNG = $LANG->GetUserLang($this->_fleet['fleet_owner']);
     $TargetUserID = $this->_fleet['fleet_target_owner'];
     $TargetMessage = sprintf($LNG['sys_stat_mess'], GetStartAdressLink($this->_fleet, ''), pretty_number($this->_fleet['fleet_resource_metal']), $LNG['Metal'], pretty_number($this->_fleet['fleet_resource_crystal']), $LNG['Crystal'], pretty_number($this->_fleet['fleet_resource_deuterium']), $LNG['Deuterium']);
     SendSimpleMessage($TargetUserID, '', $this->_fleet['fleet_end_time'], 5, $LNG['sys_mess_tower'], $LNG['sys_stat_mess_stay'], $TargetMessage);
     $this->RestoreFleet();
 }
 function ReturnEvent()
 {
     $LNG = $this->getLanguage(NULL, $this->_fleet['fleet_owner']);
     $sql = 'SELECT name FROM %%PLANETS%% WHERE id = :planetId;';
     $planetName = Database::get()->selectSingle($sql, array(':planetId' => $this->_fleet['fleet_start_id']), 'name');
     $Message = sprintf($LNG['sys_tran_mess_back'], $planetName, GetStartAdressLink($this->_fleet, ''));
     PlayerUtil::sendMessage($this->_fleet['fleet_owner'], 0, $LNG['sys_mess_tower'], 4, $LNG['sys_mess_fleetback'], $Message, $this->_fleet['fleet_end_time'], NULL, 1, $this->_fleet['fleet_universe']);
     $this->RestoreFleet();
 }
/**
 * MissionCaseTransport.php
 *
 * @version 1
 * @copyright 2008 By Chlorel for XNova
 */
function MissionCaseTransport($FleetRow)
{
    global $lang;
    $QryStartPlanet = "SELECT * FROM {{table}} ";
    $QryStartPlanet .= "WHERE ";
    $QryStartPlanet .= "`galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND ";
    $QryStartPlanet .= "`system` = '" . $FleetRow['fleet_start_system'] . "' AND ";
    $QryStartPlanet .= "`planet` = '" . $FleetRow['fleet_start_planet'] . "' AND ";
    $QryStartPlanet .= "`planet_type` = '" . $FleetRow['fleet_start_type'] . "';";
    $StartPlanet = doquery($QryStartPlanet, 'planets', true);
    $StartName = $StartPlanet['name'];
    $StartOwner = $StartPlanet['id_owner'];
    $QryTargetPlanet = "SELECT * FROM {{table}} ";
    $QryTargetPlanet .= "WHERE ";
    $QryTargetPlanet .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
    $QryTargetPlanet .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
    $QryTargetPlanet .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "' AND ";
    $QryTargetPlanet .= "`planet_type` = '" . $FleetRow['fleet_end_type'] . "';";
    $TargetPlanet = doquery($QryTargetPlanet, 'planets', true);
    $TargetName = $TargetPlanet['name'];
    $TargetOwner = $TargetPlanet['id_owner'];
    if ($FleetRow['fleet_mess'] == 0) {
        if ($FleetRow['fleet_start_time'] < time()) {
            StoreGoodsToPlanet($FleetRow, false);
            $Message = sprintf($lang['sys_tran_mess_owner'], $TargetName, GetTargetAdressLink($FleetRow, ''), $FleetRow['fleet_resource_metal'], $lang['Metal'], $FleetRow['fleet_resource_crystal'], $lang['Crystal'], $FleetRow['fleet_resource_deuterium'], $lang['Deuterium'], $FleetRow['fleet_resource_appolonium'], $lang['Appolonium']);
            SendSimpleMessage($StartOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);
            if ($TargetOwner != $StartOwner) {
                $Message = sprintf($lang['sys_tran_mess_user'], $StartName, GetStartAdressLink($FleetRow, ''), $TargetName, GetTargetAdressLink($FleetRow, ''), $FleetRow['fleet_resource_metal'], $lang['Metal'], $FleetRow['fleet_resource_crystal'], $lang['Crystal'], $FleetRow['fleet_resource_deuterium'], $lang['Deuterium'], $FleetRow['fleet_resource_appolonium'], $lang['Appolonium']);
                SendSimpleMessage($TargetOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);
            }
            $QryUpdateFleet = "UPDATE {{table}} SET ";
            $QryUpdateFleet .= "`fleet_resource_metal` = '0' , ";
            $QryUpdateFleet .= "`fleet_resource_crystal` = '0' , ";
            $QryUpdateFleet .= "`fleet_resource_deuterium` = '0' , ";
            $QryUpdateFleet .= "`fleet_resource_appolonium` = '0' , ";
            $QryUpdateFleet .= "`fleet_mess` = '1' ";
            $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow['fleet_id'] . "' ";
            $QryUpdateFleet .= "LIMIT 1 ;";
            doquery($QryUpdateFleet, 'fleets');
        }
    } else {
        if ($FleetRow['fleet_end_time'] < time()) {
            $Message = sprintf($lang['sys_tran_mess_back'], $StartName, GetStartAdressLink($FleetRow, ''));
            SendSimpleMessage($StartOwner, '', $FleetRow['fleet_end_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_fleetback'], $Message);
            RestoreFleetToPlanet($FleetRow, true);
            //Piratenangriff nach Zufallsprinzip
            $zufall = 0;
            $zufall = rand(1, 10);
            if ($zufall == 7) {
                Piratenangriff($FleetRow);
                $zufall = 0;
            }
            // Ende Piratenangriff
            doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
        }
    }
}
Beispiel #10
0
function MissionCaseStayAlly($FleetRow)
{
    global $lang;
    $QryStartPlanet = "SELECT name, id_owner FROM {{table}} ";
    $QryStartPlanet .= "WHERE ";
    $QryStartPlanet .= "`galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND ";
    $QryStartPlanet .= "`system` = '" . $FleetRow['fleet_start_system'] . "' AND ";
    $QryStartPlanet .= "`planet` = '" . $FleetRow['fleet_start_planet'] . "';";
    $StartPlanet = doquery($QryStartPlanet, 'planets', true);
    $StartName = $StartPlanet['name'];
    $StartOwner = $StartPlanet['id_owner'];
    $QryTargetPlanet = "SELECT name, id_owner FROM {{table}} ";
    $QryTargetPlanet .= "WHERE ";
    $QryTargetPlanet .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
    $QryTargetPlanet .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
    $QryTargetPlanet .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "';";
    $TargetPlanet = doquery($QryTargetPlanet, 'planets', true);
    $TargetName = $TargetPlanet['name'];
    $TargetOwner = $TargetPlanet['id_owner'];
    switch ($FleetRow['fleet_mess']) {
        case '0':
            if ($FleetRow['fleet_start_time'] <= time()) {
                $Message = sprintf($lang['sys_tran_mess_owner'], $TargetName, GetTargetAdressLink($FleetRow, ''), $FleetRow['fleet_resource_metal'], $lang['Metal'], $FleetRow['fleet_resource_crystal'], $lang['Crystal'], $FleetRow['fleet_resource_deuterium'], $lang['Deuterium']);
                SendSimpleMessage($StartOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);
                $Message = sprintf($lang['sys_tran_mess_user'], $StartName, GetStartAdressLink($FleetRow, ''), $TargetName, GetTargetAdressLink($FleetRow, ''), $FleetRow['fleet_resource_metal'], $lang['Metal'], $FleetRow['fleet_resource_crystal'], $lang['Crystal'], $FleetRow['fleet_resource_deuterium'], $lang['Deuterium']);
                SendSimpleMessage($TargetOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);
                $QryUpdateFleet = "UPDATE {{table}} SET ";
                $QryUpdateFleet .= "`fleet_mess` = 1 ";
                $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow['fleet_id'] . "' ";
                $QryUpdateFleet .= "LIMIT 1 ;";
                doquery($QryUpdateFleet, 'fleets');
            }
            break;
        case '1':
            if ($FleetRow['fleet_end_stay'] <= time()) {
                $QryUpdateFleet = "UPDATE {{table}} SET ";
                $QryUpdateFleet .= "`fleet_mess` = 2 ";
                $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow['fleet_id'] . "' ";
                $QryUpdateFleet .= "LIMIT 1 ;";
                doquery($QryUpdateFleet, 'fleets');
            }
            break;
        default:
            if ($FleetRow['fleet_end_time'] < time()) {
                $Message = sprintf($lang['sys_tran_mess_back'], $StartName, GetStartAdressLink($FleetRow, ''));
                SendSimpleMessage($StartOwner, '', $FleetRow['fleet_end_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_fleetback'], $Message);
                RestoreFleetToPlanet($FleetRow, true);
                doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
            }
            break;
    }
}
Beispiel #11
0
/**
 * MissionCaseSave.php
 *
 * @version 1 By Chlorel for XNova
 */
function MissionCaseSave($FleetRow)
{
    global $lang;
    $QryStartPlanet = "SELECT * FROM {{table}} ";
    $QryStartPlanet .= "WHERE ";
    $QryStartPlanet .= "`galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND ";
    $QryStartPlanet .= "`system` = '" . $FleetRow['fleet_start_system'] . "' AND ";
    $QryStartPlanet .= "`planet` = '" . $FleetRow['fleet_start_planet'] . "' AND ";
    $QryStartPlanet .= "`planet_type` = '" . $FleetRow['fleet_start_type'] . "';";
    $StartPlanet = doquery($QryStartPlanet, 'planets', true);
    $StartName = $StartPlanet['name'];
    $StartOwner = $StartPlanet['id_owner'];
    $QryTargetPlanet = "SELECT * FROM {{table}} ";
    $QryTargetPlanet .= "WHERE ";
    $QryTargetPlanet .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
    $QryTargetPlanet .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
    $QryTargetPlanet .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "' AND ";
    $QryTargetPlanet .= "`planet_type` = '" . $FleetRow['fleet_end_type'] . "';";
    $TargetPlanet = doquery($QryTargetPlanet, 'planets', true);
    $TargetName = $TargetPlanet['name'];
    $TargetOwner = $TargetPlanet['id_owner'];
    if ($FleetRow['fleet_mess'] == 0) {
        if ($FleetRow['fleet_start_time'] < time()) {
            $QryUpdateFleet = "UPDATE {{table}} SET ";
            $QryUpdateFleet .= "`fleet_mess` = '1' ";
            $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow['fleet_id'] . "' ";
            $QryUpdateFleet .= "LIMIT 1 ;";
            doquery($QryUpdateFleet, 'fleets');
        }
    } else {
        if ($FleetRow['fleet_end_time'] < time()) {
            $Message = sprintf($lang['sys_save_mess_back'], $StartName, GetStartAdressLink($FleetRow, ''));
            SendSimpleMessage($StartOwner, '', $FleetRow['fleet_end_time'], 4, $lang['sys_mess_save'], $lang['sys_mess_fleetback'], $Message);
            RestoreFleetToPlanet($FleetRow, true);
            doquery("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
        }
    }
}
 public function GetEventString($FleetRow, $Status, $Owner, $Label, $Record)
 {
     global $LNG;
     $FleetStyle = array(1 => 'attack', 2 => 'federation', 3 => 'transport', 4 => 'deploy', 5 => 'hold', 6 => 'espionage', 7 => 'colony', 8 => 'harvest', 9 => 'destroy', 10 => 'missile', 15 => 'transport');
     $Names = $this->GetNames($FleetRow);
     $FleetPrefix = $Owner == true ? 'own' : '';
     $MissionType = $FleetRow['fleet_mission'];
     $FleetContent = $this->CreateFleetPopupedFleetLink($FleetRow, ($MissionType == 1 || $MissionType == 2) && $FleetRow['fleet_owner'] != $_SESSION['id'] && $Status == 0 && $Owner == true ? $LNG['cff_acs_fleet'] : $LNG['ov_fleet'], $FleetPrefix . $FleetStyle[$MissionType], $Names);
     $FleetCapacity = $this->CreateFleetPopupedMissionLink($FleetRow, $LNG['type_mission'][$MissionType], $FleetPrefix . $FleetStyle[$MissionType]);
     $StartType = $FleetRow['fleet_start_type'];
     $TargetType = $FleetRow['fleet_end_type'];
     $FleetGroup = $FleetRow['fleet_group'];
     $FleetStatus = array(0 => 'flight', 1 => 'return', 2 => 'holding');
     if (($MissionType == 1 || $MissionType == 2) && $FleetRow['fleet_owner'] != $_SESSION['id'] && $Status == 0 && $Owner == true) {
         $StartID = $LNG['cff_of'] . ' ' . $Names['own_username'] . ' ';
         $StartID .= $LNG['cff_goes'];
         $StartID .= $Names['own_planetname'] . " " . GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
         if ($TargetType == 1) {
             $TargetID = $LNG['cff_the_planet'];
         } elseif ($TargetType == 2) {
             $TargetID = $LNG['cff_debris_field'];
         } elseif ($TargetType == 3) {
             $TargetID = $LNG['cff_to_the_moon'];
         }
         $TargetID .= $Names['target_planetname'] . " ";
         $TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
     } elseif ($Status != 2) {
         if ($StartType == 1) {
             $StartID = $LNG['cff_from_the_planet'];
         } elseif ($StartType == 3) {
             $StartID = $LNG['cff_from_the_moon'];
         }
         $StartID .= $Names['own_planetname'] . " " . GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
         if ($MissionType != 15) {
             if ($TargetType == 1) {
                 $TargetID = $LNG['cff_the_planet'];
             } elseif ($TargetType == 2) {
                 $TargetID = $LNG['cff_debris_field'];
             } elseif ($TargetType == 3) {
                 $TargetID = $LNG['cff_to_the_moon'];
             }
         } else {
             $TargetID = $LNG['cff_the_position'];
         }
         $TargetID .= $Names['target_planetname'] . " ";
         $TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
     } else {
         if ($StartType == 1) {
             $StartID = $LNG['cff_to_the_planet'];
         } elseif ($StartType == 3) {
             $StartID = $LNG['cff_the_moon'];
         }
         $StartID .= $Names['own_planetname'] . ' ' . GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
         if ($MissionType != 15) {
             if ($TargetType == 1) {
                 $TargetID = $LNG['cff_from_planet'];
             } elseif ($TargetType == 2) {
                 $TargetID = $LNG['cff_from_debris_field'];
             } elseif ($TargetType == 3) {
                 $TargetID = $LNG['cff_from_the_moon'];
             }
         } else {
             $TargetID = $LNG['cff_from_position'];
         }
         $TargetID .= $Names['target_planetname'] . ' ' . GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
     }
     if ($MissionType == 10) {
         $EventString = $LNG['cff_missile_attack'] . " (" . str_replace("503,", "", $FleetRow["fleet_array"]) . ")";
         $Time = $FleetRow['fleet_start_time'];
         $Rest = $Time - TIMESTAMP;
         $EventString .= $LNG['cff_from'];
         $EventString .= $StartID;
         $EventString .= $LNG['cff_to'];
         $EventString .= $TargetID;
         $EventString .= ".";
     } else {
         if ($Owner == true) {
             if (($MissionType == 1 || $MissionType == 2) && $Status == 0 && $FleetRow['fleet_owner'] != $_SESSION['id']) {
                 $EventString = $LNG['cff_a'];
             } else {
                 $EventString = $LNG['cff_one_of_your'];
             }
             $EventString .= $FleetContent;
         } else {
             $EventString = $LNG['cff_a'];
             $EventString .= $FleetContent;
             $EventString .= $LNG['cff_of'];
             $EventString .= $this->BuildHostileFleetPlayerLink($FleetRow, $Names);
         }
         if ($Status == 0) {
             $Time = $FleetRow['fleet_start_time'];
             $Rest = $Time - TIMESTAMP;
             $EventString .= $LNG['cff_goes'];
             $EventString .= $StartID;
             $EventString .= $LNG['cff_toward'];
             $EventString .= $TargetID;
             $EventString .= $LNG['cff_with_the_mission_of'];
         } elseif ($Status == 1) {
             $Time = $FleetRow['fleet_end_time'];
             $Rest = $Time - TIMESTAMP;
             $EventString .= $LNG['cff_comming_back'];
             $EventString .= $TargetID;
             $EventString .= $LNG['cff_back_to_the_planet'];
             $EventString .= $StartID;
             $EventString .= $LNG['cff_with_the_mission_of'];
         } elseif ($Status == 2) {
             $Time = $FleetRow['fleet_end_stay'];
             $Rest = $Time - TIMESTAMP;
             $EventString .= $LNG['cff_goes'];
             $EventString .= $StartID;
             $EventString .= $LNG['cff_to_explore'];
             $EventString .= $TargetID;
             $EventString .= $LNG['cff_with_the_mission_of'];
         }
         $EventString .= $FleetCapacity;
         $EventString = '<span class="' . $FleetStatus[$Status] . ' ' . $FleetPrefix . $FleetStyle[$FleetRow['fleet_mission']] . '">' . $EventString . '</span>';
     }
     return array($Rest, $EventString, $Time);
 }
 function ReturnEvent()
 {
     global $LANG;
     $LNG = $this->getLanguage(NULL, $this->_fleet['fleet_owner']);
     $Message = sprintf($LNG['sys_tran_mess_owner'], 'Asteroid', GetStartAdressLink($this->_fleet, ''), pretty_number($this->_fleet['fleet_resource_metal']), $LNG['Metal'], pretty_number($this->_fleet['fleet_resource_crystal']), $LNG['Crystal'], pretty_number($this->_fleet['fleet_resource_deuterium']), $LNG['Deuterium']);
     SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_end_time'], 5, $LNG['sys_mess_tower'], $LNG['sys_mess_fleetback'], $Message);
     $this->RestoreFleet();
 }
/**
 * 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);
}
 public function GetEventString($FleetRow, $Status, $Owner, $Label, $Record)
 {
     global $LNG;
     $FleetStyle = array(1 => 'attack', 2 => 'federation', 3 => 'transport', 4 => 'deploy', 5 => 'hold', 6 => 'espionage', 7 => 'colony', 8 => 'harvest', 9 => 'destroy', 10 => 'missile', 15 => 'transport');
     $GoodMissions = array(3, 5);
     $MissionType = $FleetRow['fleet_mission'];
     $Names = $this->GetNames($FleetRow);
     $FleetPrefix = $Owner == true ? 'own' : '';
     $FleetType = $FleetPrefix . $FleetStyle[$MissionType];
     $FleetContent = $this->CreateFleetPopupedFleetLink($FleetRow, ($MissionType == 1 || $MissionType == 2) && $FleetRow['fleet_owner'] != $_SESSION['id'] && $Status == 0 && $Owner == true ? $LNG['cff_acs_fleet'] : $LNG['ov_fleet'], $FleetPrefix . $FleetStyle[$MissionType]);
     $FleetCapacity = $this->CreateFleetPopupedMissionLink($FleetRow, $LNG['type_mission'][$MissionType], $FleetPrefix . $FleetStyle[$MissionType]);
     $FleetStatus = array(0 => 'flight', 1 => 'return', 2 => 'holding');
     $StartType = $FleetRow['fleet_start_type'] == 1 ? $LNG['fcm_planet'] : $LNG['fcm_moon'];
     $TargetType = $FleetRow['fleet_end_type'] == 1 ? $LNG['fcm_planet'] : $LNG['fcm_moon'];
     if ($MissionType == 8) {
         if ($Status == 0) {
             $EventString = sprintf($LNG['cff_mission_own_recy_0'], $FleetContent, $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), GetTargetAdressLink($FleetRow, $FleetType), $FleetCapacity);
         } else {
             $EventString = sprintf($LNG['cff_mission_own_recy_1'], $FleetContent, GetTargetAdressLink($FleetRow, $FleetType), $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $FleetCapacity);
         }
     } elseif ($MissionType == 10) {
         if ($Owner) {
             $EventString = sprintf($LNG['cff_mission_own_mip'], $FleetRow['fleet_amount'], $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $TargetType, $Names['target_planetname'], GetTargetAdressLink($FleetRow, $FleetType));
         } else {
             $EventString = sprintf($LNG['cff_mission_target_mip'], $FleetRow['fleet_amount'], $this->BuildHostileFleetPlayerLink($FleetRow, $Names), $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $TargetType, $Names['target_planetname'], GetTargetAdressLink($FleetRow, $FleetType));
         }
     } elseif ($MissionType == 11 || $MissionType == 15) {
         if ($Status == 0) {
             $EventString = sprintf($LNG['cff_mission_own_expo_0'], $FleetContent, $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), GetTargetAdressLink($FleetRow, $FleetType), $FleetCapacity);
         } elseif ($Status == 2) {
             $EventString = sprintf($LNG['cff_mission_own_expo_2'], $FleetContent, $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), GetTargetAdressLink($FleetRow, $FleetType), $FleetCapacity);
         } else {
             $EventString = sprintf($LNG['cff_mission_own_expo_1'], $FleetContent, GetTargetAdressLink($FleetRow, $FleetType), $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $FleetCapacity);
         }
     } else {
         if ($Owner == true) {
             if ($Status == 0) {
                 if (($MissionType == 1 || $MissionType == 2) && $Status == 0 && $FleetRow['fleet_owner'] != $_SESSION['id']) {
                     $Message = $LNG['cff_mission_acs'];
                 } else {
                     $Message = $LNG['cff_mission_own_0'];
                 }
                 $EventString = sprintf($Message, $FleetContent, $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $TargetType, $Names['target_planetname'], GetTargetAdressLink($FleetRow, $FleetType), $FleetCapacity);
             } elseif ($Status == 1) {
                 $EventString = sprintf($LNG['cff_mission_own_1'], $FleetContent, $TargetType, $Names['target_planetname'], GetTargetAdressLink($FleetRow, $FleetType), $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $FleetCapacity);
             } else {
                 $EventString = sprintf($LNG['cff_mission_own_2'], $FleetContent, $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $TargetType, $Names['target_planetname'], GetTargetAdressLink($FleetRow, $FleetType), $FleetCapacity);
             }
         } else {
             if ($Status == 2) {
                 $Message = $LNG['cff_mission_target_stay'];
             } elseif (in_array($MissionType, $GoodMissions)) {
                 $Message = $LNG['cff_mission_target_good'];
             } else {
                 $Message = $LNG['cff_mission_target_bad'];
             }
             $EventString = sprintf($Message, $FleetContent, $this->BuildHostileFleetPlayerLink($FleetRow, $Names), $StartType, $Names['own_planetname'], GetStartAdressLink($FleetRow, $FleetType), $TargetType, $Names['target_planetname'], GetTargetAdressLink($FleetRow, $FleetType), $FleetCapacity);
         }
     }
     $EventString = '<span class="' . $FleetStatus[$Status] . ' ' . $FleetType . '">' . $EventString . '</span>';
     if ($Status == 0) {
         $Time = $FleetRow['fleet_start_time'];
     } elseif ($Status == 1) {
         $Time = $FleetRow['fleet_end_time'];
     } elseif ($Status == 2) {
         $Time = $FleetRow['fleet_end_stay'];
     }
     $Rest = $Time - TIMESTAMP;
     return array($Rest, $EventString, $Time);
 }
    function TargetEvent()
    {
        global $resource, $reslist;
        $db = Database::get();
        $sqlFields = array();
        $elementIDs = array_merge($reslist['defense'], $reslist['missile']);
        foreach ($elementIDs as $elementID) {
            $sqlFields[] = '%%PLANETS%%.`' . $resource[$elementID] . '`';
        }
        $sql = 'SELECT lang, shield_tech,
		%%PLANETS%%.id, name, id_owner, ' . implode(', ', $sqlFields) . '
		FROM %%PLANETS%%
		INNER JOIN %%USERS%% ON id_owner = %%PLANETS%%.id
		WHERE %%PLANETS%%.id = :planetId;';
        $targetData = $db->selectSingle($sql, array(':planetId' => $this->_fleet['fleet_end_id']));
        if ($this->_fleet['fleet_end_type'] == 3) {
            $sql = 'SELECT ' . $resource[502] . ' FROM %%PLANETS%% WHERE id_luna = :moonId;';
            $targetData[$resource[502]] = $db->selectSingle($sql, array(':moonId' => $this->_fleet['fleet_end_id']), $resource[502]);
        }
        $sql = 'SELECT lang, military_tech FROM %%USERS%% WHERE id = :userId;';
        $senderData = $db->selectSingle($sql, array(':userId' => $this->_fleet['fleet_owner']));
        if (!in_array($this->_fleet['fleet_target_obj'], $reslist['defense']) || !in_array($this->_fleet['fleet_target_obj'], $reslist['missile']) || $this->_fleet['fleet_target_obj'] == 502 || $this->_fleet['fleet_target_obj'] == 0) {
            $primaryTarget = 401;
        } else {
            $primaryTarget = $this->_fleet['fleet_target_obj'];
        }
        $targetDefensive = array();
        foreach ($elementIDs as $elementID) {
            $targetDefensive[$elementID] = $targetData[$resource[$elementID]];
        }
        unset($targetDefensive[502]);
        $LNG = $this->getLanguage(Config::get($this->_fleet['fleet_universe'])->lang, array('L18N', 'FLEET', 'TECH'));
        if ($targetData[$resource[502]] >= $this->_fleet['fleet_amount']) {
            $message = $LNG['sys_irak_no_att'];
            $where = $this->_fleet['fleet_end_type'] == 3 ? 'id_luna' : 'id';
            $sql = 'UPDATE %%PLANETS%% SET ' . $resource[502] . ' = ' . $resource[502] . ' - :amount WHERE ' . $where . ' = :planetId;';
            $db->update($sql, array(':amount' => $this->_fleet['fleet_amount'], ':planetId' => $targetData['id']));
        } else {
            if ($targetData[$resource[502]] > 0) {
                $where = $this->_fleet['fleet_end_type'] == 3 ? 'id_luna' : 'id';
                $sql = 'UPDATE %%PLANETS%% SET ' . $resource[502] . ' = :amount WHERE ' . $where . ' = :planetId;';
                $db->update($sql, array(':amount' => 0, ':planetId' => $targetData['id']));
            }
            $targetDefensive = array_filter($targetDefensive);
            if (!empty($targetDefensive)) {
                require_once 'includes/classes/missions/functions/calculateMIPAttack.php';
                $result = calculateMIPAttack($targetData["shield_tech"], $senderData["military_tech"], $this->_fleet['fleet_amount'], $targetDefensive, $primaryTarget, $targetData[$resource[502]]);
                $result = array_filter($result);
                $message = sprintf($LNG['sys_irak_def'], $targetData[$resource[502]]) . '<br><br>';
                ksort($result, SORT_NUMERIC);
                foreach ($result as $Element => $destroy) {
                    $message .= sprintf('%s (- %d)<br>', $LNG['tech'][$Element], $destroy);
                    $sql = 'UPDATE %%PLANETS%% SET ' . $resource[$Element] . ' = ' . $resource[$Element] . ' - :amount WHERE id = :planetId;';
                    $db->update($sql, array(':planetId' => $targetData['id'], ':amount' => $destroy));
                }
            } else {
                $message = $LNG['sys_irak_no_def'];
            }
        }
        $sql = 'SELECT name FROM %%PLANETS%% WHERE id = :planetId;';
        $planetName = Database::get()->selectSingle($sql, array(':planetId' => $this->_fleet['fleet_start_id']), 'name');
        $ownerLink = $planetName . " " . GetStartAdressLink($this->_fleet);
        $targetLink = $targetData['name'] . " " . GetTargetAdressLink($this->_fleet);
        $message = sprintf($LNG['sys_irak_mess'], $this->_fleet['fleet_amount'], $ownerLink, $targetLink) . $message;
        PlayerUtil::sendMessage($this->_fleet['fleet_owner'], 0, $LNG['sys_mess_tower'], 3, $LNG['sys_irak_subject'], $message, $this->_fleet['fleet_start_time'], NULL, 1, $this->_fleet['fleet_universe']);
        PlayerUtil::sendMessage($this->_fleet['fleet_target_owner'], 0, $LNG['sys_mess_tower'], 3, $LNG['sys_irak_subject'], $message, $this->_fleet['fleet_start_time'], NULL, 1, $this->_fleet['fleet_universe']);
        $this->KillFleet();
    }
 function ReturnEvent()
 {
     $LNG = $this->getLanguage(NULL, $this->_fleet['fleet_owner']);
     $TargetName = $GLOBALS['DATABASE']->getFirstCell("SELECT name FROM " . PLANETS . " WHERE id = " . $this->_fleet['fleet_start_id'] . ";");
     $Message = sprintf($LNG['sys_tran_mess_owner'], $TargetName, GetStartAdressLink($this->_fleet, ''), pretty_number($this->_fleet['fleet_resource_metal']), $LNG['tech'][901], pretty_number($this->_fleet['fleet_resource_crystal']), $LNG['tech'][902], pretty_number($this->_fleet['fleet_resource_deuterium']), $LNG['tech'][903]);
     SendSimpleMessage($this->_fleet['fleet_owner'], 0, $this->_fleet['fleet_end_time'], 5, $LNG['sys_mess_tower'], $LNG['sys_mess_fleetback'], $Message);
     $this->RestoreFleet();
 }
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);
}
 private function MissionCaseStayAlly($FleetRow)
 {
     global $db, $lang, $svn_root, $users;
     $QryStartPlanet = "SELECT * FROM {{table}} ";
     $QryStartPlanet .= "WHERE ";
     $QryStartPlanet .= "`galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND ";
     $QryStartPlanet .= "`system` = '" . $FleetRow['fleet_start_system'] . "' AND ";
     $QryStartPlanet .= "`planet` = '" . $FleetRow['fleet_start_planet'] . "';";
     $StartPlanet = $db->query($QryStartPlanet, 'planets', true);
     $StartName = $StartPlanet['name'];
     $StartOwner = $StartPlanet['id_owner'];
     $QryTargetPlanet = "SELECT * FROM {{table}} ";
     $QryTargetPlanet .= "WHERE ";
     $QryTargetPlanet .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
     $QryTargetPlanet .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
     $QryTargetPlanet .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "';";
     $TargetPlanet = $db->query($QryTargetPlanet, 'planets', true);
     $TargetName = $TargetPlanet['name'];
     $TargetOwner = $TargetPlanet['id_owner'];
     if ($FleetRow['fleet_mess'] == 0) {
         if ($FleetRow['fleet_start_time'] < time()) {
             $Message = sprintf($lang['sys_tran_mess_owner'], $TargetName, GetTargetAdressLink($FleetRow, ''), $FleetRow['fleet_resource_metal'], $lang['Metal'], $FleetRow['fleet_resource_crystal'], $lang['Crystal'], $FleetRow['fleet_resource_deuterium'], $lang['Deuterium']);
             $users->SendSimpleMessage($StartOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);
             $Message = sprintf($lang['sys_tran_mess_user'], $StartName, GetStartAdressLink($FleetRow, ''), $TargetName, GetTargetAdressLink($FleetRow, ''), $FleetRow['fleet_resource_metal'], $lang['Metal'], $FleetRow['fleet_resource_crystal'], $lang['Crystal'], $FleetRow['fleet_resource_deuterium'], $lang['Deuterium']);
             $users->SendSimpleMessage($TargetOwner, '', $FleetRow['fleet_start_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_transport'], $Message);
             $QryUpdateFleet = "UPDATE {{table}} SET ";
             $QryUpdateFleet .= "`fleet_mess` = 2 ";
             $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow['fleet_id'] . "' ";
             $QryUpdateFleet .= "LIMIT 1 ;";
             $db->query($QryUpdateFleet, 'fleets');
         } elseif ($FleetRow['fleet_end_stay'] < time()) {
             $QryUpdateFleet = "UPDATE {{table}} SET ";
             $QryUpdateFleet .= "`fleet_mess` = 1 ";
             $QryUpdateFleet .= "WHERE `fleet_id` = '" . $FleetRow['fleet_id'] . "' ";
             $QryUpdateFleet .= "LIMIT 1 ;";
             $db->query($QryUpdateFleet, 'fleets');
         }
     } else {
         if ($FleetRow['fleet_end_time'] < time()) {
             $Message = sprintf($lang['sys_tran_mess_back'], $StartName, GetStartAdressLink($FleetRow, ''));
             $users->SendSimpleMessage($StartOwner, '', $FleetRow['fleet_end_time'], 5, $lang['sys_mess_tower'], $lang['sys_mess_fleetback'], $Message);
             $this->RestoreFleetToPlanet($FleetRow, true);
             $db->query("DELETE FROM {{table}} WHERE fleet_id=" . $FleetRow["fleet_id"], 'fleets');
         }
     }
 }
 public function getEventData($fleetRow, $Status)
 {
     global $LNG;
     $Owner = $fleetRow['fleet_owner'] == $this->UserID;
     $FleetStyle = array(1 => 'attack', 2 => 'federation', 3 => 'transport', 4 => 'deploy', 5 => 'hold', 6 => 'espionage', 7 => 'colony', 8 => 'harvest', 9 => 'destroy', 10 => 'missile', 11 => 'transport', 15 => 'transport', 20 => 'capture', 12 => 'harvest');
     $GoodMissions = array(3, 5);
     $MissionType = $fleetRow['fleet_mission'];
     $FleetPrefix = $Owner == true ? 'own' : '';
     $FleetType = $FleetPrefix . $FleetStyle[$MissionType];
     $FleetName = !$Owner && ($MissionType == 1 || $MissionType == 2) && $Status == FLEET_OUTWARD && $fleetRow['fleet_target_owner'] != $this->UserID ? $LNG['cff_acs_fleet'] : $LNG['ov_fleet'];
     $FleetContent = $this->CreateFleetPopupedFleetLink($fleetRow, $FleetName, $FleetPrefix . $FleetStyle[$MissionType]);
     $FleetCapacity = $this->CreateFleetPopupedMissionLink($fleetRow, $LNG['type_mission'][$MissionType], $FleetPrefix . $FleetStyle[$MissionType]);
     $FleetStatus = array(0 => 'flight', 1 => 'return', 2 => 'holding');
     $StartType = $LNG['type_planet'][$fleetRow['fleet_start_type']];
     $TargetType = $LNG['type_planet'][$fleetRow['fleet_end_type']];
     if ($MissionType == 8) {
         if ($Status == FLEET_OUTWARD) {
             $EventString = sprintf($LNG['cff_mission_own_recy_0'], $FleetContent, $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), GetTargetAdressLink($fleetRow, $FleetType), $FleetCapacity);
         } else {
             $EventString = sprintf($LNG['cff_mission_own_recy_1'], $FleetContent, GetTargetAdressLink($fleetRow, $FleetType), $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $FleetCapacity);
         }
     } elseif ($MissionType == 10) {
         if ($Owner) {
             $EventString = sprintf($LNG['cff_mission_own_mip'], $fleetRow['fleet_amount'], $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $TargetType, $fleetRow['target_planetname'], GetTargetAdressLink($fleetRow, $FleetType));
         } else {
             $EventString = sprintf($LNG['cff_mission_target_mip'], $fleetRow['fleet_amount'], $this->BuildHostileFleetPlayerLink($fleetRow, $fleetRow), $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $TargetType, $fleetRow['target_planetname'], GetTargetAdressLink($fleetRow, $FleetType));
         }
     } elseif ($MissionType == 11 || $MissionType == 15) {
         if ($Status == FLEET_OUTWARD) {
             $EventString = sprintf($LNG['cff_mission_own_expo_0'], $FleetContent, $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), GetTargetAdressLink($fleetRow, $FleetType), $FleetCapacity);
         } elseif ($Status == FLEET_HOLD) {
             $EventString = sprintf($LNG['cff_mission_own_expo_2'], $FleetContent, $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), GetTargetAdressLink($fleetRow, $FleetType), $FleetCapacity);
         } else {
             $EventString = sprintf($LNG['cff_mission_own_expo_1'], $FleetContent, GetTargetAdressLink($fleetRow, $FleetType), $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $FleetCapacity);
         }
     } else {
         if ($Owner == true) {
             if ($Status == FLEET_OUTWARD) {
                 if (!$Owner && ($MissionType == 1 || $MissionType == 2)) {
                     $Message = $LNG['cff_mission_acs'];
                 } else {
                     $Message = $LNG['cff_mission_own_0'];
                 }
                 $EventString = sprintf($Message, $FleetContent, $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $TargetType, $fleetRow['target_planetname'], GetTargetAdressLink($fleetRow, $FleetType), $FleetCapacity);
             } elseif ($Status == FLEET_RETURN) {
                 $EventString = sprintf($LNG['cff_mission_own_1'], $FleetContent, $TargetType, $fleetRow['target_planetname'], GetTargetAdressLink($fleetRow, $FleetType), $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $FleetCapacity);
             } else {
                 $EventString = sprintf($LNG['cff_mission_own_2'], $FleetContent, $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $TargetType, $fleetRow['target_planetname'], GetTargetAdressLink($fleetRow, $FleetType), $FleetCapacity);
             }
         } else {
             if ($Status == FLEET_HOLD) {
                 $Message = $LNG['cff_mission_target_stay'];
             } elseif (in_array($MissionType, $GoodMissions)) {
                 $Message = $LNG['cff_mission_target_good'];
             } else {
                 $Message = $LNG['cff_mission_target_bad'];
             }
             $EventString = sprintf($Message, $FleetContent, $this->BuildHostileFleetPlayerLink($fleetRow, $fleetRow), $StartType, $fleetRow['own_planetname'], GetStartAdressLink($fleetRow, $FleetType), $TargetType, $fleetRow['target_planetname'], GetTargetAdressLink($fleetRow, $FleetType), $FleetCapacity);
         }
     }
     $EventString = '<span class="' . $FleetStatus[$Status] . ' ' . $FleetType . '">' . $EventString . '</span>';
     if ($Status == FLEET_OUTWARD) {
         $Time = $fleetRow['fleet_start_time'];
     } elseif ($Status == FLEET_RETURN) {
         $Time = $fleetRow['fleet_end_time'];
     } elseif ($Status == FLEET_HOLD) {
         $Time = $fleetRow['fleet_end_stay'];
     }
     $Rest = $Time - TIMESTAMP;
     $Rest1 = date('H:i:s', TIMESTAMP + $Rest);
     return array($Rest, $EventString, $Time, $Rest1);
 }
 public 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/overview_fleet_event');
     $MissionType = $FleetRow['fleet_mission'];
     $FleetContent = $this->CreateFleetPopupedFleetLink($FleetRow, "flotas", $FleetPrefix . $FleetStyle[$MissionType]);
     $FleetCapacity = $this->CreateFleetPopupedMissionLink($FleetRow, $lang['type_mission'][$MissionType], $FleetPrefix . $FleetStyle[$MissionType]);
     $StartPlanet = doquery("SELECT `name` FROM {{table}} WHERE `galaxy` = '" . intval($FleetRow['fleet_start_galaxy']) . "' AND `system` = '" . intval($FleetRow['fleet_start_system']) . "' AND `planet` = '" . intval($FleetRow['fleet_start_planet']) . "' AND `planet_type` = '" . intval($FleetRow['fleet_start_type']) . "';", 'planets', true);
     $StartType = $FleetRow['fleet_start_type'];
     $TargetPlanet = doquery("SELECT `name` FROM {{table}} WHERE `galaxy` = '" . intval($FleetRow['fleet_end_galaxy']) . "' AND `system` = '" . intval($FleetRow['fleet_end_system']) . "' AND `planet` = '" . intval($FleetRow['fleet_end_planet']) . "' AND `planet_type` = '" . intval($FleetRow['fleet_end_type']) . "';", 'planets', true);
     $TargetType = $FleetRow['fleet_end_type'];
     if ($Status != 2) {
         if ($StartType == 1) {
             $StartID = $lang['cff_from_the_planet'];
         } elseif ($StartType == 3) {
             $StartID = $lang['cff_from_the_moon'];
         }
         $StartID .= $StartPlanet['name'] . " ";
         $StartID .= GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
         if ($MissionType != 15) {
             if ($TargetType == 1) {
                 $TargetID = $lang['cff_the_planet'];
             } elseif ($TargetType == 2) {
                 $TargetID = $lang['cff_debris_field'];
             } elseif ($TargetType == 3) {
                 $TargetID = $lang['cff_to_the_moon'];
             }
         } else {
             $TargetID = $lang['cff_the_position'];
         }
         $TargetID .= $TargetPlanet['name'] . " ";
         $TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
     } else {
         if ($StartType == 1) {
             $StartID = $lang['cff_to_the_planet'];
         } elseif ($StartType == 3) {
             $StartID = $lang['cff_the_moon'];
         }
         $StartID .= $StartPlanet['name'] . " ";
         $StartID .= GetStartAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
         if ($MissionType != 15) {
             if ($TargetType == 1) {
                 $TargetID = $lang['cff_from_planet'];
             } elseif ($TargetType == 2) {
                 $TargetID = $lang['cff_from_debris_field'];
             } elseif ($TargetType == 3) {
                 $TargetID = $lang['cff_from_the_moon'];
             }
         } else {
             $TargetID = $lang['cff_from_position'];
         }
         $TargetID .= $TargetPlanet['name'] . " ";
         $TargetID .= GetTargetAdressLink($FleetRow, $FleetPrefix . $FleetStyle[$MissionType]);
     }
     if ($MissionType == 10) {
         $EventString = $lang['cff_missile_attack'] . " ( " . eregi_replace("(503,)", "", $FleetRow["fleet_array"]) . " ) ";
         $Time = $FleetRow['fleet_start_time'];
         $Rest = $Time - time();
         $EventString .= $lang['cff_from'];
         $EventString .= $StartID;
         $EventString .= $lang['cff_to'];
         $EventString .= $TargetID;
         $EventString .= ".";
     } else {
         if ($Owner == true) {
             $EventString = $lang['cff_one_of_your'];
             $EventString .= $FleetContent;
         } else {
             $EventString = $lang['cff_a'];
             $EventString .= $FleetContent;
             $EventString .= $lang['cff_of'];
             $EventString .= $this->BuildHostileFleetPlayerLink($FleetRow);
         }
         if ($Status == 0) {
             $Time = $FleetRow['fleet_start_time'];
             $Rest = $Time - time();
             $EventString .= $lang['cff_goes'];
             $EventString .= $StartID;
             $EventString .= $lang['cff_toward'];
             $EventString .= $TargetID;
             $EventString .= $lang['cff_with_the_mission_of'];
         } elseif ($Status == 1) {
             $Time = $FleetRow['fleet_end_stay'];
             $Rest = $Time - time();
             $EventString .= $lang['cff_goes'];
             $EventString .= $StartID;
             $EventString .= $lang['cff_to_explore'];
             $EventString .= $TargetID;
             $EventString .= $lang['cff_with_the_mission_of'];
         } elseif ($Status == 2) {
             $Time = $FleetRow['fleet_end_time'];
             $Rest = $Time - time();
             $EventString .= $lang['cff_comming_back'];
             $EventString .= $TargetID;
             $EventString .= $StartID;
             $EventString .= $lang['cff_with_the_mission_of'];
         }
         $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_descr'] = $EventString;
     $bloc['fleet_javas'] = InsertJavaScriptChronoApplet($Label, $Record, $Rest, false);
     return parsetemplate($RowsTPL, $bloc);
 }