[HOW TO] Add custom fields to new threads

[jaybolt]

Ok - this is my first submitted 'how to' and is the result of me wanting to add a couple of new fields to my new threads. A quick search on here showed me a couple of people asking the same but no conclusive answers (there were a couple of threads with 'typos') so here is my code as is. It works for me anyway!

1. To add the fields to the thread table in the database:

Go into admincp and down to the bottom. Select Execute SQL Query and then add your fields as follows:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Where table is the name of your vb thread table (eg vb_thread) and var is the name of the field you are adding.

2. Add the fields to the newthread template in admincp / style manager

Find

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

and above that add:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Again, var is the name of the field and the same as in the previous SQL Query. You can smarten this up further using the fieldset tags and creating a custom vbphrase for the $vbphrase[your_phrase] part :



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



3. Go to admincp / add new plug in and add the following three plugins (give them the same name so you recognise them later):

newpost_process



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



newthread_post_start



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



threadfpdata_start



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Once again, var is the name of the variable you have been using for your field name above.

I hope this helps - took me a while to get it sorted (and I did find help on here along the way) but this is the completed process.

[EDITED: corrected an inevitable type in the SQL query :) ]

[ibuddy]

can you give me a screen shot of your edit plugin screen

[delaen1]

How do you access it once it's in there?

[dfe]

Is it possible to do this, but then to only have it appear in a single forum, with subforums?

[TMS_Hon]

i used the hack, but the data is not getting inserted into the db... has anyone used this successfully... help
kamal

[sonichero]

Is it possible to do this, but then to only have it appear in a single forum, with subforums?

Per style only. So, copy your style, put as default for that forum and only make the template edits there.

Thanks BTW.

[SoftDux]

Where can I see this in action?

Where can I see this in action?

[patrickb]

Could this also be used to add custom fields to forums?

Thanks

[FatalBreeze]

that's a great article!
But if i want to edit my newthread? and then change the value of 'var', how do i do it?

[wolfe]

great article but its not inserting any data into the database using vb3.6.8 ? any ideas.

[Lionel]

that's a great article!
But if i want to edit my newthread? and then change the value of 'var', how do i do it?

I'd like to know that also..

solution is in threadadmin_update ....

[brandondrury]

great article but its not inserting any data into the database using vb3.6.8 ? any ideas.

Same here.

Brandon

[fly]

Shouldn't you be using 'set' rather than 'setr'? I remember Andreas telling me not to use setr, as it bypasses some vB checks. I'm no genius at the stuff, so please excuse me if I'm wrong.

[Jelmertjee]

it's working fine for me (tested on clean 3.6.8 pl2 install) although you need to do more edits to actually show the $var in the thread, it does get inserted into the database for sure. If it's not working make sure you have used the right table name.. and the same $var everywhere.. Thanks for the article jaybolt.

so, how would you use it in a thread?

change a query in showthread.php and select the var, then put the $var into your showthread template wherever you want it.

[Lionel]

I did not have to do any additional edits on 3.68 patch level 2

[Jelmertjee]

so do you mean the "$var" was automatically added to the thread, without any edits, I guess you would need to change the template at least, and thought you would need to do more programming?!

So did anyone manage to implement this with the ability to edit threads as well? besides just creating them, like this is not very useful, often you just want to make some changes if you spot a mistake somewhere.. at least I do.

[wolfe]

how do i make it so i can edit the fields and update them because currently its updating blank fields

[Lott]

I'm also having difficulties inserting any data into the database using vb3.6.8.

Is there a specific "Hook_Location" that should be used for the plugins. I've tried "admin_index_main1", which was the default and "threaddata_postsave" - neither of which work.

Thanks for your help.

[Opserty]

Is there a specific "Hook_Location" that should be used for the plugins.Did you try the words given in bold above the piece of code?...

(in the original post.)

[Lott]

Did you try the words given in bold above the piece of code?...

(in the original post.)

Oops! - no I used these as the names of the plugin!
It seems obvious when you know how!

I used the bold words now and it works.

Thanks

[sstalder]

If I wanted to make my field editable via edit post do you know what changes need to be made?

[sstalder]

I figured out my question, if someone wants help pm me.

[thebigman87]

I trying to make this work on Vbulletin 3.7.0 and to a degree it's working.

It will Store the new field entry in MySQL, however I am having trouble in the process I need to perform in order to display it in either Threadbit or Postbit. I believe I need to edit forumdisplay and/or showthread in order to this. Can anyone help me on this? I just don't know where to start. Any Help what so ever will be very appreciated.

[Medtech]

would be nice to make a modification out of this that can be installed with chief post.;)

[Twilkey]

FYI, This works on 3.8

[0lly]

Great guide, I have it working fine :)

But, can anyone help me edit it so that the fields can be edited once they have been entered and submitted? Thanks.