public static bool LoadArenaQualifiers() { using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString"))) { using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.SELECT, false)) { cmd.Finish("DB_ArenaQualifier"); } while (sql.Read()) { Data.ArenaInfo arena = new ProjectX_V3_Game.Data.ArenaInfo(); arena.ArenaID = sql.ReadInt32("ArenaID"); arena.DatabaseID = sql.ReadInt32("PlayerID"); arena.Level = sql.ReadUInt32("ArenaLevel"); arena.Class = sql.ReadUInt32("ArenaClass"); arena.Name = sql.ReadString("PlayerName"); arena.Mesh = sql.ReadUInt32("Mesh"); arena.ArenaTotalWins = sql.ReadUInt32("TotalWins"); arena.ArenaWinsToday = sql.ReadUInt32("TotalWinsToday"); arena.ArenaTotalLoss = sql.ReadUInt32("TotalLoss"); arena.ArenaLossToday = sql.ReadUInt32("TotalLossToday"); arena.ArenaPoints = sql.ReadUInt32("ArenaPoints"); arena.ArenaHonorPoints = sql.ReadUInt32("HonorPoints"); DateTime dailyupdate = sql.ReadDateTime("TodayUpdate"); if (DateTime.Now >= dailyupdate.AddHours(24)) { UpdateArenaInfo(arena.DatabaseID, "TodayUpdate", DateTime.Now); arena.ArenaLossToday = 0; arena.ArenaWinsToday = 0; arena.Save(); } if (!Data.ArenaQualifier.AddArenaInfo(arena)) { return false; } } } Data.ArenaQualifier.GetTop10(); Data.ArenaQualifier.GetTop10(); return true; }
public static bool LoadArenaQualifiers() { using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString"))) { using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.SELECT, false)) { cmd.Finish("DB_ArenaQualifier"); } while (sql.Read()) { Data.ArenaInfo arena = new ProjectX_V3_Game.Data.ArenaInfo(); arena.ArenaID = sql.ReadInt32("ArenaID"); arena.DatabaseID = sql.ReadInt32("PlayerID"); arena.Level = sql.ReadUInt32("ArenaLevel"); arena.Class = sql.ReadUInt32("ArenaClass"); arena.Name = sql.ReadString("PlayerName"); arena.Mesh = sql.ReadUInt32("Mesh"); arena.ArenaTotalWins = sql.ReadUInt32("TotalWins"); arena.ArenaWinsToday = sql.ReadUInt32("TotalWinsToday"); arena.ArenaTotalLoss = sql.ReadUInt32("TotalLoss"); arena.ArenaLossToday = sql.ReadUInt32("TotalLossToday"); arena.ArenaPoints = sql.ReadUInt32("ArenaPoints"); arena.ArenaHonorPoints = sql.ReadUInt32("HonorPoints"); DateTime dailyupdate = sql.ReadDateTime("TodayUpdate"); if (DateTime.Now >= dailyupdate.AddHours(24)) { UpdateArenaInfo(arena.DatabaseID, "TodayUpdate", DateTime.Now); arena.ArenaLossToday = 0; arena.ArenaWinsToday = 0; arena.Save(); } if (!Data.ArenaQualifier.AddArenaInfo(arena)) { return(false); } } } Data.ArenaQualifier.GetTop10(); Data.ArenaQualifier.GetTop10(); return(true); }