CiviCRM Community Forums (archive)

Our organization needs to display a list of events that show the vacancy status (vacancies or full) because we have hundreds of volunteer events per month for volunteers to check.

It appears this was possible in the past (version 3, 4.0, 4.1) but previous methods described in the wiki:

http://wiki.civicrm.org/confluence/display/CRMDOC41/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

...  do not work for v 4.2. The PHP code that apparently did work is here:

SETUP CODE:

if (module_exists('civicrm')) {
  civicrm_initialize(TRUE);
  require_once 'api/v2/Event.php';

VALUE CODE:

if (module_exists('civicrm')) {
  $booked=CRM_Event_BAO_Participant::eventFull($row->ID);
  if ($booked)
    return " is_fully_booked";
  else
    return " is_available";

This gets an Ajax error:

An AJAX HTTP error occurred.
HTTP Result Code: 200
Debugging information follows.
Path: /admin/structure/views/view/events_that_are_full/preview/default/ajax
StatusText: OK
ResponseText:
Parse error:  syntax error, unexpected $end in /home/michael/public_html/sites/all/modules/views_php/plugins/views/views_php_handler_field.inc(117) : runtime-created function on line 3
Fatal error:  Function name must be a string in /home/michael/public_html/sites/all/modules/views_php/plugins/views/views_php_handler_field.inc on line 119

Is it possible there is a missing "}" at the end of the code in the setup or value (or both) codes?

If anyone can offer suggestions as to why the code for version 4.1 no longer works for 4.2 with a possible fix I will be more than happy to test it! (It's probably something simple but I haven't been able to figure it out.)

Thanks in advance.

the current docs:

http://wiki.civicrm.org/confluence/display/CRMDOC43/Event+listing+showing+fully-booked+result+using+Drupal+Views+PHP

do include the close braces in both the setup and value code blocks

lobo