diff options
Diffstat (limited to 'database/sqlite/sqlite.c')
| -rw-r--r-- | database/sqlite/sqlite.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/database/sqlite/sqlite.c b/database/sqlite/sqlite.c index 7f9f7fc..6b0cd72 100644 --- a/database/sqlite/sqlite.c +++ b/database/sqlite/sqlite.c @@ -386,7 +386,7 @@ char *_build_sqlpart(int btyp, eDBfieldMap *map) { dbresult *sqlite_query_mapped(eurephiaCTX *ctx, SQLqueryType qType, const char *sqlstub, - eDBfieldMap *valMap, eDBfieldMap *whereMap) + eDBfieldMap *valMap, eDBfieldMap *whereMap, const char *sortkeys) { dbresult *res = NULL; char *tmp1 = NULL, *tmp2 = NULL; @@ -399,7 +399,11 @@ dbresult *sqlite_query_mapped(eurephiaCTX *ctx, SQLqueryType qType, const char * case SQL_DELETE: if( whereMap != NULL ) { tmp1 = _build_sqlpart(btWHERE, whereMap); - res = sqlite_query(ctx, "%s WHERE %s", sqlstub, tmp1); + if( sortkeys == NULL ) { + res = sqlite_query(ctx, "%s WHERE %s", sqlstub, tmp1); + } else { + res = sqlite_query(ctx, "%s WHERE %s ORDER BY %s", sqlstub, tmp1, sortkeys); + } free_nullsafe(tmp1); } break; |