/// <summary>
/// Erzeugt eine neue Stationsklasse
/// </summary>
/// <param name="ID">ID</param>
/// <param name="data">GameData</param>
/// <returns></returns>
public static StationClass create(int ID, GameData data)
{
MySqlDataReader Reader = data.Query("SELECT * FROM `PX_stations` WHERE `ID` = '" + ID + "'");
Reader.Read();
string name = (string)Reader["Name"];
string buildres = (string)Reader["buildres"];
string res = (string)Reader["res"];
string buildshipS = (string)Reader["buildship"];
string buildtroopS = (string)Reader["buildtroop"];
int power = (int)Reader["Power"];
int health = (int)Reader["health"];
int power2 = (int)Reader["Power2"];
int power3 = (int)Reader["Power3"];
int power4 = (int)Reader["Power4"];
int resistend1 = (int)Reader["Resistend1"];
int resistend2 = (int)Reader["Resistend2"];
int resistend3 = (int)Reader["Resistend3"];
int resistend4 = (int)Reader["Resistend4"];
string need_temp = (string)Reader["need"];
string need_count_temp = (string)Reader["needcount"];
int updateto = (int)Reader["updateto"];
int population = (int)Reader["population"];
string names = (string)Reader["names"];
int limit = (int)Reader["limit"];
int globallimit = (int)Reader["globallimit"];
int time = (int)Reader["time"];
string need_techS = (string)Reader["need_tech"];
string skillsS = (string)Reader["skills"];
string raceS = (string)Reader["race"];
byte[] picture = (byte[])Reader["picture"];
StationClass station = new StationClass(ID, name);
station.names = names;
station.globallimit = globallimit;
station.time = time;
station.need_tech_temp = need_techS;
station.skills_temp = skillsS;
station.race_temp = raceS;
// station.buildtroop_temp = buildtroopS;
station.buildship_temp = buildshipS;
station.limit = limit;
station.need_count_temp = need_count_temp;
station.need_tech_temp = need_techS;
station.need_temp = need_temp;
station.population = population;
station.skills_temp = skillsS;
station.updateto_temp = updateto;
string costs = (string)Reader["costs"];
string[] costs_A1 = costs.Split(new string[] { "&" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string value in costs_A1)
{
try
{
string[] costs_A2 = value.Split(new string[] { "=" }, StringSplitOptions.RemoveEmptyEntries);
ResType type = (ResType)Enum.Parse(typeof(ResType), costs_A2[0]);
double cost = double.Parse(costs_A2[1]);
station.price[type] = cost;
}
catch
{
// Unsinnige Mysql Daten
}
}
station.create_res = Static.ResHelper.getResAdd(buildres, res);
station.health = health;
station.power = power;
station.power2 = power2;
station.power3 = power3;
station.power4 = power4;
station.resistend1 = resistend1;
station.resistend2 = resistend2;
station.resistend3 = resistend3;
station.resistend4 = resistend4;
try
{
station.picture = GraphicLibary.GraphicHelper.getPicture(picture);
}
catch
{
station.picture = new System.Drawing.Bitmap(1, 1);
}
Reader.Close();
return station;
}
/// <summary>
/// Erzeugt einen neuen Trupp
/// </summary>
/// <param name="ID">ID</param>
/// <param name="data">GameData</param>
/// <returns></returns>
public static Troop create(int ID, GameData data)
{
MySqlDataReader Reader = data.Query("SELECT * FROM `PX_mom-troops` WHERE `ID` = '" + ID + "'");
Reader.Read();
int type = (int)Reader["Class"];
string name = (string)Reader["Name"];
User UID = data.getUser((int)Reader["UID"]);
int power = (int)Reader["Power"];
int health = (int)Reader["health"];
int team = (int)Reader["team"];
WorldPoint position = new WorldPoint((string)(Reader["worldpos"]));
string states = (string)Reader["states"];
int power2 = (int)Reader["Power2"];
int power3 = (int)Reader["Power3"];
int power4 = (int)Reader["Power4"];
int resistend1 = (int)Reader["Resistend1"];
int resistend2 = (int)Reader["Resistend2"];
int resistend3 = (int)Reader["Resistend3"];
int resistend4 = (int)Reader["Resistend4"];
int hide = (int)Reader["hide"];
string verhalten = (string)Reader["verhalten"];
TroopClass typeClass = data.getTroopType(type);
Troop troop = new Troop(ID, typeClass, UID, name, team, states);
troop.position = position;
troop.health = health;
troop.power = power;
troop.power2 = power2;
troop.power3 = power3;
troop.power4 = power4;
troop.resistend1 = resistend1;
troop.resistend2 = resistend2;
troop.resistend3 = resistend3;
troop.resistend4 = resistend4;
troop.hide = hide;
troop.verhalten = verhalten;
troop.fighterTyp = FighterType.TROOP;
Reader.Close();
return troop;
}
/// <summary>
/// Erzeugt eine neue SchiffsKlasse
/// </summary>
/// <param name="ID">ID</param>
/// <param name="data">GameData</param>
/// <returns>ShipClass</returns>
public static ShipClass create(int ID, GameData data)
{
MySqlDataReader Reader = data.Query("SELECT * FROM `PX_ships` WHERE `ID` = '" + ID + "'");
Reader.Read();
string name = (string)Reader["Name"];
int power = (int)Reader["Power"];
int health = (int)Reader["health"];
int power2 = (int)Reader["Power2"];
int power3 = (int)Reader["Power3"];
int power4 = (int)Reader["Power4"];
int resistend1 = (int)Reader["Resistend1"];
int resistend2 = (int)Reader["Resistend2"];
int resistend3 = (int)Reader["Resistend3"];
int resistend4 = (int)Reader["Resistend4"];
string names = (string)Reader["names"];
int speed = (int)Reader["speed"];
int globallimit = (int)Reader["globallimit"];
int time = (int)Reader["time"];
string need_techS = (string)Reader["need_tech"];
string skillsS = (string)Reader["skills"];
string raceS = (string)Reader["race"];
byte[] picture = (byte[])Reader["picture"];
ShipClass ship = new ShipClass(ID, name);
ship.names = names;
ship.speed = speed;
ship.globallimit = globallimit;
ship.time = time;
ship.need_tech_temp = need_techS;
ship.skills_temp = skillsS;
ship.race_temp = raceS;
ship.health = health;
ship.power = power;
ship.power2 = power2;
ship.power3 = power3;
ship.power4 = power4;
ship.resistend1 = resistend1;
ship.resistend2 = resistend2;
ship.resistend3 = resistend3;
ship.resistend4 = resistend4;
string costs = (string)Reader["costs"];
string[] costs_A1 = costs.Split(new string[] { "&" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string value in costs_A1)
{
try
{
string[] costs_A2 = value.Split(new string[] { "=" }, StringSplitOptions.RemoveEmptyEntries);
ResType type = (ResType)Enum.Parse(typeof(ResType), costs_A2[0]);
double cost = double.Parse(costs_A2[1]);
ship.price[type] = cost;
}
catch
{
// Unsinnige Mysql Daten
}
}
try
{
ship.picture = GraphicLibary.GraphicHelper.getPicture(picture);
}
catch
{
ship.picture = new System.Drawing.Bitmap(1, 1);
}
Reader.Close();
return ship;
}
/// <summary>
/// Erezeugt eine neue Technologie
/// </summary>
/// <param name="ID">ID</param>
/// <param name="data">GameData</param>
/// <returns>Tech</returns>
public static Tech create(int ID, GameData data)
{
MySqlDataReader Reader = data.Query("SELECT * FROM `PX_tech` WHERE `ID` = '" + ID + "'");
Reader.Read();
string name = (string)Reader["Name"];
string beschreibung = (string)Reader["beschreibung"];
int water = (int)Reader["water"];
int metal = (int)Reader["metal"];
int food = (int)Reader["food"];
int naquadah = (int)Reader["naquadah"];
int time = (int)Reader["time"];
string need_techS = (string)Reader["need"];
string updateS = (string)Reader["update"];
string raceS = (string)Reader["race"];
int group = (int)Reader["group"];
Tech tech = new Tech(ID, name, beschreibung);
string costs = (string)Reader["costs"];
string[] costs_A1 = costs.Split(new string[] { "&" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string value in costs_A1)
{
try
{
string[] costs_A2 = value.Split(new string[] { "=" }, StringSplitOptions.RemoveEmptyEntries);
ResType type = (ResType)Enum.Parse(typeof(ResType), costs_A2[0]);
double cost = double.Parse(costs_A2[1]);
tech.price[type] = cost;
}
catch
{
// Unsinnige Mysql Daten
}
}
tech.time = time;
tech.need_tech_temp = need_techS;
tech.update_temp = updateS;
tech.race_temp = raceS;
tech.group = group;
Reader.Close();
return tech;
}
/// <summary>
/// Erzeugt einen neuen TruppenTyp
/// </summary>
/// <param name="ID">ID</param>
/// <param name="data">GameData</param>
/// <returns>TroopClass</returns>
public static TroopClass create(int ID, GameData data)
{
MySqlDataReader Reader = data.Query("SELECT * FROM `PX_troops` WHERE `ID` = '" + ID + "'");
Reader.Read();
string name = (string)Reader["Name"];
int power = (int)Reader["Power"];
int health = (int)Reader["health"];
int power2 = (int)Reader["Power2"];
int power3 = (int)Reader["Power3"];
int power4 = (int)Reader["Power4"];
int resistend1 = (int)Reader["Resistend1"];
int resistend2 = (int)Reader["Resistend2"];
int resistend3 = (int)Reader["Resistend3"];
int resistend4 = (int)Reader["Resistend4"];
int hide = (int)Reader["hide"];
int water = (int)Reader["water"];
int metal = (int)Reader["metal"];
int food = (int)Reader["food"];
int naquadah = (int)Reader["naquadah"];
int globallimit = (int)Reader["globallimit"];
int time = (int)Reader["time"];
string need_techS = (string)Reader["need_tech"];
string skillsS = (string)Reader["skills"];
string raceS = (string)Reader["race"];
TroopClass troop = new TroopClass(ID, name);
troop.globallimit = globallimit;
troop.time = time;
troop.need_tech_temp = need_techS;
troop.skills_temp = skillsS;
troop.race_temp = raceS;
troop.health = health;
troop.power = power;
troop.power2 = power2;
troop.power3 = power3;
troop.power4 = power4;
troop.resistend1 = resistend1;
troop.resistend2 = resistend2;
troop.resistend3 = resistend3;
troop.resistend4 = resistend4;
troop.hide = hide;
troop.metal = metal;
troop.naquadah = naquadah;
troop.food = food;
troop.water = water;
Reader.Close();
return troop;
}
/// <summary>
/// Erstellt eine neue PlanetenKlasse
/// </summary>
/// <param name="ID">ID</param>
/// <param name="data">GameData</param>
/// <returns>PlanetClass</returns>
public static PlanetClass create(int ID, GameData data)
{
MySqlDataReader Reader = data.Query("SELECT * FROM `PX_planeten` WHERE `ID` = '" + ID + "'");
Reader.Read();
string name = (string)Reader["Name"];
string buildres = (string)Reader["buildres"];
string res = (string)Reader["res"];
string buildshipS = (string)Reader["buildship"];
string buildtroopS = (string)Reader["buildtroop"];
int bewohnbar = (int)Reader["bewohnbar"];
string names = (string)Reader["names"];
byte[] picture = (byte[])Reader["bild"];
PlanetClass planet = new PlanetClass(ID, name);
planet.names = names;
planet.create_res = Static.ResHelper.getResAdd(buildres, res);
// planet.buildtroop_temp = buildtroopS;
try
{
planet.picture = GraphicLibary.GraphicHelper.getPicture(picture);
}
catch
{
planet.picture = new System.Drawing.Bitmap(1, 1);
}
planet.buildship_temp = buildshipS;
planet.bewohnbar = (bewohnbar == 1);
Reader.Close();
return planet;
}
/// <summary>
/// Erzeugt eine neue Fähigkeit
/// </summary>
/// <param name="ID">ID</param>
/// <param name="data">GameData</param>
/// <returns>Skill</returns>
public static Skill create(int ID, GameData data)
{
MySqlDataReader Reader = data.Query("SELECT * FROM `PX_skills` WHERE `ID` = '" + ID + "'");
Reader.Read();
string name = (string)Reader["Name"];
string beschreibung = (string)Reader["beschreibung"];
int time = (int)Reader["time"];
string need = (string)Reader["need"];
string states = (string)Reader["states"];
string skillS = (string)Reader["skill"];
bool passiv = ((int)Reader["passiv"] ==1);
bool ship = ((int)Reader["ship"] == 1);
bool stat = ((int)Reader["stat"] == 1);
bool troop = ((int)Reader["troop"] == 1);
Skill skill = new Skill(ID, name, beschreibung);
skill.time = time;
skill.need = need;
skill.passiv = passiv;
skill.stat = stat;
skill.ship = ship;
skill.skill = skillS;
skill.states = states;
skill.troop = troop;
Reader.Close();
return skill;
}