1) admin_menu('users'); else moderator_menu('users'); ?> query('SELECT poster_ip, posted FROM '.$db->prefix.'posts WHERE poster_id='.$ip_stats.' ORDER BY posted DESC') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); $num_posts = $db->num_rows($result); if ($num_posts) { // Fetch the first hit and add it to hit_list $cur_hit = $db->fetch_row($result); $hit_list = array($cur_hit[0] => array($cur_hit[1], 1)); // Loop through hits and update hit_list for ($i = 1; $i < $num_posts; $i++) { $cur_hit = $db->fetch_row($result); if (isset($hit_list[$cur_hit[0]])) { $hit_list[$cur_hit[0]][1]++; if ($cur_hit[1] > $hit_list[$cur_hit[0]][0]) $hit_list[$cur_hit[0]][0] = $cur_hit[1]; } else $hit_list[$cur_hit[0]] = array($cur_hit[1], 1); } foreach ($hit_list as $key => $value) { ?> '."\n"; ?>

IP address	Hostname	Last used	Times found	Action
				Find more users for this ip
There are currently no posts by that user in the forum.

1) admin_menu('users'); else moderator_menu('users'); ?> query('SELECT DISTINCT poster_id, poster FROM '.$db->prefix.'posts WHERE poster_ip=\''.escape($ip).'\' ORDER BY poster DESC') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error()); $num_posts = $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) = $db->fetch_row($result); $result2 = $db->query('SELECT id, username, email, title, num_posts, status, last_post, registered, admin_note FROM '.$db->prefix.'users WHERE id>1 AND id='.$poster_id) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error()); if (($user_data = $db->fetch_assoc($result2))) { $user_title = get_title($user_data); $actions = 'View IP stats - Show posts'; ?> '."\n"; ?>

Username	E-mail	Title	Registered	Last post	Posts	Admin note	Actions
'.htmlspecialchars($user_data['username']).'' ?>
		Guest
The supplied IP address could not be found in the database.

'.$last_post_after; if ($last_post_before != '') $conditions[] = 'last_post<'.$last_post_before; if ($registered_after != '') $conditions[] = 'registered>'.$registered_after; if ($registered_before != '') $conditions[] = 'registered<'.$registered_before; foreach ($form as $key => $input) { if ($input != '') $conditions[] = $key.' LIKE \''.un_escape(str_replace('*', '%', $input)).'\''; } if ($posts_greater != '') $conditions[] = 'num_posts>'.$posts_greater; if ($posts_less != '') $conditions[] = 'num_posts<'.$posts_less; if ($user_group != 'all') $conditions[] = 'status='.$user_group; if (!isset($conditions)) message('You didn\'t enter any search terms.'); $page_title = htmlspecialchars($options['board_title']).' / Admin / Users'; require 'header.php'; if ($cur_user['status'] > 1) admin_menu('users'); else moderator_menu('users'); ?> prefix.'users WHERE id>1 AND '.implode(' AND ', $conditions).' ORDER BY '.$order_by.' '.$direction; $result = $db->query($sql) or error('Unable to search for users', __FILE__, __LINE__, $db->error()); $num_users = $db->num_rows($result); if ($num_users) { // Loop through users and print out some info for ($i = 0; $i < $num_users; $i++) { $user_data = $db->fetch_assoc($result); $user_title = get_title($user_data); // This script is a special case in that we want to display "Not validated" for non-validated users if ($user_data['status'] == -1 && $user_title != $lang_common['Banned']) $user_title = 'Not validated'; $actions = 'View IP stats - Show posts'; ?> '."\n"; ?>

Username	E-mail	Title	Registered	Last post	Posts	Admin note	Actions
'.htmlspecialchars($user_data['username']).'' ?>
No match.

1) admin_menu('users'); else moderator_menu('users'); ?>

Users

Find users

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
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