TrinityCore
LoginDatabase.h File Reference
#include "MySQLConnection.h"
+ Include dependency graph for LoginDatabase.h:
+ This graph shows which files directly or indirectly include this file:

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_INS_IP_AUTO_BANNED , LOGIN_SEL_ACCOUNT_BANNED_ALL , LOGIN_SEL_ACCOUNT_BANNED_BY_FILTER , LOGIN_SEL_ACCOUNT_BANNED_BY_USERNAME ,
  LOGIN_DEL_ACCOUNT_BANNED , LOGIN_UPD_ACCOUNT_INFO_CONTINUED_SESSION , LOGIN_SEL_ACCOUNT_INFO_CONTINUED_SESSION , LOGIN_UPD_LOGON ,
  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_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_INS_LOG , LOGIN_UPD_USERNAME , LOGIN_UPD_EMAIL , LOGIN_UPD_REG_EMAIL ,
  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_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_SECLEVEL_TEST ,
  LOGIN_SEL_ACCOUNT_ACCESS , LOGIN_SEL_ACCOUNT_WHOIS , LOGIN_SEL_REALMLIST_SECURITY_LEVEL , LOGIN_DEL_ACCOUNT ,
  LOGIN_SEL_AUTOBROADCAST , LOGIN_SEL_LAST_ATTEMPT_IP , LOGIN_SEL_LAST_IP , LOGIN_GET_EMAIL_BY_ID ,
  LOGIN_INS_ALDL_IP_LOGGING , LOGIN_INS_FACL_IP_LOGGING , LOGIN_INS_CHAR_IP_LOGGING , LOGIN_INS_FALP_IP_LOGGING ,
  LOGIN_SEL_ACCOUNT_ACCESS_BY_ID , LOGIN_SEL_RBAC_ACCOUNT_PERMISSIONS , LOGIN_INS_RBAC_ACCOUNT_PERMISSION , LOGIN_DEL_RBAC_ACCOUNT_PERMISSION ,
  LOGIN_INS_ACCOUNT_MUTE , LOGIN_SEL_ACCOUNT_MUTE_INFO , LOGIN_DEL_ACCOUNT_MUTED , LOGIN_SEL_SECRET_DIGEST ,
  LOGIN_INS_SECRET_DIGEST , LOGIN_DEL_SECRET_DIGEST , LOGIN_SEL_ACCOUNT_TOTP_SECRET , LOGIN_UPD_ACCOUNT_TOTP_SECRET ,
  LOGIN_SEL_BNET_AUTHENTICATION , LOGIN_UPD_BNET_AUTHENTICATION , LOGIN_SEL_BNET_EXISTING_AUTHENTICATION , LOGIN_SEL_BNET_EXISTING_AUTHENTICATION_BY_ID ,
  LOGIN_UPD_BNET_EXISTING_AUTHENTICATION , LOGIN_SEL_BNET_ACCOUNT_INFO , LOGIN_UPD_BNET_LAST_LOGIN_INFO , LOGIN_UPD_BNET_GAME_ACCOUNT_LOGIN_INFO ,
  LOGIN_SEL_BNET_CHARACTER_COUNTS_BY_ACCOUNT_ID , LOGIN_SEL_BNET_CHARACTER_COUNTS_BY_BNET_ID , LOGIN_SEL_BNET_LAST_PLAYER_CHARACTERS , LOGIN_DEL_BNET_LAST_PLAYER_CHARACTERS ,
  LOGIN_INS_BNET_LAST_PLAYER_CHARACTERS , LOGIN_INS_BNET_ACCOUNT , LOGIN_SEL_BNET_ACCOUNT_EMAIL_BY_ID , LOGIN_SEL_BNET_ACCOUNT_ID_BY_EMAIL ,
  LOGIN_UPD_BNET_LOGON , LOGIN_SEL_BNET_CHECK_PASSWORD , LOGIN_SEL_BNET_CHECK_PASSWORD_BY_EMAIL , LOGIN_UPD_BNET_ACCOUNT_LOCK ,
  LOGIN_UPD_BNET_ACCOUNT_LOCK_CONTRY , LOGIN_SEL_BNET_ACCOUNT_ID_BY_GAME_ACCOUNT , LOGIN_UPD_BNET_GAME_ACCOUNT_LINK , LOGIN_SEL_BNET_MAX_ACCOUNT_INDEX ,
  LOGIN_SEL_BNET_GAME_ACCOUNT_LIST_SMALL , LOGIN_SEL_BNET_GAME_ACCOUNT_LIST , LOGIN_UPD_BNET_FAILED_LOGINS , LOGIN_INS_BNET_ACCOUNT_AUTO_BANNED ,
  LOGIN_DEL_BNET_EXPIRED_ACCOUNT_BANNED , LOGIN_UPD_BNET_RESET_FAILED_LOGINS , LOGIN_SEL_LAST_CHAR_UNDELETE , LOGIN_UPD_LAST_CHAR_UNDELETE ,
  LOGIN_SEL_ACCOUNT_TOYS , LOGIN_REP_ACCOUNT_TOYS , LOGIN_SEL_BATTLE_PETS , LOGIN_INS_BATTLE_PETS ,
  LOGIN_DEL_BATTLE_PETS , LOGIN_DEL_BATTLE_PETS_BY_OWNER , LOGIN_UPD_BATTLE_PETS , LOGIN_SEL_BATTLE_PET_SLOTS ,
  LOGIN_INS_BATTLE_PET_SLOTS , LOGIN_DEL_BATTLE_PET_SLOTS , LOGIN_INS_BATTLE_PET_DECLINED_NAME , LOGIN_DEL_BATTLE_PET_DECLINED_NAME ,
  LOGIN_DEL_BATTLE_PET_DECLINED_NAME_BY_OWNER , LOGIN_SEL_ACCOUNT_HEIRLOOMS , LOGIN_REP_ACCOUNT_HEIRLOOMS , LOGIN_SEL_ACCOUNT_MOUNTS ,
  LOGIN_REP_ACCOUNT_MOUNTS , LOGIN_SEL_BNET_ITEM_APPEARANCES , LOGIN_INS_BNET_ITEM_APPEARANCES , LOGIN_SEL_BNET_ITEM_FAVORITE_APPEARANCES ,
  LOGIN_INS_BNET_ITEM_FAVORITE_APPEARANCE , LOGIN_DEL_BNET_ITEM_FAVORITE_APPEARANCE , LOGIN_SEL_BNET_TRANSMOG_ILLUSIONS , LOGIN_INS_BNET_TRANSMOG_ILLUSIONS ,
  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_INS_IP_AUTO_BANNED 
