static void Main(string[] args)
{
SqlConnection _Connection = null;
string ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\DEV\ChatApp\WpfChat\WpfChat\DBChat.mdf;Integrated Security=True";
_Connection = new SqlConnection(ConnectionString);
try
{
_Connection.Open();
Console.WriteLine("Pripojeni do DB OK!!!");
}
catch
{
Console.WriteLine("Nepodarilo se pripojeni do DB!!!");
}
bool check = SQLUser.CheckEmail("*****@*****.**", _Connection);
Console.WriteLine("check: " + check);
if (!check)
{
bool register = SQLUser.RegisterUser("*****@*****.**", "123456789", _Connection);
Console.WriteLine("register: " + register);
}
Console.ReadLine();
}
public async Task FunBucksLeaderboards()
{
string LeaderboardString = "";
SQLUser[] UserList = Silver.SQL.Users.OrderByDescending(x => x.FunBucks).Take(10).ToArray();
int maxmoneysize = 0;
for (int i = 0; i < UserList.Length; i++)
{
SQLUser sqlusr = UserList[i];
IUser usr = Context.Client.GetUser(ulong.Parse(sqlusr.UserId));
if (sqlusr.FunBucks.ToString().Length + 1 > maxmoneysize)
{
maxmoneysize = sqlusr.FunBucks.ToString().Length + 2;
}
LeaderboardString += $"{i+1}. `{("🜛" + sqlusr.FunBucks.ToString()).PadLeft(maxmoneysize)}` - {Silver.SQL.GetUserPrefName(usr, true)}\n";
}
EmbedBuilder tester = Silver.Tools.GetStockEmbed();
tester.Description = LeaderboardString;
await ReplyAsync(null, false, tester.Build());
}
