Jump to content

SQL query to find users registered with the same IP?


-FP

Recommended Posts

Posted
SELECT ip_address, COUNT(ip_address) AS c FROM forums_posts
WHERE topic_id = 1224
GROUP BY ip_address
HAVING c > 1;

Someone actually made 5 accounts... and many others 2 or 3, lol. It may be poeple just in the same net, but... well I'll have to check signup times and stuff.

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...