\n"; echo "\n"; echo "\n"; echo "\t", $config['title'], "\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\t\n"; echo "\n"; echo "\n"; echo "

\n"; // Fail2BanCount - Displays information from the database // I won't claim this is all my original code, as it has // been borrowed from various places online. Use it as you // like. // Database connection info $db_host = $config['mysqlhost']; $db_user = $config['mysqluser']; $db_pwd = $config['mysqlpw']; $database = $config['mysqldb']; // Page variable $page = htmlspecialchars($_GET["page"]); $sortBy = htmlspecialchars($_GET["sortBy"]); $order = htmlspecialchars($_GET["order"]); $newOrder = testOrder($order); if ($order == 'a') { $order = 'asc'; } else { $order = 'desc'; } function testOrder($order) { if ($order == 'd') { return 'a'; } else { return 'd'; } } function n_print($data, $name = '') { $aBackTrace = debug_backtrace(); echo '

', $name, '

'; echo '

'; echo '', basename($aBackTrace[0]['file']), ' ligne => ', $aBackTrace[0]['line'], ''; echo '

',   htmlentities(print_r($data, 1)), '

'; echo '

'; } // Connect to MySQL if (!$db = mysqli_connect($db_host, $db_user, $db_pwd)) { die("Can't connect to database"); } if (!mysqli_select_db($db, $database)) { mysqli_close($db); die("Can't select database"); } // Get some information from the database // Find IPs banned more than once $multiplebans = 1; // Find the IPs currently banned // Find the total number of IPs banned $totalbans = mysqli_query($db, "SELECT MAX(id) FROM bans"); if (!$totalbans) { die("Query failed.3"); } while ($row = mysqli_fetch_array($totalbans)) { $numbans = $row['MAX(id)']; } // Find the total number of IPs unbanned $totalunbans = mysqli_query($db, "SELECT MAX(id) FROM unbans"); if (!$totalunbans) { die("Query failed.4"); } while ($row = mysqli_fetch_array($totalunbans)) { $numunbans = $row['MAX(id)']; } $currentlybanned = $numbans - $numunbans; if ($currentlybanned != 1) { $grammer = "IPs are"; } else { $grammer = "IP is"; } // Get day with ban function getDayWithBan($db) { $getDayWithBan = mysqli_query($db, "SELECT DISTINCT ban_date FROM bans ORDER BY ban_date"); while ($rows = mysqli_fetch_assoc($getDayWithBan)) { $allDate[] = $rows['ban_date']; } if (empty($allDate)) { $allDate = array(); } return $allDate; } function printFlag($countryCode) { if (empty($countryCode)) { return ''; } elseif (file_exists('img/flag/16/'.strtolower($countryCode).'.png')) { return '

'; } else { return 'Unknown

'; } } // Find the number of currently banned IP's using subtraction. // I'm sure I can do this with a single MySQL query and get // rid of the above 2 queries all together. $currentlybanned = $numbans - $numunbans; // Print some HTML echo "\t

", $config['title'], "

\n"; echo "

\n"; echo "\t

$numbans IPs have been banned since $config[launchDate]

\n"; // Menu echo "\t

\n"; echo "\t\t

\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t\t\n"; echo "\t\t

\n"; echo "\t

\n"; if ($page === 'home' || empty($page)) { require 'page/home.php'; } if ($page === 'recidivist') { require 'page/recidivist.php'; } if ($page === 'currentBan') { require 'page/currentBan.php'; } if ($page === 'lastBan') { require 'page/lastBan.php'; } if ($page === 'topTen') { require 'page/topTen.php'; } if ($page === 'topTenService') { require 'page/topTenService.php'; } if ($page === 'allBans') { require 'page/allBans.php'; } echo "

\n"; echo '

Go top

'; $stop = microtime(true); $total = round($stop - $start, 4); echo 'Generate in ', $total, ' secondes
'; echo "\n"; echo "\n"; echo "\n"; ?>