Paranoid dupe user buster when moderating

Hi.
I wrote this hack time ago to address my own needs to findout dupe users when they register.
Now I published it and hope could be useful to someone...

This hack, basically does this:
when there are new users to activate (Admin awaiting moderation, usergroup=4), the Admin can press the link 'Dupe matches grid' in AdminCP just below the user list. A new window will appear with the list of pending users followed by a complete list of possible duplicates (configurable max number, default 25 per user).

Note: you must have user moderation enabled, of course...

Each user is listed with userid, username, password, email, ipaddress, posts, lastlogin, etc..
The dupe matches are found analyzing
- similar usernames,
- similar emails,
- same passwords (I know it's md5 hashed, but... just in case... )
- similar ip address
- cross matching username and email account (without hostname)
Each possible match is evidenced in bold.

Affinities are found with a variation of levenshtein() and metaphone() php functions.
Tolerance are configurable and even is managed a correction needed on shortest words and or words containing number digits, which otherwise would raise a lot of false matches.
I put that config at the top of function, you can fine tune yourself, but max values like '1' aren't too bad and enough to find most common dupes ... Higher values could return too many false affirmatives.

Thanks to Dlst who sometime ago published something similar but involving only the username.

• Very very simple to apply.
• Involves only one php file. No templates.
• Manages almost all user characteristics.
• Visible only to admins (AdminCP).
• Leave the admin to decide what should do: delete, email, track, and so on...
• The hack, once installed, is itself facultative. You can decide to search dupes or not, and in case refresh the awaiting list on the main AdminCP page...

Screenshots are impossible as there should be a list of horizontal black lines covering user data for obvious privacy reasons ...
Just install it in one minute and give a look yourself

Let me know any problem (even I've been using for about three months...)
Bye.

[Jawelin]

Originally posted by CoolaShacka
Maybe you have to edit your Atachment
Realy nice hack.
Thank you.

:angry:

Please, read all thread next time, in particular Post #5 ....
Bye

[CoolaShacka]

Originally posted by Jawelin
ASAP I'll post the right code for that link.

In your .txt File ist still the old code inside.

[Jawelin]

aranoid: Oops.... I had corrected only one of two points with loginlog.php, when posted #5...
Sorry. Thanks

[Size]

What is the comparing of comparing an MD5 hash? Is there a way to eliminate that part? I tried eliminating password from the database query and getting rid of the password column, and I ended up with 25 hits with the IP's in bold, but the IP's didn't match at all. I'm not familiar with the metaphone function but it looks like that would need to be modified for what I'm looking for.

Has anyone else tried this?

[inetd]

Good hack!
I will install this later!

[inetd]

[high]* inetd install this good hack [/high]

[chris frolic]

Would there be a way of checking a suspect user against the database for similarities?

I don't use moderation either, but would love to make use of this script.

[subu1]

sorry, but i don't find the dupe link in acp, where is it.

greetz subu1

[subu1]

ups *g* i find this link :laugh:

You must go to " User awaiting Moderation"

thxx for this Hack

[ImportPassion]

anything like this for vb3?