IP aller User

[SebbyPHM]

Hier ein "kleiner" Tipp:

<?php

/*
* Dieses Script wurde erstellt von:
* Sebastian Hoinkes [SebbyPHM]
* 
* http://www.totaltoll.de
* web [at] totaltoll [dot] de
*/

head ('IP-Adressen im System'); ?>
<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#c0c0c0">
    <tr>
        <td align="center"><b>User ID</b></td>
        <td align="center"><b>Nickname</b></td>
        <td align="center"><b>IP-Adresse</b></td>
    </tr>
<?php
$sql = db_query('SELECT u.uid, u.nickname, k.login_ip FROM '.$db_prefix.'_userdaten AS u LEFT JOIN '.$db_prefix.'_kontodaten AS k ON k.uid = u.uid ORDER BY u.nickname ASC');
while ($user = mysql_fetch_array ($sql)) {
    $lnc = ($lnc == '#cdcdcd') ? '#ededed' : '#cdcdcd'; ?>
    <tr bgcolor="<?=$lnc;?>">
        <td align="right"><?=$user['uid'];?></td>
        <td><?=$user['nickname'];?></td>
        <td align="right"><?=(($user['login_ip'] != NULL) ? $user['login_ip'] : 'noch nie eingeloggt');?></td>
    </tr>
<?php
} ?>
</table>
<br>
<div style="text-align: center;">Copyright &copy; 2007 by <a href="http://www.totaltoll.de" target="_blank">TotalToll.de</a></div>
<?php
foot (); ?>