Add-On Releases - Advanced Application Forms

THIS ADD-ON IS NO LONGER AVAILABLE AND IS NOT SUPPORTED

* General Information *
------------------------------
This is an add-on that is designed for vBulletin 4.1.1 or later. It may not work on earlier versions of vBulletin.


Nominated twice for MOTM (October 2011, January 2012)


Features

• Unlimited Application Types*
• Unlimited Application Positions*
• Unlimited Questions*
• Different Application Positions for each Application Type
• Different Questions for each Application Position.
• Allow others to add/edit Application Types by permissions.
• Allow others to edit Positions/Questions by permissions.
• Edit Application Types, Positions and Questions in either ACP or from board.
• Show Multiple Application Types in Community Menu or direct link to them.
• Control Application Type access by Usergroup, Postcount
• Control Application Position access by Usergroup, Postcount
• Notification of an application via Forum Thread and/or Email and/or Private Message
• Specify Different Forums for Reports by Application Position.
• Define a default question set that can be included on all applications.
• Much, much more!

* Limited only if you are limited in database size and/or free disk space.


* INSTALLATION *
-------------------
1) Upload the contents of the 'upload' folder to your forum's root.
(If your forum's location is http://www.example.com/forums/, the root is /forums/)

2) Depending on your server configuration, you will need to change the permissions of the advappfiles folder to either 775 or 777

3) Import the product XML file (product-advapp.xml) into the Product Manager in AdminCP.

4) Take some time to set the options, application types and application postions in the new Application Forms area of AdminCP.
(It's really not that hard!)

5) Make sure this modification is marked as 'Installed' on vBulletin.org!
(If you want to get notices from me about updates for this modification.)

* UPGRADE INSTRUCTIONS *
-----------------------------
1) Upload the contents of the 'upload' folder to your forum's root.
(If your forum's location is http://www.example.com/forums/, the root is /forums/)

2) Import the product XML file (product-advapp.xml) into the Product Manager in AdminCP and be sure "Allow Overwrite" is set to 'Yes'.

3) vB 4.2.x ONLY - Go to ACP->Settings->Options->Application Form Settings and set 'vB 4.2 Community Menu Update' to 'Yes'.

UPGRADING TO VERSION 1.3.8 or HiGHER
Depending on your server configuration, you will need to change the permissions of the advappfiles folder to either 775 or 777

If you have edited the advapp_application template, you need to revert the template before upgrading to 1.3.8 or higher.
Once the upgrade is complete, you can re-apply your changes to that template.


* History (Changelog) *
-------------------------
1.4.7 (September 7, 2015)
- Fix Certain characters not being stored/displayed properly.

1.4.6 (January 2, 2014)
- Fix Certain non-english characters not being stored/displayed properly.

1.4.5 (October 11, 2013) (not released vB.org)
- Fix No thread status showing in new threads when Thread Status Pro version 1.0.3 is installed.

1.4.4 (August 5, 2013)
- Fix Change single MySQL call to vB database call for systems that don't play well with direct MySQL calls.

1.4.3 (July 15, 2013)
- Fix Extra tabs in first response line in email notificactions.

1.4.2 (June 18, 2013)
- Fix Applications still able to be submitted after member logs out when unusual usergroup settings are used.

1.4.1 (June 8, 2013)
- Fix regex error missing from query.

1.4.0 (June 4, 2013) (not released on vB.org)
- Fix community menu not updating properly with vB 4.2.1

1.3.9 (May 2, 2013)
- Fix thread starter not showing when new thread is created and using actual userid to post new thread.

1.3.8 (May 2, 2013) (not released on vB.org)
- Add file upload option to application questions.(Available from ACP ONLY)

1.3.7 (May 1, 2013)
- Add error field in question editor for validation failure.

1.3.6 (May 1, 2013) (not released on vB.org)
- Fix moderated threads not showing as moderated in ACP.
- Change regex validated fields are now optional if no error message is defined for the field.
- Change streamline code for displaying applications forms.

1.3.5 (April 29, 2013)
- Change question save routine to prevent misnumbering of question order.
- Add single line text answers now allow regular expression matching.(Editing regex available from ACP ONLY)
- Add flood check for new threads
- Add flood check for new posts.

1.3.4 (April 22, 2013) (not released on vB.org)
- Fix header/title phrase input on application type screen not showing properly on forum application screens.
- Fix several typographical errors in phrases.

1.3.3 (March 2, 2013)
- Fix database error if Thread Status Pro is not installed.
(NO NEED TO IMPORT XML IF YOU WERE RUNNING v1.3.2 JUST UPLOAD FILES TO YOUR SERVER)

