[ADDON] Ubercms - Kloncheck

<?php
/*=======================================================================
| UberCMS - Advanced Website and Content Management System for uberEmu
| #######################################################################
| Copyright (c) 2010, Roy 'Meth0d' and updates by Matthew 'MDK'
| http://www.meth0d.org & http://www.sulake.biz
| #######################################################################
| This program is free software: you can redistribute it and/or modify
| it under the terms of the GNU General Public License as published by
| the Free Software Foundation, either version 3 of the License, or
| (at your option) any later version.
| #######################################################################
| This program is distributed in the hope that it will be useful,
| but WITHOUT ANY WARRANTY; without even the implied warranty of
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
| GNU General Public License for more details.
\======================================================================*/

$max_allowed_per_ip = "1";  //Edit this for allow more/less Users per IP!


if (!defined('IN_HK') || !IN_HK)
{
        exit;
}

if (!HK_LOGGED_IN || !$users->hasFuse(USER_ID, 'fuse_housekeeping_moderation'))
{
        exit;
}

require_once "top.php";

echo '<h1>Clone Checker</h1>
<br /><p>This is for looking after Clones.<br>Banned Users won't be show.</p>';


$result=mysql_query("SELECT ip_last, count(ip_last) AS counthits FROM users GROUP BY ip_last ORDER BY count(ip_last) DESC");
?>
<table border="1">
<th>&nbsp;IP&nbsp;</th><th>&nbsp;Anzahl&nbsp;</th><th>&nbsp;User&nbsp;</th>
<?php
while($row=mysql_fetch_array($result)) {
$count = "0";
$countdif = 1;
    if ($row["counthits"] > $max_allowed_per_ip AND $row["ip_last"] !="") {
$username = mysql_query("SELECT username FROM users WHERE ip_last = '".$row["ip_last"]."'");
while($name=mysql_fetch_object($username)) {
$banned_yet_res=mysql_query("SELECT * FROM bans WHERE bantype='user' AND value= '".$name->username."'");
$banned_yet=mysql_fetch_object($banned_yet_res);
if(isset($banned_yet->id)) {
$count++ ;
}}
$countdif = $row["counthits"] - $count;
if($countdif > 1) {
?>
<tr>
<td bgcolor="#FF0000">
<form method="post" action="index.php?_cmd=iptool" >
<button name="ip" type="submit" style="border:0; background-color:#FF0000; text-decoration:underline; cursor:pointer;" value="<?php echo $row["ip_last"] ?>" ><?php echo $row["ip_last"] ?></button>
</form>
</td><td>
<?php echo  $row["counthits"]-$count;
?>
</td>
<td>
<?php
$username = mysql_query("SELECT username FROM users WHERE ip_last = '".$row["ip_last"]."'");
while($name=mysql_fetch_object($username)) {
$banned_yet_res=mysql_query("SELECT * FROM bans WHERE bantype='user' AND value= '".$name->username."'");
$banned_yet=mysql_fetch_object($banned_yet_res);
if(isset($banned_yet->id)) {
$count++ ;
}}


$username = mysql_query("SELECT username FROM users WHERE ip_last = '".$row["ip_last"]."'");
while($name=mysql_fetch_object($username)) {
$banned_yet_res=mysql_query("SELECT * FROM bans WHERE bantype='user' AND value= '".$name->username."'");
$banned_yet=mysql_fetch_object($banned_yet_res);
if(!isset($banned_yet->id)) {
?>
<form method="post" action="index.php?_cmd=iptool" >
<button name="user" type="submit" style="border:0; background-color:#FFFFFF; text-decoration:underline; cursor:pointer;" value="<?php echo $name->username ?>" ><?php echo $name->username ?></button>
</form>
<hr>
<?php
}}}
?>
</td>
</tr>

<?php
    }
} ?>
</table>
<p align="center"><b><font size="+1">Coded by <a href="http://beta.habbix.net.tf">flx5</a></font></b></p>
<?php
require_once "bottom.php";

?>

<li><a href="index.php?_cmd=iptool">IP address tool</a></li>

<li><a href="index.php?_cmd=clonecheck">Clone Checker</a></li>