Gossamer Forum
Quote Reply
Multiple user accounts
Greetings,

I've been having some problems with a few users on the site, like having them ghosting and using more than one user account, stuff like that. Was wondering if anyone had any ideas that would help in tracking identical IP access to multiple accounts? There's got to be a better way than just comparing different users posts indiviually


Any help would be greatly appreciated.

Much thanks,
Drakk
Quote Reply
Re: [drakknor] Multiple user accounts In reply to
Hi,

From the SQL monitor, you can run:

SELECT distinct(post_username) from gforum_Post where post_ip = '123.123.123.123';

to show all users who have posted with that IP. Or:

SELECT distinct(post_username) from gforum_Post where post_ip LIKE '123.123.123.%';

to show all users posted with the same class c ip.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Multiple user accounts In reply to
Alex,

thanks for the help, when I ran the command it came back with the following error.

Quote:

Error: Query Error: Failed to execute query: 'SELECT distinct(post_username) from gforum_Post where post_ip LIKE '207.6.236.%';' Reason: Table 'nightmag_NMForum.gforum_Post' doesn't exist


any ideas?

Thanks,
Drakk