[OT] Help to find the covers by SQL

[Ian Monroe]

On 9/24/06, Iñaki <ibc2 at euskalnet.net> wrote:
> Hello, I'm developing a small Rails web application to show the Amarok MySQL
> collection.
>
> My only problem is to find the cover filename of each album. I want to show
> the files of 150px in "$HOME/.kde/share/apps/amarok/albumcovers/cache".

If all you want are the covers in
~/.kde/share/apps/amarok/albumcovers/ your going about it the wrong
way. Those covers are just an MD5 hash of the artist and the album.
Refer to the Amarok source or the copycover script available on
kde-apps.org if you need further reference.