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