Executing this MySQL query may be also required for latest version. It is broken in archive:

I got it parsed incorrectly in the post :

where it should be :
----------------------------------------
source : some text
related toipc : the hack
----------------------------------------

?!

Hi,

I'd like to add a thread content language list as input field.

The user will have to chose among available languages that I'll have defined.

I'd like to do a multi-language forums site where all languages can reside in the same forums.

A bit like youtube, where you choose a language for your content and then you post it.

If it's not implemented in this plug-in, I think it would be a really interesting improvement.

An easy implementation would be to allow the user to define a list of choices separated by commas in the control panel and add a checkbox for select drop down or box.

And I don't know if it's easy but if you want to go further, your plug-in could also add the custom fields choices as criterias in vBulletin's advanced search feature.

Thanks

Hi!
This is a great mod, but when i install in my vB 3.6.4 i got this error:

Database error in vBulletin 3.6.4:

Invalid SQL:
CREATE TABLE `vB_custom_thread_forms` (
`custom_formid` mediumint(10) unsigned NOT NULL auto_increment,
`forumid` mediumint(10) unsigned NOT NULL default '',
`title` varchar(130) NOT NULL default '',
PRIMARY KEY (`custom_formid`)
);;

MySQL Error : Invalid default value for 'forumid'
Error Number : 1067
Date : Sunday, December 3rd 2006 @ 03:59:01 PM
Script : http://www.------.com/foro/admincp/p...=productimport
Referrer : http://www.----------.com/foro/admin...?do=productadd
IP Address : 24.xxx.xx.34
Username : mauro1947
Classname : vb_database

How can i fix this???
I want this mod on my vB
Thanks a lot!!!

I thought that once the fields was set, it was not possible to come back and edit them...
and you can do that right away...
Meaning it is a nice hack, but useless for me as I want to require a validation from my customers. If they can come back and edit the fields in the thread your hack will not help me...

Anyone has an idea about where I could find some sort of "one way validation system" in a thread ?

ex : are you happy with our answer ? Yes or No.
--- and if it is yes, it stays yes :)

I installed the original hack without any modification and I keep having this :

----------------------------------------
----------------------------------------

in each first posts, including in the forums where the hack is not supposed to be active...

Any help would be appreciated a lot.

Hi!
Anyone can help me with my problem (a few post ago)??
Please, i need your help!
Thanks!!!!!! a lot!!!!

Can I move the filed to the message box same as bleow image

https://vborg.vbsupport.ru/

Hi!
I really need this mod, but it can't works on vBulletin 3.6.4.
When i try to install i received this message:

Database error in vBulletin 3.6.4:

Invalid SQL:
CREATE TABLE `vB_custom_thread_forms` (
`custom_formid` mediumint(10) unsigned NOT NULL auto_increment,
`forumid` mediumint(10) unsigned NOT NULL default '',
`title` varchar(130) NOT NULL default '',
PRIMARY KEY (`custom_formid`)
);;

MySQL Error : Invalid default value for 'forumid'
Error Number : 1067
Date : Sunday, December 3rd 2006 @ 03:59:01 PM
Script : http://www.------.com/foro/admincp/p...=productimport
Referrer : http://www.----------.com/foro/admin...?do=productadd
IP Address : 24.xxx.xx.34
Username : mauro1947
Classname : vb_database

Have you any solution???
Thanks a lot
Bye!

Hi all, i am having the display of the custom fields working fine when i post from a PC. however, when i tried doing it on a Mac, it doesn't seem to be reading the <br /> tags and ends up being like this:

<br /><br />
----------------------------------------<br />
value 1 value 2 value 3
----------------------------------------<br />

I understand in the previous posts that this is due to the xhtml tags not being read. I have tried the solution given but that makes me post from pc messed up, so any suggestion to make it owkr on a mac and pc?

Any chance to have an answer ?

https://vborg.vbsupport.ru/external/2010/06/10.gif
Right.

I have uploaded all files and imported product. Works good up until I try to submit the thread at which time it tells me to go back and fill out all reqiured custom fields. I have tried to make them not required but says same thing. I am using vb 3.6.4.
Thanks for hack

I am having this same problem but on ALL threads..

Nice hack thanks alot.

I can't get it to run...copied the 2 files (custom_thread_fields.php and cpnav_custom_thread_fields.xml) to appropriate spots, opened ACP and selected Browse...selected product-custom_thread_forms.xml (off my hard drive correct since browsing?), and keep getting a database error. Any suggestions? Thanks

