summaryrefslogtreecommitdiffstats
path: root/core
diff options
context:
space:
mode:
Diffstat (limited to 'core')
-rw-r--r--core/language/de.php12
-rw-r--r--core/language/en.php12
-rw-r--r--core/namespace/Page/Item.php14
3 files changed, 38 insertions, 0 deletions
diff --git a/core/language/de.php b/core/language/de.php
index a1f8060..5d29d5d 100644
--- a/core/language/de.php
+++ b/core/language/de.php
@@ -159,6 +159,12 @@ $LANGUAGE['delete_post'] = 'Beitrag löschen';
$LANGUAGE['delete_user'] = 'Benutzer löschen';
#===============================================================================
+# Items search
+#===============================================================================
+$LANGUAGE['search_page'] = 'Seiten durchsuchen';
+$LANGUAGE['search_post'] = 'Beiträge durchsuchen';
+
+#===============================================================================
# Item insert titles
#===============================================================================
$LANGUAGE['title_page_insert'] = $LANGUAGE['insert_page'];
@@ -180,6 +186,12 @@ $LANGUAGE['title_post_delete'] = $LANGUAGE['delete_post'];
$LANGUAGE['title_user_delete'] = $LANGUAGE['delete_user'];
#===============================================================================
+# Item search titles
+#===============================================================================
+$LANGUAGE['title_page_search'] = $LANGUAGE['search_page'];
+$LANGUAGE['title_post_search'] = $LANGUAGE['search_post'];
+
+#===============================================================================
# Item overview titles
#===============================================================================
$LANGUAGE['title_page_overview'] = "{$LANGUAGE['page_overview']} [%d]";
diff --git a/core/language/en.php b/core/language/en.php
index 55c0ce3..dc70154 100644
--- a/core/language/en.php
+++ b/core/language/en.php
@@ -159,6 +159,12 @@ $LANGUAGE['delete_post'] = 'Delete post';
$LANGUAGE['delete_user'] = 'Delete user';
#===============================================================================
+# Items search
+#===============================================================================
+$LANGUAGE['search_page'] = 'Search in pages';
+$LANGUAGE['search_post'] = 'Search in posts';
+
+#===============================================================================
# Item insert titles
#===============================================================================
$LANGUAGE['title_page_insert'] = $LANGUAGE['insert_page'];
@@ -180,6 +186,12 @@ $LANGUAGE['title_post_delete'] = $LANGUAGE['delete_post'];
$LANGUAGE['title_user_delete'] = $LANGUAGE['delete_user'];
#===============================================================================
+# Item search titles
+#===============================================================================
+$LANGUAGE['title_page_search'] = $LANGUAGE['search_page'];
+$LANGUAGE['title_post_search'] = $LANGUAGE['search_post'];
+
+#===============================================================================
# Item overview titles
#===============================================================================
$LANGUAGE['title_page_overview'] = "{$LANGUAGE['page_overview']} [%d]";
diff --git a/core/namespace/Page/Item.php b/core/namespace/Page/Item.php
index c6cece7..e3bf6a3 100644
--- a/core/namespace/Page/Item.php
+++ b/core/namespace/Page/Item.php
@@ -25,5 +25,19 @@ class Item extends \Item {
return sha1(implode(NULL, $attributes));
}
+
+ #===============================================================================
+ # Return unique page IDs for search results
+ #===============================================================================
+ public static function getSearchResultIDs($search, \Database $Database): array {
+ $Statement = $Database->prepare(sprintf("SELECT id FROM %s WHERE
+ MATCH(name, body) AGAINST(? IN BOOLEAN MODE) LIMIT 20", Attribute::TABLE));
+
+ if($Statement->execute([$search])) {
+ return $Statement->fetchAll($Database::FETCH_COLUMN);
+ }
+
+ return [];
+ }
}
?> \ No newline at end of file