X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=scripts%2Fdelete_file.ml;h=209afc6a30539285bc672024b019dd7c28d9f744;hb=89e8d5757ca111d16ce3dfcc1ce4f2c00a119c85;hp=9c1ac60e6e85d53ad2db3c77024f00f538ac1c42;hpb=2faa766a005f4fc4f1fd48a36185452f77ceb2b9;p=cocanwiki.git diff --git a/scripts/delete_file.ml b/scripts/delete_file.ml index 9c1ac60..209afc6 100644 --- a/scripts/delete_file.ml +++ b/scripts/delete_file.ml @@ -1,7 +1,7 @@ (* COCANWIKI - a wiki written in Objective CAML. * Written by Richard W.M. Jones . * Copyright (C) 2004 Merjis Ltd. - * $Id: delete_file.ml,v 1.7 2004/10/21 19:54:29 rich Exp $ + * $Id: delete_file.ml,v 1.8 2004/11/01 17:05:14 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 @@ -32,6 +32,13 @@ let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } user= let id = int_of_string (q#param "id") in if q#param_true "yes" then ( + (* Get the name. *) + let sth = dbh#prepare_cached "select coalesce (name, name_deleted) + from files + where hostid = ? and id = ?" in + sth#execute [`Int hostid; `Int id]; + let name = sth#fetch1string () in + (* Delete the file. *) let sth = dbh#prepare_cached "update files set name_deleted = name, name = null @@ -42,7 +49,8 @@ let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } user= dbh#commit (); (* Email notify. *) - let subject = "File #" ^ string_of_int id ^ " has been deleted." in + let subject = "File " ^ name ^ "#" ^ string_of_int id ^ + " has been deleted." in let body = fun () -> "Page: http://" ^ hostname ^ "/_files?deleted=1" in