Posted: Sun Feb 22, 2004 6:32 pm
Thats what it is now:
Code: Select all
<table width="100%" border="0" height="10"><tr><td> </td></tr></TABLE>
<table width="100%" border="0" cellpadding="4" cellspacing="4" class="border">
<tr><td>
<strong> Read Messages</strong>
</td></tr>
<tr><td class="inner">
<?php
##################################################################################
# Delete message
if ($_GET['delete'])
{include "game_elements/diplomacy_delete.php";}
##################################################################################
# Echo Table headers
echo "<table class="text" width="100%" cellspacing=3 cellpadding=5>";
echo "<tr>";
echo "<td nowrap width="1%" class="header">Status</td>";
echo "<td nowrap width="1%" class="header">Sent</td>";
echo "<td width="1%" class="header">From</td>";
echo "<td width="1%" class="header">To</td>";
echo "<td width="99%" class="header">Message</td>";
echo "<td width="1%" class="header"> </td>";
echo "<td width="1%" class="header"> </td>";
echo "</tr>";
##################################################################################
# Make connection & Query messages
$mail = "Select * from users_mail where userid=$Player and gameid=$GameNumber order by 'isread' asc, 'from' asc";
$yhteys = mysql_connect($DBC1, $DBC2, $DBC3) or die ("Error on connect:" . mysql_error());
if(isset($yhteys))
{
mysql_select_db($DB, $yhteys);
$haku = mysql_query($mail, $yhteys) or die("Error in query: "$query"");
}
##################################################################################
# Select row color
$i=0;
while ($row = mysql_fetch_array($haku, MYSQL_ASSOC))
{
$i++;
if ($i % 2 == 0)
{
$A="1";
}
else
{
$A="2";
}
##################################################################################
# Choose apropriate picture
echo "<tr>";
$read="";
if ($row['isread']==0)
{
$read="<img src="includes/images/unread.gif" alt="Unread!">";
}
if ($row['isread']==2)
{
$read="<img src="includes/images/replied.gif" alt="Replied!">";
}
##################################################################################
# Print cell's
# $Link = "<a href="game.php?player=".$Player."&game=".$GameNumber."&action=";
echo "<td class="textrow$A"><div align="center">$read</div></td>";
echo "<td class="textrow$A">{$row['sent']}</td>";
$temp1=nations($row['from']);
echo "<td class="textrow$A">$temp1</td>";
$temp1=nations($row['to']);
echo "<td class="textrow$A">$temp1</td>";
echo "<td class="textrow$A">{$row['message']}</td>";
$id=$row['id'];
$del=$Link."diplomacy&act=read&delete=".$row['id'];
$del2="game.php?player=$Player&game=$GameNumber&action=diplomacy&act=read&delete=$id";
$celltxt="$del" onClick="_confirm('Delete this message?','$del2'); return false;"><img src="includes/images/delete.png" border="0" alt="Delete"></a>";
echo "<td class="textrow$A">$celltxt</td>";
$id=$row['id'];
$del=$Link."diplomacy&act=write&forward=$id";
$celltext="$del"><img src="includes/images/reply.png" border="0" alt="Reply/Forward"></a>";
echo "<td class="textrow$A"><div align="center">$celltext</div></td>";
echo "</tr>";
##################################################################################
# End of while ($row = mysql_fetch_array($haku, MYSQL_ASSOC))
}
##################################################################################
# End stuff
echo "</td></tr></table></td></tr><tr><td><div align="right">";
echo "<strong>You have $i of 100 messages </strong>";
echo "</div></td></tr></table>";
$mailread=fetch_query("update users_mail set isread=1 where isread=0 and userid=$Player and gameid=$GameNumber");
?>