Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <?php # Copyright by Manuel # Support www.ilch.de defined ( 'main' ) or die ( 'no direct access' ); echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">' ; $akttime = date ( 'Y-m-d' ); $erg = db_query( "SELECT DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time, id, game FROM prefix_wars WHERE status = 1 AND datime > '" . $akttime . "' ORDER BY datime" ); if ( db_num_rows( $erg ) == 0 ) { echo '<tr><td>kein War geplant</td></tr>' ; } else { while ( $row = db_fetch_object( $erg ) ) { echo '<tr>' ; echo '<td><a class="box" href="?m=wars&mehr=' . $row ->id. '"><img src="include/images/icons/' . $row ->game. '" border=0>' ; echo $row ->time. '</a></td></tr>' ; } } echo '</table>' ; ?> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | <?php # Copyright by Manuel # Support www.ilch.de defined ( 'main' ) or die ( 'no direct access' ); echo '<table width="100%" border="0" cellpadding="2" cellspacing="0">' ; $erg = db_query( 'SELECT * FROM prefix_wars WHERE status = "2" ORDER BY datime DESC LIMIT 5' ); while ( $row = db_fetch_object( $erg ) ) { if ( $row ->wlp == 1) { $farbe = 'C8E1B8' ; $farb2 = '00FF00' ; } elseif ( $row ->wlp == 2) { $farbe = 'D8B9B9' ; $farb2 = 'FF0000' ; } elseif ( $row ->wlp == 3) { $farbe = 'FDFBB7' ; $farb2 = 'FFFF00' ; } echo '<tr><td style="border: solid #' . $farb2 . ' 1px; background-color: #' . $farbe . '; ">' ; echo '<a style="color: #000000;" href="?m=wars&mehr=' . $row ->id. '"><img src="include/images/icons/' . $row ->game. '" border=0>' ; echo $row ->owp. ' zu ' . $row ->opp. ' - ' . $row ->gegner. '</a></td></tr>' ; } echo '</table>' ; ?> |
1 | <img src="include/images/icons/'.$row->game.'" border=0>'; |
1 | <img src="include/images/icons/'.$row->game.'.gif" border=0>'; |
Geschlossen | ||
![]() |
Zurück zu HTML, PHP, SQL,... |