Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||
Do. 18.01.2007
02:07 Uhr
#1
Do. 18.01.2007
16:37 Uhr
#2
SELECT * FROM prefix_wars WHERE status = "3" ORDER BY datime DESC LIMIT 3
SELECT *FROM prefix_wars WHERE STATUS = "3" AND tid = "4" ORDER BY datime DESC LIMIT 3
Do. 18.01.2007
17:20 Uhr
#3
SELECT *FROM prefix_wars WHERE STATUS = "3" AND tid = "1" AND tid = "2" AND tid = "3"ORDER BY datime DESC LIMIT 3
Do. 18.01.2007
18:14 Uhr
#4
Do. 18.01.2007
18:17 Uhr
#5
Sa. 24.11.2007
17:57 Uhr
#6
<?php
# Copyright by Manuel
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$farbe = '';
$farb2 = '';
echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">';
$erg = db_query('SELECT *FROM prefix_wars WHERE STATUS = "3" AND tid = "1" AND tid = "2" AND tid = "3"ORDER BY datime DESC LIMIT 3');
while ($row = db_fetch_object($erg) ) {
$row->tag = ( empty($row->tag) ? $row->gegner : $row->tag );
if ($row->wlp == 1) {
$farbe = 'C8E1B8';
$farb2 = '00aa00';
} elseif ($row->wlp == 2) {
$farbe = 'e8bbb7';
$farb2 = 'EE0000';
} elseif ($row->wlp == 3) {
$farbe = 'FDFBB7';
$farb2 = 'FF9900';
}
echo'<tr><td>'.get_wargameimg($row->game).'</td><td align="left" style="background: #'.$farbe.';">';
echo'<a style="color: #'.$farb2.';" href="index.php?wars-more-'.$row->id.'">';
echo $row->owp.' '.$lang['at2'].' '.$row->opp.' - '.$row->tag.'</a></td></tr>';
}
echo '</table>';
?>
So. 25.11.2007
13:00 Uhr
#8
$erg = db_query('SELECT *FROM prefix_wars WHERE STATUS = "3" AND tid = "1" (OR tid = "2" OR tid = "3")ORDER BY datime DESC LIMIT 3');
| Geschlossen | ||
 |
Zurück zu Module und Modifikationen | |