From 3c4aa25af0cd6f56db85d503ab552d39b81b5c17 Mon Sep 17 00:00:00 2001
From: horus
Date: Mon, 31 Oct 2022 12:24:35 +0100
Subject: renamed to things

---
 views/things/ghrss/feed.php | 47 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 views/things/ghrss/feed.php

(limited to 'views/things/ghrss/feed.php')

diff --git a/views/things/ghrss/feed.php b/views/things/ghrss/feed.php
new file mode 100644
index 0000000..a11db87
--- /dev/null
+++ b/views/things/ghrss/feed.php
@@ -0,0 +1,47 @@
+<?php
+
+use DiDom\Document;
+use Suin\RSSWriter\Channel;
+use Suin\RSSWriter\Feed;
+use Suin\RSSWriter\Item;
+
+require_once __DIR__ . '/ghrss.db.php';
+require_once __DIR__ . '/vendor/autoload.php';
+
+header("content-type: application/rss+xml");
+
+if ( isset($_REQUEST["l"]) && "" != $_REQUEST["l"] ) {
+	$stmt = $db->prepare("SELECT * FROM entry_view WHERE language = ? ORDER BY created_at DESC LIMIT 20;");
+	$stmt->execute([$_REQUEST["l"]]);
+} else {
+	$stmt = $db->prepare("SELECT * FROM entry_view WHERE created_at >= NOW() - INTERVAL 2 DAY ORDER BY created_at DESC;");
+	$stmt->execute([$_REQUEST["l"]]);
+}
+$result = $stmt->fetchAll();
+
+$feed = new Feed();
+
+$channel = new Channel();       
+$channel
+	->title("GHRSS")              
+	->description("Trending Repos from Github")
+	->url( "https://www.maximilianmoehring.com/things/ghrss/" )
+	->pubDate(strtotime(date("r", time())))
+	->lastBuildDate(strtotime(date("r", time())))
+	->ttl(5)
+	->appendTo($feed);
+
+foreach($result as $item) {
+	$item_out = new Item();
+
+	$item_out
+		->title($item["title"])         
+		->description( "<p>" . $item["synopsis"] . "<br><em>" . $item["language"] . " / " . $item["update_period"] . " / " . $item["stars"] . " Stars</em></p>" )
+		->url($item["url"])            
+		->pubDate(strtotime(date($item["created_at"])))
+		->author($item["owner"])
+		->appendTo($channel);
+}
+
+echo $feed;
+
-- 
cgit v1.2.3