1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
<?php
if ($type === '~poweron') {
$subnet = Request::post('subnet', false, 'string');
if ($subnet !== false && ($subnet = explode('/', $subnet)) !== false && count($subnet) === 2
&& $subnet[0] === $ip && $subnet[1] >= 8 && $subnet[1] < 32) {
$start = ip2long($ip);
if ($start !== false) {
$maskHost = (int)(pow(2, 32 - $subnet[1]) - 1);
$maskNet = ~$maskHost & 0xffffffff;
$end = $start | $maskHost;
$start &= $maskNet;
$netparams = ['start' => sprintf('%u', $start), 'end' => sprintf('%u', $end), 'now' => $NOW];
$affected = Database::exec('UPDATE reboot_subnet
SET lastseen = :now, seencount = seencount + 1
WHERE start = :start AND end = :end', $netparams);
if ($affected === 0) {
// New entry
Database::exec('INSERT INTO reboot_subnet (start, end, fixed, isdirect, lastseen, seencount)
VALUES (:start, :end, 0, 0, :now, 1)', $netparams);
}
}
}
}
|