Changeset 682d504 in Klonkt for src/routes
- Timestamp:
- 06/16/2026 06:49:32 PM (3 months ago)
- Branches:
- main
- Children:
- 62b899d
- Parents:
- 1be21ba
- File:
-
- 1 edited
-
src/routes/circle.js (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
src/routes/circle.js
r1be21ba r682d504 58 58 }); 59 59 60 // Sites in de cirkel (alleen succesvol gesyncte = proto-compatibel) — voor de 61 // grafische header met avatars. 62 const sites = db.prepare('SELECT name, url, avatar FROM remote_actors ORDER BY name') 63 .all() 60 // Sites in de cirkel — alleen actieve links (outdated/error vallen weg, net als 61 // hun posts). Voor de grafische header met avatars. 62 const sites = db.prepare(` 63 SELECT a.name, a.url, a.avatar 64 FROM remote_actors a 65 JOIN circle_links l ON l.remote_actor_id = a.id 66 WHERE l.status = 'active' 67 ORDER BY a.name 68 `).all() 64 69 .map((s) => ({ 65 70 name: s.name || 'Onbekend',
Note:
See TracChangeset
for help on using the changeset viewer.
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)