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

[XLCR GODFATHER]

Originally Posted by riskofficer

Thank you! One more thing about edit is something like "Usergroups Allowed to Edit Form Results". For example I'd like to leave this option (Edit Result) only for person whos answered (starter) and admins/moderators. BTW the option to delete results is in need of permissions too, I haven't found them.

I fully agree where leaving the delete option available makes it too easy for accidental click and should be a permission setting.

[ThorstenA]

Suggestion: Change phrase

Error, you have exceeded limit for number of times this form can be submitted.

to

Error, you have exceeded limit for number of times this form can be submitted.
Edit your submitted form.

Or better:
If a user has exceeded the limit for number of times he can submit the form, redirect him immediately to the edit form.

[ThorstenA]

Bugs:

• I can not edit my own entry if the maximum number of entries is limited to one.
• After I delete my entry (have no entries any more), I can not vote again because "I exceeded the limit"

[ThorstenA]

Originally Posted by ThorstenA

Bugs:

• I can not edit my own entry if the maximum number of entries is limited to one.

Solution for at least going to the edit form

1. Replace in plugin Easy Forms Part 1

    if ($form[submitlimitperuser] >= 1)

to

    if (!$formresult && $form[submitlimitperuser] >= 1)

2. In same plugin in the area after

if ($_POST['do'] == 'postform')

replace

		if ($count >= $form[submitlimitperuser])

to

		if ($count > $form[submitlimitperuser])

[ThorstenA]

Bug: Poll displays free text entries

Solution: Replace in plugin Easy Forms Part 3 short after

if ($_REQUEST['do'] == 'formresults_poll')
{

the code

	$formbits = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "formbits WHERE fid = $fid AND type != 7 ORDER BY displayorder ASC");

to

	$formbits = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "formbits WHERE fid = $fid AND type NOT IN (1,6,7,8,9) ORDER BY displayorder ASC");

[ThorstenA]

Originally Posted by ThorstenA

Bugs:

• After I delete my entry (have no entries any more), I can not vote again because "I exceeded the limit"

Temporary, not really working solution
(This messes lots of things up in your database as userid 123 will have an effect on userid 12345). It is better to get the userids from a simple SELECT query of forumresults table.

Replace in plugin Easy Forms Part 2

if ($_REQUEST['do'] == 'deleteformresult')
{
	$caneditform = unserialize($vbulletin->options['caneditform']);
	if ($caneditform && !is_member_of($vbulletin->userinfo, $caneditform))
	{
		print_no_permission();
	}
	$id = $vbulletin->input->clean_gpc('g', 'id', TYPE_UINT);
	$fid = $vbulletin->input->clean_gpc('g', 'fid', TYPE_UINT);
	$db->query_write("DELETE FROM " . TABLE_PREFIX . "formresults WHERE id=$id");
	$db->query_write("UPDATE " . TABLE_PREFIX . "forms SET userids = REPLACE(userids,\"," . $vbulletin->userinfo[userid] . "\",\"\")  WHERE fid=$fid");
	$vbulletin->url = "misc.php?do=forms";	
	eval(print_standard_redirect('redirect_deleteq'));
}

to

if ($_REQUEST['do'] == 'deleteformresult')
{
	$caneditform = unserialize($vbulletin->options['caneditform']);
	if ($caneditform && !is_member_of($vbulletin->userinfo, $caneditform))
	{
		print_no_permission();
	}
	$id = $vbulletin->input->clean_gpc('g', 'id', TYPE_UINT);
	$fid = $vbulletin->input->clean_gpc('g', 'fid', TYPE_UINT);
	$db->query_write("DELETE FROM " . TABLE_PREFIX . "formresults WHERE id=$id");
	$db->query_write("UPDATE " . TABLE_PREFIX . "forms SET userids = REPLACE(userids,\"," . $vbulletin->userinfo[userid] . "\",\"\")  WHERE fid=$fid");
	$vbulletin->url = "misc.php?do=forms";	
	eval(print_standard_redirect('redirect_deleteq'));
}

[ThorstenA]

