Added additional table column for the favicon in the database

With that commit handled the saving of that favicon as well

1 files changed, 8 insertions, 3 deletions

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',