X-Git-Url: http://git.rot13.org/?p=Fuse-DBI;a=blobdiff_plain;f=examples%2Fstrix-multi_static.pl;h=745300e4a66a4ff4713a0f9c351a19cf308fddb7;hp=5a22ab8f59034f47bad27580fcd971fba128c960;hb=HEAD;hpb=eee0ed86b45c442607a99cf0da11aa1d8ffead87

diff --git a/examples/strix-multi_static.pl b/examples/strix-multi_static.pl
index 5a22ab8..745300e 100755
--- 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