public static void AddMissionRewardData(MySql database, int difficulty, int index, MissionRewardData data)
{
database.AddRow("mission_reward", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "RewardIndex", index.ToString()),
database.CreateColumn(false, "ItemNum", data.ItemNum.ToString()),
database.CreateColumn(false, "ItemAmount", data.ItemAmount.ToString()),
database.CreateColumn(false, "ItemTag", data.ItemTag)
});
}
public static IEnumerable <MissionRewardData> LoadMissionRewardData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty)
{
string query = "SELECT mission_reward.ItemNum, mission_reward.ItemAmount, mission_reward.ItemTag " +
"FROM mission_reward " +
"WHERE mission_reward.Rank = \'" + difficulty + "\' " +
"ORDER BY mission_reward.RewardIndex";
foreach (DataColumnCollection column in database.RetrieveRowsEnumerable(query))
{
MissionRewardData data = new MissionRewardData();
data.ItemNum = column["ItemNum"].ValueString.ToInt();
data.ItemAmount = column["ItemAmount"].ValueString.ToInt();
data.ItemTag = column["ItemTag"].ValueString;
yield return(data);
}
}
public static IEnumerable<MissionRewardData> LoadMissionRewardData(MySql database, int difficulty)
{
string query = "SELECT mission_reward.ItemNum, mission_reward.ItemAmount, mission_reward.ItemTag " +
"FROM mission_reward " +
"WHERE mission_reward.Rank = \'" + difficulty + "\' " +
"ORDER BY mission_reward.RewardIndex";
foreach (DataColumnCollection column in database.RetrieveRowsEnumerable(query)) {
MissionRewardData data = new MissionRewardData();
data.ItemNum = column["ItemNum"].ValueString.ToInt();
data.ItemAmount = column["ItemAmount"].ValueString.ToInt();
data.ItemTag = column["ItemTag"].ValueString;
yield return data;
}
}
public static void AddMissionRewardData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty, int index, MissionRewardData data)
{
database.AddRow("mission_reward", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "RewardIndex", index.ToString()),
database.CreateColumn(false, "ItemNum", data.ItemNum.ToString()),
database.CreateColumn(false, "ItemAmount", data.ItemAmount.ToString()),
database.CreateColumn(false, "ItemTag", data.ItemTag)
});
}