Thread: Administrative and Maintenance Tools - EZ Bounced Email Management for Admins
View Single Post
  #682  
Old 02-20-2010, 07:06 PM
edward hamilton edward hamilton is offline
 
Join Date: Mar 2007
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I know some people won't like this but after having seeing too many users trying to reuse email addresses that bounce, I modified exbounce.php
after
PHP Code:
// Update all of bouncing user's subscribed FORUMS to emailupdate = 0
        
$vbulletin->db->query_write("
            UPDATE " 
TABLE_PREFIX "subscribeforum
            SET emailupdate = 0
            WHERE userid = " 
$buser['userid'] . "
        "
); 
I added
PHP Code:
//  #########  ADD BOUNCED EMAIL ADDRESS TO BANNED EMAIL ADDRESS

         // Get list of banned email addresses from the datastore
        
$banned_email $db->query_first("
            SELECT data FROM vb_datastore
            WHERE title = 'banemail' "
);
        
        
$banned_email $banned_email['data'];    

        
// Get new email address to ban from bounced email address 
        
$userid $buser['userid'];
        
        
// Get new email address to ban from bounced email address 
        
$bemail $db->query_first("
            SELECT email FROM vb_user
            WHERE userid = '
$userid' ");
        
        
$bemail $bemail['email'];

        
// Add new bounced email address to existing banned email addresses
        
$banned_email "$banned_email $bemail"
        
        
// Update banned email list  

        
$vbulletin->db->query_write("
            UPDATE " 
TABLE_PREFIX "datastore 
            SET data = '
$banned_email'
            WHERE title = 'banemail' "
);
             
            
//  ######### 
Now when I follow the link in the bounced email the bounced email address is added to the banned email address list in vB options.

I'd like to add another link in the bounced email that would switch to this additional script, but for the time being this will do for now for me. Something like appending another variable ($b) to the end of the email bounce link like if(isset($_GET['b'])){ execute above code}

I only bounce email address that are clearly spam like mail.ru sdffjk@gmail and those with spammy usernames.

This certainly won't work for everyone but it might give you an idea so you can tailor this great mod to work better for you.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01453 seconds
  • Memory Usage 1,789KB
  • 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
  • (2)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