public static void LoadEvo(int evoNum, PMDCP.DatabaseConnector.MySql.MySql database) { if (evolution.Evolutions.ContainsKey(evoNum) == false) { evolution.Evolutions.Add(evoNum, new Evolution()); } string query = "SELECT name, " + "species, " + "is_sandboxed " + "FROM evolution WHERE evolution.num = \'" + evoNum + "\'"; DataColumnCollection row = database.RetrieveRow(query); if (row != null) { evolution[evoNum].Name = row["name"].ValueString; evolution[evoNum].Species = row["species"].ValueString.ToInt(); evolution[evoNum].IsSandboxed = row["is_sandboxed"].ValueString.ToBool(); } query = "SELECT branch, " + "name, " + "species, " + "req_script, " + "data1, " + "data2, " + "data3 " + "FROM evolution_branch WHERE evolution_branch.num = \'" + evoNum + "\'"; foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query)) { int tradeNum = columnCollection["branch"].ValueString.ToInt(); EvolutionBranch newBranch = new EvolutionBranch(); newBranch.Name = columnCollection["name"].ValueString; newBranch.NewSpecies = columnCollection["species"].ValueString.ToInt(); newBranch.ReqScript = columnCollection["req_script"].ValueString.ToInt(); newBranch.Data1 = columnCollection["data1"].ValueString.ToInt(); newBranch.Data2 = columnCollection["data2"].ValueString.ToInt(); newBranch.Data3 = columnCollection["data3"].ValueString.ToInt(); evolution[evoNum].Branches.Add(newBranch); } }
public static void LoadEvo(int evoNum, MySql database) { if (evolution.Evolutions.ContainsKey(evoNum) == false) evolution.Evolutions.Add(evoNum, new Evolution()); string query = "SELECT name, " + "species " + "FROM evolution WHERE evolution.num = \'" + evoNum + "\'"; DataColumnCollection row = database.RetrieveRow(query); if (row != null) { evolution[evoNum].Name = row["name"].ValueString; evolution[evoNum].Species = row["species"].ValueString.ToInt(); } query = "SELECT branch, " + "name, " + "species, " + "req_script, " + "data1, " + "data2, " + "data3 " + "FROM evolution_branch WHERE evolution_branch.num = \'" + evoNum + "\'"; foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query)) { int tradeNum = columnCollection["branch"].ValueString.ToInt(); EvolutionBranch newBranch = new EvolutionBranch(); newBranch.Name = columnCollection["name"].ValueString; newBranch.NewSpecies = columnCollection["species"].ValueString.ToInt(); newBranch.ReqScript = columnCollection["req_script"].ValueString.ToInt(); newBranch.Data1 = columnCollection["data1"].ValueString.ToInt(); newBranch.Data2 = columnCollection["data2"].ValueString.ToInt(); newBranch.Data3 = columnCollection["data3"].ValueString.ToInt(); evolution[evoNum].Branches.Add(newBranch); } }