Additional Field

[chrisgoodrich]

I followed the instructions for adding an additional field to the reservation form.  Everything works fine.

I created a new field for the event title.  Now I am attempting to replace the "resource" display field in the main control panel with the new field.

I have tried everything I can think of to get it to display, however I do not have a great knowledge of PHP.

Any suggestions would be greatly appreciated!

[Nick]

I think all fields are being returned, so you should just be able to change $rs['name'] on line 153 to $rs['whatever your field name is']

[chrisgoodrich]

That is what I thought too and I have done that.  However, the field comes back blank.  No text shows up.

[Nick]

Try adding the field to the query on line 214 of lib/DBEngine.class.php

[chrisgoodrich]

This is what i edited on line 214:

Code:

$query = 'SELECT res.*, resusers.*, rs.name, rs.location, rs.rphone, eventtitle FROM '

I also edited the following in cpanel.template.php:

Code:

. '          <td style="text-align:left;">' . $rs['name'] . '</td>'

to read:

Code:

. '          <td style="text-align:left;">' . $rs['eventtitle'] . '</td>'

I have done this for all of the tables (my invitations, my reservations, etc.)

Still doesn't seem to show up properly.[/quote]

[chrisgoodrich]

I got it to work correctly.  I made the changes described above as well as the following change on line 426 of DBEngine.class.php:

Code:

$query = "SELECT ru.resid, ru.memberid, ru.accept_code, l.fname, l.lname, r.start_date, r.end_date, r.starttime, r.endtime, res.name, eventtitle FROM

where my custom field is titled "eventtitle"

Hope this provides help to anybody else attempting to make these same changes.

Any ideas on where to start to change the display of events within the calendar?  Instead of displaying the reservation owners name I want to display the event title.  Any ideas?

[Nick]

This isn't too bad.  If you want to just hack it in, all you will need to do is change the query that pulls back reservations in Schedule.class.php (get_all_res()).  There is a function called write_reservation() where you can change this line:

Code:

$summary->user_name = "{$rs['fname']} {$rs['lname']}";

to:

Code:

$summary->user_name = "{$rs['eventtitle']}";

[chrisgoodrich]

I made that change, but for some reason it still shows up with the reservation owners name.

Any Ideas?

[Nick]

Are you talking about the main booking schedule, or one of the calendar views?

[chrisgoodrich]

I am eventually going to try to do all of them.  

I have looked on all of the calendars and none have changed.

[barh0002]

In his first post he references some instructions for doing this...where would i find those?

[Nick]

The project download page on SourceForge has a pdf on how to add fields.

[durana]

hello guyz,

I have searched for the pfd for adding extra fields, but I can really find it.
Can someone give me the exact link??

thankd durana

[Nick]

Here you go...

https://sourceforge.net/project/showfiles.php?group_id=95547&package_id=169927