1.3.2 (February 28, 2013) (not released on vB.org)
- Add support for default forum thread status from Thread Status PRO
(NO NEED TO IMPORT XML IF YOU WERE RUNNING v1.3.1 JUST UPLOAD FILES TO YOUR SERVER)

1.3.1 (November 20, 2012)
- Fix database error when saving application type with some punctuated admin usernames.
(NO NEED TO IMPORT XML IF YOU WERE RUNNING v1.3.0 JUST UPLOAD FILES TO YOUR SERVER)

1.3.0 (November 19, 2012) (never released on vB.org)
- Fix item selection problems with Firefox browser
(NO NEED TO IMPORT XML IF YOU WERE RUNNING v1.2.9 JUST UPLOAD FILES TO YOUR SERVER)

1.2.9 (July 30, 2012)
- Fix error when editing application types in board (was not happening in ACP edit)
(NO NEED TO IMPORT XML IF YOU WERE RUNNING v1.2.8 JUST UPLOAD application-types.php to your server)

1.2.8 (May 23, 2012)
- Improved work around for vB 4.2 bug pertaining to navigation menu items (JIRA VBIV-14959).

1.2.7 (May 21, 2012)
- Work around for vB 4.2 bug pertaining to navigation menu items (JIRA VBIV-14959).

1.2.6 (May 20, 2012) (never released on vB.org)
- Made system compatible with vB 4.2.0

1.2.5 (February 27, 2012)
- Fix IP address not being displayed when answer color option is used.
- Fix overlap of nav tab with nav menu.

1.2.4 (January 17, 2012)
- Fix URL not being parsed when answer color is defined and URL is the only thing in the answer.

1.2.3 (January 11, 2012)
- Add replacement variables to PM after submitting application.
- Add answer color option to main settings.
- Add multiple choice answers in column format option to main settings.
- Add 'All of the above' Multiple Choice question type.

1.2.2 (December 16, 2011) (NO NEED TO IMPORT XML WHEN UPGRADING FROM 1.2.1, JUST UPLOAD FILES TO SERVER)
- Fix UTF-8 character display for expected answers.
- Fix sorting problem with first application questions.

1.2.1 (December 15, 2011) (not uploaded on vBulletin.org)
- Add option to PM a member after submitting an application.
- Add numeric ordering to edit position questions in ACP ONLY. (NOTE: Numbering MUST stay as 1,2,3.. NEVER use 10, 20, 30...)

1.2.0 (December 7, 2011)
- Fix database error when single quote is used in expected responses. (NO NEED TO IMPORT XML WHEN UPGRADING FROM 1.1.9, JUST UPLOAD FILES TO SERVER)

1.1.9 (December 5, 2011) (Not uploaded on vBulletin.org)
- Fix quote character not being displayed properly in posts. (NO NEED TO IMPORT XML WHEN UPGRADING FROM 1.1.8, JUST UPLOAD FILES TO SERVER)

1.1.8 (December 2, 2011)
- Fix 'not enough posts' now displays when it should. (NO NEED TO IMPORT XML WHEN UPGRADING FROM 1.1.7, JUST UPLOAD FILES TO SERVER)

1.1.7 (November 5, 2011)
- Added single selection dropdown box for questions.

1.1.6 (October 13, 2011) (Not uploaded on vBulletin.org)
- Code enhancements for future expansion.

