<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
$row = Array('mensaje'=>"192.168.1.1 192.168.1.2 192.168.1.2 192.168.1.3 192.168.1.3 192.168.1.3 192.168.1.4 192.168.1.4 192.168.1.4 192.168.1.4 192.168.1.5 192.168.1.5 192.168.1.5 192.168.1.5 192.168.1.5 192.168.1.6 192.168.1.6 192.168.1.6 192.168.1.6 192.168.1.6 192.168.1.6 ");

$Aips = Array();
//$stmt = $mysqli->prepare("SELECT mensaje FROM tabla");
//$stmt->execute();
//if ($result = $stmt->get_result()){
//  while ($row = $result->fetch_assoc()){
        if (preg_match_all("/((?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?))/",$row['mensaje'],$matches)){
            foreach ($matches[0] as $ip){
                if (!isset($Aips[$ip])){
                    $Aips[$ip] = 1;
                } else {
                    $Aips[$ip]++;
                }
            }
        }
//  }
//  $result->free();
//}
//$stmt->close();

arsort($Aips);

$i = 0;
foreach ($Aips as $ip=>$count){
    if ($i >= 10){
        break;
    }
    echo $ip." - ".$count;
    echo "<br>";
    $i++;
}
unset($Aips);

?>