', "\n";
echo '', "\n";
echo '', $artist_name, '
', "\n";
echo 'Created: ', pg_result($artists_res, $artist_row, 1), '
', "\n";
echo 'Website: ', $artist_site, '
', "\n";
echo '(Edit Artist)', "\n";
echo ' | ',"\n";
echo '
', "\n";
echo '', "\n";
echo '', "\n";
$songs_res = pg_exec($db, "select id, created, title, lyrics, license, length from songs where owner='$uid' and artist='$artist'");
if (pg_numrows($songs_res) == 0) {
// no songs for artist
}
for ($song_row = 0; $song_row < pg_numrows($songs_res); $song_row++) {
$song = pg_result($songs_res, $song_row, 0);
echo '', "\n";
echo '', "\n";
echo '| ', pg_result($songs_res, $song_row, 2), ' | ', "\n";
echo ' ', "\n";
echo '', "\n";
echo '', "\n";
echo 'Created: ', pg_result($songs_res, $song_row, 1), '
', "\n";
$license = pg_result($songs_res, $song_row, 4);
echo 'License: ', license_summary($license), '
', "\n";
// fixme: show lyrics, and maybe artist, length
echo '(Choose License)
', "\n";
echo '(Edit Song)', "\n";
echo ' | ', "\n";
echo '', "\n";
$afs_res = pg_exec($db, "select id, filesize, format from audiofiles where owner='$uid' and song='$song'");
if (pg_numrows($afs_res) == 0) {
// no audiofiles for song
}
for ($af_row = 0; $af_row < pg_numrows($afs_res); $af_row++) {
echo '', "\n";
echo '', "\n";
echo '| ', "\n";
echo pg_result($afs_res, $af_row, 2), ', ', pg_result($afs_res, $af_row, 1), ' bytes', "\n";
echo ' | ', "\n";
echo ' ', "\n";
echo '', "\n";
echo '', "\n";
$af = pg_result($afs_res, $af_row, 0);
$available_res = pg_exec($db, "select url from available where owner='$uid' and audiofile='$af'");
if (pg_numrows($available_res) == 0) {
// no mirror for audiofile
} else if (pg_numrows($available_res) > 1) {
echo 'Mirrors:
', "\n";
}
for ($available_row = 0; $available_row < pg_numrows($available_res); $available_row++) {
$available_url = pg_result($available_res, $available_row, 0);
echo '', $available_url, '
', "\n";
}
pg_freeresult($available_res);
echo ' | ', "\n";
echo ' ', "\n";
echo ' ', "\n";
}
pg_freeresult($afs_res);
echo ' | ', "\n";
echo ' ', "\n";
echo ' ', "\n";
}
pg_freeresult($songs_res);
echo ' | ', "\n";
echo '
', "\n";
echo '