I've installed the latest Time Tracker and all is functioning as designed.
I see in the install instructions that users can be made to login from either the Time Tracker Database or from an LDAP server.
I have a different need when it comes to users logging in.
Currently my company has a "Staff Area" on our website, and Time Tracker is installed in a sub-directory of that Staff Area.
Currently we have a small, very generic, MySQL database that contains each employees login credentials.
As I created each employee in Time Tracker, I used the same login username and password that each employee has in our staff area database.
So, currently, users first have to login to the staff area, then click the Time Tracker link, then login a second time to Time Tracker.
As one would expect, several employees (and a few bosses) want it so that users only have to login to the Staff Area, and once logged in, those credentials automatically cause the employee to be logged into Time Tracker without having to login a second time.
I specifically used the same usernames so they would carry over well from both databases.
I did see in the MySQL database that we are using different field names for the password field though. In Time Tracker the password field name is called "password". In our employee database the password field variable is called "pwd". I do see both databases use the same "login" field name.
So.... How can I get Time Tracker to use our own existing employee MySQL database to validate users at login.
Currently Time Tracker is installed on a linux platform.
Also as a side note, any page we have have inside the employee staff area starts with this PHP code.
$res=mysql_query("SELECT * FROM tblUsers WHERE id=".$_SESSION['user']);
This is to prevent someone from direct linking to a page in the staff area without logging in first.
If the session is not set, it throws the user back to the employee login screen.
Any help is appreciated in advance, and thank you for an awesome Time Tracking platform.