diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2005-10-19 23:00:17 +0000 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2005-10-19 23:00:17 +0000 |
| commit | 1a015a3cf9a06add0281e72ae1b23bd7ef34b53f (patch) | |
| tree | 10d123a7f674c703931b482b5d1ac5e3c7f16a0c /src/mod_offline_odbc.erl | |
| parent | * src/mod_roster_odbc.erl: Bugfix (diff) | |
* src/odbc/pg.sql: Added spool.seq field for offline messages
sorting
* src/mod_offline_odbc.erl: Likewise
SVN Revision: 424
Diffstat (limited to '')
| -rw-r--r-- | src/mod_offline_odbc.erl | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/mod_offline_odbc.erl b/src/mod_offline_odbc.erl index ff9737171..d7a77ae4a 100644 --- a/src/mod_offline_odbc.erl +++ b/src/mod_offline_odbc.erl @@ -214,7 +214,8 @@ pop_offline_messages(Ls, User, Server) -> case ejabberd_odbc:sql_query( LServer, ["begin;" - "select * from spool where username='", EUser, "';" + "select username, xml from spool where username='", EUser, "'" + " order by seq;" "delete from spool where username='", EUser, "';" "commit"]) of [{updated, undefined}, |