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)

HM666 08-15-2017 03:56 PM

Quote:

Originally Posted by bananalive (Post 2179733)
Possibly in future it will be added.

To create calendar events you would have to use vbulletin calendar datamanager and easy form hooks.

Can anyone explain how to do this? I would like to use the forms to automatically create an event in the calendar, but there seems to be no other info on this.

hparsons 08-28-2017 02:31 PM

Is it possible to limit the entry length of a form entry field? For instance, can I limit a multi-line text box that is 60 columns by 10 lines that a person cannot enter more than those 600 characters?

barnsi 10-18-2017 08:57 AM

Form Output Styling is no longer functional...

Example:
PHP Code:

[SIZE=4][COLOR=#0000ff][B]PLP - {q_119}[/B][/COLOR][/SIZE]

[SIZE=4][COLOR=#00eeff][B]{qn_122}[/B][/COLOR][/SIZE][INDENT][SIZE=1][COLOR=#848484] Zahlen, Daten, Fakten...
Leitfragen:
Wie genau aeussert sich das Problem
Wie wirkt sich der Fehler aus?
[/
COLOR][/SIZE][/INDENT

there are only blanks for {q_*}...

scottkoz20 10-18-2017 08:58 PM

use {qo_###}

barnsi 10-19-2017 08:46 AM

Sorry folks.
Everything is fine now. Version 4.04 is fully working with vB4.2.5 and PHP7.
For thread-title it is:
Quote:

For {q_*} replace the question id with the *, e.g. to show question 1's output you would use {q_1}
I exported and imported forms while testing and everytime creating a new form the form-IDs are changing! :p

IggyP 10-24-2017 11:56 PM

ok heres a fun challenge but i think i need a help in it...

to start i wrapped if conditionals around the new thread buttons to hide them for the forum using the easyforms....then as blind-eddie suggested i added back my own button to force topic starting thru the forms, again with if conditionals....perfectly, good stuff ;P

then heres the fun part.....ok so there is a form#2 which is meant to be posted inside the topic started by form #1....ive coded that perfectly as well....however! i want to ADD a button by "post reply" to give an option to reply by "form in thread" or a normal reply....

simple enough right?
Quote:

<vb:if condition="$threadid == 201365701"><a href="https://www.mysite.com/forums/forms.php?do=form&fid=9" rel="nofollow" class="newcontent_textcontrol" id="formreplylink_bottom"><span><i class="material-icons">&#xE0D8;</i></span>REPLY WITH FORM</a></vb:if>
haha well it works but that is no solution.....

what i need is......

1.if conditional for the button to only display for the topic author
2.and for button to only show in the threads of that forum....rather than how i manually entered the threadid in the above example....(i tried using forumid instead, like the thread starting buttons, but it didnt work for this)

thats easy for you alien brain coders? :D

thanks

bananalive 12-22-2017 03:14 PM

Quote:

Originally Posted by barnsi (Post 2590518)
Sorry folks.
Everything is fine now. Version 4.04 is fully working with vB4.2.5 and PHP7.
For thread-title it is:

I exported and imported forms while testing and everytime creating a new form the form-IDs are changing! :p

Try giving the questions "Reference Name" and then that will stay the same after you re-import.

HM666 12-23-2017 01:24 AM

Having an issue for no apparent reason on this now. I have several forms and they all submit just fine but if I try to submit something using a form I created that has a special character like an umlat from the German language the form will not submit and I get the following message:

Quote:

Form failed to submit. The following error(s) occured:
The message you have entered is too short. Please lengthen your message to at least 1 characters.
EDIT: Scratch that... It happens whenever I change a question in the form or change any info in the question. Anyone?

HM666 01-04-2018 12:22 AM

Anyone have any idea how to fix this?

BlackxRam 03-02-2018 06:12 AM

When this form posts to a new thread in a forum how does the layout of the form look? Just curious before I give it a try. I didn't see any customizing page layout options in the description.

HM666 03-02-2018 10:04 AM

Quote:

Originally Posted by BlackxRam (Post 2593220)
When this form posts to a new thread in a forum how does the layout of the form look? Just curious before I give it a try. I didn't see any customizing page layout options in the description.

You can actually customize how it looks in the "Form Output Styling" tab when you edit the form. You do not have to keep the default styling there, you can create whatever you want.

Redlabelgaming 03-25-2018 05:48 PM

Is it already getting updated to 5.4.0???
Im trying to use this version on vbulletin 5 but ill get errors if I want to set usergroup permissions on ithttps://gyazo.com/55161df293111a8458976645794be55c

MarkFL 03-25-2018 06:18 PM

Quote:

Originally Posted by Redlabelgaming (Post 2593736)
Is it already getting updated to 5.4.0???
Im trying to use this version on vbulletin 5 but ill get errors if I want to set usergroup permissions on ithttps://vborg.vbsupport.ru/external/2018/03/4.jpg

This product is intended for use with vB 4.x...it's not going to work with vB 5.x.

wawro 10-17-2018 10:38 AM

Hi
vBulletin 4.2.3 Patch Level 2

While user is entering to the form get message Could not find phrase ''.. and page is displayed
Form after fill is saved.
Where is problem ?

Thanks for help

MGO_TOM 11-25-2018 01:56 PM

I am having a problem for the past few weeks.

iOS users report that when filling out the form, the new thread submission results in an error message “Please complete both the subject and message fields”. When clicking back, the "Title" (single line text field) shows what they entered, but the form keeps getting rejected.

I did some testing and narrowed the issue down to use of the " character. For instance, if 20" is entered in the Title field (thread subject), the form gets rejected with the above error message. However, if I replace 20" with 20in, 20 in, 20 inch, etc, the form goes though fine and a new thread is created, as normal.

Any ideas?

macgyvers 12-03-2018 11:29 AM

User still able to create new thread bypassing the form by doing /newthread.php?do=newthread&f=x

How to prevent this?

MGO_TOM 12-03-2018 11:45 AM

Quote:

Originally Posted by macgyvers (Post 2597613)
User still able to create new thread bypassing the form by doing /newthread.php?do=newthread&f=x

How to prevent this?

There are 3 ways to create a new thread. Did you modify all 3 to use the form vs the standard new thread path?

macgyvers 12-04-2018 08:13 AM

Quote:

Originally Posted by MGO_TOM (Post 2597616)
There are 3 ways to create a new thread. Did you modify all 3 to use the form vs the standard new thread path?

MGO_TOM can you enlighten me with those 3 ways and how to modify them?
Maybe a link I can read further? thanks

MGO_TOM 12-04-2018 11:12 AM

Quote:

Originally Posted by macgyvers (Post 2597632)
MGO_TOM can you enlighten me with those 3 ways and how to modify them?
Maybe a link I can read further? thanks

There is a "New Thread" button at the top of the forum thread list.
There is a "New Thread" button at the bottom of the forum thread list.
There is a "New Thread" link in the "Forum Tools" drop-down.

It has been years since I modified the standard code to create a new thread in select forums by directing the new thread buttons/links to the appropriate form for that forum, so I'd have to do some legwork to find it again. I'm pretty sure it is discussed earlier in this thread.

When i first made the changes to use a form vs the standard thread composition of vBulletin, I overlooked the drop-down "New Thread" link and had a very small number of users that were posting via the standard interface vs the form. I had to do some investigation to figure-out that they were using the drop-down means vs either of the two "New Thread" buttons.

snakes1100 12-26-2018 10:19 PM

Seems to be an issue again with a sql error, when adding a new question, vb 4.2.5

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', '1', 'Date of Event', 'The month & day(s) of your event', '', '1', '0', '0', '0', '255', '', '', '', '40', '0', '5', '', '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

IggyP 12-27-2018 01:23 AM

did anyone try this with php7.2? i need to test soon, im a little nervous for this one...

shka 12-27-2018 06:00 AM

@snakes1100:

It is not a vB4.2.5 issue. "rows" is a reserved word since MariaDB 10.2.4.

Quick and dirty you can change the sql which is using "rows" to "[rows]" (using square brackets for the field name(s)).
Update Upps, you probably have to use mysql-like backticks.

Better way somebody would change the mod (alter column name in for example rowcount and search and replace every occurrence in codes and templates)

elikkha 02-11-2019 04:25 PM

Quote:

Originally Posted by shka (Post 2597938)
@snakes1100:

It is not a vB4.2.5 issue. "rows" is a reserved word since MariaDB 10.2.4.

Quick and dirty you can change the sql which is using "rows" to "[rows]" (using square brackets for the field name(s)).
Update Upps, you probably have to use mysql-like backticks.

Better way somebody would change the mod (alter column name in for example rowcount and search and replace every occurrence in codes and templates)


Hi all

Is there any chance to have a soluce for this plz ?

edgeless 09-22-2019 07:27 PM

Is there a way to put a link to the thread that's auto created into the forum results?

djbaxter 09-22-2019 07:43 PM

Quote:

Originally Posted by edgeless (Post 2600739)
Is there a way to put a link to the thread that's auto created into the forum results?

I don't understand your question. What are you trying to do?

edgeless 09-22-2019 08:11 PM

Quote:

Originally Posted by djbaxter (Post 2600740)
I don't understand your question. What are you trying to do?

Upon form submission, I have it set to create a thread. I would like to have a clickable link to that thread auto inserted into the form results (table and results list). Is this possible?

djbaxter 09-22-2019 09:14 PM

That should happen automatically when a new thread is created.

edgeless 09-22-2019 09:45 PM

Quote:

Originally Posted by djbaxter (Post 2600742)
That should happen automatically when a new thread is created.

It doesn't for me. The new thread is successfully created with the correct information from the submitted form. But the only link that appears in the form results is the username link. It would be great if there were a way to also have a link to the created thread inserted into the form results record as well.

djbaxter 09-22-2019 10:26 PM

Oh I see. No it won't be created in the form. It will be created in the forum though, so visible in the new posts results.

edgeless 09-23-2019 12:17 AM

Quote:

Originally Posted by djbaxter (Post 2600744)
Oh I see. No it won't be created in the form. It will be created in the forum though, so visible in the new posts results.

Yes, it does that just fine. For my purpose, though, we have users that we'd prefer use the form results table as a tracking index (of sorts) to allow them to see the information from multiple recent submissions all together. If there were links to each associated thread within each results row, it would be quite handy for quickly clicking into an ensuing thread dialog. My guess is that one problem in achieving that functionality is that the threads are automatically created after the submitted data is saved... so there may have to be a script called that could modify the saved data after the thread creation stage. Conclusion: not such an easy thing to make happen :(

PPhysX 03-09-2020 11:00 AM

Code:

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 03-09-2020 12:55 PM

Updated your DB server?

Quote:

Originally Posted by PPhysX (Post 2602282)
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 03-09-2020 01:06 PM

Quote:

Originally Posted by shka (Post 2602285)
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:

Code:

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 03-10-2020 06:47 PM

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

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

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 03-11-2020 08:20 AM

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

N0FeaR 10-30-2023 12:38 PM

Is there any plugin like this for vbulletin 5 ?

wolfe 11-12-2023 07:56 PM

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


All times are GMT. The time now is 02:39 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.07734 seconds
  • Memory Usage 1,874KB
  • 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
  • (4)bbcode_code_printable
  • (7)bbcode_php_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (37)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