public static async Task <string> GetLastTime(ulong userId, ulong guildId, string item) { var it = AbbysqlClient.EscapeString(item); var a = await AbbysqlClient.FetchSQL($"select * from `user`.`activity` where `UserId`='{userId}' and `GuildId` = '{guildId}' and `Kind` = '{it}'"); return((a.Count > 0 && a[0]["Time"] is string s) ? s : ""); }
public static async Task IncreaseStat(ulong abbybotId, ulong guildId, ulong channelId, ulong userId, string stat) { if (stat.Length == 0) { return; } var it = AbbysqlClient.EscapeString(stat); //var month = DateTime.Now.ToString("MMMM yyyy"); var a = await AbbysqlClient.FetchSQL($"select * from `guild`.`userstats` where `Stat`='{stat}' and `AbbybotId` = '{abbybotId}' and `GuildId`='{guildId}' and `ChannelId`='{channelId}' and `UserId`='{userId}'"); if (a.Count != 0) { ulong num = (a[0]["Points"] is ulong points) ? points : 0; ulong n = ++num; string s = $"UPDATE `guild`.`userstats` SET `Points`= '{n}' WHERE `Stat`='{stat}' and `AbbybotId` = '{abbybotId}' and `GuildId`='{guildId}' and `ChannelId`='{channelId}' and `UserId`='{userId}';"; await AbbysqlClient.RunSQL(s); } else { await AbbysqlClient.RunSQL($"insert into `guild`.`userstats` (`AbbybotId`,`GuildId`, `ChannelId`,`UserId`, `Stat`, `Points`) values ('{abbybotId}', '{guildId}', '{channelId}', '{userId}','{stat}', '1');"); } }
public static async Task Add(string message, Image I) { var url = AbbysqlClient.EscapeString(I.url); var sourceurl = AbbysqlClient.EscapeString(I.sourceurl); var msg = AbbysqlClient.EscapeString(message); await AbbysqlClient.RunSQL($"INSERT INTO `twitter`.`tweets` ( `ImgUrl`,`SrcUrl`, `Description`, `Priority`, `md5`, `GelId` ) VALUES('{url}', '{sourceurl}', '{msg}','0', '{I.md5}', '{I.gelId}');"); }
internal static async Task <bool> UnbadtaglistTag(ulong id, string item) { item = AbbysqlClient.EscapeString(item); var e = await AbbysqlClient.RunSQL($"DELETE FROM `user`.`gelbadtaglist` WHERE `UserId` = '{id}' and `Tag` = '{item}';"); return(e switch {
public static async Task <List <(ulong userId, ulong stat)> > GetGuildStat(ulong abbybotId, ulong guildId, string v) { List <(ulong userId, ulong stat)> stats = new List <(ulong userId, ulong stat)>(); var ori = AbbysqlClient.EscapeString(v); var a = await AbbysqlClient.FetchSQL($"select * from `guild`.`userstats` where `AbbybotId` = '{abbybotId}' and `GuildId`='{guildId}' and `Stat`='{ori}';"); foreach (AbbyRow abr in a) { var point = abr["Points"] is ulong p ? p : 0; var user = abr["UserId"] is ulong u ? u : 0; stats.Add((user, point)); } var groupedstats = stats.ToList().GroupBy(x => x.userId); stats.Clear(); foreach (var u in groupedstats) { ulong o = 0; foreach (var s in u) { o += s.stat; } stats.Add((u.Key, o)); } return(stats); }
public static async Task Add(Tweet I, bool v) { int priority = v ? 1 : 0; var url = AbbysqlClient.EscapeString(I.url); var sourceurl = AbbysqlClient.EscapeString(I.sourceurl); var message = AbbysqlClient.EscapeString(I.message); await AbbysqlClient.RunSQL($"INSERT INTO `twitter`.`tweets` ( `ImgUrl`,`SrcUrl`, `Description`, `Priority`, `GelId`, `md5` ) VALUES('{url}', '{sourceurl}', '{message}', '{priority}','{I.GelId}','{I.md5}' );"); }
public static async Task SetFavoriteCharacterHistoryAsync(ulong userId, string favoriteCharacter, string type, string info, ulong lastId) { var t = DateTime.Now.ToString("G"); var fc = AbbysqlClient.EscapeString(favoriteCharacter); var ty = AbbysqlClient.EscapeString(type); var inf = AbbysqlClient.EscapeString(info); await AbbysqlClient.RunSQL($"insert into `abbybooru`.`userfchistory` (`UserId`, `Time`, `FavoriteCharacter`, `Type`, `Info`, `UndoId`) values ('{userId}','{t}','{fc}', '{ty}', '{inf}', '{lastId}');"); }
public static async Task RemoveCharacterAsync(ISocketMessageChannel channel, string v) { var tag = AbbysqlClient.EscapeString(v); var tbl = await AbbysqlClient.FetchSQL($"SELECT * FROM `abbybooru`.`characters` WHERE `Tag` = '{tag}' AND `ChannelId` = '{channel.Id}';"); if (tbl.Count < 1) { throw new Exception("nocharacter"); } await AbbysqlClient.RunSQL($"DELETE FROM `abbybooru`.`characters` WHERE `Tag` = '{tag}' AND `ChannelId` = '{channel.Id}';"); }
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}'); "); }
public static async Task SetUsernameSql(ulong userId, string username, string nickname = "") { nickname ??= ""; string u = (username.Length > 1) ? AbbysqlClient.EscapeString(username) : ""; string n = (nickname.Length > 1) ? AbbysqlClient.EscapeString(nickname) : ""; string ss = $"UPDATE `user`.`names` SET `Username`='{u}'"; if (n.Length > 1) { ss += $", `Nickname`= '{n}'"; } ss += $" WHERE `UserId`= {userId}; "; await AbbysqlClient.RunSQL(ss); }
public static async Task SetCFCAsync(ulong guildId, ulong channelId, bool nsfw, string fc) { string fcm = AbbysqlClient.EscapeString(fc); int insfw = nsfw ? 1 : 0; AbbyTable table = await AbbysqlClient.FetchSQL($"select * from `channel`.`fcsettings` where `GuildId` = {guildId} and `ChannelId`= {channelId}"); if (table.Count < 1) { await AbbysqlClient.RunSQL($"insert into `channel`.`fcsettings` (`GuildId`, `ChannelId`, `FavoriteCharacter`,`IsNSFW` ) values ('{guildId}', '{channelId}', '{fcm}', {insfw});"); } else { await AbbysqlClient.RunSQL($"UPDATE `channel`.`fcsettings` SET `FavoriteCharacter`= '{fcm}' WHERE `GuildId`= {guildId} and `ChannelId` = {channelId};"); } }
public static async Task <List <(ulong channel, ulong stat)> > GetChannelsinGuildStats(ulong abbybotId, ulong guildId, ulong userId, string v) { List <(ulong, ulong)> statchannels = new List <(ulong, ulong)>(); var ori = AbbysqlClient.EscapeString(v); var a = await AbbysqlClient.FetchSQL($"select * from `guild`.`userstats` where `AbbybotId` = '{abbybotId}' and `GuildId`='{guildId}' and `UserId`='{userId}' and `Stat`='{ori}';"); foreach (AbbyRow abr in a) { ulong channelId = (abr["ChannelId"] is ulong chanid) ? chanid : 0; ulong points = (abr["Points"] is ulong poin) ? poin : 0; statchannels.Add((channelId, points)); } return(statchannels); }
public static async Task Add(Tweet I, bool v) { var facts = await FunAbbybotFactsSql.GetFactsList(true); Random r = new(); int priority = v ? 1 : 0; var url = AbbysqlClient.EscapeString(I.url); var sourceurl = AbbysqlClient.EscapeString(I.sourceurl); var message = AbbysqlClient.EscapeString(I.message); if (message.Contains("new tweet just came in") && facts.Count > 0) { message = facts[r.Next(0, facts.Count)].fact; } message = AbbysqlClient.EscapeString(message); await AbbysqlClient.RunSQL($"INSERT INTO `twitter`.`archive` ( `ImgUrl`,`SrcUrl`, `Description`, `Priority`, `md5`, `GelId` ) VALUES('{url}', '{sourceurl}', '{message}','0', '{I.md5}', '{I.GelId}');"); }
public static async Task IncStat(ulong userId, string item) { if (item.Length == 0) { return; } var it = AbbysqlClient.EscapeString(item); var a = await AbbysqlClient.FetchSQL($"select * from `users`.`userstats` where `Id`='{userId}'"); if (a.Count == 0) { return; } int num = (int)a[0][item]; int n = ++num; string s = $"UPDATE `users`.`userstats` SET `{it}`= '{n}' WHERE `Id`= {userId};"; await AbbysqlClient.RunSQL(s); }
public static async Task SetTimeSql(ulong userId, ulong guildId, string item, string time) { if (item.Length == 0) { return; } var it = AbbysqlClient.EscapeString(item); var a = await AbbysqlClient.FetchSQL($"select * from `user`.`activity` where `UserId`='{userId}' and `GuildId` = '{guildId}' and `Kind` = '{it}'"); if (a.Count == 0) { await AbbysqlClient.RunSQL($"insert into `user`.`activity` (`UserId`, `GuildId`, `Kind`, `Time`) values ('{userId}','{guildId}','{it}','{time}');"); return; } string s = $"UPDATE `user`.`activity` SET `Time`= '{time}' WHERE `UserId`='{userId}' and `GuildId` = '{guildId}' and `Kind` = '{it}';"; await AbbysqlClient.RunSQL(s); }
public static async Task AddBadTag(ulong did, string item, Action onSuccess = null, Action <string> onFail = null) { item = AbbysqlClient.EscapeString(item); var table = await AbbysqlClient.FetchSQL($"SELECT * FROM `user`.`gelbadtaglist` WHERE `UserId` = '{did}' && `Tag`= '{item}';"); if (table.Count > 0) { onFail?.Invoke($"Sorry master... {item} was already added..."); return; } var e = await AbbysqlClient.RunSQL($"INSERT INTO `user`.`gelbadtaglist`(`UserId`, `Tag`) VALUES ('{did}', '{item}'); "); if (e > 0) { onSuccess?.Invoke(); } else { onFail?.Invoke("I... Couldn't add the tag to the database..."); } }
public static async Task SetFavoriteCharacterAsync(ulong userId, string favoriteCharacter) { string fc = AbbysqlClient.EscapeString(favoriteCharacter); await AbbysqlClient.RunSQL($"UPDATE `user`.`users` SET `FavoriteCharacter`= '{fc}' WHERE `UserId`= {userId};"); }
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}';"); }
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}'); "); }
public static async Task UpdateGuildName(SocketGuild guild, RestInviteMetadata rim) { var name = AbbysqlClient.EscapeString(guild.Name); await AbbysqlClient.RunSQL($"UPDATE `discord`.`invites` SET `Joins` = '{rim.Uses}' WHERE `GuildId` ='{guild.Id}' AND `InviteId` = '{rim.Code}';"); }
public static async Task AddLuaData(ulong UserId, string piece) { piece = AbbysqlClient.EscapeString(piece); await AbbysqlClient.RunSQL($"insert into user.lua (`UserId`, `lua`) values ('{UserId}', '{piece}');"); }