public bool TryGetLeaderBoardData(int GameId, out LeaderBoardData LeaderBoard)
{
if (this._leaderBoardData.TryGetValue(GameId, out LeaderBoard))
{
return(true);
}
return(false);
}
public bool TryGetLeaderBoardDataWithWeek(int GameId, int Week, out LeaderBoardData LeaderBoardData)
{
if (this._leaderboards.TryGetValue(Week, out LeaderBoardData) && this._leaderboards.TryGetValue(GameId, out LeaderBoardData))
{
return(true);
}
return(false);
}
public void Init()
{
if (_games.Count > 0)
{
_games.Clear();
}
if (_leaderBoardData.Count > 0)
{
_leaderBoardData.Clear();
}
using (IQueryAdapter dbClient = RavenEnvironment.GetDatabaseManager().GetQueryReactor())
{
DataTable GetData = null;
dbClient.SetQuery("SELECT `id`,`name`,`colour_one`,`colour_two`,`resource_path`,`string_three`,`game_swf`,`game_assets`,`game_server_host`,`game_server_port`,`socket_policy_port`,`game_enabled` FROM `games_config`");
GetData = dbClient.getTable();
if (GetData != null)
{
foreach (DataRow Row in GetData.Rows)
{
using (IQueryAdapter dbClient2 = RavenEnvironment.GetDatabaseManager().GetQueryReactor())
{
DataTable GetLeaderData = null;
dbClient2.SetQuery("SELECT * FROM `games_leaderboard` WHERE game_id = " + Convert.ToInt32(Row["id"]) + " ORDER BY points ASC");
GetLeaderData = dbClient2.getTable();
if (GetLeaderData != null)
{
foreach (DataRow Rows in GetLeaderData.Rows)
{
LeaderBoardData value = new LeaderBoardData(Convert.ToInt32(Rows["game_id"]), Convert.ToInt32(Rows["user_id"]), Convert.ToInt32(Rows["points"]), Convert.ToInt32(Rows["record"]), Convert.ToInt32(Rows["week"]), Convert.ToInt32(Rows["year"]));
this._leaderBoardData.Add(Convert.ToInt32(Rows["id"]), value);
}
}
this._games.Add(Convert.ToInt32(Row["id"]), new GameData(Convert.ToInt32(Row["id"]), Convert.ToString(Row["name"]), Convert.ToString(Row["colour_one"]), Convert.ToString(Row["colour_two"]), Convert.ToString(Row["resource_path"]), Convert.ToString(Row["string_three"]), Convert.ToString(Row["game_swf"]), Convert.ToString(Row["game_assets"]), Convert.ToString(Row["game_server_host"]), Convert.ToString(Row["game_server_port"]), Convert.ToString(Row["socket_policy_port"]), RavenEnvironment.EnumToBool(Row["game_enabled"].ToString()), _leaderBoardData));
}
}
}
}
log.Info(">> GameCenter Manager -> READY!");
}
