AzerothCore 3.3.5a
OpenSource WoW Emulator
Loading...
Searching...
No Matches
LoginDatabase.h File Reference
#include "MySQLConnection.h"

Go to the source code of this file.

Classes

class  LoginDatabaseConnection
 

Enumerations

enum  LoginDatabaseStatements : uint32 {
  LOGIN_SEL_REALMLIST ,
  LOGIN_DEL_EXPIRED_IP_BANS ,
  LOGIN_UPD_EXPIRED_ACCOUNT_BANS ,
  LOGIN_SEL_IP_INFO ,
  LOGIN_SEL_IP_BANNED ,
  LOGIN_INS_IP_AUTO_BANNED ,
  LOGIN_SEL_ACCOUNT_BANNED ,
  LOGIN_SEL_ACCOUNT_BANNED_ALL ,
  LOGIN_SEL_ACCOUNT_BANNED_BY_USERNAME ,
  LOGIN_INS_ACCOUNT_AUTO_BANNED ,
  LOGIN_DEL_ACCOUNT_BANNED ,
  LOGIN_UPD_LOGON ,
  LOGIN_UPD_LOGONPROOF ,
  LOGIN_SEL_LOGONCHALLENGE ,
  LOGIN_SEL_RECONNECTCHALLENGE ,
  LOGIN_UPD_FAILEDLOGINS ,
  LOGIN_SEL_FAILEDLOGINS ,
  LOGIN_SEL_ACCOUNT_ID_BY_NAME ,
  LOGIN_SEL_ACCOUNT_LIST_BY_NAME ,
  LOGIN_SEL_ACCOUNT_INFO_BY_NAME ,
  LOGIN_SEL_ACCOUNT_LIST_BY_EMAIL ,
  LOGIN_SEL_NUM_CHARS_ON_REALM ,
  LOGIN_SEL_REALM_CHARACTER_COUNTS ,
  LOGIN_SEL_ACCOUNT_BY_IP ,
  LOGIN_INS_IP_BANNED ,
  LOGIN_DEL_IP_NOT_BANNED ,
  LOGIN_SEL_IP_BANNED_ALL ,
  LOGIN_SEL_IP_BANNED_BY_IP ,
  LOGIN_SEL_ACCOUNT_BY_ID ,
  LOGIN_INS_ACCOUNT_BANNED ,
  LOGIN_UPD_ACCOUNT_NOT_BANNED ,
  LOGIN_DEL_REALM_CHARACTERS ,
  LOGIN_REP_REALM_CHARACTERS ,
  LOGIN_SEL_SUM_REALM_CHARACTERS ,
  LOGIN_INS_ACCOUNT ,
  LOGIN_INS_REALM_CHARACTERS_INIT ,
  LOGIN_UPD_EXPANSION ,
  LOGIN_UPD_ACCOUNT_LOCK ,
  LOGIN_UPD_ACCOUNT_LOCK_COUNTRY ,
  LOGIN_UPD_USERNAME ,
  LOGIN_UPD_MUTE_TIME ,
  LOGIN_UPD_MUTE_TIME_LOGIN ,
  LOGIN_UPD_LAST_IP ,
  LOGIN_UPD_LAST_ATTEMPT_IP ,
  LOGIN_UPD_ACCOUNT_ONLINE ,
  LOGIN_UPD_UPTIME_PLAYERS ,
  LOGIN_DEL_OLD_LOGS ,
  LOGIN_DEL_ACCOUNT_ACCESS ,
  LOGIN_DEL_ACCOUNT_ACCESS_BY_REALM ,
  LOGIN_INS_ACCOUNT_ACCESS ,
  LOGIN_GET_ACCOUNT_ID_BY_USERNAME ,
  LOGIN_GET_ACCOUNT_ACCESS_GMLEVEL ,
  LOGIN_GET_GMLEVEL_BY_REALMID ,
  LOGIN_GET_USERNAME_BY_ID ,
  LOGIN_SEL_CHECK_PASSWORD ,
  LOGIN_SEL_CHECK_PASSWORD_BY_NAME ,
  LOGIN_SEL_PINFO ,
  LOGIN_SEL_PINFO_BANS ,
  LOGIN_SEL_GM_ACCOUNTS ,
  LOGIN_SEL_ACCOUNT_INFO ,
  LOGIN_SEL_ACCOUNT_ACCESS_GMLEVEL_TEST ,
  LOGIN_SEL_ACCOUNT_ACCESS ,
  LOGIN_SEL_ACCOUNT_RECRUITER ,
  LOGIN_SEL_BANS ,
  LOGIN_SEL_ACCOUNT_WHOIS ,
  LOGIN_SEL_REALMLIST_SECURITY_LEVEL ,
  LOGIN_DEL_ACCOUNT ,
  LOGIN_SEL_AUTOBROADCAST ,
  LOGIN_SEL_MOTD ,
  LOGIN_REP_MOTD ,
  LOGIN_SEL_LAST_ATTEMPT_IP ,
  LOGIN_SEL_LAST_IP ,
  LOGIN_INS_ALDL_IP_LOGGING ,
  LOGIN_INS_FACL_IP_LOGGING ,
  LOGIN_INS_CHAR_IP_LOGGING ,
  LOGIN_INS_FALP_IP_LOGGING ,
  LOGIN_INS_ACCOUNT_MUTE ,
  LOGIN_SEL_ACCOUNT_MUTE_INFO ,
  LOGIN_DEL_ACCOUNT_MUTED ,
  LOGIN_INS_LOG ,
  LOGIN_SEL_SECRET_DIGEST ,
  LOGIN_INS_SECRET_DIGEST ,
  LOGIN_DEL_SECRET_DIGEST ,
  LOGIN_SEL_ACCOUNT_TOTP_SECRET ,
  LOGIN_UPD_ACCOUNT_TOTP_SECRET ,
  MAX_LOGINDATABASE_STATEMENTS
}
 

