<?php
    $host="46.218.144.13"; // Host name
    $db_username="papao348570"; // Mysql username
    $db_password="aspirin6"; // Mysql password
    $db_name="papao348570"; // Database name
    $tbl_name="members"; // Table name

    if($_GET['week']){
        $week = $_GET['week'];
    } else {
        $week = 1;
    }

    $connect=mysql_connect("$host", "$db_username", "$db_password") or die(mysql_error());
    mysql_select_db("$db_name") or die(mysql_error());

    // Recupération de toutes les équipes supportées
    $sql="SELECT DISTINCT first_team FROM members UNION SELECT DISTINCT second_team FROM members";
    $result=mysql_query($sql);
    $i=0;
    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
        $team[$i] = $row[0];
        $i++;
    }

    $req="SELECT DISTINCT date FROM planning WHERE week=$week ORDER BY date";
    $r=mysql_query($req);
    while ($row_date = mysql_fetch_array($r, MYSQL_NUM)) {
        $sql="SELECT * FROM planning WHERE date='$row_date[0]'";
        $result=mysql_query($sql);
        echo '<br /><br /><table cellspacing="0">
            <div align="left"><span style="color:#808080; letter-spacing:4px; font-size:15px">'.date("d/m/Y", strtotime($row_date[0])).' week '.$week.'</span></div>';
        while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
            $stadium=$row[7];
            $network=$row[5];
            $home_team=$row[1];
            $visitor_team=$row[2];
            $sql="SELECT * FROM teams WHERE id=$row[1]";
            $res=mysql_query($sql);
            $row_team = mysql_fetch_row($res);
            $home_team_logo = $row_team[3];
            $home_team_nom = $row_team[1];
            $home_team_ville = $row_team[2];
            $sql="SELECT * FROM teams WHERE id=$row[2]";
            $res=mysql_query($sql);
            $row_team = mysql_fetch_row($res);
            $visitor_team_logo = $row_team[3];
            $visitor_team_nom = $row_team[1];
            $visitor_team_ville = $row_team[2];

            if(($_SESSION['team1']==$row[1])||($_SESSION['team1']==$row[2])||($_SESSION['team2']==$row[1])||($_SESSION['team2']==$row[2])) {
                // en rouge
                echo '<tr border="1"><tr height="44" valign="middle" bgcolor="#FFCCCC">
                      <td align="center" width="8%" bgcolor="#E5B9B9"><span style="color:#696969">'.$row[4].'</span></td>';
            } else {
                foreach ($team as $value) {
                    if(($value==$row[1])||($value==$row[2])) {
                        $flag_trouve = true;
                    }
                }
                if($flag_trouve) {
                    // en bleu
                    echo '<tr height="44" valign="middle" bgcolor="#ADC8FF">
                    <td align="center" width="8%" bgcolor="#9EB6E5"><span style="color:#696969">'.$row[4].'</span></td>';
                    $flag_trouve = false;
                } else {
                    // en jaune
                    echo '<tr height="44" valign="middle" bgcolor="#FFFFCC">
                    <td align="center" width="8%" bgcolor="#E5E5B9"><span style="color:#696969">'.$row[4].'</span></td>';
                    $flag_trouve = false;
                }
            }
            echo '  <td align="center" width="200"><span style="font-weight:bold; letter-spacing:4px; font-size:15px">'.strtoupper($visitor_team_nom).'</span><br /><span style="color:grey; font-weight:normal; letter-spacing:4px; font-size:10px">'.$visitor_team_ville.'</span></td>
                    <td align="center" width="45"><img src="/teams_logo/'.strtolower($visitor_team_nom).'.png" alt="" height="28" /></td>
                    <td align="center" width="14">vs</td>
                    <td align="center" width="45"><img src="/teams_logo/'.strtolower($home_team_nom).'.png" alt="" height="28" /></td>
                    <td align="center" width="200"><span style="font-weight:bold; letter-spacing:4px; font-size:15px">'.strtoupper($home_team_nom).'</span><br /><span style="color:grey; font-weight:normal; letter-spacing:4px; font-size:10px">'.$home_team_ville.'</span></td>';
            $flag_trouve = false;
            if(($_SESSION['team1']==$row[1])||($_SESSION['team1']==$row[2])||($_SESSION['team2']==$row[1])||($_SESSION['team2']==$row[2])) {
                $flag_trouve = true;
            } else {
                foreach ($team as $value) {
                    if(($value==$row[1])||($value==$row[2])) {
                        $flag_trouve = true;
                    }
                }
            }
            if($flag_trouve) {
                $btn_prono = '<a href="#"><img src="error.png" alt="" title="Tous les pronostics ne sont pas placés !" /></a><a href="#"><img src="add.png" alt="" title="Placer un prono" /></a>';
            } else {
                $btn_prono = '';
            }
            echo '<td width="16">'.$btn_prono.'</td>';
            $flag_trouve = false;
            echo '  </tr>';
            if(($_SESSION['team1']==$row[1])||($_SESSION['team1']==$row[2])||($_SESSION['team2']==$row[1])||($_SESSION['team2']==$row[2])) {
                // en rouge
                echo '<tr bgcolor="#E5B9B9"><td align="left" colspan="7"><span style="color:#696969; font-size:10px">Stadium : <strong>'.$stadium.'</strong> | Network : <strong>'.$network.'</strong></span></td></tr></tr>';
            } else {
                foreach ($team as $value) {
                    if(($value==$row[1])||($value==$row[2])) {
                        $flag_trouve = true;
                    }
                }
                if($flag_trouve) {
                    // en bleu
                    echo '<tr bgcolor="#9EB6E5"><td align="left" colspan="7"><span style="color:#696969; font-size:10px">Stadium : <strong>'.$stadium.'</strong> | Network : <strong>'.$network.'</strong></span></td></tr></tr>';
                    $flag_trouve = false;
                } else {
                    // en jaune
                    echo '<tr bgcolor="#E5E5B9"><td align="left" colspan="7"><span style="color:#696969; font-size:10px">Stadium : <strong>'.$stadium.'</strong> | Network : <strong>'.$network.'</strong></span></td></tr></tr>';
                    $flag_trouve = false;
                }
            }
        }
        echo '</table>';
    }
    mysql_free_result($result);
?>