Page 1 of 1

Question about HESK SQL database setup

Posted: Wed Dec 17, 2008 12:58 pm
by puniksem
Question about SQL setup for the helpdesk software?

I am trying to setup a copy of HESK into a sub-domain, but found that as the SQL setup sub-prefixes are predefined, the setup conflicts with my existing domain HESK installation.

Is there any way either you can introduce an update for HESK so users can define customized prefixes for the SQL files? or is there any way I can alter the existing scripts to accomodate multiple HESK installations on one SQL database.

Many thanks in advance
Puniksem

Posted: Wed Dec 17, 2008 2:35 pm
by Klemen
It's already included in the next version. The new version is now almost fully functional (say about 95%), I need to update installation files and documentation. I plan to release it before new year.

Untill then you will need to manually change 'hesk_' table prefixes to something else in all Hesk files.

another small question

Posted: Wed Dec 17, 2008 6:18 pm
by puniksem
I wish to setup the settings so that the SQL database password is represented by ******** only so that the other admin cannot view my database password. is this possible?


Do I change the below code in admin_settings_save.php

Code: Select all

$set['database_pass']=hesk2_input($_POST['s_database_pass'],$hesklang['err_dbpass']);
Your advice is greatly appreciated
Puniksem

Posted: Wed Dec 17, 2008 7:03 pm
by Klemen
Don't confuse MySQL table prefix with function names. hesk_tickets is a MySQL table but hesk_input() is a PHP function.

To hide the password change

Code: Select all

<input type="text" name="s_database_pass"
to

Code: Select all

<input type="password" name="s_database_pass"
.

Thank you

Posted: Wed Dec 17, 2008 8:04 pm
by puniksem
Thank you for replying, I sussed it while waiting for an answer