<?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 = sql::$db->query("SELECT `login_ip`, COUNT(*) AS `anzahl` FROM  `" . _VMS_ . "_kontodaten` GROUP BY `login_ip` HAVING COUNT(*) > 1") or die($sql->errorInfo());
if ($sql->rowCount() == 0) {
    echo '
 <tr>
     <td colspan="2" align="center"><font color="green">Keine Doppelten IP-Adressen im System</font></td>
 </tr>';
} else {
    while ($fake1 = $sql -> fetch() ) {
        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 (isset($_GET['ip'])) {
    $ip = sql::$db->prepare("SELECT k.uid,u.nickname FROM
                        " . _VMS_ . "_kontodaten AS k
                        LEFT JOIN " . _VMS_ . "_userdaten AS u ON u.uid=k.uid
WHERE k.login_ip=:ip");
    $ip->bindParam(':ip', $_GET['ip'], PDO::PARAM_STR);
    $ip->execute();

    echo "<p>User mit der IP " . $_GET['ip'] . ":</p>";
    while ($doppelt = $ip -> fetch() ) {
        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 = sql::$db->query("SELECT `passwort`, COUNT(*) AS `anzahl` FROM  `" . _VMS_ . "_kontodaten` GROUP BY `passwort` HAVING COUNT(*) > 1") or die($sql->errorInfo());
if ($sql2->rowCount() == 0) {
    echo '
 <tr>
     <td colspan="2" align="center"><font color="green">Keine doppelten Passwörter im System</font></td>
 </tr>';
} else {
    while ($fake2 = $sql2->fetch(PDO::FETCH_ASSOC) ) {
        echo '
   <tr>
       <td>' . $fake2['anzahl'] . '</td>
       <td><a href="?content=/usersystem/doppelaccis&md5=' . $fake2['passwort'] . '">' . $fake2['passwort'] . '</a></td>
   </tr>
 ';
    }
}

?>
</table>

<?php
if (isset($_GET['md5'])) {
    $md5 = sql::$db->prepare("SELECT k.uid,u.nickname FROM
                        `" . _VMS_ . "_kontodaten` AS k
                        LEFT JOIN `" . _VMS_ . "_userdaten` AS u ON u.uid=k.uid
WHERE k.passwort=:md5");
    $md5->bindParam(':md5', $_GET['md5'], PDO::PARAM_STR);
    $md5->execute();

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

foot();
?>