vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Cleaning up the DB from Spammer Accounts? (https://vborg.vbsupport.ru/showthread.php?t=218690)

terminator2k2 07-15-2009 10:28 PM

Cleaning up the DB from Spammer Accounts?
 
Is there someway or kind of addon to clean up the Database from spammer accounts?
Like something that uses http://www.stopforumspam.com/ to search the DB (email, and maybe ip) and to show all entries they can be deleted from the forum

I'm not talking about vbStopForumSpam.. because it blocks the new users, but cannot clean those who are already registered

James Birkett 07-17-2009 01:17 PM

Hey terminator,
I personally wouldn't recommend getting something automated to clean up your database, it could cause issues. It depends on how you want to find the spammers. It could be as easy as just running SQL queries to select spammers and displaying them as an array.
I'd recommend (using a new page) doing a mysqli and connecting to the database then running the query and displaying the results as an array, then running a query to delete them entries.
You'd need to define conditions of spammers though.. it's hard to really make a query to find spammers.
SELECT * FROM `user` WHERE `joindate` >= {date in database format} AND `postcount` >= {postcount}?

I am unsure of the best way to do this.


All times are GMT. The time now is 08:29 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.02233 seconds
  • Memory Usage 1,710KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete