Moodle and MythTV integration

[CyberNerd]

background:

We have a mythtv server with mythweb - our librarian records programs for teachers and sends them a link.

We'd like to integrate this into Moodle 2.0 so that teachers can select files from a moodle repository that resides on the mythtv server.

 

solution:

we mount a partition of the mythtv server onto the webserver

 

problem:

mythtv saves files by a datestamp.mpg and holds the title in a database

 

the database query we need is:

 mysql> select basename, title from recorded; 

 

we then need to create a UNIX symbolic link from the basename to the title

 ln -s $basename /nfsexports/$title

 

can anyone help with this?

some php/perl/python etc to tie these things up would be really helpful