vb.org Archive
Page 4 of 5 « First 23 4 5
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)

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

Mark4865 01-05-2013 11:09 AM
Install Gold Version and ran report, fantastic stuff came up with some very interesting info

Where do I find my thread id so I can specify it for future reports

My report showed some potential spammers which I wasn't aware off which was great

It also showed some duplicate IP addresses where I know users are legitimate and not spammers, 1 duplicate made sense as the 2 members work for same company but the other 2 didn't make sense. I am sure all are real users could it just be they logged onto same server or something?

diddy29 01-05-2013 11:38 AM
Hi, looks like a great mod, but I keep running into these errors:

Warning: include_once([path]/./includes/cron/bop5_dupeip.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/bop5_dupeip.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

I've disabled Glowhost, set my days 1, 1, but I still keep getting these errors when I run it manually.

We have a mod that prevents links from being posted until they have a minimum number of approved posts (2) to prevent spammers. That's worked perfectly, but could that prevent this from working?

Thank you!!

ForceHSS 01-05-2013 04:31 PM
Quote:
Originally Posted by diddy29 (Post 2394871)
Hi, looks like a great mod, but I keep running into these errors:

Warning: include_once([path]/./includes/cron/bop5_dupeip.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/bop5_dupeip.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

I've disabled Glowhost, set my days 1, 1, but I still keep getting these errors when I run it manually.

We have a mod that prevents links from being posted until they have a minimum number of approved posts (2) to prevent spammers. That's worked perfectly, but could that prevent this from working?

Thank you!!
its not hard to work out the problem just upload the missing file it is asking for includes/cron/bop5_dupeip.php

diddy29 01-10-2013 02:15 AM
Quote:
Originally Posted by ForceHSS (Post 2394922)
its not hard to work out the problem just upload the missing file it is asking for includes/cron/bop5_dupeip.php
To confirm, do I just upload a file named bop5_dupeip.php or is there a special file named this that I have to acquire?

ForceHSS 01-10-2013 02:50 AM
Quote:
Originally Posted by diddy29 (Post 2395884)
To confirm, do I just upload a file named bop5_dupeip.php or is there a special file named this that I have to acquire?
it is all in the file you downloaded

BirdOPrey5 01-12-2013 02:12 PM
In the download zip for this mod there is a folder called upload, inside upload is includes, inside includes is cron, and inside cron in the file: bop5_dupeip.php

Using FTP upload bop5_dupeip.php onto your vBulletin install in the folder /includes/cron/

The folders after /upload/ match where the files need to go in your forums. Same as with the VB install files when you installed the forum.

Hostboard 02-20-2013 02:13 PM
Took me awhile but I finally came up with some things that would be helpful (at least for me) At the moment I have it setup to post a thread/report into a dedicated forum. However I would like to stop those that have access to the forum from posting within the same thread. So would it possible to add a feature to auto-close the thread upon its posting? Also having the ability to make the thread auto-sticky for X amount of days would be great. This would allow x amount of reports (a week in my case) worth of reports to remain at the top of the forum and not get lost in the staff's chit chat.

TIA

BirdOPrey5 03-03-2013 11:52 AM
Quote:
Originally Posted by Hostboard (Post 2405418)
Took me awhile but I finally came up with some things that would be helpful (at least for me) At the moment I have it setup to post a thread/report into a dedicated forum. However I would like to stop those that have access to the forum from posting within the same thread. So would it possible to add a feature to auto-close the thread upon its posting? Also having the ability to make the thread auto-sticky for X amount of days would be great. This would allow x amount of reports (a week in my case) worth of reports to remain at the top of the forum and not get lost in the staff's chit chat.

TIA
Closed threads is a good idea- I will make sure it is an option in the next update.

In the mean time if you want closed threads just edit the php file that came with the mod (in the /includes/cron/ directory)

Find the line:

PHP Code:
    $kthread->set('showsignature', $showsig); 
And directly below it add:

PHP Code:
    $isopen = 0;
    $kthread->setr('open',     $isopen); 
That will create all threads as closed threads.

If you want to go back to open threads just change $isopen = 1 instead.


The sticky threads for X number of days isn't likely to happen, would be too much code with nothing to do with this mod IMO.

BirdOPrey5 03-03-2013 12:45 PM
Not likely either- that would require keeping some type of log in the database which means creating new database tables, regular reading from and updates to those tables, just an annoyance from a coding point of view.

BirdOPrey5 03-04-2013 11:42 AM
The 2 existing queries can be quite heavy, especially on large forms- doubling the queries would cause more timeout issues or require forum admins to restrict how far back the mod looks even more. That's why if I did implement this feature it would be with a custom log not a duplicate query one day earlier.

Second issue with your logic, there would be a report every other day.

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 ?

BirdOPrey5 09-17-2013 10:06 PM
I'm sorry I don't know why. It may be your MySQL version is too old, I have only tested this on MySQL 5.x.x never got a chance to test on MySQL 4.1.21.

Bubble #5 09-21-2013 11:45 PM
Is there a way to have it send an e-mail to the admin, instead of posting a thread?

Would be so much easier to manage, and would catch most peoples attention sooner.

ozzy47 09-21-2013 11:59 PM
I suppose you could subscribe to the forum that you have the mod posting in and choose, Instant notification by email, then you would get a email that a new thread was made.

Bubble #5 09-22-2013 12:04 AM
Yes, but then you'd also have to go in and clean up 30 threads per month :p

Would be so much more straight forward to not make the threads and just send the e-mail. Just say'in ;)

ozzy47 09-22-2013 12:10 AM
What do you mean by clean up threads?

IMO it is better to have the threads, so you have a record of the report, and if you or your mods took action on it, you can post in there what you did or did not due.

With that being said, I am sure it is very possible to have it as a email, but that will have to wait till Joe can get around to adding such a feature if he wishes to, or has the time to do. :)

Bubble #5 09-22-2013 12:18 AM
Quote:
Originally Posted by ozzy47 (Post 2447174)
What do you mean by clean up threads?
Clean up, as in delete them because they aren't needed anymore.

Quote:
IMO it is better to have the threads, so you have a record of the report
You can save a e-mail just as easily, and mods on my site don't have access to this section of the forum. If someone is away from their site, say they are out shopping, they would still be made aware of what was happening on their site by getting an e-mail about it.

Quote:
I am sure it is very possible to have it as a email, but that will have to wait till Joe can get around to adding such a feature if he wishes to, or has the time to do.
Yes, fully understand :)

iraqiboy90 09-22-2013 01:39 AM
Let's say;
- I have 200 users
- There are many duplicated IPs
- No more posts has been added or registration for a week.

then, does this mod create the same report 7 times?

ps. I have the gold version

Bubble #5 09-22-2013 01:45 AM
Once per night you'll get a report.

iraqiboy90 09-22-2013 02:46 AM
Quote:
Originally Posted by Bubble #5 (Post 2447202)
Once per night you'll get a report.
In other words; The same report 7 times....
Is there any option to exclude those numbers/IPs from showing on further reports if nothing new happens to them?

ozzy47 09-22-2013 03:02 AM
According to the original post: There are options for whitelisting (ignoring) specific IP Addresses and/or userids.


All times are GMT. The time now is 08:35 PM.
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

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.03129 seconds
  • Memory Usage 1,842KB
  • 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
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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