diff options
| author | fusion32 <marcopuzziello@gmail.com> | 2025-10-04 12:45:13 -0300 |
|---|---|---|
| committer | fusion32 <marcopuzziello@gmail.com> | 2025-10-04 12:45:13 -0300 |
| commit | fa22d10a9d132ff509cb4b40ced1c6d1c0e98167 (patch) | |
| tree | 546834c104502b6276558fc48164c0a5c2c0f192 /src/database.cc | |
| parent | 875b584b090680858393bb24dc58fa85e1a434ce (diff) | |
| download | querymanager-fa22d10a9d132ff509cb4b40ced1c6d1c0e98167.tar.gz querymanager-fa22d10a9d132ff509cb4b40ced1c6d1c0e98167.zip | |
fix problem with finishing or excluding from auctions
Diffstat (limited to 'src/database.cc')
| -rw-r--r-- | src/database.cc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/database.cc b/src/database.cc index 4b06386..f4ca942 100644 --- a/src/database.cc +++ b/src/database.cc @@ -1227,7 +1227,7 @@ bool FinishHouseAuctions(int WorldID, DynamicArray<THouseAuction> *Auctions){ // be an inconvenience but it's not a big problem. sqlite3_stmt *Stmt = PrepareQuery( "DELETE FROM HouseAuctions" - " WHERE WorldID = ?1 AND FinishTime != NULL AND FinishTime <= UNIXEPOCH()" + " WHERE WorldID = ?1 AND FinishTime IS NOT NULL AND FinishTime <= UNIXEPOCH()" " RETURNING HouseID, BidderID, BidAmount, FinishTime," " (SELECT Name FROM Characters WHERE CharacterID = BidderID)"); if(Stmt == NULL){ @@ -1610,7 +1610,7 @@ bool ExcludeFromAuctions(int WorldID, int CharacterID, int Duration, int Banishm if(sqlite3_bind_int(Stmt, 1, WorldID) != SQLITE_OK || sqlite3_bind_int(Stmt, 2, CharacterID) != SQLITE_OK || sqlite3_bind_int(Stmt, 3, Duration) != SQLITE_OK - || sqlite3_bind_int(Stmt, 3, BanishmentID) != SQLITE_OK){ + || sqlite3_bind_int(Stmt, 4, BanishmentID) != SQLITE_OK){ LOG_ERR("Failed to bind parameters: %s", sqlite3_errmsg(g_Database)); return false; } |