public static void AddMissionEnemyData(MySql database, int difficulty, int index, MissionEnemyData data) { database.AddRow("mission_enemy", new IDataColumn[] { database.CreateColumn(false, "Rank", difficulty.ToString()), database.CreateColumn(false, "EnemyIndex", index.ToString()), database.CreateColumn(false, "NpcNum", data.NpcNum.ToString()) }); }
public static IEnumerable<MissionEnemyData> LoadMissionEnemyData(MySql database, int difficulty) { string query = "SELECT mission_enemy.NpcNum " + "FROM mission_enemy " + "WHERE mission_enemy.Rank = \'" + difficulty + "\' " + "ORDER BY mission_enemy.EnemyIndex"; foreach (DataColumnCollection column in database.RetrieveRowsEnumerable(query)) { MissionEnemyData data = new MissionEnemyData(); data.NpcNum = column["NpcNum"].ValueString.ToInt(); yield return data; } }
public static IEnumerable <MissionEnemyData> LoadMissionEnemyData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty) { string query = "SELECT mission_enemy.NpcNum " + "FROM mission_enemy " + "WHERE mission_enemy.Rank = \'" + difficulty + "\' " + "ORDER BY mission_enemy.EnemyIndex"; foreach (DataColumnCollection column in database.RetrieveRowsEnumerable(query)) { MissionEnemyData data = new MissionEnemyData(); data.NpcNum = column["NpcNum"].ValueString.ToInt(); yield return(data); } }
public static void AddMissionEnemyData(PMDCP.DatabaseConnector.MySql.MySql database, int difficulty, int index, MissionEnemyData data) { database.AddRow("mission_enemy", new IDataColumn[] { database.CreateColumn(false, "Rank", difficulty.ToString()), database.CreateColumn(false, "EnemyIndex", index.ToString()), database.CreateColumn(false, "NpcNum", data.NpcNum.ToString()) }); }