New Posting Features - Easy Forms v4.x - Create a form or multiple forms without php or html knowledge

Easily create forms with no HTML or PHP knowledge. Questions can be made compulsory and are checked before the form is submitted. Forms can be previewed. (You can create multiple forms)

Screenshots
There are two posts full of screenshots of this modification

• https://vborg.vbsupport.ru/showpost....64&postcount=3
• https://vborg.vbsupport.ru/showpost....65&postcount=4

Installation

1. Download and then extract .zip archive
2. Upload the contents of upload folder to forum root
   (Allow Overwrite "YES" for overwrite)
   clientscript\easyforms.css -> \clientscript\
   clientscript\easyforms.js -> \clientscript\
3. Import product file (product-easyforms v4.0.xml) in admincp
   AdminCP -> Plugins & Products -> Manage Products -> [Add/Import Product]
4. Change usergroups permissions at:
   AdminCP -> vBulletin Options -> Easy Form Options

Question Types:

• Single line text
• Multi-line text
• Multi-select checkboxes
• Single-select radio buttons
• Single Select Dropdown
• Yes/No
• Multi-line text field using vbeditor
• Human verification question
• Custom Question (can query database or do whatever you want using php and html)
• Date (month/ day/ year fields)
• Address
• Scale

Form can Submit to:

• new thread in forum
• new post in thread
• new pm to user
• email address
• save to database

More Features:

• Form list categories (optional)
• Preview form (can disable for individual forms)
• Optional questions
• Form Sections
• Prefix support - you can choose which prefix you want thread to have
• Different thread/pm title to form title with variables {username} {userid} and {q_1} (replacing 1 with appropriate question number)
• Poll Options: Multiple choice, public vote, poll question, poll options, poll timeout
• Regular expression match for single line text input field
• Usergroup permissions per form
• Forumid/threadid/username can be specified by input via {value=X} in dropdown, single line input or radio buttons
• Multiple dropdown select for form usergroup permissions (still optional - leave blank to not use)
• Option to show link to form list in navbar and quick links (separate options)
• Import/ Export your forms as XML files - great for transferring forms across forums or creating backups
• Specify bbcode for questions/ answers/ sections for the form's output
• Form Hooks: (uses php code)
  1. Before form submitted
     Useful for: your own form validation, multiple form outputs, etc.
  2. At form start
     Useful for: banning userids/usergroups from form, setting minimum post count,etc.
• Attachments allowed for posting new thread
• Mass Copy Forms & their questions
• Quiz Mode

Support this Modification

• Click 'Marked as Installed'
• Rate it 'Excellent'
• Consider a donation

[PPhysX]

Database error in vBulletin 4.2.5:

Invalid SQL:
INSERT INTO formbits
		(fid, displayorder, type, question, description, options, compulsory, perrow, rows, cols, maxlength, ereg, custom, spacer, size, guestonly, minlength, reference, hidelabel, quiz)
		VALUES ('1', '10', '13', 'Test Scale', '', '', '1', '0', '1', '5', '0', '', '', '', '0', '0', '0', '', '0', '');

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows, cols, maxlength, ereg, custom, spacer, size, guestonly, minlength, referen' at line 2
Error Number  : 1064

Any fix for this please?

[shka]

Updated your DB server?

Originally Posted by PPhysX

Invalid SQL:
INSERT INTO formbits
(fid, displayorder, type, question, description, options, compulsory, perrow, rows, cols, maxlength, ereg, custom, spacer, size, guestonly, minlength, reference, hidelabel, quiz)
...

"Rows" is a reserved word in MariaDB since 10.2.4

Edit your forms.php and quote the column names with backticks `
, I found this three times
Line 1976

PHP Code:

(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `perrow`, `rows`, `cols`, `maxlength`, `ereg`, `custom`, `spacer`, `size`, `guestonly`, `minlength`, `reference`, `hidelabel`, `quiz`) 


Line 3305

PHP Code:

(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `rows`, `cols`, `maxlength`, `size`, `perrow`, `ereg`, `custom`, `guestonly`, `minlength`, `reference`, `hidelabel`) 


Line 3555

PHP Code:

(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `rows`, `cols`, `maxlength`, `size`, `perrow`, `ereg`, `custom`, `guestonly`, `minlength`, `reference`, `hidelabel`) 


[PPhysX]

Originally Posted by shka

Updated your DB server?



"Rows" is a reserved word in MariaDB since 10.2.4

Edit your forms.php and quote the column names with backticks `
, I found this three times
Line 1976

PHP Code:

(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `perrow`, `rows`, `cols`, `maxlength`, `ereg`, `custom`, `spacer`, `size`, `guestonly`, `minlength`, `reference`, `hidelabel`, `quiz`) 


Line 3305

PHP Code:

(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `rows`, `cols`, `maxlength`, `size`, `perrow`, `ereg`, `custom`, `guestonly`, `minlength`, `reference`, `hidelabel`) 


Line 3555

PHP Code:

(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `rows`, `cols`, `maxlength`, `size`, `perrow`, `ereg`, `custom`, `guestonly`, `minlength`, `reference`, `hidelabel`) 


Thanks for the quick reply! I have gone ahead and tried this, and given it another try.
This time the error is as follows:

Database error in vBulletin 4.2.5:

Invalid SQL:
INSERT INTO formbits
		(`fid`, `displayorder`, `type`, `question`, `description`, `options`, `compulsory`, `perrow`, `rows`, `cols`, `maxlength`, `ereg`, `custom`, `spacer`, `size`, `guestonly`, `minlength`, `reference`, `hidelabel`, `quiz`)
		VALUES ('1', '10', '13', 'Test Scale', 'Test descr', '', '1', '0', '1', '5', '0', '', '', '', '0', '0', '0', '', '0', '');

MySQL Error   : Unknown column 'rows' in 'field list'
Error Number  : 1054

[shka]

It is only a MariaDB-reserved-word-problem with two possible reasons and solutions.

A. Install mod first and later upgrade MariaDB to 10.2.4+
Then you can check in phpmyadmin if there is a column "rows" in table formbits. If yes then backticks two posts above is the solution.
If no then B.

B. (like PPhysX) Install mod on MariaDB 10.2.4+
Then adding the "rows"-column fails in installer. Then it makes more sense to use a better column-name.
a. First goto phpmyadmin in forum-db
Call sql (same as installer but changed column to "textrows" for visible rows in textarea)

ALTER TABLE formbits ADD textrows int(5) NOT NULL default '3';

Then with sql "show fields from formbits" you shoud see a new line (= tablecolumn) called textrows

b. The go to forms.php and edit the three lines 1976,3305,3555. You can use old or new version (with or without backticks, but replace "rows" with "textrows").

c. Then edit some other lines (always replacing rows with textrows shown next)

line 2054
			textrows = '". $vbulletin->db->escape_string($rows)."',
line 3401
			'rows'          => $formbit['textrows'],
line 475
			$formoutput .= $form['prea'] . ($qo[$formbit[id]] >= $formbit['textrows']  ...
line 521
		elseif (($qo[$formbit[id]] < $formbit['textrows'] OR ...
line 1611
			$i = $formbit['textrows'];
line 2377
			$starti = $formbit['textrows'];
line 3314
					'" . $vbulletin->db->escape_string($question['textrows']) . "',
line 3564
					'" . $vbulletin->db->escape_string($question['textrows']) . "',

[PPhysX]

Big thanks to 'shka', his solution worked and so far no errors whatsoever on 4.2.5

[N0FeaR]

Is there any plugin like this for vbulletin 5 ?

[wolfe]

I have my forms make threads and have stopped them saving to database so how do I delete old complete form entries ?