query('SELECT poster_ip, MAX(posted) AS last_used, COUNT(id) AS used_times FROM '.$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__, $db->error()); if ($db->num_rows($result)) { while ($cur_ip = $db->fetch_assoc($result)) { ?> '."\n"; ?>

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

query('SELECT DISTINCT poster_id, poster FROM '.$db->prefix.'posts WHERE poster_ip=\''.$db->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 u.id, u.username, u.email, u.title, u.num_posts, u.admin_note, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u INNER JOIN '.$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__, $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/Status	Posts	Admin note	Actions
'.pun_htmlspecialchars($user_data['username']).'' ?>
		Guest
The supplied IP address could not be found in the database.

query('SELECT u.id, u.username, u.email, u.title, u.num_posts, u.admin_note, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id>1 AND '.implode(' AND ', $conditions).' ORDER BY '.$db->escape($order_by).' '.$db->escape($direction)) or error('Unable to fetch user info', __FILE__, __LINE__, $db->error()); if ($db->num_rows($result)) { while ($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 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"; ?>

Username	E-mail	Title/Status	Posts	Admin note	Actions
'.pun_htmlspecialchars($user_data['username']).'' ?>
No match.