public int CheckUserLogin(UserL User)
{
using (SqlConnection con = new SqlConnection(conexion))
{
SqlCommand comObj = new SqlCommand("spLogin", con);
comObj.CommandType = CommandType.StoredProcedure;
comObj.Parameters.Add(new SqlParameter("@username", User.UserName));
comObj.Parameters.Add(new SqlParameter("@password", User.Password));
con.Open();
var dr = comObj.ExecuteScalar();
while (dr.read())
{
int userid = convert.toint16(dr[0]);
string Password = dr[1].tostring();
// now Manipulate as per as your requirment
}
}
}
public async Task dCoinsShow(params String[] UserL)
{
string output = "";
for (int i = 0; i < UserL.Length; i++)
{
output += UserL.ElementAt(i);
if (i != UserL.Length - 1)
{
output += " ";
}
}
if (output != "")
{
if (output.IndexOf('@') == 1)
{
try
{
output = output.Remove(0, 2);
output = output.Remove(output.Length - 1, 1);
if (output.IndexOf('!') == 0)
{
output = output.Remove(0, 1);
}
SocketGuildUser j = null;
var n = Initialization._client.Guilds.GetEnumerator();
n.MoveNext();
var g = n.Current;
for (int i = 0; i < Initialization._client.Guilds.Count; i++)
{
g = n.Current;
n.MoveNext();
if (j == null)
{
j = g.Users.FirstOrDefault(x => x.Id == ulong.Parse(output));
}
}
if (j == null)
{
throw new Exception();
}
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor($"Succesfull", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithDescription($"**{j.Username}'s balance is: **" + DBData.getCoins(j.Id));
eb.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb.Build());
return;
}
catch (Exception)
{
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithDescription($"**Can't find user with id {output} in all connected to the bot servers.**");
eb.WithThumbnailUrl(Settings.MainThumbnailUrl);
await Context.Channel.SendMessageAsync("", false, eb.Build());
return;
}
}
else
{
try
{
var n = Initialization._client.Guilds.GetEnumerator();
n.MoveNext();
var g = n.Current;
SocketGuildUser j = null;
for (int i = 0; i < Initialization._client.Guilds.Count; i++)
{
g = n.Current;
n.MoveNext();
if (j == null)
{
j = g.Users.FirstOrDefault(x => x.Username == output);
}
}
if (j == null)
{
throw new Exception();
}
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor($"Succesfull", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithDescription($"**{j.Username}'s balance is: **" + DBData.getCoins(j.Id));
eb.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb.Build());
return;
}
catch (Exception)
{
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithDescription($"**Can't find user with username \"{output}\" in all connected to the bot servers.**");
eb.WithThumbnailUrl(Settings.MainThumbnailUrl);
await Context.Channel.SendMessageAsync("", false, eb.Build());
return;
}
}
}
else
{
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor($"Succesfull", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithDescription("**Your balance is:** " + DBData.getCoins(Context.User.Id));
eb.WithThumbnailUrl(Context.User.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb.Build());
}
}
public async Task getId(params String[] UserL)
{
bCheck();
if (check != true)
{
return;
}
string output = "";
for (int i = 0; i < UserL.Length; i++)
{
output += UserL.ElementAt(i);
if (i != UserL.Length - 1)
{
output += " ";
}
}
if (output != "")
{
try
{
var n = Duck_Bot_.Net_Core.Initialization._client.Guilds.GetEnumerator();
n.MoveNext();
var g = n.Current;
SocketGuildUser j = null;
for (int i = 0; i < Duck_Bot_.Net_Core.Initialization._client.Guilds.Count; i++)
{
g = n.Current;
n.MoveNext();
if (j == null)
{
j = g.Users.FirstOrDefault(x => x.Username == output);
}
}
if (j == null)
{
return;
}
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor("Succesfull", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithThumbnailUrl(j.GetAvatarUrl());
eb.WithDescription($"**{j.Username}'s id: {j.Id}**" + Environment.NewLine + $"Created at: {j.CreatedAt.UtcDateTime}");
await Context.Channel.SendMessageAsync("", false, eb.Build());
string text = $"[{DateTime.UtcNow}] {Context.User.Username} used d!buser command for user {j.Username}.";
Console.WriteLine(text);
await bLog(text);
return;
}
catch (Exception)
{
EmbedBuilder eb2 = new EmbedBuilder();
eb2.WithAuthor("Error", Context.User.GetAvatarUrl());
eb2.WithThumbnailUrl("https://cdn.discordapp.com/attachments/524677710770077697/527415053134331925/WarDT.png");
eb2.WithDescription($"**Can't find user with username \"{output}\" in all connected to bot servers.**");
await Context.Channel.SendMessageAsync("", false, eb2.Build());
return;
}
}
}
public async Task giveDCoins(int amount = 0, params String[] UserL)
{
string output = "";
for (int i = 0; i < UserL.Length; i++)
{
output += UserL.ElementAt(i);
if (i != UserL.Length - 1)
{
output += " ";
}
}
if (output != "")
{
if (output.IndexOf('@') == 1)
{
try
{
output = output.Remove(0, 2);
output = output.Remove(output.Length - 1, 1);
if (output.IndexOf('!') == 0)
{
output = output.Remove(0, 1);
}
SocketGuildUser j = null;
var n = Initialization._client.Guilds.GetEnumerator();
n.MoveNext();
var g = n.Current;
for (int i = 0; i < Initialization._client.Guilds.Count; i++)
{
g = n.Current;
n.MoveNext();
if (j == null)
{
j = g.Users.FirstOrDefault(x => x.Id == ulong.Parse(output));
}
}
if (j == null)
{
throw new Exception();
}
if (j.IsBot)
{
EmbedBuilder eb1 = new EmbedBuilder();
eb1.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb1.WithColor(40, 200, 150);
eb1.WithDescription($"**Can't give {amount} Ducky Coins to {j.Username}, cause it's a bot!**");
eb1.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb1.Build());
return;
}
if (DBData.getCoins(Context.User.Id) < amount)
{
EmbedBuilder eb2 = new EmbedBuilder();
eb2.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb2.WithColor(40, 200, 150);
eb2.WithDescription($"**You don't have {amount} Ducky Coins to give them**");
eb2.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb2.Build());
return;
}
await DBData.saveCoins(j.Id, amount);
await DBData.removeCoins(Context.User.Id, amount);
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor($"Succesfull", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithDescription($"**Succesfully gave {amount} Ducky Coins to {j.Username}**");
eb.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb.Build());
return;
}
catch (Exception)
{
if (amount >= 0)
{
EmbedBuilder eb1 = new EmbedBuilder();
eb1.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb1.WithColor(40, 200, 150);
eb1.WithDescription($"**Can't find user with id {output} in all connected to the bot servers.**");
eb1.WithThumbnailUrl(Settings.MainThumbnailUrl);
await Context.Channel.SendMessageAsync("", false, eb1.Build());
}
else
{
EmbedBuilder eb1 = new EmbedBuilder();
eb1.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb1.WithColor(40, 200, 150);
eb1.WithDescription($"**Please type right amount of Ducky Coins to give them.**");
eb1.WithThumbnailUrl(Settings.MainThumbnailUrl);
await Context.Channel.SendMessageAsync("", false, eb1.Build());
}
return;
}
}
else
{
try
{
var n = Initialization._client.Guilds.GetEnumerator();
n.MoveNext();
var g = n.Current;
SocketGuildUser j = null;
for (int i = 0; i < Initialization._client.Guilds.Count; i++)
{
g = n.Current;
n.MoveNext();
if (j == null)
{
j = g.Users.FirstOrDefault(x => x.Username == output);
}
}
if (j == null)
{
throw new Exception();
}
if (j.IsBot)
{
EmbedBuilder eb1 = new EmbedBuilder();
eb1.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb1.WithColor(40, 200, 150);
eb1.WithDescription($"**Can't give {amount} Ducky Coins to {j.Username}, cause it is a bot!**");
eb1.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb1.Build());
return;
}
if (DBData.getCoins(Context.User.Id) < amount)
{
EmbedBuilder eb1 = new EmbedBuilder();
eb1.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb1.WithColor(40, 200, 150);
eb1.WithDescription($"**You don't have {amount} Ducky Coins to give them**");
eb1.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb1.Build());
return;
}
await DBData.saveCoins(j.Id, amount);
await DBData.removeCoins(Context.User.Id, amount);
EmbedBuilder eb = new EmbedBuilder();
eb.WithAuthor($"Succesfull", Context.User.GetAvatarUrl());
eb.WithColor(40, 200, 150);
eb.WithDescription($"**Succesfully gave {amount} Ducky Coins to {j.Username}**");
eb.WithThumbnailUrl(j.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, eb.Build());
return;
}
catch (Exception)
{
if (amount >= 0)
{
EmbedBuilder eb1 = new EmbedBuilder();
eb1.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb1.WithColor(40, 200, 150);
eb1.WithDescription($"**Can't find user with id {output} in all connected to the bot servers.**");
eb1.WithThumbnailUrl(Settings.MainThumbnailUrl);
await Context.Channel.SendMessageAsync("", false, eb1.Build());
}
else
{
EmbedBuilder eb1 = new EmbedBuilder();
eb1.WithAuthor($"Error", Context.User.GetAvatarUrl());
eb1.WithColor(40, 200, 150);
eb1.WithDescription($"**Please type right amount of Ducky Coins to give them.**");
eb1.WithThumbnailUrl(Settings.MainThumbnailUrl);
await Context.Channel.SendMessageAsync("", false, eb1.Build());
}
return;
}
}
}
}
