diff options
| author | fusion32 <marcopuzziello@gmail.com> | 2025-10-15 21:40:42 -0300 |
|---|---|---|
| committer | fusion32 <marcopuzziello@gmail.com> | 2025-10-15 21:41:03 -0300 |
| commit | c3b333af90a39f38559de59762c8c1e247ffa2a3 (patch) | |
| tree | 24d74f0024a711e3cbab34c8ffa64cd589cff61a /src | |
| parent | e89144eb2d13532dd8802509a48c27e9934113b7 (diff) | |
| download | querymanager-c3b333af90a39f38559de59762c8c1e247ffa2a3.tar.gz querymanager-c3b333af90a39f38559de59762c8c1e247ffa2a3.zip | |
fix a few postgres queries
Diffstat (limited to 'src')
| -rw-r--r-- | src/database_postgres.cc | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/database_postgres.cc b/src/database_postgres.cc index c79e921..8cfc6ab 100644 --- a/src/database_postgres.cc +++ b/src/database_postgres.cc @@ -1828,7 +1828,7 @@ bool GetCharacterProfile(TDatabase *Database, const char *CharacterName, TCharac " LEFT JOIN CharacterRights AS R" " ON R.CharacterID = C.CharacterID" " AND R.Name = 'NO_STATISTICS'" - " WHERE C.Name = $1::TEXT AND R.Right IS NULL"); + " WHERE C.Name = $1::TEXT AND R.Name IS NULL"); if(Stmt == NULL){ LOG_ERR("Failed to prepare query"); return false; @@ -3212,8 +3212,9 @@ bool MergeKillStatistics(TDatabase *Database, int WorldID, int NumStats, TKillSt const char *Stmt = PrepareQuery(Database, "INSERT INTO KillStatistics (WorldID, RaceName, TimesKilled, PlayersKilled)" " VALUES ($1::INTEGER, $2::TEXT, $3::INTEGER, $4::INTEGER)" - " ON CONFLICT DO UPDATE SET TimesKilled = TimesKilled + EXCLUDED.TimesKilled," - " PlayersKilled = PlayersKilled + EXCLUDED.PlayersKilled"); + " ON CONFLICT (WorldID, RaceName)" + " DO UPDATE SET TimesKilled = KillStatistics.TimesKilled + EXCLUDED.TimesKilled," + " PlayersKilled = KillStatistics.PlayersKilled + EXCLUDED.PlayersKilled"); if(Stmt == NULL){ LOG_ERR("Failed to prepare query"); return false; |