public List <DDO_Mission> GetTitleMissionListByCharacterId(int charId)
{
DataSet ds = new DataSet();
cmd = "select * from `title` where charid=" + charId + ";";
pool.ExecuteSql(database, cmd, ds);
DataTable dt = ds.Tables[0];
List <DDO_Mission> missions = new List <DDO_Mission> ();
for (int i = 0; i < dt.Rows.Count; i++)
{
DDO_Mission mission = new DDO_Mission();
mission.m_missionId = short.Parse(dt.Rows[i]["titleid"].ToString());
mission.m_characterId = short.Parse(dt.Rows[i]["charid"].ToString());
mission.m_missionTargetProgressList = new List <int> ();
string[] targets = dt.Rows[i]["target"].ToString().Split(' ');
mission.m_missionTargetProgressList = new List <int> ();
if (targets[0] != "")
{
for (int j = 0; j < targets.Length; j++)
{
mission.m_missionTargetProgressList.Add(int.Parse(targets[j]));
}
}
mission.m_status = (MissionStatus)Enum.Parse(typeof(MissionStatus), dt.Rows[i]["status"].ToString());
missions.Add(mission);
}
return(missions);
}
public void InsertTitleMission(DDO_Mission ddo)
{
string target;
if (ddo.m_missionTargetProgressList.Count == 0)
{
target = "";
}
else
{
target = ddo.m_missionTargetProgressList[0].ToString();
for (int i = 1; i < ddo.m_missionTargetProgressList.Count; i++)
{
target = target + " " + ddo.m_missionTargetProgressList[i].ToString();
}
}
cmd = String.Format("insert into `title` values({0},{1},\"{2}\",\"{3}\");", ddo.m_missionId, ddo.m_characterId, target, ddo.m_status.ToString());
pool.ExecuteSql(database, cmd);
}
public void UpdateTitleMission(DDO_Mission ddo)
{
string target;
if (ddo.m_missionTargetProgressList.Count == 0)
{
target = "";
}
else
{
target = ddo.m_missionTargetProgressList[0].ToString();
for (int i = 1; i < ddo.m_missionTargetProgressList.Count; i++)
{
target = target + " " + ddo.m_missionTargetProgressList[i].ToString();
}
}
string status = ddo.m_status.ToString();
cmd = String.Format("update `title` set `target`=\"{0}\",`status`=\"{1}\" where charid={2} and titleid={3};", target, ddo.m_status.ToString(), ddo.m_characterId, ddo.m_missionId);
pool.ExecuteSql(database, cmd);
}
public void UpdateMission(DDO_Mission ddo)
{
string target;
if (ddo.m_missionTargetProgressList.Count == 0)
{
target = "";
}
else
{
target = ddo.m_missionTargetProgressList[0].ToString();
for (int i = 1; i < ddo.m_missionTargetProgressList.Count; i++)
{
target = target + " " + ddo.m_missionTargetProgressList[i].ToString();
}
}
string status = ddo.m_status.ToString();
cmd = "update mission set targets=\"" + target + "\",`status`=\"" + status + "\" where charid=" + ddo.m_characterId + " and missionid=" + ddo.m_missionId + ";";
pool.ExecuteSql(database, cmd);
}
public void InsertMission(DDO_Mission ddo)
{
string target;
if (ddo.m_missionTargetProgressList.Count == 0)
{
target = "";
}
else
{
target = ddo.m_missionTargetProgressList[0].ToString();
for (int i = 1; i < ddo.m_missionTargetProgressList.Count; i++)
{
target = target + " " + ddo.m_missionTargetProgressList[i].ToString();
}
}
string status = ddo.m_status.ToString();
cmd = "insert into mission values(" + ddo.m_missionId + "," + ddo.m_characterId + ",\"" + target + "\",\"" + status + "\");";
pool.ExecuteSql(database, cmd);
}
