(* COCANWIKI - a wiki written in Objective CAML. * Written by Richard W.M. Jones . * Copyright (C) 2004 Merjis Ltd. * $Id: delete_contact.ml,v 1.6 2006/07/26 13:12:10 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 * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; see the file COPYING. If not, write to * the Free Software Foundation, Inc., 59 Temple Place - Suite 330, * Boston, MA 02111-1307, USA. *) open Apache open Registry open Cgi open Printf open Cocanwiki open Cocanwiki_ok let run r (q : cgi) dbh hostid { hostname = hostname } _ = (* Cancel? *) if q#param_true "cancel" then q#redirect ("http://" ^ hostname ^ "/_bin/contacts.cmo"); (* We can delete multiple contact forms from this script, which is * quite unusual. *) let ids = List.map Int32.of_string (q#param_all "delete") in if ids = [] then q#redirect ("http://" ^ hostname ^ "/_bin/contacts.cmo"); (* Need to check the contact emails all belong to this host. *) let rows = PGSQL(dbh) "select count(*)::int4 from contacts where hostid = $hostid and id in $@ids" in assert (List.length rows = List.length ids); (* Delete them. *) PGSQL(dbh) "delete from contact_emails where contactid in $@ids"; PGSQL(dbh) "delete from contacts where hostid = $hostid and id in $@ids"; (* Finish off. *) PGOCaml.commit dbh; ok ~title:"Contact form(s) deleted" ~buttons:[ok_button "/_bin/contacts.cmo"] dbh hostid q "Those contact form(s) were deleted." let () = register_script ~restrict:[CanManageContacts] run