vb.org Archive

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)

tekguru 11-30-2007 12:16 PM

In and loaded Chris looking good apart from the known issue with the BBCode Table Mod.

AyeCapn 11-30-2007 01:04 PM

donated-izzledededed!!!!111oneone1!!!eleventy

Cyricx 11-30-2007 07:46 PM

Thanks guys!!!

BBcode mod is definately on my todo list.

onehost 12-01-2007 02:28 AM

question: is this just a one way email??

I send email from my account to the forum, it imported just fine, but
when i replied, or even post a new thread, nothing was sent back??
any reason why...

and concerning the multiple email accounts, so if i have 50 categories,
well thats a lot more then what i would want to do as a user, save
all those emails...

Thank-You

dot2slash 12-01-2007 04:50 AM

Quote:

Originally Posted by Cyricx (Post 1392282)
Dot2slash -
Try using the new 2.3.1 xml :)

AWESOME !!

works great ... phrases read and shown in the admincp .. forums can be saved (but all email-settings where gone ... not so dramatic) ...

Donation (small one) on the way ;-) .... really good piece of work !

anyway why the options in a seperate tree instead of vboptions ?
makes no diffrence, im just courious

Cyricx 12-01-2007 01:11 PM

Quote:

Originally Posted by onehost (Post 1392736)
question: is this just a one way email??

I send email from my account to the forum, it imported just fine, but
when i replied, or even post a new thread, nothing was sent back??
any reason why...

and concerning the multiple email accounts, so if i have 50 categories,
well thats a lot more then what i would want to do as a user, save
all those emails...

Thank-You

You need to be subscribed to the forum :) Go to your user cp and under subscriptions there is a "Forum Subscription Manager".

Yes, if you have 50 forums that allow posting from email, you would need 50 different email accounts. Just like yahoo groups :)


Quote:

Originally Posted by dot2slash (Post 1392768)
AWESOME !!

works great ... phrases read and shown in the admincp .. forums can be saved (but all email-settings where gone ... not so dramatic) ...

Donation (small one) on the way ;-) .... really good piece of work !

anyway why the options in a seperate tree instead of vboptions ?
makes no diffrence, im just courious

Thank you for the donation!!!

You mean the forum settings help thinga machig? That's just a test script. People input their base settings there, then it scrolls through trying all the possible combinations and spits back out a page telling them what options to use in their forum manager to connect to the box. :)

Eliminates everyone having to manually try localhost and mydomain.com and the 6 different connection types etc :)

Does it for them :)

onehost 12-01-2007 02:05 PM

Quote:

Originally Posted by Cyricx (Post 1392918)
You need to be subscribed to the forum :) Go to your user cp and under subscriptions there is a "Forum Subscription Manager".

Yes, if you have 50 forums that allow posting from email, you would need 50 different email accounts. Just like yahoo groups :)


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

capsize 12-01-2007 05:56 PM

I really like this new feature. I had previously tried to tell my users what to do to get instant email notification for each forum ... and it was a pain. This new feature in 2.3.1 is concise and self-explanatory and the "Set All None" and "Set All Instant" are exactly what I needed. Thanks!

capsize 12-01-2007 07:38 PM

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.

dot2slash 12-02-2007 02:44 AM

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.

Cyricx 12-02-2007 04:12 PM

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 :)

Cyricx 12-02-2007 04:14 PM

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 :)

capsize 12-03-2007 10:21 PM

Quote:

Originally Posted by Cyricx (Post 1393577)
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.

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.

capsize 12-03-2007 10:28 PM

Quote:

Originally Posted by Cyricx (Post 1393577)
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.

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.

capsize 12-04-2007 06:56 AM

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


Cyricx 12-04-2007 11:47 AM

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

AyeCapn 12-06-2007 04:04 PM

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=

lbernstein 12-10-2007 04:28 AM

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.

lbernstein 12-10-2007 04:53 AM

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?

lbernstein 12-10-2007 08:51 PM

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!

mykkal 12-10-2007 09:42 PM

don't most out of office replies have that in the subject? It can only be so perfect. Maybe put in an out of office setting for users to check/use when they are out of office. You can only do so much without human intervention.

dot2slash 12-10-2007 11:46 PM

Quote:

Originally Posted by Cyricx (Post 1393579)
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?

all cronjobs running usally as planned (i have some little traffic to ensure this)

the emailed posts with attachments are show the postbit_attachment or postbit_thumb templates
but the graphics are not shown ...

this remains so ... even after days .. nothing changed ...

