use breadcrumbs for directories and files

[Fuse-DBI] / examples / strix-static3.pl

diff --git a/examples/strix-static3.pl b/examples/strix-static3.pl
index f49c947..15fa6e0 100755 (executable)
--- a/examples/strix-static3.pl
+++ b/examples/strix-static3.pl
@@ -42,11 +42,12 @@ unless (-w $mount) {
 my $sql = {
        'filenames' => q{
                select
-                       layout_id as id,
-                       layout_id||'-'||title||'.html' as filename,
+                       layout_id as id,
+                       replace(getpathfromnav(kategorija_id),' > ','/')||'/'||title||'.html' as filename,
                        length(content) as size,
                        true as writable
-               from static3
+               from static3, layout
+               where static3.layout_id = layout.id
        },
        'read' => q{
                select content