Adding custom fields to threads

[DSdad]

I need someone to help me add custom fields to each of the threads in my vBulletin. Specifically, for each thread, I'd like the thread to have separate fields for: address, city, state, zip, phone, and GPS coordinates. Thus, when a person starts a thread, it'll have a title (which I need renamed to "Name"), and will also have the above referenced fields available as optional fields to fill in

I need the customization done fairly quickly if anyone is interested (might be willing to pay a little $$ as well :D ).

Thanks.

[Zachariah]

Thread Prefixes
https://vborg.vbsupport.ru/showthread.php?t=123033

[DSdad]

Could I set up multiple prefixes to allow me to have the 1) address, 2) city, 3) state, 4) zip, etc fields?

Thanks

[Zachariah]

Brief Description of the Modification

This modification allows your users to choose a thread prefix for each thread. To do this you are able to select an appropriate prefix from a list beside the title while posting a new thread - for example 'Help', 'Problem', 'Search' etc.



Scrns
https://vborg.vbsupport.ru/attachment.php?attachmentid=51553&d=1154712410
https://vborg.vbsupport.ru/attachment.php?attachmentid=51554&d=1154712421

[DSdad]

I understand - what I need though is to be able to specify 5 "prefix" fields for each thread, then move the prefixes to the left of the thread field. Does that make sense...I'm new here so not very fluent in how vB works.

[paul41598]

you might want something like this:
https://vborg.vbsupport.ru/showthread.php?t=128587&highlight=custom+thread

should be right up your alley. Also on the 3rd page or so of that thread, I thought I released a modified version of that hack, so whatever u typed into the thread custom fields could be appended to the thread title.

Read up alot on that thread, should work for ya

[DSdad]

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!