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:

[mustang_lex]

Originally Posted by DogGunn

I just get a blank screen.. Help?

Ya I did too??????????

[mustang_lex]

OK, now that I admit I'm new at this hacking thing, when you say add these templates you actually have to add them in Admin CP. Since I did that. Its all working great. Now I need to cusomize it. Here goes nothing :speechless:

[mustang_lex]

My form works great. Once question. My form is asking questions that the member may have entered in their profile. Such as hobbies for example. How can I have the text field that they will fill in on the form (such as hobbies) default to having the same text in their profile?

[Erwin]

Originally Posted by mustang_lex

My form works great. Once question. My form is asking questions that the member may have entered in their profile. Such as hobbies for example. How can I have the text field that they will fill in on the form (such as hobbies) default to having the same text in their profile?

In the variable for the answer, put down $bbuserinfo[fieldx] where fieldx is the custom profile field number.

[mustang_lex]

Awesome!!! i added

value="$bbuserinfo[field7]"

To my input fields (changing the fieldID) and its cool. When the person opens the app. if the questions were allready filled out in their profile, it will be automatically added in each text field. This ROCKS!!!!! Thanks

[mustang_lex]

I would like to incorporate an upload field. Is this possible. When the person submits, the photo is uploaded to a folder on the server, and the file title is displayed in the formanswer (mine inwhich is submitted to a group)

[paul41598]

Is it possible to put a form (this form) somehow in a new thread, and then users can view that thread, choose all the selections, submit it, and then write it out to a new thread? Almost like a question form in a thread, and then the results goto a result thread.

[Spinball]

Erwin,
do you think it would be possible to add the code to subscribe people to new threads if they have automatic subscriptions switched on?
For our use - the creation of classified adverts - it's particularly needed.
Thanks

[paul41598]

I have figured out a way to do dropdowns if anyone is interested

[Cyricx]

Hmmm, found a bug, when a user fills out a form and uses a ' like

Suzuhara's

It gives an invalid sql error

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO vb3_thread(title, lastpost,
forumid, open, replycount,
postusername, postuserid, lastposter,
dateline, iconid, visible, attach)
VALUES
('Aged bowman Requests
Suzuhara's Care Package', 1118670743, 176,
1, 0, 'Aged bowman', 593,
'Aged bowman', 1118670743, 0,
1,
0)

mysql error: You have an error in your SQL syntax near 's Care
Package', 1118670743, 176,
1, 0,' at line 5

mysql error number: 1064

[Spinball]

Cyricx,
do you see

PHP Code:

$formtitle 


in the following bit of the hack where it inserts the thread?

PHP Code:

                    $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)
"); 


well if you put

PHP Code:

" . addslashes($formtitle) . " 


instead, this will fix it.
Try it and see if it still breaks when you use a quote in the title.

[mustang_lex]

Although this bug hasn't been picked up by me yet. I like to fix it. and I have no clue what you ment at the last post spinball, Please send details. Thanks

[Spinball]

Originally Posted by mustang_lex

Although this bug hasn't been picked up by me yet. I like to fix it. and I have no clue what you ment at the last post spinball, Please send details. Thanks

Sorry but I can't teach you PHP. I suggest you buy a PHP and MySQL book and learn it like I did. It will serve you well to best maintain your forum.

[jeepinaround]

Ok I had this working at one point in time. Some of the modifications I have done is...
Having the first question answered as the title to the thread
The option to redirect to the form when posting a new thread

For some reason now when you fill out the form and hit submit it creates a new thread with the answer to the first question as the title but nothing in the actual post it is blank other than a signature. I took all day from work and read every page of this thread and did not find a similiar problem. Does anybody have any ideas? The only thing I can think of that I did was upgrade to 3.0.7 since I originally had this working.

[sdsvtdriver]

I'd like to change the subject to be, say the answer to normal question1. how easy is this to change?