vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Moderators Functions - One-touch Spam Ban and Cleanup (https://vborg.vbsupport.ru/showthread.php?t=156444)

blind-eddie 10-30-2007 11:05 PM

Is there any way to undo a delete of a member done in error, He had over 15,000 Threads & Post, vast amounts of info. One of our Admins did unknowingly. Please help me out, Thanks, Tim

ETDC 10-30-2007 11:16 PM

^ I doubt this plugin did that. By default, after 30 days I think it is, accounts become protected against its use.

Nope - someone used the regular delete function... cue horror music! :eek:

You might want to speak to whoever hosts your board. Maybe, you can retreive it from the database. I doubt it though.

blind-eddie 10-30-2007 11:23 PM

Yep, I will install a backup of my site from this morning then, no problem...Thanks for your help though.

I backup my site 2 times a day, plus my host backs it up every day....

skippybosco 11-01-2007 02:12 AM

Our site has tried to take a stance to remove barriers of entry by not currently implementing captcha and email authentication. So far (knock on wood) we've been very fortunate to have a low rate of spam among our 2,000+ active users but a tool like this certainly helps when one does creep in.

I've been using http://www.stopforumspam.com as a means to validate and report spam on my site and while manual today, has been quite useful. It basically is a central database of known username, email and IPs that have been connected to SPAM behavior. They do have an API, however, for PUTs and GETs which could automate the process.

What do you guys think about implementing a hook into One-Touch (or potentially a new mod altogether perhaps?).. I'm imagining it could work one of many ways:

1) Regular cron that updates the Ban or restrict IP , usernmae or email with known Spammers
2) On registration a check is made against IP, email and/or username and based on configuration can block or add to a different user group.
3) On post a check is made against IP, email and/or username and based on configuration can block or require moderation of the post.
4) When a SPAM user or Post does make it through and you need to Ban via One Touch, the details of the user information are sent to the central database so that other forum members can benefit by the early detection.

JtChurch925 11-03-2007 05:17 PM

This mod definitely looks like quality stuff, I only wish I could use it.
I have MySQL 4.0.27, a fact which I now regret, but as I am a little hesitant to go upgrading the database of my live site for fear of having the whole thing crash, I had to find an alternative to One-touch.

I found the Spam Decimator mentioned earlier in this thread, and it actually works with earlier versions of MySQL. It also says that it is a vB 3.5 plug, but it seems to work ok with my 3.6.8 forum.

So just an FYI to those that find they are unable to use this fine plug, there is another that will work. :)

skippybosco 11-04-2007 05:21 AM

FYI, I went from 4.0.27 to 5.x as part of a Host move recently with no ill effects. Set up a test server and do a dry run of the import before you do your live site and you just may be ok.

Sarthek 11-04-2007 07:20 AM

Hi, looks like promising. Will give it a try soon.

One question though. Is it possible to give an option to input preset password to confirm deletetion. I dont want to see delete member with 15.000 posts by accident, or if someone gets into forum with admin account to make unrevertable damage.

thompson 11-05-2007 08:26 PM

sounds good.

needaltuna 11-07-2007 02:53 AM

Thanks for the top mod.

wragge11 11-08-2007 10:21 AM

Installed - Thanks!

Invalid ID 11-09-2007 04:57 AM

It's working great in user's profile, but I don't see the link in postbit.

Plz help. Thanks

afullcup 11-18-2007 12:46 AM

Help please. I had to use this hack this morning on a PM spammer. They got 1500 PMs out before I caught it. So, they are all deleted now, but my users are still seeing a message that they have 1 New message, but when they go to their PM box there's nothing there. How can I remove the message for them?

Pebbled 11-18-2007 02:32 AM

This looks absolutely perfect for dealing with unwanted spammers, the satisfaction of removing all their handiwork in less time than it took them to create all the spam in the first place is incredible.

I note that in the settings you can specify your 'Banned' usergroup ID, could a different usergroup be applied here -- as in 'Miserable', rather than 'Banned', in order to make their lives totally miserable from this point on?

benFF 11-18-2007 04:36 AM

It would be great if a report of the deleted user could be posted to a specified forum :)

akonze 11-18-2007 02:41 PM

Hi all,

sounds like a great mod, but I can not install it. My server is hosted by 1&1, europes biggest webhoster and they do have MySQL 4.0.25 at the moment. Is there any chance you could update this mod for earlier MySQL versions?

afullcup 11-19-2007 01:31 PM

Quote:

Originally Posted by afullcup (Post 1384712)
Help please. I had to use this hack this morning on a PM spammer. They got 1500 PMs out before I caught it. So, they are all deleted now, but my users are still seeing a message that they have 1 New message, but when they go to their PM box there's nothing there. How can I remove the message for them?

anyone?

ozmazdaclub 11-21-2007 11:37 PM

Installed it at 6pm last night (AEST) and first spammer detected and spam banned and cleaned at 6:15pm (AEST). Worked like a dream. All my moderators love it. Excellent work!

jmurrayhead 11-23-2007 06:28 PM

