From e143770fc296e34862d95272fc79a56fa9d20a34 Mon Sep 17 00:00:00 2001
From: Georgi Nikolov <ggeorgi60@gmail.com>
Date: Sat, 25 Jan 2025 17:01:26 +0200
Subject: Added additional table column for the favicon in the database

With that commit handled the saving of that favicon as well
---
 models/webpage.php | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

(limited to 'models/webpage.php')

diff --git a/models/webpage.php b/models/webpage.php
index 1a2f4a6..5dd44e0 100644
--- a/models/webpage.php
+++ b/models/webpage.php
@@ -9,12 +9,13 @@ class Webpage extends Table {
     public $Date;
     public $Visits;
     public $RequesterUID;
+    public $FaviconPath;
 
-    static function create(string $Path, string $URL, int $RequesterUID) : int {
+    static function create(string $Path, string $URL, int $RequesterUID, string $FaviconPath) : int {
         return Table::_create(
             'Webpages',
-            '(Path, URL, Date, Visits, RequesterUID)',
-            "(\"$Path\", \"$URL\", (NOW() + INTERVAL 2 HOUR), 0, \"$RequesterUID\")"
+            '(Path, URL, Date, Visits, RequesterUID, FaviconPath)',
+            "(\"$Path\", \"$URL\", (NOW() + INTERVAL 2 HOUR), 0, \"$RequesterUID\", \"$FaviconPath\")"
         );
     }
 
@@ -25,6 +26,10 @@ class Webpage extends Table {
         );
     }
 
+    static function getPagesCount() : int {
+        return Table::_get_entries_count("Webpages");
+    }
+
     static function mostVisited(int $count) : array {
         return Table::_get_all(
             'Webpages',
-- 
cgit v1.2.3