aboutsummaryrefslogtreecommitdiff
path: root/common
diff options
context:
space:
mode:
Diffstat (limited to 'common')
-rw-r--r--common/functions.php171
-rw-r--r--common/navbar.php98
-rw-r--r--common/navbarjs.php151
3 files changed, 420 insertions, 0 deletions
diff --git a/common/functions.php b/common/functions.php
new file mode 100644
index 0000000..a0a953e
--- /dev/null
+++ b/common/functions.php
@@ -0,0 +1,171 @@
+<?php
+// sqlite datehbank ahfigge
+$db = new SQLite3($websiteConfig['database']);
+
+// so luegele ob mer navbar sache mache oder ob d'websihte wahrschiinlich so sidebar style wird
+$navbarTableExists = $db->querySingle("SELECT name FROM sqlite_master WHERE type='table' AND name='navbar'");
+$navbarHasEntries = $db->querySingle("SELECT COUNT(*) FROM navbar") > 0;
+
+// mis wunderschöne url handling ✨
+$page = isset($_GET['page']) ? htmlspecialchars($_GET['page']) : 'index';
+$sub = isset($_GET['sub']) ? htmlspecialchars($_GET['sub']) : null;
+$offset = isset($_GET['offset']) ? (int)$_GET['offset'] : 0;
+$limit = 10; // Number of posts per load
+$menuExpanded = isset($_GET['menu']) ? (bool)$_GET['menu'] : false;
+
+// overflow protection oder so cha kei cybersecurity
+if ($offset < 0) {
+ $offset = 0;
+}
+
+// schlimmste funktion eveer für breadcrumbs aber es funktioniert leider
+function get_full_path($db, $page, $sub = null) {
+ $path = [];
+ $current_page = $sub ?: $page; // If sub is set of posts benutzen sub suscht halt page
+
+ while ($current_page) {
+ $query = $db->prepare('SELECT parent, title, page FROM pages WHERE page = :page');
+ $query->bindValue(':page', $current_page, SQLITE3_TEXT);
+ $result = $query->execute()->fetchArray(SQLITE3_ASSOC);
+
+ if ($result) {
+ array_unshift($path, [
+ 'title' => $result['title'],
+ 'page' => $result['page']
+ ]);
+ $current_page = $result['parent']; // eltere vor d'füess schiebe
+ } else {
+ break;
+ }
+ }
+ return $path;
+}
+
+$breadcrumbs = get_full_path($db, $page, $sub);
+
+// siihte metadata mache und so
+$metaQuery = $db->prepare('SELECT meta_description, parent FROM pages WHERE page = :page AND (parent IS NULL OR parent = :parent)');
+$metaQuery->bindValue(':page', $page, SQLITE3_TEXT);
+$metaQuery->bindValue(':parent', $sub, SQLITE3_TEXT);
+$metaResult = $metaQuery->execute()->fetchArray(SQLITE3_ASSOC);
+$metaDescription = $metaResult ? htmlspecialchars($metaResult['meta_description'] ?? '', ENT_QUOTES, 'UTF-8') : 'Default description of the website.';
+
+// mal gügsle wiviel posts es git hmmm 🤔 lol
+$countQuery = $db->prepare('SELECT COUNT(*) as total FROM content WHERE page = :page AND (parent IS NULL OR parent = :sub)');
+$countQuery->bindValue(':page', $page, SQLITE3_TEXT);
+$countQuery->bindValue(':sub', $sub, SQLITE3_TEXT);
+$totalPosts = $countQuery->execute()->fetchArray(SQLITE3_ASSOC)['total'];
+
+// offset dörf nid grösser sii als total posts will susch depressione
+if ($offset > $totalPosts) {
+ $offset = $totalPosts - ($totalPosts % $limit);
+}
+
+// ALLI POSTS ABRÜefe bitte ned ahlange susch hühl ich
+$query = $db->prepare('SELECT title, content, date FROM content WHERE page = :page ORDER BY date DESC LIMIT :limit OFFSET :offset');
+$query->bindValue(':page', $sub ? $sub : $page, SQLITE3_TEXT);
+$query->bindValue(':limit', $offset + $limit, SQLITE3_INTEGER);
+$query->bindValue(':offset', 0, SQLITE3_INTEGER); // immer alli posts holeh will was isch normali site pagination
+$result = $query->execute();
+
+// het page überhaupt was drufeh oder so ?
+$hasContent = $result->fetchArray() !== false;
+if ($hasContent) {
+ // Reset the result pointer
+ $result->reset();
+}
+
+// haben das linke sidebar sache?
+$leftSidebarHasItems = $db->querySingle("SELECT COUNT(*) FROM sidebar WHERE position='left'") > 0;
+
+// haben das rechte sidebar sache?
+$rightSidebarHasItems = $db->querySingle("SELECT COUNT(*) FROM sidebar WHERE position='right'") > 0;
+
+// das isch fett schaisse und ich ha kein plan ki het gseit das fixts und so ich ha kei lust meh gha ha nach 2 stund 😭
+function sameQueryParams(string $url1, string $url2): bool {
+ $parsed1 = parse_url($url1);
+ $parsed2 = parse_url($url2);
+
+ $params1 = [];
+ $params2 = [];
+ if (!empty($parsed1['query'])) {
+ parse_str($parsed1['query'], $params1);
+ }
+ if (!empty($parsed2['query'])) {
+ parse_str($parsed2['query'], $params2);
+ }
+
+ return $params1 == $params2;
+}
+
+// isch das total behindert und komplett losti ahgangs wiihs ? ja ... aber es funktioniert leider echt kei bock meh fr fr die grüene sind schuld
+function get_sidebar($db, $position, $page, $sub) {
+ $query = $db->prepare('
+ SELECT title, link, link_text
+ FROM sidebar
+ WHERE position = :position
+ ORDER BY id
+ ');
+ $query->bindValue(':position', $position, SQLITE3_TEXT);
+ $result = $query->execute();
+
+ if (!$result || !$result->fetchArray(SQLITE3_ASSOC)) {
+ return; // effizienz versuech will die ganz funktion müll isch ach mannn 😭
+ }
+ $result->reset();
+ $lastTitle = "";
+ // Bob der baumeister spileh und $activeLink zemme bastle
+ $queryString = parse_url($_SERVER['REQUEST_URI'], PHP_URL_QUERY) ?? ''; // luege das ned null isch will susch motzts
+ parse_str($queryString, $queryParams);
+
+ $activeParts = ["?page=" . ($queryParams['page'] ?? '')];
+ if (!empty($queryParams['sub'])) {
+ if (is_array($queryParams['sub'])) {
+ foreach ($queryParams['sub'] as $subParam) {
+ $activeParts[] = "sub=" . $subParam;
+ }
+ } else {
+ $activeParts[] = "sub=" . $queryParams['sub'];
+ }
+ }
+ $activeLink = implode("&", $activeParts);
+
+ $foundActive = false;
+
+ while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
+ // new post oh mein gott so spannend mached mer grad neue title
+ if ($row['title'] !== $lastTitle) {
+ if ($lastTitle !== "") {
+ echo '</div>';
+ }
+ echo '<div class="box"><h3>' . htmlspecialchars($row['title']) . '</h3>';
+ $lastTitle = $row['title'];
+ }
+
+ // externi links z'erchäne wär inteligent schickiert
+ if (filter_var($row['link'], FILTER_VALIDATE_URL)) {
+ echo '<p><a href="'
+ . htmlspecialchars($row['link'])
+ . '" target="_blank">'
+ . htmlspecialchars($row['link_text'])
+ . '</a></p>';
+ } else {
+ // robuster mache und so lönd mich ihn rueh
+ $activeClass = '';
+ if (!$foundActive && sameQueryParams($row['link'], $activeLink)) {
+ $activeClass = 'active';
+ $foundActive = true;
+ }
+
+ echo '<p><a href="'
+ . htmlspecialchars($row['link'], ENT_QUOTES, 'UTF-8')
+ . '" class="' . $activeClass . '">'
+ . htmlspecialchars($row['link_text'])
+ . '</a></p>';
+ }
+ }
+ if ($lastTitle !== "") {
+ echo '</div>';
+ }
+}
+?> \ No newline at end of file
diff --git a/common/navbar.php b/common/navbar.php
new file mode 100644
index 0000000..681f176
--- /dev/null
+++ b/common/navbar.php
@@ -0,0 +1,98 @@
+<?php
+if ($navbarTableExists && $navbarHasEntries) {
+ // Fetch navbar items from the database and render them for nicht behindertes navbar ohni js <3
+ $navbarItems = [];
+ $navbarResult = $db->query("SELECT * FROM navbar ORDER BY id");
+ while ($row = $navbarResult->fetchArray(SQLITE3_ASSOC)) {
+ $navbarItems[] = $row;
+ }
+
+ // Function to render the navbar items im grosse navbar für normali mensche
+ function render_navbar($items, $currentPage) {
+ $leftItems = array_filter($items, fn($item) => $item['align'] === 'left');
+ $centerItems = array_filter($items, fn($item) => $item['align'] === 'center');
+ $rightItems = array_filter($items, fn($item) => $item['align'] === 'right');
+
+ echo '<div class="navbar-left">';
+ render_navbar_items($leftItems, $currentPage);
+ echo '</div>';
+ echo '<div class="navbar-center">';
+ render_navbar_items($centerItems, $currentPage);
+ echo '</div>';
+ echo '<div class="navbar-right">';
+ render_navbar_items($rightItems, $currentPage);
+ echo '</div>';
+ }
+
+ function render_navbar_items($items, $currentPage) {
+ foreach ($items as $item) {
+ $activeClass = ($item['link'] == "?page=$currentPage") ? ' class="active"' : '';
+ switch ($item['type']) {
+ case 'title':
+ echo '<span class="navbar-title">' . htmlspecialchars($item['name']) . '</span>';
+ break;
+ case 'link':
+ echo '<a href="' . htmlspecialchars($item['link']) . '"' . $activeClass . '>' . htmlspecialchars($item['name']) . '</a>';
+ break;
+ case 'drop down':
+ echo '<div class="navbar-dropdown">';
+ echo '<a class="navbar-dropbtn" href="#">' . htmlspecialchars($item['name']) . '</a>';
+ echo '<div class="navbar-dropdown-content">';
+ foreach ($items as $dropdownItem) {
+ if ($dropdownItem['type'] === 'drop down entry' && $dropdownItem['name'] === $item['name']) {
+ echo '<a href="' . htmlspecialchars($dropdownItem['link']) . '">' . htmlspecialchars($dropdownItem['link_text']) . '</a>';
+ }
+ }
+ echo '</div>';
+ echo '</div>';
+ break;
+ case 'text field':
+ echo '<input type="text" placeholder="' . htmlspecialchars($item['name']) . '">';
+ break;
+ case 'button':
+ echo '<button onclick="location.href=\'' . htmlspecialchars($item['link']) . '\'">' . htmlspecialchars($item['name']) . '</button>';
+ break;
+ case 'custom':
+ echo $item['link_text'];
+ break;
+ case 'logo':
+ echo '<img src="' . htmlspecialchars($item['link']) . '" alt="' . htmlspecialchars($item['name']) . '" class="navbar-logo">';
+ break;
+ case 'search':
+ echo '<input type="search" placeholder="' . htmlspecialchars($item['name']) . '">';
+ break;
+ }
+ }
+ }
+
+ // Function to render the mobile navbar für behindertes hamburger menu
+ function render_mobile_navbar($items, $menuExpanded) {
+ echo '<div class="mobile-navbar-panel">';
+ echo '<div class="navbar-header">';
+
+ foreach ($items as $item) {
+ if ($item['type'] === 'logo') {
+ echo '<img src="' . htmlspecialchars($item['link']) . '" alt="' . htmlspecialchars($item['name']) . '" class="navbar-logo">';
+ }
+ if ($item['type'] === 'title') {
+ echo '<span class="navbar-title">' . htmlspecialchars($item['name']) . '</span>';
+ }
+ }
+
+ $toggleState = $menuExpanded ? 0 : 1;
+ echo '<form method="get" action="" style="display:inline;">';
+ echo '<input type="hidden" name="menu" value="' . $toggleState . '">';
+ echo '<button type="submit" class="navbar-toggle">' . ($menuExpanded ? 'Collapse' : 'Expand') . '</button>';
+ echo '</form>';
+ echo '</div>';
+ echo '</div>';
+
+ // Separate the menu from the navbar panel will mir ned ganz normali mensche sind und euses menu mit post uf und zue gaht
+ if ($menuExpanded) {
+ echo '<div class="mobile-navbar-menu">';
+ render_navbar_items(array_filter($items, fn($item) => $item['type'] !== 'logo' && $item['type'] !== 'title'), '');
+ echo '</div>';
+ }
+ }
+}
+?> \ No newline at end of file
diff --git a/common/navbarjs.php b/common/navbarjs.php
new file mode 100644
index 0000000..28aa549
--- /dev/null
+++ b/common/navbarjs.php
@@ -0,0 +1,151 @@
+<?php
+function render_navbar_js($db) {
+ // Fetch navbar items from the database and render them for behindertes dreckiges js navbar ... ich bin mal fullstack php dev gsi vor 5 jahr und jetzt machi das hier... 🤡
+ $navbarQuery = $db->query("SELECT * FROM navbar ORDER BY id");
+ $navbarItems = [];
+ while ($row = $navbarQuery->fetchArray(SQLITE3_ASSOC)) {
+ $navbarItems[] = $row;
+ }
+
+ echo '<nav class="navbar">';
+ echo '<div class="navbar-container">';
+ echo '<div class="navbar-left">';
+ foreach ($navbarItems as $item) {
+ $link = htmlspecialchars($item['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $name = htmlspecialchars($item['name'] ?? '', ENT_QUOTES, 'UTF-8');
+
+ if ($item['type'] === 'logo') {
+ echo '<img class="navbar-logo" src="' . $link . '" alt="' . $name . '">';
+ } elseif ($item['type'] === 'title') {
+ echo '<a href="index.php" class="navbar-title">' . $name . '</a>';
+ } elseif ($item['align'] === 'left' && $item['type'] === 'link') {
+ echo '<a class="navbar-link" href="' . $link . '">' . $name . '</a>';
+ } elseif ($item['align'] === 'left' && $item['type'] === 'button') {
+ echo '<button class="buttonify" onclick="location.href=\'' . $link . '\'">' . $name . '</button>';
+ } elseif ($item['align'] === 'left' && $item['type'] === 'text field') {
+ echo '<input type="text" placeholder="' . $name . '">';
+ } elseif ($item['align'] === 'left' && $item['type'] === 'search') {
+ echo '<input type="search" placeholder="' . $name . '">';
+ } elseif ($item['align'] === 'left' && $item['type'] === 'drop down') {
+ echo '<div class="navbar-dropdown">';
+ echo '<button class="navbar-dropbtn" onclick="location.href=\'' . $link . '\'">' . $name . '</button>';
+ echo '<div class="navbar-dropdown-content">';
+ foreach ($navbarItems as $dropdownItem) {
+ if ($dropdownItem['type'] === 'drop down entry' && $dropdownItem['name'] === $item['name']) {
+ $dropdownLink = htmlspecialchars($dropdownItem['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $dropdownLinkText = htmlspecialchars($dropdownItem['link_text'] ?? '', ENT_QUOTES, 'UTF-8');
+ echo '<a class="dropdown-link" href="' . $dropdownLink . '">' . $dropdownLinkText . '</a>';
+ }
+ }
+ echo '</div>';
+ echo '</div>';
+ }
+ }
+ echo '</div>';
+
+ echo '<div class="navbar-center">';
+ foreach ($navbarItems as $item) {
+ $link = htmlspecialchars($item['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $name = htmlspecialchars($item['name'] ?? '', ENT_QUOTES, 'UTF-8');
+
+ if ($item['align'] === 'center') {
+ if ($item['type'] === 'link') {
+ echo '<a class="navbar-link" href="' . $link . '">' . $name . '</a>';
+ } elseif ($item['type'] === 'button') {
+ echo '<button class="buttonify" onclick="location.href=\'' . $link . '\'">' . $name . '</button>';
+ } elseif ($item['type'] === 'text field') {
+ echo '<input type="text" placeholder="' . $name . '">';
+ } elseif ($item['type'] === 'search') {
+ echo '<input type="search" placeholder="' . $name . '">';
+ } elseif ($item['type'] === 'drop down') {
+ echo '<div class="navbar-dropdown">';
+ echo '<button class="navbar-dropbtn" onclick="location.href=\'' . $link . '\'">' . $name . '</button>';
+ echo '<div class="navbar-dropdown-content">';
+ foreach ($navbarItems as $dropdownItem) {
+ if ($dropdownItem['type'] === 'drop down entry' && $dropdownItem['name'] === $item['name']) {
+ $dropdownLink = htmlspecialchars($dropdownItem['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $dropdownLinkText = htmlspecialchars($dropdownItem['link_text'] ?? '', ENT_QUOTES, 'UTF-8');
+ echo '<a class="dropdown-link" href="' . $dropdownLink . '">' . $dropdownLinkText . '</a>';
+ }
+ }
+ echo '</div>';
+ echo '</div>';
+ }
+ }
+ }
+ echo '</div>';
+
+ echo '<div class="navbar-right">';
+ foreach ($navbarItems as $item) {
+ $link = htmlspecialchars($item['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $name = htmlspecialchars($item['name'] ?? '', ENT_QUOTES, 'UTF-8');
+
+ if ($item['align'] === 'right') {
+ if ($item['type'] === 'link') {
+ echo '<a class="navbar-link" href="' . $link . '">' . $name . '</a>';
+ } elseif ($item['type'] === 'button') {
+ echo '<button class="buttonify" onclick="location.href=\'' . $link . '\'">' . $name . '</button>';
+ } elseif ($item['type'] === 'text field') {
+ echo '<input type="text" placeholder="' . $name . '">';
+ } elseif ($item['type'] === 'search') {
+ echo '<input type="search" placeholder="' . $name . '">';
+ } elseif ($item['type'] === 'drop down') {
+ echo '<div class="navbar-dropdown">';
+ echo '<button class="navbar-dropbtn" onclick="location.href=\'' . $link . '\'">' . $name . '</button>';
+ echo '<div class="navbar-dropdown-content">';
+ foreach ($navbarItems as $dropdownItem) {
+ if ($dropdownItem['type'] === 'drop down entry' && $dropdownItem['name'] === $item['name']) {
+ $dropdownLink = htmlspecialchars($dropdownItem['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $dropdownLinkText = htmlspecialchars($dropdownItem['link_text'] ?? '', ENT_QUOTES, 'UTF-8');
+ echo '<a class="dropdown-link" href="' . $dropdownLink . '">' . $dropdownLinkText . '</a>';
+ }
+ }
+ echo '</div>';
+ echo '</div>';
+ }
+ }
+ }
+ echo '</div>';
+ echo '</div>';
+
+ echo '<div class="navbar-mobile">';
+ echo '<div class="navbar-left">';
+ foreach ($navbarItems as $item) {
+ $link = htmlspecialchars($item['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $name = htmlspecialchars($item['name'] ?? '', ENT_QUOTES, 'UTF-8');
+
+ if ($item['type'] === 'logo') {
+ echo '<img class="navbar-logo" src="' . $link . '" alt="' . $name . '">';
+ } elseif ($item['type'] === 'title') {
+ echo '<a href="index.php" class="navbar-title">' . $name . '</a>';
+ }
+ }
+ echo '</div>';
+ echo '<button class="navbar-toggle" onclick="toggleNavbar()">☰</button>';
+ echo '</div>';
+
+ echo '<div class="mobile-navbar-menu">';
+ foreach ($navbarItems as $item) {
+ $link = htmlspecialchars($item['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $name = htmlspecialchars($item['name'] ?? '', ENT_QUOTES, 'UTF-8');
+
+ if ($item['type'] === 'link') {
+ echo '<a class="navbar-link bruh-why" href="' . $link . '">' . $name . '</a>';
+ } elseif ($item['type'] === 'drop down') {
+ echo '<span class="mobile-navbar-dropdown" onclick="location.href=\'' . $link . '\'">' . $name . '</span>';
+ } elseif ($item['type'] === 'drop down entry') {
+ $dropdownLink = htmlspecialchars($item['link'] ?? '', ENT_QUOTES, 'UTF-8');
+ $dropdownLinkText = htmlspecialchars($item['link_text'] ?? '', ENT_QUOTES, 'UTF-8');
+ echo '<a class="dropdown-link" href="' . $dropdownLink . '" class="mobile-dropdown-entry">↳ ' . $dropdownLinkText . '</a>';
+ } elseif ($item['type'] === 'button') {
+ echo '<button class="buttonify" onclick="location.href=\'' . $link . '\'">' . $name . '</button>';
+ } elseif ($item['type'] === 'text field') {
+ echo '<input type="text" placeholder="' . $name . '">';
+ } elseif ($item['type'] === 'search') {
+ echo '<input type="search" placeholder="' . $name . '">';
+ }
+ }
+ echo '</div>';
+ echo '</nav>';
+}
+?> \ No newline at end of file
generated by cgit v1.2.3-70-g09d2 (git 2.46.0) at 2025-04-05 11:56:13 +0000