diff options
| author | UltraNix <80540499+UltraNix@users.noreply.github.com> | 2021-05-14 10:15:45 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-05-14 10:15:45 +0200 |
| commit | 8dd58ebb5bea6a8aada54c830d06974d3ecd1353 (patch) | |
| tree | 01ab1321f59d73bf47676ce56998a142837ce2e0 /src/server/database/Database/Implementation | |
| parent | 1b6c2004ce05ee6934bf1fa1562f7eae4cc74d07 (diff) | |
fix(Core): Memleaks fixes - Part II. (#5760)
Diffstat (limited to 'src/server/database/Database/Implementation')
| -rw-r--r-- | src/server/database/Database/Implementation/CharacterDatabase.cpp | 1 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/CharacterDatabase.h | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/src/server/database/Database/Implementation/CharacterDatabase.cpp b/src/server/database/Database/Implementation/CharacterDatabase.cpp index c8e0591e5b..8409b32162 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/database/Database/Implementation/CharacterDatabase.cpp @@ -205,6 +205,7 @@ void CharacterDatabaseConnection::DoPrepareStatements() // Chat channel handling PrepareStatement(CHAR_INS_CHANNEL, "INSERT INTO channels(channelId, name, team, announce, lastUsed) VALUES (?, ?, ?, ?, UNIX_TIMESTAMP())", CONNECTION_ASYNC); PrepareStatement(CHAR_UPD_CHANNEL, "UPDATE channels SET announce = ?, password = ?, lastUsed = UNIX_TIMESTAMP() WHERE channelId = ?", CONNECTION_ASYNC); + PrepareStatement(CHAR_DEL_CHANNEL, "DELETE FROM channels WHERE name = ? AND team = ?", CONNECTION_ASYNC); PrepareStatement(CHAR_UPD_CHANNEL_USAGE, "UPDATE channels SET lastUsed = UNIX_TIMESTAMP() WHERE channelId = ?", CONNECTION_ASYNC); PrepareStatement(CHAR_DEL_OLD_CHANNELS, "DELETE FROM channels WHERE lastUsed + ? < UNIX_TIMESTAMP()", CONNECTION_ASYNC); PrepareStatement(CHAR_DEL_OLD_CHANNELS_BANS, "DELETE cb.* FROM channels_bans cb LEFT JOIN channels cn ON cb.channelId=cn.channelId WHERE cn.channelId IS NULL OR cb.banTime <= UNIX_TIMESTAMP()", CONNECTION_ASYNC); diff --git a/src/server/database/Database/Implementation/CharacterDatabase.h b/src/server/database/Database/Implementation/CharacterDatabase.h index 4e22362dd3..ebf4a09098 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.h +++ b/src/server/database/Database/Implementation/CharacterDatabase.h @@ -184,6 +184,7 @@ enum CharacterDatabaseStatements CHAR_INS_CHANNEL, CHAR_UPD_CHANNEL, + CHAR_DEL_CHANNEL, CHAR_UPD_CHANNEL_USAGE, CHAR_DEL_OLD_CHANNELS, CHAR_DEL_OLD_CHANNELS_BANS, |