1.1.5 (September 4, 2011)
- Repair forum based application group type editor. (NO NEED TO IMPORT XML WHEN UPDATING FROM 1.1.4 to 1.1.5, JUST UPLOAD FILES TO SERVER - NO NEED TO UPDATE IF YOU DON'T USE THE FORUM BASED EDITOR)

1.1.4 (August 27, 2011)
- Change hard coded Yes/No answers to standard vBulletin Yes/No phrases (thanks to Ellendway for testing).

1.1.3 (August 15, 2011)
- Corrected post format problems.
- Changed human verify portion of template.
- Changed hard coded Yes/No questions to standard vBulletin Yes/No Phrases.

1.1.2 (July 30, 2011)
- Code enhancements to allow for future expansion.

1.1.1 (July 6, 2011)
- Fix human verification. (problem found while converting mod to vB 3.8.7)

1.1.0 (June 29, 2011)
- Installation script change to correct installation problem where plugin was not importing completely for some people.

1.0.9 (June 21, 2011)
- Removed odd credit line for skin.

1.0.8 (June 14, 2011)
- Changed URL parse option so URLs are now parsed in all text fields.
- Changed 'Use First Text Answer As Subject' to subject replacement variable.
- Added option to remove member name from first line of reports.
- Added option to post application reports in an existing thread.
- Moved 'Start Application' button label to advapp vBulletin Phrase.
- Moved 'I am applying for the postion of' text from template to advapp vBulletin Phrase.
- Changed template so 'Member Name' now uses advapp vBulletin Phrase.
- Changed CSS so 'Start Application' button is centered on page.
- Removed remnant heading phrase from application form template.

1.0.7 (June 8, 2011)
- Fix minor bug where multi-line text was being cut into smaller sections.
- Added option to parse URLs. (it is in the position editor)

1.0.6 (June 6, 2011)
- Added option to use first single line text answer as report subject.
- Added option to require approval of the thread created when a member submits an application.
- Added options to redirect member to different locations after submitting an application.

1.0.5 (June 4, 2011)
- Fix default questions were carrying over their display positions causing answers to record improperly.
- Added option to show applications in navbar tabs.

1.0.4 (June 1, 2011)
- Database table creation change to make it compatible with MySQL 5.5.8
(NO NEED TO UPDATE IF YOU ARE ALREADY RUNNING VERSION 1.0.3)

1.0.3 (May 23, 2011)
- Added note about default email/pm user ids to position editors.
- Added Delete All Questions to ACP question editor.
- Added the ability to use a Thread Prefix for report threads.

1.0.2 (May 20, 2011)
- Fix rewind error.

1.0.1 (May 20, 2011)
- Changed database creation method for those that might be having problems.

1.0.0 (May 20, 2011)
- Initial Release

[d19rnyxx]

Database error when i install it

It seems to not create the tables properly.

[nhawk]

What version of Vb are you running?

I've tested it on 4.0.7 and 4.1.1.

And if you could post the error, that would help too.

[d19rnyxx]

im running 4.1.3 and the error is basically the table does not exist "advapp_applications"

so i think its not running the main init for the xml :/

[steviewonder44]

Fantastic will test it out

[nhawk]

Originally Posted by d19rnyxx

im running 4.1.3 and the error is basically the table does not exist "advapp_applications"

so i think its not running the main init for the xml :/

I just ran the install on a 4.1.3 site and it installed without a problem.

I'll need the actual error you get to track this down.

It almost sounds like you uploaded the files, but didn't install the add-on in Plugins & Products -> Manage Products.

[d19rnyxx]

Database error
The FiveStarGamerz - Gaming Forum, News, Reviews, Exploits, Hacks and Glitches database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.fivestargamerz.com home page, then try to open another page.
Click the Back button to try another link.
The www.fivestargamerz.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM advapp_applications ORDER BY type ASC;

MySQL Error : Table 'XXXX.advapp_applications' doesn't exist
Error Number : 1146
Request Date : Friday, May 20th 2011 @ 07:35:18 PM
Error Date : Friday, May 20th 2011 @ 07:35:18 PM
Script : http://www.fivestargamerz.com/gzcp/a...p?do=listtypes
Referrer : http://www.fivestargamerz.com/gzcp/index.php?do=nav
IP Address : XXXXXXXXXX
Username : EliteMossy
Classname : vB_Database
MySQL Version : XXXXXXXX

[nhawk]

Originally Posted by d19rnyxx

Database error
The FiveStarGamerz - Gaming Forum, News, Reviews, Exploits, Hacks and Glitches database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.fivestargamerz.com home page, then try to open another page.
Click the Back button to try another link.
The www.fivestargamerz.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM advapp_applications ORDER BY type ASC;

MySQL Error : Table 'XXXX.advapp_applications' doesn't exist
Error Number : 1146
Request Date : Friday, May 20th 2011 @ 07:35:18 PM
Error Date : Friday, May 20th 2011 @ 07:35:18 PM
Script : http://www.fivestargamerz.com/gzcp/a...p?do=listtypes
Referrer : http://www.fivestargamerz.com/gzcp/index.php?do=nav
IP Address : XXXXXXXXXX
Username : EliteMossy
Classname : vB_Database
MySQL Version : XXXXXXXX

You haven't installed the add-on.

Install the add-on in Plugins & Products -> Manage Products.

At least that's what it looks like to me.

It is also possible you got a bad download. Try downloading and installing again.

[d19rnyxx]

Originally Posted by nhawk

You haven't installed the add-on.

Install the add-on in Plugins & Products -> Manage Products.

I really am not that stupid. The xml was installed.

[nhawk]

Originally Posted by d19rnyxx

I really am not that stupid. The xml was installed.

I didn't mean to imply that.

I edited my reply, the only other thing is you might have gotten a bad download.

Try downloading and install again.

I've now personally installed this on 4.0.7, 4.1.1 and 4.1.3 without any problems.