Пример #1
0
        public static async Task <AbbybotGuild> GetGuild(ulong abg)
        {
            var g = new AbbybotGuild()
            {
                Id = abg
            };
            var table = await AbbysqlClient.FetchSQL($"SELECT `GuildId` FROM `abbybot`.`guilds` WHERE `GuildId` = '{g.Id}';");

            bool e = table.Count > 0;

            if (abg == 0)
            {
                return(null);
            }

            var table2 = await AbbysqlClient.FetchSQL($"SELECT * FROM `abbybot`.`guilds` WHERE `GuildId` = '{g.Id}';");

            foreach (AbbyRow row in table2)
            {
                g.NoLoli         = (sbyte)row["NoLoli"] == 1 ? true : false;
                g.NoNSFW         = (sbyte)row["NoNSFW"] == 1 ? true : false;
                g.PrefAbbybot    = row["PrefAbbybot"] is ulong pabi ? pabi : 0;
                g.AutoDeleteTime = row["DeleteAfterSeconds"] is int secs ? secs : -1;
            }
            return(g);
        }
Пример #2
0
        public static async Task AddCharacterAsync(ISocketMessageChannel channel, AbbybotGuild abbybotGuild, string v)
        {
            var tag = AbbysqlClient.EscapeString(v);
            var nsf = (channel as ITextChannel).IsNsfw ? 0 : 1;

            var tbl = await AbbysqlClient.FetchSQL($"SELECT * FROM `abbybooru`.`characters` WHERE `Tag` = '{tag}' AND `ChannelId` = '{channel.Id}';");

            if (tbl.Count > 0)
            {
                throw new Exception("CharacterAlreadyAdded");
            }

            await AbbysqlClient.RunSQL($"INSERT INTO `abbybooru`.`characters` ( `Tag`,`ChannelId`, `GuildId`, `IsLewd` ) VALUES ('{tag}','{channel.Id}','{abbybotGuild.Id}', '{nsf}'); ");
        }
Пример #3
0
        public static async Task GetGuild(AbbybotGuild abg)
        {
            var table = await AbbysqlClient.FetchSQL($"SELECT `GuildId` FROM `abbybot`.`guilds` WHERE `GuildId` = '{abg.Id}';");

            bool e = table.Count > 0;

            if (!e)
            {
                await AddGuild(abg);
            }

            var table2 = await AbbysqlClient.FetchSQL($"SELECT * FROM `abbybot`.`guilds` WHERE `GuildId` = '{abg.Id}';");

            foreach (AbbyRow row in table2)
            {
                abg.NoLoli         = (sbyte)row["NoLoli"] == 1 ? true : false;
                abg.NoNSFW         = (sbyte)row["NoNSFW"] == 1 ? true : false;
                abg.PrefAbbybot    = row["PrefAbbybot"] is ulong pabi ? pabi : 0;
                abg.AutoDeleteTime = row["DeleteAfterSeconds"] is int secs ? secs : -1;
            }
        }
Пример #4
0
 public static async Task AddGuild(AbbybotGuild guild)
 {
     var name = AbbysqlClient.EscapeString(guild.Name);
     await AbbysqlClient.RunSQL($"INSERT INTO `abbybot`.`guilds`(GuildId, Name) VALUES ('{guild.Id}', '{name}'); ");
 }
Пример #5
0
 public static async Task UpdateGuildName(AbbybotGuild guild)
 {
     var name = AbbysqlClient.EscapeString(guild.Name);
     await AbbysqlClient.RunSQL($"UPDATE `abbybot`.`guilds` SET `Name` = '{name}' WHERE `GuildId` ='{guild.Id}';");
 }