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