if i start maintance (admincp) and let the board create the thumbs its apears.

storage is DB driven ... (but i can switch this if needed)

Piggo 12-12-2007 11:25 AM

Probably to early to answer; but what's the likelihood that this email integration will work with 3.7 right out of the box?

(still running this as a trial in 3.6.7....but want to release it forum-wide when upgrading to 3.7....)

rodneytamblyn 12-14-2007 01:21 AM

Is there any way to make Email Integration check an IMAP mail box but not delete messages it finds? I'd prefer to keep a record of all messages received and at present it is deleting the messages whenever the cron job runs.

Enhancement suggestion - it might be nice to have a configuration option to transfer messages from INBOX to another box after they have been processed (perhaps even two boxes, one for accepted another for rejected)

Thanks

~ Rodney

vrwired 12-15-2007 07:20 PM

Quote:

Originally Posted by lbernstein (Post 1398791)
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!

I am a coder, but haven't found a way to get this to work yet... cyricx? any insight on how to fix this yet?

vrwired 12-15-2007 07:22 PM

Quote:

Originally Posted by lbernstein (Post 1398363)
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?

Cyricx? This is the same problem that i'm having with auto subscriptions... haven't found a way to fix it yet.. any insight from you?

vrwired 12-15-2007 09:29 PM

Quote:

Originally Posted by vrwired (Post 1401724)
Cyricx? This is the same problem that i'm having with auto subscriptions... haven't found a way to fix it yet.. any insight from you?

Regarding the problem with "Auto Subscriptions", if you know enough about working 'under the hood', here's a hack to get this working:

The problem when trying to load auto subscriptions is:
Invalid SQL:
SELECT title FROM forum WHERE forumid =;

Here's what I did to 'fix' it so it would at least function...

1) Open up file admin_ei.php in the admincp folder.
Around line 52, it reads: $getforuminfo = $db->query_read("SELECT title FROM " . TABLE_PREFIX . "forum WHERE forumid = $forumupdateid");
-- just hardcode (i.e. replace) $forumupdateid with the actual # of the forum you want to subscribe all users to (I had 7 different forums, so had to do one at a time:( )

2) You also need to update the table 'usergroup' in your forum's dB... if you have phpmyadmin you can use this query to pull up the info you need to update:

SELECT usergroupid, title, ei_forumid
FROM usergroup
WHERE ei_auto =1
ORDER BY `usergroupid`

Find the row that has 'registered users' in the title column Now change the value for 'ei_forumid' in that row to be the forum # that you are subscribing all users to (same # as in the first step)....

Now you should be able to subscribe all users by going to admincp and clicking "Auto Subscription" again, but will still need to repeat steps 1 and 2 until you get all forums subscribed...:cool:

Mad Dog 12-16-2007 02:44 AM

Quote:

Originally Posted by Cyricx (Post 1293842)
No, you won't need a new host :)

Most hosts will not have any issues at all with enabling IMAP :) Like I said, I have yet to encounter a host that didn't have it enabled. :)

All they have to do is uncomment one line and recompile the php. Pretty quick and painless :)

Talked to GoDaddy today about getting IMAP enabled. Not gonna happen unless I start using a virtual dedicated server solution. Then supposedly, I would be able to configure the server myself so that IMAP is enabled. I really don't understand GoDaddy's rationale behind this policy.

capsize 12-17-2007 05:22 PM

Quote:

Originally Posted by Mad Dog (Post 1401908)
Talked to GoDaddy today about getting IMAP enabled. Not gonna happen unless I start using a virtual dedicated server solution. Then supposedly, I would be able to configure the server myself so that IMAP is enabled. I really don't understand GoDaddy's rationale behind this policy.

I switched from GoDaddy to another hosting provider because of this. GoDaddy's problems are worse than just their lack of imap support in php. You cannot connect to their email servers from your shared hosting server at all. They block all network connections to their email servers from their own network. And they refuse to fix this. They claim it's "a limitation of the shared hosting environment" and push you to their VPS products. I had tried to code my own POP3 client to use this mod since their php server does not have IMAP support and then noticed that connections would simply fail. So there's no way for a GoDaddy shared hosting website to do any sort of automatic email processing, php or otherwise. PM me if you want a hosting recommendation. You're gonna have to leave GoDaddy shared hosting or at least use an email server other than GoDaddy's to use this mod.

Mad Dog 12-18-2007 04:55 AM

