vb.org Archive
Page 11 of 12 « First 910 11 12
Show 40 post(s) from this thread on one page

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)

cheekymonk3y 02-23-2007 05:40 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?
pity i never read this thread before having my forum totalled for a whole 30 hours. The exact same thing as the above user happened with me, and i never noticed the slowdown after i installed, but members began picking it up after a few hours. The forums were creeping and activity was 95% down, anyway, i eventually figured things out and uninstalled and everything went hyper. The reason for the slowdown i think is because the mod interrupts the page load. Ftp/downloads/non-vb pages worked perfectly.

TMM-TT 04-22-2007 10:48 AM
Yes, I've discovered the bottlenecks myself with this hack after a quite long period now, and due to IRL-delays I haven't been able to answer for a long time. I'm also thinking of making a brand new version in a (hopefully) close future, that should work better than this..umm..crap. :p

I'm sorry for this and all my "lagging"..

valdet 04-22-2007 01:29 PM
Does this work on vB 3.6.5 too. I need this bad..

Alfa1 05-13-2007 12:19 AM
TTM: My database is incredibly huge now. I'd like to get rid of the troll tracker until you have created something better.

Can you please tell me how to un-install this in a way so that my database goes back to normal? Please be specific. I am very scared to do something wrong.

TMM-TT 05-13-2007 12:51 AM
Quote:
Originally Posted by Alfa1 (Post 1246527)
TTM: My database is incredibly huge now. I'd like to get rid of the troll tracker until you have created something better.

Can you please tell me how to un-install this in a way so that my database goes back to normal? Please be specific. I am very scared to do something wrong.
I don't think there will be no problems... Actually, I think the only thing you need to do is to disable the hack from the product manager. If you uninstall it, the table should be dropped, but in case of any possible problems I'd prefer to disable the hack first. After disabling, you can do whatever you want with the table :)

Alfa1 05-13-2007 02:04 AM
Which tables should I delete?

Karolis_S 05-28-2007 08:29 PM
Quote:
Originally Posted by TMM-TT (Post 1233284)
Yes, I've discovered the bottlenecks myself with this hack after a quite long period now, and due to IRL-delays I haven't been able to answer for a long time. I'm also thinking of making a brand new version in a (hopefully) close future, that should work better than this..umm..crap. :p

I'm sorry for this and all my "lagging"..
What about new better version? Can we hope to see it soon?

This was the best sollution I have ever seen, but as I read the forums goes slowly... Please let us know if you are creating something, or we have to look any solusions in other threads...

Big Thank you.

TMM-TT 07-17-2007 04:26 PM
Quote:
Originally Posted by Karolis_S (Post 1256448)
What about new better version? Can we hope to see it soon?

This was the best sollution I have ever seen, but as I read the forums goes slowly... Please let us know if you are creating something, or we have to look any solusions in other threads...

Big Thank you.
The problem with the old script is that every single hit to the forum are controlled and registered to the database. The controlling part should limit the database size, to prevent duplicates, but instead when the database grows larger, it's almost impossible to handle, especially if the board is big. I still have no good solution for this, but I've been working with similar things that still is working quite nice - and is a bit coorporative with the AE-Detector.

Of course, there could be a possibility to make it work as the DNSBL-Plugin does, by caching the lates nicknames, but still, if the database is too large there might be some problems with the speed.

Due to a lot of "side-work", my time is limited, but I'll try to make an upgrade soon. If you have any suggestions on how to make the tracker better, that would be nice too. :)

twilighthush 08-05-2007 06:27 PM
I'm getting errors that look like this:

Quote:
Connecting to destination database...

Warning: mysql_connect() [function.mysql-connect]: Access denied for user '[usernamehere]'@'localhost' (using password: YES) in /trollpost.php on line 77
Unable to reach forumdatabase
I edited the username and password in the php file when it failed the first time, and it still doesn't work. Any advice?

bikers 08-06-2007 05:23 PM
Quote:
Originally Posted by Ski-Whiz (Post 1061254)
Ok I have found a bug:

Code:
Invalid SQL:
UPDATE user_troll SET timestamp = 1156627674, date = '2006-08-26', username =
'dabear's are #1', userid = '0', time = '17:27:54', opm = '0', imported = 0 WHERE
idx = '9830' AND deleted = 0 AND fqdn = 0 LIMIT 1;

MySQL Error  : You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 's are
#1', userid = '0', time = '17:27:54', opm = '0', imported = 0 WHERE idx = ' at line
1
Error Number : 1064
Date        : Saturday, August 26th 2006 @ 05:27:54 PM
Script      : http://www.xxxxxxx.com/forums/register.php
Now this error is from anyone who uses an apostrophe in their username. The name I tried to register is "dabear's are #1"

This leaves us all open to a SQL attack..


Im still getting this error with 2.0.4. When is there going to be an update or fix for this?


All times are GMT. The time now is 09:15 AM.
Page 11 of 12 « First 910 11 12
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.01081 seconds
  • Memory Usage 1,747KB
  • 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
  • (6)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
  • (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