Announcement box

[xowi]

How can I increase the character limit for the announcement box?

Thanks.

[Chuck S]

That is not something you can do unless altering your settings table and changing the settings field from a varchar to text.

ALTER TABLE pp_settings CHANGE setting setting TEXT;

[xowi]

Sounds good.
Thanks Chuck.

[Chuck S]

Not a problem have a good one.

[skidpics]

Originally Posted by Chuck S

That is not something you can do unless altering your settings table and changing the settings field from a varchar to text.

ALTER TABLE pp_settings CHANGE setting setting TEXT;

since it us setup as a varchar(250), can you just not change it to something like 500?

[skidpics]

never mind - just answered my own question..

Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255

[Chuck S]

Yep it has a max length of 255 which is the issue

[skidpics]

IC - I just changed it to 500 to see what it does, and mysql converts it to a text field instead

Good news is, html can still show in it.

[Chuck S]

yes text box means anything can be entered really

[skidpics]

I tried some variations, but how would be use an 'include' to just include a file for announcements in that block?

I tried:

<?php include("http://skidpics.com/announcewithuploader.html"); ?>

and

<!--#include virtual="insertthisfile.html" -->

both with no luck - any suggestions or is this not possible?

[Chuck S]

You cant that I know of its not a php file

You could try just this of course using the proper path

include( "/var/www/html/announcewithuploader.html" );