<td width="150">Username:</td>
<td width="650"><? echo $playerdata['username']; ?></td>
</tr>
<tr>
<td width="150">Rulername:</td>
<td width="650"><? echo $playerdata['rulername']; ?></td>
</tr>
<tr>
<td width="150">Planetname:</td>
<td width="650"><? echo $playerdata['planetname'];?></td>
</tr>
<tr>
<td width="150">Universe location:</td>
<td width="650">
<?
$xyz = getXYZ($playerdata['id']);
echo $xyz[0].':'.$xyz[1].':'.$xyz[2];
?>
</td>
</tr>
<tr>
<td width="150">Alliance name & tag:</td>
<td width="650"><?echo getAllianceName($playerdata['id']).' - '.getAllianceTag($playerdata['id']);?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="4" background="img/border/R.gif"> </td>
</tr>
<?
$sql_memberlist = "SELECT `id`, `username`, `rulername`,`planetname`, `lastlogin`, `roid_steel`, `roid_crystal`, `roid_erbium`, `roid_unused`, `score` FROM $table[players] WHERE `alliance_id` = '$alliance_id' ORDER BY `score` DESC";
$res_memberlist = mysql_query($sql_memberlist);
while ($rec_memberlist = mysql_fetch_array($res_memberlist)) {
$currenttime = time();
$logintime = $rec_memberlist['lastlogin'];
$time_diff = $currenttime - $logintime;
if ($time_diff > 300) {
$status_color = 'red';
$status = 'Offline';
} else {
$status_color = 'green';
$status = 'Online';
}
$xyz = getXYZ($rec_memberlist['id']);
$totalroids = 0;
$totalroids += $rec_memberlist['roid_steel'];
$totalroids += $rec_memberlist['roid_crystal'];
$totalroids += $rec_memberlist['roid_erbium'];
$totalroids += $rec_memberlist['roid_unused'];
?>
<tr>
<td align="center"><?echo $xyz[0].':'.$xyz[1].':'.$xyz[2];?></td>
<td align="center"><a href="main.php?mod=main&act=mail&do=compose&x=<?php
echo $xyz[0];
?>
&y=<?php
echo $xyz[1];
?>
$table[playerfleet_ships].player_id, $table[playerfleet_ships].fleet_id, $table[playerfleet].target_id
FROM `$table[ships]`
INNER JOIN $table[playerfleet_ships] ON $table[ships].id = $table[playerfleet_ships].ship_id
INNER JOIN $table[playerfleet] ON $table[playerfleet].id = $table[playerfleet_ships].fleet_id
WHERE $table[playerfleet_ships].fleet_id = '$rec_findreturning[id]'
ORDER BY $table[ships].traveltime DESC";
$res_findtraveltime = mysql_query($sql_findtraveltime);
$num_findtraveltime = @mysql_num_rows($res_findtraveltime);
if ($num_findtraveltime > 0) {
$rec_findtraveltime = mysql_fetch_assoc($res_findtraveltime);
$slowest_traveltime = $rec_findtraveltime['traveltime'];
}
if ($slowest_traveltime > 0) {
if (($current - $rec_findreturning['sent_tick']) > $slowest_traveltime) { $eta = $slowest_traveltime; }
else { $eta = $current - $rec_findreturning['sent_tick']; }
} else {
$eta = $current - $rec_findreturning['sent_tick'];
}
$target_xyz = getXYZ($rec_findtraveltime['target_id']);
$player_xyz = getXYZ($rec_findtraveltime['player_id']);
$eta_bonus = 0;
if (($target_xyz[0] == $player_xyz[0]) && ($target_xyz[1] == $player_xyz[1])) { $eta_bonus = 10; }
elseif ($target_xyz[0] == $player_xyz[0]) { $eta_bonus = 5; }
$eta -= $eta_bonus;
$action_start = $current + $eta;
$sql_fleethome = "UPDATE $table[playerfleet] SET `target_id` = '$rec_findreturning[player_id]', `action` = 'home', `action_start` = '$action_start', `action_time` = '0' WHERE `id` = '$rec_findreturning[id]'";
mysql_query($sql_fleethome) or die(mysql_error());
appendPlayerLog($rec_findreturning['player_id'], 'Found fleet which should already be returning home (id: '.$rec_findreturning['id'].'). Sending it home now..', '');
}
}
?>
<td width="150" background="img/bg_balk.jpg"> </td>
</tr>
<?
$sql_mails = "SELECT * FROM $table[mail] WHERE `to_player` = '$playerdata[id]' ORDER BY `date` DESC";
$res_mails = mysql_query($sql_mails);
if (@mysql_num_rows($res_mails) < 1) {
?>
<tr><td width="800" colspan="4" align="center">There are no mails.</td></tr>
<?
}
else {
while ($rec_mails = mysql_fetch_array($res_mails)) {
$bo = null;
$bc = null;
if ($rec_mails['read'] == 0) { $bo = '<b>'; $bc = '</b>'; }
$c = getXYZ($rec_mails['from_player']);
?>
<form method="POST" action="main.php?mod=main&act=mail&do=delete&mail_id=<?echo $rec_mails['id'];?>">
<tr>
<td><a href="main.php?mod=main&act=mail&do=read&mail_id=<?echo $rec_mails['id'];?>"><?echo $bo.getRulernameById($rec_mails['from_player']).' of '.getPlanetnameById($rec_mails['from_player']).'('.$c[0].':'.$c[1].':'.$c[2].')'.$bc;?></a></td>
<td><a href="main.php?mod=main&act=mail&do=read&mail_id=<?echo $rec_mails['id'];?>"><?echo $bo.$rec_mails['subject'].$bc;?></a></td>
<td><a href="main.php?mod=main&act=mail&do=read&mail_id=<?echo $rec_mails['id'];?>"><?echo $bo.date('H:i d-m-Y', $rec_mails['date']).$bc;?></a></td>
<td align="center"><input type="submit" name="deletemail" value=" Delete "></td>
</tr>
</form>
<?
}
}
?>
</table>
</td>
$source_id = $piratefleet[$j]->getPlayerId();
$sql_upd_roids_attacker = "UPDATE `$table[players]` SET
`roid_steel` = `roid_steel` + $steel_roids_capped,
`roid_crystal` = `roid_crystal` + $crystal_roids_capped,
`roid_erbium` = `roid_erbium` + $erbium_roids_capped,
`roid_unused` = `roid_unused` + $unused_roids_capped
WHERE `id` = $source_id";
$new['roid_steel'] -= $steel_roids_capped;
$new['roid_crystal'] -= $crystal_roids_capped;
$new['roid_erbium'] -= $erbium_roids_capped;
$new['roid_unused'] -= $unused_roids_capped;
mysql_query($sql_upd_roids_attacker) or die(mysql_error());
$c = getXYZ($target_id);
$playername = getRulernameById($target_id).' of '.getPlanetnameById($target_id);
addNews($source_id, 'Battle', 'Asteroid pirate report',
'<table border="0" width="450" style="border: 1px solid #3C5762">
<tr style="border: 1px solid #3C5762">
<td colspan="2" width="450" >Asteroid pirate report from: <b>'.getShipProperty($ship_id, 'name').'</b></td>
<tr style="border: 1px solid #3C5762">
<td width="150"><b>Asteroid type</b></td>
<td width="250"><b>Amount stolen from '.$c[0].':'.$c[1].':'.$c[2].' ('.$playername.')</b></td>
</tr>
<tr style="border: 1px solid #3C5762">
<td>Steel</td>
<td>'.$steel_roids_capped.'</td>
</tr>
<tr style="border: 1px solid #3C5762">
<td>Crystal</td>
function getBRHtmlStart($player_id, $type, $mytype) {
$c = getXYZ($player_id);
$html = '<table border="0" width="595" style="border: 1px solid #3C5762">
<tr>
<td width="595" colspan="5"><b>'.$type.' at '.$c[0].':'.$c[1].':'.$c[2].' ('.getPlayerProperty($player_id, 'rulername').' of '.getPlayerProperty($player_id, 'planetname').')</b></td>
</tr>
<tr>
<td width="250">Ship name</td>
<td width="85">Total amount</td>';
if ($mytype) {
$html .= '
<td width="85">Total losses</td>
<td width="85">Your amount</td>
<td width="85">Your losses</td>
</tr>';
} else {
$html .= '
<td width="255" colspan="3">Total losses</td>
</tr>';
}
return $html;
}
</tr>
<?
$sql_out = "SELECT $table[playerfleet].player_id, $table[playerfleet].target_id,
$table[playerfleet].action, $table[playerfleet].action_start
FROM $table[playerfleet]
INNER JOIN $table[players] ON $table[players].id = $table[playerfleet].player_id
WHERE $table[players].galaxy_id = '$playerdata[galaxy_id]'
AND ($table[playerfleet].action = 'defend' OR $table[playerfleet].action = 'attack')
ORDER BY `action_start`
";
$res_out = mysql_query($sql_out) or die(mysql_error());
$num_out = @mysql_num_rows($res_out);
if ($num_out > 0) {
while($rec_out = mysql_fetch_assoc($res_out)) {
$from_xyz = getXYZ($rec_out['player_id']);
$to_xyz = getXYZ($rec_out['target_id']);
$eta = $rec_out['action_start'] - getCurrentTick();
if ($eta < 0) { $eta = 0; }
if ($rec_out['action'] == 'attack') { $tdclass = 'class="hostile"'; }
if ($rec_out['action'] == 'defend') { $tdclass = 'class="friendly"'; }
?>
<tr>
<td <?if ($tdclass) echo $tdclass;?>><?if ($rec_out['action'] == 'attack') echo 'Hostile'; elseif ($rec_out['action'] == 'defend') echo 'Friendly'; ?></td>
<td <?if ($tdclass) echo $tdclass;?>><a href="main.php?mod=galaxy&act=view&x=<?php
echo $from_xyz[0];
?>
&y=<?php
echo $from_xyz[1];
?>
"><?echo $from_xyz[0].':'.$from_xyz[1].':'.$from_xyz[2];?></a> (<a href="main.php?mod=main&act=mail&do=compose&x=<?php
echo $from_xyz[0];
<td width="100" background="img/bg_balk.jpg"><b>Score</b></td>
<td width="50" background="img/bg_balk.jpg"><b>Asteroids</b></td>
</tr>
<?
$sql_getuni = "SELECT
$table[universe].id, $table[universe].player_id, $table[universe].tag, $table[universe].score, $table[universe].asteroids,
$table[players].rulername, $table[players].planetname
FROM $table[universe]
INNER JOIN $table[players] ON $table[universe].player_id = $table[players].id
ORDER BY $table[universe].id";
$res_getuni = mysql_query($sql_getuni);
while ($rec_getuni = mysql_fetch_array($res_getuni)) {
?>
<tr>
<td><?echo $rec_getuni['id']; ?></td>
<td align="center"><? $xyz = getXYZ(getIdByRulername($rec_getuni['rulername']));?><a href="main.php?mod=galaxy&act=view&x=<?php
echo $xyz[0];
?>
&y=<?php
echo $xyz[1];
?>
"><? echo $xyz[0].':'.$xyz[1].':'.$xyz[2]; ?></a></td>
<td align="center"><?echo stripslashes($rec_getuni['tag']); ?></td>
<td align="center"><a href="main.php?mod=main&act=mail&do=compose&x=<?php
echo $xyz[0];
?>
&y=<?php
echo $xyz[1];
?>
&z=<?php
echo $xyz[2];
?>
<form method="POST" action="main.php?mod=office&act=fleet&do=fleetaction&fleet_id=<?php
echo $res_getfleets['id'];
?>
">
<tr>
<td <?if ($tdclass) echo $tdclass;?>><?php
echo $res_getfleets['id'];
?>
</td>
<td <?if ($tdclass) echo $tdclass;?>><?php
echo $res_getfleets['action'];
?>
</td>
<td <?if ($tdclass) echo $tdclass;?>><?
$xyz = getXYZ($res_getfleets['target_id']);
$rulername = getRulernameById($res_getfleets['target_id']);
$planetname = getPlanetnameById($res_getfleets['target_id']);
if ($rulername && $xyz) {
echo $xyz[0].':'.$xyz[1].':'.$xyz[2].' ('.$rulername.' of '.$planetname.')';
} else {
echo ' ';
}
?></td>
<td <?if ($tdclass) echo $tdclass;?>><?
if (($res_getfleets['action_start'] > 0) || (($res_getfleets['action_start'] - getCurrentTick()) > 0)) {
echo ($res_getfleets['action_start'] - getCurrentTick());
} else {
echo 0;
}
?></td>
if ($num_outhostile > 0) {
$outgoing .= "Outgoings:";
while ($rec_outhostile = mysql_fetch_assoc($res_outhostile)) {
$xyz = getXYZ($rec_outhostile['target_id']);
if (($rec_outhostile['action_start'] - getCurrentTick()) < 1) { $eta = 0; }
else { $eta = $rec_outhostile['action_start'] - getCurrentTick(); }
$outgoing .= '<font color="red"><li>Hostile to '.$xyz[0].':'.$xyz[1].':'.$xyz[2].' - ETA: '.$eta.'</font>';
}
}
$sql_outfriendly = "SELECT `target_id`, `action_start` FROM $table[playerfleet] WHERE `player_id` = '$playerdata[id]' AND `action` = 'defend'";
$res_outfriendly = mysql_query($sql_outfriendly);
$num_outfriendly = @mysql_num_rows($res_outfriendly);
if ($num_outfriendly > 0) {
if (strlen($outgoing) < 1) { $outgoing = "Incomings:"; }
while ($rec_outfriendly = mysql_fetch_assoc($res_outfriendly)) {
$xyz = getXYZ($rec_outfriendly['target_id']);
if (($rec_outfriendly['action_start'] - getCurrentTick()) < 1) { $eta = 0; }
else { $eta = $rec_outfriendly['action_start'] - getCurrentTick(); }
$outgoing .= '<font color="green"><li>Friendly to '.$xyz[0].':'.$xyz[1].':'.$xyz[2].' - ETA: '.$eta.'</font>';
}
}
if (strlen($outgoing) > 0) {
if (strlen($incoming) > 0) { echo '<br>'; }
echo $outgoing;
echo '<br>';
}
if ((strlen($outgoing) < 1) && (strlen($incoming) < 1)) {
echo 'No fleet movements around your planet.';
}
?>
</td>
