vb.org Archive - Administrative and Maintenance Tools - EZ Bounced Email Management for Admins

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Administrative and Maintenance Tools - EZ Bounced Email Management for Admins (https://vborg.vbsupport.ru/showthread.php?t=138884)

Quote:

Originally Posted by Antivirus (Post 1570926)

There's a macro application that some members are using in tandem with this mod, it's a few pages back.

I couldn't understand which one it's...

Look at the post above yours. The quote from Devices, comes from his post explaining all:

Quote:

Originally Posted by Devices (Post 1524461)

I am no PHP expert, my PHP knowledge is very basic but this is what I did.

In ezbounce.php on line 46 look for

Code:

$vbulletin->input->clean_gpc('r', 'u', TYPE_UINT);

Change it to

Code:

$vbulletin->input->clean_gpc('r', 'u', TYPE_STR);

Then on line 51 look for

Code:

WHERE userid = " . $vbulletin->GPC['u'] . "

Change it to

Code:

WHERE email = " . $vbulletin->GPC['u'] . "

Now the URL will except your users email instead of their userid.

You just need to use

Code:

http://yourdomain.com/forum/admincp/ezbounce.php?u=(USERS@EMAIL)

To process the user, replacing (USER@EMAIL) with your actual users email address.

Regarding the Macro, I use Macro Express and it is quite basic but very specific to me so sharing it would not really help you. Here are the steps I carried out though.

I sent a mass mailing to members, and the bounces start to arrive.
I then use eMail Bounce Handler to grab and handle the bounces.
After about 24 hours I have the majority of the bounces so I export all the hard bounces to a txt file.
Then I use Macro Express to process the list.

The macro basically doe this

Brings the txt file full of emails one per line to the front.
Positions the curser at the front of the first line then cuts the first line
Presses delete to remove the blank line left after the cut.
Brings my browser to the front and selects all in the URL box.
Types in the ezbounce URL stopping after the "="
Pastes the email address and hits enter
A 5 second delay then it repeats itself.

Very primitive I know but it does the job. If I had more time I would learn how to read in a txt file and process the emails all within the script but it was quicker for me to just use a macro at this time.

Now the end result I just have some soft bounces left that I can check more closely before adding them to a list.

Over the next few days there will be some odd bounces etc so I can wait and process them later.

I hope this helps and if you do use Macro Express and want my macro file as a starting point I am happy to share. You will need to tweak it specific for you but I can help with that if you need it.

eMail Bounce Handler
Macro Express

Quote:

Originally Posted by djbaxter (Post 1572744)

You forgot to change the version number from 1.10 to 1.11 in the XML file for July 9 update.

(doh!) thanks for pointing that out. fixing right now :)

Quote:

Originally Posted by Alfa1 (Post 1574438)

Thanks!

This gives me errors:

PHP Code:


		
			
Database error in vBulletin 3.7.1:

Invalid SQL:

            SELECT * FROM vb_user
    WHERE email = user@hotmail.com;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@hotmail.com' at line 2
Error Number  : 1064
Request Date  : Sunday, July 13th 2008 @ 09:58:03 PM
Error Date    : Sunday, July 13th 2008 @ 09:58:03 PM
Script        : http://www.mysite/forum/admincp/ezbounce.php?u=user@hotmail.com
Referrer      : 
IP Address    : xx.xx.xx.xx
Username      : Alfa1
Classname     : vB_Database
MySQL Version : 5.0.45

I am using vb 3.7.1 PL2

Could you able to fix it? I've the same problem.

Quote:

Originally Posted by NeutralizeR (Post 1576326)

Could you able to fix it? I've the same problem.

This would have been the solution to automatize it completely.

Does this work on 3.7 version?

It's working fine for me - 3.72 PL1

Thanks DJ, I seen another mod that puts the users into the group for you but it's not working so this one looks just fine, Cheers.

Also what if the member becomes active again and he's in this bounced email group or Users Awaiting Email Confirmation, If they update there Email Address how do they get back to Registered members?

Quote:

Originally Posted by djbaxter (Post 1598363)

It's working fine for me - 3.72 PL1

I've tried it in 3.7.2 PL2 and it simply doesn't work. Whether I set it to leave the link in the email or in the header, it never appears on the bounced messages that are returned to me. I've tried several email clients. Same difference.

I'd love to use it if I could have a working version. And the other bounce management system for 3.7.x is only partly functional.

Peace,
Gene

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02154 seconds Memory Usage 1,755KB 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 (5)bbcode_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: