+ let sth = dbh#prepare_cached "select theme_css from hosts
+ where id = ?" in
+ sth#execute [`Int hostid];
+
+ let theme_css =
+ match sth#fetch1 () with
+ [ `Null ] -> "/_css/standard.css"
+ | [ `String file ] -> file
+ | _ -> assert false in
+
+ template#set "theme_css" theme_css;
+
+ (* Site menu. *)
+ let sth = dbh#prepare_cached "select url, label, ordering from sitemenu
+ where hostid = ? order by ordering" in
+ sth#execute [`Int hostid];
+
+ let table = sth#map (function [`String url; `String label; _] ->
+ [ "url", Template.VarString url;
+ "label", Template.VarString label ]
+ | _ -> assert false) in
+
+ template#table "sitemenu" table;
+
+ (* Wiki version. *)
+ template#set "cocanwiki_package" Cocanwiki_version.package;
+ template#set "cocanwiki_version" Cocanwiki_version.version;
+
+ (* Copyright year. *)
+ template#set "year" (string_of_int year);