public static void Initialize(GameClock gameClock)
{
gameClock.TickEvent += new GameClock.TickHandler(On_Tick);
PlayerManager.gameClock = gameClock;
Query query = new Query("select * from Player");
foreach (DataRow player_row in query.result.Tables[0].Rows)
{
Players.Add(player_row["user_name"].ToString(), new Player(player_row["user_name"].ToString(), PlayerManager.gameClock));
}
MainForm.Log("PlayerManager Initialized");
}
private void Load_Database_Values()
{
Query query = new Query("select * from Player where user_name=\'" + this.user_name + "\'");
if (query.result.Tables[0].Rows.Count != 0)
{
this.ID = (int)query.result.Tables[0].Rows[0]["id"];
this.strategy = (PLAYER_STRAT)(int)query.result.Tables[0].Rows[0]["strategy"];
this.credits_current = (int)query.result.Tables[0].Rows[0]["credits_current"];
this.Asteroids = Parse_Asteroids(query.result.Tables[0].Rows[0]["asteroids"].ToString());
this.Structures = Parse_Structures(query.result.Tables[0].Rows[0]["structures"].ToString());
this.Ships_Attacking = Parse_Ships(query.result.Tables[0].Rows[0]["ships_attacking"].ToString());
this.Ships_Defending = Parse_Ships(query.result.Tables[0].Rows[0]["ships_defending"].ToString());
this.action_attack = Parse_Action(query.result.Tables[0].Rows[0]["action_attack"].ToString());
this.action_build_ship = Parse_Action(query.result.Tables[0].Rows[0]["action_build_ship"].ToString());
this.action_build_struct = Parse_Action(query.result.Tables[0].Rows[0]["action_build_struct"].ToString());
this.action_research = Parse_Action(query.result.Tables[0].Rows[0]["action_research"].ToString());
this.action_diplomacy = Parse_Action(query.result.Tables[0].Rows[0]["action_diplomacy"].ToString());
this.action_direct = Parse_Action(query.result.Tables[0].Rows[0]["action_direct"].ToString());
this.tech_ship_weapons = (int)query.result.Tables[0].Rows[0]["tech_ship_weapons"];
this.tech_ship_hp = (int)query.result.Tables[0].Rows[0]["tech_ship_hp"];
this.tech_ship_engine = (int)query.result.Tables[0].Rows[0]["tech_ship_engine"];
this.tech_ship_stealth = (int)query.result.Tables[0].Rows[0]["tech_ship_stealth"];
this.tech_struct_weapons = (int)query.result.Tables[0].Rows[0]["tech_struct_weapons"];
this.tech_struct_hp = (int)query.result.Tables[0].Rows[0]["tech_struct_hp"];
this.tech_struct_econ = (int)query.result.Tables[0].Rows[0]["tech_struct_mining"];
this.tech_struct_research = (int)query.result.Tables[0].Rows[0]["tech_struct_research"];
this.tech_struct_diplomacy = (int)query.result.Tables[0].Rows[0]["tech_struct_diplomacy"];
this.tech_construct_speed = (int)query.result.Tables[0].Rows[0]["tech_construct_speed"];
this.tech_base_sensors = (int)query.result.Tables[0].Rows[0]["tech_base_sensors"];
this.tech_base_fleet_cap = (int)query.result.Tables[0].Rows[0]["tech_base_fleet_cap"];
this.tech_base_asteroid_cap = (int)query.result.Tables[0].Rows[0]["tech_base_asteroid_cap"];
if (this.action_attack.Type == PLAYER_ACTION.ACTION_NO_ACTION)
{
fleet_at_home = true;
}
else
{
fleet_at_home = false;
}
}
else
{
MainForm.Log("Error! A player got past authentication without existing! Username: " + this.user_name);
}
}
public void Save_Database_Values()
{
Query query = new Query("select * from Player where user_name=\'" + this.user_name + "\'");
if (query.result.Tables[0].Rows.Count != 0)
{
query.result.Tables[0].Rows[0]["credits_current"] = this.credits_current;
query.result.Tables[0].Rows[0]["asteroids"] = Serialize_Asteroids(this.Asteroids);
query.result.Tables[0].Rows[0]["structures"] = Serialize_Structures(this.Structures);
//Store Ships
query.result.Tables[0].Rows[0]["ships_attacking"] = Serialize_Ships(this.Ships_Attacking);
query.result.Tables[0].Rows[0]["ships_defending"] = Serialize_Ships(this.Ships_Defending);
//Store Actions
query.result.Tables[0].Rows[0]["action_attack"] = Serialize_Action(this.action_attack);
query.result.Tables[0].Rows[0]["action_build_ship"] = Serialize_Action(this.action_build_ship);
query.result.Tables[0].Rows[0]["action_build_struct"] = Serialize_Action(this.action_build_struct);
query.result.Tables[0].Rows[0]["action_research"] = Serialize_Action(this.action_research);
query.result.Tables[0].Rows[0]["action_diplomacy"] = Serialize_Action(this.action_diplomacy);
query.result.Tables[0].Rows[0]["action_direct"] = Serialize_Action(this.action_direct);
//Store Tech Levels
query.result.Tables[0].Rows[0]["tech_ship_weapons"] = this.tech_ship_weapons;
query.result.Tables[0].Rows[0]["tech_ship_hp"] = this.tech_ship_hp;
query.result.Tables[0].Rows[0]["tech_ship_engine"] = this.tech_ship_engine;
query.result.Tables[0].Rows[0]["tech_ship_stealth"] = this.tech_ship_stealth;
query.result.Tables[0].Rows[0]["tech_struct_weapons"] = this.tech_struct_weapons;
query.result.Tables[0].Rows[0]["tech_struct_hp"] = this.tech_struct_hp;
query.result.Tables[0].Rows[0]["tech_struct_mining"] = this.tech_struct_econ;
query.result.Tables[0].Rows[0]["tech_struct_research"] = this.tech_struct_research;
query.result.Tables[0].Rows[0]["tech_struct_diplomacy"] = this.tech_struct_diplomacy;
query.result.Tables[0].Rows[0]["tech_construct_speed"] = this.tech_construct_speed;
query.result.Tables[0].Rows[0]["tech_base_sensors"] = this.tech_base_sensors;
query.result.Tables[0].Rows[0]["tech_base_fleet_cap"] = this.tech_base_fleet_cap;
query.result.Tables[0].Rows[0]["tech_base_asteroid_cap"] = this.tech_base_asteroid_cap;
query.Update();
}
}
