PHP Template to get database connection parameters and access control

stelaso

We are looking to develop a PHP report page and incorporate into osTickets 1.9+.Assume the PHP report can only be executed AFTER user login, wondering how we can get the database connection parameters (database name, database user, password) and user access control enforced on the PHP report. I mean we don't want to hard-code the database connection parameters within the PHP report.And even if we do, we cannot enforce the user access control (e.g. department, team etc).Any advice or pointers please? Thanks.

ntozier

db connection info is in /include/ost-config.phpuser permissions are more difficult. you can look up their group_id, dept_id and role_id in ost_staff.Then look up their permissions in ost_role.

stelaso

Thanks for advice.