
12-11-2007, 20:36
|
|
|
|
חבר מתאריך: 09.10.06
הודעות: 13
|
|
קוד:
while ($select = mysql_fetch_array ($q))
{
echo "
<tr>
<td bgcolor='#F0F0F0' align=right width=100>";
//$selectit = mysql_query("SELECT * FROM resultboard WHERE id=5");
//$select = mysql_fetch_array($selectit,MYSQL_ASSOC);
$timegame = $select[time];
$curtime = new tTime();
$curtime->vTime = date("l:H:m");
$curtime->fInit();
$curtime->fCalculate();
$gametime = new tTime();
$gametime->vTime = $select["time"];
$gametime->fInit();
$gametime->fCalculate();
$datenow = $curtime->minu;
$timegame = $gametime->minu;
if ($datenow-$timegame >= 0 && $datenow-$timegame < 45)
echo "מחצית ראשונה";
else if ($datenow-$timegame == 45 && $datenow-$timegame <= 60)
echo "מחצית";
else if ($datenow-$timegame > 60 && $datenow-$timegame < 105)
echo "מחצית שנייה";
else if ($datenow-$timegame >= 105)
echo "הסתיים";
else
echo "לא התחיל";
class tTime
{
var $vTime;
var $day;
var $hour;
var $minu;
function fInit(){
list($this->day,$this->hour,$this->minu) = explode(":",$this->vTime);}
function fCalculate(){
$this->minu = $this->minu + ($this->hour + $this->day * 24) * 60;}
}
echo "</td>
<td bgcolor='#F0F0F0' align=right width=250><font size=2><Font face=arial><font color=black><div align=center>$select[homename]</td>
<td bgcolor='#F0F0F0' align=right width=90><font size=2><Font face=arial><font color=black><div align=center><a href='profile_game.php?gameID=$select[id]'>$select[result]</a></td>
<td bgcolor='#F0F0F0' align=right width=250><font size=2><Font face=arial><font color=black><div align=center>$select[awayname]</td>
</tr>
";
}
|