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