X-Git-Url: http://git.annexia.org/?a=blobdiff_plain;f=scripts%2Fpage_email_send.ml;h=4e18374ce8103680ddd85d767e090056536cecb7;hb=bfa88724ee152ba00c2b2fca881dd78a6599820a;hp=a679faa360e0c2ea8d865f47d4ff49bc5bef3f7b;hpb=e828b148d6338765d7f5ca8f10567d5d9ef00548;p=cocanwiki.git diff --git a/scripts/page_email_send.ml b/scripts/page_email_send.ml index a679faa..4e18374 100644 --- a/scripts/page_email_send.ml +++ b/scripts/page_email_send.ml @@ -1,7 +1,7 @@ (* COCANWIKI - a wiki written in Objective CAML. * Written by Richard W.M. Jones . * Copyright (C) 2004 Merjis Ltd. - * $Id: page_email_send.ml,v 1.4 2005/11/24 14:54:12 rich Exp $ + * $Id: page_email_send.ml,v 1.5 2006/03/27 18:09:46 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_template open Cocanwiki_strings -let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } _ = +let run r (q : cgi) dbh hostid { hostname = hostname } _ = let template = get_template dbh hostid "page_email_send.txt" in let page = q#param "page" in @@ -46,12 +46,12 @@ let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } _ = where pending is not null and entry_date < current_date - 7" in sth#execute []; - dbh#commit (); + PGOCaml.commit dbh; (* Is that email address already registered in the database? *) let sth = dbh#prepare_cached "select 1 from page_emails where hostid = ? and url = ? and email = ?" in - sth#execute [`Int hostid; `String page; `String email]; + sth#execute [Some hostid; Some page; Some email]; let registered = try sth#fetch1int () = 1 with Not_found -> false in @@ -75,10 +75,10 @@ let run r (q : cgi) (dbh : Dbi.connection) hostid { hostname = hostname } _ = (* Insert into the database. *) let sth = dbh#prepare_cached "insert into page_emails (hostid, url, email, pending, opt_out) values (?, ?, ?, ?, ?)" in - sth#execute [`Int hostid; `String page; `String email; `String pending; - `String opt_out]; + sth#execute [Some hostid; Some page; Some email; Some pending; + Some opt_out]; - dbh#commit (); + PGOCaml.commit dbh; (* Send the initial email to the user. *) template#set "hostname" hostname;