Forum Display Enhancements - Thread title enhancement

Thread title enhancement
To use this i recommend uninstalling Thread cosmetics if you have it installed already. Im not really sure what this might do to have them both. Also disable vbplaza if you have not already. It should work ok with vbplaza, but its not a good idea to have it enabled.

To use this you will see under the thread drop down menu Thread Cosmetics, just like the hack below had. You must click Beautify and then update to update the values.

Install takes about 5 minutes


Description:

Thread title enhancement will let you Italicize, Bold, Underline, Color or set a Font to a thread title.

Inspiration / Thanks:

Well i liked how you could do this in vbplaza. Then there was another hack to do this without having to use points. https://vborg.vbsupport.ru/showthread.php?t=131913 , i actually modified that hack and took the portion from vbplaza to make this. Its a little bit better as it will work in any browser that i know of. I thank paul41598 and vbplaza. Only reason i made this was so i could have the colored stuff again without having vbplaza installed due to the exploits. Im not sure if it will ever come back.


Support:

I wont be supporting this hack that much, its basically going to be as is. I may add more features later on.
Version 1.0.2 is probably my last update, if anyone wants to expand on this hack they may.

Changelog:

2.0.0

• Fixed a bug where if you removed all settings from the title but had a font size on it would not remove the font size.
• Got rid of all the plugin files, now there is only one file to upload
• Got rid of most template modifications. Only need to do one now.
• If you want to upgrade you will basically need to start all over, reverse all template changes. Reinstall the product. Delete all files in the plugins folder. Only file that needs to be uploaded is includes\xml\bitfield_tte.xml. All template modifications have changed as well. You can leave them there if you like but make sure to shut off the auto template modification in the TTE options.

1.0.2

• Added a font select box, you can add more fonts in settings
• Added a size select box, you can add more sizes in settings.
• Added bitfields for permissions. You must set these in the usergroup manager as all are set to no by default.

1.0.1

• Fixed the underline, so if you do underline it does underline now.
• Added a color table, you can add your own colors
• Added font size

1.0.0

• Make thread title Bold, Italic, Underline, Colored and change font.

[Kungfu]

Originally Posted by parrot5

After that bit of modifying, your mod works perfectly. I have been searching for months for a mod like this! Thanks a bunch!!

For the ease of use for my crew though, I might modify it so that the colours can be chosen instead of typed in... but I understand that your method gives the most flexibility.

yea, i was thinking of this as well. Put in a color wheel basically. You choose the color from a little popup thingy. I had to get this out as fast as possible for my forums as its used by my mods in the my forums. Ill look into getting something like that just so its easier.


I worked on the color table thing a little bit. I decided to do something sort of like the VB editor. I didnt know how to just create the button so im doing this from scratch. Its just a table with rows. You can add your own colors and it goes up to 5 columns then starts a new one as shown in the screenshots. hopefully ill get it so it does pop down like the color font on the vb editor.

[xenon58]

its a great idea. one thing i wanted to ask, if its possible at all, once you are done with color table can you please add an option to change the size of the font, next to the name of the font? i think it would be more useful to users to be able to change the size of the font. thnx

[parrot5]

Originally Posted by Kungfu

yea, i was thinking of this as well. Put in a color wheel basically. You choose the color from a little popup thingy. I had to get this out as fast as possible for my forums as its used by my mods in the my forums. Ill look into getting something like that just so its easier.


I worked on the color table thing a little bit. I decided to do something sort of like the VB editor. I didnt know how to just create the button so im doing this from scratch. Its just a table with rows. You can add your own colors and it goes up to 5 columns then starts a new one as shown in the screenshots. hopefully ill get it so it does pop down like the color font on the vb editor.

Hey this is a lot more usable for my crew!! Brilliant! Will you release the code for it (or later after you finish it) ?

[Kungfu]

Originally Posted by xenon58

its a great idea. one thing i wanted to ask, if its possible at all, once you are done with color table can you please add an option to change the size of the font, next to the name of the font? i think it would be more useful to users to be able to change the size of the font. thnx

Yea, i can do that. shouldnt be a big problem.

Originally Posted by parrot5

Hey this is a lot more usable for my crew!! Brilliant! Will you release the code for it (or later after you finish it) ?

Yea, its usable now, just not pretty

[parrot5]

I get a database error whenever I try going into any forum after upgrading it. Here's the error log:

Invalid SQL:

SELECT post.pagetext AS preview,post.thankscache,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount




,thread.tte_boldflag, thread.tte_italicflag, thread.tte_underlineflag, thread.tte_titletextcolor, thread.tte_titlefonttype, thread.tte_titlefontsize, firstpostid
FROM vb_thread AS thread



LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)



WHERE thread.threadid IN (0,4297,4294,4198,4022,3768,3565,3917,3777,3765,36 65,2919,3796)
ORDER BY sticky DESC, lastpost DESC;

MySQL 错误 (edit: Error) : Unknown column 'thread.tte_titlefontsize' in 'field list'
错误号 (edit: Error number) : 1054

The words in brackets are the translation for the Chinese characters on the left. I disabled the plugin in a hurry and the site is back to normal.

[Kungfu]

You reuploaded the product file? You may have to uninstall it and try to reinstall it again. It sucks that theres no way to check if a column already exists or not.

[parrot5]

Originally Posted by Kungfu

You reuploaded the product file? You may have to uninstall it and try to reinstall it again. It sucks that theres no way to check if a column already exists or not.

Uninstallation:

数据库错误在 vBulletin 3.6.4:

Invalid SQL:
ALTER TABLE vb_thread DROP COLUMN tte_titlefontsize;

MySQL 错误 : Can't DROP 'tte_titlefontsize'; check that column/key exists
错误号 : 1091
日期 : Friday, February 9th 2007 @ 05:30:45 PM
脚本 : (*forum path*)/admincp/plugin.php?do=productkill
来源 : (*forum path*)/admincp/plugin.php?do=productdelete&productid=TTE&s=

After this error, the mod is still on the product list.

[Kungfu]

Originally Posted by parrot5

Uninstallation:

After this error, the mod is still on the product list.

ok i think i found a way to fix this to check. So im going to try it and see if it works. If you want to do it manually you can go to the query area under maintenance. And put in

ALTER TABLE vb_thread.thread ADD COLUMN tte_titlefontsize INT UNSIGNED NOT NULL DEFAULT ''")

[parrot5]

Originally Posted by Kungfu

ok i think i found a way to fix this to check. So im going to try it and see if it works. If you want to do it manually you can go to the query area under maintenance. And put in

ALTER TABLE vb_thread.thread ADD COLUMN tte_titlefontsize INT UNSIGNED NOT NULL DEFAULT ''")

Yes the tte_titlefontsize column never got added. Not even after I install it from scratch. Very strange I still cannot get it go work.

[Kungfu]

Originally Posted by parrot5

Yes the tte_titlefontsize column never got added. Not even after I install it from scratch. Very strange I still cannot get it go work.

Ok i think i got a workaround for it. Please download that product xml file in attachments and see if that works for you.