TrinityCore
LoginDatabase.h
Go to the documentation of this file.
1/*
2 * This file is part of the TrinityCore Project. See AUTHORS file for Copyright information
3 *
4 * This program is free software; you can redistribute it and/or modify it
5 * under the terms of the GNU General Public License as published by the
6 * Free Software Foundation; either version 2 of the License, or (at your
7 * option) any later version.
8 *
9 * This program is distributed in the hope that it will be useful, but WITHOUT
10 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
11 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
12 * more details.
13 *
14 * You should have received a copy of the GNU General Public License along
15 * with this program. If not, see <http://www.gnu.org/licenses/>.
16 */
17
18#ifndef _LOGINDATABASE_H
19#define _LOGINDATABASE_H
20
21#include "MySQLConnection.h"
22
24{
25 /* Naming standard for defines:
26 {DB}_{SEL/INS/UPD/DEL/REP}_{Summary of data changed}
27 When updating more than one field, consider looking at the calling function
28 name for a suiting suffix.
29 */
30
99
104
108
112
115
142
147
150
153
165
168
171
179
182
184{
185public:
187
190
191 //- Loads database type specific prepared statements
192 void DoPrepareStatements() override;
193};
194
195#endif
#define TC_DATABASE_API
Definition: Define.h:111
uint32_t uint32
Definition: Define.h:142
LoginDatabaseStatements
Definition: LoginDatabase.h:24
@ LOGIN_UPD_MUTE_TIME_LOGIN
Definition: LoginDatabase.h:68
@ LOGIN_GET_EMAIL_BY_ID
Definition: LoginDatabase.h:94
@ LOGIN_INS_ACCOUNT_BANNED
Definition: LoginDatabase.h:53
@ LOGIN_SEL_BNET_CHARACTER_COUNTS_BY_BNET_ID
@ LOGIN_SEL_ACCOUNT_LIST_BY_EMAIL
Definition: LoginDatabase.h:46
@ LOGIN_UPD_BNET_RESET_FAILED_LOGINS
@ LOGIN_INS_LOG
Definition: LoginDatabase.h:63
@ LOGIN_UPD_BNET_LAST_LOGIN_INFO
@ LOGIN_SEL_ACCOUNT_ACCESS_SECLEVEL_TEST
Definition: LoginDatabase.h:86
@ LOGIN_UPD_EMAIL
Definition: LoginDatabase.h:65
@ LOGIN_SEL_ACCOUNT_BY_IP
Definition: LoginDatabase.h:47
@ LOGIN_UPD_ACCOUNT_INFO_CONTINUED_SESSION
Definition: LoginDatabase.h:40
@ LOGIN_DEL_BATTLE_PETS_BY_OWNER
@ LOGIN_DEL_ACCOUNT_ACCESS_BY_REALM
Definition: LoginDatabase.h:75
@ LOGIN_SEL_BATTLE_PETS
@ LOGIN_SEL_BNET_EXISTING_AUTHENTICATION_BY_ID
@ LOGIN_SEL_LAST_CHAR_UNDELETE
@ LOGIN_GET_ACCOUNT_ID_BY_USERNAME
Definition: LoginDatabase.h:77
@ LOGIN_SEL_BNET_AUTHENTICATION
@ LOGIN_SEL_ACCOUNT_BANNED_BY_FILTER
Definition: LoginDatabase.h:37
@ LOGIN_UPD_UPTIME_PLAYERS
Definition: LoginDatabase.h:72
@ LOGIN_UPD_BNET_FAILED_LOGINS
@ LOGIN_INS_BATTLE_PET_SLOTS
@ LOGIN_SEL_LAST_ATTEMPT_IP
Definition: LoginDatabase.h:92
@ LOGIN_UPD_REG_EMAIL
Definition: LoginDatabase.h:66
@ LOGIN_DEL_IP_NOT_BANNED
Definition: LoginDatabase.h:49
@ LOGIN_UPD_BNET_GAME_ACCOUNT_LINK
@ LOGIN_UPD_BNET_ACCOUNT_LOCK
@ LOGIN_SEL_ACCOUNT_BY_ID
Definition: LoginDatabase.h:52
@ LOGIN_SEL_BNET_ITEM_FAVORITE_APPEARANCES
@ LOGIN_INS_ALDL_IP_LOGGING
Definition: LoginDatabase.h:95
@ LOGIN_DEL_ACCOUNT_MUTED
@ LOGIN_REP_REALM_CHARACTERS
Definition: LoginDatabase.h:56
@ LOGIN_DEL_ACCOUNT_BANNED
Definition: LoginDatabase.h:39
@ LOGIN_SEL_ACCOUNT_TOYS
@ LOGIN_DEL_EXPIRED_IP_BANS
Definition: LoginDatabase.h:32
@ LOGIN_SEL_CHECK_PASSWORD_BY_NAME
Definition: LoginDatabase.h:81
@ LOGIN_INS_BATTLE_PETS
@ LOGIN_DEL_BATTLE_PETS
@ LOGIN_SEL_PINFO
Definition: LoginDatabase.h:82
@ MAX_LOGINDATABASE_STATEMENTS
@ LOGIN_INS_BNET_ACCOUNT_AUTO_BANNED
@ LOGIN_SEL_BNET_ACCOUNT_ID_BY_EMAIL
@ LOGIN_UPD_ACCOUNT_TOTP_SECRET
@ LOGIN_SEL_BNET_GAME_ACCOUNT_LIST_SMALL
@ LOGIN_UPD_LAST_ATTEMPT_IP
Definition: LoginDatabase.h:70
@ LOGIN_DEL_ACCOUNT_ACCESS
Definition: LoginDatabase.h:74
@ LOGIN_SEL_ACCOUNT_WHOIS
Definition: LoginDatabase.h:88
@ LOGIN_SEL_BNET_CHECK_PASSWORD_BY_EMAIL
@ LOGIN_UPD_USERNAME
Definition: LoginDatabase.h:64
@ LOGIN_INS_IP_BANNED
Definition: LoginDatabase.h:48
@ LOGIN_SEL_SECRET_DIGEST
@ LOGIN_SEL_BNET_ACCOUNT_ID_BY_GAME_ACCOUNT
@ LOGIN_SEL_REALMLIST
Definition: LoginDatabase.h:31
@ LOGIN_DEL_RBAC_ACCOUNT_PERMISSION
@ LOGIN_SEL_IP_BANNED_BY_IP
Definition: LoginDatabase.h:51
@ LOGIN_GET_GMLEVEL_BY_REALMID
Definition: LoginDatabase.h:78
@ LOGIN_UPD_EXPANSION
Definition: LoginDatabase.h:60
@ LOGIN_UPD_ACCOUNT_LOCK_COUNTRY
Definition: LoginDatabase.h:62
@ LOGIN_SEL_REALMLIST_SECURITY_LEVEL
Definition: LoginDatabase.h:89
@ LOGIN_SEL_RBAC_ACCOUNT_PERMISSIONS
@ LOGIN_INS_SECRET_DIGEST
@ LOGIN_SEL_ACCOUNT_MUTE_INFO
@ LOGIN_UPD_BNET_LOGON
@ LOGIN_UPD_ACCOUNT_NOT_BANNED
Definition: LoginDatabase.h:54
@ LOGIN_SEL_GM_ACCOUNTS
Definition: LoginDatabase.h:84
@ LOGIN_UPD_LOGON
Definition: LoginDatabase.h:42
@ LOGIN_SEL_ACCOUNT_LIST_BY_NAME
Definition: LoginDatabase.h:44
@ LOGIN_UPD_BNET_AUTHENTICATION
@ LOGIN_SEL_ACCOUNT_MOUNTS
@ LOGIN_INS_BNET_TRANSMOG_ILLUSIONS
@ LOGIN_SEL_ACCOUNT_TOTP_SECRET
@ LOGIN_INS_FALP_IP_LOGGING
Definition: LoginDatabase.h:98
@ LOGIN_SEL_BNET_EXISTING_AUTHENTICATION
@ LOGIN_UPD_MUTE_TIME
Definition: LoginDatabase.h:67
@ LOGIN_SEL_BNET_ACCOUNT_INFO
@ LOGIN_REP_ACCOUNT_MOUNTS
@ LOGIN_UPD_LAST_CHAR_UNDELETE
@ LOGIN_DEL_BATTLE_PET_DECLINED_NAME
@ LOGIN_UPD_LAST_IP
Definition: LoginDatabase.h:69
@ LOGIN_SEL_ACCOUNT_ACCESS_BY_ID
@ LOGIN_UPD_BNET_GAME_ACCOUNT_LOGIN_INFO
@ LOGIN_INS_BATTLE_PET_DECLINED_NAME
@ LOGIN_INS_BNET_ACCOUNT
@ LOGIN_UPD_ACCOUNT_LOCK
Definition: LoginDatabase.h:61
@ LOGIN_SEL_AUTOBROADCAST
Definition: LoginDatabase.h:91
@ LOGIN_SEL_SUM_REALM_CHARACTERS
Definition: LoginDatabase.h:57
@ LOGIN_UPD_ACCOUNT_ONLINE
Definition: LoginDatabase.h:71
@ LOGIN_GET_USERNAME_BY_ID
Definition: LoginDatabase.h:79
@ LOGIN_UPD_BATTLE_PETS
@ LOGIN_DEL_ACCOUNT
Definition: LoginDatabase.h:90
@ LOGIN_SEL_BNET_CHARACTER_COUNTS_BY_ACCOUNT_ID
@ LOGIN_SEL_LAST_IP
Definition: LoginDatabase.h:93
@ LOGIN_INS_BNET_LAST_PLAYER_CHARACTERS
@ LOGIN_DEL_BATTLE_PET_SLOTS
@ LOGIN_INS_REALM_CHARACTERS_INIT
Definition: LoginDatabase.h:59
@ LOGIN_SEL_IP_INFO
Definition: LoginDatabase.h:34
@ LOGIN_DEL_SECRET_DIGEST
@ LOGIN_UPD_EXPIRED_ACCOUNT_BANS
Definition: LoginDatabase.h:33
@ LOGIN_SEL_ACCOUNT_INFO_CONTINUED_SESSION
Definition: LoginDatabase.h:41
@ LOGIN_SEL_ACCOUNT_BANNED_BY_USERNAME
Definition: LoginDatabase.h:38
@ LOGIN_SEL_ACCOUNT_HEIRLOOMS
@ LOGIN_DEL_BNET_EXPIRED_ACCOUNT_BANNED
@ LOGIN_SEL_BNET_TRANSMOG_ILLUSIONS
@ LOGIN_INS_FACL_IP_LOGGING
Definition: LoginDatabase.h:96
@ LOGIN_INS_CHAR_IP_LOGGING
Definition: LoginDatabase.h:97
@ LOGIN_DEL_BATTLE_PET_DECLINED_NAME_BY_OWNER
@ LOGIN_DEL_BNET_LAST_PLAYER_CHARACTERS
@ LOGIN_INS_ACCOUNT_ACCESS
Definition: LoginDatabase.h:76
@ LOGIN_DEL_REALM_CHARACTERS
Definition: LoginDatabase.h:55
@ LOGIN_SEL_CHECK_PASSWORD
Definition: LoginDatabase.h:80
@ LOGIN_SEL_PINFO_BANS
Definition: LoginDatabase.h:83
@ LOGIN_SEL_ACCOUNT_ID_BY_NAME
Definition: LoginDatabase.h:43
@ LOGIN_SEL_BNET_GAME_ACCOUNT_LIST
@ LOGIN_SEL_ACCOUNT_ACCESS
Definition: LoginDatabase.h:87
@ LOGIN_UPD_BNET_ACCOUNT_LOCK_CONTRY
@ LOGIN_SEL_BNET_MAX_ACCOUNT_INDEX
@ LOGIN_SEL_IP_BANNED_ALL
Definition: LoginDatabase.h:50
@ LOGIN_INS_IP_AUTO_BANNED
Definition: LoginDatabase.h:35
@ LOGIN_SEL_ACCOUNT_INFO
Definition: LoginDatabase.h:85
@ LOGIN_INS_RBAC_ACCOUNT_PERMISSION
@ LOGIN_SEL_BNET_ACCOUNT_EMAIL_BY_ID
@ LOGIN_SEL_BATTLE_PET_SLOTS
@ LOGIN_REP_ACCOUNT_HEIRLOOMS
@ LOGIN_SEL_BNET_LAST_PLAYER_CHARACTERS
@ LOGIN_INS_BNET_ITEM_FAVORITE_APPEARANCE
@ LOGIN_DEL_OLD_LOGS
Definition: LoginDatabase.h:73
@ LOGIN_SEL_ACCOUNT_BANNED_ALL
Definition: LoginDatabase.h:36
@ LOGIN_SEL_BNET_CHECK_PASSWORD
@ LOGIN_SEL_ACCOUNT_INFO_BY_NAME
Definition: LoginDatabase.h:45
@ LOGIN_UPD_BNET_EXISTING_AUTHENTICATION
@ LOGIN_SEL_BNET_ITEM_APPEARANCES
@ LOGIN_INS_ACCOUNT_MUTE
@ LOGIN_INS_BNET_ITEM_APPEARANCES
@ LOGIN_REP_ACCOUNT_TOYS
@ LOGIN_INS_ACCOUNT
Definition: LoginDatabase.h:58
@ LOGIN_DEL_BNET_ITEM_FAVORITE_APPEARANCE
ConnectionFlags
LoginDatabaseStatements Statements
virtual void DoPrepareStatements()=0