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:

[PKRWUD]

Originally Posted by Erwin

Just add a \ in FRONT of any apostrophes you want to use IN the quotation marks.

I'm sorry, I wasn't specific enough. When ever someone fills out the form on my site, if they include an apostrophe in the box that becomes $formtitle (ie: I'm having car trouble), when they try to complete the form, they get the following error message:

Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO thread(title, lastpost, forumid, open, replycount,
postusername, postuserid, lastposter, dateline, iconid, visible, attach)
VALUES
('PKRWUD 'test'', 1093876723, 53,
1, 0, 'PKRWUD', 94,
'PKRWUD', 1093876723, 0, 1,
0)

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 'test'', 1093876723, 53,


mysql error number: 1064

[Erwin]

Replace:

'$formtitle'

in the query with:

'" . addslashes($formtitle) . "'

[PKRWUD]

Originally Posted by Erwin

Replace:

'$formtitle'

in the query with:

'" . addslashes($formtitle) . "'

I'm not terribly bright when it comes to this stuff, and didn't realize that I had to make that change in 3 queries in order for it to work, but I figured it out in a couple minutes. Thanks for taking the time to help! You ROCK!

Thanks again!

Take care,
~Chris

[alqadir]

Newbie question: why do we have three files here? Can't everything be put in the form.php file?

[WAR]

The second file contains example templates thatyou will need to create in addition to the generic form.php file

[dndog]

Originally Posted by Erwin

Replace:

<A HREF="$answer1">$answer2</a>

With:

The [url ] bbtag:

[url="$answer1" ] $answer2 [/url ]

Remove the space in the url tags, but keep the space around $answer2.

I tried doing that, but the url came out like this:

Yahoo

[kall]

Beautiful.

One minor typo in installation.txt tho..

3. Upload form.php

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

[y2krazy]

Is there a way to make a form that is created to be required by any new registration before they can do anything else? Such as a form that posts an introduction thread in a specified forum when someone registers, and it will be a requirement before said new member can do anything on the entire forum(almost like a "second" registration page). Maybe a re-direct once the registration goes through or something to the form before anything else can take place. Let me know if this can be done, or is even possible. Thanks!

[Abe1]

Thanks for the hack. I made 14 forms for my site. All leading to new threads.

I got 2 problems now. One, the posts don't count. Two, the posts don't get searched.

I fixed number one by my self.

find:

PHP Code:

$forum[forumid] = $formforumid; 


add before:

PHP Code:

                $DB_site->query("
                                UPDATE " . TABLE_PREFIX . "user
                                SET posts = posts + 1
                                WHERE userid = $bbuserinfo[userid]
                        "); 


find:

PHP Code:

$forum[forumid] = $formreplyforumid; 


add before:

PHP Code:

                $DB_site->query("
                                UPDATE " . TABLE_PREFIX . "user
                                SET posts = posts + 1
                                WHERE userid = $bbuserinfo[userid]
                        "); 


For the search problem, I couldn't come up with anything yet. Maybe someone else can.

[dndog]

Does anybody know how to fix my url problem? It outputs a url like this:

http://&quot/;www.yahoo.com"

How can I get rid of the &quot?