I'm working on a film site and need to log some custom information about a user's activity. On the site you can click a play button to start watching a film. (This link just takes you to Amazon Instant.) When a logged-in user clicks to start watching the film, I need to:
- Set a "watching" flag in their account denoting that they started watching
- Next time they load a page on the site I need to check to see if they're "watching" any films;
- If they are "watching" a film I need to display a modal that asks them to rate the film.
I know EE allows you to run queries as you see fit. Wondering if there is a recommended way to log and retrieve data that doesn't necessarily exist in the EE interface?