FORM to THREAD/ FORUM/ POLL/ PM/ EMAIL - CUSTOMIZABLE FORMS - Mod Apps, Orders, News.

FORM to THREAD/ FORUM/ POLL/ PM/ EMAIL - Totally CUSTOMIZABLE FORMS
Version 1.6 for vBulletin 3.x.x by Dr Erwin Loh

Features:

Ever wanted an online form that a user can fill out, which when submitted gets:

1. Posted into a new thread in a forum of your choice
2. Create a new poll in the new thread with options of your choice
3. Posted as a reply in an existing thread of your choice
4. PMed to you or someone else
5. Emailed to an email address you specify
6. Choose to redirect to the post, thread or forum, or a custom thank you message
7. Choose to redirect to editpost to upload attachments

Or any combination or all of the above?

Well, this is the hack for you!

You can use this for:

1) Moderator Applications
2) Quiz Submit Form which gets PMed to a moderator
3) Contact Form that goes to PM, email or thread
4) Guests to apply to be members
5) Report a Moderator form that goes as a PM to you
6) Guests can PM you for whatever reason
7) Order form to buy things
8) Donation form
9) News or Articles submissions that can go straight to a thread


Or anything you like - this hack is totally customizable via the PHP file.
Basically, this hack involves modifying 1 PHP file form.php (you add questions, options etc. in the PHP file itself), uploading it, and then adding 2 templates.

The beauty of this hack is that once you have added the 2 templates, to make a new form, all you need to do is copy the form.php and rename it to form2.php, edit the variables in the PHP file, and you have a totally new form!!! You do not need to touch the templates again.

Format of the form:

1. One main input question
2. 2 Radio buttons Choice questions
3. 3 Normal text input questions
4. 1 Long answer question

This is customizable via the PHP file.

Also:
- You can set the usergroups you want access to this form.
- Depending on your forum permissions, if the new thread is in a public forum, members can reply to it. This hack allows a form to submit the new thread or post wherever you want it to go.
- Force the user to answer all questions.


INSTALLATION


Easy - takes only a few minutes:

1. Add the 2 templates.

2. Edit form.php - the instructions are all inside the PHP file itself, in the top half. Follow the instructions carefully!

3. Upload form.php

Just link to form1.php eg. http://www.yourforum.com/forums/form.php

Done!

Use this hack to make as many forms as you like!

Enjoy!


Updates:

Version 1.1 - Option to force user to answer all questions.
Version 1.2 - Thread count and lastposter information now updated if form is sent to existing thread.
Version 1.3 - ADDED CREATE POLL OPTION!
Version 1.4 - Fixed bug with Form-to-thread code
Version 1.5 - Major update:
- fixed bug where thread count not updated when form to forum
- fixed default posting to allow smilies and sigs when reply to thread
- added templates to cache (saves 2 queries)
- added option to change thank you message
- added options to redirect to post, thread or forum when submit
Version 1.6 - Choose to redirect to editpost to upload attachments

Screenshot is an example of a form - the form title and questions are customizable:

[Erwin]

Originally Posted by Jolten

Wonderful hack!

After some modifying I'm getting a query for an uncached template. All I pretty much did was delete some radio buttons and the check for them and changed the two template names to two new custom templates. I'm having a real hard time finding what other template the script may be using other than STANDARD_ERROR.

Either way.. freakin' great hack Erwin. Thanks.

This file only uses the standard_error template.

[Jolten]

that's what I thought. hmmm.. Thanks Erwin.

[Jolten]

Okay help please... I've changed the three template names. The form works wonderfully.. but there's a query for an uncashed template.

PHP Code:

