public static UserAccount.GuildAccounts GetGuildInfo(ulong guildId) { using (var db = new LiteDatabase(@"Data\guilds.db")) { var servers = db.GetCollection <UserAccount.GuildAccounts>("guilds"); var result = servers.FindOne(x => x.Guild == guildId); if (result == null) { var newGuild = new UserAccount.GuildAccounts { Guild = guildId, AlertDelay = 15, Rewards = new UserAccount.Rewards { WantedRewards = new List <string> { "none" } }, Fissures = new UserAccount.Fissures { WantedFissures = new List <string> { "none" } }, News = new UserAccount.News { KnownNews = new List <string> { "none" } }, Alerts = new UserAccount.Alerts { KnownAlerts = new List <string> { "none" } }, PmLists = new UserAccount.PmLists { PmList = new List <string> { "none" } } }; servers.Insert(newGuild); servers = db.GetCollection <UserAccount.GuildAccounts>("guilds"); result = servers.FindOne(x => x.Guild == guildId); } return(result); } }
public static void UpdateDb(ulong guildid, UserAccount.GuildAccounts guild) { using (var db = new LiteDatabase(@"Data\guilds.db")) { var guilds = db.GetCollection <UserAccount.GuildAccounts>("guilds"); var results = guilds.FindOne(x => x.Guild == guildid); if (results == null) { guilds.Insert(guild); return; } guilds.Update(guild); } }