(* COCANWIKI - a wiki written in Objective CAML. * Written by Richard W.M. Jones . * Copyright (C) 2004 Merjis Ltd. * $Id: edit_page_css.ml,v 1.24 2006/08/17 09:11:31 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 * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; see the file COPYING. If not, write to * the Free Software Foundation, Inc., 59 Temple Place - Suite 330, * Boston, MA 02111-1307, USA. *) open Apache open Registry open Cgi open Printf open Cocanwiki open Cocanwiki_ok open Cocanwiki_diff open Cocanwiki_emailnotify open Cocanwiki_strings let run r (q : cgi) dbh hostid {hostname = hostname} user = let page = q#param "page" in let css = q#param "css" in let css = if string_is_whitespace css then None else Some css in (* Get the IP address of the user, if available. *) let logged_ip = try Some (Connection.remote_ip (Request.connection r)) with Not_found -> None in let logged_user = match user with | User (id, _, _, _) -> Some id | _ -> None in (* Changing the CSS creates a new version of the page. This enables * us to revert changes to the CSS easily. *) let rows = PGSQL(dbh) "select id, title, description, keywords, noodp, creation_date, redirect from pages where hostid = $hostid and url = $page" in let oldpageid, title, description, keywords, noodp, creation_date, redirect = match rows with | [row] -> row | _ -> assert false in PGSQL(dbh) "set constraints pages_redirect_cn, sitemenu_url_cn, page_emails_url_cn, links_from_cn, recently_visited_url_cn deferred"; PGSQL(dbh) "update pages set url_deleted = url, url = null where hostid = $hostid and id = $oldpageid"; PGSQL(dbh) "insert into pages (hostid, url, title, description, keywords, noodp, creation_date, logged_ip, logged_user, redirect, css) values ($hostid, $page, $title, $description, $?keywords, $?noodp, $creation_date, $?logged_ip, $?logged_user, $?redirect, $?css)"; let pageid = PGOCaml.serial4 dbh "pages_id_seq" in PGSQL(dbh) "insert into contents (pageid, ordering, sectionname, content, divname, divclass, jsgo) select $pageid as pageid, ordering, sectionname, content, divname, divclass, jsgo from contents where pageid = $oldpageid"; PGOCaml.commit dbh; (* Email notification. *) let subject = "CSS for page " ^ page ^ " has been modified" in let body = fun () -> let diff, _ = get_diff dbh hostid page ~version:pageid ~old_version:oldpageid () in "Page: http://" ^ hostname ^ "/" ^ page ^ "\n\n" ^ diff in email_notify ~subject ~body ~user dbh hostid; let buttons = [ ok_button ("/" ^ page); { Template.StdPages.label = "Edit stylesheet again"; Template.StdPages.link = "/_bin/edit_page_css_form.cmo"; Template.StdPages.method_ = None; Template.StdPages.params = [ "page", page ] } ] in ok ~title:"Stylesheet changed" ~buttons dbh hostid q ("The stylesheet was changed successfully. " ^ "Note: You must RELOAD the page to see changes to stylesheets.") let () = register_script ~restrict:[CanEdit] run