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

[DragonByte Tech]

Are you using a 3rd party plugin manager? It looks like your product manager is incapable of correctly running install scripts

You might want to try a reinstall.


Fillip

[pedroenf]

And another one when editing the mailing list activating the Default Subscribed or creating one with Default subscribed field selected:

Database error in vBulletin 4.1.5:

Invalid SQL:

INSERT IGNORE INTO vbdbtech_vbmail_subscription
(userid, mailinglistid)
(
SELECT userid, 1 AS mailinglistid
FROM vbuser AS user
WHERE (
FIND_IN_SET(6, membergroupids)
OR usergroupid IN(6)
)
AND user.dbtech_vbmail_bounceflag = '0'
);

MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054
Request Date : Monday, August 15th 2011 @ 12:20:20 AM
Error Date : Monday, August 15th 2011 @ 12:20:21 AM
Script :
Referrer :

MySQL Version : 5.5.15


Too many errors in the plugin. I would like to try it before consider buying it but probably will unninstall it. Sorry

[pedroenf]

Originally Posted by DragonByte Tech

Are you using a 3rd party plugin manager? It looks like your product manager is incapable of correctly running install scripts

You might want to try a reinstall.


Fillip

Never thought of that. yes i am. Let me disable it and try reinstall. I'll let you know in just a moment

[pedroenf]

Well, the mailing list problem is solved (but had exec that bd query for the 'external' column anyway), but the member email editing in CP remains

[DragonByte Tech]

Well the problem isn't this mod - or you'd be seeing 5 pages of people complaining about this error.

ALTER TABLE vbuser ADD dbtech_vbmail_bounceflag ENUM('0', '1') NOT NULL DEFAULT '0'

Fillip

[pedroenf]

Originally Posted by DragonByte Tech

Well the problem isn't this mod - or you'd be seeing 5 pages of people complaining about this error.

ALTER TABLE vbuser ADD dbtech_vbmail_bounceflag ENUM('0', '1') NOT NULL DEFAULT '0'

Fillip

No doubt about that neither i said that Just asked for help and thank you for it :up:
Member email edit in CP solved.

But i have another question, isn't supposed to have all member in mailing list if selected in Default Subscribed option?

[DragonByte Tech]

It wouldn't have, because of the aforementioned error. Delete the mailing list and re-create it, then it will work


Fillip

[pedroenf]

It worked Thanks

[Goatpod]

Having a problem with the Editor; I'm presuming that all controls should be showing when creating mail and not just two arrows, and I'm presuming that there may be a problem with my installation (I've disable all hacks except vbMail and still get the same result). Any pointers where to look next would be appreciated. Image attached shows what I'm seeing. Thanks in advance for any help.

[DragonByte Tech]

Have you customised any templates? We've received no reports of similar issues appearing on 4.1.5 (and we're running it on DBTech as well), so I'm rather stumped...

Fillip