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}');"); }
public static async Task Remove(Tweet I) { if (I.source == "tweets") { await AbbysqlClient.RunSQL($"DELETE FROM `twitter`.`{I.source}` WHERE `Id` = '{I.id}';"); } }
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 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(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 <bool> AddRole(ulong guildId, ulong roleId) { var t = await AbbysqlClient.FetchSQL($"select * from `guild`.`mostactiveroles` where `GuildId`='{guildId}' and `RoleId` = '{roleId}';"); return(t.Count < 1 ? await AbbysqlClient.RunSQL($"insert into `guild`.`mostactiveroles`(`GuildId`, `RoleId`) values ('{guildId}', '{roleId}');") > 0 : false); }
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 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 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 SetAutoFcDmAsync(ulong userId, bool FCMentions) { int fcm = FCMentions ? 1 : 0; AbbyTable table = await AbbysqlClient.FetchSQL($"select * from `user`.`autofcdms` where `UserId` = {userId}"); if (table.Count < 1) { await AbbysqlClient.RunSQL($"insert into `user`.`autofcdms` (`UserId`, `On`) values ('{userId}','{fcm}');"); return; } await AbbysqlClient.RunSQL($"UPDATE `user`.`autofcdms` SET `On`= '{fcm}' WHERE `UserId`= {userId};"); }
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 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 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 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 <(bool inTimeout, DateTime timeoutEndDate, string reason)> GetUserTimeout(ulong auId) { var table = await AbbysqlClient.FetchSQL($"SELECT * FROM `user`.`timeout` WHERE `UserId` = '{auId}';"); (bool t, DateTime ted, string r)vars = (false, DateTime.Now, ""); if (table.Count > 0) { vars.t = true; vars.ted = (table[0]["Time"] is string s) ? DateTime.Parse(s) : DateTime.Now; vars.r = (table[0]["Reason"] is string z) ? z : ""; } if (vars.ted < DateTime.Now) { await AbbysqlClient.RunSQL($"DELETE FROM `user`.`timeout` WHERE `UserId` = '{auId}'"); vars.t = false; } return(vars); }
public static async Task <(string favoritecharacter, bool isLewd, ulong marriedid)> GetUserData(ulong Id) { var table = await AbbysqlClient.FetchSQL($"SELECT `UserId` FROM `user`.`users` WHERE `UserId` = '{Id}';"); if (table.Count < 1) { await AbbysqlClient.RunSQL($"INSERT INTO `user`.`users`(UserId, FavoriteCharacter) VALUES ('{Id}','Abigail_Williams*');"); } table = await AbbysqlClient.FetchSQL($"SELECT `user`.`users`.* FROM `user`.`users` WHERE users.UserId = {Id};"); AbbyRow row = table[0]; (string favoritecharacter, bool isLewd, ulong marriedid)gol = ("Abigail_Williams*", true, 0); gol.favoritecharacter = (row["FavoriteCharacter"] is string s) ? s : "abigail_williams*"; gol.isLewd = row["IsLewd"] is ulong il && il == 1; gol.marriedid = row["MarriedUserId"] is ulong mid ? mid : 0; return(gol); }
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 <bool> SetRole(ulong user, ulong guild, ulong role) { bool dre = await DoesRoleExist(user, guild, role); if (dre) { return(false); } bool ran = true; try { await AbbysqlClient.RunSQL($"INSERT INTO `user`.`roles` (`UserId`,`GuildId`,`RoleId`) VALUES ('{user}', '{guild}','{role}');"); } catch (Exception e) { Abbybot_III.Abbybot.print(e.Message + e.StackTrace); } return(ran); }
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 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}';"); }
internal static async Task UpdatePrefAbbybot(ulong guildId, ulong abbybotId) { await AbbysqlClient.RunSQL($"UPDATE `abbybot`.`guilds` SET `PrefAbbybot` = '{abbybotId}' WHERE `GuildId` ='{guildId}';"); }
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 ClearLuaData(ulong UserId) { await AbbysqlClient.RunSQL($"delete from user.lua where `UserId` = '{UserId}';"); }
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}');"); }
internal static async Task AddLatestPostIdAsync(ulong id1, ulong id2, int gelId) { await AbbysqlClient.RunSQL($"INSERT INTO `abbybooru`.`characterpostids` (`Id`, `CharId`, `GelId`) VALUES ('{id2}', '{id1}', '{gelId}');"); }
public static async Task AddLatestMentionIdAsync(ulong id) { await AbbysqlClient.RunSQL($"INSERT INTO heardtweets (Id) VALUES ('{id}');"); }
public static async Task AddGuild(SocketGuild guild, RestInviteMetadata rim) { await AbbysqlClient.RunSQL($"INSERT INTO `discord`.`invites`(GuildId, InviteId, Joins) VALUES ('{guild.Id}', '{rim.Code}', '{rim.Uses}'); "); }
public static async Task Remove(Tweet I) { await AbbysqlClient.RunSQL($"DELETE FROM `twitter`.`archive` WHERE `Id` = '{I.id}';"); }