convert all SQL query strings to heredoc syntax
remove trailing whitespace from php sources
fix root update algorithm
remove dead DCA definitions
factor out helper method for sending 404
request patterns