(* COCANWIKI - a wiki written in Objective CAML.
* Written by Richard W.M. Jones <rich@merjis.com>.
* Copyright (C) 2004 Merjis Ltd.
- * $Id: users.ml,v 1.8 2004/10/23 15:00:16 rich Exp $
+ * $Id: users.ml,v 1.12 2006/12/06 09:46:57 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 template = get_template dbh hostid "users.html" in
+let run r (q : cgi) dbh hostid _ _ =
+ let template = get_template r dbh hostid "users.html" in
- let sth =
- dbh#prepare_cached
+ let rows =
+ PGSQL(dbh)
"select id, name, email, registration_date, invite is not null,
can_edit, can_manage_users,
can_manage_contacts, can_manage_site, can_edit_global_css,
- can_import_mail
- from users where hostid = ? order by name" in
- sth#execute [`Int hostid];
+ can_import_mail, can_edit_macros
+ from users where hostid = $hostid order by name" in
let table =
- sth#map
- (function
- [`Int userid; `String name; (`Null | `String _) as email;
- `Date registration_date; `Bool invite_pending;
- `Bool can_edit; `Bool can_manage_users;
- `Bool can_manage_contacts; `Bool can_manage_site;
- `Bool can_edit_global_css; `Bool can_import_mail] ->
- let email = match email with `Null -> "" | `String s -> s in
- [ "userid", Template.VarString (string_of_int userid);
- "name", Template.VarString name;
- "email", Template.VarString email;
- "registration_date",
- Template.VarString (printable_date' registration_date);
- "invite_pending",
- Template.VarConditional invite_pending;
- "can_edit", Template.VarConditional can_edit;
- "can_manage_users", Template.VarConditional can_manage_users;
- "can_manage_contacts",
- Template.VarConditional can_manage_contacts;
- "can_manage_site", Template.VarConditional can_manage_site;
- "can_edit_global_css",
- Template.VarConditional can_edit_global_css;
- "can_import_mail",
- Template.VarConditional can_import_mail;]
- | _ -> assert false) in
+ List.map
+ (fun (userid, name, email, registration_date, invite_pending,
+ can_edit, can_manage_users, can_manage_contacts, can_manage_site,
+ can_edit_global_css, can_import_mail, can_edit_macros) ->
+ let email = match email with None -> "" | Some s -> s in
+ let invite_pending = Option.get invite_pending in
+ [ "userid", Template.VarString (Int32.to_string userid);
+ "name", Template.VarString name;
+ "email", Template.VarString email;
+ "registration_date",
+ Template.VarString (printable_date' registration_date);
+ "invite_pending",
+ Template.VarConditional invite_pending;
+ "can_edit", Template.VarConditional can_edit;
+ "can_manage_users", Template.VarConditional can_manage_users;
+ "can_manage_contacts",
+ Template.VarConditional can_manage_contacts;
+ "can_manage_site", Template.VarConditional can_manage_site;
+ "can_edit_global_css",
+ Template.VarConditional can_edit_global_css;
+ "can_import_mail",
+ Template.VarConditional can_import_mail;
+ "can_edit_macros",
+ Template.VarConditional can_edit_macros;]
+ ) rows in
template#table "users" table;