vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   New Posting Features - Easy Forms v4.x - Create a form or multiple forms without php or html knowledge (https://vborg.vbsupport.ru/showthread.php?t=234385)

bananalive 01-29-2011 10:46 AM

Quote:

Originally Posted by ceho (Post 2155348)
Hi, jus two questions I couldn't find the answers to:

is it possible to preselect a value from a dropdown select so that it's shown when a user enters the form?

And second: is it somehow possible that users of a form could upload a picture via form that will be shown in a post/thread (as an attachment)? How would I do such a thing, how would I set up a form field (custom?)?

And maybe you can take a look at this old post of mine: https://vborg.vbsupport.ru/showpost....&postcount=956

I hope I made myself understood... Thankyou very much!

1. Yes, using form hooks. For example: Form Hook: Form Start:
PHP Code:

if ($_REQUEST['select']==1)
{
$qo['316']=1;
$q['316']=1;


http://www.yourforums.com/forums/misc.php?do=form&fid=41&select=1
This would select the first option of question with question hash 316

2. Yes, click enable attachments. (Only available for forms creating new threads)

bananalive 01-29-2011 10:48 AM

Quote:

Originally Posted by biancolaw (Post 2155798)
Love this mod, can you tell me how I what code I would change to add a section as a link to the new form? I thought it would be section_navnext but I can't find where to edit to make it work. Nobody seems to have a straight answer to make a section a link.

I do not understand what you mean? Are you talking about form sections? or sections elsewhere in vBulletin?

ceho 01-29-2011 11:03 AM

bananalive, you rock, thank you very much!!

ascroft 01-29-2011 07:45 PM

Hi there - seeking some advice on how to use forms for replying to thread posts. I have set up and working well for controlling new posts to forums. Many thanks for the earlier advice re that.

Also with regard to polls, could you add a variable on the end of this - I am keen to differentiate my polls per post but as the questions are all the same per post (which is what I want), VB seems to just show the latest voted thread - ie through the poll widget.....

www.shackchat.co.nz

bananalive 01-30-2011 04:59 PM

Quote:

Originally Posted by ascroft (Post 2156178)
Hi there - seeking some advice on how to use forms for replying to thread posts. I have set up and working well for controlling new posts to forums. Many thanks for the earlier advice re that.

Also with regard to polls, could you add a variable on the end of this - I am keen to differentiate my polls per post but as the questions are all the same per post (which is what I want), VB seems to just show the latest voted thread - ie through the poll widget.....

www.shackchat.co.nz

Are you referring to Form Results Poll or creating a thread with a poll?

Gomojoe 01-30-2011 08:51 PM

I'm having a problem with permissions. I set it to allow unregistered/not logged in users to be able to see the forms, but when I click on my form when I am not logged in I get the "I do not have permission" notice. Is there something I'm missing here?

ascroft 01-31-2011 04:47 AM

Quote:

Originally Posted by bananalive (Post 2156536)
Are you referring to Form Results Poll or creating a thread with a poll?

Hi - I mean creating a poll upon form submission.

thunderclap82 02-01-2011 12:22 PM

Quote:

Originally Posted by JamesGunner (Post 1999283)
Im having a bit trouble with the "Manage Attachment" Button on the form. The user can fill in the form and a thread will be posted in an internal section of our forum so that user cant read the outcome / the thread. If a user wants to attach something he will get the "No permission" message telling him that he doesnt have permission to attach something. Is there any way around this?

This is the problem I'm currently having. The forum permissions and usergroup permissions are configured correctly, yet only admin can attach files. Did you ever resolve this?

garfieldH 02-01-2011 03:42 PM

How can I move the position of the tab? I'd like to have it at the end of the other tabs, or at least further away from 'Forum'.

bananalive 02-01-2011 05:01 PM

Quote:

Originally Posted by garfieldH (Post 2157369)
How can I move the position of the tab? I'd like to have it at the end of the other tabs, or at least further away from 'Forum'.

  1. Find in plugin Easy Forms - Forms Tab
    PHP Code:

    $template_hook['navtab_middle'

  2. Replace with
    PHP Code:

    $template_hook['navtab_end'


bananalive 02-01-2011 05:04 PM

Quote:

Originally Posted by thunderclap82 (Post 2157315)
This is the problem I'm currently having. The forum permissions and usergroup permissions are configured correctly, yet only admin can attach files. Did you ever resolve this?

Check your permissions for attachments as per the forum the form posts to.

bananalive 02-01-2011 05:09 PM

Quote:

Originally Posted by Gomojoe (Post 2156627)
I'm having a problem with permissions. I set it to allow unregistered/not logged in users to be able to see the forms, but when I click on my form when I am not logged in I get the "I do not have permission" notice. Is there something I'm missing here?

Double check that you are editing ability for users to view form and not the ability to view form lists.

thunderclap82 02-01-2011 09:01 PM

Quote:

Originally Posted by bananalive (Post 2157409)
Check your permissions for attachments as per the forum the form posts to.

Quote:

Originally Posted by bananalive (Post 2157412)
Double check that you are editing ability for users to view form and not the ability to view form lists.

Well, Forum & Moderators --> Forum Permissions --> Can Upload Attachments is set to Yes.

Usergroup has the ability to attach up to 10MB files.

I double checked the form settings and the users are configured properly. The can view the forms but not the form lists.

paul41598 02-02-2011 01:20 PM

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

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

Code:

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


Greight 02-03-2011 06:08 AM

Quote:

Originally Posted by bananalive (Post 2156017)
What are you trying to input? and into what field?

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

TeknoSounds 02-03-2011 08:56 AM

Quote:

Originally Posted by paul41598 (Post 2157777)
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:
Code:

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

Code:

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


Upgraded just now from a couple versions ago, not sure of the exact one, but
I didn't receive any SQL errors during product import nor have noticed any on my dev site.

Is yours a first time install or upgrade?

paul41598 02-03-2011 05:59 PM

First time install

customcolor 02-04-2011 12:05 AM

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?

steveman0018 02-04-2011 12:59 AM

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?

thunderclap82 02-04-2011 03:42 PM

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?

bananalive 02-04-2011 08:14 PM

Quote:

Originally Posted by steveman0018 (Post 2158498)
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 02-04-2011 08:25 PM

Quote:

Originally Posted by thunderclap82 (Post 2158739)
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 02-04-2011 08:33 PM

Quote:

Originally Posted by customcolor (Post 2158480)
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:
    Code:

    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 02-04-2011 08:37 PM

Quote:

Originally Posted by Greight (Post 2158135)
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 02-04-2011 08:38 PM

1 Attachment(s)
Quote:

Originally Posted by paul41598 (Post 2157777)
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:
Code:

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

Code:

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 02-04-2011 08:51 PM

Quote:

Originally Posted by bananalive (Post 2158843)
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 02-04-2011 08:55 PM

Quote:

Originally Posted by thunderclap82 (Post 2158853)
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 02-04-2011 09:09 PM

Quote:

Originally Posted by bananalive (Post 2158854)
Does the error come up after you click 'Manage Attachments'?

Yes.

Quote:

Does the user have permission to view forum, the thread is being created within?
Yes, though the forum is hidden.

Quote:

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 02-06-2011 12:21 AM

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 02-06-2011 10:57 AM

Quote:

Originally Posted by thunderclap82 (Post 2158860)
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'$vbulletinERRTYPE_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
      HTML Code:

      newthread_post_complete

bananalive 02-06-2011 11:00 AM

Quote:

Originally Posted by thrace (Post 2159207)
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?

To add user to additional usergroup...

https://vborg.vbsupport.ru/showpost....&postcount=115

zushiba 02-07-2011 04:03 PM

Is it possible to view a single result?

I am creating a widgit in PHP that shows the users submitted forms with an easy "Edit" button but I'm stuck on how to just show them their result as it goes in to a database not a forum.

So I'd like to just show them the resulted form information they entered for that single entry.\

EDIT: Oh I suppose I could just pull the Output field. Though then I need to find a way to show the output of the BBCode from the database in a php widgit.

bananalive 02-08-2011 02:30 PM

Quote:

Originally Posted by zushiba (Post 2159805)
Is it possible to view a single result?

I am creating a widgit in PHP that shows the users submitted forms with an easy "Edit" button but I'm stuck on how to just show them their result as it goes in to a database not a forum.

So I'd like to just show them the resulted form information they entered for that single entry.\

EDIT: Oh I suppose I could just pull the Output field. Though then I need to find a way to show the output of the BBCode from the database in a php widgit.

To parse it, use the following on $output:
PHP Code:

require_once(DIR '/includes/class_bbcode.php');
$bbcode_parser = new vB_BbCodeParser($vbulletinfetch_tag_list(), true); 
$output $bbcode_parser->parse($output); 


bananalive 02-08-2011 02:39 PM

1 Attachment(s)
v4.2.3 Beta

v4.2.3 is the addition of searchable Form Results Table. If you have a go and let me know what you think.

https://vborg.vbsupport.ru/attachmen...1&d=1297183178

zushiba 02-08-2011 02:41 PM

Awesome, bananalive you have no idea how much work this addon is saving me. Thank you!

Upgraded, looks great and the search function works great!

paul41598 02-08-2011 04:06 PM

bananalive: Exporting to excel doesnt work well with some fields it seems. It's not taking my radio button results, nor my multiline results. Are you aware of the issue, or have a fix? Just curious. Thanks for the hard work on this mod. It's one of a kind!

DevinM 02-09-2011 02:15 PM

Any idea what might cause this display/formatting problem? Or how to fix it?

https://vborg.vbsupport.ru/external/2011/02/1.bmp

I havent modified anything, just installed and noticed it was doing that.

bananalive 02-10-2011 12:13 PM

Quote:

Originally Posted by paul41598 (Post 2160235)
bananalive: Exporting to excel doesnt work well with some fields it seems. It's not taking my radio button results, nor my multiline results. Are you aware of the issue, or have a fix? Just curious. Thanks for the hard work on this mod. It's one of a kind!

There was a problem with Grid Questions, I'll release a fix later today. But not with multi-line or radio that i aware of it? If you cannot see all the text - try expanding the cells height and width.

bananalive 02-10-2011 12:18 PM

Quote:

Originally Posted by DevinM (Post 2160569)
Any idea what might cause this display/formatting problem? Or how to fix it?

http://www.gridironjunkies.net/image...rmsproblem.bmp

I havent modified anything, just installed and noticed it was doing that.

It should be copying the styling from other parts of the forum. If you want to manually edit the formatting, edit template form_list_bot

In v4.2.4+ 'Create New Form' it has been changed from a link to a button.

bananalive 02-10-2011 12:26 PM

v4.2.4 (just released in first post) is the non-Beta version of v4.2.3 (with a few bug fixes from the beta version)


All times are GMT. The time now is 10:46 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03087 seconds
  • Memory Usage 1,897KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (1)bbcode_html_printable
  • (8)bbcode_php_printable
  • (27)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete