// シーン開始後に呼び出される
void Start()
{
Debug.Log("「キャラクター詳細画面」に遷移した");
this.name = CharacterList.CharacterName;
Debug.Log("name" + this.name);
// キャラクターのデータを取得する
ProcessingSQL countSQL = new ProcessingSQL();
DataTable dataTable = countSQL.SelectSQL(this.name);
//変数の準備
var name = "";
int job = 0;
int hp = 0;
int mp = 0;
int str = 0;
int def = 0;
int agi = 0;
int luck = 0;
string create_at = null;
// DBのデータを変数に格納
foreach (DataRow dr in dataTable.Rows)
{
name = (string)dr["name"];
job = (int)dr["job"];
hp = (int)dr["hp"];
mp = (int)dr["mp"];
str = (int)dr["str"];
def = (int)dr["def"];
agi = (int)dr["agi"];
luck = (int)dr["luck"];
create_at = (string)dr["create_at"];
}
// 名前の表示用
textName.text = name;
//職業の表示用
if (job == 0)
{
textJob.text = "戦士";
}
else if (job == 1)
{
textJob.text = "魔法使い";
}
else if (job == 2)
{
textJob.text = "僧侶";
}
else
{
textJob.text = "勇者";
}
textStatus.text = string.Format("\n{0}\n{1}\n{2}\n{3}\n{4}\n{5}", hp, mp, str, def, agi, luck);
}
// Start is called before the first frame update
void Start()
{
// スクロールビューに表示するノードの数を調べる
ProcessingSQL countSQL = new ProcessingSQL();
int count = countSQL.CountSQL();
// DB名を指定して接続
SqliteDatabase sqlDB = new SqliteDatabase("namebattler.db");
// 行数分のノードを作成する
for (int i = 0; i < count; i++)
{
// ノードの自動作成
var character = GameObject.Instantiate(prefab) as RectTransform;
character.SetParent(transform, false);
// ノード内に表示するテキストを検索する
DataTable dataTable = countSQL.SelectSQL(i);
string name = "";
int job = 0;
int hp = 0;
int mp = 0;
int str = 0;
int def = 0;
int agi = 0;
int luck = 0;
string create_at = null;
foreach (DataRow dr in dataTable.Rows)
{
name = (string)dr["name"];
job = (int)dr["job"];
hp = (int)dr["hp"];
mp = (int)dr["mp"];
str = (int)dr["str"];
def = (int)dr["def"];
agi = (int)dr["agi"];
luck = (int)dr["luck"];
create_at = (string)dr["create_at"];
}
texts = character.GetComponentsInChildren <Text>();
texts[0].text = name;
if (job == 0)
{
texts[1].text = "戦士";
}
else if (job == 1)
{
texts[1].text = "魔法使い";
}
else if (job == 2)
{
texts[1].text = "僧侶";
}
else
{
texts[1].text = "勇者";
}
texts[2].text = $"HP: {hp} MP: {mp} STR: {str} DEF: {def} AGI: {agi}";
}
}
