PDA

View Full Version : Administrative and Maintenance Tools - Duplicate IP Report by BOP5 (Checks for users sharing the same IP Addresses) VB3/VB4


BirdOPrey5
05-05-2012, 10:00 PM
Brought to you by BirdOPrey5
www.Qapla.com (http://www.qapla.com/mods/)

Version 2.1.2 - Fixed MySQLi bug - Introduced GOLD/Premium Version
Version 2.1 - Added BBCode to Banned Users and Post Count Options, better debug info
Version 2.0 - Added report for Registration (User) IP Address Checking

Check out the GOLD Version for these additional features (http://www.qapla.com/mods/showthread.php/521-Duplicate-IP-Report-GOLD-Recent-Registration-Check-GOLD-by-BOP5):

Run reports directly from the Admin CP anytime you want
Post daily report as a "New Post" into an existing thread rather than a "New Thread" each night
Access to another Gold Mod- Recent Registration Check- will block spammers and scammers trying to register multiple accounts from the same IP address


This mod will run a nightly scan of your "post" and/or "user" table. It will report if it finds any users sharing the same IP address. You choose in the options how many days back you want to look. (Max of 5000 days, but please use more reasonable limits.)

If any "duplicate use" is found the IP addresses, usernames and optionally the posts themselves will be reported.

See a real report: Report Demo at Qapla.com (http://www.qapla.com/mods/showthread.php/433-Duplicate-IP-Report-for-05-07-2012?p=1235#post1235)

The report takes the form of a new thread posted to the forum of the Admin's choosing (A private forum for mods or admins is strongly recommended.)

There are options for whitelisting (ignoring) specific IP Addresses and/or userids so if you or your mods post as other users you can prevent that from being reported. If you use the Zoints Anonymous Posting mod you will want to put that userid on the whitelist else the report will out whoever posted "Anonymously."

NOTE: There are PERFECTLY valid reasons 2 or more users may share the same IP address. This report in and of itself is not proof of malicious activity. Users that connect by mobile devices, work in same offices, or go to the same schools for example would likely share the same IP address on some posts. So would too any users connecting from the same home or public Wi-Fi network.

As of version 2.0 there is a report for both the "post" and "user" table. The "user" table will find when 2 or more users register with the same IP address.

Tested and working on VB 3.8.7 and VB 4.1.12/4.2.0 and should work on all 3.7 / 3.8 / 4.x versions.

------------------------------------------------------

Please "Mark as Installed" if you use this. :)
Donations always appreciated. :up:
Nominate MOTM if you LOVE it! ;)

BirdOPrey5
05-06-2012, 03:39 PM
Reserved.

RRCamellini
05-06-2012, 07:27 PM
thx a lot for MOD my friend

Prorockz
05-06-2012, 08:47 PM
it looks great.
is there any kind of PHP error?
i am just confirming:)

BirdOPrey5
05-06-2012, 08:51 PM
No errors that i know of, If I knew of any php errors I would have fixed it before releasing.

BirdOPrey5
05-07-2012, 07:52 PM
Version 2.0 Released- Now will check the User table too (For Registration IP Check.)

The first time I ran this report I saw one IP being used by 18 people I hadn't noticed. They had never made a post but when I checked their profile they had all spammed their own visitor messages with links.

Without this mod no telling how long they may have lasted.

You will need to do a full install - that is upload the new php file AND import the product xml file, overwriting each, if upgrading.
__________________

oshrizak
05-09-2012, 12:21 PM
Ok I installed with no problems and runs great thanks for this release

BirdOPrey5
05-09-2012, 12:24 PM
Are you sure you loaded the file to the correct location?

Does it have any other message besides "failed" ?

oshrizak
05-09-2012, 12:25 PM
Sorry I found the problem I forgot to put in a valid user id to post to the forum I selected.

oshrizak
05-09-2012, 12:34 PM
Is there a way to automate this to run like once a week don't see it in the settings or I am missing it.

BirdOPrey5
05-09-2012, 01:00 PM
It is set to run once every night when you install it. You can go to Scheduled tasks and edit how often it runs there.

BirdOPrey5
05-18-2012, 12:52 PM
Updated to version 2.1

Added option to apply custom bbcode to banned users in reports.
Added option to show post counts in reports.
Added actual SQL query to debug info when manually running reports.

Artes_Marciales
05-24-2012, 02:24 PM
Amazing!!

BirdOPrey5
06-01-2012, 06:02 PM
[redacted.]

oxblood12
06-02-2012, 02:39 AM
interesante add on gracias

v123shine
06-15-2012, 07:34 AM
My Server Load Averages increase 600% after install and active this plugin :(
I think this plugin can not be used on busy/large sites traffics.

BirdOPrey5
06-15-2012, 11:39 AM
My Server Load Averages increase 600% after install and active this plugin :(
I think this plugin can not be used on busy/large sites traffics.

There is no way that is possible from this mod.

This mod only runs once a day. There is nothing "active" throughout the day- there are no plugins- nothing that could possibly caused sustained loads.

It is just a couple of SQL queries (two at max) that run once every 24 hours.

Yes, for the few seconds the query runs it will use resources but once it is done it is done.

This isn't affecting a daily or even hourly average.

If somehow it is taking up to much resources for the 1 time it runs each day the solution is to drop the number of "days back" each report looks for.

v123shine
06-15-2012, 02:00 PM
I swear it happened on my server. After 10 minutes run the plugin my site error, when i check, my Server Load Averages increase 600%. After i disable the plugin, server back to normal.

My site visitors average 800-1400 visitors online in 1 second.

I hope you can fix this problem, because this plugin is very useful to reduce spam.

*Forgive me, if my english language not good.

There is no way that is possible from this mod.

This mod only runs once a day. There is nothing "active" throughout the day- there are no plugins- nothing that could possibly caused sustained loads.

It is just a couple of SQL queries (two at max) that run once every 24 hours.

Yes, for the few seconds the query runs it will use resources but once it is done it is done.

This isn't affecting a daily or even hourly average.

If somehow it is taking up to much resources for the 1 time it runs each day the solution is to drop the number of "days back" each report looks for.

BirdOPrey5
06-16-2012, 11:06 AM
I would suggest you schedule the report to run during the time your forum gets the least traffic.

I'm sure your usage went up AS the report was running, for sure- but once the report was done it would have returned to normal.

Did the reports finish?

v123shine
06-20-2012, 12:39 AM
I dont get any reports.

I will run this plugin during the time my forum gets the least traffic

Thank you

I would suggest you schedule the report to run during the time your forum gets the least traffic.

I'm sure your usage went up AS the report was running, for sure- but once the report was done it would have returned to normal.

Did the reports finish?

BirdOPrey5
06-20-2012, 01:14 AM
If you're not getting any reports the reports aren't finishing- it may be timing out.

Reduce the "days back" in each report to 1 and see if the report runs. If it does slowing build up the days back as needed.

There's nothing to "fix" if you have that many users and posts it's just going to be a big load, you need to reduce the number of records it will look through by reducing the days back options.

vijayninel
07-06-2012, 01:18 PM
Thank You BirdOPrey5. Working fine and is useful :)

BirdOPrey5
12-17-2012, 10:29 PM
Long awaited update to Version 2.1.2.

Fixed the MySQLi bug and introduced a Gold/Premium version (no features removed from this free version!)

See first/top post for details.