Customization of Staff-Signature

bigblueenzo

Hi there,

I recognized, that there is a restriction to the number of characters a staff-signature can have. Is there any possibility to edit this number?

Cheers

Sven

Corey

Right now it's set to 255. You can edit the number by running this SQL query:

ALTER TABLE `ost_staff` CHANGE `signature` `signature` VARCHAR( number ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL

Change number to the number you want.

bigblueenzo

Thats great and easy! Thank you very much!

Joecool

Right now it's set to 255. You can edit the number by running this SQL query:
ALTER TABLE `ost_staff` CHANGE `signature` `signature` VARCHAR( number ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
Change number to the number you want.

Hi, this is an old thread, but it covers the same question I had.

I don't understand how to run an "SQL query" what exactly do I need to do?

I have configured some other parts of osticket to my liking just but editing the PHP pages. But I am not really that technical, I just figure it out as I go.

I need my signature to be longer than it is, because I want it to display a disclaimer and a link to my full disclaimer page.

Can anyone clarify exactly how to make my signature longer. I tried editing one of the php files (can't remember which one) and it changed the length of the box in my control panel, but it still didn't allow me to save a longer signature to the box.

Help... :)

pti_breton

This number is in the database so you have to use a software like PHPMyAdmin to manage it.

Be careful !

ozkr

ALTER TABLE `ost_staff` CHANGE `signature` `signature` VARCHAR( 2550 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

in 2550 you can put the number you want.

Joecool

Thanks for the help pti_breton and ozkr. I have managed to find phpadmin and run the query and everything seems to be running perfectly now. I have managed to fit all my signature in.

Thanks a lot, both of you. :)

stevewalsh

field type - tinytext -> text

I simply changed the type of the dept_signature field from "tinytext" to "text".

If anyone knows why I shouldn't do this as opposed to running the SQL in this thread, please let me know.... (so far it's all still working!)

(everything is managed via webmin, which has a MySQL module to give you access to the database to change such things.....and create backups etc....)