Question about HESK SQL database setup

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
puniksem
Posts: 47
Joined: Thu Nov 01, 2007 12:25 pm

Question about HESK SQL database setup

Post 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
World's shortest poem: We, see.
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post 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.
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
puniksem
Posts: 47
Joined: Thu Nov 01, 2007 12:25 pm

another small question

Post 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
World's shortest poem: We, see.
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post 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"
.
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
puniksem
Posts: 47
Joined: Thu Nov 01, 2007 12:25 pm

Thank you

Post by puniksem »

Thank you for replying, I sussed it while waiting for an answer
World's shortest poem: We, see.
Post Reply