Hello,
 
I wanted to have the mediatype image displayed in the web list, but I didn't liked the hardcoded "mediatype name prefix" used for the pdf export.  I added an "image" row in the "mediatypes" table with the image filename relative to pictures/media, and here is the little patch, with the modern template updated.
If somoene else find it useful...
 
Thanks again for this soft, it helps me everyday !
 
Robert
 
===================================================================
Index: index.php
===================================================================
RCS file: /cvsroot/videodb/videodb/index.php,v
retrieving revision 2.49
diff -r2.49 index.php
168c168
<                   lastupdate, mediatype,
---
>                   lastupdate, mediatype, mediatypes.image AS mediaimage,
177a178,179
>              LEFT JOIN mediatypes
>                ON videodata.mediatype = mediatypes.id
Index: search.php
===================================================================
RCS file: /cvsroot/videodb/videodb/search.php,v
retrieving revision 2.21
diff -r2.21 search.php
150c150
<                     custom3, custom4, created,
---
>                     custom3, custom4, created, mediatypes.image AS mediaimage,
Index: core/pdf.php
===================================================================
RCS file: /cvsroot/videodb/videodb/core/pdf.php,v
retrieving revision 1.9
diff -r1.9 pdf.php
277c277
<                    mediatypes.name AS mediatype
---
>                    mediatypes.name AS mediatype, mediatypes.image AS mediaimage
336,337c336
<         $mediatype = $row['mediatype'];
<         if (preg_match("/^(DVD|DivX|CD|VCD|SVCD|VHS)/i", $mediatype, $matches))
---
>         if ($row['mediaimage'])
339,345c338
<             $type_image = strtolower($matches[1]).'.png';
<         }
<         else $type_image = '';
<
<         if ($type_image)
<         {
<             $pdf->Image('./images/media/'.$type_image, 190, $ypos-2, 8, 0, '', '');
---
>             $pdf->Image('./images/media/'.$row['mediaimage'], 190, $ypos-2, 8, 0, '', '');
Index: templates/modern/list.tpl
===================================================================
RCS file: /cvsroot/videodb/videodb/templates/modern/list.tpl,v
retrieving revision 2.22
diff -r2.22 list.tpl
65a66,73
>    {if $video.mediaimage }
>     {if $listcolumns == 1}</td>
>      <td valign="middle" align="center" nowrap="nowrap" style="text-align:center">
>     {/if}
>     <img src="./images/media/{$video.mediaimage}" border="0"/>
>    {/if}
>       
>