public WonderMail(PlayerDataJobListItem baseJobItem) { this.baseJobItem = baseJobItem; }
public static void LoadPlayerMissionBoardMissions(MySql database, PlayerData playerData) { string query = "SELECT mission_board_missions.Slot, " + "mission_board_missions.ClientIndex, mission_board_missions.TargetIndex, mission_board_missions.RewardIndex, mission_board_missions.MissionType, " + "mission_board_missions.Data1, mission_board_missions.Data2, mission_board_missions.DungeonIndex, mission_board_missions.Goal, " + "mission_board_missions.RDungeon, mission_board_missions.StartScript, mission_board_missions.WinScript, mission_board_missions.LoseScript " + "FROM mission_board_missions " + "WHERE mission_board_missions.CharID = \'" + playerData.CharID + "\' " + "ORDER BY mission_board_missions.Slot"; foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query)) { int slot = columnCollection["Slot"].ValueString.ToInt(); PlayerDataJobListItem job = new PlayerDataJobListItem(); job.MissionClientIndex = columnCollection["ClientIndex"].ValueString.ToInt(); job.TargetIndex = columnCollection["TargetIndex"].ValueString.ToInt(); job.RewardIndex = columnCollection["RewardIndex"].ValueString.ToInt(); job.MissionType = columnCollection["MissionType"].ValueString.ToInt(); job.Data1 = columnCollection["Data1"].ValueString.ToInt(); job.Data2 = columnCollection["Data2"].ValueString.ToInt(); job.DungeonIndex = columnCollection["DungeonIndex"].ValueString.ToInt(); job.GoalMapIndex = columnCollection["Goal"].ValueString.ToInt(); job.RDungeon = columnCollection["RDungeon"].ValueString.ToBool(); job.StartStoryScript = columnCollection["StartScript"].ValueString.ToInt(); job.WinStoryScript = columnCollection["WinScript"].ValueString.ToInt(); job.LoseStoryScript = columnCollection["LoseScript"].ValueString.ToInt(); playerData.MissionBoardMissions.Add(job); } }
public WonderMailJob(PlayerDataJobListItem baseJobItem) { mission = new WonderMail(baseJobItem); }
public static void LoadPlayerJobList(MySql database, PlayerData playerData) { string query = "SELECT job_list.Accepted, job_list.SendsRemaining, " + "job_list.ClientIndex, job_list.TargetIndex, job_list.RewardIndex, job_list.MissionType, " + "job_list.Data1, job_list.Data2, job_list.DungeonIndex, job_list.Goal, " + "job_list.RDungeon, job_list.StartScript, job_list.WinScript, job_list.LoseScript " + "FROM job_list " + "WHERE job_list.CharID = \'" + playerData.CharID + "\' " + "ORDER BY job_list.JobListSlot"; foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query)) { PlayerDataJobListItem jobItem = new PlayerDataJobListItem(); jobItem.Accepted = columnCollection["Accepted"].ValueString.ToInt(); jobItem.SendsRemaining = columnCollection["SendsRemaining"].ValueString.ToInt(); jobItem.MissionClientIndex = columnCollection["ClientIndex"].ValueString.ToInt(); jobItem.TargetIndex = columnCollection["TargetIndex"].ValueString.ToInt(); jobItem.RewardIndex = columnCollection["RewardIndex"].ValueString.ToInt(); jobItem.MissionType = columnCollection["MissionType"].ValueString.ToInt(); jobItem.Data1 = columnCollection["Data1"].ValueString.ToInt(); jobItem.Data2 = columnCollection["Data2"].ValueString.ToInt(); jobItem.DungeonIndex = columnCollection["DungeonIndex"].ValueString.ToInt(); jobItem.GoalMapIndex = columnCollection["Goal"].ValueString.ToInt(); jobItem.RDungeon = columnCollection["RDungeon"].ValueString.ToBool(); jobItem.StartStoryScript = columnCollection["StartScript"].ValueString.ToInt(); jobItem.WinStoryScript = columnCollection["WinScript"].ValueString.ToInt(); jobItem.LoseStoryScript = columnCollection["LoseScript"].ValueString.ToInt(); playerData.JobList.Add(jobItem); } }