[BFC] Applicator

[EnIgMa1234]

/*================================================= ====
||
|| [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!.

[EnIgMa1234]

Change Log:

1.0 => 1.1: Added Thread Posting feature.

[abouahmed]

Features:
See screenshots.

where ?

[EnIgMa1234]

where ?
Give me a chance :P
They are up now.

[M-Tuning]

Nice, but would be even cooler when there is an option to automatically post a topic/post when someone made an application.

[EnIgMa1234]

Nice, but would be even cooler when there is an option to automatically post a topic/post when someone made an application.
Would be pretty easy for me to do :)
I'll try get this done today.

[rmxs]

hello,
Its possible to complete fields username email etc?
When user is login wht we have ask for username and email?

[EnIgMa1234]

hello,
Its possible to complete fields username email etc?
When user is login wht we have ask for username and email?
Username is automatically given on new entries.

[rmxs]

You have a mistake at folders..

folder names are include and xml and not Include and Xml :)
this are 2 different folders..

Edit..I cant fount the menu at CP

[rmxs]

Error when you install the product...
Parse error: syntax error, unexpected T_STRING in /home/rmxs/domains/xxx.com/public_html/Vb/admincp/plugin.php(1995) : eval()'d code on line 1

[EnIgMa1234]

Error when you install the product...
Parse error: syntax error, unexpected T_STRING in /home/rmxs/domains/xxx.com/public_html/Vb/admincp/plugin.php(1995) : eval()'d code on line 1
Uninstall the product and reinstall the new one I've uploaded.

[Hasann]

Very Nice Work Buddy
Exact what I Needed
Thank You Installed.

[nalexandre]

Thank you for this hack, my question is. Is this hack possible to turno into a feedback aplicattion? Like in a area of classifieds, with this aplicattion, the members are alowed to give feedback about the sales, and automatically this creats a post in a specify forum?
Sorry about my english and my explanation.

Obrigado.

[EnIgMa1234]

Thank you for this hack, my question is. Is this hack possible to turno into a feedback aplicattion? Like in a area of classifieds, with this aplicattion, the members are alowed to give feedback about the sales, and automatically this creats a post in a specify forum?
Sorry about my english and my explanation.



Obrigado.
Yes :) It can be used to create any application imaginable

[M-Tuning]

Would be pretty easy for me to do :)
I'll try get this done today.

Nice, would be cool if you can do that!

[Ocean-Wonders]

I've installed this but can't find the menu in my ACP ??

[EnIgMa1234]

Oops, put the wrong file in. Reupload the cpnav_applicator.xml file :)

[nyqnzguju999]

Great work :) Installed

I will wait for you to finish up the new thread when a new application is field.

Ones again NICE WORK. Just get that think done asap :) And registering at your site now

[pein87]

great work installed, just a tiny question how many queries goes this add? and could there be away to add applications to a new page?

[EnIgMa1234]

Updated :) Thread Posting is now added.

[nalexandre]

Updated :) Thread Posting is now added.

Thank you.

[EnIgMa1234]

Thank you, it gives an error when i try to download.
Downloading the addon from here?
What error does it give?

[tafreeh]

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]

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]

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]

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

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]

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]

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

[MrEyes]

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

On install you get the following error:

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:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS".TABLE_PREFIX."`applicator_question` (
Should be:
$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:

$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:

$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]

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

On install you get the following error:

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:

$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS".TABLE_PREFIX."`applicator_question` (
Should be:
$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:

$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:

$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:

[EntranaRS]

i get a database error..

[EntranaRS]

This is the error i get and i put a space in the product file still didnt work please help

Database error in vBulletin 3.8.2:

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 : Wednesday, May 20th 2009 @ 04:46:05 AM
Error Date : Wednesday, May 20th 2009 @ 04:46:05 AM
Script : http://www.scapemasters.com/admincp/plugin.php?do=productimport
Referrer : http://www.scapemasters.com/admincp/plugin.php?do=productadd
IP Address : 78.147.78.104
Username : Moonnite
Classname : vB_Database
MySQL Version : 5.1.30

[EnIgMa1234]

Ugh...Can't believe I messed up the product file again.

The next version will have many bug fixes :)

[Knight0319]

Maybe you can add an option that tells you if another admin already read the application already. Otherwise, this is a great addon.

[eXoOutsider]

This is the error i get and i put a space in the product file still didnt work please help

Database error in vBulletin 3.8.2:

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 : Wednesday, May 20th 2009 @ 04:46:05 AM
Error Date : Wednesday, May 20th 2009 @ 04:46:05 AM
Script : http://www.scapemasters.com/admincp/plugin.php?do=productimport
Referrer : http://www.scapemasters.com/admincp/plugin.php?do=productadd
IP Address : 78.147.78.104
Username : Moonnite
Classname : vB_Database
MySQL Version : 5.1.30

Same error, looking forward to a fix.

[meissenation]

Been subscribed for awhile but afraid to install until it's stable.

[Skyrider]

Indeed, get the same error as above.

[EnIgMa1234]

Hey,
Just updated this (finally).

Installation should be stable now.

Sorry for the inconvienience.

[meissenation]

Installed perfectly. I made an application and I click the link from Manage Applications on the app that I created but when it takes me to applicator.php?app=1 I get an error message that the application does not exist.

Edit: Well, that's weird. I went in and edited the application and all the checkboxes for the permissions were blank. I only clicked a few and hit edit and now I can see the app. When I click "Edit" on the app again, the checkboxes are blank again.

Edit 2: OK - If i select almost all of the usergroups, it won't apply and I can't view the application. If I only select a handful of them, then I can view the app. Strange. Hope the bugs get worked out because this has so much potential.

[Skyrider]

Same, this plugin is a bit bugged. Selecting all groups makes it displaying there is no application, and when it is posted, "Administrator" (username number: 1) is making a new thread. I thought it was going to be posted by the user itself?

Please enter the userid of the user you want posting the new thread.
Please note: If no value is entered, the person submitting the entry will post it.
Seems to be keep changing to 1.

Great plugin though!

[LCN2007]

How does a member access the actual application to fill it out?

[EnIgMa1234]

How does a member access the actual application to fill it out?
By linking the URL.

[LCN2007]

I feel stupid lol i was missing a file. Thanks for the fast support & great product.

Im having the same problem as this guy below.

Same, this plugin is a bit bugged. Selecting all groups makes it displaying there is no application, and when it is posted, "Administrator" (username number: 1) is making a new thread. I thought it was going to be posted by the user itself?


Seems to be keep changing to 1.

Great plugin though!

[TheSupportForum]

getting this message, please help

Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home/tutorial/public_html/includes/class_applicator.php on line 10

[AWantedHero]

I get this

Database error in vBulletin 3.8.3:

Invalid SQL:
CREATE TABLE IF NOT EXISTS vb3`applicator_question` (
`qid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appid` INT( 10 ) NOT NULL DEFAULT '0',
`question` VARCHAR( 150 ) NOT NULL ,
`qtype` VARCHAR( 20 ) NOT NULL ,
`quniqueid` VARCHAR( 10 ) NOT NULL ,
`qorder` INT( 15 ) NOT NULL DEFAULT '1',
`qoptions` VARCHAR( 150 ) NOT NULL,

UNIQUE (
`qid`
)
);

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 '`applicator_question` (
`qid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`appid` INT(' at line 1
Error Number : 1064
Request Date : Saturday, June 13th 2009 @ 06:22:58 PM
Error Date : Saturday, June 13th 2009 @ 06:22:58 PM
Script : http://warriersofpie.net/forum/admincp/plugin.php?do=productimport
Referrer : http://warriersofpie.net/forum/admincp/plugin.php?do=productadd
IP Address : 24.16.139.173
Username : bahoginbill
Classname : vB_Database
MySQL Version : 5.0.67-community

[Vackrick]

there isnt any staff application on the navbar

and the username posting the application keep changing to 1...

when i go to my site url /applicator.php

it say

Invalid App