Desagertutako multimedia fitxategien kasua

<p>&nbsp;</p>
<style type="text/css">
select{max-width:200px;}</style>
<?php

if(isset($_POST['fid'])){
foreach($_POST['fid'] as $k => $v){
if($v > 0){
db_query('UPDATE bideo_lehiaketa SET fid = %d WHERE id = %d', $v, $k);
print sprintf('UPDATE bideo_lehiaketa SET fid = %d WHERE id = %d', $v, $k).'<br/>';
}
}
}

$result = db_query('SELECT fid, filename, filepath FROM files WHERE filepath LIKE "%/koldo-eleizalde/%" AND fid NOT IN (SELECT fid FROM bideo_lehiaketa UNION SELECT argazki FROM bideo_lehiaketa UNION SELECT letra FROM bideo_lehiaketa) ORDER BY fid');

$opts = array('<option value=""></option>');
while($r = db_fetch_object($result)){
$opts[] = '<option value="'.$r->fid.'">'. "$r->fid: $r->filename" .'</option>';
}

$result = pager_query('SELECT id, nid, izenburu, fid, argazki, letra FROM bideo_lehiaketa ORDER BY id', 25);
$rows = array();
while($r = db_fetch_object($result)){
$fid = $r->fid == 0 ? '<select name="fid['.$r->id.']">'.join($opts, '').'</select>' : $r->fid;
$node_link = l($r->nid, "node/$r->nid");
$rows[] = array($r->id, $r->izenburu, $node_link, $fid, $r->argazki, $r->letra);
}

$headers = array('Id', 'Izenburua', 'Nid', 'Multimedia', 'Argazkia', 'Letra');

$output = '';
$output .= '<form method="post">';
$output .= theme('table', $headers, $rows);
$output .= '<input type="submit" name="op" value="gorde" />';
$output .= '</form>';
$output .= theme('pager');

print $output;

?>