**Before Making An Add on **
Please consult with me before making an add on to this hack. As it is my work and such, the add ons that you are trying to make for it may be in the next release and/or premium version.
What does this do?
This hack allows you to add more fields to your threads besides just the title and message. This is extremely usefull in order to specify certain things in a thread in a way that people are more aware of it and such. There are several types of fields you can add and several features for the hack.
What features does this hack provide?
Add extra fields to threads. These include:
Text fields
Select Drop Down Fields
Radio Fields
Checkbox Fields
Enhanced extra threadfields manager - Premium Only*new
Search through fields within forums (forumdisplay.php) - Premium Only*new
Search through fields in search.php - Premium Only
Control order in which fields are displayed
Edit thread fields via the "edit thread" page
Edit thread fields via the "edit post" page - Premium Only*new
Set the forums in which you want fields to appear in - Premium Only (light version may set forumid's, but are a tad more limited as to how many)
Show fields automatically in thread
Show fields automatically in forumdisplay
Make a field required - Premium Only
Control what forums the field is shown in
Enable/Disable system
Enable/Disable automatic showing fields in thread
Enable/Disable automatic showing fields in forum
Make the field only editable by staff - Premium Only
Control what usergroups can edit staff-only editable fields - Premium Only
Show extra fields in subscriptions - Premium Only
Show extra fields in forum index - Premium Only
Show extra fields in search results - Premium Only
Control what fields are searchable - Premium Only
Enable/Disable automatic showing fields in forum index - Premium Only
Enable/Disable automatic showing fields in search results - Premium Only
Style how your extra fields appear in threads (using html) directly from your admincp! - Premium Only*new
No template edits required! - Premium Only*new
What does this hack require?
Template Edits: 4
Products Imported: 1
5 Easy Steps Step 1. Import the following product: product-extra_threadfields.xml Step 2. Upload the files in the upload folder. Step 3. Do the edits located below Step 4. Edit the newly added options in admincp as you please Step 5. Enjoy the hack.
F.A.Q Q. How do i get extra fields to show in the "edit post" page? A. This is only available in the premium version.
Q. If i do not want the fields to be shown automatically, can i do it manually? A. You can manually show fields in threads or posts by using $thread[fieldx] in the postbit or showthread template. Replace x with the ID of the field you want. To find the ID of the field go to admincp >> Extra Threadfields >> Extra Fields Manager, and hover over a field. The number after fieldid = will be the id of your field.
Q. I updated all of the options, i installed it perfectly, i did all edits, and still the options are not showing when i go to add a new thread. What do i do? A. It is believed that you have a hack interfering with this one. Take away the edit that you did for putting $extrathreadfields inside the newthread template, and do this instead:
CREATE TABLE IF NOT EXISTS `thread_fields_admin` ( `title` varchar(100) NOT NULL default '', `fieldid` int(10) unsigned NOT NULL auto_increment, `description` varchar(200) NOT NULL default '', `forums` varchar(200) NOT NULL default '', `type` varchar(100) NOT NULL default '', `size` char(3) NOT NULL default '40', `options` varchar(200) NOT NULL default '', `display` varchar(100) NOT NULL default '1', PRIMARY KEY (`fieldid`) ) 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 11 Error Number : 1064 Request Date : Monday, March 30th 2015 @ 09:04:14 AM Error Date : Monday, March 30th 2015 @ 09:04:14 AM Script : http://*******.com/forum/vbadmin/plugin.php?do=productimport Referrer : IP Address : 37.229.165.203 Username : admin Classname : vB_Database_MySQLi MySQL Version : 5.5.31-1~dotdeb.0-log
For those that install this and receive a database error...
Open the product,
Code:
Find:
Type=MyISAM
Change to:
ENGINE=MyISAM
re-upload product
****
Quote:
Originally Posted by Dimoks
I have error after import produnct
PHP Code:
Database error in vBulletin 3.8.6:
Invalid SQL:
CREATE TABLE IF NOT EXISTS `thread_fields_admin` (
`title` varchar(100) NOT NULL default '',
`fieldid` int(10) unsigned NOT NULL auto_increment,
`description` varchar(200) NOT NULL default '',
`forums` varchar(200) NOT NULL default '',
`type` varchar(100) NOT NULL default '',
`size` char(3) NOT NULL default '40',
`options` varchar(200) NOT NULL default '',
`display` varchar(100) NOT NULL default '1',
PRIMARY KEY (`fieldid`)
) 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 11
Error Number : 1064
Request Date : Monday, March 30th 2015 @ 09:04:14 AM
Error Date : Monday, March 30th 2015 @ 09:04:14 AM
Script : http://*******.com/forum/vbadmin/plugin.php?do=productimport
Referrer :
IP Address : 37.229.165.203
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.5.31-1~dotdeb.0-log
Extra Threadfields Lite(Add Text, Radio, Drop Down, & Checkbox Fields To Threads!) Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
04-12-2012, 04:01 PM
