Fitxategien jarraipena (datubasean lotu gabeko fitxategiak)
Lotutako hitzak berbaren dagokion sarreran erantsita azalduko dira.
""
UNION ALL
SELECT "letra" zertan, b.nid, f.fid, f.filename, f.filepath AS path FROM files f
LEFT JOIN bideo_lehiaketa b ON f.fid = b.letra
WHERE b.letra <> ""
UNION ALL
SELECT "argazkia" zertan, b.nid, f.fid, f.filename, f.filepath AS path FROM files f
LEFT JOIN bideo_lehiaketa b ON f.fid = b.argazki
WHERE b.argazki <> ""
UNION ALL
SELECT "nodo eranskin" zertan, u.nid, f.fid, f.filename, f.filepath AS path FROM files f
LEFT JOIN upload u ON f.fid = u.fid
WHERE u.nid <> ""
) AS T ORDER BY path ASC');
$rows = array();
while($r = db_fetch_object($result)){
$file_link = !empty($r->path) ? l($r->filename, $r->path) : '-';
$page_link = !empty($r->nid) ? l($r->nid, "node/$r->nid") : '-';
$row = array($page_link, $r->zertan, $r->fid, $file_link);
$rows[] = $row;
}
$output = '';
$headers = array('Orria', 'Mota', 'FID', 'Fitxategiaren izena');
$output .= theme('table', $headers, $rows);
$output .= theme('pager');
print $output;
?>