LOGIN_SEL_ACCOUNT_BANNED_ALL 
LOGIN_SEL_ACCOUNT_BANNED_BY_FILTER 
LOGIN_SEL_ACCOUNT_BANNED_BY_USERNAME 
LOGIN_DEL_ACCOUNT_BANNED 
LOGIN_UPD_ACCOUNT_INFO_CONTINUED_SESSION 
LOGIN_SEL_ACCOUNT_INFO_CONTINUED_SESSION 
LOGIN_UPD_LOGON 
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_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_INS_LOG 
LOGIN_UPD_USERNAME 
LOGIN_UPD_EMAIL 
LOGIN_UPD_REG_EMAIL 
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_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_SECLEVEL_TEST 
LOGIN_SEL_ACCOUNT_ACCESS 
LOGIN_SEL_ACCOUNT_WHOIS 
LOGIN_SEL_REALMLIST_SECURITY_LEVEL 
LOGIN_DEL_ACCOUNT 
LOGIN_SEL_AUTOBROADCAST 
LOGIN_SEL_LAST_ATTEMPT_IP 
LOGIN_SEL_LAST_IP 
LOGIN_GET_EMAIL_BY_ID 
LOGIN_INS_ALDL_IP_LOGGING 
LOGIN_INS_FACL_IP_LOGGING 
LOGIN_INS_CHAR_IP_LOGGING 
LOGIN_INS_FALP_IP_LOGGING 
LOGIN_SEL_ACCOUNT_ACCESS_BY_ID 
LOGIN_SEL_RBAC_ACCOUNT_PERMISSIONS 
LOGIN_INS_RBAC_ACCOUNT_PERMISSION 
LOGIN_DEL_RBAC_ACCOUNT_PERMISSION 
LOGIN_INS_ACCOUNT_MUTE 
LOGIN_SEL_ACCOUNT_MUTE_INFO 
LOGIN_DEL_ACCOUNT_MUTED 
LOGIN_SEL_SECRET_DIGEST 
LOGIN_INS_SECRET_DIGEST 
LOGIN_DEL_SECRET_DIGEST 
LOGIN_SEL_ACCOUNT_TOTP_SECRET 
LOGIN_UPD_ACCOUNT_TOTP_SECRET 
LOGIN_SEL_BNET_AUTHENTICATION 
LOGIN_UPD_BNET_AUTHENTICATION 
LOGIN_SEL_BNET_EXISTING_AUTHENTICATION 
LOGIN_SEL_BNET_EXISTING_AUTHENTICATION_BY_ID 
LOGIN_UPD_BNET_EXISTING_AUTHENTICATION 
LOGIN_SEL_BNET_ACCOUNT_INFO 
LOGIN_UPD_BNET_LAST_LOGIN_INFO 
LOGIN_UPD_BNET_GAME_ACCOUNT_LOGIN_INFO 
LOGIN_SEL_BNET_CHARACTER_COUNTS_BY_ACCOUNT_ID 
LOGIN_SEL_BNET_CHARACTER_COUNTS_BY_BNET_ID 
LOGIN_SEL_BNET_LAST_PLAYER_CHARACTERS 
LOGIN_DEL_BNET_LAST_PLAYER_CHARACTERS 
LOGIN_INS_BNET_LAST_PLAYER_CHARACTERS 
LOGIN_INS_BNET_ACCOUNT 
LOGIN_SEL_BNET_ACCOUNT_EMAIL_BY_ID 
LOGIN_SEL_BNET_ACCOUNT_ID_BY_EMAIL 
LOGIN_UPD_BNET_LOGON 
LOGIN_SEL_BNET_CHECK_PASSWORD 
LOGIN_SEL_BNET_CHECK_PASSWORD_BY_EMAIL 
LOGIN_UPD_BNET_ACCOUNT_LOCK 
LOGIN_UPD_BNET_ACCOUNT_LOCK_CONTRY 
LOGIN_SEL_BNET_ACCOUNT_ID_BY_GAME_ACCOUNT 
LOGIN_UPD_BNET_GAME_ACCOUNT_LINK 
LOGIN_SEL_BNET_MAX_ACCOUNT_INDEX 
LOGIN_SEL_BNET_GAME_ACCOUNT_LIST_SMALL 
LOGIN_SEL_BNET_GAME_ACCOUNT_LIST 
LOGIN_UPD_BNET_FAILED_LOGINS 
LOGIN_INS_BNET_ACCOUNT_AUTO_BANNED 
LOGIN_DEL_BNET_EXPIRED_ACCOUNT_BANNED 
LOGIN_UPD_BNET_RESET_FAILED_LOGINS 
LOGIN_SEL_LAST_CHAR_UNDELETE 
LOGIN_UPD_LAST_CHAR_UNDELETE 
LOGIN_SEL_ACCOUNT_TOYS 
LOGIN_REP_ACCOUNT_TOYS 
LOGIN_SEL_BATTLE_PETS 
LOGIN_INS_BATTLE_PETS 
LOGIN_DEL_BATTLE_PETS 
LOGIN_DEL_BATTLE_PETS_BY_OWNER 
LOGIN_UPD_BATTLE_PETS 
LOGIN_SEL_BATTLE_PET_SLOTS 
LOGIN_INS_BATTLE_PET_SLOTS 
LOGIN_DEL_BATTLE_PET_SLOTS 
LOGIN_INS_BATTLE_PET_DECLINED_NAME 
LOGIN_DEL_BATTLE_PET_DECLINED_NAME 
LOGIN_DEL_BATTLE_PET_DECLINED_NAME_BY_OWNER 
LOGIN_SEL_ACCOUNT_HEIRLOOMS 
LOGIN_REP_ACCOUNT_HEIRLOOMS 
LOGIN_SEL_ACCOUNT_MOUNTS 
LOGIN_REP_ACCOUNT_MOUNTS 
LOGIN_SEL_BNET_ITEM_APPEARANCES 
LOGIN_INS_BNET_ITEM_APPEARANCES 
LOGIN_SEL_BNET_ITEM_FAVORITE_APPEARANCES 
LOGIN_INS_BNET_ITEM_FAVORITE_APPEARANCE 
LOGIN_DEL_BNET_ITEM_FAVORITE_APPEARANCE 
LOGIN_SEL_BNET_TRANSMOG_ILLUSIONS 
LOGIN_INS_BNET_TRANSMOG_ILLUSIONS 
MAX_LOGINDATABASE_STATEMENTS 

Definition at line 23 of file LoginDatabase.h.