Help to add a column to Approve/Manage Reservations

[MeGo]

Good afternoon,
First of all, thanks for all the hard work you've done to create this wonderful app.

Here is my question.   I have created two schedules for managing a group of 12 people.  One schedule is to request time off, and the other one to show availiability for over time.  Each person was created as a resource under each schedule.  With this setup, I have been able to accomplish exactly what I need to manage the group, except for one thing.  When I hit the Approve/Manage Reservations, I am presented with a table showing Start/End Date, User, Resource Name, Start/End Time, View, Modify/Approve, and Delete.   The problem is, I am able to see the reservations, but I am unable to see if it was made on the Time Off, or the Overtime schedules.  Is there any way to add the Schedule Name to the table?

Thank you very much in advance for your time and assistance.

[Nick]

To do this you would need to make 2 modifications:

1) lib/db/AuthDB.class.php, change the query on line 79 to join on to schedules for each reservation and return the schedule_name.

2) templates/admin.template.php, add a row after line 728 to display the schedule name, just like the other columns do.

[MeGo]

Nick, thanks for your reply.  However, I have been unable to find the query you refer to on line 79 of the lib/db/AuthDB.class.php file.  Could you please post a sample of the code?

Thank you very much.  I am fairly new to this, so please excuse my stupidity  :wink:

[Nick]

Sorry about that, it's AdminDB.class.php, not AuthDB.class.php

[MeGo]

Nick, thanks a lot for your reply.

Sorry to be a pain in the butt, but due to my limited PHP knowledge I have struggled trying to make these simple changes.  Do you think is possible for you to post the code for the modified query?

Thank you very much for your help.