if ($action=="submit") {

if ($answerall == "1") {
    if ($answer1 == '' OR $answer2 == '' OR $longanswer1 == '')
    {
    $errormessage = "You need to answer every question, $bbuserinfo[username]!";
    eval('print_output("' . fetch_template('flag_error') . '");');
    exit();
    }
}

    eval('$formsend = "' . fetch_template('flag_answers') . '";');

    if ($formforum == "1") {

                    $DB_site->query("
                                INSERT INTO " . TABLE_PREFIX . "thread(title, lastpost, forumid, open, replycount,
                                postusername, postuserid, lastposter, dateline, iconid, visible, attach)
                                VALUES
                                        ('".addslashes(htmlspecialchars($bbuserinfo[username]))." $formtitle', " . TIMENOW . ", $formforumid,
                                         1, 0, '" . addslashes($bbuserinfo['username']) . "', $bbuserinfo[userid],
                                         '" . addslashes($bbuserinfo['username']) . "', " . TIMENOW . ", 0, 1,
                                         0)
                        ");
                $thread['threadid'] = $DB_site->insert_id();
                $DB_site->query("
                        INSERT INTO " . TABLE_PREFIX . "post
                                (threadid, title, username, userid, dateline, pagetext, allowsmilie,
                                 showsignature, iconid, visible)
                        VALUES
                                ($thread[threadid], '".addslashes(htmlspecialchars($bbuserinfo[username]))." $formtitle',
                                 '" . addslashes($bbuserinfo['username']) . "', $bbuserinfo[userid], " . TIMENOW . ",
                                 '" . addslashes($formsend) . "', 1, 1,
                                 0, 1)
                ");
                $post['postid'] = $DB_site->insert_id();
                $DB_site->query("
                                UPDATE " . TABLE_PREFIX . "thread
                                SET firstpostid = $post[postid]
                                WHERE threadid = $thread[threadid]
                        ");
                $DB_site->query("
                                UPDATE " . TABLE_PREFIX . "forum
                                SET replycount = replycount +  1,
                                " . iif($type == 'thread', 'threadcount = threadcount + 1,') . "
                                lastpost = " . TIMENOW . ",
                                lastposter = '" . addslashes($bbuserinfo['username']) . "',
                                lastthread = '".addslashes(htmlspecialchars($bbuserinfo[username]))." $formtitle',
                                lastthreadid = $thread[threadid]
                                WHERE forumid = $formforumid
                        ");

    }


    if ($formemail == "1") {
    vbmail($formemailaddress, $formtitle, $formsend);
    }

    $errormessage = "The image has been flagged.";
    eval('print_output("' . fetch_template('flag_error') . '");');
   exit();
}

eval('print_output("' . fetch_template('flag') . '");');
?> 


[mtha]

Originally Posted by Erwin

2. Posted as a reply in an existing thread of your choice

When reply to an existing thread, should thread counter and last poster be updated?


Look for

PHP Code:

    if ($formreply == "1") {
      $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$formreplythreadid','".addslashes(htmlspecialchars($bbuserinfo[username]))." $formtitle','".addslashes($bbuserinfo[username])."','$bbuserinfo[userid]','".time()."','" . addslashes($formsend) . "','$allowsmilie','$signature','$ipaddress','$iconid','1')"); 


Add after

PHP Code:

        $DB_site->query("UPDATE thread SET replycount = replycount + 1, lastpost = " . TIMENOW . ", lastposter = '".addslashes($bbuserinfo[username])."' WHERE threadid = $formreplythreadid"); 


[Erwin]

Thanks mtha - forgot to add that.

Update Version 1.2

Thread count and lastposter information now updated if form is sent to existing thread.

Zip file is updated.

To upgrade, just apply the changes in the post above.

[Merjawy]

Great hack Erwin.. will install soon I get my issues out of the way and upgrade

[mtha]

Originally Posted by Erwin

Thanks mtha - forgot to add that.

Update Version 1.2

Thread count and lastposter information now updated if form is sent to existing thread.

Zip file is updated.

To upgrade, just apply the changes in the post above.

this one is not important, but if you want, you can fix.

when sending a PM to user, and that user has option to display a pop-up for new PM, the pop-up isnt displayed.

[T2DMan]

Cool - this is going to be fun

Objective - each thread is a restaurant, users submit review, and review gets posted into that thread, with the data stored. Each thread shows survey to date, new survey form, and submitted reviews.

I'll report back when its all working.

[Erwin]

Originally Posted by mtha

this one is not important, but if you want, you can fix.

when sending a PM to user, and that user has option to display a pop-up for new PM, the pop-up isnt displayed.

Really? It does for me.

[WAR]

Originally Posted by Erwin

Really? It does for me.

It doesn't pop the window up for me either but i wasn't worried about it.

Thanks again for this hack erwin, it has been invaluable for me as I've been building the site I am working on.