vb.org Archive - Administrative and Maintenance Tools - Duplicate IP Report by BOP5 (Checks for users sharing the same IP Addresses) VB3/VB4

Page 12 of 20

Show 40 post(s) from this thread on one page

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)

TheSupportForum

10-08-2012 12:52 PM

@BirdOPrey5

a few questions

1) i set the Reports to be in a private forum, no other usergroups see the forum accept administrators

on activity.php for 4.2.0 PL2 it appears for all users :(

i was just wondering whether this mod works with the the activity stream as unregistered users can see the post as

Code:

Snowderblazer Created a New Thread Duplicate IP Report for 07-10-2012

this is shown to all usergroups including unregistered even though they should not have permission to view it

Snowhog

10-08-2012 03:45 PM

Not so here. If I look at the Activity Stream as a guest (not logged in to the forum), I do not see the generated report, and I have it written to a sub-forum accessible only by the Administrator usergroup.

TheSupportForum

10-08-2012 03:56 PM

Quote:

Originally Posted by Snowhog (Post 2371571)

for soem ready it shows, but found a fix using a plugin, strange but i hope that they implement a feature to not include certain forums

BirdOPrey5

10-08-2012 06:46 PM

Quote:

Originally Posted by Jennifer2010 (Post 2371472)

I get a database error when trying to run a report.

After clicking Run report, after about 15 seconds:

Quote:

Originally Posted by simonhind (Post 2371535)

Code:

Snowderblazer Created a New Thread Duplicate IP Report for 07-10-2012

this is shown to all usergroups including unregistered even though they should not have permission to view it

That would be a problem with the permissions on your forum, not this mod- this mod uses standard code to create a new thread- it is up to the VB 4.2.0 code to decide what goes in the activity stream and what doesn't.

TheSupportForum

10-09-2012 02:19 AM

Quote:

Originally Posted by BirdOPrey5 (Post 2371612)

MySQL Has Gone Away Error probably means the query is overloading your database... How many users and how many posts do you have? You could try lowering the number of days back to look for each report.

That would be a problem with the permissions on your forum, not this mod- this mod uses standard code to create a new thread- it is up to the VB 4.2.0 code to decide what goes in the activity stream and what doesn't.

Thank you

but i found it rather strange that the forum was visible to me only "set as admin view only" but activity stream showed the threads to all users :(

i found a solution posted in vbulletin.com

using example in a template hook postdata_presave

Code:

if ($this->info['forum']['forumid'] == '2'){

           $this->set_info('skip_activitystream', true);  

     }

Hostboard

10-09-2012 10:26 AM

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

TheSupportForum

10-09-2012 10:33 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

have you se the forums you want the reports sent to

e.g.
http://img201.imageshack.us/img201/4...86eae3a0da.png

also ensure that the userid that reports it has access to that forum

Hostboard

10-09-2012 11:21 AM

As noted, the reported ran and it posted properly.

TheSupportForum

10-09-2012 11:53 AM

Quote:

Originally Posted by Hostboard (Post 2371758)

As noted, the reported ran and it posted properly.

Hmm i can only think its how the query is formed for your MYSQL version
seeing that you received the threads in your chosen forum, the script works

Hostboard

10-09-2012 01:12 PM

Quote:

Originally Posted by simonhind (Post 2371765)

Hmm i can only think its how the query is formed for your MYSQL version
seeing that you received the threads in your chosen forum, the script works

Running MySQL version:: 5.1.63-0ubuntu0.10.04.1

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

Page 12 of 20

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01478 seconds Memory Usage 1,755KB 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 (5)bbcode_code_printable (7)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
Messages: