vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Forum Display Enhancements - Thread title enhancement (https://vborg.vbsupport.ru/showthread.php?t=138781)

parrot5 02-10-2007 01:49 AM

Error on install:

Quote:

Invalid SQL:
ALTER TABLE vb_thread ADD COLUMN tte_titlefontsize INT UNSIGNED NOT NULL DEFAULT '';

MySQL 错误 : Invalid default value for 'tte_titlefontsize'
错误号 : 1067
Looks like it's because of this syntax error that the column never got added for the previous versions as well?

I tried changing '' to '11' and the site loads normally. I can change the colors and size. However when try to remove all of enhancements, the size won't revert back to 11. I was already happy with 1.0 version and I think I'm going back to 1.0 at least for now :) Do you mind providing 1.0 again?

Kungfu 02-10-2007 02:17 AM

Quote:

Originally Posted by parrot5 (Post 1178854)
Error on install:


Looks like it's because of this syntax error that the column never got added for the previous versions as well?

I tried changing '' to '11' and the site loads normally. I can change the colors and size. However when try to remove all of enhancements, the size won't revert back to 11. I was already happy with 1.0 version and I think I'm going back to 1.0 at least for now :) Do you mind providing 1.0 again?

Sorry that should be 0. And it you leave the field blank or set it to 0 it will just go to 0. If the size is 0 it wont resize the font. Its only if you put in 1 or more. And it goes by pixels.

xenon58 02-10-2007 09:04 AM

hi, thanks for taking and including my suggestion, i do appreciate it. i've just checked on a new version and unfortunately i've found few bugs that id like to point your attention to.

1. i wanted to know about the color table that is created, when a user choses a color, why it doesn't get entered into the color text box as a color of choice? i had to manually write the name of the color in order to change the color of the letters. i think it would be great to have user select the color form the table, click on it, and name of the color gets entered into that box, so the users knows which color those letters will be.

2. on the font box, do you think having a drop-down box like in the editor with the name of the fonts installed would be possible to do? i just think that it would be more useful as an option to users just to choose the font type, and a size from already available fonts, rather then write down a name of a font that doesnt exists and ask stupid questions like "why it didnt change the font"

3. when i've selected to remove all the changes i've made, unfortunately only color change was removed, but bold, underline and font-size are still there and unchanged. so the removal procedure didnt work as planned.

thank you again for creating this great addon. its a great idea indeed. i do appreciate your time and efforts spent on this. im sure its going to be one helluva mod, once its done ;)

Kungfu 02-10-2007 02:59 PM

Quote:

Originally Posted by xenon58 (Post 1179010)
hi, thanks for taking and including my suggestion, i do appreciate it. i've just checked on a new version and unfortunately i've found few bugs that id like to point your attention to.

1. i wanted to know about the color table that is created, when a user choses a color, why it doesn't get entered into the color text box as a color of choice? i had to manually write the name of the color in order to change the color of the letters. i think it would be great to have user select the color form the table, click on it, and name of the color gets entered into that box, so the users knows which color those letters will be.

2. on the font box, do you think having a drop-down box like in the editor with the name of the fonts installed would be possible to do? i just think that it would be more useful as an option to users just to choose the font type, and a size from already available fonts, rather then write down a name of a font that doesnt exists and ask stupid questions like "why it didnt change the font"

3. when i've selected to remove all the changes i've made, unfortunately only color change was removed, but bold, underline and font-size are still there and unchanged. so the removal procedure didnt work as planned.

thank you again for creating this great addon. its a great idea indeed. i do appreciate your time and efforts spent on this. im sure its going to be one helluva mod, once its done ;)

It uses a hex color. If you were to type gray or grey i cant remember which one in IE it doesnt work. Using the hex code should always work and i recommend using that instead of just a color as they dont always work.
I suppose i could add an option like HexColor:RealColorName in the options so when you click on it, it shows the real color name or something.

For fonts i could have a setting in options to add more

for size i would have to treat a bit different since its pixels not pts like the bbcode.

but ill look into it.

Kungfu 02-13-2007 05:54 PM

I added the font select box instead now. Just need to add the size in a select box. Instead of saying a color i just added a preview box instead.

The preview box only works if you click on the a color from the table. Ill probably add an option to make the box read only so whatever you put in the colortable is the only colors you can choose from.

I started to make it show up as an actual color, but it started to get complicated quite fast so instead i just made a preview area so you can see what color it is and font etc..

pollon 02-14-2007 06:41 AM

hi!
thank you for this hack. i would like to know if i can set the usergroups that can use this hack.

Kungfu 02-15-2007 04:57 AM

Ok, fixed the issues from before when upgrading. It should not give you errors anymore. I tested this on another board and it worked ok for me. There are quite of bit of changes so i suggest just replacing everything in the SHOWTHREAD template.

Added permissions to usergroup manager, so you must set permissions here for people to use it.

Good thing about this hack is it shouldnt use anymore SQL queries then what you currently have now. It just adds onto or uses existing queries that VB makes.

This will probably be the final update, so if anyone wants to take this project and further develop it they can.

apiasto 02-15-2007 05:32 AM

nice mod , thnx

parrot5 02-16-2007 12:06 AM

You're the man! Thanks for improving on the mod. My crew loves you.

xenon58 02-16-2007 05:18 AM

thnx for an update bud, really appreciated. unfortunately when installing, got this error

PHP Code:

Parse errorparse errorunexpected T_ENCAPSED_AND_WHITESPACEexpecting T_STRING or T_VARIABLE or T_NUM_STRING in ***\includes\adminfunctions_template.php(3596) : eval()'d code on line 28 

this error showed up when i was doing the last step of an install, which was
PHP Code:

OPEN Threadbit

Find
:
--------

<
a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]id="thread_title_$thread[realthreadid]"<if condition="$show['gotonewpost']"style="font-weight:bold"</if>>$thread[threadtitle]</a>


Replace With:
--------------

<
a href="showthread.php?$session[sessionurl]t=$thread[threadid]$thread[highlight]id="thread_title_$thread[realthreadid]"<if condition="$thread['titlestyle']">style="$thread[titlestyle]"</if><if  condition="$show['gotonewpost']"style="font-weight:bold"</if>>$thread[threadtitle]</a

do you know what gives by any chance?

thnx again for all the time and help.


All times are GMT. The time now is 03:30 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01287 seconds
  • Memory Usage 1,761KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete