<tr>
<td valign="top">
<table border="0" width="800">
<?
$sql_alliancedata = "SELECT `message`, `message_lastedit` FROM $table[alliance] WHERE `id` = '$alliance_id'";
$rec_alliancedata = mysql_fetch_array(mysql_query($sql_alliancedata));
?>
<tr>
<td width="800" background="img/bg_balk.jpg" align="right"><b>Message posted at: <?php
echo date("H:i d-m-Y", $rec_alliancedata['message_lastedit']);
?>
</b></td>
</tr>
<tr>
<td align="left"><?php
echo nl2br(parseBBcode(stripslashes($rec_alliancedata['message']), 1, 1, 1, 1));
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="4" background="img/border/R.gif"> </td>
</tr>
<tr>
<td width="2%" valign="top"><img border="0" src="img/border/L_O.gif" width="20" height="15"></td>
<td width="100%" background="img/border/O.gif" colspan="2"> </td>
<td width="3%" valign="top"><img border="0" src="img/border/R_O.gif" width="20" height="15"></td>
</tr>
<form method="POST" action="main.php?mod=main&act=mail&do=delete&mail_id=<?echo $rec_readmail['id'];?>"><td width="50"><input type="submit" name="deletemail" value=" Delete "></td></form>
</tr>
<tr>
<td width="150">Date recieved:</td>
<td width="650" colspan="3"><?echo date('H:i d-m-Y', $rec_readmail['date']);?></td>
</tr>
<tr>
<td width="150">Subject:</td>
<td width="650" colspan="3"><?echo $rec_readmail['subject'];?></td>
</tr>
<tr>
<td height="15" colspan="5"> </td>
</tr>
<tr>
<td width="150">Message content:</td>
<td width="650" colspan="3"><?echo nl2br(parseBBcode(stripslashes($rec_readmail['text']), 1, 1, 1, 1));?></td>
</tr>
<?
}
else {
?>
<tr>
<td width="800" align="center">There is no such mail.</td>
</tr>
<?
}
?>
</table>
</td>
</tr>
</table>
<table width="100%" border="0">
<?
if ($playerdata['alliance_id'] > 0) {
$sql_allimsg = "SELECT `message` FROM $table[alliance] WHERE `id` = '$playerdata[alliance_id]'";
$res_allimsg = mysql_query($sql_allimsg);
$num_allimsg = @mysql_num_rows($res_allimsg);
if ($num_allimsg > 0) {
$rec_allimsg = mysql_fetch_assoc($res_allimsg);
}
?>
<tr>
<td align="center" background="img/bg_balk.jpg"><b>Message from the alliance commanders</b></td>
</tr>
<tr>
<td align="left"><?php
echo nl2br(parseBBcode(stripslashes($rec_allimsg['message']), 1, 1, 1, 1));
?>
</td>
</tr>
<tr>
<td align="left"> </td>
</tr>
<?
if (checkItem($playerdata['id'], $ALLIANCE_COMMUNICATION)) {
$sql_inc = "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].target_id
WHERE $table[players].alliance_id = '$playerdata[alliance_id]'
AND ($table[playerfleet].action = 'defend' OR $table[playerfleet].action = 'attack')
";