private async Task SetBubbleExperienceAsync(KaosTribe tribe, int value)
{
var sql = $"UPDATE pvpve_tribes SET PveBubble = {value} WHERE TribeID = {tribe.TribeId}";
using (IDbConnection connection = new MySqlConnection(ConnectionString))
{
await connection.ExecuteAsync(sql);
}
}
internal async Task <int> GetTribeSizeAsync(KaosTribe tribe)
{
var sql = $"SELECT COUNT(SteamId) FROM pvpve_players WHERE TribeList RLIKE @Id";
using (IDbConnection connection = new MySqlConnection(ConnectionString))
{
var size = await connection.QueryFirstOrDefaultAsync <int>(sql, new { Id = $"[[:<:]]{tribe.Id}[[:>:]]" });
if (size == 0)
{
return(1);
}
return(size);
}
}
internal async Task <List <KaosUser> > GetMembersAsync(KaosTribe tribe)
{
var members = new List <KaosUser>();
var sql = $"SELECT SteamId FROM pvpve_playerss WHERE TribeList RLIKE @Id";
using (IDbConnection connection = new MySqlConnection(ConnectionString))
{
var steamIds = await connection.QueryAsync <long>(sql, new { Id = $"[[:<:]]{tribe.Id}[[:>:]]" });
foreach (long steamId in steamIds)
{
var user = await GetUserAsync(steamId);
members.Add(user);
}
}
return(members);
}
internal async Task AddBubbleExperienceAsync(KaosTribe tribe, double amount)
{
await Task.CompletedTask;
}
