#!/bin/sh /usr/share/dpatch/dpatch-run
## 007-mod_log_sql.c_funny-table-names.dpatch by Thomas Goirand <thomas@goirand.fr>
##
## DP: This patch adds the possibility to use any kind of names for
## DP: the table names by escaping it when calling SQL.

@DPATCH@
--- libapache-mod-log-sql-1.100/mod_log_sql.c.orig	2008-04-23 04:58:51.000000000 +0000
+++ libapache-mod-log-sql-1.100/mod_log_sql.c	2008-04-23 04:58:53.000000000 +0000
@@ -931,7 +931,7 @@
 			}
 		}
 		if ( itemsets != "" ) {
-			note_query = apr_psprintf(r->pool, "insert %s into %s (id, item, val) values %s",
+			note_query = apr_psprintf(r->pool, "insert %s into `%s` (id, item, val) values %s",
 				/*global_config.insertdelayed?"delayed":*/"", notes_tablename, itemsets);
 
 			log_error(APLOG_MARK,APLOG_DEBUG,0, orig->server,"mod_log_sql: note string: %s", note_query);
@@ -959,7 +959,7 @@
 			}
 		}
 		if ( itemsets != "" ) {
-			hout_query = apr_psprintf(r->pool, "insert %s into %s (id, item, val) values %s",
+			hout_query = apr_psprintf(r->pool, "insert %s into `%s` (id, item, val) values %s",
 				/*global_config.insertdelayed?"delayed":*/"", hout_tablename, itemsets);
 
 			log_error(APLOG_MARK,APLOG_DEBUG,0, orig->server,"mod_log_sql: header_out string: %s", hout_query);
@@ -988,7 +988,7 @@
 			}
 		}
 		if ( itemsets != "" ) {
-			hin_query = apr_psprintf(r->pool, "insert %s into %s (id, item, val) values %s",
+			hin_query = apr_psprintf(r->pool, "insert %s into `%s` (id, item, val) values %s",
 				/*global_config.insertdelayed?"delayed":*/"", hin_tablename, itemsets);
 
 			log_error(APLOG_MARK,APLOG_DEBUG,0, orig->server,"mod_log_sql: header_in string: %s", hin_query);
@@ -1018,7 +1018,7 @@
 
 		}
 		if ( itemsets != "" ) {
-			cookie_query = apr_psprintf(r->pool, "insert %s into %s (id, item, val) values %s",
+			cookie_query = apr_psprintf(r->pool, "insert %s into `%s` (id, item, val) values %s",
 				/*global_config.insertdelayed?"delayed":*/"", cookie_tablename, itemsets);
 
 			log_error(APLOG_MARK,APLOG_DEBUG,0, orig->server,"mod_log_sql: cookie string: %s", cookie_query);
@@ -1026,7 +1026,7 @@
 
 
 		/* Set up the actual INSERT statement */
-		access_query = apr_psprintf(r->pool, "insert %s into %s (%s) values (%s)",
+		access_query = apr_psprintf(r->pool, "insert %s into `%s` (%s) values (%s)",
 			/*global_config.insertdelayed?"delayed":*/"", transfer_tablename, fields, values);
 
         log_error(APLOG_MARK,APLOG_DEBUG,0, r->server,"mod_log_sql: access string: %s", access_query);