-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathbookmarks.php
184 lines (164 loc) · 9.73 KB
/
bookmarks.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
<?php
// Global database/session initialization.
require_once "./config.php";
require_once "./nilacon.php";
if(!isset($_SESSION['loggedin'])){
header("Location: ./login.php?location=" . urlencode($_SERVER['REQUEST_URI']));
exit;
}
$current_folder_id = trim($_GET["folder"]);
?>
<html>
<head>
<title>Browse - Nilamark</title>
<link rel="stylesheet" href="styles.css">
<link rel="icon" href="favicon.svg">
<link rel="manifest" href="pwa-manifest.json">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<?php include 'header.php'; ?>
<?php
$sql = $pdo->prepare("SELECT nm_folders.id,title,parent_folder FROM nm_folders INNER JOIN nm_tree ON nm_folders.id = nm_tree.id WHERE type = 'folder' AND nm_folders.id = :folder ORDER BY title");
$sql->bindParam(":folder", $current_folder_id, PDO::PARAM_STR);
$sql->execute();
$current_folder = $sql->fetch();
$parent_folder_id = $current_folder['parent_folder'] ?? null;
if (!$current_folder) {
$sql = $pdo->prepare("SELECT id,title FROM nm_folders WHERE nm_folders.id = :folder ORDER BY title");
$sql->bindParam(":folder", $current_folder_id, PDO::PARAM_STR);
$sql->execute();
$current_folder = $sql->fetch();
}
if (isset($parent_folder_id)) {
if($parent_folder_id == 1) {
$sql = $pdo->prepare("SELECT title FROM nm_folders WHERE nm_folders.id = :folder");
} else {
$sql = $pdo->prepare("SELECT title,parent_folder FROM nm_folders LEFT OUTER JOIN nm_tree ON nm_folders.id = nm_tree.id WHERE type = 'folder' AND nm_folders.id = :folder");
}
$sql->bindParam(":folder", $parent_folder_id, PDO::PARAM_STR);
$sql->execute();
$parent_folder = $sql->fetch();
if (isset($parent_folder['parent_folder'])) {
if($parent_folder['parent_folder'] == 1) {
$sql = $pdo->prepare("SELECT title FROM nm_folders WHERE nm_folders.id = :folder");
} else {
$sql = $pdo->prepare("SELECT title,parent_folder FROM nm_folders LEFT OUTER JOIN nm_tree ON nm_folders.id = nm_tree.id WHERE type = 'folder' AND nm_folders.id = :folder");
}
$sql->bindParam(":folder", $parent_folder['parent_folder'], PDO::PARAM_STR);
$sql->execute();
$parent2_folder = $sql->fetch();
if (isset($parent2_folder['parent_folder'])) {
if($parent2_folder['parent_folder'] == 1) {
$sql = $pdo->prepare("SELECT title FROM nm_folders WHERE nm_folders.id = :folder");
} else {
$sql = $pdo->prepare("SELECT title,parent_folder FROM nm_folders LEFT OUTER JOIN nm_tree ON nm_folders.id = nm_tree.id WHERE type = 'folder' AND nm_folders.id = :folder");
}
$sql->bindParam(":folder", $parent2_folder['parent_folder'], PDO::PARAM_STR);
$sql->execute();
$parent3_folder = $sql->fetch();
if (isset($parent3_folder['parent_folder'])) {
if($parent3_folder['parent_folder'] == 1) {
$sql = $pdo->prepare("SELECT title FROM nm_folders WHERE nm_folders.id = :folder");
} else {
$sql = $pdo->prepare("SELECT title,parent_folder FROM nm_folders LEFT OUTER JOIN nm_tree ON nm_folders.id = nm_tree.id WHERE type = 'folder' AND nm_folders.id = :folder");
}
$sql->bindParam(":folder", $parent3_folder['parent_folder'], PDO::PARAM_STR);
$sql->execute();
$parent4_folder = $sql->fetch();
if (isset($parent4_folder['parent_folder'])) {
if($parent4_folder['parent_folder'] == 1) {
$sql = $pdo->prepare("SELECT title FROM nm_folders WHERE nm_folders.id = :folder");
} else {
$sql = $pdo->prepare("SELECT title,parent_folder FROM nm_folders LEFT OUTER JOIN nm_tree ON nm_folders.id = nm_tree.id WHERE type = 'folder' AND nm_folders.id = :folder");
}
$sql->bindParam(":folder", $parent4_folder['parent_folder'], PDO::PARAM_STR);
$sql->execute();
$parent5_folder = $sql->fetch();
}
}
}
}
}
?>
<div id="breadcrumbs">
<?php
if (isset($parent5_folder)) {
echo "<a href='./bookmarks.php?folder=" . $parent4_folder['parent_folder'] . "'>" . $parent5_folder['title'] . "</a><img src='./assets/navigate-next.svg' alt='>'/>";
}
if (isset($parent4_folder)) {
echo "<a href='./bookmarks.php?folder=" . $parent3_folder['parent_folder'] . "'>" . $parent4_folder['title'] . "</a><img src='./assets/navigate-next.svg' alt='>'/>";
}
if (isset($parent3_folder)) {
echo "<a href='./bookmarks.php?folder=" . $parent2_folder['parent_folder'] . "'>" . $parent3_folder['title'] . "</a><img src='./assets/navigate-next.svg' alt='>'/>";
}
if (isset($parent2_folder)) {
echo "<a href='./bookmarks.php?folder=" . $parent_folder['parent_folder'] . "'>" . $parent2_folder['title'] . "</a><img src='./assets/navigate-next.svg' alt='>'/>";
}
if (isset($parent_folder)) {
echo "<a href='./bookmarks.php?folder=" . $parent_folder_id . "'>" . $parent_folder['title'] . "</a><img src='./assets/navigate-next.svg' alt='>'/>";
}
echo "<a href='./bookmarks.php?folder=" . $current_folder['id'] . "'>" . $current_folder['title'] . "</a> <img src='./assets/navigate-next.svg' style='visibility: hidden;' />";
?>
</div>
<div class="result-set">
<h2>Folders:</h2>
<a href="./create-folder.php?parent=<?php echo $current_folder_id; ?>" class="add-button"><img src="./assets/add-circle.svg" /></a>
<?php
$sql = $pdo->prepare("SELECT nm_folders.id,title,parent_folder FROM nm_folders INNER JOIN nm_tree ON nm_folders.id = nm_tree.id WHERE type = 'folder' AND parent_folder = :folder ORDER BY title");
$sql->bindParam(":folder", $current_folder_id, PDO::PARAM_STR);
$sql->execute();
$folders_result = $sql->fetchAll();
if (!empty($folders_result)) {
// output data of each row
foreach($folders_result as &$row) {
echo "<div class='result'>";
echo "<img src='./assets/folder.svg' class='entry-icon' />";
echo "<a class='result-link' href='./bookmarks.php?folder=" . $row["id"] . "'>" . htmlspecialchars($row["title"]) . "</a>";
echo "<a href=./edit-folder.php?folder=" . $row["id"] . "><span class='edit-button'><img src='./assets/edit.svg'/></span></a></div>";
}
echo "<div class='result'>";
echo "<a class='result-link' href='./create-folder.php?parent=" . $current_folder_id . "'>" . "Add new folder..." . "</a>";
echo "<a href='./create-folder.php?parent=" . $current_folder_id . "' class='edit-button'><img src='./assets/add-circle.svg' /></a></div>";
} else {
echo "0 folders";
}
?>
</div>
<div class="result-set">
<h2>Bookmarks:</h2>
<a href="./add.php?parent=<?php echo $current_folder_id; ?>" class="add-button"><img src="./assets/add-circle.svg" /></a>
<?php
$sql = $pdo->prepare("SELECT nm_bookmarks.id,title, url FROM nm_bookmarks INNER JOIN nm_tree ON nm_bookmarks.id = nm_tree.id WHERE type = 'bookmark' AND parent_folder = :folder ORDER BY title");
$sql->bindParam(":folder", $current_folder_id, PDO::PARAM_STR);
$sql->execute();
$sql->execute();
$bookmarks_result = $sql->fetchAll();
if (!empty($bookmarks_result)) {
// output data of each row
foreach($bookmarks_result as &$row) {
echo "<div class='result'>";
/*
$fav = array(
'URL' => $row["url"], // URL of the Page we like to get the Favicon from
'SAVE'=> true, // Save Favicon copy local (true) or return only favicon url (false)
'DIR' => './favicon-storage', // Local Dir the copy of the Favicon should be saved
'TRY' => false, // Try to get the Favicon frome the page (true) or only use the APIs (false)
'DEV' => null, // Give all Debug-Messages ('debug') or only make the work (null)
);*/
$favicon_url = get_favicon($row["url"]);
echo "<img src='". $favicon_url ."' class='entry-icon'>";
echo "<a class='result-link' href='" . $row["url"] . "'>" . htmlspecialchars($row["title"]) . "</a>";
echo "<a href=./edit-bookmark.php?bookmark=" . $row["id"] . "><span class='edit-button'><img src='./assets/edit.svg'/></span></a></div>";
}
echo "<div class='result'>";
echo "<a class='result-link' href='./add.php?parent=" . $current_folder_id . "'>" . "Add new bookmark..." . "</a>";
echo "<a href='./add.php?parent=" . $current_folder_id . "' class='edit-button'><img src='./assets/add-circle.svg' /></a></div>";
} else {
echo "0 bookmarks";
}
?>
</div>
<?php require_once "./footer.php"; ?>
</body>
</html>