Forum Display Enhancements - ChangUonDyU - Thread Title Stylist

ChangUonDyU - Thread Title Stylist
version 2.0

Feature
-Custom Thread Title style width: Font, Size, Color, Bold, Italic, Underline, Strikeline, Overine at

• Forum Display
• Search Results

-Auto template: New thread, Edit first post of thread
-Preview

Settings
-Turn ON or OFF
-Turn feature (view attach)
-Custom your font list, size list, color list
-Usergroup are allowed to asjust thread title style (default: 5,6,7 for Admin,Smod,Mod)

Installation
Import XML file via Product

DONE!

DEMO:
New thread: http://img517.imageshack.us/img517/7311/a1cf0.jpg
Edit first post: http://img517.imageshack.us/img517/9872/a12zs6.jpg
FoumDisplay: http://img517.imageshack.us/img517/5241/a2lu5.jpg
Search Results: http://img255.imageshack.us/img255/4120/a3ji6.jpg

Thank to Fırtına for Turkish Language

[DjEddie]

This is very good mod, thanx, installed with no problems...

As someone suggested for next update, When u use Edit Thread in Thread Tools options to have it showing there too for you to edit previously made threads.
Also to have it override any other setting when you make the Thread Sticky And Closed

Thanks

Clicked Installed and Clicked Nominated

[bada_bing]

Originally Posted by xtrung

3.5.x -> 3.9.x

Does NOT work for 3.5.x here is the database error I got

Database error in vBulletin 3.5.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
	(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
	('1', '4', 'Chang - Thread Title Style - Select Menu Edit First Post', 'editpost_edit_start', 'global $vbulletin;\r\n			if ($vbulletin->options[\'tstyle_turn\'])\r\n			{\r\n			\r\n			if (!$isfirstpost)\r\n{\r\n    $colorlist = $vbulletin->options[\'tstyle_colorlist\'];\r\n			$colorlist = preg_replace(\"#(\\r\\n|\\r|\\n)#s\",\"#\",$colorlist);\r\n$clist = explode(\'#\',$colorlist);\r\n$sl = sizeof($clist);\r\nfor ($i = 0; $i < $sl; $i++)\r\n{\r\n$selected = \'\';\r\n$ccolor = $clist[$i];\r\nif ($ccolor == $threadinfo[\'tcolor\']) { $selected = \'selected\'; }\r\neval(\"\\$tselectcolor .= \\\"\".fetch_template(\'changuondyu_optioncolor\').\"\\\";\");\r\n}\r\n\r\n$sizelist = $vbulletin->options[\'tstyle_sizelist\'];\r\n$sizelist = preg_replace(\"#(\\r\\n|\\r|\\n)#s\",\"#\",$sizelist);\r\n$clist = explode(\'#\',$sizelist);\r\n$sl = sizeof($clist);\r\nfor ($i = 0; $i < $sl; $i++)\r\n{\r\n$selected = \'\';\r\n$optionvalue = $clist[$i];\r\nif ($optionvalue == $threadinfo[\'tsize\']) { $selected = \'selected\'; }\r\neval(\"\\$tselectsize .= \\\"\".fetch_template(\'changuondyu_optionsizefont\').\"\\\";\");\r\n}\r\n\r\n$fontlist = $vbulletin->options[\'tstyle_fontlist\'];\r\n$fontlist = preg_replace(\"#(\\r\\n|\\r|\\n)#s\",\"#\",$fontlist);\r\n$clist = explode(\'#\',$fontlist);\r\n$sl = sizeof($clist);\r\nfor ($i = 0; $i < $sl; $i++)\r\n{\r\n$selected = \'\';\r\n$optionvalue = $clist[$i];\r\nif ($optionvalue == $threadinfo[\'tfont\']) { $selected = \'selected\'; }\r\neval(\"\\$tselectfont .= \\\"\".fetch_template(\'changuondyu_optionsizefont\').\"\\\";\");\r\n}\r\n}\r\n\r\n$tlocate = \'post\';\r\n\r\n}\r\n', 'changthreadstyle');

MySQL Error  : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date         : Monday, June 16th 2008 @ 07:39:36 AM
Script       : http://www.mysite.com/forums/admincp/plugin.php
Referrer     : http://www.mysite.com/forums/admincp/plugin.php?do=productadd
IP Address   : 67.59.x.x
Username     : XXXXXXXXXXXXXr
Classname    : vb_database

[bada_bing]

Now I cant uninstall this hack without database errors, should of really made sure it worked for 3.5.x before posting that it would work

[bada_bing]

How can I uninstall this plugin? When I try and do an uninstall I get this now

Database error in vBulletin 3.5.3:

Invalid SQL:
ALTER TABLE thread DROP COLUMN tfont;

MySQL Error  : Can't DROP 'tfont'; check that column/key exists
Error Number : 1091
Date         : Monday, June 16th 2008 @ 07:49:16 AM
Script       : http://www.mysite.com/forums/admincp/plugin.php
Referrer     : http://www.mysite.com/forums/admincp/plugin.php?do=productdelete&productid=changthreadstyle&s=
IP Address   : 67.59.x.x
Username     : xxxxxxxxxxxxxxxxxxxx
Classname    : vb_database

I did check the database and tfont does not exist but I need to remove the plugin from showing up in my CP

[LjNux]

Unknown column 'executionorder' in 'field list'

Check it in database please.

[xtrung]

@bada_bing: i tested my hack on vbb358 and work stable, i thing 3.5.3 same..
Now, to Unsintall
you login to AdminCP > Manage Product
Edit my product
Delete all content in Uninstall Code textarea
--then Uninstall product

I thing you should upgrade to 3.7.1, 3.5.3 is very old

I can try edition for 3.5.3

[bada_bing]

Originally Posted by xtrung

@bada_bing: i tested my hack on vbb358 and work stable, i thing 3.5.3 same..
Now, to Unsintall
you login to AdminCP > Manage Product
Edit my product
Delete all content in Uninstall Code textarea
--then Uninstall product

I thing you should upgrade to 3.7.1, 3.5.3 is very old

I can try edition for 3.5.3

Thanks xtrung the new plugin worked great for 3.5.3 about upgrading no need to go 3.7 for me no new feature I really want to use plus my version is stable for me... .Thanks

[PiTXI]

Awesome!!!

*** Installed ***

[q8salem]

VVVVVVVVVery nice !!!

*** Installed ***

If it show the same results on forumhome it would be great.

thanks

[BWJ]

nice hack - but I have a problem:

1) I installed it
2) I experienced that not all phrases were possible to translate through admin
3) I custom made the translation to the file
4) I overwrote the old file
5) There was a problem with the 'Underline' as it always appeared (may be this was a problem already). But I was in doubt - tried your uninstall instructions mentioned above
6) now I got this database error when I try to overwrite the product again:

Invalid SQL:
ALTER TABLE forumthread ADD COLUMN tfont VARCHAR(30) NOT NULL;

MySQL Error : Duplicate column name 'tfont'
Error Number : 1060

How do I remove this column and get back in order?