+ (* If logged in, we want to update the recently_visited table. *)
+ (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 = 15 in (* Show no more links than this. *)
+
+ (* What links here. *)
+ let wlh = what_links_here dbh hostid page' 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 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 max_links]);
+ 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;
+
+ let table = List.map f rv in
+ t#table "recently_visited" table;
+ );
+