Multiple IP Tracking?

[MrGameShow]

Hey guys,

    First of all, I just want to say that I was a former YaBB user, and when my provider suspended my account for some PERL problems crashing the server, I found this board software, and it is a GODSEND!

     Anyhow, I just ran into a problem of finding someone who logged into my site to register FIVE (yes, I'm not exaggerating) names, and the only reason I found that was because it just caught me as odd that a newbie was asking if they could help admin the board.. *snicker*..

     Granted that there is an IP tracking feature in the board already, but would it be possible (or IS there something around), that would be able to search through all the registered users and bring up a list of conflicts (such as.. oh, I dunno.. MULTIPLE IP LOGINS?)

      Great stuff you've created, and thanks again!

Till Then, Take Care
MrGameShow
www.flashgameshows.com

[LostProphecy]

would be highly usefull...

at the moment my only methods of sorting out these sorts of ppl are by clicking on "view members" in admin and sort the list by ip address... that can be a bit tedious sometimes though especially when you have masses of members

[[Unknown]]

What's wrong with profile -> track ip?  I mean, that shows possible doppelgangers, doesn't it?

-[Unknown]

[MrGameShow]

Technically, YES that does work - but what I was trying to say was that it would be nice to have something that did a "member database scan" and brought up users with multiple IPs.. like a "reverse lookup" sort of deal..

Otherwise it's a tedious task to have to go through "every user" to see if there are multiple IPs..

Does that clarify what I meant?

[Fizzy]

How about a MySQL query to hunt out IP numbers with a count > 1 ?
Is there such a query?

[[Unknown]]

Actually, I wrote such a query for YaBB SE.  Something like this:

SELECT DISTINCT mem1.ID_MEMBER, mem1.realName, mem1.memberName, mem1.emailAddress, mem1.memberIP
FROM smf_members AS mem1, smf_members AS mem2
WHERE mem1.memberIP = mem2.memberIP
   AND mem1.ID_MEMBER != mem2.ID_MEMBER;

This query is most likely fairly slow (just tried it, the answer is *YES*.)  What is phpMyAdmin?

-[Unknown]

[liquidism]

Code Select Expand

SELECT DISTINCT
mem1.ID_MEMBER,
mem1.memberName,
mem1.emailAddress,
mem1.memberIP,
mem2.ID_MEMBER,
mem2.memberName,
mem2.emailAddress,
mem2.memberIP
FROM
smfrm_members AS mem1,
smfrm_members AS mem2
WHERE
mem1.memberIP = mem2.memberIP
AND
mem1.ID_MEMBER != mem2.ID_MEMBER
AND
mem1.memberIP != ""
worked quite fast on a 3000 user db.