New Posting Features - [HTL] & [Normal] Thread Descriptions v1.0.1

THIS HACK IS BACK UNDER PRODUCTION
I will be working on getting a new version of this hack out tonight. I will provide support here the best I can. For priority support go here

Thread Descriptions
Version: 1.0.1
vB-version: 3.0.0 Release Candidate 2
Developer: Tim "eXtremeTim" Yarbrough
Install-difficulty: Easy
File-edits: 4
Template-edits: 2
Files modified for this Hack:
root/newthread.php
root/forumdisplay.php
root/includes/functions_newpost.php
Templates modified for this Hack:
newthread
threadbit
DB Tables modified for this Hack:
thread

Updated in v1.0.1:
Fixed html security problems.

What is coming in the next version:
Ability to edit descriptions
Ability to turn descriptions on and offer on a per forum basis and globaly
Ability to turn on showing the descriptions at the top of every page of the thread for reference.
Ability to define the cutoff on the display of it on forumdisplay (recommended only to use this when using the display in thread feature)
Ability to define the cutoff for how many characters can be input into the description box.

This hack was made for eXtremeChatForums.com by Tim "eXtremeTim" Yarbrough

[LOD-squa]

Something I would like to see in this hack would be that you *can* change the thread description from Thread(or however it is called) Tools ----> Edit Thread

[Boofo]

That requires extensive editing of postings.php. It can be done, but only with time and patience.

[LOD-squa]

If someone could do it I would appreciate it.

[setsykid]

:/

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
iconid, visible, attach, threaddesc, similar)
VALUES
('', 1077487797, 39,
1, 0, 'Dx', 2,
'Dx', 1077487797, 0, 1,
0, '', 'yaaaa'

[Boofo]

Originally Posted by setsykid

:/

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
iconid, visible, attach, threaddesc, similar)
VALUES
('', 1077487797, 39,
1, 0, 'Dx', 2,
'Dx', 1077487797, 0, 1,
0, '', 'yaaaa'

Where's the rest of the error message?

[setsykid]

Fix it

[Boofo]

What was it?

[FleaBag]

LOL I was just about to release this myself. Though I did it in two file edits, probably the insecure way.

[Boofo]

I'm going to be releasing a version on my site that has the edits for the postings.php and editpost.php (as soon as I get the install file put together, which is almost done).

[Serge]

Originally Posted by setsykid

:/

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline,
iconid, visible, attach, threaddesc, similar)
VALUES
('', 1077487797, 39,
1, 0, 'Dx', 2,
'Dx', 1077487797, 0, 1,
0, '', 'yaaaa'

In reply to your problem it is because of a missing ) at the end of that line. It seems to be a typo cause I got the same thing using v1.0.1

Originally Posted by eXtremeTim

######
#Find#
######

$totalattachments, '" . addslashes($similarthreads) . "'

##############
#Replace with#
##############

$totalattachments, '" . addslashes($similarthreads) . "', '" . addslashes($post['threaddesc']) . "'

At the end of the replace line there should be a ) so it should be

PHP Code:

$totalattachments, '" . addslashes($similarthreads) . "', '" . addslashes($post['threaddesc']) . "' ) 


Try that to see if it works as that is what I had to do.