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