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}';");
}