Administrative and Maintenance Tools - [DBTech] vBMail v2 (vB4)

vBMail: What is it?
vBMail is a professional mailing list mod with Bounced Mail handling and advanced subscription management features.

Uses

vBMail is the perfect solution for any forum who wish to send out large quantities of mail to users on a mailing list. It lets admins and users have fine-grained access to subscriptions, and also automatically handles bounced mail.

-------------------------------------------------------------------------------------------

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Priority support & Product Demos available at: http://www.dragonbyte-tech.com/

-------------------------------------------------------------------------------------------

Translations available @ our forum
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------

Major Features:

Bounced Mail Handling: Once configured, it will (if so desired) automatically track and handle bounced mail. Alternatively, you can manually handle bounced mail if you so wish.

Automatic "Unsubscribe" Link Creation: If the user receiving the mail has access to unsubscribing, a secure link to unsubscribe themselves from the mailing list will be automatically added to the bottom of the mail. It does not require the user to be logged in, so it complies with spam policies set forth by mail providers.

Mail History: Each past sent mail can be viewed at any time from the front-end.

Advanced Subscription Management: Users can quickly and easily (un)subscribe from the mailing list via the mailing list directory, or the admin can manually change the subscription status in the AdminCP.

Bounced Mail Threshold: When an admin-configured number of mails bounce from the same email address, the user is automatically removed from mailing lists and all other email-related vBulletin features, and notified via PM what happened to their account, as well as directions to change their email addresses.

Complete Feature List (Lite)

• Mailing List Directory
  • List all mailing lists
  • Links to send mail / view mail history / (un)subscribe
  • Unsubscription stats
• Send Mail
  • Uses the full editor in vBulletin
  • Works with 4.1.4's CKEditor
  • Uses vBulletin's Mail Queue system to avoid overloading servers / avoid "maximum mails per hour" server restrictions
• Mail History
  • Displays a list of all mail from that mailing list
  • View the mail in full HTML
  • Unsubscription stats
• (Un)subscribe
  • One-click to add or remove from a mailing list
• AdminCP
  • Create unlimited mailing lists with per-list usergroup permissions
  • Create keywords for people to subscribe to
  • View list of bounced mail
  • Prune list of bounced mail
  • Permissions for who can view unsubscription stats
• Scheduled Tasks
  • Hourly collection of bounced mail
  • Hourly checks for number of bounces above the threshold

Complete Feature List (Pro)

• Send Mail
  • Subscribe to an external mailing list via the vBulletin Sidebar (vB4 only)
  • Override SMTP settings per mailing list
• AdminCP
  • Ability to create External mailing lists, powered by emails not found in vBulletin user accounts

-------------------------------------------------------------------------------------------
This mod displays a copyright notification in the footer of pages generated by this mod which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[cisoprogressivo]

I decided to reinstall vBMail and I get a lot of this error:

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE forumvb_user SET
usergroupid = 2,
usertitle = 'Baby Android',
customtitle = 0,
dbtech_vbmail_bounceflag = '0',
displaygroupid = 0
WHERE userid = 49125;

MySQL Error : Unknown column 'dbtech_vbmail_bounceflag' in 'field list'
Error Number : 1054
Request Date : Monday, July 16th 2012 @ 12:08:37 PM
Error Date : Monday, July 16th 2012 @ 12:08:38 PM
Script : http://www.androidworld.it/forum/reg...fd9295a3ac9827
Referrer :
IP Address : ***
Username : ste9822
Classname : vB_Database
MySQL Version :

[DragonByte Tech]

Run these 2 queries:

alter table forumvb_dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'

alter table forumvb_user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'

Fillip

[cisoprogressivo]

Originally Posted by DragonByte Tech

Run these 2 queries:

alter table forumvb_dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'

alter table forumvb_user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'

Fillip

Thank you!

[dany_danay]

Sorry, but i want to send an HTML email, but when i put it in the ck editor, obviously, it doesnt parse... I can send html mail?

[DragonByte Tech]

Yeah, you can send HTML email

You can test it by creating a new mailing list only you have access to, then send a test HTML email


Fillip

[rebelde]

Fillip,

Great job with the bounced email handling. I'm not sure you understand what a big deal this is. Building on your code, we can now block a lot of outgoing emails that will bounce.

I just created an add-on modification (the Poor Man's Bounced Email Handler) that uses your vBMail as a basis to block "new post" notifications. I hope you don't mind and that people find it useful.

[DragonByte Tech]

I had a quick look at your code, unless I'm reading it wrong I think it's already covered by vBMail

The hook you used is executed in exec_send_notification, and the query only returns users that match

subscribethread.emailupdate IN (1, 4)

whereas part of vBMail's "remove the user from everything email related" cron job code is setting that column to 0 - so in theory it shouldn't fetch users vBMail has dealt with

For the record; we'll never give permission to re-use our code


Fillip

[rebelde]

Originally Posted by DragonByte Tech

unless I'm reading it wrong I think it's already covered by vBMail

There might be a bug. Without my small bit of code, emails were still being sent out to users whose emails were bouncing. With my code, those emails stopped going out.

[DragonByte Tech]

vBMail v1.1.7:
Feature: The Affiliate ID setting now properly integrates with the link-back

Fillip

[DragonByte Tech]

Affiliate ID link hotfix

Fillip