Email posts into forum

*phew*

Here it is people, the hack I use at vBulletin.org that allows you to send replies to the thread through email.
I've rewritten most of it in the last couple of days, killing bugs and making the code more readable with comments.

Installation is pretty easy, download the attaced ZIP file and read readme.txt.

This hack is provided as is and with no support whatsoever!
DO NOT email, private message or contact me through any other means about this hack. You will be ingored and receive bad jake karma! (provided graciously by jake Inc.)
Bug reports are welcome.

I hope none of you will need any support, this is not a space ship and you don't need to be a rocket scientist to install it.

[high]* FireFly waits for someone to request a screen shot... :dead:
[/high]

Enjoy!

[tacoX]

Looks like another rip of yaxay! *Looks Up* thanks chen...

[Linux]

Child process of virtual_address_pipe transport returned 69 (could mean service or program unavailable)

me too I had the same problem , any tips or solution ?

[PhotoGenie]

Can anyone tell me what to do to get the emails sent from the relpy's to show the content of the post. Like the emails I get here that say...

Here are the contents of the post:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Well, I'm glad that no one wants to help me out. */sarcasm*
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I didn't see anything in the code changes to add this. Thanks

[ChurchMedia]

Has anyone actually got this to work? I don't see any reference in the instructions to getpost.php other than "don't put it in your public directory". So, I'm not sure how to apply it.

Also, it creates an error when replying after I make the mods:

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.field8
FROM subscribethread,user,userfield
WHERE subscribethread.threadid='1'
AND subscribethread.userid=user.userid
AND userfield.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1041124392' mysql error: Unknown table 'usergroup' in where clause

mysql error number: 1109

The usergroup table shows up and seems to be okay. Any ideas?

Thanks!

[SemperFidelis]

Hmmm
Im getting the exact same error as ChurchMedia
(running vb 2.2.9)

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT user.*,userfield.field5
FROM subscribethread,user,userfield
WHERE subscribethread.threadid='2'
AND subscribethread.userid=user.userid
AND userfield.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1041223298' mysql error: Unknown table 'usergroup' in where clause

mysql error number: 1109

Date: Monday 30th of December 2002 06:03:50 PM

Anyone got any ideas on this one ?

[Xenon]

your query is incorrect
instead of this:

SELECT user.*,userfield.field5
FROM subscribethread,user,userfield
WHERE subscribethread.threadid

it should be this:

SELECT user.*,userfield.field5
FROM subscribethread,user,userfield,usergroup
WHERE subscribethread.threadid

[Mystis]

Thanks for releasing it Firefly, I learned quite a bit studying the code!

[SemperFidelis]

Cheers Xenon
That has fixed it all up

[NuclioN]

.procmailrc solution:
_____________________

:0
* (^To:|^CC:|^Cc .*emailadres@domain.ltd
|/usr/bin/php4 /path/to/getpost.php
_____________________
cyberty.nl

[NuclioN]

if you get problems with that mysql_connect is an invalid option, edit your php.ini file (OF YOUR CGI PHP, debian /etc/php/cgi/php.ini) and add extenstion=mysql.so
_______