public static bool AddNotif(DateTime time, string desc)
{
SqlConnectionStringBuilder con = new SqlConnectionStringBuilder();
con.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C: \Users\RamenNoodle\source\repos\NoodleBot — копия\NoodleBot\Data.mdf;Integrated Security=True";
UserAccounts.UserAccount Person = new UserAccounts.UserAccount();
using (SqlConnection conn = new SqlConnection(con.ConnectionString))
{
SqlCommand cmdadd = new SqlCommand("INSERT INTO Notification (Data, Description, ServerId) VALUES (@dat, @Des, @Server)");
try
{
conn.Open();
using (cmdadd)
{
cmdadd.CommandType = CommandType.Text;
cmdadd.Connection = conn;
cmdadd.Parameters.AddWithValue("@dat", time);
cmdadd.Parameters.AddWithValue("@Des", desc.ToString());
cmdadd.Parameters.AddWithValue("@Server", 1);
cmdadd.ExecuteNonQuery(); // Incorrect syntax near the keyword 'Open'.
}
conn.Close();
}
catch { return(false); }
}
return(true);
}
internal static async void AddExperience(SocketGuildUser user, SocketTextChannel channel, uint Experience, bool IgnoreCooldown = false)
{
if (false == Timer.IsRunning)
{
Timer.Start();
PlayerCooldownTime.Clear();
}
if (false == IgnoreCooldown)
{
long TimeSinceLastMessage = 0;
if (false == PlayerCooldownTime.TryGetValue(user.Id, out TimeSinceLastMessage))
{
PlayerCooldownTime.Add(user.Id, Timer.ElapsedMilliseconds);
}
else
{
if (Math.Abs(Timer.ElapsedMilliseconds - TimeSinceLastMessage) < CooldownTime)
{
return;
}
}
PlayerCooldownTime[user.Id] = Timer.ElapsedMilliseconds;
}
UserAccounts.UserAccount CurrentAccount = UserAccounts.UserAccounts.GetAccount(user);
if (null == CurrentAccount)
{
return;
}
uint OldLevel = CurrentAccount.LevelNumber;
CurrentAccount.XP += Experience;
if (OldLevel != CurrentAccount.LevelNumber)
{
SendLevelUpNotice(user, CurrentAccount.LevelNumber, CurrentAccount.XP, channel);
SetNewLevelRole(user, channel, CurrentAccount.LevelNumber);
}
UserAccounts.UserAccounts.SaveAccounts();
Console.WriteLine("User {0} Add Exp {1}", user.Nickname, Experience);
}
public static UserAccounts.UserAccount AddUserAccounts(ulong user /*, string server*/)
{
SqlConnectionStringBuilder con = new SqlConnectionStringBuilder();
con.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\RamenNoodle\source\repos\NoodleBot — копия\NoodleBot\Data.mdf;Integrated Security=True";
//Server detection for later
//int ServerID = GetServerID(server);
UserAccounts.UserAccount Person = new UserAccounts.UserAccount();
using (SqlConnection conn = new SqlConnection(con.ConnectionString))
{
SqlCommand cmdadd = new SqlCommand("INSERT INTO Users (UserName, XP, Currency) VALUES (@user, @XP, @Curr)");
try
{
conn.Open();
using (cmdadd)
{
cmdadd.CommandType = CommandType.Text;
cmdadd.Connection = conn;
cmdadd.Parameters.AddWithValue("@user", Convert.ToInt64(user));
cmdadd.Parameters.AddWithValue("@XP", 10);
cmdadd.Parameters.AddWithValue("@Curr", 0);
cmdadd.ExecuteNonQuery(); // Incorrect syntax near the keyword 'Open'.
}
conn.Close();
}
catch (SqlException e) { Console.WriteLine("Ошибка при " + e); return(null); }
}
Person.ID = user;
Person.XP = 10;
Person.Points = 0;
return(Person);
}
public static UserAccounts.UserAccount GetUserData(ulong user)
{
SqlConnectionStringBuilder con = new SqlConnectionStringBuilder();
con.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\RamenNoodle\source\repos\NoodleBot — копия\NoodleBot\Data.mdf;Integrated Security=True";
UserAccounts.UserAccount Person = new UserAccounts.UserAccount();
using (SqlConnection conn = new SqlConnection(con.ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("Select UserName, XP, Currency, LastXPGet from Users WHERE UserName = "******"UserName"]);
Person.XP = Convert.ToUInt32(rdr["XP"]);
Person.Points = Convert.ToUInt32(rdr["Currency"]);
Person.LastMesg = Convert.ToDateTime(rdr["LastXPGet"]);
}
}
conn.Close();
}
catch (SqlException e) { Console.WriteLine("Ошибка при " + e); return(null); }
}
return(Person);
}
public static bool UpdateUserData(UserAccounts.UserAccount user)
{
SqlConnectionStringBuilder con = new SqlConnectionStringBuilder();
con.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\RamenNoodle\source\repos\NoodleBot — копия\NoodleBot\Data.mdf;Integrated Security=True";
using (SqlConnection conn = new SqlConnection(con.ConnectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE Users SET XP = @xp, Currency = @curr, LastXPGet = @date WHERE UserName = @user");
try
{
using (cmd)
{
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
DateTime dateTimeVariable = DateTime.Now;
cmd.Parameters.AddWithValue("@user", Convert.ToInt64(user.ID));
cmd.Parameters.AddWithValue("@xp", Convert.ToInt32(user.XP));
cmd.Parameters.AddWithValue("@curr", Convert.ToInt32(user.Points));
cmd.Parameters.AddWithValue("@date", dateTimeVariable);
cmd.ExecuteNonQuery();
}
conn.Close();
}
catch (SqlException e) { Console.WriteLine("Ошибка при " + e); return(false); }
}
return(true);
}
