Changeset 183875b in Klonkt for src/routes/posts.js

Timestamp:

06/20/2026 05:23:08 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

d727e92

Parents:

459acd9

Message:

feat(audio): per-track "open in" Spotify/YouTube/SoundCloud links

New per-track fields link_spotify/link_youtube/link_soundcloud (audio_tracks),
editable in the track editor (https + correct host validated). Shown as small
brand icons per track row in standalone track embeds, albums and playlists —
click opens the track on that service (new tab). buster audio.css?v=8.

Co-Authored-By: Claude <noreply@…>

File:

• src/routes/posts.js (modified) (4 diffs)

src/routes/posts.js

@@ -529 +529 @@
       const placeholders = trackIds.map(() => '?').join(',');
       const rows = db.prepare(`
-        SELECT t.id, t.title, t.artist, t.cover_url, t.credit, t.license, m.filename
+        SELECT t.id, t.title, t.artist, t.cover_url, t.credit, t.license,
+               t.link_spotify, t.link_youtube, t.link_soundcloud, m.filename
         FROM audio_tracks t LEFT JOIN media m ON m.id = t.media_id
         WHERE t.site_id = ? AND t.id IN (${placeholders})
@@ -544 +545 @@
           credit: r.credit || '',
           license: r.license || '',
+          link_spotify: r.link_spotify || '',
+          link_youtube: r.link_youtube || '',
+          link_soundcloud: r.link_soundcloud || '',
           url: audioUrl(r.filename),
         };
@@ -554 +558 @@
       const placeholders = albumNames.map(() => '?').join(',');
       const albumRows = db.prepare(`
-        SELECT t.id, t.title, t.artist, t.album, t.cover_url, t.position, m.filename
+        SELECT t.id, t.title, t.artist, t.album, t.cover_url, t.position,
+               t.link_spotify, t.link_youtube, t.link_soundcloud, m.filename
         FROM audio_tracks t LEFT JOIN media m ON m.id = t.media_id
         WHERE t.site_id = ? AND t.album IN (${placeholders})
@@ -569 +574 @@
           artist: r.artist || '',
           cover: r.cover_url || '',
+          link_spotify: r.link_spotify || '',
+          link_youtube: r.link_youtube || '',
+          link_soundcloud: r.link_soundcloud || '',
         });
       }