Home Forums Pre-Releases Attendee Reassignment Filter by Category

Attendee Reassignment Filter by Category

Posted: December 16, 2013 at 12:56 pm

Al Joly

December 16, 2013 at 12:56 pm

The attendee reassignment filter is working good for us. The downfall we’ve found is that we have a lot of events. We have them all categorized by their type of class.

For example: First Aid – all these classes are in that category as we run this class multiple times each month.

Our usage for this tool is to move them from one date to a new date.

Is there a way to filter the event display in the Attendee Reassignment dropdown to only show events in the same category?

Sidney Harrell

December 16, 2013 at 3:33 pm

You would need to make some code changes to the attendee mover tool. In index.php add in the following after line 68:

global $wpdb, $org_options;

	$cat_id = $wpdb->get_var($wpdb->prepare("SELECT cat_id FROM " . EVENTS_CATEGORY_REL_TABLE . " WHERE event_id = '%d'", $old_event_id));

then add the following line after what will then be line 138:

$sql .= " FROM " . EVENTS_DETAIL_TABLE . " e ";
	$sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " cr ON  cr.event_id = ";

then modify line 155:

$sql .= " WHERE e.event_status != 'D' AND cr.cat_id = '%d'";

and finally, modify line 165:

$events = $wpdb->get_results($wpdb->prepare($sql, $cat_id));

Note: I was working off the development branch copy, but it should be pretty much the same code in the current pre-release channel copy.

The support post ‘Attendee Reassignment Filter by Category’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso