Thread: Administrative and Maintenance Tools - vbStopForumSpam - known spammer lookup for new registrations
View Single Post
  #744  
Old 11-09-2009, 10:54 AM
techtir techtir is offline
 
Join Date: Sep 2009
Location: Ireland
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here is the code from the "submit" to stopforumspam. It's the plugin add on I got from this thread with one small change.
PHP Code:
if (is_member_of($user['usergroupid'], 8)) // we dont want to ban our admin account now do we
        

            
print_table_break(''$INNERTABLEWIDTH);
            
print_table_header("vbStopForumSpam");
            if (
$vbulletin->options["vbstopforumspam_apikey"])
                
print_label_row('Submit these details to www.stopforumspam.com ban list<BR><table><tr><td>Username:</td><td><input type="text" name="username"  size="30" value="'
$user['username'] . '"></td></tr><tr><td>Email:</td><td><input type="text" name="email"  size="30" value="' $user['email'] . '"></td></tr><tr><td>IP:&nbsp;</td><td><input type="text" name="ip_addr"  value="' .$user['ipaddress'] . '"></td></tr></table><input name="api_key" type="hidden" value="' $vbulletin->options['vbstopforumspam_apikey'] .    '"><input onclick="this.form.action=\'http://www.stopforumspam.com/add.php\';this.form.submit()"  type="button" class="button" value="' $vbphrase['submit'] . '"/>');

            else
                
print_label_row('You need an API key from www.stopforumspam.com before you can submit to the database' ,'');    
        } 
Changed line
if (is_member_of($user['usergroupid'], 8))
Note it's now ==8, banned Group, rather than != Admin Group

This means the box with email, username, IP and submit to stopforumspam only appears if you banned user (i.e. automagically via Delete all posts as Span etc)
I haven't added anything else.
But this is where you would add two SQL statements, one to add email and other to add IP to the database normally accessed manually in VBoptions User Banning settings.
Then assuming all the spammer's posts where physically deleted you can now safely delete the user.
I usually also manually add IP used and email quoted in the Spamvertisment that is deleted, as well as the user account IP and email.

None of this is automatic, I'm only suggesting that that's what I would automate and where I'd add it.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01222 seconds
  • Memory Usage 1,780KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete