public static void AddMissionClientData(MySql database, int difficulty, int index, MissionClientData data)
{
database.AddRow("mission_client", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "ClientIndex", index.ToString()),
database.CreateColumn(false, "DexNum", data.DexNum.ToString()),
database.CreateColumn(false, "FormNum", data.FormNum.ToString())
});
}
public static IEnumerable<MissionClientData> LoadMissionClientData(MySql database, int difficulty)
{
string query = "SELECT mission_client.DexNum, mission_client.FormNum " +
"FROM mission_client " +
"WHERE mission_client.Rank = \'" + difficulty + "\' " +
"ORDER BY mission_client.ClientIndex";
foreach (DataColumnCollection column in database.RetrieveRowsEnumerable(query)) {
MissionClientData data = new MissionClientData();
data.DexNum = column["DexNum"].ValueString.ToInt();
data.FormNum = column["FormNum"].ValueString.ToInt();
yield return data;
}
}
public static IEnumerable <MissionClientData> LoadMissionClientData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty)
{
string query = "SELECT mission_client.DexNum, mission_client.FormNum " +
"FROM mission_client " +
"WHERE mission_client.Rank = \'" + difficulty + "\' " +
"ORDER BY mission_client.ClientIndex";
foreach (DataColumnCollection column in database.RetrieveRowsEnumerable(query))
{
MissionClientData data = new MissionClientData();
data.DexNum = column["DexNum"].ValueString.ToInt();
data.FormNum = column["FormNum"].ValueString.ToInt();
yield return(data);
}
}
public static void AddMissionClientData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty, int index, MissionClientData data)
{
database.AddRow("mission_client", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "ClientIndex", index.ToString()),
database.CreateColumn(false, "DexNum", data.DexNum.ToString()),
database.CreateColumn(false, "FormNum", data.FormNum.ToString())
});
}