use breadcrumbs for directories and files

git-svn-id: svn://svn.rot13.org/fuse_dbi/trunk@58 17f4e80c-d0e0-0310-8903-bfc3ae804c12

diff --git a/examples/strix-multi_static.pl b/examples/strix-multi_static.pl
index 5a22ab8..745300e 100755 (executable)
--- a/examples/strix-multi_static.pl
+++ b/examples/strix-multi_static.pl
@@ -42,11 +42,14 @@ unless (-w $mount) {
 my $sql = {
        'filenames' => q{
                select
-                       id as id,
-                       id||'-'||title||'.html' as filename,
+                       multistatic_id as id,
+                       replace(getpathfromnav(multistatic_navigation.kategorija_id)||' > '||getpathfromms(multistatic_navigation.multistatic_id),' > ','/')||'.html' as filename,
+
                        length(content) as size,
                        true as writable
-               from multistatic
+               from multistatic_navigation,multistatic
+               where multistatic.id = multistatic_id and 
+               not multistatic_navigation.redirect;
        },
        'read' => q{
                select content

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