Mein Rally System sieht nun so aus:
PHP-Code:
<?
// Rallys abfragen
$ref=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='refralley'"));
$klick=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='klickralley'"));
$t_klick=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='tagklickralley'"));
$w_klick=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='woklickralley'"));
$bettel=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='bettelralley'"));
$aktiv=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='aktivralley'"));
$mail=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='mailralley'"));
$tagrally=mysql_fetch_array(mysql_query("SELECT start, ende, ralley FROM ".$db_prefix."_ralleydaten WHERE ralley='tagrally'"));
?>
<?menuehead("Ralley System")?>
<? if ($aktiv[ende]>= time() and $aktiv[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/aktiv">Aktiv Rally</a><br>
<? if ($bettel[ende]>= time() and $bettel[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/bettel">Bettel Rally</a><br>
<? if ($klick[ende]>= time() and $klick[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/klick">Klick Rally</a><br>
<? if ($mail[ende]>= time() and $mail[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/mail">Mail Rally</a><br>
<? if ($ref[ende]>= time() and $ref[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/ref">Ref Rally</a><br>
<? if ($t_klick[ende]>= time() and $t_klick[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/tag_klick">Tages Rally</a><br>
<? if ($w_klick[ende]>= time() and $w_klick[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/wo_klick">Wochen Rally</a><br>
<? if ($tagrally[ende]>= time() and $tagrally[start]<= time()){echo"<img src='images/gruen.gif' alt='on' border='0'>";} else{echo"<img src='images/rot.gif' alt='off' border='0'>";}?>
<a href="?content=/ralleys/tagesklick">Tages Klick Rally</a><br>
<?menuefoot();?>
Nun ist die Frage wo muss ich da das wie es oben steht einbauen dass die Rallys die Farben wechseln, also sprich orange als beispiel, wenn sie bald starten oder gerade beendet wurden?
LG
Zitieren