To have my users automatically redirect to the form results page where they can edit their entries if they exceeded their maximum entries, I use this code in plugin Easy Forums Part 1

    if (!$formresult && $form[submitlimitperuser] >= 1) 
    { 
        $userids = $form[userids]; 
        $userid = $vbulletin->userinfo[userid]; 
        $count = substr_count(",$userids,", ",$userid,"); 
        if ($count >= $form[submitlimitperuser]) 
        { 
	$vbulletin->url = "misc.php?do=formresults&fid=" . $fid;
	eval(print_standard_redirect('redirect_deleteq'));
             //$errormessage = "Error, you have exceeded limit for number of times this form can be submitted."; 
            //eval(standard_error($errormessage)); 
        } 
    }

I use this product as a review type. For each form a user can only have one entry. As I only have one entry to be displayed on this page anyway, I am redirecting my user to the edit page directly. For doing that I need the id of the formresults table:

    $id = $db->query_first("SELECT id FROM " . TABLE_PREFIX . "formresults WHERE fid = '$fid' AND userid = " . $vbulletin->userinfo[userid] . "");
	$vbulletin->url = "misc.php?do=editformresult&id=" . $id[id] . "&fid=" . $fid;
	eval(print_standard_redirect('redirect_deleteq'));

[ThorstenA]

This is about the database "review" model where users are allowed to give an entry once (limit: 1).

Users are allowed to see the poll results from all users. However, for Privacy Reasons users can only see their own entries on form results table:

In plugin Easy Forms Part 3 replace

	$formresults = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE fid = '$fid' $search AND userid=" . $vbulletin->userinfo[userid] . " ORDER BY time DESC");

to

	$formresults = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "formresults WHERE fid = '$fid' $search AND userid=" . $vbulletin->userinfo[userid] . " ORDER BY time DESC");

[ThorstenA]

After user has completed the entry successfully, he is redirected to the statistic page:

Replace in plugin Easy Forms Part 1

    if ($complete && $show['editing']) 
    { 
        $sdata = serialize($qo); 
        $db->query_write(" 
            UPDATE " . TABLE_PREFIX . "formresults 
            SET 
                title = '".$db->escape_string($threadtitle)."', 
                output = '".$db->escape_string($formoutput)."', 
                sdata = '".$db->escape_string($sdata)."' 
            WHERE 
                fid = '".$fid."' AND 
                id = '".$show['edit_id']."' 
        "); 
        $errormessage = "Form Result was successfully updated."; 
        $vbulletin->url = $vbulletin->options['bburl'] . "/misc.php?do=formresults&fid=$fid"; 
        eval(print_standard_redirect($errormessage, false, true)); 
    }

to

	    if ($complete && $show['editing']) 
    { 
        $sdata = serialize($qo); 
        $db->query_write(" 
            UPDATE " . TABLE_PREFIX . "formresults 
            SET 
                title = '".$db->escape_string($threadtitle)."', 
                output = '".$db->escape_string($formoutput)."', 
                sdata = '".$db->escape_string($sdata)."' 
            WHERE 
                fid = '".$fid."' AND 
                id = '".$show['edit_id']."' 
        "); 
        $errormessage = "Form Result was successfully updated."; 
	$vbulletin->url = $vbulletin->options['bburl'] . "/misc.php?do=formresults_poll&fid=$fid"; 
        eval(print_standard_redirect($errormessage, false, true)); 
    }

[ThorstenA]

I love this product! Therefore I took some time to look into it and I have some suggestions for its database structure

• Rename row time to dateline (as they do in the other vbulletin tables)
• Remove username from table formresults and fetch username by querying user table.
  ("... FROM formresults, user WHERE formresults.userid=user.userid ...")
  
• Remove userids from table forms and get this information from table forumresults. This is needed for limit users entries for a question. It is very hard to maintain duplicate (redundant) information. You have all these infos when querying forumresults table
  ("SELECT count(userid) AS usercount FROM forumresults WHERE fid=$fid AND userid=" . $vbulletin->userinfo[userid] ."")
• Remove redirect from table forms. It is redundant to redirecturl.