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 32 33 34 35 36 37 38 39 40
| <?php
//------- Création liste IP dans ipList.txt
$file = fopen('ipList.txt', 'w');
while($data = mysql_fetch_assoc($req))
{
fputs($file, $data['IPADDR']."\n");
}
fclose($file);
//------- Verification dispo ipList & execution de fping + exportation dans ipUp.txt
while (!is_writable('ipList.txt')) {
sleep(0.5);
}
`fping -a < ipList.txt > ipUp.txt`;
//------- Verification dispo ipUp
while (!is_writable('ipUp.txt')) {
sleep(0.5);
}
//------- Lecture ipUp vers tableau
$tableauIP = file('ipUp.txt');
//------- Envoi de la requête
$sqlReset = 'UPDATE hardware SET STATUSPING=\'DOWN\'';
$reqReset = mysql_query($sqlReset) or die('Erreur SQL !<br>'.$sqlReset.'<br>'.mysql_error());
foreach ($tableauIP as $ipOK)
{
$sqlUP = 'UPDATE hardware SET STATUSPING=\'UP\' WHERE IPADDR=\''.$ipOK.'\'';
$reqUP = mysql_query($sqlUP) or die('Erreur SQL !<br>'.$sqlUP.'<br>'.mysql_error());
}
?> |
Partager