diff options
| author | leak <leakzx@googlemail.com> | 2011-03-01 01:42:18 +0100 |
|---|---|---|
| committer | leak <leakzx@googlemail.com> | 2011-03-01 01:42:18 +0100 |
| commit | 709c395421eb1c124afdc5fffb7948ab92ac180c (patch) | |
| tree | 9ea7be533b6ad97d7de6100ca2a01454ec0a5083 /src/server/shared/Database/Implementation | |
| parent | 6b1837cecb811454c2155e907a133f0ce75d2673 (diff) | |
Core/Groups: Forgotten changes from group id recycling reimplementation, also cleanup queries should be sync (and due to their one time execution have no need to be prepared statements)
Diffstat (limited to 'src/server/shared/Database/Implementation')
| -rwxr-xr-x | src/server/shared/Database/Implementation/CharacterDatabase.cpp | 5 | ||||
| -rwxr-xr-x | src/server/shared/Database/Implementation/CharacterDatabase.h | 5 |
2 files changed, 0 insertions, 10 deletions
diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.cpp b/src/server/shared/Database/Implementation/CharacterDatabase.cpp index 1d001962526..44c186cdb82 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/shared/Database/Implementation/CharacterDatabase.cpp @@ -31,11 +31,6 @@ bool CharacterDatabaseConnection::Open() PREPARE_STATEMENT(CHAR_DEL_OLD_GUILD_EVENT_LOGS, "DELETE FROM guild_eventlog WHERE LogGuid > ?", CONNECTION_ASYNC) PREPARE_STATEMENT(CHAR_DEL_OLD_GUILD_BANK_EVENT_LOGS, "DELETE FROM guild_bank_eventlog WHERE LogGuid > ?", CONNECTION_ASYNC) PREPARE_STATEMENT(CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM, "DELETE FROM guild_bank_item WHERE guildid = ? AND TabId = ? AND SlotId = ?", CONNECTION_ASYNC) - PREPARE_STATEMENT(CHAR_DEL_NONEXISTENT_CHARACTER_GROUP_MEMBERS, "DELETE FROM group_member WHERE memberGuid NOT IN (SELECT guid FROM characters)", CONNECTION_ASYNC) - PREPARE_STATEMENT(CHAR_DEL_LEADERLESS_GROUPS, "DELETE FROM groups WHERE NOT EXISTS (SELECT guid FROM characters WHERE guid=leaderGuid)", CONNECTION_SYNCH) - PREPARE_STATEMENT(CHAR_DEL_TINY_GROUPS, "DELETE FROM groups WHERE guid NOT IN (SELECT guid FROM group_member GROUP BY guid HAVING COUNT(guid) > 1)", CONNECTION_SYNCH) - PREPARE_STATEMENT(CHAR_DEL_NONEXISTENT_GROUP_MEMBERS, "DELETE FROM group_member WHERE guid NOT IN (SELECT guid FROM groups)", CONNECTION_ASYNC) - PREPARE_STATEMENT(CHAR_DEL_NONEXISTENT_GROUP_INSTANCES, "DELETE FROM group_instance WHERE guid NOT IN (SELECT guid FROM groups)", CONNECTION_ASYNC) PREPARE_STATEMENT(CHAR_DEL_EXPIRED_BANS, "UPDATE character_banned SET active = 0 WHERE unbandate <= UNIX_TIMESTAMP() AND unbandate <> bandate", CONNECTION_ASYNC) PREPARE_STATEMENT(CHAR_GET_GUID_BY_NAME, "SELECT guid FROM characters WHERE name = ?", CONNECTION_SYNCH) PREPARE_STATEMENT(CHAR_ADD_BAN, "INSERT INTO character_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)", CONNECTION_ASYNC) diff --git a/src/server/shared/Database/Implementation/CharacterDatabase.h b/src/server/shared/Database/Implementation/CharacterDatabase.h index fbe2498b511..951ea90b326 100755 --- a/src/server/shared/Database/Implementation/CharacterDatabase.h +++ b/src/server/shared/Database/Implementation/CharacterDatabase.h @@ -47,11 +47,6 @@ enum CharacterDatabaseStatements CHAR_DEL_OLD_GUILD_EVENT_LOGS, CHAR_DEL_OLD_GUILD_BANK_EVENT_LOGS, CHAR_DEL_NONEXISTENT_GUILD_BANK_ITEM, - CHAR_DEL_NONEXISTENT_CHARACTER_GROUP_MEMBERS, - CHAR_DEL_LEADERLESS_GROUPS, - CHAR_DEL_TINY_GROUPS, - CHAR_DEL_NONEXISTENT_GROUP_MEMBERS, - CHAR_DEL_NONEXISTENT_GROUP_INSTANCES, CHAR_DEL_EXPIRED_BANS, CHAR_GET_GUID_BY_NAME, CHAR_ADD_BAN, |