Complete Thread Description Hack 1.7

Complete Thread Description

Version: 1.7
vBulletin Version: 3.0.3
Updated and Adapted by: Steven Blum
Install difficulty: Pretty easy

Updates:

Updates in 1.7:

All known issues fixed. If a post error message is encountered in making a new thread, the threaddesc will reappear in the form along with the title and the message.

Updates in 1.6.2:

Adjustments in instructions to clarify and make a couple steps much easier. Also, fixed a problem that would cause threads with both descriptions and ratings to display on 3 lines instead of 2.

Updates in 1.6.1:

soft-deleted threads will now display properly

Updates in 1.6:

Fixed an error that would come up if you tried to edit a thread description and add an apostrophe.
Fixed an error that would make it so announcements didn't span the whole table width.


Description:
This is basically a massively updated and modified version of eXtremeTim's thread description hack located here: https://vborg.vbsupport.ru/showthread.php?t=60697

This hack emulates thread descriptions as seen in IPB, displaying them right below the thread title. Also, an optional step puts thread creator in its own column, basically making it look like most other forums.

Features:

• Users are allowed to leave thread descriptions upon initial posting of a thread
• Users with permission are allowed to edit thread description within the same time limit allowed to edit a thread
• Thread description shows up in Searches as well as Forumdisplay
• Thread description also shows up on the first post of a thread, right next to title
• Added: Forumdisplay like most other forums making thread creator display in a new column - this step is optional and included in another txt file, but strongly recommended (it looks pretty retarded the other way)

Nobody was doing updates or answering questions, so I took matters into my own hands! This is my first officially released vB hack. Everything works perfectly on my forums, but if you have any problems with this let me know.

Note: I've discovered that if you have it set so that people can not edit the thread title after a certain amount of time, they will be unable to edit thread description, which is as intended. However, admins will also not be able to edit the thread title, which is not intended. On my forums I do not use such restrictions so it's not a problem, and I don't have any plans to update this hack accordingly, sorry.

Demo

<removed>

Sorry, no screenshots are available right now, I'm currently at work and have no image manipulating program other than mspaint. You can see it in action at my forum. If you receive any errors or there are any bugs, please let me know and I'll try to get it fixed.

And always, if you like this hack, please click install. Thank you!

Edit: Added the threadstarterinowncolum (like i have on my boards and IPB has) text file... You want to do this before you add thread description. It's pretty easy to do it after, the search just won't work 100% due to an extra line involving threaddesc. I have tested these modifications, and it works 100% fine for me, but back up your templates anyways and report any errors here.

[turbidblue]

worked like a charm! thanks alot! i really appreciate it!

[FleaBag]

Oustanding, this is just what I was looking for.

[wrongful]

I could be wrong here, I don't know much about PHP but in the following edit in search.php

######
 
#Find#
 
######
 
SELECT $previewfield
 
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid,
 
thread.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
 
thread.pollid, thread.open, thread.lastpost AS postdateline,
 
thread.lastpost, thread.lastposter, thread.attach, thread.postusername, thread.forumid,
 
#################
 
#Add right after#
 
#################
 
thread.threaddesc

shouldn't

thread.threaddesc

be

thread.threaddesc,

[wrongful]

Also for some reason when I edit the threads, and change the thread description, it isn't updating. I have checked all of my edits.

[sblum]

Does anyone else have the same problem that wrongful is having? It works 100% for me

[turbidblue]

works 100% here too

[wrongful]

Ok after some testing I came to the following conclusion:

It is only not letting me edit the thread desciptions of threads that are older than 10 minutes, which is the time limit to edit the thread title set in the admincp options. Since I am an admin, this rule shouldn't apply to me. I think that's what the problem is.

[sblum]

I'll check it out wrongful, but that means that there's other conditionals set somewhere while editing a post to check if you're an admin that I don't know about. I'll check it out tomorrow and try to figure it out.

[wrongful]

I have a huge problem. Whenever someone edits a post, and uses and apostrophie, you get a database error:

Database error in vBulletin 3.0.3:
Invalid SQL:
UPDATE thread
SET title = 'gfdsgds', threaddesc = 'gdfgs'', iconid = 0
WHERE threadid = 4110

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 ''gdfgs'', iconid = 0
WHERE threadid = 4110' at line 2
mysql error number: 1064
Date: Friday 20th of August 2004 11:56:02 AM
Script: http://www.wrongfuldistribution.com/forums/editpost.php
Referer: http://www.wrongfuldistribution.com/...itpost&p=34096
Username: Terry Norris
IP Address: 69.1.28.89

[sblum]

Sorry abou that, can't believe I overlooked it. If you've instaleld this hack prior to 8/20, open up editpost.php

Find:

PHP Code:

            $threadupdate[] = "title = '" . addslashes(htmlspecialchars_uni($edit['title'])) . "', threaddesc = '$edit[threaddesc]', iconid = $edit[iconid]"; 


and replace it with:

PHP Code:

            $threadupdate[] = "title = '" . addslashes(htmlspecialchars_uni($edit['title'])) . "', threaddesc = '" . addslashes(htmlspecialchars_uni($edit['threaddesc'])) . "', iconid = $edit[iconid]";