forked from hswno/kofradia
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ip_ban.php
30 lines (24 loc) · 1.1 KB
/
ip_ban.php
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
<?php
require "../base.php";
global $_base;
$_base->page->add_title("IP Ban");
if (isset($_GET['active']))
{
\Kofradia\DB::get()->query("SELECT bi_id, INET_NTOA(bi_ip_start) AS ip_range_start, IF(bi_ip_end=bi_ip_start,NULL,INET_NTOA(bi_ip_end)) AS ip_range_end, FROM_UNIXTIME(bi_time_start) AS time_start, FROM_UNIXTIME(bi_time_end) AS time_end, bi_reason, bi_info FROM ban_ip WHERE ISNULL(bi_time_end) OR bi_time_end >= UNIX_TIMESTAMP() ORDER BY bi_time_end = 0, bi_time_end DESC")->debug();
die;
}
elseif (isset($_GET['inactive']))
{
\Kofradia\DB::get()->query("SELECT bi_id, INET_NTOA(bi_ip_start) AS ip_range_start, IF(bi_ip_end=bi_ip_start,NULL,INET_NTOA(bi_ip_end)) AS ip_range_end, FROM_UNIXTIME(bi_time_start) AS time_start, FROM_UNIXTIME(bi_time_end) AS time_end, bi_reason, bi_info FROM ban_ip WHERE bi_time_end != 0 AND bi_time_end < UNIX_TIMESTAMP() ORDER BY bi_time_end DESC")->debug();
die;
}
else
{
echo '
<h1>IP ban</h1>
<ul>
<li><a href="ip_ban?active">Vis aktive IP-ban oppføringer</a></li>
<li><a href="ip_ban?inactive">Vis gamle IP-ban oppføringer</a></li>
</ul>';
}
$_base->page->load();