vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - Troll/ip-tracker, detect multiple accounts/trolls [3.6 compatible] (https://vborg.vbsupport.ru/showthread.php?t=119695)

Hollanda 10-18-2006 02:44 PM

Quote:

Originally Posted by TMM-TT
No, that's probably on me. I'll check it out :)

Okay thank you, I'll be waiting for it :)

The problem is caused bij two users on the same ip.

Quiz 10-26-2006 09:01 AM

Quote:

Originally Posted by TMM-TT
Yes, but blocking users is optional and can be turned off. I only block specific usernames myself but the function is there for paranoid admins ;)

Hi,

I have a question. I tried to turn off the user-blocking function. I just want to recive a message in a forum.

I get the messagge, but the user gets blocked automaticly all the time... can you help me?

greetings
Quiz

Morning Glory 11-12-2006 04:34 PM

This banned everyone this morning. I imported the product-trolltracker_beta_blockdisabled.xml and then tried to overwrite it with the original product and get this error. Now I have no product showing and can't import either of them.


Invalid SQL:
CREATE TABLE user_troll (
`idx` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`username` varchar(128) NOT NULL default '',
`userlink` int(11) NOT NULL default '0',
`forwarded_for` varchar(128) NOT NULL default '',
`browser` varchar(255) NOT NULL default '',
`http_via` varchar(128) NOT NULL default '',
`realip` varchar(15) NOT NULL default '',
`owner` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`date` date NOT NULL default '0000-00-00',
`time` time NOT NULL default '00:00:00',
`external` int(11) NOT NULL default '0',
`opm` int(11) NOT NULL default '0',
`imported` int(11) NOT NULL default '0',
PRIMARY KEY (`idx`),
KEY `uscan` (`username`,`realip`)
);
MySQL Error : Table 'user_troll' already exists
Error Number : 1050

geppeto 11-17-2006 11:55 AM

Quote:

Originally Posted by TMM-TT (Post 1098782)
Interesting.. Doesn't exit? Try reinstalling the hack :)

I get the same error. Reinstall de product and the same...

Quote:

nvalid SQL:
UPDATE user_troll SET alert = 1163771597 WHERE userid = '13' AND deleted = 0 ORDER by alert DESC LIMIT 1;

MySQL Error : Table 'xxxxx_forum.user_troll' doesn't exist Error Number : 1146
One question... my prefix is not in xxxx_forum.(prefix)user_troll, I don't know if this is the problem.

Regards

Alfa1 11-17-2006 03:08 PM

To the posters above: Are you shared hosting? If yes: see my posts in earlier in this thread. All errors sustained until I moved to dedicated hosting. That took care of the problems.

Quote:

Originally Posted by TMM-TT (Post 1078656)
Ahh, the amount it shows is the total amount of registered usernames/ip the database has registered since the install. Maybe the nickname you're looking for hasn't been "catched" yet?

The same problem persists. For some obscure reason the tracker lists certain users and does not catch others. Tracking for members which have been posting for some time does not give the expected results, while I can trace them in the adminCP. For this reason I am considering installing version 2.0.0 again, since that did allow me to track all members.

Quote:

Originally Posted by TMM-TT (Post 1083794)
Hmm, I think you have a point there... The thing I told you about just disables tracking of proxyusers. You just want to skip reports of the proxied ones. That type of function doesn't exist yet. I'll fix that too :)

Is there any update for this? Without this feature you simply get swamped in useless reports of dialup/AOL/proxy users.

Quote:

Originally Posted by TMM-TT (Post 1082958)
If you use the tracker together with the OPM-hack theres an option called "Ignore OPM-users" you can use. Described:

If the OPM-monitor is installed, use this option to avoid register users using proxies (Keeping track of users that using multiple accounts from anonymous proxies might give unreliable results in the tracker). OPM Monitor is required for this option

Looking at the OPM hack and the errors reported, puts the fear in me. I have been trying the troll tracker out from the beginning, as I would love to have this functionality. Some things are just not working yet. I have much respect for the great effort that you have put into both hacks. The following is meant as constructive and not negative in any way:

I think it would be a great idea if you would get help from an advanced vbulletin coder, to work out the issues with both hacks. I really hope that there is someone willing to review the code and work out the bugs with you. This is a very valuable hack, but it needs a full revision.

fxs158 12-08-2006 02:56 AM

can you keep people from accessing iptracker.php? Is there a way to get the entries for the last day or so?

white_2kgt 12-16-2006 02:16 AM

Is it possible for this to just log those 'trolls' and not block them? I installed this and within a few hrs I started getting emails from people that live together (husbands/wifes/roommates) saying they could get to the forum because they are on 2 usersnames. I just want it to log but not block anyone.

WATRD 12-28-2006 03:33 PM

Quote:

Originally Posted by DannyBoy8406 (Post 1098546)
Ok, this seems to work for me for so long but then it gives me a DB error:

Same thing here...

Quote:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE user_troll SET alert = 1167326811 WHERE userid = '3' AND deleted = 0 ORDER by alert DESC LIMIT 1;

MySQL Error : Table 'xxxxxxx.user_troll' doesn't exist
Error Number : 1146
Date : Thursday, December 28th 2006 @ 10:26:51 AM
Script : http://www.xxxxxxx.com/forum/
Referrer : http://www.xxxxxxx.com/home/
IP Address : xx.xx.xx.xx
Username : xxxxxxx
Classname : vb_database

WATRD 12-28-2006 03:43 PM

Quote:

Originally Posted by WATRD (Post 1146422)
Same thing here...

It looks like it decided I was a troll, then did something that caused me to get a database error. It looks like everyone it determines to be a troll was getting that DB error until I disabled the product.

I have "Block Trolls" set to "0" with version "trolltracker-2.0.4" and my user id is included in the "Specific users to exclude" section.

Any suggestions?

WATRD 12-28-2006 08:59 PM

Quote:

Originally Posted by geppeto (Post 1119300)
I get the same error. Reinstall de product and the same...



One question... my prefix is not in xxxx_forum.(prefix)user_troll, I don't know if this is the problem.

Regards

Same here. I see that it installed to the DB using the table prefix of "vb_", but for some reason when it runs, it's using the DB name.


All times are GMT. The time now is 04:58 AM.

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.01297 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
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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