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; }