(* COCANWIKI scripts. * Written by Richard W.M. Jones . * Copyright (C) 2004 Merjis Ltd. * $Id: edit_hostnames.ml,v 1.3 2004/09/07 14:58:34 rich Exp $ *) open Apache open Registry open Cgi open Printf open Cocanwiki open Cocanwiki_ok open Cocanwiki_strings let split_re = Pcre.regexp "[\\s,;]+" let run r (q : cgi) (dbh : Dbi.connection) host_stuff _ = let hostid = int_of_string (q#param "hostid") in if q#param_true "cancel" then ( let _, hostname, _ = host_stuff in q#redirect ("http://" ^ hostname ^ "/_bin/admin/host.cmo?hostid=" ^ string_of_int hostid); raise CgiExit ); let canonical_hostname = q#param "canonical_hostname" in let hostnames = try q#param "hostnames" with Not_found -> "" in (* In theory we could verify characters in hostnames, and call * error / raise CgiExit if the format is incorrect. However * it's probably best to assume the sysadmin knows what they're up to * here. If this script is allowed to be accessed by untrusted users, * then this has security implications. *) let check_hostname h = let h = trim h in (* Trim whitespace. *) let h = String.lowercase h in (* Lowercase. *) h in let canonical_hostname = check_hostname canonical_hostname in let hostnames = Pcre.split ~rex:split_re hostnames in let hostnames = List.map check_hostname hostnames in let hostnames = List.filter ((<>) "") hostnames in (* Update the database. *) let sth = dbh#prepare_cached "set constraints \"hosts_hostname_cn\" deferred" in sth#execute []; let sth = dbh#prepare_cached "update hosts set canonical_hostname = ? where id = ?" in sth#execute [`String canonical_hostname; `Int hostid]; let sth = dbh#prepare_cached "delete from hostnames where hostid = ?" in sth#execute [`Int hostid]; let sth = dbh#prepare_cached "insert into hostnames (hostid, name) values (?, ?)" in sth#execute [`Int hostid; `String canonical_hostname]; List.iter (fun name -> sth#execute [`Int hostid; `String name]) hostnames; (* Commit to the database. *) dbh#commit (); (* Print confirmation page. *) let buttons = [ { StdPages.label = "OK"; StdPages.link = "/_bin/admin/host.cmo"; StdPages.method_ = None; StdPages.params = [ "hostid", string_of_int hostid ] } ] in ok ~title:"Saved" ~buttons q "Hostnames updated." let () = register_script run