Troll beta

[TMM-TT]

Originally Posted by TMM-TT

Absolutely! A product, it will be.

How about this (beta-stuff-things)?

[TMM-TT]

The beta is now released at http://forum.tornevall.net/showthread.php?t=102799

[Talisman]

Originally Posted by TMM-TT

How about this (beta-stuff-things)?

That looks very useful, TMM-TT.

As for the question asked, I stopped banning trolls a long time ago. That's mostly what they're hoping you'll do and it just makes your site a challenge for them afterwards.

The miserable user's hack is great. I'll use that to begin with but if that doesn't put a stop to the misbehaviour, I'll just lock them down into an inactive usergroup with no permissions. They can't even see the forum anymore. That prevents them from continuing to use their original login/account and tips me off if they try to register again using multiple accounts.

Never delete user info on the troublemakers. That data is the best resource you have to confirm the identity of suspicious new members in the future.

[Alfa1]

Looks like the beta version creates an extra table, but leaves a empty space between the prefix and the table name. It won't work for me. That may be because I have a non standard table prefix.

However, I have been searching all around for a hack like this. Even requested one. As far as I can find, there is no other hack that can alert admins to clones, except the one working with cookies. I suspect this hack may get very popular.

[TMM-TT]

Originally Posted by Alfa1

Looks like the beta version creates an extra table, but leaves a empty space between the prefix and the table name. It won't work for me. That may be because I have a non standard table prefix.

However, I have been searching all around for a hack like this. Even requested one. As far as I can find, there is no other hack that can alert admins to clones, except the one working with cookies. I suspect this hack may get very popular.

Maybe alerting can be something to add to this plugin too, then. I should just figure out how to do that.

The beta creates an extra table called user_troll, yes. What prefix are you using that makes it not work? (I don't use any myself but got no errors when I tried to install)

[Alfa1]

I am using 'vb9_ as table' prefix. Here is the error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS entries FROM vb9_ user_troll;

MySQL Error : Table 'servername.vb9_' doesn't exist
Error Number : 1146
Date : Saturday, June 24th 2006 @ 03:35:10 PM
Script : http://www.mysite.com/forum/iptracker.php
Referrer :
IP Address : myIP
Username : Alfa1
Classname : vB_Database

I have replaced some data relating to my servername, sitename and IP.
Note that there is a space between 'AS entries FROM vb9_' and 'user_troll'

[antialiasis]

Well, I just made a quick hack that doesn't give people their validation code until they visit the bottom of the rules page. People who don't intend to follow rules generally don't bother reading them, so it's more or less been working like a charm with a couple of exceptions.

[TMM-TT]

Originally Posted by Alfa1

I am using 'vb9_ as table' prefix. Here is the error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS entries FROM vb9_ user_troll;

MySQL Error : Table 'servername.vb9_' doesn't exist

Ahh, a miss by me.

Look for this code

PHP Code:


if (file_exists("./global.php")) {
        $sql_count = "SELECT COUNT(*) AS entries FROM " . TABLE_PREFIX . " user_troll"; 


Replace with:

PHP Code:

if (file_exists("./global.php")) {
        $sql_count = "SELECT COUNT(*) AS entries FROM " . TABLE_PREFIX . "user_troll"; 


... then it should work.


Or get a modified sorce from here

[Marco van Herwaarden]

If you want to discuss and test a beta product, then please release it in the appropriate forum as a beta release, and continue discussion there.

Thanks for understanding.