Enumeration Type Documentation

◆ LoginDatabaseStatements

Enumerator
LOGIN_SEL_REALMLIST 
LOGIN_DEL_EXPIRED_IP_BANS 
LOGIN_UPD_EXPIRED_ACCOUNT_BANS 
LOGIN_SEL_IP_INFO 
LOGIN_SEL_IP_BANNED 
LOGIN_INS_IP_AUTO_BANNED 
LOGIN_SEL_ACCOUNT_BANNED 
LOGIN_SEL_ACCOUNT_BANNED_ALL 
LOGIN_SEL_ACCOUNT_BANNED_BY_USERNAME 
LOGIN_INS_ACCOUNT_AUTO_BANNED 
LOGIN_DEL_ACCOUNT_BANNED 
LOGIN_UPD_LOGON 
LOGIN_UPD_LOGONPROOF 
LOGIN_SEL_LOGONCHALLENGE 
LOGIN_SEL_RECONNECTCHALLENGE 
LOGIN_UPD_FAILEDLOGINS 
LOGIN_SEL_FAILEDLOGINS 
LOGIN_SEL_ACCOUNT_ID_BY_NAME 
LOGIN_SEL_ACCOUNT_LIST_BY_NAME 
LOGIN_SEL_ACCOUNT_INFO_BY_NAME 
LOGIN_SEL_ACCOUNT_LIST_BY_EMAIL 
LOGIN_SEL_NUM_CHARS_ON_REALM 
LOGIN_SEL_REALM_CHARACTER_COUNTS 
LOGIN_SEL_ACCOUNT_BY_IP 
LOGIN_INS_IP_BANNED 
LOGIN_DEL_IP_NOT_BANNED 
LOGIN_SEL_IP_BANNED_ALL 
LOGIN_SEL_IP_BANNED_BY_IP 
LOGIN_SEL_ACCOUNT_BY_ID 
LOGIN_INS_ACCOUNT_BANNED 
LOGIN_UPD_ACCOUNT_NOT_BANNED 
LOGIN_DEL_REALM_CHARACTERS 
LOGIN_REP_REALM_CHARACTERS 
LOGIN_SEL_SUM_REALM_CHARACTERS 
LOGIN_INS_ACCOUNT 
LOGIN_INS_REALM_CHARACTERS_INIT 
LOGIN_UPD_EXPANSION 
LOGIN_UPD_ACCOUNT_LOCK 
LOGIN_UPD_ACCOUNT_LOCK_COUNTRY 
LOGIN_UPD_USERNAME 
LOGIN_UPD_MUTE_TIME 
LOGIN_UPD_MUTE_TIME_LOGIN 
LOGIN_UPD_LAST_IP 
LOGIN_UPD_LAST_ATTEMPT_IP 
LOGIN_UPD_ACCOUNT_ONLINE 
LOGIN_UPD_UPTIME_PLAYERS 
LOGIN_DEL_OLD_LOGS 
LOGIN_DEL_ACCOUNT_ACCESS 
LOGIN_DEL_ACCOUNT_ACCESS_BY_REALM 
LOGIN_INS_ACCOUNT_ACCESS 
LOGIN_GET_ACCOUNT_ID_BY_USERNAME 
LOGIN_GET_ACCOUNT_ACCESS_GMLEVEL 
LOGIN_GET_GMLEVEL_BY_REALMID 
LOGIN_GET_USERNAME_BY_ID 
LOGIN_SEL_CHECK_PASSWORD 
LOGIN_SEL_CHECK_PASSWORD_BY_NAME 
LOGIN_SEL_PINFO 
LOGIN_SEL_PINFO_BANS 
LOGIN_SEL_GM_ACCOUNTS 
LOGIN_SEL_ACCOUNT_INFO 
LOGIN_SEL_ACCOUNT_ACCESS_GMLEVEL_TEST 
LOGIN_SEL_ACCOUNT_ACCESS 
LOGIN_SEL_ACCOUNT_RECRUITER 
LOGIN_SEL_BANS 
LOGIN_SEL_ACCOUNT_WHOIS 
LOGIN_SEL_REALMLIST_SECURITY_LEVEL 
LOGIN_DEL_ACCOUNT 
LOGIN_SEL_AUTOBROADCAST 
LOGIN_SEL_MOTD 
LOGIN_REP_MOTD 
LOGIN_SEL_LAST_ATTEMPT_IP 
LOGIN_SEL_LAST_IP 
LOGIN_INS_ALDL_IP_LOGGING 
LOGIN_INS_FACL_IP_LOGGING 
LOGIN_INS_CHAR_IP_LOGGING 
LOGIN_INS_FALP_IP_LOGGING 
LOGIN_INS_ACCOUNT_MUTE 
LOGIN_SEL_ACCOUNT_MUTE_INFO 
LOGIN_DEL_ACCOUNT_MUTED 
LOGIN_INS_LOG 
LOGIN_SEL_SECRET_DIGEST 
LOGIN_INS_SECRET_DIGEST 
LOGIN_DEL_SECRET_DIGEST 
LOGIN_SEL_ACCOUNT_TOTP_SECRET 
LOGIN_UPD_ACCOUNT_TOTP_SECRET 
MAX_LOGINDATABASE_STATEMENTS 
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
107
111
113
117
120
122};
@ LOGIN_UPD_MUTE_TIME_LOGIN
Definition: LoginDatabase.h:72
@ LOGIN_INS_ACCOUNT_BANNED
Definition: LoginDatabase.h:60
@ LOGIN_SEL_ACCOUNT_LIST_BY_EMAIL
Definition: LoginDatabase.h:51
@ LOGIN_INS_ACCOUNT_AUTO_BANNED
Definition: LoginDatabase.h:40
@ LOGIN_INS_LOG
Definition: LoginDatabase.h:112
@ LOGIN_SEL_ACCOUNT_BY_IP
Definition: LoginDatabase.h:54
@ LOGIN_DEL_ACCOUNT_ACCESS_BY_REALM
Definition: LoginDatabase.h:79
@ LOGIN_REP_MOTD
Definition: LoginDatabase.h:100
@ LOGIN_GET_ACCOUNT_ID_BY_USERNAME
Definition: LoginDatabase.h:81
@ LOGIN_UPD_UPTIME_PLAYERS
Definition: LoginDatabase.h:76
@ LOGIN_SEL_LAST_ATTEMPT_IP
Definition: LoginDatabase.h:101
@ LOGIN_DEL_IP_NOT_BANNED
Definition: LoginDatabase.h:56
@ LOGIN_SEL_ACCOUNT_BY_ID
Definition: LoginDatabase.h:59
@ LOGIN_INS_ALDL_IP_LOGGING
Definition: LoginDatabase.h:103
@ LOGIN_DEL_ACCOUNT_MUTED
Definition: LoginDatabase.h:110
@ LOGIN_REP_REALM_CHARACTERS
Definition: LoginDatabase.h:63
@ LOGIN_DEL_ACCOUNT_BANNED
Definition: LoginDatabase.h:41
@ LOGIN_DEL_EXPIRED_IP_BANS
Definition: LoginDatabase.h:32
@ LOGIN_SEL_CHECK_PASSWORD_BY_NAME
Definition: LoginDatabase.h:86
@ LOGIN_SEL_BANS
Definition: LoginDatabase.h:94
@ LOGIN_SEL_PINFO
Definition: LoginDatabase.h:87
@ MAX_LOGINDATABASE_STATEMENTS
Definition: LoginDatabase.h:121
@ LOGIN_UPD_ACCOUNT_TOTP_SECRET
Definition: LoginDatabase.h:119
@ LOGIN_SEL_IP_BANNED
Definition: LoginDatabase.h:35
@ LOGIN_UPD_LAST_ATTEMPT_IP
Definition: LoginDatabase.h:74
@ LOGIN_DEL_ACCOUNT_ACCESS
Definition: LoginDatabase.h:78
@ LOGIN_SEL_ACCOUNT_WHOIS
Definition: LoginDatabase.h:95
@ LOGIN_UPD_USERNAME
Definition: LoginDatabase.h:70
@ LOGIN_INS_IP_BANNED
Definition: LoginDatabase.h:55
@ LOGIN_SEL_SECRET_DIGEST
Definition: LoginDatabase.h:114
@ LOGIN_SEL_REALMLIST
Definition: LoginDatabase.h:31
@ LOGIN_SEL_IP_BANNED_BY_IP
Definition: LoginDatabase.h:58
@ LOGIN_GET_GMLEVEL_BY_REALMID
Definition: LoginDatabase.h:83
@ LOGIN_UPD_EXPANSION
Definition: LoginDatabase.h:67
@ LOGIN_UPD_ACCOUNT_LOCK_COUNTRY
Definition: LoginDatabase.h:69
@ LOGIN_SEL_REALMLIST_SECURITY_LEVEL
Definition: LoginDatabase.h:96
@ LOGIN_INS_SECRET_DIGEST
Definition: LoginDatabase.h:115
@ LOGIN_SEL_ACCOUNT_MUTE_INFO
Definition: LoginDatabase.h:109
@ LOGIN_UPD_ACCOUNT_NOT_BANNED
Definition: LoginDatabase.h:61
@ LOGIN_SEL_GM_ACCOUNTS
Definition: LoginDatabase.h:89
@ LOGIN_UPD_LOGON
Definition: LoginDatabase.h:42
@ LOGIN_SEL_ACCOUNT_LIST_BY_NAME
Definition: LoginDatabase.h:49
@ LOGIN_SEL_ACCOUNT_TOTP_SECRET
Definition: LoginDatabase.h:118
@ LOGIN_INS_FALP_IP_LOGGING
Definition: LoginDatabase.h:106
@ LOGIN_UPD_MUTE_TIME
Definition: LoginDatabase.h:71
@ LOGIN_UPD_LAST_IP
Definition: LoginDatabase.h:73
@ LOGIN_UPD_LOGONPROOF
Definition: LoginDatabase.h:43
@ LOGIN_UPD_ACCOUNT_LOCK
Definition: LoginDatabase.h:68
@ LOGIN_SEL_AUTOBROADCAST
Definition: LoginDatabase.h:98
@ LOGIN_SEL_SUM_REALM_CHARACTERS
Definition: LoginDatabase.h:64
@ LOGIN_UPD_ACCOUNT_ONLINE
Definition: LoginDatabase.h:75
@ LOGIN_GET_USERNAME_BY_ID
Definition: LoginDatabase.h:84
@ LOGIN_DEL_ACCOUNT
Definition: LoginDatabase.h:97
@ LOGIN_SEL_LAST_IP
Definition: LoginDatabase.h:102
@ LOGIN_SEL_FAILEDLOGINS
Definition: LoginDatabase.h:47
@ LOGIN_INS_REALM_CHARACTERS_INIT
Definition: LoginDatabase.h:66
@ LOGIN_SEL_IP_INFO
Definition: LoginDatabase.h:34
@ LOGIN_SEL_NUM_CHARS_ON_REALM
Definition: LoginDatabase.h:52
@ LOGIN_DEL_SECRET_DIGEST
Definition: LoginDatabase.h:116
@ LOGIN_UPD_EXPIRED_ACCOUNT_BANS
Definition: LoginDatabase.h:33
@ LOGIN_SEL_ACCOUNT_BANNED_BY_USERNAME
Definition: LoginDatabase.h:39
@ LOGIN_INS_FACL_IP_LOGGING
Definition: LoginDatabase.h:104
@ LOGIN_INS_CHAR_IP_LOGGING
Definition: LoginDatabase.h:105
@ LOGIN_SEL_RECONNECTCHALLENGE
Definition: LoginDatabase.h:45
@ LOGIN_INS_ACCOUNT_ACCESS
Definition: LoginDatabase.h:80
@ LOGIN_DEL_REALM_CHARACTERS
Definition: LoginDatabase.h:62
@ LOGIN_SEL_CHECK_PASSWORD
Definition: LoginDatabase.h:85
@ LOGIN_SEL_PINFO_BANS
Definition: LoginDatabase.h:88
@ LOGIN_SEL_ACCOUNT_ID_BY_NAME
Definition: LoginDatabase.h:48
@ LOGIN_UPD_FAILEDLOGINS
Definition: LoginDatabase.h:46
@ LOGIN_SEL_ACCOUNT_ACCESS
Definition: LoginDatabase.h:92
@ LOGIN_SEL_IP_BANNED_ALL
Definition: LoginDatabase.h:57
@ LOGIN_SEL_ACCOUNT_RECRUITER
Definition: LoginDatabase.h:93
@ LOGIN_INS_IP_AUTO_BANNED
Definition: LoginDatabase.h:36
@ LOGIN_SEL_ACCOUNT_INFO
Definition: LoginDatabase.h:90
@ LOGIN_SEL_ACCOUNT_BANNED
Definition: LoginDatabase.h:37
@ LOGIN_SEL_LOGONCHALLENGE
Definition: LoginDatabase.h:44
@ LOGIN_SEL_ACCOUNT_ACCESS_GMLEVEL_TEST
Definition: LoginDatabase.h:91
@ LOGIN_DEL_OLD_LOGS
Definition: LoginDatabase.h:77
@ LOGIN_SEL_ACCOUNT_BANNED_ALL
Definition: LoginDatabase.h:38
@ LOGIN_GET_ACCOUNT_ACCESS_GMLEVEL
Definition: LoginDatabase.h:82
@ LOGIN_SEL_REALM_CHARACTER_COUNTS
Definition: LoginDatabase.h:53
@ LOGIN_SEL_MOTD
Definition: LoginDatabase.h:99
@ LOGIN_SEL_ACCOUNT_INFO_BY_NAME
Definition: LoginDatabase.h:50
@ LOGIN_INS_ACCOUNT_MUTE
Definition: LoginDatabase.h:108
@ LOGIN_INS_ACCOUNT
Definition: LoginDatabase.h:65