The Arcive of Official vBulletin Modifications Site.

Email posts into forum · **Released**: 07-02-2002

*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!

NuclioN · #52 01-08-2003, 03:05 AM

Altough the mail pipe is working correct, members having problems with the reply errormail. This errormail is blanc.
Sometimes a mailed reply is succesfull, other times not. And wierd is that the admins are instantly got the "U have no permission etc" error-logout message when they check the reply on the forum after sending it trough mail. (??)

USODJA · #53 02-02-2003, 01:48 PM

Database error in vBulletin 2.2.9:

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

mysql error number: 1109

Kars10 · #54 02-02-2003, 01:49 PM

@ USODJA, look @ Post 46...

USODJA · #55 02-02-2003, 02:21 PM

Thanks, that worked, now for the pipeline...LOL

And put on glasses to see other posts....

mcyates · #56 02-05-2003, 02:25 PM

Sorry i'm stupid, BUT how do i change this, what file / database table

Quote:

Originally posted by Xenon
your query is incorrect
instead of this:

Code:

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

it should be this:

Code:

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

squawell · #57 02-05-2003, 02:26 PM

i have a problem....

when i get the mail....what should i do next ???

ex:how to reply??can someone give me some screenshot will be easy understand....because i confused....

thankz.....

USODJA · #58 02-06-2003, 06:08 PM

Quote:

Originally posted by mcyates
Sorry i'm stupid, BUT how do i change this, what file / database table

Functions.php ...

sabret00the · #59 02-23-2003, 12:16 PM

Code:

In functions.php, replace this:
---- start code ----------------------------------------------------------
  $useremails=$DB_site->query("SELECT user.*
                               FROM subscribethread,user
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
---- end code ------------------------------------------------------------
With this:
---- start code ----------------------------------------------------------
  $fieldid = 7; // ID of the email password field in the user's profile
  $useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid
                               FROM subscribethread,user,usergroup,userfield
                               WHERE subscribethread.threadid='$threadid'
                                 AND subscribethread.userid=user.userid
                                 AND userfield.userid=user.userid
---- end code ------------------------------------------------------------

my functions.php aint got that, it might have something do with another hack, i got something similar so i might try editing that, just wanna make sure i don't thuck anything else up

Big Daddy Chemo · #60 03-02-2003, 04:41 PM

Quote:

This message was created automatically by mail delivery software (Exim).

A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed:

pipe to |/home/bdcnut2/public_html/forum/getpost.php
generated by post@*MYDOMAIN*.com
Child process of virtual_address_pipe transport returned 69 (could mean service or program unavailable) from command:
/home/bdcnut2/public_html/forum/getpost.php

Can someone help me out here? I see there were others with the same error message so if you have worked through this with Exim please share the knowledge.

Now, I have a dedicated server and I added the pipe in my alias file (etc/valiases/mydomain.com). At the command line I ran newaliases. Still get the above error.

I then deleted the entry, newaliases at the command line, and added them through cPanel6. Still the same error.

Little help from the knowledgeable?

Chemo

amp2000 · #61 05-02-2003, 05:37 PM

I've been trying this all day & am getting really confused, I have vBulletin 2.3.0 & have tried to install it with that, but my replies never go into the Forum.
in the code_changes.txt it says

PHP Code:


			
In functions.php, replace this:

---- start code ----------------------------------------------------------

  $useremails=$DB_site->query("SELECT user.*

                               FROM subscribethread,user

                               WHERE subscribethread.threadid='$threadid'

                                 AND subscribethread.userid=user.userid

---- end code ------------------------------------------------------------

With this:

---- start code ----------------------------------------------------------

  $fieldid = 7; // ID of the email password field in the user's profile

  $useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid

                               FROM subscribethread,user,userfield

                               WHERE subscribethread.threadid='$threadid'

                                 AND subscribethread.userid=user.userid

                                 AND userfield.userid=user.userid

---- end code ------------------------------------------------------------

And change the $fieldid variable to the right field ID.

Now I dont have that in my functions.php, I have this

PHP Code:


			
$useremails=$DB_site->query("SELECT user.*, style.templatesetid

                               FROM subscribethread,user,usergroup

                               LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)

                               WHERE subscribethread.threadid='$threadid'

                                 AND subscribethread.userid=user.userid

                                 AND usergroup.usergroupid=user.usergroupid

                                 AND user.userid<>'$userid'

                                 AND user.usergroupid<>'3'

                                 AND usergroup.canview = 1

                                 AND user.lastactivity>'$lastposttime[dateline]'");

so I replaced it with this

PHP Code:


			
$fieldid = 5; // ID of the email password field in the user's profile

$useremails=$DB_site->query("SELECT user.*,userfield.field$fieldid, style.templatesetid

                               FROM subscribethread,user,usergroup,userfield

                               LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)

                               WHERE subscribethread.threadid='$threadid'

                                 AND subscribethread.userid=user.userid

                                 AND userfield.userid=user.userid

                                AND usergroup.usergroupid=user.usergroupid

                                 AND user.userid<>'$userid'

                                 AND user.usergroupid<>'3'

                                 AND usergroup.canview = 1

                                 AND user.lastactivity>'$lastposttime[dateline]'");

I think that is right. I have also figured out the pipe with the e-mail by putting

PHP Code:


			
post: | /usr/bin/php /tmp/getpost.php

in my /etc/aliases file & restarted postfix & ran newaliases
Now here is where I get really confused, I receive the email telling me there was a reply to my post & I reply to it by replying to the e-mail but the post never makes it to the forum. If I dont have getpost.php world writable I get an error in my delivery failure report saying permission denied on getpost.php.
If I do have getpost.php world writable my reply is appended to the end of getpost.php.

Any ideas what's going on here people???

Thanks in advance for any replies.

amp2000

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06901 seconds Memory Usage 2,340KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (4)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!