On Wed, Jul 23, 2008 at 12:10 PM, <[EMAIL PROTECTED]> wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-----------------+-----------+
> | ip | count(ip) |
> +-----------------+-----------+
> | 83.117.196.206 | 1 |
> | 85.17.109.28 | 1 |
> | 125.138.96.19 | 1 |
> | 89.110.148.253 | 1 |
> | 192.168.105.10 | 1 |
> | 200.170.124.72 | 1 |
> | 201.116.98.214 | 1 |
> | 202.168.255.226 | 1 |
> | 203.89.243.158 | 1 |
> | 210.245.207.217 | 1 |
> +-----------------+-----------+
> 10 rows in set (0.00 sec)
Okay, this would have to be done in code, and isn't a MySQL issue.
Presuming you're using PHP, I'm going to also copy this message to
the PHP General mailing list, Payne, so that others can benefit from
it in the archives as well. If you're not already subscribed and
would like to follow along with the thread, please send a blank
message to [EMAIL PROTECTED]
To get the Class C on that, here's a simple function you can use:
<?php
function get_subnet($ip) {
return substr($ip,0,strrpos($ip,'.'));
}
?>
As a quick illustration of how it works, here's an example script
(to use MySQL, just replace the $ips array with your <?php $row =
mysql_fetch_array($result); ?> or similar line):
<?php
$ips =
array('192.168.0.0','10.0.0.1','127.0.0.1','216.37.159.240','99.99.99.99','127.0.0.2','192.168.1.1','10.0.0.0','192.168.0.1','192.168.0.150');
function get_subnet($ip) {
return substr($ip,0,strrpos($ip,'.'));
}
foreach($ips as $ip) {
echo $ip."'s Class C is ".get_subnet($ip)."\n";
}
?>
--
</Daniel P. Brown>
Better prices on dedicated servers:
Intel 2.4GHz/60GB/512MB/2TB $49.99/mo.
Intel 3.06GHz/80GB/1GB/2TB $59.99/mo.
Dedicated servers, VPS, and hosting from $2.50/mo.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
