WMail - a POP3/SMTP Webmailer for vBulletin

What is this?
---------------
WMail is a "webmail client" - a front end, like a mail tool installed locally on your PC, for using POP3/SMTP mailboxes.

In short:
WMail adds POP3/SMTP access to vBulletin.

A live demo can currentliy be found on my testing board here:
http://vbdev.area-42.net/wmail.php


Key features:

• The obvious: Getting mailbox content, reading mails from every POP3 mailbox and sending mails through any SMTP server (configurable in the user options)
• written from scratch, spezificially to be used with vBulletin 3.5.x - not a port of something
• fully phrased and templated down to the last bit
• Full multipart support for downloading (and sending) attachments
• When reading mail the mail text is parsed for BB-Codes, so you get the graphical smillies from the forum, text formatting and URLs automatically become clickable links
• When replying to, or forwarding, mail the text of the original mail is quoted, propper quotemarks are added and a quote-header is added (customizable via template)
• various options for admin and users to customize the webmail client
• Does NOT require any special modules to be compiled into your PHP installation (like the IMAP libraries)
  (for techies: this uses basic socket connections instead of special PHP function calls)
• Admin can override certain aspects of the user config (forcing to use a given mailserver, force using forum email address and such)
• Write your mails using vB's WYSIWYG editor
• buildin (yet simple) addressbook for your E-Mail contacts
• Read/Unread markings - unread mails are highlighted, options for "mark selected read", "mark all read" and "mark selected unread"
• custom hooks to make it easy to develop addons for it
• automatically adds links to the webmailer in "Quick Links" menu, navbar and UserCP. Usualy no template edits needed when using default ones (can be disabled for each link in admin options)

Planned features:

• Support for multiple config sets per user
  (and so multiple mailbox accounts that can be querried)
• Sort mails into folders
• User configurable filters (for automatically sorting mails into folders)
• Preview of mailtext in inbox view (bellow subject)
• Forward mails as PM / Forward PMs as mail
• Reply to threads and PMs by mail
• Give/Provide your members an own eMail adress and inbox on your forums!
  • Members can recieve and send mails as "username@forumdomain.tld" without the need for an own POP3 account anywhere
  • Admin only needs ONE "real" POP3 box as "catch all".

Installation
--------------

Level : EASY
Duration : a minute or so
Files to upload : yes (11)
Products to import : yes (1)
Templates to edit : usually none


ChangeLog
===========
1.00 - first final release

• Fixed some minor bugs
• Login details are no longer stored as plain text in the database (*see note bellow!)
• Added option to save login details in a cookie on the users local computer instead of storing them in the forum's database

* Note on storing the login details in the database:
The login details are only base64 encoded when stored in the database.
A more secure encryption would make no sense anyway, the login details must be decrypted to be passed to the POP3/SMTP server - one well placed line of additional code in the POP3 or SMTP class could save the decrypted info anywhere the admin likes.
This "encoding" is only meant to prevent login details to be read (in plaintext) when doing maintanance to the database and stepping over it.
For fully securing the login details the "Save in cookie" option has been added.

Known Issues:

• On some installations mass deletion of mails (via "Delete Selected" from the inbox view) does not delete all mails
• Sometimes you get "-4 mails in inbox" - reloading the page then shows the correct inbox again

Besides of those two issues, that do not really break the function of the webmailer, it seemed to run pretty stable so far - that's why I decided to release 1.00 without having them resolved.


(more changelog entries in the readme)

____________________
This vBulletin extension is FREE! Be welcome to download and use it.
However, if you feel like supporting further development any donation is appreciated :bunny:

[MissKalunji]

Originally Posted by MissKalunji

How would this work? with any other e-mail that uses pop3? that would cause a lot of server loads no?

bump!

[TTG]

Originally Posted by shadow smith

Is there a way to give accounts to users of vbulletin without having to make a pop account for everyone?

You might find this useful, been using it for quite a while, works well :-

Email per username

[MissKalunji]

Originally Posted by TTG

You might find this useful, been using it for quite a while, works well :-

Email per username

Nice!!

[Roms]

I'm having the same Send SMTP problem.... I've tried all different settings.. Still no joy...

[Hellcat]

Update time
I'd like esp. all the ones having AUTH issues to test again the two AUTH types available and report any changes.

• Fixed a phrase that didn't show in Admin's global settings
• Added admin option for the automatic addition of the "Webmail" links: "Never add any link", "Only add for users having propper permission" and "Always add selected links"
• When the mailbox is empty it no longer shows "An error accoured...", it now correctly displays a notice "Your inbox is empty" instead (this notice can be hidden completely by deleting the used phrase)
• "Empty strtotime() call" should be fixed, no longer causing that PHP warning and showing "N/A" when no or invalid date in mail specified
• Added option in user settings to choose between WYSIWYG editor and simple textbox (default is still WYSIWYG)
• Fixed a few things in inc_accessconfig.php - hopefully the warnings and SQL errors regarding the config are now gone....
• Added an experimental fix in the SMTP protocol that MIGHT raise compatibility with more SMTP server's requiring authentication
• Added option (in user settings) to be automatically redirected back to the "Write A New Mail" page after successfull sending

