+ (* If logged in, we want to update the recently_visited table. *)
+ if pageid <> None then (
+ match user with
+ | User (userid, _, _, _) ->
+ let sth = dbh#prepare_cached "delete from recently_visited
+ where hostid = ? and userid = ?
+ and url = ?" in
+ sth#execute [`Int hostid; `Int userid; `String page'];
+ let sth = dbh#prepare_cached
+ "insert into recently_visited (hostid, userid, url)
+ values (?, ?, ?)" in
+ sth#execute [`Int hostid; `Int userid; `String page'];
+ dbh#commit ()
+ | _ -> ()
+ );
+
+ (* Navigation links. *)
+ if navigation then (
+ let max_links = 18 in (* Show no more links than this. *)
+
+ (* What links here. *)
+ let wlh = what_links_here dbh hostid page' in
+ let wlh = List.take max_links wlh in
+ let wlh_urls = List.map fst wlh in (* Just the URLs ... *)
+
+ let rv =
+ match user with
+ | User (userid, _, _, _) ->
+ (* Recently visited URLs, but don't repeat any from the 'what
+ * links here' section, and don't link to self.
+ *)
+ let not_urls = page' :: wlh_urls in
+ let limit = max_links - List.length wlh_urls in
+ let qs = Dbi.placeholders (List.length not_urls) in
+ let sth =
+ dbh#prepare_cached
+ ("select rv.url, p.title, rv.visit_time
+ from recently_visited rv, pages p
+ where rv.hostid = ? and rv.userid = ?
+ and rv.url not in " ^ qs ^ "
+ and rv.hostid = p.hostid and rv.url = p.url
+ order by 3 desc
+ limit ?") in
+ let args = List.map (fun s -> `String s) not_urls in
+ sth#execute
+ ([`Int hostid; `Int userid] @ args @ [`Int limit]);
+ sth#map
+ (function [`String url; `String title; _] ->
+ url, title
+ | _ -> assert false)
+ | _ -> [] in
+
+ (* Links to page. *)
+ let f (page, title) = [ "page", Template.VarString page;
+ "title", Template.VarString title ] in
+ let table = List.map f wlh in
+ t#table "what_links_here" table;
+ t#conditional "has_what_links_here" (wlh <> []);
+
+ let table = List.map f rv in
+ t#table "recently_visited" table;
+ t#conditional "has_recently_visited" (rv <> []);
+
+ (* If both lists are empty (ie. an empty navigation box would
+ * appear), then disable navigation altogether.
+ *)
+ if wlh = [] && rv = [] then t#conditional "navigation" false
+ );
+