aboutsummaryrefslogtreecommitdiff
path: root/src/mod_mam_sql.erl
diff options
context:
space:
mode:
Diffstat (limited to 'src/mod_mam_sql.erl')
-rw-r--r--src/mod_mam_sql.erl16
1 files changed, 7 insertions, 9 deletions
diff --git a/src/mod_mam_sql.erl b/src/mod_mam_sql.erl
index 48112842c..dee2cd7c7 100644
--- a/src/mod_mam_sql.erl
+++ b/src/mod_mam_sql.erl
@@ -268,15 +268,13 @@ export(_Server) ->
is_empty_for_user(LUser, LServer) ->
case ejabberd_sql:sql_query(
LServer,
- ?SQL("select @(count(*))d from archive"
- " where username=%(LUser)s and %(LServer)H")) of
- {selected, [{Res}]} ->
- case Res of
- 0 -> true;
- _ -> false
- end;
- _ -> false
- end.
+ ?SQL("select @(1)d from archive"
+ " where username=%(LUser)s and %(LServer)H limit 1")) of
+ {selected, [{1}]} ->
+ false;
+ _ ->
+ true
+ end.
is_empty_for_room(LServer, LName, LHost) ->
LUser = jid:encode({LName, LHost, <<>>}),