function ParseHostnames_hours($servername) { $q = new nginx_stats($servername); $hourstables = $q->LIST_TABLES_HOURS_TEMP(); while (list($tablename, $rows) = each($hourstables)) { $sql = "SELECT ipaddr FROM `{$tablename}` WHERE LENGTH(hostname)=0 GROUP BY `ipaddr`"; $results = $q->QUERY_SQL($sql); while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { $ipaddr = $ligne["ipaddr"]; if (!isset($GLOBALS[$ipaddr])) { $GLOBALS[$ipaddr] = gethostbyaddr($ipaddr); } $q->QUERY_SQL("UPDATE `{$tablename}` SET `hostname`='{$GLOBALS[$ipaddr]}' WHERE `ipaddr`='{$ipaddr}'"); } } }