Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?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(mysql_error());
if (!mysql_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 = mysql_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 = mysql_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(mysql_error());
if (!mysql_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 = mysql_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
`" . _VMS_ . "_kontodaten` AS k
LEFT JOIN `" . _VMS_ . "_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 = mysql_fetch_assoc($md5)) {
echo "<a href='?content=/usersystem/userbearbeiten&uid=" . $doppelt['uid'] . "'>" . $doppelt['nickname'] . "</a><br>";
}
}
foot();
?>