here's the actual error:

Invalid SQL:
CREATE TABLE `custom_thread_forms` (
`custom_formid` mediumint(10) unsigned NOT NULL auto_increment,
`forumid` mediumint(10) unsigned NOT NULL default '',
`title` varchar(130) NOT NULL default '',
PRIMARY KEY (`custom_formid`)
);;

MySQL Error : Invalid default value for 'forumid'
Error Number : 1067

Further to the last post, I'm also running vbPortal...not sure if that would affect the installation but I've tried it again and continue to get hte same database error message.

Thanks for any help!

*clicks install

not sure what that means? there an attachment/link in your post?

Thanks

thanks a lot buddy........
installing it right now...

reposting earlier message b/c I don't have a clue what the last 2 messages have to do with my question (yes, it's true - I don't have a clue...):

I can't get it to run...copied the 2 files (custom_thread_fields.php and cpnav_custom_thread_fields.xml) to appropriate spots, opened ACP and selected Browse...selected product-custom_thread_forms.xml (off my hard drive correct since browsing?), and keep getting a database error. Any suggestions? Thanks

here's the actual error:

Invalid SQL:
CREATE TABLE `custom_thread_forms` (
`custom_formid` mediumint(10) unsigned NOT NULL auto_increment,
`forumid` mediumint(10) unsigned NOT NULL default '',
`title` varchar(130) NOT NULL default '',
PRIMARY KEY (`custom_formid`)
);;

MySQL Error : Invalid default value for 'forumid'
Error Number : 1067

Further to the last post, I'm also running vbPortal...not sure if that would affect the installation but I've tried it again and continue to get hte same database error message.

Thanks for any help!

I don't know if the previous two folks were having the same issue as me, but after install I had no options until I edited in Vbull Options.

You have to then go to your VBulletin Options. Scroll all the way down in the list and it will be there. You can edit the options available at that time. It's working for me in 3.6.5

But that's just my experience, anyhow.

I dont need it, so i wont use it. But it a very good idea.

The create table in the product file is bad: wants to be I would think.

instead of:
maybe more a mysql 5 requirement so those on mysql 4 wont suffer the error DSdad suffered ?

this isnt showing the fields when i try to post a new thread

is it possible to make an option to choose from input to textarea ? thx in advance

also it does not show the boxes on edit.

getting this error in a forum where i dont want the custom fields to show up.

my members cant post.

I have fixed a few things.

When a field is required it won't give you an error even though you have typed in it.
The fieldset along with the field(s) will only appear on forums that are supposed to have them.
I properly clean the data from the custom fields.

Great mod.

Mine works.. however I do have a question. Although I've setup some fields to display in certain forums, and that is working well.. in other forums where I have set no fields at all, i still get the "custom fields" box which is blank. It shows up on all forums, simply putting fields into it where they exist.

is there anyway to make it disappear in the other forums that aren't using it?

They shouldn't show up on forums that have no fields.
I'll look into it more.

You don't need to do the template edit in the Install_Instructions.txt

I have added more features.

You can create custom fields for your thread using..

• Single-Line Input Box
• Radio Buttons
• Drop Down Selection Box
• Text Area

I have updated the screenshots to reflect the changes

im sorry but this isnt working for me. i installed everything right and added custom fields, but they arent showing

Did you go to vBulletin Options --> Custom Thread Fields Settings and make sure both are set to 'Yes'?

Just 'discovered' this mod and it's simply brilliant...

PS: I'm using it for new user to intoduce themselfs in a specific thread, by 'forcing' them to fill out some required fields...

Truely a very usefull mod and it works like a charm on 3.6.4

I also swicthed it to a category and it still didn't show.

Can you search by the Custom Fields?

For example, I will have checkboxes or dropdowns for 'City" and I would like my users to be able to search for all posts in a particular city. Is that possible?

Great mod BTW, exactly what I need.

lol i feel so embarrased :p

Another question: can you have the values of some or all of the custom fields show up in "forumdisplay" so users might be able to more easily tell if they want to click?

Or better yet, how does it work on this site (vBulletin.org), when you're searching for mods and there's that row of dropdowns at the top and the "Show Mods" button?

Here's an example: https://vborg.vbsupport.ru/forumdisplay.php?f=194

Just installed this mod.
Working great so far.

But how can I change the size of the "Text Area"?

No. It's not possible. I add the data from the custom fields to the message before it goes to the database. I didn't want to create another table.