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