What makes this not compatible with the 4.0.24-nt-max version of MySQL? I can't use it because of that :(

Seiyaboy 11-24-2007 04:25 PM

This looks very nice indeed, but I have a question about this before I install it. Do this modification require admins and mods to be logged into their admin/mod cps in order for the banning and thread/post deleting to take place? Or as long as the usergroup permission matches, no extra login is needed? Thanks in advance.

Fungsten 11-24-2007 08:10 PM

Quote:

Originally Posted by Invalid ID (Post 1378878)
It's working great in user's profile, but I don't see the link in postbit.

Plz help. Thanks

Same here. 3.6.8 PL2

ParsianSat_Net 11-26-2007 08:27 AM

Dear
hello
I'm banned user
automatic banned IP?

cyberws 11-26-2007 07:37 PM

This should make cleanup after a spammer easier. Thanks. :)

weeno 12-13-2007 11:29 PM

An issue that we've seen.

If you try to "one touch ban" from a user's name in the postbit, it tries to ban the 1st poster in the thread, not the user whose name you've clicked on.

Obviously, it's the wrong variable is being used.

arn

DssCrazy 12-13-2007 11:33 PM

1 Attachment(s)
something needs to be added!

Look at the pic! i pointed it out!

Todecay 12-20-2007 08:29 PM

seriouly a great mod...thanks a lot m8!!

tekguru 12-24-2007 06:54 PM

Any ideas why we are getting this message when trying to run?

PHP Code:

Database error in vBulletin 3.6.8:

Invalid SQL:

                
DELETE FROM vb_pm WHERE pmtextid IN (SELECT pmtextid FROM vb_pmtext WHERE fromuserid 21443);

MySQL Error  Got error 134 from storage engine
Error Number 
1030
Date         
MondayDecember 24th 2007 08:37:24 PM
Script       
http://www.4winmobile.com/forums/misc.php
Referrer     http://www.4winmobile.com/forums/misc.php?do=spamcleanconfirm&u=21443 

It's been running flawlessly for ages...

RS25com 12-25-2007 09:11 PM

Edit - admin error - one of the admins gave public access to the tool and Google/Yahoo was hitting the link and deleting everyone. :o

RS25com 12-25-2007 09:42 PM

Quote:

Originally Posted by mfyvie (Post 1409070)
The issue you described was fixed in 1.0. Can you confirm that you are seeing that issue in version 1.1?

There is a protocol for reporting security issues with mods. It usually involves contacting the author first and/or the vbulletin.org team. I don't think it's helpful for you to announce to everyone to disable the product. I do think however it would be useful for you to liase with me if you feel this product is in any way responsible that I can also confirm that.

Please see my edit above - it turns out someone (admin?) changed one of the templates and allowed anonymous access to the tool.

I've removed it just in case, which is unfortunate as it's a great product.

tekguru 12-25-2007 09:56 PM

Just goes to show tools like this are powerful and need to be given to Mods only!

leeman 12-26-2007 07:08 AM

Installed and works like a charm.

Thnx!

Fungsten 12-26-2007 07:38 PM

Quote:

Originally Posted by Fungsten (Post 1388817)
Same here. 3.6.8 PL2

I see it now! It's set for users that have registered in less than 30 days.

mark|3 12-27-2007 03:39 AM

Hi, i tried to install the following product but i get this error message.

The following dependencies were not met:

1. This product is not compatible with version 4.0.16-standard-log of MySQL. (Compatible starting with 4.1)

Thanks

COBRAws 12-28-2007 03:25 PM

How come i never ran across this mod? Thanks for your quality works Mark!

Pcwolfx? 12-29-2007 09:35 AM

very beatiful add-on. thanks.

Arbit3r 12-29-2007 02:01 PM

GREAT! thanks best tool out there

Saviour 12-29-2007 02:38 PM

This is an excellent idea...downloaded and installed.

I haven't had the need to use it, as of yet, but just wanted you to know that installation went perfectly with no errors. I'm currently running vB 3.6.8 PL2.

I'm sure my Moderators will love this...making their job so much easier.

I also nominated this for MOTM.

Very nice job!

stanleys 12-30-2007 05:24 AM

Terrific mod, thanks for making it.

Unfortunately the link only shows up on the member's profile, and not in the the drop-down on the postbit as shown in the screenshot. Any reasons on why this might be happening?

telc 01-01-2008 11:50 PM

Can you please fix the addon so it will work with MySQL > 4.0.16 the same as VBulletin requirements?

adam75south 01-04-2008 08:32 PM

installed and works like a charm!!! i just converted from phpBB so i won't know what to do after i get rid of all my spammers. i might be sad.

nbaphenom 01-07-2008 01:11 AM

Quote:

Originally Posted by telc (Post 1413497)
Can you please fix the addon so it will work with MySQL > 4.0.16 the same as VBulletin requirements?

Hey man i 2nd this i have the same issue and cannot install.


All times are GMT. The time now is 09:32 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.03084 seconds
  • Memory Usage 1,819KB
  • 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_php_printable
  • (5)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
  • (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