Thread Description

[derekivey]

Thread Description
Developers: derekivey (https://vborg.vbsupport.ru/member.php?u=81169)
Version: 1.0.0
vBulletin Version: 3.5.4
File Edits: 0
Template Edits: 6
New Phrases: 1
Uses Plugins: Yes
Difficulty: Easy

Description: This hack adds the ability for users to add a description for their thread.

*** I Strongly Recommend That You Backup Before Installing/Upgrading This Hack! ***

Planned features for a later release:

Add AJAX Description Edit [ Flagged for a later release ]
Show Thread Description In Archive [ Flagged for a later release ]
Whatever is suggested.Features Added To 1.0.0

Changed Install and Uninstall Code
Show Thread Description In showthread
Show Thread Description In Search Results
Add Field To Edit Post For First Post
Add htmlspecialchars_uni to description updates to prevent HTMLI have added screen shots of this hack in action below.

Please click https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=116410) If you installed this hack.

If you would like to make a donation, you may send it to me through PayPal.
https://vborg.vbsupport.ru/external/2013/04/2.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=derek%40nbsdesignz%2ecom&item_name=vBulletin%20Hack%20Donation&no_shipping=1&cn=Optional%20Message&tax=0&currency_code=USD&bn=PP%2dDonationsBF&charset=UTF%2d8)

Thanks!

[akanevsky]

Nice hack, seems to be much better than the one already released. Nicely styled code and installer readme, too. Good job.

I haven't checked whether this actually works yet, but by reading the code I can't see why this is in beta stage.

[Living in music]

Great work, I love you ! ;)

[Kaleem]

lets check it out :) will click install after seeing whts goin on :)

[derekivey]

Thanks guys. Glad you like it :).

Derek

[derekivey]

I haven't checked whether this actually works yet, but by reading the code I can't see why this is in beta stage.

I decided to leave it in beta for a few days just to make sure there aren't any bugs. If there are I will fix them and take it out of beta.

Derek

[DJ XtAzY]

awesome i think this version is better than the other version. This hack requries no file edits!!!!

[derekivey]

Yup it just uses plugins :)

[Boofo]

Does this work in the editpost too? ;)

[Valter]

It works fine in the editpost.

-It doesn't show description in search results.
-It would be great if you can make that thread starter is shown in separate column in forumdisplay. With description title/starter field is much heighter.

Nice work.

[shadowevil]

Nice hack ... great work >:D<

[rmxs]

Nice hack and work GREATE....

Suggestion...Ajax EDIT ON description LIKE TITLES EDIT :)

[projectego]

Awesome hack! Thanks very much for sharing. ;)

[derekivey]

It works fine in the editpost.

-It doesn't show description in search results.
-It would be great if you can make that thread starter is shown in separate column in forumdisplay. With description title/starter field is much heighter.

Nice work.

I'll see if I can add it to the search as well but not making any guarantees because I have never worked with vB's search engine before so I'm not exactly sure how I would add it. I will take a look tonight to see if I can figure it out. Also for the thread author in a new column, you can do that in the templates manager if you want to, but I don't feel that it needs to be done for this because the max limit for the descriptions is 100 characters so it should only be one extra line per threadbit.

Nice hack and work GREATE....

Suggestion...Ajax EDIT ON description LIKE TITLES EDIT :)

I like that. I'll try adding it also.

[Snake]

Thanks for your release but how about a screenshot? :p

[akanevsky]

There's a screenshot inside the archive, although yeah - screens should be attached separately.

[utw-Mephisto]

I am not using it, but there you go :

[akanevsky]

I have installed and checked this hack, works perfectly.

Except for your install/uninstall code, which should be replaced by this:

$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` ADD `description` VARCHAR( 100 ) NOT NULL");
$db->show_errors();

$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `description`");
$db->show_errors();

Note:
1. No semicolon at the end of query. That sometimes causes errors.
2. query replaced with query_write
3. No reason to create an array for only one query.
4. hide_errors and show_errors to avoid unnecessary error display.

After that, "Beta Stage" marker can be safely removed! :)

Couple of suggestions:

1. Show threaddescription is showthread and archive.
2. Show threaddescription in search results, for both thread mode and post mode.
3. Add ajax description edit in threadbit.
4. Add the field to editpost when editing first post in advanced mode.
5. "description of" is a grammatical error in the context. Should be "description for".

Cheers!

[Allan]

Screens please ^^

[akanevsky]

There are screens in the post above mine.

[TCB]

Thanks, it looks nice.... but I agree with one of the earlier posters, that it looks a bit messy with 3 rows (title/subtitle/poster) in various fonts. I prefer the Invisionboard style (adding an extra column with the topicstarter)

[derekivey]

Sorry about that. I forgot to upload them. They have now been attached.

Derek

[derekivey]

I have installed and checked this hack, works perfectly.

Except for your install/uninstall code, which should be replaced by this:

$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` ADD `description` VARCHAR( 100 ) NOT NULL");
$db->show_errors();

