(* COCANWIKI - a wiki written in Objective CAML.
* Written by Richard W.M. Jones <rich@merjis.com>.
* Copyright (C) 2004 Merjis Ltd.
- * $Id: create_contact.ml,v 1.2 2004/09/23 11:56:47 rich Exp $
+ * $Id: create_contact.ml,v 1.6 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
let split_re = Pcre.regexp "[\\r\\n,;]+"
-let run r (q : cgi) (dbh : Dbi.connection) hostid _ _ =
+let run r (q : cgi) dbh hostid _ _ =
let name = trim (q#param "name") in
let subject = trim (q#param "subject") in
let emails = try q#param "emails" with Not_found -> "" in
if name = "" then (
error ~back_button:true ~title:"Name field missing"
- q "You must name your contact form.";
+ dbh hostid q "You must name your contact form.";
return ()
);
if subject = "" then (
error ~back_button:true ~title:"Subject line missing"
- q "You must give a subject line, which appears on contact emails.";
+ dbh hostid q
+ "You must give a subject line, which appears on contact emails.";
return ()
);
if emails = [] then (
error ~back_button:true ~title:"No email addresses"
- q ("There are no email addresses listed for this contact form. You " ^
- "must list at least one valid email address.");
+ dbh hostid q
+ ("There are no email addresses listed for this contact form. You " ^
+ "must list at least one valid email address.");
return ()
);
(* Update the database. *)
- let sth = dbh#prepare_cached "insert into contacts (hostid, name, subject)
- values (?, ?, ?)" in
- sth#execute [`Int hostid; `String name; `String subject];
+ PGSQL(dbh) "insert into contacts (hostid, name, subject)
+ values ($hostid, $name, $subject)";
- let contactid = sth#serial "contacts_id_seq" in
+ let contactid = PGOCaml.serial4 dbh "contacts_id_seq" in
- let sth = dbh#prepare_cached "insert into contact_emails (contactid, email)
- values (?, ?)" in
- List.iter (fun email ->
- sth#execute [`Int contactid; `String email]) emails;
+ List.iter (
+ fun email ->
+ PGSQL(dbh) "insert into contact_emails (contactid, email)
+ values ($contactid, $email)"
+ ) emails;
(* Finish off. *)
- dbh#commit ();
+ PGOCaml.commit dbh;
- let msg = sprintf "Contact form created. The contact id is %d. On the next page you will be given some same <html> code which you should copy and paste onto a web page to create a simple form, which can then be modified for your requirements." contactid in
+ let msg = sprintf "Contact form created. The contact id is %ld. On the next page you will be given some same <html> code which you should copy and paste onto a web page to create a simple form, which can then be modified for your requirements." contactid in
- let buttons = [ { StdPages.label = " View contact form ";
- StdPages.link = "/_bin/contact_show.cmo";
- StdPages.method_ = None;
- StdPages.params = [ "id", string_of_int contactid ] } ] in
- ok ~title:"Contact form created" ~buttons q msg
+ let buttons = [ { Template.StdPages.label = " View contact form ";
+ Template.StdPages.link = "/_bin/contact_show.cmo";
+ Template.StdPages.method_ = None;
+ Template.StdPages.params =
+ [ "id", Int32.to_string contactid ] } ] in
+ ok ~title:"Contact form created" ~buttons dbh hostid q msg
let () =
register_script ~restrict:[CanManageContacts] run