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