$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "thread` DROP `description`");
$db->show_errors();

Note:
1. No semicolon at the end of query. That sometimes causes errors.
2. query replaced with query_write
3. No reason to create an array for only one query.
4. hide_errors and show_errors to avoid unnecessary error display.

After that, "Beta Stage" marker can be safely removed! :)

Couple of suggestions:

1. Show threaddescription is showthread and archive.
2. Show threaddescription in search results, for both thread mode and post mode.
3. Add ajax description edit in threadbit.
4. Add the field to editpost when editing first post in advanced mode.
5. "description of" is a grammatical error in the context. Should be "description for".

Cheers!
Thanks for the suggestions. I will try to do those tonight if I can and release a new version and take it out of beta :).

Derek

[derekivey]

I'm not sure how to add the Ajax thing because vB has it so when you click twice anywhere in the threadbit it automatically edits the title. Any suggestions?

[derekivey]

From the looks of it, it looks like I would have to add a file edit for the description to show in the search results because right after the hook call is $thread_select_logic = array();. I somehow would need to add $thread_select_logic[] = "thread.description"; Any ideas on how to add this when the array() is called after the hook call?

Thanks,
Derek

[derekivey]

Nevermind I got it. It's coming along nicely now :).

Derek

[FreshFroot]

Nice work Derek :) I can't wait too see the newest updated hack. Again nice work mate. :)

[jaks]

I think this should have been in VB default install already. Awesome!!! Can't wait til it's done.

:D
Jaks

[rmxs]

I'm not sure how to add the Ajax thing because vB has it so when you click twice anywhere in the threadbit it automatically edits the title. Any suggestions?
Yes everywere if you click the title can be edited..
you cannot split this row?half part klik edit tiltes and the other half the description..

[fly]

This is awesome. I'll be trying this tonite.

[Hemanth]

Thanks a lot. It's working fine. Just installed :)

[Snake]

Thank you for the fix, I shall install this right away! :)

[derekivey]

Thanks a lot. It's working fine. Just installed :)

Please click install. Thanks! :)

[Snake]

derek, here's a silly question. How do I remove the italic effect for all thread descriptions?

[derekivey]

In threadbit, find:

<em>$thread[description]</em>

Replace with:

$thread[description]

Derek

[FreshFroot]

the updated version is posted? looks the same one from before.........

[derekivey]

No not yet, it just says Updated because I attached the ScreenShots. The new version will be out in a few hours, but I'm not sure if I'll have the AJAX Quick Edit in the new version, it might take some time to code.

Derek

[derekivey]

Where in showthread do you guys think I should put the thread description? I can't put it in the navbits because it would require a file edit and I don't want that. Where would be a good spot for it?

Thanks,
Derek

[akanevsky]

Where in showthread do you guys think I should put the thread description? I can't put it in the navbits because it would require a file edit and I don't want that. Where would be a good spot for it?

Thanks,
Derek

Put it under forum description as you can see it a in default vB. In other words, just above the first post :)

[derekivey]

Ok thanks, I'll put it there.

Derek

[derekivey]

Psionic Vision, you mean like this?

[akanevsky]

Somewhat, except you should replace "Description" with "Thread Description" :)

[derekivey]

Ok lol

[FreshFroot]

looking good so far :D

[derekivey]

Ok, Version 1.0.0 has been released! :). Please see the first post for what has changed, and there are install and upgrade instructions in the readme file.

Derek

[Living in music]

Very cool, i'll update now! Thanks to derekivey :D

[rmxs]

I just update ITS FANTASTIC...and if tou make it with ajax......SUPER FANTASTIC :) lol

Thanks

[derekivey]

I just update ITS FANTASTIC...and if tou make it with ajax......SUPER FANTASTIC :) lol

Thanks

Yup, I am shooting for that for the next release.

Derek

[Valter]

Nice updates in 1.0, thanks!

[Snake]

Thanks for the update.

[liwo]

You get a database error if you have a table prefix for your Board (or at least we got one):
Invalid SQL:
UPDATE thread SET description = '' WHERE threadid = '9';

MySQL-Fehler : Table 'xxx.thread' doesn't exist

