vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Administrative and Maintenance Tools - Duplicate IP Report by BOP5 (Checks for users sharing the same IP Addresses) VB3/VB4 (https://vborg.vbsupport.ru/showthread.php?t=282525)

Skyrider 10-03-2014 04:27 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2517475)
I'm may not be fully understanding the question- but looking at the SQL query it is clear the only IP addresses being checked in the posts report are the post IP addresses. It would be impossible for that query to check against registration IPs as those IPs are never returned/mentioned in the query.

If "Boo" is being returned in the post report it means the other username returned with boo has also posted posts with the same IP boo has posted from during the report period.

I'll give an example.

We currently found 2 forum profiles, of which we are sure that they are the same person, but the duplicate IP report isn't showing it in the report.

I'll replace Boo with Person A and the other profile with Person B.

Person A has a post count of 0, and the registration IP address in the AdminCP (of the profile) is 123.456.789 (not showing real IP address for obvious reasons). When I check his IP address through the AdminCP, it shows:

Registration IP Address - 123.456.789
Post IP Addresses - No Matches Found
Registration IP Addresses - No Matches Found

Awesome, lets continue!

Now, when I look at Person B

Has 3 post counts, and the registration IP address in the AdminCP is 987.654.321

Now, you can see that Person A and Person B don't have a matching IP address. However, when I use the AdminCP to View the IP address of Person B.

Registration IP Address - 987.654.321
Post IP Addresses - 123.456.789 [Find More Users with this IP Address]

Clicking "[Find More Users with this IP Address]" results in:

123.456.789 [host information here]

Post IP address:
Person B 123.456.789

Registration IP address:
Person A 123.456.789

As you can see. Person B with 3 posts, at least used the Post IP address of person A once. I can't find any IP reports from user A, but when I search through the IP results of Person B, I can find Person A.

I was wondering if this plugin can be extended a little bit so it can include the registration/post IP address match, regardless if it cannot be found in 1 profile, but can be found through another.

Hope you understand it a bit now.

(in this example I might have switched the IP's, 123 with 987 at the end. If that's the case, just swap them). Was using 2 example IP addresses and it is possible I mixed them up with one and other. But I think you'll get the general idea.

BirdOPrey5 10-04-2014 09:40 AM

Oh, I did misunderstand. I thought you were reporting a bug because registration IPs were not only being checked against registration IPs...

Indeed it was by design registration IPs only check against other registration IPs and post IPs only check against other post IPs.

You want a report that checks across both...

Unfortunately that was not an intended option and it is not something I will be adding- it would be a more difficult query and honestly one I think would be of limited use- as is these queries can take a big hit on the server- making them more complex will increase the chance of timeout/db errors.

Sorry.

If I had an idea I'd give you a hint on how to make the change yourself- the query code is in the php file- but I'm not sure how to go about combining the two- as is these were about as complex a mysql query I can handle.

Amenadiel 11-08-2014 04:10 PM

+1 for supporting wildcards and or IP blocks in the IP whitelist field. I want to add Cloudflare's IP ranges.

Kesha 11-08-2014 04:58 PM

Hey BOP!

I just installed your mod and I'm currently attempting to run it from the Admin CP (Options section) to try it out. I have a private forum set up, which is only accessible by Moderators and Admins. The issue is, when I click the Run Now button, the resulting page is simply "Duplicate IP Report by BOP5" followed by the word "Done" on a new line.

I saw a similar issue in this thread by another user so I decided to try some of what you asked him to do, with no luck. (disabling the Spam-O-Matic plugin, setting days to check to 1 & 1, etc.)

MySQL Version is 5.5.40-0ubuntu0.14.04.1, and PHP version is 5.5.9-1ubuntu4.5.

The forum itself is a large forum. Over 100,000 accounts are registered and over 1.9 million posts are in the database.

Any suggestions?

EDIT: Just figured it out... Apparently, the file that I uploaded did not have the correct permissions. After setting +rw on the file, it runs as promised and this mod runs now. Sorry about that!

BJJBJ 11-14-2014 09:43 AM

Quote:

Originally Posted by Kesha (Post 2521962)
Hey BOP!

I just installed your mod and I'm currently attempting to run it from the Admin CP (Options section) to try it out. I have a private forum set up, which is only accessible by Moderators and Admins. The issue is, when I click the Run Now button, the resulting page is simply "Duplicate IP Report by BOP5" followed by the word "Done" on a new line.

I saw a similar issue in this thread by another user so I decided to try some of what you asked him to do, with no luck. (disabling the Spam-O-Matic plugin, setting days to check to 1 & 1, etc.)

MySQL Version is 5.5.40-0ubuntu0.14.04.1, and PHP version is 5.5.9-1ubuntu4.5.

The forum itself is a large forum. Over 100,000 accounts are registered and over 1.9 million posts are in the database.

Any suggestions?

EDIT: Just figured it out... Apparently, the file that I uploaded did not have the correct permissions. After setting +rw on the file, it runs as promised and this mod runs now. Sorry about that!

I've got the exact same problem as above but his fix didn't work.

BirdOPrey5 11-14-2014 04:35 PM

Quote:

Originally Posted by BJJBJ (Post 2522670)
I've got the exact same problem as above but his fix didn't work.

If you are having issue with the Gold version (the free one doesn't have Admin CP interface) please post in the mod thread on qapla.com or PM me on Qapla.com- I can't provide support for the paid mod here on vbulletin.org.

Kesha 11-15-2014 04:17 PM

Just wanted to provide another update. I've had a chance to install and use this mod now, and let me just say that it works surprisingly well with my forum (being a larger forum). The only thing that I wish this modification had, is a duplicate account checker upon registration (with similar style alerts as this mod) but for the price I paid (nothing), this mod does it all for me.

Thank you kindly to BOP5 for this wonderful mod.

BirdOPrey5 11-15-2014 05:15 PM

Quote:

Originally Posted by Kesha (Post 2522821)
Just wanted to provide another update. I've had a chance to install and use this mod now, and let me just say that it works surprisingly well with my forum (being a larger forum). The only thing that I wish this modification had, is a duplicate account checker upon registration (with similar style alerts as this mod) but for the price I paid (nothing), this mod does it all for me.

Thank you kindly to BOP5 for this wonderful mod.

Thanks for the kind words. I couldn't "Like" this post because I liked an earlier one. But to your "wishes" if someone registers with an IP address already used (and within the time window specified) they will show up in the report the next say.

If you wanted to actually prevent someone with the same IP from registering again that is possible with the Recent Registration Check mod which is free with the purchase of the paid version of this mod. It doesn't make a report, just blocks the registration (or moderates it) based on your settings.

Snowhog 01-17-2015 08:33 PM

The mod posts the report to a specified Forum. I'd like to be able to choose between posting to a Forum or sending the report to an email address.

Faskis 01-01-2016 05:32 PM

I've found that the scheduled task for this only runs if done manually, but does not run at the scheduled time (it does list a future date/time). I can't find anything about it in the error logs. Any help would be appreciated.


All times are GMT. The time now is 08:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03659 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete