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:
Code:
 mysql> select basename, title from recorded;
we then need to create a UNIX symbolic link from the basename to the title
Code:
 ln -s $basename /nfsexports/$title
can anyone help with this?
some php/perl/python etc to tie these things up would be really helpful