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('Impossible de retrouver les informations des messages', __FILE__, __LINE__, $db->error()); if ($db->num_rows($result)) { while ($cur_ip = $db->fetch_assoc($result)) { ?> '."\n"; ?>

Adresse IP	Dernière visite	Occurences	Action
			Trouver plus d'utilisateur pour cette IP
Il n\'y a actuellement aucun message de cet utilisateur dans les forums.

query('SELECT DISTINCT poster_id, poster FROM '.$db->prefix.'posts WHERE poster_ip=\''.$db->escape($ip).'\' ORDER BY poster DESC') or error('Impossible de retrouver les informations des messages', __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('Impossible de retrouver les informations utilisateur', __FILE__, __LINE__, $db->error()); if (($user_data = $db->fetch_assoc($result2))) { $user_title = get_title($user_data); $actions = 'Voir stats IP - Afficher messages'; ?> '."\n"; ?>

Nom d'utilisateur	E-mail	Titre/Statut	Messages	Note admin	Actions
'.pun_htmlspecialchars($user_data['username']).'' ?>
		Invité
L\'adresse IP soumise est introuvable dans la base de données.

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('Impossible de retrouver les informations utilisateurs', __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 = 'Voir stats IP - Afficher messages'; ?> '."\n"; ?>

Nom d'utilisateur	E-mail	Titre/Status	Messages	Note admin	Actions
'.pun_htmlspecialchars($user_data['username']).'' ?>
Aucun résultat.