Well, mod is installed and working beautifully with the exception of being able to post replies or new threads from email. Without a doubt, the ability to receive instant email notification (as well as daily/weekly digest mode) of ALL new posts and threads should be a part of the core vBulletin application.

Given that I convinced a client to transition to vBulletin so that we could use this mod and have Yahoo group forum functionality with an improved and more flexible interface, I am now in search of changing web hosts. If anyone has any recommendations, by all means PM and let me know.

RWerksman 12-20-2007 02:03 AM

Despite having installed quite a few mods to my forum, I seem to be running into a bit of an issue wit this.

I can post via email to my forum quite well, and I can subscribe to regular threads fine, but when I subscribe to the entire forum, I never get any emails. I have:

- Enabled the prodcut via vBulletin Options
- Setup the email accounts
- Plopped my forumids in the "If joining this usergroup opens access to any Email Integrated Forums, please enter the forumids here separated by a comma." box in my usergroup.
- Entered the settings in my "Email Reply Integration Settings" section of the forum
- Subscribed to the forum via instant notifications

What am I missing here? Why isn't this working correctly for me?

RWerksman 12-26-2007 01:59 AM

Quote:

Originally Posted by RWerksman (Post 1405127)
Despite having installed quite a few mods to my forum, I seem to be running into a bit of an issue with this.

Ok - I'm absolutely at my wits end with this -- it just wont generate subscription emails!! I've tried damn near everything to get this to roll, but it appears as not be triggering the plugin to send out the email.

Someone help! :(


(and Merry Christmas!)

Cyricx 12-26-2007 11:26 AM

I'll be catching up on this, this week and I have a few ideas on how to redo the format of the emails to clean things up a bit.

*glancing at some of the above posts*

RWerksman, if you would like to PM me a temporary admin login with access to the forum manager, plugin manager and scheduled tasks and let me know which forums you have enabled I'll jump in and see if I can figure out what may be going on.

RWerksman 12-26-2007 01:07 PM

Quote:

Originally Posted by Cyricx (Post 1409355)
RWerksman, if you would like to PM me a temporary admin login with access to the forum manager, plugin manager and scheduled tasks and let me know which forums you have enabled I'll jump in and see if I can figure out what may be going on.

Done! Thank you sir! :D

amphicar770 12-28-2007 03:02 PM

Thanks Cyricx,

This is the one mod that many vb sites have been dying for. Like many others, I can now get my group off of Yahoo. :D

Just sent a contribution your way. Hope everyone else does the same and that it encourages you to continue updating and supporting this killer mod!!!

Mike I.

amphicar770 12-28-2007 08:01 PM

How do I update existing users, as opposed to new users, to be subscribed to a specific forum.

popmyzit 12-28-2007 09:50 PM

Hey guys,
everything works :) except... I don't get emails sent out for replies to the original thread...

amphicar770 12-29-2007 12:20 AM

Quote:

Originally Posted by justchecking (Post 1383827)
.. I get an error
- unable to open the stream. So basically cron script has trouble logging into the mail system and downloading the emails. I tried all 6 settings but no luck.

-Warning: imap_open() [function.imap-open]: Couldn't open stream {mail.mysite.com:993/pop3/ssl}INBOX in /includes/cron/emailintegration.php on line 111

I ran into same issue. Here is what I found that might help others out.

For username login I entered the username of the email account I created, which is:
amphicarlovers
Nothing was working until I went to my sites admincp for email where it told me the sytem userid is:
amphicarlovers+amphicar770.com
(yes, literally with the plus sign).
Once I changed that I had working IMAP, Pop, etc.

I also have to give a plug to my host asmallorange. IMAP was not installed on PHP. I submitted a support ticket and in 5 minutes had a reply to give them 15 minutes and they would recompile php with this setting enabled. Like evry other thing I have ever asked them, boom it is done!

Love this mod. Just need to know how, as admin, I can subscribe existing users.

RWerksman 12-29-2007 12:32 AM

Quote:

Originally Posted by popmyzit (Post 1411065)
Hey guys,
everything works :) except... I don't get emails sent out for replies to the original thread...

Same deal with me :(

popmyzit 12-29-2007 05:31 AM

Ok, it sends emails only if they subscribe in usercp...cant automatically add users.

Also works on 3.7 except get errors on registration:

Fatal error: Call to a member function query_read() on a non-object in /forum/includes/class_dm_user.php(2652) : eval()'d code on line 30


All times are GMT. The time now is 05:17 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02899 seconds
  • Memory Usage 1,891KB
  • 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
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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