The Arcive of Official vBulletin Modifications Site.

[BFC] Applicator · **Released**: 05-16-2009

/*================================================= ====
||
|| [BFC] Applicator
|| ------------------------------------------------------------------
|| Author: EnIgMa1234
|| Site: http://www.bluefirecreation.com
|| Copyright ?2009 EnIgMa1234.
|| This addon may not be redistributed or modified in whole or significant part.
||
\*================================================ =====

Presenting The Applicator!

What is it?
Ever wanted to easily add surveys or applications to your forum but didn't know how? Applicator does this for you. With Applicator you can create endless amounts of applications/surveys in just a few clicks.

Features:
See screenshots.

How do I install?
Follow the installation instructions provided

.

Support for this product will be provided on my site.

Limit support will be offered here.

Please do not PM me about this hack. Thanks!.

nalexandre · #22 05-18-2009, 03:39 PM

Quote:

Originally Posted by EnIgMa1234

Updated

Thread Posting is now added.

Thank you.

EnIgMa1234 · #23 05-18-2009, 03:40 PM

Quote:

Originally Posted by nalexandre

Thank you, it gives an error when i try to download.

Downloading the addon from here?
What error does it give?

tafreeh · #24 05-18-2009, 07:31 PM

great mod... but can we add a separator after X question , plus can we change line in question.... or add description of question right below it.... for example...
You asked question in English and u want add Spanish translation underneath it.

but its great mod.... i will try it definitely as soon as you add these features... if not possible i will still give it a chance

The D · #25 05-18-2009, 07:37 PM

I keep getting SQL errors left and right with missing tables. I reinstalled it and it still errors out. I can't click the 'Main' link nor can I create new applications.

EnIgMa1234 · #26 05-18-2009, 08:47 PM

Quote:

Originally Posted by The D

I keep getting SQL errors left and right with missing tables. I reinstalled it and it still errors out. I can't click the 'Main' link nor can I create new applications.

Could you post the error please

The D · #27 05-19-2009, 03:15 AM

Sure thing.

I had the error while installing like the others, but here is the SQL errors I was getting.

Code:

		SELECT *
		FROM applicator_app
		ORDER BY appid ASC;

MySQL Error  : Table 'forum_vb.applicator_app' doesn't exist

It apparently didn't create the tables for some reason.

sargatanas · #28 05-19-2009, 09:35 AM

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT *
FROM applicator_app
ORDER BY appid ASC;

MySQL Error : Table 'sargatanas.applicator_app' doesn't exist
Error Number : 1146
Request Date : Tuesday, May 19th 2009 @ 03:34:16 AM
Error Date : Tuesday, May 19th 2009 @ 03:34:16 AM

Help Please

EnIgMa1234 · #29 05-19-2009, 02:43 PM

Ok uninstall the old product and reimport the new one - Overwrite = No

MrEyes · #30 05-19-2009, 09:11 PM

There is a "bug" in the current product file:

On install you get the following error:

Code:

Database error in vBulletin 3.8.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` VARCHAR( 100 ) NOT NULL DEFAULT 'Name',
`appactive` TINYINT( 1 ) NOT NULL DEFAULT '1',
`appperms` VARCHAR( 150 ) NOT NULL DEFAULT '0',
UNIQUE (
`appid`
)
);

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 'EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` V' at line 1
Error Number  : 1064
Request Date  : Tuesday, May 19th 2009 @ 10:37:40 PM
Error Date    : Tuesday, May 19th 2009 @ 10:37:40 PM
Script        : http://www.wibble.com/admincp/plugin.php
Referrer      : http://www.wibble.com/admincp/plugin.php?do=productadd
IP Address    : 90.213.65.43
Username      : Wibble
Classname     : vB_Database
MySQL Version : 5.0.45-community-nt

This is becuase of a missing space in the product XML, the following line:

Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS".TABLE_PREFIX."`applicator_question` (

Should be:

Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."`applicator_question` (

Notice the space after EXISTS

Also there is a bug in the navbits, at the moment navbits is set using this code:

Code:

$navbits[$parent] = $vbphrase['bs_newbattle'];

and that phrase doesn't exists and isn't created by the product install, for now I have changed this to:

Code:

$navbits[$parent] = 'Applications'

However it would be better if this was the name of the application being viewed.

Also, I need to ask some fairly long questions but the question DB field is only 150 characters, so I have changed this to MEDIUMTEXT

And finally, if a user submits an application and then tries to resubmit another they get a standard (unphrased) "Error while posting application. Please try again." message - if the user has already submitted then it should really display their current submission and remove the submit button - or even better have a config value for each application that sets whether the user can resubmit.

Looks like a fantastic mod, but need a little polish before it is ready to go on live sites.

sargatanas · #31 05-20-2009, 04:21 AM

Quote:

Originally Posted by MrEyes

There is a "bug" in the current product file:

On install you get the following error:

Code:

Database error in vBulletin 3.8.0:

Invalid SQL:
CREATE TABLE IF NOT EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` VARCHAR( 100 ) NOT NULL DEFAULT 'Name',
`appactive` TINYINT( 1 ) NOT NULL DEFAULT '1',
`appperms` VARCHAR( 150 ) NOT NULL DEFAULT '0',
UNIQUE (
`appid`
)
);

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 'EXISTSapplicator_app (
`appid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appname` V' at line 1
Error Number  : 1064
Request Date  : Tuesday, May 19th 2009 @ 10:37:40 PM
Error Date    : Tuesday, May 19th 2009 @ 10:37:40 PM
Script        : http://www.wibble.com/admincp/plugin.php
Referrer      : http://www.wibble.com/admincp/plugin.php?do=productadd
IP Address    : 90.213.65.43
Username      : Wibble
Classname     : vB_Database
MySQL Version : 5.0.45-community-nt

This is becuase of a missing space in the product XML, the following line:

Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS".TABLE_PREFIX."`applicator_question` (

Should be:

Code:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS ".TABLE_PREFIX."`applicator_question` (

Notice the space after EXISTS

Also there is a bug in the navbits, at the moment navbits is set using this code:

Code:

$navbits[$parent] = $vbphrase['bs_newbattle'];

and that phrase doesn't exists and isn't created by the product install, for now I have changed this to:

Code:

$navbits[$parent] = 'Applications'

However it would be better if this was the name of the application being viewed.

Also, I need to ask some fairly long questions but the question DB field is only 150 characters, so I have changed this to MEDIUMTEXT

And finally, if a user submits an application and then tries to resubmit another they get a standard (unphrased) "Error while posting application. Please try again." message - if the user has already submitted then it should really display their current submission and remove the submit button - or even better have a config value for each application that sets whether the user can resubmit.

Looks like a fantastic mod, but need a little polish before it is ready to go on live sites.

very well said. :up:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04630 seconds Memory Usage 2,353KB Queries Executed 26 (?)
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 (11)bbcode_code (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)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 (8)postbit_attachment (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_attachment 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!