From d0c76376fd736a84c7824d8521c5792060f69086 Mon Sep 17 00:00:00 2001 From: Syndamia Date: Sat, 1 Feb 2025 09:13:33 +0200 Subject: feat(views/list): Show all items in a list --- models/archivelist.php | 11 +++++++++++ views/list/index.php | 6 ++++++ 2 files changed, 17 insertions(+) diff --git a/models/archivelist.php b/models/archivelist.php index 09d5d86..75bee1f 100644 --- a/models/archivelist.php +++ b/models/archivelist.php @@ -38,4 +38,15 @@ class ArchiveList extends Table { "(\"$WID\", \"$this->LID\", \"0\")" ); } + + function allItems() : array { + return Table::_get_all( + 'Webpages', + 'Database\Webpage', + "INNER JOIN ArchiveListsWebpages ON Webpages.WID = ArchiveListsWebpages.WID + WHERE ArchiveListsWebpages.LID = $this->LID + ORDER BY ArchiveListsWebpages.Position ASC", + 'Webpages.*' + ); + } } diff --git a/views/list/index.php b/views/list/index.php index 79402ec..9047fb3 100644 --- a/views/list/index.php +++ b/views/list/index.php @@ -15,6 +15,12 @@

Description ?>

Username ?>

+ allItems() as $webpage): ?> +
+ URL ?> +
+ +

List doesn't exist -- cgit v1.2.3