diff -r e3d7322305bf -r 5e1f1e916419 punbb/admin_users.php --- a/punbb/admin_users.php Sun Sep 02 11:00:57 2007 -0400 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 @@ -1,514 +0,0 @@ - -
-
-
Go back
-
-
- -
-

Users

-
-
- - - - - - - - - - -query('SELECT poster_ip, MAX(posted) AS last_used, COUNT(id) AS used_times FROM '.$pun_db->prefix.'posts WHERE poster_id='.$ip_stats.' GROUP BY poster_ip ORDER BY last_used DESC') or error('Unable to fetch post info', __FILE__, __LINE__, $pun_db->error()); - if ($pun_db->num_rows($result)) - { - while ($cur_ip = $pun_db->fetch_assoc($result)) - { - -?> - - - - - - -'."\n"; - -?> - -
IP addressLast usedTimes foundAction
Find more users for this ip
There are currently no posts by that user in the forum.
-
-
-
- -
-
-
Go back
-
-
- -
-
-
Go back
-
-
- -
-

Users

-
-
- - - - - - - - - - - - -query('SELECT DISTINCT poster_id, poster FROM '.$pun_db->prefix.'posts WHERE poster_ip=\''.$pun_db->escape($ip).'\' ORDER BY poster DESC') or error('Unable to fetch post info', __FILE__, __LINE__, $pun_db->error()); - $num_posts = $pun_db->num_rows($result); - - if ($num_posts) - { - // Loop through users and print out some info - for ($i = 0; $i < $num_posts; ++$i) - { - list($poster_id, $poster) = $pun_db->fetch_row($result); - - $result2 = $pun_db->query('SELECT u.id, u.username, u.email, u.title, u.num_posts, u.admin_note, g.g_id, g.g_user_title FROM '.$pun_db->prefix.'users AS u INNER JOIN '.$pun_db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id>1 AND u.id='.$poster_id) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - - if (($user_data = $pun_db->fetch_assoc($result2))) - { - $user_title = get_title($user_data); - - $actions = 'View IP stats - Show posts'; - -?> - - - - - - - - - - - - - - - - - -'."\n"; - -?> - -
UsernameE-mailTitle/StatusPostsAdmin noteActions
'.pun_htmlspecialchars($user_data['username']).'' ?>
 Guest   
The supplied IP address could not be found in the database.
-
-
-
- -
-
-
Go back
-
-
-'.$last_post_after; - if ($last_post_before != '') - $conditions[] = 'u.last_post<'.$last_post_before; - if ($registered_after != '') - $conditions[] = 'u.registered>'.$registered_after; - if ($registered_before != '') - $conditions[] = 'u.registered<'.$registered_before; - - $like_command = ($db_type == 'pgsql') ? 'ILIKE' : 'LIKE'; - while (list($key, $input) = @each($form)) - { - if ($input != '' && in_array($key, array('username', 'email', 'title', 'realname', 'url', 'jabber', 'icq', 'msn', 'aim', 'yahoo', 'location', 'signature', 'admin_note'))) - $conditions[] = 'u.'.$pun_db->escape($key).' '.$like_command.' \''.$pun_db->escape(str_replace('*', '%', $input)).'\''; - } - - if ($posts_greater != '') - $conditions[] = 'u.num_posts>'.$posts_greater; - if ($posts_less != '') - $conditions[] = 'u.num_posts<'.$posts_less; - - if ($user_group != 'all') - $conditions[] = 'u.group_id='.intval($user_group); - - if (empty($conditions)) - message('You didn\'t enter any search terms.'); - - - $page_title = pun_htmlspecialchars($pun_config['o_board_title']).' / Admin / Users'; - require PUN_ROOT.'header.php'; - -?> -
-
-
Go back
-
-
- -
-

Users

-
-
- - - - - - - - - - - - -query('SELECT u.id, u.username, u.email, u.title, u.num_posts, u.admin_note, g.g_id, g.g_user_title FROM '.$pun_db->prefix.'users AS u LEFT JOIN '.$pun_db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id>1 AND '.implode(' AND ', $conditions).' ORDER BY '.$pun_db->escape($order_by).' '.$pun_db->escape($direction)) or error('Unable to fetch user info', __FILE__, __LINE__, $pun_db->error()); - if ($pun_db->num_rows($result)) - { - while ($user_data = $pun_db->fetch_assoc($result)) - { - $user_title = get_title($user_data); - - // This script is a special case in that we want to display "Not verified" for non-verified users - if (($user_data['g_id'] == '' || $user_data['g_id'] == PUN_UNVERIFIED) && $user_title != $lang_common['Banned']) - $user_title = 'Not verified'; - - $actions = 'View IP stats - Show posts'; - -?> - - - - - - - - -'."\n"; - -?> - -
UsernameE-mailTitle/StatusPostsAdmin noteActions
'.pun_htmlspecialchars($user_data['username']).'' ?>
No match.
-
-
-
- -
-
-
Go back
-
-
- -
-

User search

-
-
-

-
-
- Enter search criteria -
-

Search for users in the database. You can enter one or more terms to search for. Wildcards in the form of asterisks (*) are accepted.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Username
E-mail address
Title
Real name
Website
ICQ
MSN Messenger
AOL IM
Yahoo! Messenger
Location
Signature
Admin note
Number of posts greater than
Number of posts less than
Last post is after - (yyyy-mm-dd hh:mm:ss)
Last post is before - (yyyy-mm-dd hh:mm:ss)
Registered after - (yyyy-mm-dd hh:mm:ss)
Registered before - (yyyy-mm-dd hh:mm:ss)
Order by -     -
User group - -
-
-
-
-

-
-
- -

IP search

-
-
-
-
- Enter IP to search for -
- - - - - -
IP address
 - The IP address to search for in the post database.
-
-
-
-
-
-
-
- -