The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Identify accounts with duplicate IPs
So in line with all the recent spam discussions. I have a question for you all.
I have noticed that we have certain spammers signing up for accounts using a range of IP addresses. I am looking for a way to find these users easily without having to go use the admincp. I ran the command: select username, ipaddress, COUNT(*) as n from user Group by ipaddress having n > 4; It came back with some results but only shows me registering IPs for the users. I have instances where the users will register from 1 IP address and post from another. How does one query the database to show duplicate IPs from not only the registration but from the other IPs that are used? Thanks in advanced! Regards, Keith |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|