public void FillData()
{
SQLiteTableReader reader = new SQLiteTableReader(null, Program.DbPath);
reader.Connect();
DataTable missionTable = reader.ExecuteQuery("SELECT tm.id as id, tm.item_id as item_id, tm.item_num as item_num, t0.text as MissionText FROM (SELECT id, item_id, item_num FROM mission_data) as tm, (SELECT \"index\", text FROM text_data WHERE category=67) as t0 WHERE tm.id = t0.\"index\"");
reader.Disconnect();
for (int i = 0; i < missionTable.Rows.Count; i++)
{
MissionData data = new MissionData();
data.Id = (long)missionTable.Rows[i]["id"];
data.ItemId = (long)missionTable.Rows[i]["item_id"];
data.ItemCount = (long)missionTable.Rows[i]["item_num"];
data.SetMissionText(((string)missionTable.Rows[i]["MissionText"]).Replace("\\n", ""));
if (!MissionDataList.Exists(a => a.MissionText.Equals(data.MissionText)))
{
string transText = Program.TransDict.GetTranslation(transDict, data.MissionText);
if (string.IsNullOrEmpty(transText))
{
transText = string.Empty;
}
data.TransMissionText = transText;
MissionDataList.Add(data);
}
}
}
public void FillData()
{
SQLiteTableReader reader = new SQLiteTableReader(null, Program.DbPath);
reader.Connect();
DataTable shopItemTable = reader.ExecuteQuery("SELECT tm.item_id, tm.coin_num, tm.motion_id, t0.text as ItemName, t1.text as ItemDesc FROM (SELECT item_id, coin_num, motion_id FROM single_mode_free_shop_item) as tm, (SELECT \"index\", text FROM text_data WHERE category=225) as t0, (SELECT \"index\", text FROM text_data WHERE category=238) as t1 WHERE tm.item_id = t0.\"index\" AND tm.item_id = t1.\"index\"");
reader.Disconnect();
for (int i = 0; i < shopItemTable.Rows.Count; i++)
{
FreeShopItemData data = new FreeShopItemData();
data.ItemId = (long)shopItemTable.Rows[i]["item_id"];
data.ItemPrice = (long)shopItemTable.Rows[i]["coin_num"];
data.SetItemName(((string)shopItemTable.Rows[i]["ItemName"]).Replace("\\n", ""));
data.ItemDesc = ((string)shopItemTable.Rows[i]["ItemDesc"]).Replace("\\n", "");
if (!FreeShopDataList.Exists(a => a.ItemName.Equals(data.ItemName)))
{
string transName = Program.TransDict.GetTranslation(transDict, data.ItemName);
if (string.IsNullOrEmpty(transName))
{
transName = string.Empty;
}
data.ItemNameTrans = transName;
string transDesc = Program.TransDict.GetTranslation(transDict, data.ItemDesc);
if (string.IsNullOrEmpty(transDesc))
{
transDesc = string.Empty;
}
data.ItemDescTrans = transDesc;
FreeShopDataList.Add(data);
}
}
}
public void FillData()
{
SQLiteTableReader reader = new SQLiteTableReader(null, Program.DbPath);
reader.Connect();
DataTable factorTable = reader.ExecuteQuery("SELECT tm.factor_id as id, tm.factor_type, t0.text as FactorName, t1.text as FactorDesc FROM (SELECT factor_id, factor_type FROM succession_factor) as tm, (SELECT \"index\", text FROM text_data WHERE category=147) as t0, (SELECT \"index\", text FROM text_data WHERE category=172) as t1 WHERE tm.factor_id = t0.\"index\" AND tm.factor_id = t1.\"index\"");
reader.Disconnect();
for (int i = 0; i < factorTable.Rows.Count; i++)
{
FactorData data = new FactorData();
data.Id = (long)factorTable.Rows[i]["id"];
data.FactorType = (FactorType)factorTable.Rows[i]["factor_type"];
data.Desc = (string)factorTable.Rows[i]["FactorDesc"];
data.Desc = data.Desc.Replace("\\n", "");
data.SetName((string)factorTable.Rows[i]["FactorName"]);
if (!FactorDataList.Exists(a => a.Name.Equals(data.Name)))
{
string transName = Program.TransDict.GetTranslation(transDict, data.Name);
if (string.IsNullOrEmpty(transName))
{
transName = string.Empty;
}
data.NameTrans = transName;
string transDesc = Program.TransDict.GetTranslation(transDict, data.Desc);
if (string.IsNullOrEmpty(transDesc))
{
transDesc = string.Empty;
}
data.DescTrans = transDesc;
FactorDataList.Add(data);
}
}
for (int i = 0; i < FactorDataList.Count; i++)
{
KeyValuePair <int, StringData> data = new KeyValuePair <int, StringData>(i, new StringData(FactorDataList[i].NameToCheck));
int key = FactorDataList[i].NameToCheck.Length;
if (factorListByName.ContainsKey(key))
{
factorListByName[key].Add(data);
}
else
{
factorListByName.Add(key, new List <KeyValuePair <int, StringData> >()
{
data
});
}
}
}
public void FillData()
{
SQLiteTableReader reader = new SQLiteTableReader(null, Program.DbPath);
reader.Connect();
DataTable skillTable = reader.ExecuteQuery("SELECT tm.id, tm.icon_id,tm.rarity, t0.text as SkillName, t1.text as SkillDesc FROM (SELECT id, rarity, icon_id FROM skill_data) as tm, (SELECT \"index\", text FROM text_data WHERE category=47) as t0, (SELECT \"index\", text FROM text_data WHERE category=48) as t1 WHERE tm.id = t0.\"index\" AND tm.id = t1.\"index\"");
reader.Disconnect();
for (int i = 0; i < skillTable.Rows.Count; i++)
{
SkillData data = new SkillData();
data.Id = (long)skillTable.Rows[i]["id"];
data.IconId = (long)skillTable.Rows[i]["icon_id"];
data.Rarity = (long)skillTable.Rows[i]["rarity"];
data.Desc = (string)skillTable.Rows[i]["SkillDesc"];
data.Desc = data.Desc.Replace("\\n", "");
data.SetName((string)skillTable.Rows[i]["SkillName"]);
SkillDataList.Add(data);
}
for (int i = 0; i < SkillDataList.Count; i++)
{
if (SkillDataList[i].Rarity > 2)
{
continue;
}
KeyValuePair <int, StringData> data = new KeyValuePair <int, StringData>(i, new StringData(SkillDataList[i].NameToCheck));
int key = SkillDataList[i].NameToCheck.Length;
if (skillListByName.ContainsKey(key))
{
skillListByName[key].Add(data);
}
else
{
skillListByName.Add(key, new List <KeyValuePair <int, StringData> >()
{
data
});
}
}
}
