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

Page 15 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)

tpearl5

07-18-2013 01:11 AM

Has anyone seen two users with the same ips multiple times that also use tapatalk? It seems posts made either from tapatalk or mobile phones in general more commonly get the same ips.

BirdOPrey5

07-18-2013 08:59 AM

Quote:

Originally Posted by tpearl5 (Post 2434227)

Has anyone seen two users with the same ips multiple times that also use tapatalk? It seems posts made either from tapatalk or mobile phones in general more commonly get the same ips.

Yes, as I noted in the first post users using mobile devices often share the same IP address. I have users in different states that often end up sharing the same verizon wireless, cingular, at&t, or sprint IP addresses because they are using their cell phones to access. It's not Tapatalk's IP address, it's the fact the mobile providers don't use unique IPs.

tpearl5

07-18-2013 09:45 AM

Right, okay. I read everything but the rest of the first post :) And that's what I figured with the mobile IP's.

Bubble #5

09-09-2013 03:59 AM

BOP5 you always come up with the best mods! This is exactly what I was looking for :up:

Nominated for MOTM.

When I ran it I saw some code. Is it normal for it to display this in the ACP?

Code:

Post Check SQL:

SELECT post.ipaddress, GROUP_CONCAT(DISTINCT post.userid) AS userid, GROUP_CONCAT(DISTINCT post.postid) AS postid, user.usergroupid FROM post LEFT JOIN user ON user.userid = post.userid WHERE post.dateline > 1378097227 AND post.userid > 0 AND post.ipaddress != '127.0.0.1' AND post.ipaddress != '' GROUP BY post.ipaddress HAVING COUNT(DISTINCT post.userid) > 1 ORDER BY COUNT(DISTINCT post.userid) DESC LIMIT 500



User Check SQL:

SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid, usergroupid FROM user WHERE joindate > 1376110027 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

BirdOPrey5

09-09-2013 07:51 AM

Yes, if you run the task manually I have it display the queries for debugging purposes. It won't show if not run manually.

ForceHSS

09-09-2013 09:39 AM

What do I need to change in the scheduled task so it will run once every 7 days on a Monday. Time does not matter as long as it runs each Monday.

CAG CheechDogg

09-09-2013 10:06 AM

To do that do the following..

Day of the week: Monday
Day of the Month: *
Hour: what ever hour of the day you want
Minute: what ever minute of the day you want

ForceHSS

09-10-2013 03:41 AM

Thanks

CAG CheechDogg

09-10-2013 04:57 AM

No problem ForceHSS ....

ali1359

09-17-2013 03:34 PM

When I hit Run Report Now :

MySQL Error : Invalid use of group function
Error Number : 1111
Request Date : Tuesday, September 17th 2013 @ 11:31:52 AM
Error Date : Tuesday, September 17th 2013 @ 11:31:52 AM
Script : http://xxxxx.com/admincp/cronadmin.p...check&manual=1
Referrer :
IP Address : xx.xx.x.xx
Username : Admin
Classname : vB_Database_MySQLi
MySQL Version : 4.1.21-community-nt

What I have to do ?

All times are GMT. The time now is 12:00 PM.

Page 15 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.01282 seconds Memory Usage 1,736KB 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 (1)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: