hier der code neue datei anlegen(ip_suche ) und im adminforce/?content=/usersystem/ip_suche speichern.
PHP-Code:
<? head ('Doppelte Log_in IP\'s im System'); ?>
<table align="center" width="90%" border=1 bgcolor="#ffffff" bordercolor="#000000" style="border-collapse: collapse;" cellspacing=1 cellpadding=1>
<tr bgcolor="#cfcfcf">
<td width="25%" align="center"><b>Anzahl</b></td>
<td width="25%" align="center"><b>User 1</b></td>
<td width="25%" align="center"><b>User 2</b></td>
<td width="25%" align="center"><b>IP der User</b></td>
</tr>
<?
$sql = db_query ("SELECT COUNT( uid ) AS anzahl, uid, SUM( uid ) AS uid2, login_ip FROM `".$db_prefix."_kontodaten` WHERE login_ip != '' GROUP BY login_ip ORDER BY anzahl DESC");
$anzahl = false;
while ($res = mysql_fetch_object ($sql)) {
if ($res->anzahl == 2) {
?>
<tr>
<td align="center"><? echo $res->anzahl; ?></td>
<td align="center"><a href="?content=/usersystem/userbearbeiten&uid=<? echo $res->uid; ?>"><? echo $res->uid; ?></a></td>
<td align="center"><a href="?content=/usersystem/userbearbeiten&uid=<? echo ($res->uid2-$res->uid); ?>"><? echo ($res->uid2-$res->uid); ?></a></td>
<td align="right"><? echo $res->login_ip; ?></td>
</tr>
<?
$anzahl = true;
}
}
if ($anzahl == false) {
?>
<tr>
<td colspan="4" align="center"><b>Keine doppelten IP's im System!</b></td>
</tr>
<? } ?>
</table>
<br /><br />
<center>
Copyright © by <a href="http://www.123-mobile.de" target="_blank">Sebastian Hoinkes</a>
</center>
<? foot (); ?>
<? head ('Doppelte Anmelde IP\'s im System'); ?>
<table align="center" width="90%" border=1 bgcolor="#ffffff" bordercolor="#000000" style="border-collapse: collapse;" cellspacing=1 cellpadding=1>
<tr bgcolor="#cfcfcf">
<td width="25%" align="center"><b>Anzahl</b></td>
<td width="25%" align="center"><b>User 1</b></td>
<td width="25%" align="center"><b>User 2</b></td>
<td width="25%" align="center"><b>IP der User</b></td>
</tr>
<?
$sql = db_query ("SELECT COUNT( uid ) AS anzahl, uid, SUM( uid ) AS uid2, login_ip FROM `".$db_prefix."_userdaten` WHERE ip != '' GROUP BY ip ORDER BY anzahl DESC");
$anzahl = false;
while ($res = mysql_fetch_object ($sql)) {
if ($res->anzahl == 2) {
?>
<tr>
<td align="center"><? echo $res->anzahl; ?></td>
<td align="center"><a href="?content=/usersystem/userbearbeiten&uid=<? echo $res->uid; ?>"><? echo $res->uid; ?></a></td>
<td align="center"><a href="?content=/usersystem/userbearbeiten&uid=<? echo ($res->uid2-$res->uid); ?>"><? echo ($res->uid2-$res->uid); ?></a></td>
<td align="right"><? echo $res->ip; ?></td>
</tr>
<?
$anzahl = true;
}
}
if ($anzahl == false) {
?>
<tr>
<td colspan="4" align="center"><b>Keine doppelten IP's im System!</b></td>
</tr>
<? } ?>
</table>
<br /><br />
<? foot (); ?>
*edit by Gremlin*
PHP-Code-Tags nutzen!