public static void AddUser(FTClasses.User user) { if (_conn == null) { InitConn(); } FTClasses.DBTools.AddUserInformation(_conn, user); }
public static void AddUserInformation(MySqlConnection conn, FTClasses.User user) { if (conn.State != ConnectionState.Open) { conn.Open(); } DeleteUserInformation(conn, user.UserName.ToUpper()); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO users (name, token, expires, clientip, clientbuild) VALUES (@name, @token, @expires, @clientip, @clientbuild)"; cmd.Parameters.Add("@name", user.UserName.ToUpper()); cmd.Parameters.Add("@token", user.Password.Substring(0, 8)); cmd.Parameters.Add("@expires", DateTime.Now.AddMinutes(5)); cmd.Parameters.Add("@clientip", user.ClientIP); cmd.Parameters.Add("@clientbuild", user.BuildInfo); cmd.ExecuteNonQuery(); }