[CrowleyAJ]

I'm using the Amber skin on a Raspberry Pi. I really like the recommended items feature for TV shows. Unfortunately it doesn't work very well with multiple installations on a shared MySQL library, i.e. if I watched an episode in the living room, the shelf on the bedroom device doesn't get updated. The only way to force an update to the recommended items list seems to be an library update or playing a video. Even marking an episode as watched on the same device doesn't trigger an update.
I would like similar options like the random or recent items: Updating on a timer or updating when returning to the home screen.

The best option would be an update triggered by a database change, though im not sure whether this is possible.

The following would be a possibility for MySQL:

Code:

SELECT UPDATE_TIME FROM information_schema.TABLES WHERE TABLE_SCHEMA='xbmc_master_video78' AND TABLE_NAME = 'episode'