X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=scripts%2Frestore.ml;h=471b8fcd8d98e43909e093f5a2e4afc35f47c22e;hb=f303d3e2bc355bdca4147d21441d6a13d4748d1a;hp=167ac9e29d9a0f57f96c34d414670d53fb5e1d73;hpb=11b93485a29771f4d826c50d9efc6d3607dfa50f;p=cocanwiki.git diff --git a/scripts/restore.ml b/scripts/restore.ml index 167ac9e..471b8fc 100644 --- a/scripts/restore.ml +++ b/scripts/restore.ml @@ -1,7 +1,7 @@ (* COCANWIKI - a wiki written in Objective CAML. * Written by Richard W.M. Jones . * Copyright (C) 2004 Merjis Ltd. - * $Id: restore.ml,v 1.7 2004/09/09 12:21:22 rich Exp $ + * $Id: restore.ml,v 1.9 2004/09/24 15:53:57 rich Exp $ * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by @@ -29,7 +29,7 @@ open Cocanwiki_ok open Cocanwiki_diff open Cocanwiki_emailnotify -let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } _ = +let run r (q : cgi) (dbh : Dbi.connection) hostid {hostname = hostname} user = let version = int_of_string (q#param "version") in let page = q#param "page" in @@ -39,6 +39,11 @@ let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } _ = try `String (Connection.remote_ip (Request.connection r)) with Not_found -> `Null in + let logged_user = + match user with + | User (id, _, _) -> `Int id + | _ -> `Null in + (* Copy the old version of the page to be live. *) let sth = dbh#prepare_cached "select title, description, creation_date, redirect, css @@ -55,7 +60,8 @@ let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } _ = let sth = dbh#prepare_cached - "set constraints pages_redirect_cn, sitemenu_url_cn deferred" in + "set constraints pages_redirect_cn, sitemenu_url_cn, + page_emails_url_cn deferred" in sth#execute []; let sth = dbh#prepare_cached "update pages set url_deleted = url, @@ -65,10 +71,10 @@ let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } _ = let sth = dbh#prepare_cached "insert into pages (hostid, url, title, description, creation_date, logged_ip, - redirect, css) - values (?, ?, ?, ?, ?, ?, ?, ?)" in + logged_user, redirect, css) + values (?, ?, ?, ?, ?, ?, ?, ?, ?)" in sth#execute [`Int hostid; `String page; title; description; - creation_date; logged_ip; redirect; css ]; + creation_date; logged_ip; logged_user; redirect; css ]; let pageid = sth#serial "pages_id_seq" in