thanks for the answers!

I get an error when trying to install the product:

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Quote template', 'cache_templates', '$globaltemplates = array_merge($globaltemplates, array(\'bbcode_quote\'));', 'emailreplyint');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054

These are the only fields in my plugin table:
pluginid
title
hookname
phpcode
product
devkey
active

Do I need to upgrade to the latest version of vb for this to work?

I have just installed and am in the process of testing this baby out. Very excited.

For the most part the reason I love this new hack is that it allows for the posting of threads and replies via email. My users will really appreciate it.

I previously had RedTyger's code installed "Instant new thread notification" -- and I notice you used that code in the process of developing this new one. Now when I go to Forum Tools -> Subscription Type, I see two identical entries under Notification type called "Instant Notification by email."

No problem, I go into AdminCP and disable the previous hack by RedTyger, and now one of them is gone from the Subscription Type pulldown. But I realize that means users can no longer subscribe to instant notification of "new threads only." And I'd like to retain that option, if possible. So perhaps for a future version, this hack could offer two types of subscription:

-Instant notification by email of new threads only
-Instant notification by email of new threads and all replies

I request this simply because the way my forum is structured, the 2nd option might be too much for some folks and will ultimately flood their email inbox, scaring them away. The 1st option, of course, is enough to keep them in the loop of new topics and announcements, and may even entice them to login to the forum and be more active via the web.

Thanks for the consideration. I suppose I could go in and rename these things myself to get them to coexist peacefully... but figured I'd request it for the benefit of others.

Vocoder - You'll either need to upgrade, or edit the product xml file and change all of the <plugin active="1" executionorder="5"> to just <plugin active="1">

Vbulletin 3.6 added executionorders to the plugins which is something 3.5 didn't have.

Hypothetically, this modification should work on 3.5, but I'm only offering support for 3.6 boards due to the complexity of the modification.

You've got some kick ass ideas!! Thank you!!! :)

I had planned on a future version getting this to coexist with subscribed forums/threads. So if you subscribed to a thread that email integration was turned on in, you would be able to reply to the email you get for subscribed threads :), and it's definatley in my brain for a future version.

The new thread only thing is kick ass as well! And should not be hard for me to code at all! I'll add it to my list and it should make it into 2.0

I want to let 1.x ride a little bit to find out what other email programs are not behaving well before I start on 2.0 though :)

Keep the suggestions coming!!

yeah, I went and upgraded to the latest vB and it installed just fine.

When a new post is created, it sends out the email just fine, however when I reply to that email, it never shows up in the forum. I'm using Exchange for the email server, and have IMAP enabled, but still think there may be some problem with that setup....is there a good way to test?

I'm just wondering if when it sends the email, is it also using the imap server that is specified for the forum, or is it perhaps using localhost (vb is running on a linux server with mail)

Okay, so I set up a new mailbox on my server and confirmed that I could email to it, as well as check it. (BTW, a good free web tool to confirm this is Mail2Web.)

I know my email hoster supports POP3 and IMAP because I have set up regular email accounts and clients using both over the years.

But, with this hack, I chose POP3, and then just ran the cron job manually and got this error:

:(

I was afraid that might happen.

Sure enough, I looked in there and didn't see anything listed about "imap."

Just wondering, is enabling IMAP support necessary even if we've chosen POP3 in the Forum Manager prefs? I ask this because getting my webhoster to do anything, even as simple as enabling the line for imap support, is often an uphill battle.

I ran the cron and seem to be getting the

Call to undefined function imap_open() in /var/www/bb/includes/cron/emailintegration.php on line 70

error. I recall seeing posts about this here, I'll look to see what is causes this.

One more question. When emails are fetched from the mailbox to be posted, are they deleted from the mailbox, too? (Just asking because I don't want to see that mailbox be filled up eventually.)

See the FAQ in post #2.
https://vborg.vbsupport.ru/showpost....90&postcount=2

okay, I enabled the php imap extension...now i am getting different errors. it looks as though its trying to use the POP3 port instead of hte IMAP port, even though I have IMAP selected?

It should be using port 143, right, not 110? these are the errors i now get:

Warning: imap_open() [function.imap-open]: Couldn't open stream {mail.mymailserver.com:110/pop3/notls}INBOX in /includes/cron/emailintegration.php on line 70

Warning: imap_headers(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 73

Warning: imap_close(): supplied argument is not a valid imap resource in /includes/cron/emailintegration.php on line 807

EDIT: my settings are correct, I tested it with thunderbird IMAP just to doublecheck. and it works fine with thunderbird. I think it has to do with the port.

Yes on each loop of reading each message, either when it gets an error or when it completes the process of working with that email it marks it to be deleted. Then just before it closes that mailbox, it deletes all those emails :)



Please try the other options such as with official and self signed certificate as well.

There are 3 different pop3 and 3 different imap connections due to the varied kinds of ways people can setup their servers :)

To your previous question, the emails being processed to the forum are controlled through the cron job, if the cron cannot connect, it will not process those emails :)

however, it will still send out emails when someone posts from the forums. :)

Tried this last suggestion, not working. What I do notice is that is does not appear to be recognizing the connection type and instead keeps trying to connect via standard POP3 even if it is set to something else in the forum.

Update to last post. Yup, you are calling the wrong variable when setting up the $connectmailserver statement. It should be ei_connectiontype.

checking :)

Still doesn't fix the overall problem though.

Please try the new uploaded zip.

You were correct. The reason most were not experiencing it is that the field defaults to 0 and most people will not need to change their settings from pop3.

