1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
$result4 = mysql_query("SELECT valeur, HOUR(date)as heure, MINUTE(date) as minute, etat_trafic, logs_trafic.id_interface, date FROM logs_trafic WHERE logs_trafic.id_interface = '$ligne[6]' AND date BETWEEN date(now() - INTERVAL 7 DAY) AND now()");
while ($ligne1 = mysql_fetch_array($result4)) {
if (($date1 == $ligne1[1]) && ($date2 == $ligne1[2]) && ($ligne1[3] == 'normal') )
{
if ((($d > $ligne1[0] + $vcomparaison) || ($d < $ligne1[0] - $vcomparaison)))
{
echo "<tr style='font-size:small;padding:5px;vertical-align:top;#000000;background-color:#FFFFFF';color:black;><td><b>$ligne[2] <font color=\"chartreuse\">$e</font> </b></td><td style='font-size:small;padding:5px;vertical-align:top;#000000;border-right: 1px solid black;background-color:#FFFFFF';color:black;></td><td><font color=\"red\">$d</font> Mo/s</b></td></tr></br>";
$result8 = mysql_query("INSERT INTO logs_trafic (id_logs, date, id_interface, etat_interface, etat_trafic, valeur) VALUES ('', '$date', '$ligne[6]', 'Up', 'anormal', '$d')");
}
}
else if (($date1 != $ligne1[1]) AND ($date2 != $ligne1[2]))
{
echo "<tr style='font-size:small;padding:5px;vertical-align:top;#000000;background-color:#FFFFFF';color:black;><td><b>$ligne[2] <font color=\"chartreuse\">$e</font> </b></td><td style='font-size:small;padding:5px;vertical-align:top;#000000;border-right: 1px solid black;background-color:#FFFFFF';color:black;></td><td><font color=\"chartreuse\">$d</font> Mo/s</b></td></tr></br>";
$result7 = mysql_query("INSERT INTO logs_trafic (id_logs, date, id_interface, etat_interface, etat_trafic, valeur) VALUES ('', '$date', '$ligne[6]', 'Up', 'normal', '$d')");
}
} |
Partager