<?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(); ?>