Posted on: 04/25/04 10:19am
By: Sniper12
Posted on: 04/25/04 10:32am
By: Dirk
Posted on: 04/25/04 10:40am
By: Sniper12
Posted on: 07/18/04 10:19pm
By: varian vega
Posted on: 07/19/04 03:18am
By: Sniper12
Posted on: 07/21/04 05:52pm
By: varian vega
$offset = (($curpage - 1) * $limit); if (!empty($query)) { $sql = "SELECT u.uid,u.username,u.fullname,u.email,i.lastlogin FROM {$_TABLES['users']} AS u, {$_TABLES['userinfo']} AS i WHERE u.uid=i.uid AND u.uid > 1 AND (u.username LIKE '$query' OR u.email LIKE '$query' OR u.fullname LIKE '$query') LIMIT $offset,$limit"; } else { $sql = "SELECT u.uid,u.username,u.fullname,u.email,i.lastlogin FROM {$_TABLES['users']} AS u, {$_TABLES['userinfo']} AS i WHERE u.uid=i.uid AND u.uid > 1 LIMIT $offset,$limit"; } $result = DB_query($sql); $nrows = DB_numRows($result); for ($i = 0; $i < $nrows; $i++) { $A = DB_fetchArray($result); $lasttime = COM_getUserDateTimeFormatShort ($A['lastlogin']); $user_templates->set_var('user_id', $A['uid']); $user_templates->set_var('username', $A['username']); $user_templates->set_var('user_fullname', $A['fullname']); $user_templates->set_var('user_email', $A['email']); $user_templates->set_var('lang_lastlogin', $LANG28[35]); if (empty ($A['lastlogin'])) { $user_templates->set_var('user_lastlogin', $LANG28[36]); } else { $user_templates->set_var('user_lastlogin', $lasttime[0]); } $user_templates->parse('user_row', 'row', true); }
<table border="0" cellspacing="0" cellpadding="2" width="100%"> <tr> <th align="left">{lang_username}</th> <th>{lang_fullname}</th> <th>{lang_emailaddress}</th> <th>{lang_lastlogin}</th> </tr> {user_row} </tr> </table>
<tr align="center"> <td align="left"><a href="{site_url}/users.php?mode=profile&uid={user_id}"><img src="{layout_url}/images/person.gif" border="0" alt=""></a> <a href="{site_admin_url}/user.php?mode=edit&uid={user_id}">{username}</a></td> <td>{user_fullname}</td> <td>{user_email}</td> <td>{user_lastlogin}</td> </tr>
Posted on: 07/22/04 02:51pm
By: Sniper12
Posted on: 07/25/04 06:42pm
By: varian vega
COM_getUserDateTimeFormat($A['lastlogin']);
function COM_getUserDateTimeFormatShort( $date='' ) { global $_TABLES, $_USER, $_CONF; // Get display format for time if( $_USER['uid'] > 1 ) { if( empty( $_USER['format'] )) { $dateformat = $_CONF['daytime']; } else { $dateformat = $_USER['format']; } } else { $dateformat = $_CONF['daytime']; } if( empty( $date )) { // Date is empty, get current date/time $stamp = time(); } else if( is_numeric( $date )) { // This is a timestamp $stamp = $date; } else { // This is a string representation of a date/time $stamp = strtotime( $date ); } // Format the date $date = strftime( $dateformat, $stamp ); return array( $date, $stamp ); }
Posted on: 07/25/04 07:33pm
By: Sniper12
Posted on: 07/29/04 10:32pm
By: varian vega