Desagertutako multimedia fitxategien kasua
Lotutako hitzak berbaren dagokion sarreran erantsita azalduko dira.
$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).'
'; } } } $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(''); while($r = db_fetch_object($result)){ $opts[] = ''; } $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 ? '' : $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 .= ''; $output .= theme('pager'); print $output; ?>
Batere ez.