<?php
defined (
'main'
)
or
die
(
'no direct access'
);
echo
'<table width="100%" border="0" cellpadding="0" cellspacing="0" style="margin-top: -3px;">'
;
$akttime
=
date
(
'Y-m-d'
);
$erg
= @db_query(
"SELECT DATE_FORMAT(datime,'%d.%m.%Y - %H:%i') as time,tag,gegner, id, game FROM prefix_wars WHERE status = 2 AND datime > '"
.
$akttime
.
"' ORDER BY datime ASC LIMIT 4"
);
if
( @db_num_rows(
$erg
) == 0 ) {
echo
'<tr><td>kein War geplant</td></tr>'
;
}
else
{
while
(
$row
= @db_fetch_object(
$erg
) ) {
$row
->tag = (
empty
(
$row
->tag) ?
$row
->gegner :
$row
->tag );
echo
'<tr>'
;
echo
'<td style="padding: 3px 10px 3px 0; height: 34px;" align="left" valign="middle">'
.get_wargameimg(
$row
->game).
'</td>'
;
echo
'<td class="vs"> VS </td>'
;
echo
'<td width="80%" align="left"><table width="90%" border="0" cellspacing="0" cellpadding="0">'
;
echo
'<tr>'
;
echo
'<td align="left"><a class="warsbox" href="index.php?wars-more-'
.
$row
->id.
'">'
.
$row
->tag.
'</a></td>'
;
echo
'</tr>'
;
echo
'<tr>'
;
echo
'<td height="1" bgcolor="#000000"></td>'
;
echo
'</tr>'
;
echo
'<tr>'
;
echo
'<td height="1" bgcolor="#666666"></td>'
;
echo
'</tr>'
;
echo
'<tr>'
;
echo
'<td align="left" class="vor">am: <span class="datum">'
.
$row
->time.
' Uhr</span></td>'
;
echo
'</tr>'
;
echo
'</table></td>'
;
echo
'</tr>'
;
}
}
echo
'</table>'
;
?>