[MThornback]

error when allowing usergroups to use functions:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'WCC Forum Administrators',
`description` = '',
`usertitle` = 'Forum Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1074790399',
`attachlimit` = '0',
`pmquota` = '150',
`pmpermissions` = '3',
`pmsendmax` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '23',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`advanced_bbcode_usergroup_on` = '1',
`advanced_bbcode_usergroup_permissions` = '1023',
`advanced_bbcode_usergroup_permissions_custom` = 'a244',
`modpermissions` = '0',
`vbugpermissions` = '7',
`hc_usercountdown` = '1',
`mh_unm_permissions` = '7',
`mh_unm_changelimit` = '30',
`mh_unm_viewhistorylimit` = '1',
`awspermissions` = '15',
`googlemappermissions` = '1',
`wmailpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'wmailpermissions' in 'field list'
Error Number : 1054
Date : Monday, May 15th 2006 @ 11:49:19 PM
Script : http://www.webcadets.com/forum/admincp/usergroup.php
Referrer :/forum/admincp/usergroup.php?do=edit&usergroupid=6

Username : MThornback
Classname : vb_database

will try and add manually and see if it fixes

Edit: Manual add fixed this error....

error now on wmail.php

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT data FROM vb3_wmail_settings WHERE userid = 2;

MySQL Error : Table 'rburns_forum.vb3_wmail_settings' doesn't exist
Error Number : 1146
Date : Monday, May 15th 2006 @ 11:54:28 PM
Script : /forum/wmail.php
Referrer :
Username : MThornback
Classname : vb_database

adding manually...will edit again

fixed....

new error same page

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT name, email FROM vb3_wmail_adrbook WHERE userid = '2' ORDER BY name ASC;;

MySQL Error : Table 'rburns_forum.vb3_wmail_adrbook' doesn't exist
Error Number : 1146
Date : Monday, May 15th 2006 @ 11:58:45 PM
Script : /forum/wmail.php
Referrer :

Username : MThornback
Classname : vb_database

will edit again....

Ok...added that table manually and now it works....just have to do the settings.

[MThornback]

Ok, still small problem...I set yes for all three display options (CP, Nav and Quick Link) none of them are showing up...OTHERWISE....working as expected and truly awesome


Suggestion for next update: Add in ability to choose port for POP and SMTP....my server is anal and doesn't use standard SMTP port....so port 25 does not agree with my e-mail addresses

[Hellcat]

weird, why did not add the tables and the column at install time....
This vB install code thing gives me a headache....

But that it's working besides that, I'll tweak the installer some more.

Now I need to know if the SMTP error(s) are still present.
Seems (besides the install issue) the last remaining showstopper.

Once that's resolved we should have a 1.00 final and can head over to the new features

[VBUsers]

im getting this error. i have a prefix on my DB is that it and if so whats the change i need to do?


Database error in vBulletin 3.5.3:

Invalid SQL:
SELECT data FROM smora_wmail_settings WHERE userid=0;

MySQL Error : Table 'smora_forum.smora_wmail_settings' doesn't exist
Error Number : 1146
Date : Tuesday, May 16th 2006 @ 01:20:25 AM
Script : http://www.thenextelforums.com/admin...min_global.php
Referrer : http://www.thenextelforums.com/admincp/index.php?do=nav
IP Address : 000000
Username : LOW
Classname : vb_database



now i went to my usergroup and added my permission. i click on the wmail.php and get this error


Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE smora_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Head Administrator',
`description` = '',
`usertitle` = 'Head Administrator',
`opentag` = '<span style=\"color: orange;font-weight: bold;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '470810623',
`attachlimit` = '0',
`pmquota` = '2000',
`pmpermissions` = '0',
`pmsendmax` = '10',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520895',
`genericoptions` = '31',
`profilepicmaxwidth` = '500',
`profilepicmaxheight` = '500',
`profilepicmaxsize` = '999999',
`avatarmaxwidth` = '500',
`avatarmaxheight` = '500',
`avatarmaxsize` = '9999999',
`vbaffiliatespermissions` = '15',
`itraderpermissions` = '7',
`pagerpermissions` = '13',
`pagerquota` = '200',
`pagerminpost` = '0',
`pagerminpostperday` = '0',
`pagermaxperday` = '0',
`pagersendmax` = '0',
`pagersendmaxchar` = '300',
`que` = '4095',
`vbimghost` = '3',
`vbimghost_upslots` = '5',
`vbimghost_files` = '50',
`hackdbperm` = '15',
`vbppermissions` = '65529',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '2000.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`wmailpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'wmailpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, May 16th 2006 @ 01:43:51 AM
Script : http://www.thenextelforums.com/admincp/usergroup.php
Referrer : http://www.thenextelforums.com/admin...&usergroupid=6
IP Address : 00000000000
Username : LOW
Classname : vb_database

[VBUsers]

Originally Posted by MThornback

error when allowing usergroups to use functions:




will try and add manually and see if it fixes

Edit: Manual add fixed this error....

error now on wmail.php



adding manually...will edit again

fixed....

new error same page



will edit again....

Ok...added that table manually and now it works....just have to do the settings.

im having the same errors as you can you tell me what you did to fix this?