mirror of
https://github.com/DarkflameUniverse/DarkflameServer.git
synced 2025-05-23 23:32:29 +00:00
36 lines
1.3 KiB
C++
36 lines
1.3 KiB
C++
#include "MySQLDatabase.h"
|
|
|
|
void MySQLDatabase::InsertGuildMember(const uint32_t guild_id, const uint32_t member_id, const uint16_t rank){
|
|
ExecuteInsert("INSERT INTO guild_members (guild_id, character_id, rank) VALUES (?, ?, ?);", guild_id, member_id, rank);
|
|
}
|
|
|
|
void MySQLDatabase::DeleteGuildMember(const uint32_t member_id){
|
|
ExecuteDelete("DELETE FROM guild_members WHERE character_id = ?;", member_id);
|
|
}
|
|
|
|
uint32_t MySQLDatabase::GetMembersGuild(const uint32_t member_id){
|
|
auto res = ExecuteSelect("SELECT * FROM guild_members WHERE character_id = ?;", member_id);
|
|
if (!res->next()) return 0;
|
|
return res->getUInt("guild_id");
|
|
}
|
|
|
|
std::vector<IGuildMembers::GuildMember> MySQLDatabase::GetGuildMembers(const uint32_t guild_id){
|
|
auto res = ExecuteSelect("SELECT * FROM guild_members WHERE guild_id = ?;", guild_id);
|
|
std::vector<GuildMember> toReturn;
|
|
toReturn.reserve(res->rowsCount());
|
|
|
|
while (res->next()) {
|
|
GuildMember member;
|
|
member.id = res->getUInt("character_id");
|
|
member.rank = res->getUInt("rank");
|
|
toReturn.push_back(member);
|
|
}
|
|
return toReturn;
|
|
}
|
|
|
|
bool MySQLDatabase::CheckIsInGuild(const uint32_t guild_id, const uint32_t character_id) {
|
|
auto res = ExecuteSelect("SELECT * FROM guild_members WHERE guild_id = ? AND character_id = ?;", guild_id, character_id);
|
|
if (res->next()) return true;
|
|
return false;
|
|
}
|