Show Thread Enhancements - Thread Description

Release: for 3.5.x ~ 3.6.x to 3.7.x (*)

. This hack allows your users to add descriptions to their threads that show up on the threadlist.
. More info & option see (Screenshots)

• Code Changed (*)
• Add Field To Edit Post For First Post
• Show Thread Description In Showthread
• Show Thread Description In Search Results
• Add html specialchars uni to description updates to prevent HTML
• Admin CP can Enable/Disable thread descriptions per forum (*)

DL / Unpacking the attachment:

. UpLoad images\strela_w.gif

Installation Instructions:

. Login to Admin CP
. Choose Plugin System
. Choose [Add/Import Product]
. Choose product-thread_description.xml
. Click [ Import ]

Modify templates: ( 6 templates )

. Read My Instructions: readme-thread-description.html (c) (+)

. Import [ XML ] = Done

. Thats all!

. Enjoy!

Note:
I will update my mod "no more edit template" on my next ver.
Good date all!

(*) My New Version Dec12, 2006
(c) Templace(s) - vBulletin ver you may find template changes, but these input code not changes.

[KURTZ]

thx TrucLinh!

already INSTALLED on 3.6.4 and works like a charm

[TrucLinh]

Originally Posted by Neutral Singh

Is it possible to do search in thread description? Thanks for this.

Originally Posted by KURTZ

thx TrucLinh!

already INSTALLED on 3.6.4 and works like a charm

You are welcome.

[farooqaaa]

Thanks alot. This is nice!

[transitbus]

A couple of suggestions:

1. Don't rar the file please, leave it as zip
2. There is no need to upload the XML product file via ftp. You can use the product upload via the admin CP
3. The description on the main thread here is far too confusing, it has too much information that is hard to follow. Can you simplify the process and give upgrade instructions?

Thanks and aside from these little things this is an excellent mod.

[transitbus]

Edit... NM simply had to remove the program and reinstall it and the error went away.

[transitbus]

when installed your mod interferes with unread posts. When uninstalled it break the undread post function by deleting a required table field. This is a dangerous bug and I hope you fix it because now I am having to go and manually fix my forum to fix your bug

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'b2ba47094c3fh227e95e9820abe34e7a' AND orderedids = '491' AND announceids = '' AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Tuesday, December 19th 2006 @ 05:07:48 PM
Script : http://www.shebaliscronies.com/search.php?do=getnew
Referrer : http://www.shebaliscronies.com/
IP Address : xxx.xxx.xxx.xxx
Username : xxx
Classname : vb_database

[transitbus]

Edit:

looks like your mod removes a required field:

http://www.vbulletin.com/forum/bugs3...iew&bugid=1218

If you have done a new install and are getting errors while searching, this column is missing. Please run the following query to add it:

Code:
ALTER TABLE `search` ADD `completed` SMALLINT UNSIGNED NOT NULL DEFAULT '1';

I think if you alter your xml file to not include:

$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "search` ADD `completed` tinyint(1) default NULL");

and:

$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "search` DROP `completed`");

This might work because completed has to have a default of not null to work and you are altering it to change to null as the default. You also can not remove this field

[Paul M]

The uninstall code of this mod is removing a default vbulletin field from the search table - this should be fixed asap and people informed to upgrade (and not to uninstall this product until they have). You should also remove the code in the install section that adds this field - the field should already be present in a 3.6.4 installation.

Edit: This has now been fixed by the author.

[Terminatoronly]

thanks alot working fine for me

[Cybershaolin]

There is also another bug for 3.6.4. When you want to edit a message by using the Edit (modifiy) button and if you decide to go in advance mode, you will get a DB error such as:

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE thread SET description = '' WHERE threadid = '24';

MySQL Error : The table 'vb_364.thread' doesn't exist
Error Number : 1146
Date : Wednesday, December 20th 2006 @ 04:54:03 PM
Script : http://myforum.com/forum/editpost.p...pdatepost&p=87
Referrer : http://myforum.com/forum/editpost.p...post&postid=87
Username : Netsurfer
Classname : vb_database