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)

BirdOPrey5 10-12-2012 10:51 AM

Quote:

Originally Posted by Hostboard (Post 2371745)
Fresh install on 4.2.0pl2
Ran the report after configuring it.
Report generated and posted but also got:

Code:

Post Check SQL:
 SELECT mmpost.ipaddress, GROUP_CONCAT(DISTINCT mmpost.userid) AS userid, GROUP_CONCAT(DISTINCT mmpost.postid) AS postid, mmuser.usergroupid          FROM mmpost LEFT JOIN mmuser ON mmuser.userid = mmpost.userid          WHERE mmpost.dateline > 1349176946 AND mmpost.userid > 0  AND mmpost.ipaddress != '127.0.0.1'  AND mmpost.ipaddress != ''            GROUP BY mmpost.ipaddress          HAVING COUNT(DISTINCT mmpost.userid) > 1          ORDER BY COUNT(DISTINCT mmpost.userid) DESC          LIMIT 500

User Check SQL:
 SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid, usergroupid          FROM mmuser          WHERE joindate > 1347189746 AND userid > 0  AND ipaddress != '127.0.0.1'  AND ipaddress != ''            GROUP BY ipaddress          HAVING COUNT(DISTINCT userid) > 1          ORDER BY COUNT(DISTINCT userid) DESC          LIMIT 500


Where did you "get" that code? If you manually run the report that is completely normal debug info that is output.

Skyrider 11-12-2012 10:07 PM

https://vborg.vbsupport.ru/external/2012/11/22.png
For some reason, I'm using his IP & host and this happens on multiple users. Thus I'm showing up under the users "alternative" account list (multiple accounts). And this happens on 2 different forums of which I find weird. All started to happen when I used this plugin. My account ID is used to create the Duplicate IP thread by the way, of which I think might have something to do with it.

BirdOPrey5 12-17-2012 10:24 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.

Snowhog 12-17-2012 10:54 PM

Updated. Thank you.

Hostboard 12-18-2012 01:14 PM

One of those must haves...
Uninstalled... Went gold :D Thank you for the update & bonus!

dmm2020 01-01-2013 01:17 AM

I can't download the xml file at www.Qapla.com. WHen I try to register or do anything, it hangs on "waiting for response from google plus one..."

datoneer 01-01-2013 11:20 PM

Soon i'll buy gold one for sure

Mark4865 01-02-2013 02:20 PM

Hello BOP

This looks like a fantastic mod and I would like to purchase the gold version for my website.

I just want to be able to view the reports via admin cp and not have them posted as threads in the forum as they are only for my use. Is that possible with Gold version.

If so I am ready to buy and have registered on your forum, please confirm.

Thanks for the great mod

BirdOPrey5 01-04-2013 06:03 PM

Quote:

Originally Posted by dmm2020 (Post 2393911)
I can't download the xml file at www.Qapla.com. WHen I try to register or do anything, it hangs on "waiting for response from google plus one..."

Please try again, I have gotten a number of new registrations over the last few days so it must be a temporary issue.

Quote:

Originally Posted by Mark4865 (Post 2394222)
Hello BOP

This looks like a fantastic mod and I would like to purchase the gold version for my website.

I just want to be able to view the reports via admin cp and not have them posted as threads in the forum as they are only for my use. Is that possible with Gold version.

If so I am ready to buy and have registered on your forum, please confirm.

Thanks for the great mod

Yes you can turn off the posting of reports and use only the admin cp reports.

Mark4865 01-05-2013 06:40 AM

Just bought the Gold Version, seems to be great value for money can't wait to install it

Thanks for effort BOP


All times are GMT. The time now is 10:26 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.01271 seconds
  • Memory Usage 1,741KB
  • 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
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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