public void Load(DatabaseConnection dbConnection)
{
var database = dbConnection.Database;
string query = "SELECT pokedex_pokemon.PokemonName, pokedex_pokemon.SpeciesName, " +
"pokedex_pokemon.GrowthGroup, pokedex_pokemon.EggGroup1, pokedex_pokemon.EggGroup2 " +
"FROM pokedex_pokemon " +
"WHERE pokedex_pokemon.DexNum = \'" + ID + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null)
{
Name = row["PokemonName"].ValueString;
SpeciesName = row["SpeciesName"].ValueString;
GrowthGroup = (Enums.GrowthGroup)row["GrowthGroup"].ValueString.ToInt();
EggGroup1 = row["EggGroup1"].ValueString;
EggGroup2 = row["EggGroup2"].ValueString;
}
int formNum = 0;
query = "SELECT pokedex_pokemonform.FormName, pokedex_pokemonform.HP, " +
"pokedex_pokemonform.Attack, pokedex_pokemonform.Defense, " +
"pokedex_pokemonform.SpecialAttack, pokedex_pokemonform.SpecialDefense, " +
"pokedex_pokemonform.Speed, pokedex_pokemonform.Male, pokedex_pokemonform.Female, " +
"pokedex_pokemonform.Height, pokedex_pokemonform.Weight, " +
"pokedex_pokemonform.Type1, pokedex_pokemonform.Type2, " +
"pokedex_pokemonform.Ability1, pokedex_pokemonform.Ability2, pokedex_pokemonform.Ability3, " +
"pokedex_pokemonform.ExpYield " +
"FROM pokedex_pokemonform " +
"WHERE pokedex_pokemonform.DexNum = \'" + ID + "\' " +
"AND pokedex_pokemonform.FormNum = \'" + formNum + "\'";
row = database.RetrieveRow(query);
while (row != null)
{
PokemonForm form = new PokemonForm();
form.FormIndex = formNum;
form.FormName = row["FormName"].ValueString;
form.BaseHP = row["HP"].ValueString.ToInt();
form.BaseAtt = row["Attack"].ValueString.ToInt();
form.BaseDef = row["Defense"].ValueString.ToInt();
form.BaseSpAtt = row["SpecialAttack"].ValueString.ToInt();
form.BaseSpDef = row["SpecialDefense"].ValueString.ToInt();
form.BaseSpd = row["Speed"].ValueString.ToInt();
form.MaleRatio = row["Male"].ValueString.ToInt();
form.FemaleRatio = row["Female"].ValueString.ToInt();
form.Height = row["Height"].ValueString.ToDbl();
form.Weight = row["Weight"].ValueString.ToDbl();
form.Type1 = (Enums.PokemonType)row["Type1"].ValueString.ToInt();
form.Type2 = (Enums.PokemonType)row["Type2"].ValueString.ToInt();
form.Ability1 = row["Ability1"].ValueString;
form.Ability2 = row["Ability2"].ValueString;
form.Ability3 = row["Ability3"].ValueString;
form.BaseRewardExp = row["ExpYield"].ValueString.ToInt();
form.LoadAppearance(dbConnection, ID, formNum);
form.LoadMoves(dbConnection, ID, formNum);
Forms.Add(form);
formNum++;
query = "SELECT pokedex_pokemonform.FormName, pokedex_pokemonform.HP, " +
"pokedex_pokemonform.Attack, pokedex_pokemonform.Defense, " +
"pokedex_pokemonform.SpecialAttack, pokedex_pokemonform.SpecialDefense, " +
"pokedex_pokemonform.Speed, pokedex_pokemonform.Male, pokedex_pokemonform.Female, " +
"pokedex_pokemonform.Height, pokedex_pokemonform.Weight, " +
"pokedex_pokemonform.Type1, pokedex_pokemonform.Type2, " +
"pokedex_pokemonform.Ability1, pokedex_pokemonform.Ability2, pokedex_pokemonform.Ability3, " +
"pokedex_pokemonform.ExpYield " +
"FROM pokedex_pokemonform " +
"WHERE pokedex_pokemonform.DexNum = \'" + ID + "\' " +
"AND pokedex_pokemonform.FormNum = \'" + formNum + "\'";
row = database.RetrieveRow(query);
}
}
/*
public void Load() {
int formNum = 0;
while (IO.IO.FileExists(IO.Paths.PokedexFolder + ID + "-" + formNum + ".xml")) {
PokemonForm form = new PokemonForm();
form.FormIndex = formNum;
form.Load(ID);
Forms.Add(form);
formNum++;
}
}
public void Save() {
foreach(PokemonForm form in Forms) {
form.Save(ID);
}
}
*/
public void Load(DatabaseConnection dbConnection)
{
MySql database = dbConnection.Database;
string query = "SELECT pokedex_pokemon.PokemonName, pokedex_pokemon.SpeciesName, " +
"pokedex_pokemon.GrowthGroup, pokedex_pokemon.EggGroup1, pokedex_pokemon.EggGroup2 " +
"FROM pokedex_pokemon " +
"WHERE pokedex_pokemon.DexNum = \'" + ID + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null)
{
Name = row["PokemonName"].ValueString;
SpeciesName = row["SpeciesName"].ValueString;
GrowthGroup = (Enums.GrowthGroup)row["GrowthGroup"].ValueString.ToInt();
EggGroup1 = row["EggGroup1"].ValueString;
EggGroup2 = row["EggGroup2"].ValueString;
}
int formNum = 0;
query = "SELECT pokedex_pokemonform.FormName, pokedex_pokemonform.HP, " +
"pokedex_pokemonform.Attack, pokedex_pokemonform.Defense, " +
"pokedex_pokemonform.SpecialAttack, pokedex_pokemonform.SpecialDefense, " +
"pokedex_pokemonform.Speed, pokedex_pokemonform.Male, pokedex_pokemonform.Female, " +
"pokedex_pokemonform.Height, pokedex_pokemonform.Weight, " +
"pokedex_pokemonform.Type1, pokedex_pokemonform.Type2, " +
"pokedex_pokemonform.Ability1, pokedex_pokemonform.Ability2, pokedex_pokemonform.Ability3, " +
"pokedex_pokemonform.ExpYield " +
"FROM pokedex_pokemonform " +
"WHERE pokedex_pokemonform.DexNum = \'" + ID + "\' " +
"AND pokedex_pokemonform.FormNum = \'" + formNum + "\'";
row = database.RetrieveRow(query);
while (row != null)
{
PokemonForm form = new PokemonForm();
form.FormName = row["FormName"].ValueString;
form.BaseHP = row["HP"].ValueString.ToInt();
form.BaseAtt = row["Attack"].ValueString.ToInt();
form.BaseDef = row["Defense"].ValueString.ToInt();
form.BaseSpAtt = row["SpecialAttack"].ValueString.ToInt();
form.BaseSpDef = row["SpecialDefense"].ValueString.ToInt();
form.BaseSpd = row["Speed"].ValueString.ToInt();
form.MaleRatio = row["Male"].ValueString.ToInt();
form.FemaleRatio = row["Female"].ValueString.ToInt();
form.Height = row["Height"].ValueString.ToDbl();
form.Weight = row["Weight"].ValueString.ToDbl();
form.Type1 = (Enums.PokemonType)row["Type1"].ValueString.ToInt();
form.Type2 = (Enums.PokemonType)row["Type2"].ValueString.ToInt();
form.Ability1 = row["Ability1"].ValueString;
form.Ability2 = row["Ability2"].ValueString;
form.Ability3 = row["Ability3"].ValueString;
form.BaseRewardExp = row["ExpYield"].ValueString.ToInt();
form.LoadAppearance(dbConnection, ID, formNum);
form.LoadMoves(dbConnection, ID, formNum);
Forms.Add(form);
formNum++;
query = "SELECT pokedex_pokemonform.FormName, pokedex_pokemonform.HP, " +
"pokedex_pokemonform.Attack, pokedex_pokemonform.Defense, " +
"pokedex_pokemonform.SpecialAttack, pokedex_pokemonform.SpecialDefense, " +
"pokedex_pokemonform.Speed, pokedex_pokemonform.Male, pokedex_pokemonform.Female, " +
"pokedex_pokemonform.Height, pokedex_pokemonform.Weight, " +
"pokedex_pokemonform.Type1, pokedex_pokemonform.Type2, " +
"pokedex_pokemonform.Ability1, pokedex_pokemonform.Ability2, pokedex_pokemonform.Ability3, " +
"pokedex_pokemonform.ExpYield " +
"FROM pokedex_pokemonform " +
"WHERE pokedex_pokemonform.DexNum = \'" + ID + "\' " +
"AND pokedex_pokemonform.FormNum = \'" + formNum + "\'";
row = database.RetrieveRow(query);
}
}
