(* COCANWIKI - a wiki written in Objective CAML.
* Written by Richard W.M. Jones <rich@merjis.com>.
* Copyright (C) 2004 Merjis Ltd.
- * $Id: edit_user_form.ml,v 1.6 2004/09/22 10:19:26 rich Exp $
+ * $Id: edit_user_form.ml,v 1.11 2006/07/26 16:34:18 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
open Cocanwiki_template
open Cocanwiki_date
-let run r (q : cgi) (dbh : Dbi.connection) hostid _ _ =
+let run r (q : cgi) dbh hostid _ _ =
let template = get_template dbh hostid "edit_user_form.html" in
- let userid = int_of_string (q#param "userid") in
+ let userid = Int32.of_string (q#param "userid") in
- let sth =
- dbh#prepare_cached
+ let rows =
+ PGSQL(dbh)
"select u.name, u.email, u.registration_date,
u.can_edit, u.can_manage_users, u.can_manage_contacts,
- u.can_manage_site, u.can_edit_global_css,
- (select count(*) from pages where logged_user = u.id),
+ u.can_manage_site, u.can_edit_global_css, u.can_import_mail,
+ u.can_edit_macros,
+ (select count(*) from pages where logged_user = u.id)::int4,
(select count(*) from pages
- where logged_user = u.id and url_deleted is null)
- from users u where u.hostid = ? and u.id = ?" in
- sth#execute [`Int hostid; `Int userid];
+ where logged_user = u.id and url_deleted is null)::int4
+ from users u where u.hostid = $hostid and u.id = $userid" in
let name, email, registration_date, can_edit, can_manage_users,
can_manage_contacts, can_manage_site, can_edit_global_css,
- nr_edits, nr_edits_live =
- match sth#fetch1 () with
- [`String name; (`Null | `String _) as email;
- `Date registration_date;
- `Bool can_edit; `Bool can_manage_users; `Bool can_manage_contacts;
- `Bool can_manage_site; `Bool can_edit_global_css;
- `Int nr_edits; `Int nr_edits_live] ->
- name, email, registration_date, can_edit, can_manage_users,
- can_manage_contacts, can_manage_site, can_edit_global_css,
- nr_edits, nr_edits_live
- | _ -> assert false in
+ can_import_mail, can_edit_macros, nr_edits, nr_edits_live =
+ match rows with
+ | [name, email, registration_date,
+ can_edit, can_manage_users, can_manage_contacts,
+ can_manage_site, can_edit_global_css,
+ can_import_mail, can_edit_macros,
+ nr_edits, nr_edits_live] ->
+ name, email, registration_date, can_edit, can_manage_users,
+ can_manage_contacts, can_manage_site, can_edit_global_css,
+ can_import_mail, can_edit_macros, nr_edits, nr_edits_live
+ | _ -> assert false in
- template#set "userid" (string_of_int userid);
+ template#set "userid" (Int32.to_string userid);
template#set "name" name;
- template#set "email" (match email with `Null -> "" | `String s -> s);
+ template#set "email" (match email with None -> "" | Some s -> s);
template#set "registration_date" (printable_date' registration_date);
template#conditional "can_edit" can_edit;
template#conditional "can_manage_users" can_manage_users;
template#conditional "can_manage_contacts" can_manage_contacts;
template#conditional "can_manage_site" can_manage_site;
template#conditional "can_edit_global_css" can_edit_global_css;
- template#set "nr_edits" (string_of_int nr_edits);
- template#set "nr_edits_live" (string_of_int nr_edits_live);
+ template#conditional "can_import_mail" can_import_mail;
+ template#conditional "can_edit_macros" can_edit_macros;
+ template#set "nr_edits" (Int32.to_string (Option.get nr_edits));
+ template#set "nr_edits_live" (Int32.to_string (Option.get nr_edits_live));
q#template template