increasing the signature lengh

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
power
Posts: 31
Joined: Fri Feb 16, 2007 3:05 am

increasing the signature lengh

Post by power »

Script URL:
Version of script: 94
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:


I need to know how to increase the signature lengh, our sig is very long, and is it safe to set it to 999999 max, thanks

Signature (max 255 chars):
power
Posts: 31
Joined: Fri Feb 16, 2007 3:05 am

Post by power »

can someone help me ? thanks
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

You'd have to go into MySQL database and in table "hesk_users" change field type for 'signature' from "varchar(255)" to "text". You can use phpMyAdmin to do that if your host supports it.

Also open profile.php in a plain text editor and delete line

Code: Select all

if (strlen($_SESSION['signature'])>255) {hesk_error($hesklang['signature_long']);}
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
SEEKNDESTROY427
Posts: 12
Joined: Thu Dec 27, 2007 3:04 pm

Re: increasing the signature lengh

Post by SEEKNDESTROY427 »

How do increase the signature length in Hesk 2.4.2?
I changed the MySQL database value.

Changing

Code: Select all

if (strlen($_SESSION['new']['signature'])>255)
in admin/profile.php does not work.

Thanks
Klemen
Site Admin
Posts: 10147
Joined: Fri Feb 11, 2005 4:04 pm

Re: increasing the signature lengh

Post by Klemen »

You didn't change MySQL database value, because 255 is the maximum "varchar" fields will accept in MySQL.

You will need to change field type to "text" in MySQL.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
SEEKNDESTROY427
Posts: 12
Joined: Thu Dec 27, 2007 3:04 pm

Re: increasing the signature lengh

Post by SEEKNDESTROY427 »

You're correct, I made a mistake editing the database value. However, deleting if (strlen($_SESSION['new']['signature'])>255) does not work. I had to change it to if (strlen($_SESSION['new']['signature'])>10000) to be able to save the signature. 10k is a lot but I'm the only one answering tickets so it doesn't matter.
Post Reply