<?php head("Doppelte IP Adressen");?>
<table border="0" width="100%">
<tr>
    <td align="center"><b>Anzahl</b></td>
    <td align="center"><b>IP-Adresse</b></td>
</tr>
<?php
$sql = db_query("SELECT `login_ip`, COUNT(*) AS `anzahl` FROM  `" . $db_prefix . "_kontodaten` GROUP BY `login_ip` HAVING COUNT(*) > 1") or die(mysqli_error());
if (!mysqli_num_rows($sql)) {
    echo '
 <tr>
     <td colspan="2" align="center"><font color="green">Keine Doppelten IP-Adressen im System</font></td>
 </tr>';
} else {
    while ($fake1 = mysqli_fetch_assoc($sql)) {
        echo '
   <tr>
       <td>' . $fake1['anzahl'] . '</td>
       <td><a href="?content=/usersystem/doppelaccis&ip=' . $fake1['login_ip'] . '">' . $fake1['login_ip'] . '</a></td>
   </tr>
 ';
    }
}

?>
</table>
<?php
if ($_GET['ip']) {
    $ip = db_query("SELECT k.uid,u.nickname FROM
                        " . $db_prefix . "_kontodaten AS k
                        LEFT JOIN " . $db_prefix . "_userdaten AS u ON u.uid=k.uid
WHERE k.login_ip='" . addslashes($_GET['ip']) . "'");

    echo "<p>User mit der IP " . $_GET['ip'] . ":</p>";
    while ($doppelt = mysqli_fetch_assoc($ip)) {
        echo "<a href='?content=/usersystem/userbearbeiten&uid=" . $doppelt['uid'] . "'>" . $doppelt['nickname'] . "</a><br>";
    }
}

foot();
?>



<?php head("Doppelte Passwörter");?>
<table border="0" width="100%">
<tr>
    <td align="center"><b>Anzahl</b></td>
    <td align="center"><b>md5Hash</b></td>
</tr>
<?php
$sql2 = db_query("SELECT `passwort`, COUNT(*) AS `anzahl` FROM  `" . $db_prefix . "_kontodaten` GROUP BY `passwort` HAVING COUNT(*) > 1") or die(mysqli_error());
if (!mysqli_num_rows($sql)) {
    echo '
 <tr>
     <td colspan="2" align="center"><font color="green">Keine Doppelten Passwörter im System</font></td>
 </tr>';
} else {
    while ($fake2 = mysqli_fetch_assoc($sql2)) {
        echo '
   <tr>
       <td>' . $fake2['anzahl'] . '</td>
       <td><a href="?content=/usersystem/doppelaccis&md5=' . $fake2['passwort'] . '">' . $fake2['passwort'] . '</a></td>
   </tr>
 ';
    }
}

?>
</table>

<?php
if ($_GET['md5']) {
    $md5 = db_query("SELECT k.uid,u.nickname FROM
                        " . $db_prefix . "_kontodaten AS k
                        LEFT JOIN " . $db_prefix . "_userdaten AS u ON u.uid=k.uid
WHERE k.passwort='" . addslashes($_GET['md5']) . "'");

    echo "<p>User mit dem Passworthash " . $_GET['md5'] . ":</p>";
    while ($doppelt = mysqli_fetch_assoc($md5)) {
        echo "<a href='?content=/usersystem/userbearbeiten&uid=" . $doppelt['uid'] . "'>" . $doppelt['nickname'] . "</a><br>";
    }
}

foot();
?>