I fixed this by changing the line in the product xml file
$db->query_write("UPDATE thread SET description = '" . $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" . $db->escape_string($threadinfo['threadid']) . "'");

to

$db->query_write("UPDATE " . TABLE_PREFIX . "thread SET description = '" . $db->escape_string(htmlspecialchars_uni($edit['description'])) . "' WHERE threadid = '" . $db->escape_string($threadinfo['threadid']) . "'");

Thanks for that great hack!

[derekivey]

Thanks for reporting that. I will update the zip file to include the fix. I guess I must have forgot to add TABLE_PREFIX to that one. Thanks again!

Derek

[CP,]

Hi how can i make the thread description, in non italic please? thanks!

[derekivey]

Hello CP,

Please see this post (https://vborg.vbsupport.ru/showpost.php?p=987299&postcount=35)

Thanks,
Derek

[Snake]

derekivey, I am trying to display the thread description right next to the thread title in postbit? Can you help?

[derekivey]

Where? Can you upload a screenshot please of where you want it?

Thanks!

[Snake]

Nevermind. I have figured it out already. Thanks anyway...

[derekivey]

Ok, mind posting it here so that anyone else who wants to do it can do it to their forum?

Derek

[Terminatoronly]

thanks alot it works with me and it also work with vb3.6 rc2 i have tried it there thanks alot

[I||usi0nz]

this is what I neededd, thankss :)

[derekivey]

thanks alot it works with me and it also work with vb3.6 rc2 i have tried it there thanks alot
Thanks for confirming that it works on RC 2 :).

this is what I neededd, thankss :)
No Problem :).

Just to let everyone know, as soon as I get some time I am going to be adding the ajax edit description feature, like vB's edit thread title feature. I just haven't had time to do it. I should hopefully get some time later this week.

Derek

[DPSR]

Working fine on v3.6.0 :)

Thanks for the hack derekivey

*installed

[wtricks]

It should be the default in any VB install.

Installed ... nice :D

[derekivey]

Thanks :).

[Megareus Rex]

Question: Is there a way to upgrade from the other thread description hack to this one? In other words, to keep the existing description tables and such so that all the current descriptions remain, and they won't need to be redone?

If this is already the case, then that's fine, but if not, any way you could provide such an option?

PS: Also, does this display in search.php? I saw earlier users wondered, but I didn't see if it was taken care of when skimming the thread for info on switching to this description hack from the other one.

[derekivey]

Question: Is there a way to upgrade from the other thread description hack to this one? In other words, to keep the existing description tables and such so that all the current descriptions remain, and they won't need to be redone?

If this is already the case, then that's fine, but if not, any way you could provide such an option?

PS: Also, does this display in search.php? I saw earlier users wondered, but I didn't see if it was taken care of when skimming the thread for info on switching to this description hack from the other one.
I'll have to see how the other hack stores them in the database, I might be able to make a converter for it, I'll have to see, and get back to you.

Yes, the descriptions are also shown on the search results :).

Derek

[derekivey]

Ok, attached is a converter I made. Just upload it to the admincp folder and go to http://www.yourdomain.com/path_to_forums/admincp/thread_description_converter.php, and run it. Once it has finished, delete that file from your site. Let me know if you have any problems with it.

Thanks,
Derek

[Megareus Rex]

Ok, attached is a converter I made. Just upload it to the admincp folder and go to http://www.yourdomain.com/path_to_forums/admincp/thread_description_converter.php, and run it. Once it has finished, delete that file from your site. Let me know if you have any problems with it.

Thanks,
Derek
Just to be sure, do I run the converter before or after installing the description hack?

[derekivey]

After.

Derek

[Megareus Rex]

And then I uninstall the other description hack, I'm assuming? (After installing your desc. hack, and running the converter).

Sorry for the questions, I just dont wanna mess anything up. I'll have a backup to revert to if something goes wrong, but its still a pain in the neck to do so.

[derekivey]

Make sure my converter imported the old descriptions first, and then uninstall the other hack when your sure it converted them ok.

[Megareus Rex]

It worked perfectly. You are so awesome for that :D

You should add that file in as part of the hack for those of us already dug in with the older version, if you weren't planning on that already.

[derekivey]

Great :).

Yes, I plan on including it with the next version.

Derek

[Danny Diamond]

Installed.

Good times

[Snake]

Will this work on 3.6.4?

[derekivey]

It should...

[rnmcd]

Will this work on 3.6.4?

Try it...I dare you to be the guinea pig :knockedout:

[tmwillett]

it works wonderfully on 3.6.4 :) I installed it tonight :) My members love it :) great hack!

[rnmcd]

Your members told you they loved it the same night you installed it?

I'd like to see a link to anyone that has this installed on vb 3.6.4.

[Snake]

Here ya go. As you can see, I've it installed on my forums. :D

http://www.finalfantasyforums.net

[derekivey]

Yup, it should work fine on 3.6, as there weren't many changes (just new features basically).

[RvG2]

works in 3.6.7 pl1 :)

[optrex]

I've got this working on vb 3.6.7pl1 too, but does anyone know how to make it work in vb advanced?

[fly]

It works as long as you don't preview the thread. The description gets lost then.

[sonixax]

Is it compatible With 4.0.7 ?