public async Task TopAsync()
{
//Aqui você substitui pelos seus dados
var connString = "Server=192.168.1.141;Port=3306;Database=lebot;Uid=lebot;Pwd=;SslMode=none;";
var connection = new MySqlConnection(connString);
var command = connection.CreateCommand();
try
{
connection.Open();
command.CommandText = "SELECT userid, coins FROM currency ORDER BY coins DESC LIMIT 5";
MySqlDataReader coinsReader;
coinsReader = command.ExecuteReader();
List <string[]> users = new List <string[]>();
while (coinsReader.Read())
{
string userID = coinsReader["userid"].ToString();
string userCoins = coinsReader["coins"].ToString();
string[] thisUser = { userID, userCoins };
users.Add(thisUser);
}
EmbedBuilder topUsers = new EmbedBuilder();
var getColor = new Functions.RandomBuilderColor();
topUsers.WithTitle("Quem está mais ligado a Deus?")
.WithColor(getColor.MessageBuilderColor());
foreach (var user in users)
{
string nick = "" + Context.Client.GetUser(ulong.Parse("" + user.GetValue(0)));
topUsers.AddField("" + nick, "Tem " + user.GetValue(1) + " de fé");
}
await ReplyAsync("", false, topUsers);
coinsReader.Close();
connection.Close();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
public async Task CreditsAsync()
{
var getColor = new Functions.RandomBuilderColor();
EmbedBuilder creditsBuilder = new EmbedBuilder();
creditsBuilder.WithTitle("Creditos d'**O Padre**")
.WithColor(getColor.MessageBuilderColor())
.AddField("Ideias por:", "@João Rodrigo Gonçalves#9391 \n@Hikaru#0448")
.AddField("Programação por:", "@João Rodrigo Gonçalves#9391")
.AddField("Atenção!", "BOT feito em C# e PHP com :heart: para uso privado!");
await ReplyAsync("", false, creditsBuilder.Build());
}
public async Task shopHelp()
{
var getColor = new Functions.RandomBuilderColor();
EmbedBuilder helpCommands = new EmbedBuilder();
helpCommands.WithTitle("Comandos da shop d'**padre**!")
.WithDescription("Comandos da *shop*")
.WithColor(getColor.MessageBuilderColor())
.AddInlineField("\\shop `{ordem [id/price/name]}` `{sentido [ASC/DESC]}`", "Mostra toda a shop")
.AddInlineField("\\buy `{id}`", "Comprar o item selecionado em `id`");
await ReplyAsync("", false, helpCommands);
}
public async Task defaultHelp()
{
var getColor = new Functions.RandomBuilderColor();
EmbedBuilder helpCommands = new EmbedBuilder();
helpCommands.WithTitle("Comandos d'**O Padre**!")
.WithDescription("Todos os comandos d'**O Padre**!")
.WithColor(getColor.MessageBuilderColor())
.AddInlineField("\\help", "Este menu de ajuda :expressionless:")
.AddInlineField("\\help shop", "Menu de ajuda da \\shop")
.AddInlineField("\\credits", "Autores d'**O Padre**")
.AddInlineField("\\dab", "Precisas de um update :neutral_face:")
.AddInlineField("\\shutup", "**O Padre** vai fingir que não te está a ouvir...")
.AddInlineField("\\fe", "Mostra a tua \"fé\"!")
.AddInlineField("\\lapada `{gajo}`", "Espeta um lapada nesse gajo")
.AddInlineField("\\give `{quantia}` `{gajo}`", "Dar \"fé\" a um gajo :clap: :pray:")
.AddInlineField("\\festa", "Não é uma festa sem foguetes! :fireworks:")
.AddInlineField("\\missa", "Vai á missa e pode ser que o padre te dê muita fé :pray:")
.AddInlineField("\\top", "Os mais ligados a Deus de sempre! :raised_hands:")
.AddInlineField("\\bet {quantidade}", "Duplica, triplica ou perde toda a fé que apostares!");
await ReplyAsync("", false, helpCommands.Build());
}
public async Task MissaAsync()
{
var connString = "Server=192.168.1.141;Port=3306;Database=lebot;Uid=lebot;Pwd=;SslMode=none;";
var connection = new MySqlConnection(connString);
var command = connection.CreateCommand();
ulong userReceivingCoins = 10;
try
{
connection.Open();
command.CommandText = "SELECT coins FROM currency WHERE userid='" + Context.Message.Author.Id + "' LIMIT 1";
MySqlDataReader coinsReader;
coinsReader = command.ExecuteReader();
if (coinsReader.Read())
{
userReceivingCoins = coinsReader.GetUInt32("coins");
coinsReader.Close();
}
else
{
coinsReader.Close();
command.CommandText = "INSERT INTO currency (userid) VALUES ('" + Context.Message.Author.Id + "')";
command.ExecuteNonQuery();
userReceivingCoins = 10;
}
connection.Close();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
int lastday = 0;
int lastmonth = 0;
int lastyear = 0;
bool exist = false;
try
{
connection.Open();
command.CommandText = "SELECT lastday, lastmonth, lastyear FROM missas WHERE userid='" + Context.Message.Author.Id + "' LIMIT 1";
MySqlDataReader dateReader;
dateReader = command.ExecuteReader();
if (dateReader.Read())
{
lastday = dateReader.GetInt32("lastday");
lastmonth = dateReader.GetInt32("lastmonth");
lastyear = dateReader.GetInt32("lastyear");
dateReader.Close();
exist = true;
}
else
{
dateReader.Close();
command.CommandText = "INSERT INTO missas (userid, lastday, lastmonth, lastyear) VALUES ('" + Context.Message.Author.Id + "', '" + DateTime.Now.Day + "', '" + DateTime.Now.Month + "', '" + DateTime.Now.Year + "')";
command.ExecuteNonQuery();
exist = false;
}
connection.Close();
//Check if bool "exist" was changed and if the user exists in the database
bool allowed = false;
if (exist)
{
var checkTime = new Functions.TimeCalculation();
if (checkTime.TimeClaculations(lastday, lastmonth, lastyear))
{
allowed = true;
}
}
else
{
allowed = true;
}
if (allowed)
{
Random random = new Random();
int randomNumber = random.Next(0, 26); //[0, 26[
if (randomNumber <= 0)
{
randomNumber = 1;
}
ulong userCoins = userReceivingCoins + Convert.ToUInt64(Convert.ToInt64(randomNumber));
try
{
connection.Open();
command.CommandText = "UPDATE currency SET coins='" + userCoins + "' WHERE userid='" + Context.Message.Author.Id + "' LIMIT 1";
command.ExecuteNonQuery();
connection.Close();
connection.Open();
command.CommandText = "UPDATE missas SET lastday='" + DateTime.Now.Day + "', lastmonth='" + DateTime.Now.Month + "', lastyear='" + DateTime.Now.Year + "' WHERE userid='" + Context.Message.Author.Id + "' LIMIT 1";
command.ExecuteNonQuery();
connection.Close();
EmbedBuilder ammountMessage = new EmbedBuilder();
var getColor = new Functions.RandomBuilderColor();
ammountMessage.WithTitle("Ganhas-te " + randomNumber + " de fé! :pray:")
.WithColor(getColor.MessageBuilderColor());
await ReplyAsync("", false, ammountMessage);
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
else
{
EmbedBuilder warningMessage = new EmbedBuilder();
warningMessage.WithTitle("Exedeste o teu limite diário!!")
.WithDescription("Tenta novamente amanhã para receberes a tua fé diária!");
await ReplyAsync("", false, warningMessage);
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
public async Task InventoryAsync()
{
ulong userid = Context.Message.Author.Id;
//Aqui você substitui pelos seus dados
var connString = "Server=192.168.1.141;Port=3306;Database=lebot;Uid=lebot;Pwd=;SslMode=none;";
var connection = new MySqlConnection(connString);
var command = connection.CreateCommand();
List <string[]> items = new List <string[]>();
List <string[]> userItems = new List <string[]>();
connection.Open();
command.CommandText = "SELECT * FROM store_prices";
MySqlDataReader itemReader;
itemReader = command.ExecuteReader();
try
{
while (itemReader.Read())
{
string itemId = itemReader["id"].ToString();
string itemName = itemReader["name"].ToString();
string itemPrice = itemReader["price"].ToString();
string itemDescription = itemReader["description"].ToString();
string[] thisItem = { itemId, itemName, itemPrice, itemDescription };
items.Add(thisItem);
}
itemReader.Close();
connection.Close();
var ownItem = new Functions.OwnItem();
foreach (var item in items)
{
if (ownItem.OwnedItem(userid, int.Parse("" + item.GetValue(0))))
{
string[] thisUserItem = { "" + item.GetValue(0), "" + item.GetValue(1), "" + item.GetValue(2), "" + item.GetValue(3) };
userItems.Add(thisUserItem);
}
}
EmbedBuilder inventoryDump = new EmbedBuilder();
var getColor = new Functions.RandomBuilderColor();
inventoryDump.WithTitle("Inventário de " + Context.Message.Author.Username + "#" + Context.Message.Author.Discriminator);
inventoryDump.WithColor(getColor.MessageBuilderColor());
if (userItems.Count > 0)
{
foreach (var ownedItem in userItems)
{
inventoryDump.AddField("Id: " + ownedItem.GetValue(0) + " :arrow_right: " + ownedItem.GetValue(1), ownedItem.GetValue(3));
}
}
else
{
inventoryDump.WithDescription("Nada... Talvez usar a \\shop para encontrar algo?");
}
await ReplyAsync("", false, inventoryDump);
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
public async Task FeAsync([Remainder] string user = null)
{
string userid = null;
string String = null;
bool self = true;
if (user == null)
{
userid = "" + Context.Message.Author.Id;
String = Context.Message.Author + ", tu tens";
self = true;
}
else
{
var charToRemove = new string[] { "<", "@", "!", ">" };
foreach (var c in charToRemove)
{
user = user.Replace(c, string.Empty);
}
userid = user;
String = Context.Client.GetUser(ulong.Parse(user)) + " tem";
self = false;
}
//Aqui você substitui pelos seus dados
var connString = "Server=192.168.1.141;Port=3306;Database=lebot;Uid=lebot;Pwd=;SslMode=none;";
var connection = new MySqlConnection(connString);
var command = connection.CreateCommand();
var getColors = new Functions.RandomBuilderColor();
try
{
connection.Open();
command.CommandText = "SELECT coins FROM currency WHERE userid='" + userid + "' LIMIT 1";
MySqlDataReader coinsReader;
coinsReader = command.ExecuteReader();
EmbedBuilder coinsAmount = new EmbedBuilder();
if (coinsReader.Read())
{
uint userCoins = coinsReader.GetUInt32("coins");
coinsAmount.WithTitle(String + " " + coinsReader.GetInt32("coins") + " de fé!")
.WithColor(getColors.MessageBuilderColor());
if (self)
{
coinsAmount.WithThumbnailUrl("https://cdn.discordapp.com/avatars/" + Context.Message.Author.Id + "/" + Context.Message.Author.AvatarId + ".png?size=128");
}
else
{
coinsAmount.WithThumbnailUrl("https://cdn.discordapp.com/avatars/" + Context.Client.GetUser(ulong.Parse(userid)).Id + "/" + Context.Client.GetUser(ulong.Parse(userid)).AvatarId + ".png?size=128");
}
coinsReader.Close();
}
else
{
coinsReader.Close();
command.CommandText = "INSERT INTO currency (userid) VALUES ('" + Context.Message.Author.Id + "') LIMIT 1";
command.ExecuteNonQuery();
coinsAmount.WithTitle(String + " 10 de fé!")
.WithColor(getColors.MessageBuilderColor());
if (self)
{
coinsAmount.WithThumbnailUrl("https://cdn.discordapp.com/avatars/" + Context.Message.Author.Id + "/" + Context.Message.Author.AvatarId + ".png?size=128");
}
else
{
coinsAmount.WithThumbnailUrl("https://cdn.discordapp.com/avatars/" + Context.Client.GetUser(ulong.Parse(userid)).Id + "/" + Context.Client.GetUser(ulong.Parse(userid)).AvatarId + ".png?size=128");
}
}
coinsAmount.WithDescription("Consegue mais fé com comandos como \"\\missa\"!");
await ReplyAsync("", false, coinsAmount);
connection.Close();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
public async Task ShopAsync(string order = "id", string mode = "ASC")
{
if (!order.Equals("id", StringComparison.OrdinalIgnoreCase))
{
if (!order.Equals("name", StringComparison.OrdinalIgnoreCase))
{
if (!order.Equals("price", StringComparison.OrdinalIgnoreCase))
{
await ReplyAsync(Context.Message.Author.Mention + "! Os únicos argumentos válidos para a ordenação dos itens da shop são `id`, `price` e `name`!");
return;
}
}
}
if (!mode.Equals("ASC", StringComparison.OrdinalIgnoreCase))
{
if (!mode.Equals("DESC", StringComparison.OrdinalIgnoreCase))
{
await ReplyAsync(Context.Message.Author.Mention + "! Os únicos argumentos válidos para o sentido da ordenação dos itens da shop são `ASC` e `DESC`!");
return;
}
}
//Aqui você substitui pelos seus dados
var connString = "Server=192.168.1.141;Port=3306;Database=lebot;Uid=lebot;Pwd=;SslMode=none;";
var connection = new MySqlConnection(connString);
var command = connection.CreateCommand();
try
{
connection.Open();
command.CommandText = "SELECT * FROM store_prices ORDER BY " + order + " " + mode + "";
MySqlDataReader coinsReader;
coinsReader = command.ExecuteReader();
List <string[]> items = new List <string[]>();
while (coinsReader.Read())
{
string itemId = coinsReader["id"].ToString();
string itemName = coinsReader["name"].ToString();
string itemPrice = coinsReader["price"].ToString();
string itemDescription = coinsReader["description"].ToString();
string[] thisItem = { itemId, itemName, itemPrice, itemDescription };
items.Add(thisItem);
}
EmbedBuilder shopList = new EmbedBuilder();
var getColor = new Functions.RandomBuilderColor();
shopList.WithTitle("Loja d' *O Padre*")
.WithColor(getColor.MessageBuilderColor());
foreach (var item in items)
{
shopList.AddField("Id: " + item.GetValue(0) + " :arrow_right: " + item.GetValue(1), item.GetValue(3) + "\n" + "Preço: " + item.GetValue(2) + " de fé :pray:");
}
await ReplyAsync("", false, shopList);
coinsReader.Close();
connection.Close();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
return;
}
public async Task BetAsync([Remainder] string amount = null)
{
if (amount != null)
{
if (int.TryParse(amount, out int amountConverted))
{
//Aqui você substitui pelos seus dados
var connString = "Server=192.168.1.141;Port=3306;Database=lebot;Uid=lebot;Pwd=;SslMode=none;";
var connection = new MySqlConnection(connString);
var command = connection.CreateCommand();
var getColors = new Functions.RandomBuilderColor();
int currentCoins = 0;
try
{
connection.Open();
command.CommandText = "SELECT coins FROM currency WHERE userid='" + Context.Message.Author.Id + "' LIMIT 1";
MySqlDataReader coinsReader;
coinsReader = command.ExecuteReader();
if (coinsReader.Read())
{
currentCoins = coinsReader.GetInt32("coins");
coinsReader.Close();
}
else
{
coinsReader.Close();
command.CommandText = "INSERT INTO currency (userid) VALUES ('" + Context.Message.Author.Id + "') LIMIT 1";
command.ExecuteNonQuery();
currentCoins = 10;
}
connection.Close();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
Random chance = new Random();
int chanceResult = chance.Next(0, 101);
/*
*
* 0 - 50 -» Lost
* 51 - 90 -» Won x2
* 91 - 100 -» Won x3
*
*/
int newTotal = 0;
if (chanceResult <= 50)
{
try
{
connection.Open();
command.CommandText = "UPDATE currency SET coins='" + (currentCoins - amountConverted) + "' WHERE userid='" + Context.Message.Author.Id + "' LIMIT 1";
command.ExecuteNonQuery();
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
await ReplyAsync(Context.Message.Author.Mention + " perdeste " + amountConverted + "...");
}
else
{
if (chanceResult >= 51 && chanceResult <= 90)
{
newTotal = amountConverted * 2;
}
if (chanceResult >= 91)
{
newTotal = amountConverted * 3;
}
int total = newTotal + currentCoins;
try
{
connection.Open();
command.CommandText = "UPDATE currency SET coins='" + total + "' WHERE userid='" + Context.Message.Author.Id + "' LIMIT 1";
command.ExecuteNonQuery();
await ReplyAsync(Context.Message.Author.Mention + ", ganhaste " + newTotal + "!");
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
}
else
{
await ReplyAsync("Números pah. Tu apostas números crl! Dasse " + Context.Message.Author.Mention + "...");
}
}
else
{
await ReplyAsync("Ó " + Context.Message.Author.Mention + "! E dizeres quanto é que vais apostar?");
}
}
