function MissionCaseSpy($FleetRow)
{
global $lang, $resource;
//Get the users
$TargetUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $FleetRow['target_userid'] . "';", 'users', true);
$CurrentUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $FleetRow['owner_userid'] . "';", 'users', true);
//Get the planets
$TargetPlanet = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $FleetRow['target_id'] . "' ;", 'planets', true);
$CurrentPlanet = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $FleetRow['owner_id'] . "' ;", 'planets', true);
//Get the espionage levels
$TargetSpyLvl = $TargetUser[$resource[106]];
$CurrentSpyLvl = $CurrentUser[$resource[106]];
//Get the number of probes
$probes = 0;
foreach (explode(";", $FleetRow['array']) as $b) {
if ($b) {
$a = explode(",", $b);
if ($a[0] == 210) {
$probes += $a[1];
}
}
}
//Get the effective number of probes, baring in mind tech difference.
$spy = pow($CurrentUser[$resource[106]] - $TargetUser[$resource[106]], 2);
if ($CurrentUser[$resource[106]] - $TargetUser[$resource[106]] < 0) {
$spy = 0 - $spy;
}
$spy += $probes;
$report = '';
if ($spy > 7) {
$spy = 7;
}
switch ($spy) {
case 7:
$section = SpyTarget($TargetUser, 4, $lang['tech'][100]);
$report = $section['String'] . $report;
case 6:
case 5:
$section = SpyTarget($TargetPlanet, 3, $lang['tech'][0]);
$report = $section['String'] . $report;
case 4:
case 3:
$section = SpyTarget($TargetPlanet, 2, $lang['tech'][400]);
$report = $section['String'] . $report;
case 2:
$section = SpyTarget($TargetPlanet, 1, $lang['tech'][200]);
$report = $section['String'] . $report;
default:
$section = SpyTarget($TargetPlanet, 0, $lang['Resources']);
$report = $section['String'] . $report . "</table>";
break;
}
PM($CurrentPlanet['id_owner'], 0, $report, $lang['fleet_6_tit'], $lang['fleet_control'], 4);
/*
$QryTargetGalaxy = "SELECT * FROM {{table}} WHERE ";
$QryTargetGalaxy .= "`galaxy` = '". $FleetRow['fleet_end_galaxy'] ."' AND ";
$QryTargetGalaxy .= "`system` = '". $FleetRow['fleet_end_system'] ."' AND ";
$QryTargetGalaxy .= "`planet` = '". $FleetRow['fleet_end_planet'] ."';";
$TargetGalaxy = doquery( $QryTargetGalaxy, 'galaxy', true);
$CristalDebris = $TargetGalaxy['crystal'];
$SpyToolDebris = $LS * 300;
$MaterialsInfo = SpyTarget ( $TargetPlanet, 0, $lang['sys_spy_maretials'] );
$Materials = $MaterialsInfo['String'];
$PlanetFleetInfo = SpyTarget ( $TargetPlanet, 1, $lang['sys_spy_fleet'] );
$PlanetFleet = $Materials;
$PlanetFleet .= $PlanetFleetInfo['String'];
$PlanetDefenInfo = SpyTarget ( $TargetPlanet, 2, $lang['sys_spy_defenses'] );
$PlanetDefense = $PlanetFleet;
$PlanetDefense .= $PlanetDefenInfo['String'];
$PlanetBuildInfo = SpyTarget ( $TargetPlanet, 3, $lang['tech'][0] );
$PlanetBuildings = $PlanetDefense;
$PlanetBuildings .= $PlanetBuildInfo['String'];
$TargetTechnInfo = SpyTarget ( $TargetUser, 4, $lang['tech'][100] );
$TargetTechnos = $PlanetBuildings;
$TargetTechnos .= $TargetTechnInfo['String'];
$TargetForce = ($PlanetFleetInfo['Count'] * $LS) / 4;
if ($TargetForce > 100) {
$TargetForce = 100;
}
$TargetChances = rand(0, $TargetForce);
$SpyerChances = rand(0, 100);
if ($TargetChances >= $SpyerChances) {
$DestProba = sprintf( $lang['sys_mess_spy_lostproba'], $TargetChances);
} elseif ($TargetChances < $SpyerChances) {
$DestProba = "<font color=\"red\">".$lang['sys_mess_spy_destroyed']."</font>";
}
$AttackLink = "<center>";
$AttackLink .= "<a href=\"fleet.php?galaxy=". $FleetRow['fleet_end_galaxy'] ."&system=". $FleetRow['fleet_end_system'] ."";
$AttackLink .= "&planet=".$FleetRow['fleet_end_planet']."";
$AttackLink .= "&target_mission=1";
$AttackLink .= " \">". $lang['type_mission'][1] ."";
$AttackLink .= "</a></center>";
$MessageEnd = "<center>".$DestProba."</center>";
$pT = ($TargetSpyLvl - $CurrentSpyLvl);
$pW = ($CurrentSpyLvl - $TargetSpyLvl);
if ($TargetSpyLvl > $CurrentSpyLvl) {
$ST = ($LS - pow($pT, 2));
}
if ($CurrentSpyLvl > $TargetSpyLvl) {
$ST = ($LS + pow($pW, 2));
}
if ($TargetSpyLvl == $CurrentSpyLvl) {
$ST = $CurrentSpyLvl;
}
if ($ST <= "1") {
$SpyMessage = $Materials."<br />".$AttackLink.$MessageEnd;
}
if ($ST == "2") {
$SpyMessage = $PlanetFleet."<br />".$AttackLink.$MessageEnd;
}
if ($ST == "4" or $ST == "3") {
$SpyMessage = $PlanetDefense."<br />".$AttackLink.$MessageEnd;
}
if ($ST == "5" or $ST == "6") {
$SpyMessage = $PlanetBuildings."<br />".$AttackLink.$MessageEnd;
}
if ($ST >= "7") {
$SpyMessage = $TargetTechnos."<br />".$AttackLink.$MessageEnd;
}
SendSimpleMessage ( $FleetRow['owner_userid'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_qg'], $lang['sys_mess_spy_report'], $SpyMessage);
$TargetMessage = $lang['sys_mess_spy_ennemyfleet'] ." ". $CurrentPlanet['name'];
$TargetMessage .= "<a href=\"galaxy.php?mode=3&galaxy=". $CurrentPlanet["galaxy"] ."&system=". $CurrentPlanet["system"] ."\">";
$TargetMessage .= "[". $CurrentPlanet["galaxy"] .":". $CurrentPlanet["system"] .":". $CurrentPlanet["planet"] ."]</a> ";
$TargetMessage .= $lang['sys_mess_spy_seen_at'] ." ". $TargetPlanet['name'];
$TargetMessage .= " [". $TargetPlanet["galaxy"] .":". $TargetPlanet["system"] .":". $TargetPlanet["planet"] ."].";
SendSimpleMessage ( $FleetRow['target_userid'], '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_spy_control'], $lang['sys_mess_spy_activity'], $TargetMessage);
}
if ($TargetChances >= $SpyerChances) {
$QryUpdateGalaxy = "UPDATE {{table}} SET ";
$QryUpdateGalaxy .= "`crystal` = `crystal` + '". (0 + $SpyToolDebris) ."' ";
$QryUpdateGalaxy .= "WHERE `id_planet` = '". $TargetPlanet['id'] ."';";
doquery( $QryUpdateGalaxy, 'galaxy');
doquery("DELETE FROM {{table}} WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');
} else {
doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = '". $FleetRow["fleet_id"] ."';", 'fleets');
}
}
} else {
// Retour de sondes
if ($FleetRow['fleet_end_time'] <= time()) {
RestoreFleetToPlanet ( $FleetRow, true );
doquery("DELETE FROM {{table}} WHERE `fleet_id` = ". $FleetRow["fleet_id"], 'fleets');
}
}
}
}*/
}
function MissionCaseSpy($FleetRow)
{
global $lang, $resource;
if ($FleetRow['fleet_start_time'] <= time()) {
$CurrentUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $FleetRow['fleet_owner'] . "';", 'users', true);
$CurrentUserID = $FleetRow['fleet_owner'];
$QryGetTargetPlanet = "SELECT * FROM {{table}} ";
$QryGetTargetPlanet .= "WHERE ";
$QryGetTargetPlanet .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
$QryGetTargetPlanet .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
$QryGetTargetPlanet .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "' AND ";
$QryGetTargetPlanet .= "`planet_type` = '" . $FleetRow['fleet_end_type'] . "';";
$TargetPlanet = doquery($QryGetTargetPlanet, 'planets', true);
$TargetUserID = $TargetPlanet['id_owner'];
$CurrentPlanet = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_start_system'] . "' AND `planet` = '" . $FleetRow['fleet_start_planet'] . "';", 'planets', true);
$CurrentSpyLvl = $CurrentUser['spy_tech'];
$CurrentEspia = $CurrentUser['rpg_espion'];
$TargetUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $TargetUserID . "';", 'users', true);
$TargetSpyLvl = $TargetUser['spy_tech'];
$TargetEspia = $TargetUser['rpg_espion'];
$fleet = explode(";", $FleetRow['fleet_array']);
$fquery = "";
// Planeten aktualisieren und erneut auslesen
// =============================================================================
$update = PlanetResourceUpdate($TargetUser, $TargetPlanet, $FleetRow['fleet_end_time']);
$TargetPlanet = doquery($QryGetTargetPlanet, 'planets', true);
$TargetUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $TargetUserID . "';", 'users', true);
// =============================================================================
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
if ($FleetRow['fleet_mess'] != "1") {
if ($a[0] == "210") {
$LS = $a[1];
$QryTargetGalaxy = "SELECT * FROM {{table}} WHERE ";
$QryTargetGalaxy .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
$QryTargetGalaxy .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
$QryTargetGalaxy .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "';";
$TargetGalaxy = doquery($QryTargetGalaxy, 'galaxy', true);
$CristalDebris = $TargetGalaxy['crystal'];
$SpyToolDebris = $LS * 300;
$MaterialsInfo = SpyTarget($TargetPlanet, 0, $lang['sys_spy_maretials']);
$Materials = $MaterialsInfo['String'];
$PlanetFleetInfo = SpyTarget($TargetPlanet, 1, $lang['sys_spy_fleet']);
$PlanetFleet = $Materials;
$PlanetFleet .= $PlanetFleetInfo['String'];
$PlanetDefenInfo = SpyTarget($TargetPlanet, 2, $lang['sys_spy_defenses']);
$PlanetDefense = $PlanetFleet;
$PlanetDefense .= $PlanetDefenInfo['String'];
$PlanetBuildInfo = SpyTarget($TargetPlanet, 3, $lang['tech'][0]);
$PlanetBuildings = $PlanetDefense;
$PlanetBuildings .= $PlanetBuildInfo['String'];
$TargetTechnInfo = SpyTarget($TargetUser, 4, $lang['tech'][100]);
$TargetTechnos = $PlanetBuildings;
$TargetTechnos .= $TargetTechnInfo['String'];
// Stehende Flotten
$TargetAllyInfo = SpyTarget($TargetPlanet, 5, $lang['sys_spy_stayfleets']);
$TargetAllyFleet = $TargetTechnos;
$TargetAllyFleet .= $TargetAllyInfo['String'];
$TargetForce = $PlanetFleetInfo['Count'] * $LS / 4;
if ($TargetForce > 100) {
$TargetForce = 100;
}
$TargetChances = rand(0, $TargetForce);
$SpyerChances = rand(0, 100);
if ($TargetChances >= $SpyerChances) {
$DestProba = "<font color=\"red\">" . $lang['sys_mess_spy_destroyed'] . "</font>";
//Wenn die Spiosonden abgeschossen wurden werden sie jetzt in der DB gelöscht.
doquery("DELETE FROM {{table}} WHERE `fleet_owner` = '" . $TargetUserID . "' AND `fleet_mission`=6 AND `fleet_mission`='" . $FleetRow['fleet_id'] . "';", 'fleets');
} elseif ($TargetChances < $SpyerChances) {
$DestProba = sprintf($lang['sys_mess_spy_lostproba'], $TargetChances);
}
$AttackLink = "<center>";
$AttackLink .= "<a href=\"fleet.php?galaxy=" . $FleetRow['fleet_end_galaxy'] . "&system=" . $FleetRow['fleet_end_system'] . "";
$AttackLink .= "&planet=" . $FleetRow['fleet_end_planet'] . "&planettype=" . $FleetRow['fleet_end_type'] . "";
$AttackLink .= "&target_mission=1";
$AttackLink .= " \">" . $lang['type_mission'][1] . "";
$AttackLink .= "</a></center>";
$MessageEnd = "<center>" . $DestProba . "</center>";
$pT = $TargetSpyLvl + $TargetEspia - ($CurrentSpyLvl + $CurrentEspia);
$pW = $CurrentSpyLvl + $CurrentEspia - ($TargetSpyLvl + $TargetEspia);
if ($TargetSpyLvl + $TargetEspia > $CurrentSpyLvl + $CurrentEspia) {
$ST = $LS - pow($pT, 2);
}
if ($CurrentSpyLvl + $CurrentEspia > $TargetSpyLvl + $TargetEspia) {
$ST = $LS + pow($pW, 2);
}
if ($TargetSpyLvl == $CurrentSpyLvl) {
$ST = $CurrentSpyLvl;
}
if ($ST <= "1") {
$SpyMessage = $Materials . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST == "2") {
$SpyMessage = $PlanetFleet . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST == "4" or $ST == "3") {
$SpyMessage = $PlanetDefense . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST == "5" or $ST == "6") {
$SpyMessage = $PlanetBuildings . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST >= "7") {
$SpyMessage = $TargetAllyFleet . "<br />" . $AttackLink . $MessageEnd;
}
SendSimpleMessage($CurrentUserID, '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_qg'], $lang['sys_mess_spy_report'], $SpyMessage);
$TargetMessage = $lang['sys_mess_spy_ennemyfleet'] . " " . $CurrentPlanet['name'];
$TargetMessage .= "<a href=\"galaxy.php?mode=3&galaxy=" . $CurrentPlanet['galaxy'] . "&system=" . $CurrentPlanet['system'] . "\">";
$TargetMessage .= "[" . $CurrentPlanet['galaxy'] . ":" . $CurrentPlanet['system'] . ":" . $CurrentPlanet['planet'] . "]</a> ";
$TargetMessage .= $lang['sys_mess_spy_seen_at'] . " " . $TargetPlanet['name'];
$TargetMessage .= " [" . $TargetPlanet['galaxy'] . ":" . $TargetPlanet['system'] . ":" . $TargetPlanet['planet'] . "].";
SendSimpleMessage($TargetUserID, '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_spy_control'], $lang['sys_mess_spy_activity'], $TargetMessage);
}
if ($TargetChances >= $SpyerChances) {
$QryUpdateGalaxy = "UPDATE {{table}} SET ";
$QryUpdateGalaxy .= "`crystal` = `crystal` + '" . (0 + $SpyToolDebris) . "' ";
$QryUpdateGalaxy .= "WHERE `id_planet` = '" . $TargetPlanet['id'] . "';";
doquery("DELETE FROM {{table}} WHERE `fleet_id` = " . $FleetRow['fleet_id'], 'fleets');
doquery($QryUpdateGalaxy, 'galaxy');
} else {
doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = '" . $FleetRow['fleet_id'] . "';", 'fleets');
}
}
} else {
// Rueckkehr der Spiosonden
if ($FleetRow['fleet_end_time'] <= time()) {
RestoreFleetToPlanet($FleetRow, true);
doquery("DELETE FROM {{table}} WHERE `fleet_id` = " . $FleetRow['fleet_id'], 'fleets');
}
}
}
}
}
function MissionCaseSpy($FleetRow)
{
global $lang, $resource;
if ($FleetRow['fleet_start_time'] <= time()) {
$CurrentUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $FleetRow['fleet_owner'] . "';", 'users', true);
$CurrentUserID = $FleetRow['fleet_owner'];
$QryGetTargetPlanet = "SELECT * FROM {{table}} ";
$QryGetTargetPlanet .= "WHERE ";
$QryGetTargetPlanet .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
$QryGetTargetPlanet .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
$QryGetTargetPlanet .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "' AND ";
$QryGetTargetPlanet .= "`planet_type` = '" . $FleetRow['fleet_end_type'] . "';";
$TargetPlanet = doquery($QryGetTargetPlanet, 'planets', true);
$TargetUserID = $TargetPlanet['id_owner'];
$CurrentPlanet = doquery("SELECT * FROM {{table}} WHERE `galaxy` = '" . $FleetRow['fleet_start_galaxy'] . "' AND `system` = '" . $FleetRow['fleet_start_system'] . "' AND `planet` = '" . $FleetRow['fleet_start_planet'] . "';", 'planets', true);
$CurrentSpyLvl = $CurrentUser['spy_tech'];
$TargetUser = doquery("SELECT * FROM {{table}} WHERE `id` = '" . $TargetUserID . "';", 'users', true);
$TargetSpyLvl = $TargetUser['spy_tech'];
$fleet = explode(";", $FleetRow['fleet_array']);
$fquery = "";
foreach ($fleet as $a => $b) {
if ($b != '') {
$a = explode(",", $b);
$fquery .= "{$resource[$a[0]]}={$resource[$a[0]]} + {$a[1]}, \n";
if ($FleetRow["fleet_mess"] != "1") {
if ($a[0] == "210") {
$LS = $a[1];
$QryTargetGalaxy = "SELECT * FROM {{table}} WHERE ";
$QryTargetGalaxy .= "`galaxy` = '" . $FleetRow['fleet_end_galaxy'] . "' AND ";
$QryTargetGalaxy .= "`system` = '" . $FleetRow['fleet_end_system'] . "' AND ";
$QryTargetGalaxy .= "`planet` = '" . $FleetRow['fleet_end_planet'] . "';";
$TargetGalaxy = doquery($QryTargetGalaxy, 'galaxy', true);
$CristalDebris = $TargetGalaxy['crystal'];
//$SpyToolDebris = $LS * 300;
$SpyToolDebris = $LS * 10;
//减少撞击的渣土
$MaterialsInfo = SpyTarget($TargetPlanet, 0, $lang['sys_spy_maretials']);
$Materials = $MaterialsInfo['String'];
$PlanetFleetInfo = SpyTarget($TargetPlanet, 1, $lang['sys_spy_fleet']);
$PlanetFleet = $Materials;
$PlanetFleet .= $PlanetFleetInfo['String'];
$PlanetDefenInfo = SpyTarget($TargetPlanet, 2, $lang['sys_spy_defenses']);
$PlanetDefense = $PlanetFleet;
$PlanetDefense .= $PlanetDefenInfo['String'];
$PlanetBuildInfo = SpyTarget($TargetPlanet, 3, $lang['tech'][0]);
$PlanetBuildings = $PlanetDefense;
$PlanetBuildings .= $PlanetBuildInfo['String'];
$TargetTechnInfo = SpyTarget($TargetUser, 4, $lang['tech'][100]);
$TargetTechnos = $PlanetBuildings;
$TargetTechnos .= $TargetTechnInfo['String'];
$TargetForce = $PlanetFleetInfo['Count'] * $LS / 4;
if ($TargetForce > 100) {
$TargetForce = 100;
}
$TargetChances = rand(0, $TargetForce);
$SpyerChances = rand(0, 100);
if ($TargetChances >= $SpyerChances) {
$DestProba = sprintf($lang['sys_mess_spy_lostproba'], $TargetChances);
} elseif ($TargetChances < $SpyerChances) {
$DestProba = "<font color=\"red\">" . $lang['sys_mess_spy_destroyed'] . "</font>";
}
$AttackLink = "<center>";
$AttackLink .= "<a href=\"fleet.php?galaxy=" . $FleetRow['fleet_end_galaxy'] . "&system=" . $FleetRow['fleet_end_system'] . "";
$AttackLink .= "&planet=" . $FleetRow['fleet_end_planet'] . "";
$AttackLink .= "&target_mission=1";
$AttackLink .= " \">" . $lang['type_mission'][1] . "";
$AttackLink .= "</a></center>";
$MessageEnd = "<center>" . $DestProba . "</center>";
$pT = $TargetSpyLvl - $CurrentSpyLvl;
$pW = $CurrentSpyLvl - $TargetSpyLvl;
if ($TargetSpyLvl > $CurrentSpyLvl) {
$ST = $LS - pow($pT, 2);
}
if ($CurrentSpyLvl > $TargetSpyLvl) {
$ST = $LS + pow($pW, 2);
}
if ($TargetSpyLvl == $CurrentSpyLvl) {
$ST = $CurrentSpyLvl;
}
if ($ST <= "1") {
$SpyMessage = $Materials . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST == "2") {
$SpyMessage = $PlanetFleet . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST == "4" or $ST == "3") {
$SpyMessage = $PlanetDefense . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST == "5" or $ST == "6") {
$SpyMessage = $PlanetBuildings . "<br />" . $AttackLink . $MessageEnd;
}
if ($ST >= "7") {
$SpyMessage = $TargetTechnos . "<br />" . $AttackLink . $MessageEnd;
}
SendSimpleMessage($CurrentUserID, '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_qg'], $lang['sys_mess_spy_report'], $SpyMessage);
$TargetMessage = $lang['sys_mess_spy_ennemyfleet'] . " " . $CurrentPlanet['name'];
$TargetMessage .= "<a href=\"galaxy.php?mode=3&galaxy=" . $CurrentPlanet["galaxy"] . "&system=" . $CurrentPlanet["system"] . "\">";
$TargetMessage .= "[" . $CurrentPlanet["galaxy"] . ":" . $CurrentPlanet["system"] . ":" . $CurrentPlanet["planet"] . "]</a> ";
$TargetMessage .= $lang['sys_mess_spy_seen_at'] . " " . $TargetPlanet['name'];
$TargetMessage .= " [" . $TargetPlanet["galaxy"] . ":" . $TargetPlanet["system"] . ":" . $TargetPlanet["planet"] . "].";
SendSimpleMessage($TargetUserID, '', $FleetRow['fleet_start_time'], 0, $lang['sys_mess_spy_control'], $lang['sys_mess_spy_activity'], $TargetMessage);
}
if ($TargetChances >= $SpyerChances) {
$QryUpdateGalaxy = "UPDATE {{table}} SET ";
$QryUpdateGalaxy .= "`crystal` = `crystal` + '" . (0 + $SpyToolDebris) . "' ";
$QryUpdateGalaxy .= "WHERE `id_planet` = '" . $TargetPlanet['id'] . "';";
doquery($QryUpdateGalaxy, 'galaxy');
//卫星碎片产生的废墟
doquery("DELETE FROM {{table}} WHERE `fleet_id` = '" . $FleetRow["fleet_id"] . "';", 'fleets');
} else {
doquery("UPDATE {{table}} SET `fleet_mess` = '1' WHERE `fleet_id` = '" . $FleetRow["fleet_id"] . "';", 'fleets');
$FleetRow['fleet_array'] = "";
//清空间谍卫星，可能存在BUG,如果是一支混合舰队？
}
}
} else {
//舰队返回
if ($FleetRow['fleet_end_time'] <= time()) {
RestoreFleetToPlanet($FleetRow, true);
doquery("DELETE FROM {{table}} WHERE `fleet_id` = " . $FleetRow["fleet_id"], 'fleets');
}
}
}
}
}