Posted on: 11/24/04 01:29am
By: Anonymous (FreakWorld)
Posted on: 11/24/04 11:30am
By: zipstart
Posted on: 11/24/04 02:24pm
By: Dirk
Posted on: 11/25/04 12:16am
By: Anonymous (FreakWorld)
Posted on: 11/25/04 01:30am
By: Anonymous (tokyoahead)
$iaup_action=$_POST['iaup_action']; if ($iaup_action=="delete") {iaup_delete();} else {iaup_index();} function iaup_index() { global $_TABLES; global $_CONF; $sql="SELECT username, {$_TABLES['users']}.regdate, {$_TABLES['users']}.uid FROM {$_TABLES['users']} "; $sql.="LEFT JOIN {$_TABLES['userinfo']} ON {$_TABLES['users']}.uid={$_TABLES['userinfo']}.uid "; $sql.="WHERE ({$_TABLES['userinfo']}.lastlogin=0 OR {$_TABLES['userinfo']}.lastlogin IS NULL) AND {$_TABLES['users']}.uid>1 "; $sql.="ORDER BY {$_TABLES['users']}.regdate"; $result = DB_query($sql); $nrows = DB_numRows($result); $display.=COM_startBlock("Users that never logged in: ($nrows Users found)"); $display.="<Table>"; $display.="<TR><TD><B>No</B></TD><TD><B>Name</B></TD><TD><B>Reg. Date</B></TD></TR>"; for ($i=0;$i<$nrows;$i++) { $j=$i+1; $user = DB_fetchArray($result); $display.="<TR><TD>$j:</TD><TD><A HREF=\""; $display.=$_CONF['site_admin_url']."/user.php?mode=edit&uid={$user['uid']}\">"; $display.=$user['username']."</A></TD>"; $display.="<TD>".$user['regdate']."</TD></TR>"; } $display.="</Table>"; $display.=COM_endBlock(); $sql="SELECT username, {$_TABLES['userinfo']}.lastlogin, {$_TABLES['users']}.uid FROM {$_TABLES['users']} "; $sql.="LEFT JOIN {$_TABLES['userinfo']} ON {$_TABLES['users']}.uid={$_TABLES['userinfo']}.uid "; $sql.="WHERE {$_TABLES['users']}.uid>1 AND {$_TABLES['userinfo']}.lastlogin>0 "; $sql.="ORDER BY {$_TABLES['userinfo']}.lastlogin LIMIT 20"; $result = DB_query($sql); $nrows = DB_numRows($result); $display.=COM_startBlock("Users that did not login for a long time: (Top 20)"); $display.="<Table>"; $display.="<TR><TD><B>No</B></TD><TD><B>Name</B></TD><TD><B>Last Login</B></TD></TR>"; for ($i=0;$i<$nrows;$i++) { $j=$i+1; $user = DB_fetchArray($result); $display.="<TR><TD>$j:</TD><TD><A HREF=\""; $display.=$_CONF['site_admin_url']."/user.php?mode=edit&uid={$user['uid']}\">"; $display.=$user['username']."</A></TD>"; $lastlogin=date("Y.m.d H:i:s",$user['lastlogin']); $display.="<TD>$lastlogin</TD></TR>"; } $display.="</Table>"; $display.=COM_endBlock(); echo $display; }
Posted on: 11/26/04 03:35pm
By: zipstart
Posted on: 11/29/04 06:37am
By: Anonymous (FreakWorld)