* src/mod_offline_odbc.erl: Bugfix

SVN Revision: 955

2 files changed, 6 insertions, 1 deletions

diff --git a/ChangeLog b/ChangeLog
index 05ecee040..1c6321da1 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,7 @@
+2007-10-06  Alexey Shchepin  <alexey@process-one.net>
+
+	* src/mod_offline_odbc.erl: Bugfix
+
 2007-10-01  Alexey Shchepin  <alexey@process-one.net>
 
 	* src/ejabberd_auth_pam.erl: Support for PAM authentication
diff --git a/src/mod_offline_odbc.erl b/src/mod_offline_odbc.erl
index 19e23585f..e645bad66 100644
--- a/src/mod_offline_odbc.erl
+++ b/src/mod_offline_odbc.erl
@@ -425,8 +425,9 @@ webadmin_user(Acc, User, Server, Lang) ->
 
 %% Returns as integer the number of offline messages for a given user
 count_offline_messages(LUser, LServer) ->
+    Username = ejabberd_odbc:escape(LUser),
     case catch odbc_queries:count_records_where(
-		 LServer, "spool", "where username='" ++ LUser ++ "'") of
+		 LServer, "spool", "where username='" ++ Username ++ "'") of
         {selected, [_], [{Res}]} ->
             list_to_integer(Res);
         _ ->