24 #include <boost/asio/post.hpp>
30 #define ERR_UH LOG_STREAM(err, log_mp_user_handler)
31 #define WRN_UH LOG_STREAM(warn, log_mp_user_handler)
32 #define LOG_UH LOG_STREAM(info, log_mp_user_handler)
33 #define DBG_UH LOG_STREAM(debug, log_mp_user_handler)
36 const int USER_INACTIVE = 1;
37 const int USER_IGNORE = 2;
42 , db_users_table_(
c[
"db_users_table"].str())
43 , db_extra_table_(
c[
"db_extra_table"].str())
47 mp_mod_group_ = std::stoi(
c[
"mp_mod_group"].str());
49 ERR_UH <<
"Failed to convert the mp_mod_group value of '" <<
c[
"mp_mod_group"].str() <<
"' into an int! Defaulting to " << mp_mod_group_ <<
".";
53 bool fuh::login(
const std::string& name,
const std::string& password) {
59 return password == hash;
61 ERR_UH <<
"Invalid hash for user '" << name <<
"'";
64 }
catch (
const error&
e) {
65 ERR_UH <<
"Could not retrieve hash for user '" << name <<
"' :" <<
e.message;
81 }
catch (
const error&
e) {
82 ERR_UH <<
"Could not retrieve hash for user '" << name <<
"' :" <<
e.message;
87 return hash.substr(0,12);
93 ERR_UH <<
"Error getting salt from hash of user '" << name <<
"': " <<
err.what();
115 return user_type != USER_INACTIVE && user_type != USER_IGNORE;
135 switch(
b.get_ban_type())
140 LOG_UH <<
"User '" << name <<
"' ip " << addr <<
" banned by IP address";
141 return {
BAN_IP,
b.get_ban_duration() };
143 LOG_UH <<
"User '" << name <<
"' uid " <<
b.get_user_id() <<
" banned by uid";
144 return {
BAN_USER,
b.get_ban_duration() };
146 LOG_UH <<
"User '" << name <<
"' email " <<
b.get_email() <<
" banned by email address";
149 ERR_UH <<
"Invalid ban type '" <<
b.get_ban_type() <<
"' returned for user '" << name <<
"'";
156 throw error(
"No user with the name '" + name +
"' exists.");
162 std::string reg_string = ctime(®_date);
163 std::string ll_string;
166 ll_string = ctime(&ll_date);
168 ll_string =
"Never\n";
171 std::stringstream
info;
172 info <<
"Name: " << name <<
"\n"
173 <<
"Registered: " << reg_string
174 <<
"Last login: " << ll_string;
176 info <<
"This account is currently inactive.\n";
211 boost::asio::post([
this, &
s, player, player_id, offset, &io_service, search_game_name, search_content_type, search_content] {
212 boost::asio::post(io_service, [player, &
s, doc =
conn_.
get_game_history(player_id, offset, search_game_name, search_content_type, search_content)]{
213 s.send_to_player(player, *doc);
218 void fuh::db_insert_game_info(
const std::string& uuid,
int game_id,
const std::string& version,
const std::string& name,
int reload,
int observers,
int is_public,
int has_password){
226 void fuh::db_insert_game_player_info(
const std::string& uuid,
int game_id,
const std::string& username,
int side_number,
int is_host,
const std::string& faction,
const std::string& version,
const std::string& source,
const std::string& current_user,
const std::string& leaders){
230 unsigned long long fuh::db_insert_game_content_info(
const std::string& uuid,
int game_id,
const std::string&
type,
const std::string& name,
const std::string&
id,
const std::string& addon_id,
const std::string& addon_version){
239 boost::asio::post([
this, limit, &io_service] {
240 ERR_UH <<
"async test query starts!";
242 boost::asio::post(io_service, [
i]{ ERR_UH <<
"async test query output: " <<
i; });
250 void fuh::db_insert_addon_info(
const std::string& instance_version,
const std::string&
id,
const std::string& name,
const std::string&
type,
const std::string& version,
bool forum_auth,
int topic_id,
const std::string uploader) {
254 unsigned long long fuh::db_insert_login(
const std::string& username,
const std::string& ip,
const std::string& version) {
282 void fuh::db_insert_addon_authors(
const std::string& instance_version,
const std::string&
id,
const std::string& primary_author,
const std::vector<std::string>& secondary_authors) {
286 std::set<std::string> inserted_authors;
287 inserted_authors.emplace(primary_author);
289 for(
const std::string& secondary_author : secondary_authors) {
290 if(inserted_authors.count(secondary_author) == 0) {
291 inserted_authors.emplace(secondary_author);
A config object defines a single node in a WML file, with access to child nodes.
void delete_addon_authors(const std::string &instance_version, const std::string &id)
bool do_any_authors_exist(const std::string &instance_version, const std::string &id)
void update_addon_download_count(const std::string &instance_version, const std::string &id, const std::string &version)
bool topic_id_exists(int topic_id)
int async_test_query(int limit)
bool is_user_author(const std::string &instance_version, const std::string &id, const std::string &username, int is_primary)
long get_forum_id(const std::string &name)
std::unique_ptr< simple_wml::document > get_game_history(int player_id, int offset, std::string search_game_name, int search_content_type, std::string search_content)
This is an asynchronous query that is executed on a separate connection to retrieve the game history ...
void get_ips_for_user(const std::string &username, std::ostringstream *out)
bool is_user_in_group(const std::string &name, int group_id)
bool user_exists(const std::string &name)
void get_users_for_ip(const std::string &ip, std::ostringstream *out)
void insert_addon_author(const std::string &instance_version, const std::string &id, const std::string author, int is_primary)
unsigned long long insert_login(const std::string &username, const std::string &ip, const std::string &version)
void update_logout(unsigned long long login_id)
void write_user_int(const std::string &column, const std::string &name, int value)
The provided value is updated if a row exists or a new row inserted otherwise.
void set_oos_flag(const std::string &uuid, int game_id)
void update_game_end(const std::string &uuid, int game_id, const std::string &replay_location)
int get_user_int(const std::string &table, const std::string &column, const std::string &name)
ban_check get_ban_info(const std::string &name, const std::string &ip)
void insert_addon_info(const std::string &instance_version, const std::string &id, const std::string &name, const std::string &type, const std::string &version, bool forum_auth, int topic_id, const std::string uploader)
std::string get_user_string(const std::string &table, const std::string &column, const std::string &name)
void insert_game_info(const std::string &uuid, int game_id, const std::string &version, const std::string &name, int reload, int observers, int is_public, int has_password)
void insert_game_player_info(const std::string &uuid, int game_id, const std::string &username, int side_number, int is_host, const std::string &faction, const std::string &version, const std::string &source, const std::string ¤t_user, const std::string &leaders)
std::string get_tournaments()
unsigned long long insert_game_content_info(const std::string &uuid, int game_id, const std::string &type, const std::string &name, const std::string &id, const std::string &addon_id, const std::string &addon_version)
void db_set_oos_flag(const std::string &uuid, int game_id)
Sets the OOS flag in the database if wesnothd is told by a client it has detected an OOS error.
std::string db_users_table_
The name of the phpbb users table.
bool user_is_moderator(const std::string &name)
void db_delete_addon_authors(const std::string &instance_version, const std::string &id)
Removes the authors information from addon_author for a particular addon and version.
void db_insert_addon_info(const std::string &instance_version, const std::string &id, const std::string &name, const std::string &type, const std::string &version, bool forum_auth, int topic_id, const std::string uploader)
Inserts information about an uploaded add-on into the database.
std::string get_hashed_password_from_db(const std::string &user)
void db_insert_addon_authors(const std::string &instance_version, const std::string &id, const std::string &primary_author, const std::vector< std::string > &secondary_authors)
Inserts rows for the primary and secondary authors for a particular addon and version.
void set_is_moderator(const std::string &name, const bool &is_moderator)
Sets or unsets whether the player should be considered a moderator in the extra table.
long get_forum_id(const std::string &name)
int mp_mod_group_
The group ID of the forums MP Moderators group.
void get_users_for_ip(const std::string &ip, std::ostringstream *out)
Searches for all players that logged in using the ip address.
bool db_topic_id_exists(int topic_id)
Checks whether a forum thread with topic_id exists.
ban_info user_is_banned(const std::string &name, const std::string &addr)
std::string db_extra_table_
The name of the extras custom table, not part of a phpbb database.
void db_update_game_end(const std::string &uuid, int game_id, const std::string &replay_location)
Update the game related information when the game ends.
std::string get_user_email(const std::string &user)
std::string extract_salt(const std::string &name)
Needed because the hashing algorithm used by phpbb requires some info from the original hash to recre...
void db_update_addon_download_count(const std::string &instance_version, const std::string &id, const std::string &version)
Increments the download count for this add-on for the specific version.
bool db_is_user_secondary_author(const std::string &instance_version, const std::string &id, const std::string &username)
Checks whether the provided username is a secondary author of the add-on.
std::string get_tournaments()
void user_logged_in(const std::string &name)
Sets the last login time to the current time.
void get_ips_for_user(const std::string &username, std::ostringstream *out)
Searches for all ip addresses used by the player.
bool login(const std::string &name, const std::string &password)
Retrieves the player's hashed password from the phpbb forum database and checks if it matches the has...
fuh(const config &c)
Reads wesnothd's config for the data needed to initialize this class and dbconn.
void async_test_query(boost::asio::io_service &io_service, int limit)
A simple test query for running a query asynchronously.
std::time_t get_lastlogin(const std::string &user)
std::time_t get_registrationdate(const std::string &user)
bool user_is_active(const std::string &name)
std::string user_info(const std::string &name)
bool db_do_any_authors_exist(const std::string &instance_version, const std::string &id)
Checks whether any author information exists for a particular addon and version, since if there's no ...
bool db_is_user_primary_author(const std::string &instance_version, const std::string &id, const std::string &username)
Checks whether the provided username is the primary author of the add-on.
unsigned long long db_insert_login(const std::string &username, const std::string &ip, const std::string &version)
Inserts into the database for when a player logs in.
void db_insert_game_player_info(const std::string &uuid, int game_id, const std::string &username, int side_number, int is_host, const std::string &faction, const std::string &version, const std::string &source, const std::string ¤t_user, const std::string &leaders)
Inserts player information per side.
dbconn conn_
An instance of the class responsible for executing the queries and handling the database connection.
bool user_exists(const std::string &name)
unsigned long long db_insert_game_content_info(const std::string &uuid, int game_id, const std::string &type, const std::string &name, const std::string &id, const std::string &addon_id, const std::string &addon_version)
Inserts information about the content being played.
void async_get_and_send_game_history(boost::asio::io_service &io_service, wesnothd::server &s, wesnothd::player_iterator player, int player_id, int offset, std::string &search_game_name, int search_content_type, std::string &search_content)
Runs an asynchronous query to fetch the user's game history data.
void db_update_logout(unsigned long long login_id)
Updates the database for when a player logs out.
void db_insert_game_info(const std::string &uuid, int game_id, const std::string &version, const std::string &name, int reload, int observers, int is_public, int has_password)
Inserts game related information.
@ BAN_EMAIL
Account email address ban.
@ BAN_USER
User account/name ban.
static bool is_valid_prefix(const std::string &hash)
std::string get_salt() const
static bcrypt from_hash_string(const std::string &input)
static bool is_valid_hash(const std::string &hash)
Definitions for the interface to Wesnoth Markup Language (WML).
player_connections::const_iterator player_iterator
static map_location::DIRECTION s