public static void Insert(AccountData data) { MysqlQuery query = new MysqlQuery(INSERT_QUERY); query.AddValue("GUID", data.Id, MySqlDbType.Int32); query.AddValue("USERNAME", data.Login.Length > 16 ? data.Login.Substring(0, 16) : data.Login, MySqlDbType.VarChar); query.AddValue("PASSWORD", data.Password.Length > 32 ? data.Password.Substring(0, 32) : data.Password, MySqlDbType.VarChar); MysqlDB.Query(query); }
public static void UpdateAll(Dictionary <int, AccountData> accounts) { foreach (var a in accounts) { MysqlQuery query = new MysqlQuery(UPDATE_QUERY); query.AddValue("GUID", a.Value.Id, MySqlDbType.Int32); query.AddValue("ACCESSLEVEL", a.Value.AccessLevel, MySqlDbType.Int32); MysqlDB.Query(query); } }
public static void UpdateAll(Dictionary<int, AccountData> accounts) { foreach (var a in accounts) { MysqlQuery query = new MysqlQuery(UPDATE_QUERY); query.AddValue("GUID", a.Value.Id, MySqlDbType.Int32); query.AddValue("ACCESSLEVEL", a.Value.AccessLevel, MySqlDbType.Int32); MysqlDB.Query(query); } }