', "\n"; ?> ', "\n"; } $lyrics = pg_result($songs_res, $song, 4); if ($lyrics) { echo ' ', "\n", nl2br(htmlentities(lyrics, ENT_NOQUOTES)), ' ', "\n"; } echo '', "\n"; echo "\n"; for ($af = 0; $af < pg_numrows($afs_res); $af++) { echo '', "\n"; $available_res = pg_exec($db, "select url from available where owner='$uid' and audiofile='" . pg_result($afs_res, $af, 0) . "'"); for ($available = 0; $available < pg_numrows($available_res); $available++) { echo ' ', "\n"; } pg_freeresult($available_res); echo ' ', "\n"; echo ' ', "\n"; echo ' ', pg_result($afs_res, $af, 4), '', "\n"; echo ' ', pg_result($afs_res, $af, 3), '', "\n"; echo ' ', pg_result($afs_res, $af, 2), '', "\n"; echo '', "\n"; echo "\n"; } pg_freeresult($afs_res); } pg_freeresult($songs_res); $artists_res = pg_exec($db, "select rdf_id, name, website from artists where owner='$uid' and rdf_file='$id'"); for ($artist = 0; $artist < pg_numrows($artists_res); $artist++) { echo '', "\n"; echo ' ', htmlentities(pg_result($artists_res, $artist, 1), ENT_NOQUOTES), '', "\n"; if (pg_result($artists_res, $artist, 2)) echo ' ', "\n"; echo '', "\n"; echo "\n"; } pg_freeresult($artists_res); $artists_res = pg_exec($db, "select rdf_id, name, website, url from artists, rdf_files where rdf_file=rdf_files.id and artists.owner='$uid' and rdf_file != '$id' and artists.id in (select artist from songs where owner='$uid' and rdf_file='$id')"); for ($artist = 0; $artist < pg_numrows($artists_res); $artist++) { echo '', "\n"; echo ' ', htmlentities(pg_result($artists_res, $artist, 1), ENT_NOQUOTES), '', "\n"; echo ' ', "\n"; echo '', "\n"; echo "\n"; } pg_freeresult($artists_res); $licenses_res = pg_exec($db, "select license_url, rdf from license_descriptions where license_url in (select license from songs where rdf_file='$id')"); for ($license = 0; $license < pg_numrows($licenses_res); $license++) { echo pg_result($licenses_res, $license, 1), "\n"; } pg_freeresult($licenses_res); ?>