Already changed it here, but it still doesn't stop the failed stream error no matter what it's set to.

I'll have to see your settings to figure out what the modification is doing wrong :(

I can't guess at what your settings are unfortunately :(

Can you send me a login via pm?

Update: since the 1.5 fix, it correctly recognizes connection types. On my home site, I have 4 forums enabled, when I change the connection type for one of them I get the errors. I would suggest running a global query something like

update forum set ei_active = 0;

and then go back and edit one forum and play with it's connection type, my guess is you may have accidently turned on a second forum as active

in future versions I'll code in a die loop so if it gets that error it'll like send an email to the admin or something, *shrug* I'll figure something out :)

update to my issue (i selected IMAP, but it was using the settings for POP3)

the only way I could fix it was to actually go into the emailintegration php file and make it so POP3 settings used IMAP settings instead...then it worked fine. And I want to stress that my forum was set to use IMAP.

vocoder, please try the file from the new zip version 1.5

There was an error in the cron file that was not correctly viewing peoples connection types :(

Hmm, well, it looks like needing the imap extension is going to stop me from using this. I do run on a vps, but php was not compiled with the imap extension and php.net is telling me I have to have other software to support it before compiling php with it. I do have some users that have internet blocked at work that this could be useful for, but being unsure how many people would use it, I don't think I want to risk the downtime.

I don't think you need any additional software at all. If I recall right it's a simple edit to the php.ini file.

It certainly isn't software that costs you anything. I'm not the server guru though, so perhaps someone who is can chime in with how easy it is to grab imap :)

I stand corrected, you do need to download and compile one item. I put a link in the first post with a link to installing imap. Seems fairly painless though :)

I think I found the problem. In my case the password being used begins with a zero, but the zero is being dropped for some reason so it's passing an invalid password. If I hardcode the password in, it works.

Changed my password to one without a starting zero and it works, well at least I don't get the cron error anymore. Going to test it all now.

How many characters long is the password?

NM, can't be that.. hehe I've got the field set for 50 characters allowed...

Hmmm, let me test over here too.

Ok seems to be working to a degree, but whenever I reply via email I get back an error saying

Message too short: your message does not have the required minimum amount of characters.

Hold up Quik, I've got a new version I'm about to roll up with that will handle emails that are only coming in as text only format.

Waiting for cory to test it out :)

excellent! happy to test here if you'd like

Thank you so much for your patience quik!!! The zip is up!

The new version is up, just need to reupload the emailintegration.php file to upgrade.

The thing I really hate about the text only emails more so then the html is all the > and * line starts. I'm currently trying to find a way to get preg_replace to rip out the > and * characters if they are on a line by themselves..

Whew.. I'm quite the busy bee!

Heh, I hate HTML email myself, but I'll put up with it for this mod ;)

You are doing a fantastic job! This mod is one I really want to get working properly as we have a lot of folks who prefer using a mail list rather than the forums. This gives us the best of both worlds.

Grabbing the new file for testing now

if you are looking for any input, my preference would be to have it be all text only emails...

HTML just seems to really add a lot of confusion, and I also think that users that are coming from older email discussion groups are used to text only. It really seems to simplify things.

anyway my $.02

great job!

I should really put up a list of my future planned features :)

One of them will be a usercp controlled switch that users can select to get these via html or plaintext :)

Kinda waiting to work on too many features til I know the preg_replaces are handling incoming emails right. Those are the key functions, everything else is just toppings :)

The problem with text only all the time is

A) smilies get lost, the plaintext parser rips them out entirely, not even the replace code remains.

B) links to your forums become inactive, thereby losing the ability to encourage your users to come to your forum, rather then just sit back and read emails

The second one is the big kicker for me.

But hey.. I'm all about user optional :)

Woot, that looks like it got it!

One suggest if there is any way to do it. Don't have it send replies back to the person who sent the reply. No biggie though.

Again let me say thanks for a great mod with a lot of potential!

I see your point, In my experience with text only emails - the email client will still usually create links as long as you have the www.

at least on thunderbird it does.

all the links that vbulletin sends out (thread notifications etc etc) are all clickable links for me, as text only..

Ah right on. Maybe it won't be as bad as I fear.

It shouldn't be hard at all to code. It will make it into one of the early versions for sure :) Just gotta get through these various email programs first :)

And those damn lines with just > on them that are driving me insane LOL!

Yeah, I've debated back and forth on that one. The mailing lists send it to yourself. Which can be nice if you like start a thread and then go.. O crap, I forgot about this, you could grab your email about the thread posting and reply to that and yoru good to go.

Without getting emails back to yourself (like mailing lists do), you'd either A) have to wait for someone to reply or B) have to jump over to the forums :)

It will likely end up becoming another end user option though with the default being receive emails about your own posts.

Besides it also makes sure you know it actually posted :)

What do others think? :)

I like the idea of that being an end user option, for the reply to who replied.

Sadly, my ISP won't enable the imap_open() requirement, so I'm going to have to sit out of this one for a bit. I see this is a pretty common issue though; here's a page for folks who need to deal with it.

http://drupal.org/node/121634

I guess when I get some time I'll attempt to custom compile PHP... or find a kind soul willing to help. :)

Well back from holiday and this just had to be installed before I hit the shees last night :)

Looking good and working well so far. Suggestions from me include those already on the to do list, but I'd like to add:

- Option to remove the signature when exporting the email.
- Option to remove some of the links in the email footer - for example we dp not use the Calendar at all on site and have it turned off.

Anyway the site staff should hopefully start testing it later on today. More thoughts from me later when I start to try getting clever with the system :)