void AuthDatabase::LoadQueries()
{
    // account queries
    LoadQuery(AUTH_SELECT_ACCOUNT, "SELECT *, UNIX_TIMESTAMP(`subscription_time`) - UNIX_TIMESTAMP(NOW()) AS `subscription_time` FROM `account` WHERE `username` = '%s'");
    LoadQuery(AUTH_UPDATE_ACCOUNT_STATE, "UPDATE account SET online = %u WHERE account_id = %u");
    LoadQuery(AUTH_SELECT_ACCOUNT_SESSION_KEY, "SELECT *, UNIX_TIMESTAMP(`subscription_time`) - UNIX_TIMESTAMP(NOW()) AS `subscription_time` FROM account WHERE session_key = '%s'");
    LoadQuery(AUTH_UPDATE_ACCOUNT_SESSION_KEY, "UPDATE account SET session_key = '%s' WHERE account_id = %u");
    LoadQuery(AUTH_UPDATE_ACCOUNT_CHARS, "REPLACE INTO `realm_characters` (`account_id`,`realm_id`, `num_characters`) VALUES (%u, %u, %u)");
    LoadQuery(AUTH_SELECT_ACCOUNT_CHARACTERS, "SELECT * FROM `realm_characters` WHERE `account_id` = %u");
    LoadQuery(AUTH_SEARCH_FRIEND, "SELECT * FROM `realm_characters` WHERE `account_id` = (SELECT `account_id` FROM `account` WHERE `pseudo` = '%s')");

    // banned_ip queries
    LoadQuery(AUTH_SELECT_IP_BANNED, "SELECT * FROM ip_banned WHERE ip = '%s'");

    // realmlist queries
    LoadQuery(AUTH_SELECT_ALL_SERVERS, "SELECT realm_id, status, population, subscription FROM realmlist");
    LoadQuery(AUTH_SELECT_SERVER, "SELECT address, port FROM realmlist WHERE realm_id = %u");
}
Exemple #2
0
void CharDatabase::LoadQueries()
{
    LoadQuery(SELECT_CHARACTER_MAX_GUID, "SELECT MAX(guid) FROM characters");
    LoadQuery(SELECT_CHARACTERS_BY_ACCOUNT_ID, "SELECT * FROM characters WHERE account_id = ?");
    LoadQuery(SELECT_CHARACTER_BY_GUID, "SELECT * FROM characters WHERE guid = ?");
    LoadQuery(SELECT_CHARACTER_BY_GUID_AND_ACCOUNT, "SELECT * FROM characters WHERE guid = ? AND account_id = ?");
    LoadQuery(SELECT_CHARACTER_BY_NAME, "SELECT guid FROM characters WHERE name = ?");
    LoadQuery(DELETE_CHARACTER_BY_GUID, "DELETE FROM characters WHERE guid = ?");
    LoadQuery(INSERT_CHARACTER, "INSERT INTO characters (guid, account_id, name, breed, gender, level, xp, skin_color, hair_color, pupil_color, skin_color_factor, hair_color_factor, cloth, face, title, position_x, position_y, position_z, direction, instance_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
    LoadQuery(UPDATE_CHARACTER, "UPDATE characters SET position_x = ?, position_y = ?, position_z = ?, direction = ?, instance_id = ? WHERE guid = ?");
}