vb.org Archive - Major Additions - Email Integration (New threads/replies by email)

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

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

- - Major Additions - Email Integration (New threads/replies by email) (https://vborg.vbsupport.ru/showthread.php?t=151222)

Quote:

Originally Posted by capsize (Post 1393115)

Cyricx,
Any idea when you'll have attachments working? If you post a message with an attachment via email, the post is generated properly and has a "1" in the vb_post column "attach". There's also an entry created in the vb_attachment table for the attachment. Most of the fields in this table entry are correct (postid, userid, dateline). But there's no data at all stored in the "filedata" column for this entry. So the attachment is effectively discarded even though the post shows that it has an attachment. In my case, I've got attachment processing enabled, but didn't make any of the changes to allow unknown type attachments. The attachment type I am using to test with is a small .jpg file. Posting with this attachment via the forums webpage works fine. But via email it doesn't. This problem isn't new to 2.3.1. It hasn't worked in any previous rev I've tested either. 2.3.1 looks functional enough for me to deploy on my live board if attachments work.

Capsize, can you send the email you tried to send to testforums(at)campgaea(dot)org? Also please go to your admincp -> attachments -> attachment manager and tell me if you have it set to store attachments in the database or file system.

Quote:

Originally Posted by onehost (Post 1392942)

Im not sure if you have this option or not, how would i be able to strip
out links from emails coming into the forum? It would not hurt either to be
able to strip out words, terms, sentences also.

another option is to ban individual users from sending email into the forum,
for those that may take advantage of the email system, sending emails
that should not be sent...

Thank-You

On the stripping words, links etc topic. I'll take some look into this. It shouldn't be too hard to do a quick regex with a global option. I'll add that to my list :)

On the second topic, you can easily control who's emails are processed. When you go to the forum manager and input the settings for the mailbox there is also a setting there for what usergroups can post messages from emails. This also handles secondary usergroups. So you only put those that can post to the forum in that usergroup and add that usergroup to that setting and your good to go :)

Quote:

Originally Posted by dot2slash (Post 1393307)

attachments... work fine here .. with just the issue that picture-thumbnails not crerated.
its annoying start maintance scripts manually ... to get this updated ...
but thats okay for now ... a not finished feature with a solution ;-)

hope later this will be runns automaticly.

The email script should be running automatically now... albeit vbulletin's cron system only runs when the site has traffic.. but I have not had any reports yet of the script not running when ther is traffic accessing the footer template.

Are you have issues on your site with this?

The thumbnails in pictures is definately an annoyance to me too. There's sooo much I still want to do with this. :) But some of it, I get it functional, then I pretty it up. Unfortunately there are still a few things I need to get function, hence the beta, before I go back and pretty things up like the thumbnails :)

Quote:

Originally Posted by Cyricx (Post 1393577)

I sent you a simple test post that doesn't work on my installation of 2.3.1. I've got attachments currently getting stored in the database (vb default). I'll try switching this to filesystem storage and see if that makes a difference.

Quote:

Originally Posted by Cyricx (Post 1393577)

I have the same problem with vb set for filesystem attachment storage. In the directory where the attachments get stored, a zero-byte file gets created.

I think I've figured this one out.

Line 451 of emailintegration.php is wrong. It has this:

PHP Code:


		
			
$filedata = base64_decode($attach['data']);

But this trashes the attachment data since mimeDecode has already done a base64 decode of the contents. This line always sets $filedata to 0 length for my attachments.

If I change it to

PHP Code:


		
			
$filedata = $attach['data'];

then attachments seem to work.

Scanning through the rest of the file, I see this comment ... perhaps the code on line 451 should check this variable and decode it conditionally.

PHP Code:


		
			
$mime_class = new Mail_mimeDecode;

// decodes attachments if true, turn off base64 in the files section below

$mime_class->_decode_bodies = true;

Bug verified. I'll get on a fix. It must have occured during the huge regex rewrite.

Just noticed a potential bug.

At the bottom of each email it has links:

Unsubscribe from ForumName
View thread in forum (1 replies) | Reply via forum | Start a new thread via forum
View Forums

For me, the link to "Reply via forum" goes nowhere. The format does not specify a thread ID:

http://www.blackbus.org/forum/newrep...y&noquote=0&p=

The mod worked great on a test forum, but I just can't seem to automatically subscribe everyone to the forums and default everyone to "Instant notification by email" on my live forum.

I've created separate email accounts for each forum and enabled Email Integration for the forum. I've entered the usergroup ID's that can post and reply by email. What am I doing wrong?

I was also wondering whether under the Usergroup Manager-->Email Reply Intergration Settings, whether I have to list ALL of the forumids, or whether it defaults to all if I don't enter a value.

At this time I would basically like to have all of my current registered users to be defaulted to Instant Email Notification of all forums, as well as any new members.

When runing Auto Subscriptions I get a Database error:
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT title FROM forum WHERE forumid =;

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 '' at line 1
Error Number : 1064
Date : Monday, December 10th 2007 @ 01:51:01 AM
Script : http://www.ambersight.com/forums/admincp/admin_ei.php
Referrer : https://vborg.vbsupport.ru/showthread.php?p=1398363
IP Address : 76.171.161.117
Username : lbernstein
Classname : vb_database

I'm not quite sure what the error means. Can anyone help?

I'm kinda new to this, so bear with me.

Was able to get the mod working this morning and the emails are coming through. I am having some problems with out of office and other auto replies. How are others dealing with those beyond adding more terms to the filter?

Still with a database error. Any suggestions on where to start on that problem???

L. Bernstein, MD
Damn it Jim, I'm a doctor not a coder!

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 (3)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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.01642 seconds Memory Usage 1,757KB 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 (3)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)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: