which table has lesson linked media details?

which table has lesson linked media details?

Crazy Coder - દ્વારા
Number of replies: 1

I have added a media file in a lesson using lesson settings -> Appearance -> Linked media. I need to know in which table the path of the linked media is stored. I want to get the video URL and pass it in a Webservice for showing it in a mobile application.

Average of ratings: -
In reply to Crazy Coder

Re: which table has lesson linked media details?

Crazy Coder - દ્વારા

I found it myself. Uploaded file details are stored in table 'mdl_files'. I was able to show the file using below code.

$fs = get_file_storage();
$file = $fs->get_file_by_hash(sha1($filepath));
send_stored_file($file, 0, 0);
where $filepath is dynamically generated as below

"/$context->id/mod_lesson/mediafile/0".$lesson->mediafile

Average of ratings: -