Re: [Bodington-developers] Events

[Matthew B. <mat...@ou...>]

Naomi Miles wrote:
> That's what I kind of thought, just thought I'd check.
> 
> We're trying to set up reports, so that users can display who's been  
> doing what in their various rooms.  So, we're pulling back all the  
> Events for a particular resource and then building up xml to display  
> events per resource.
>   Something like:
> 
>>> <resource id="1234">
>>>   <user id="eo01nm">
>>>     <event code="1" time="2005-01-19 14:58:32" />
>>>   </user>
>>> </resouce>
> 
> But we really need the type of event otherwise the event code is  
> meaningless.

If you are doing this outside of Bodington then you should be able to 
join the Event table to the Objects table and then to the Classes table 
to find out the event type. Although you will still need a mapping for 
the event type codes to event class constants.

-- 
  -- Matthew Buckett, VLE Developer
  -- Learning Technologies Group, Oxford University Computing Services
  -- Tel: +44 (0)1865 283660 http://www.oucs.ox.ac.uk/ltg/