Tim,
I fetched all the records from the files table and matched by "contextid","component" ,"filearea" and "filename" and retrieved the filename hash.
From the filename hash, I get the file path and filename.I am able to get the files, I hope this is the correcct approach.
Also in the modinfo, for "mod=resource" sometimes the URL is resource/view.php?id=...... and sometimes it is pluginfile.php?......How do i make it point to pluginfile all the time?