Change subject line so it shows the name of the site.

[cocanwiki.git] / scripts / mailing_list_unsubscribe.ml

diff --git a/scripts/mailing_list_unsubscribe.ml b/scripts/mailing_list_unsubscribe.ml
index d2b1328..346a332 100644 (file)
--- a/scripts/mailing_list_unsubscribe.ml
+++ b/scripts/mailing_list_unsubscribe.ml
@@ -1,7 +1,7 @@
 (* COCANWIKI - a wiki written in Objective CAML.
  * Written by Richard W.M. Jones <rich@merjis.com>.
  * Copyright (C) 2004 Merjis Ltd.
- * $Id: mailing_list_unsubscribe.ml,v 1.1 2004/09/24 16:41:16 rich Exp $
+ * $Id: mailing_list_unsubscribe.ml,v 1.4 2006/03/28 13:20:00 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
@@ -27,20 +27,19 @@ open Printf
 open Cocanwiki
 open Cocanwiki_ok
 
-let run r (q : cgi) (dbh : Dbi.connection) hostid _ _ =
+let run r (q : cgi) dbh hostid _ _ =
   let opt_out = q#param "o" in
 
   (* Update the database. *)
-  let sth = dbh#prepare_cached "delete from mailing_lists
-                                 where hostid = ? and opt_out = ?" in
-  sth#execute [`Int hostid; `String opt_out];
+  PGSQL(dbh) "delete from mailing_lists
+               where hostid = $hostid and opt_out = $opt_out";
 
-  dbh#commit ();
+  PGOCaml.commit dbh;
 
   (* Confirmed. *)
   let buttons = [ ok_button "/" ] in
   ok ~buttons ~title:"Unsubscribed"
-    q "Your email address has been unsubscribed."
+    dbh hostid q "Your email address has been unsubscribed."
 
 let () =
   register_script run