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)

Alfa1 12-28-2006 10:49 PM

My forum has become slower and slower until it started crashing(time outs) daily. Then I tried many things, but nothing helped. Then I deactivated the troll tracker and my site was as speedy as ever again. There are quite a lot of entries in the tracker. Is it possible that the amount of entries caused my site to slow down so much that it crashed?

dutchbb 12-29-2006 01:45 PM

Quote:

Originally Posted by Alfa1 (Post 1146611)
My forum has become slower and slower until it started crashing(time outs) daily. Then I tried many things, but nothing helped. Then I deactivated the troll tracker and my site was as speedy as ever again. There are quite a lot of entries in the tracker. Is it possible that the amount of entries caused my site to slow down so much that it crashed?

Looks like I'm in the same boat. I got high loads yesterday and today the load was over 200, shortly after I got a database error. I disabled the script and everything was back to normal...

parabat 12-30-2006 10:14 PM

Hi

Can anyone tell me why I'm getting this error when I run a general report?

Warning: preg_replace(): Compilation failed: nothing to repeat at offset 0 in /iptracker.php on line 9

I'm running vB3.6.4

-Parabat

Keyser S?ze 01-15-2007 01:15 PM

ok my site went down for a few hours, qwhen it came back up i was getting this error

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * from user_troll WHERE userid = '2230' AND realip = '71.161.49.82' AND deleted = 0 AND fqdn = 0 ORDER BY timestamp DESC LIMIT 1;

MySQL Error : Can't open file: 'user_troll.MYI' (errno: 145)
Error Number : 1016
Date : Monday, January 15th 2007 @ 09:11:38 AM
Script : http://www.emuasylum.com/forums/index.php
Referrer :
IP Address : 71.161.49.82
Username : Ice
Classname : vb_database

any suggestions?

UncoderMom 01-15-2007 06:07 PM

Is there a way to stop this from counting aol proxie users from being marked as trolls?

Sadie Frost 01-18-2007 09:17 PM

Quote:

Originally Posted by Keyser S?ze (Post 1159775)
ok my site went down for a few hours, qwhen it came back up i was getting this error

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT * from user_troll WHERE userid = '2230' AND realip = '71.161.49.82' AND deleted = 0 AND fqdn = 0 ORDER BY timestamp DESC LIMIT 1;

MySQL Error : Can't open file: 'user_troll.MYI' (errno: 145)
Error Number : 1016
Date : Monday, January 15th 2007 @ 09:11:38 AM
Script : http://www.emuasylum.com/forums/index.php
Referrer :
IP Address : 71.161.49.82
Username : Ice
Classname : vb_database

any suggestions?

Try running a repair on your tables from the admincp. I know I've had those MYI errors before and I *think* that's what I did to fix them but you might just want to search on vb.com about it to be sure. :)

As for the whole user_troll file not existing error, I've been trying to help DannyBoy8406 with fixing this, and he too has a table prefix. So it looks like the hack is not calling the table prefix from the config file properly. Not sure how to fix it other than adding it manually. Anyone have any ideas?

Sadie Frost 01-18-2007 09:22 PM

Okay I think I've got it. On line 273 of the xml file

Code:

        $vbulletin->db->query_write("UPDATE user_troll SET alert = " . TIMENOW . " WHERE userid = '" . $vbulletin->userinfo[userid] . "' AND deleted = 0 ORDER by alert DESC LIMIT 1");
Update user_troll is missing the table prefix. :)

swatkins 01-23-2007 02:52 AM

With this mod track all the IP's a user has used before? Is it stable enough to install now?

Ignicoccus 01-23-2007 09:18 AM

Hi,

I installed the Mod today. It began showing the expected data in "Who is online". I disabled "Block Trolls" (value 0). But some AOL useres were locked out of the forum. I could not see an option to disable this, any hints ?

There were four useres from AOL who go a message like this :

Quote:

iptracker v2.0.4
225 entries in tracker
Your ip is x.x.x.x.
You have been using the following nicks:
nick1
nick2
nick3
nick4
(IP and nicknames have been changend)

Thy were blocked out, but the system did not send a PN to inform me.

I disabled the mod to let these users back in, any way to fix this problem ?

Harley-Heaven 02-01-2007 06:43 PM

Just wanted to say "THANKS!!", this worked like a dream!!

I have two ID's on my board - it caught me...... plus it alerted us to two husband and wife members, which we knew about. Gives us a real comfort feeling.

Excellent mod!! Great work.


All times are GMT. The time now is 08:04 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.01084 seconds
  • Memory Usage 1,743KB
  • 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)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