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

[bananalive]

Originally Posted by steveman0018

bananalive, this mod makes my website recruit form so much easier. Thank you very much. On a side note, a lot of people over at xenforo really want this mod ported over. Some offering donations too. Do you have any plans to do this?

Sorry, no I'm not.

[bananalive]

Originally Posted by thunderclap82

I'm still waiting for a response too. I've checked the permissions for attachments per your suggestion yet non-admin users still can't attach files. Is there a hidden Forms setting somewhere I'm missing?

Is it showing attach link? Are they getting error messages?

[bananalive]

Originally Posted by customcolor

yeah!!your back!!

now i like to bump my question i had a wile back...


ok here is my question...i see what you did in post #64 and that is make it so you can choose an answer that is a thread title that is in a certain forum....now can you make it so that is the thread that the results go to from the form?...aka user can choose what thread in a forum the results go to every time with out having to go to that thread/s every time?

Form Hook: Form Start:

PHP Code:

$form['threadid'] = $q['threadid']; 


Form Hook: Before Submit:

PHP Code:

$form['threadid'] = $q['threadid']; 


Custom Question

• Reference Name:

  threadid

• PHP Code:
  PHP Code:

  $answer = '<select name="'.$formbit[id].'">'; 
      $answer .= '<option></option>'; 
      $thisanswer = $q[$formbit[id]]; 
      $threads = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread 
      WHERE forumid = '2' 
      ORDER BY title ASC"); 
          while($row = $db->fetch_array($threads)) { 
      $answer .= '<option value="'.$row[threadid].'"'; 
      if ($row[threadid] == $thisanswer) { 
      $answer .= 'selected="selected"'; 
      } 
      $answer .= '>'.$row[title].'</option>'; 
      } 
      $answer .= '</select>'; 


[bananalive]

Originally Posted by Greight

Unicode characters like ب ت م and it does not make difference in any field. All turn into question marks.

I have just checked on my forum and those characters are inserted fine in forms for me.

[bananalive]

Originally Posted by paul41598

Is noone having major issues with this product with 4.1? I have sql errors constantly. I had issues installing the product and had to edit the DB create statements and remove the TYPE=MYSAM or whatever to get it to import.

Now when I try to delete forms I get:

atabase error in vBulletin 4.1.1:

Invalid SQL:
DELETE FROM formbits WHERE fid=1  AND userid = '1';

MySQL Error   : Unknown column 'userid' in 'where clause'
Error Number  : 1054
Request Date  : Wednesday, February 2nd 2011 @ 03:19:20 PM
Error Date    : Wednesday, February 2nd 2011 @ 03:19:21 PM

Here's the one I was talking about when I import the product

Database error in vBulletin 4.1.1:

Invalid SQL:

  CREATE TABLE IF NOT EXISTS `forms` (
  `fid` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `displayorder` int(10) NOT NULL,
  `action` int(3) NOT NULL,
  PRIMARY KEY  (`fid`)
) TYPE=MyISAM;

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 'TYPE=MyISAM' at line 8
Error Number  : 1064

Try attached file.

[thunderclap82]

Originally Posted by bananalive

Is it showing attach link? Are they getting error messages?

I'm getting the error:

"You do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation."

I can only assume this means the permissions are configured wrong but, again, I've triple checked the forum permissions, usergroup permissions and verified with vB support and it's all configured properly.

[bananalive]

Originally Posted by thunderclap82

I'm getting the error:

"You do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation."

I can only assume this means the permissions are configured wrong but, again, I've triple checked the forum permissions, usergroup permissions and verified with vB support and it's all configured properly.

Does the error come up after you click 'Manage Attachments'?

Does the user have permission to view forum, the thread is being created within?

Does the user have permission to post in the forum the thread is being created within?

Sorry about all the questions, but it's the only way i'll be able to find a solution because i cannot replicate the problem at the moment.

[thunderclap82]

Originally Posted by bananalive

Does the error come up after you click 'Manage Attachments'?

Yes.

Does the user have permission to view forum, the thread is being created within?

Yes, though the forum is hidden.

Does the user have permission to post in the forum the thread is being created within?

Yes. And if they fill out the form it posts properly. It's only the Manage Attachments that isn't working.

[thrace]

Would it be possible to add a user to a special user group after they have completed the form? if so how would one go about doing this?

[bananalive]

Originally Posted by thunderclap82

Yes.

Yes, though the forum is hidden.

Yes. And if they fill out the form it posts properly. It's only the Manage Attachments that isn't working.

Here's a fix:

1. Edit Form -> Alter Forum to one where users can post threads and attach files
2. Create the following vBulletin Plugin via AdminCP
   • php code
     PHP Code:

     if ($fid == 43)
{
$forumid = 6;
$dataman =& datamanager_init('Thread', $vbulletin, ERRTYPE_ARRAY, 'threadpost'); 
$dataman->set_existing($threadinfo);  
$dataman->setr('forumid', $forumid);  
$dataman->pre_save(); 
if (count($dataman->errors) > 0) 
{ 
    foreach ($errors as $error)
    {
        $errorss .= $error. "<br />";
    }
    $errormessage = "Form failed to submit. The following error(s) occured: <br /> ".$errorss;
    eval(standard_error($errormessage));
} 
else 
{ 
$dataman->save();  
$foruminfo = fetch_foruminfo($forumid);
$threadinfo = fetch_threadinfo($newpost['threadid']);
mark_thread_read($threadinfo, $foruminfo, $vbulletin->userinfo['userid'], TIMENOW);    
}
} 

   • change 43 for appropriate form id
   • change 6 to appropriate forum id
   • hook name

     newthread_post_complete