/** * Delete all the relationships between events and * resources when the list of events in a * course has been deleted. * @param Event $event */ public function deleteEventResourceList($event) { $eventArgs = $event->getArgs(); $cid = array_key_exists('cid', $eventArgs) ? $eventArgs['cid'] : ''; $mainTables = claro_sql_get_main_tbl(); $eventResourceTable = $mainTables['event_resource']; $sql = 'DELETE FROM `' . $eventResourceTable . '` ' . 'WHERE `course_code` = \'' . $cid . '\''; claro_sql_query($sql); }