Jump to content

SQL query to find users registered with the same IP?


-FP
 Share

Recommended Posts

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.

Edited by -FP
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

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