public AtkE Buscar_Id_Atke_Criatura(int i, int N)
{
using (SqlConnection conn = new SqlConnection(@"Initial Catalog=HNI;Data Source = localhost; Integrated Security=SSPI"))
{
string strSQL = @"SELECT * FROM AtkexCriat where Criat_Id = '" + i + "' and Identi ='" + N + "'";
using (SqlCommand cmd = new SqlCommand(strSQL))
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = strSQL;
var dataReader = cmd.ExecuteReader();
var dt = new DataTable();
dt.Load(dataReader);
conn.Close();
foreach (DataRow row in dt.Rows)
{
var A = new AtkE()
{
Id = Convert.ToInt32(row["AtkE_Id"]),
};
A.Nome = "E";
return(A);
}
}
}
AtkE E = new AtkE();
E.Nome = "N";
return(E);
}
public AtkE Buscar_AtkE(int I, int Identi)
{
using (SqlConnection conn = new SqlConnection(@"Initial Catalog=HNI;Data Source = localhost; Integrated Security=SSPI"))
{
string strSQL = @"SELECT * FROM AtkexClasse where Identi = '" + Identi + "' and Classe_Id ='" + I + "'";
using (SqlCommand cmd = new SqlCommand(strSQL))
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = strSQL;
var dataReader = cmd.ExecuteReader();
var dt = new DataTable();
dt.Load(dataReader);
conn.Close();
foreach (DataRow row in dt.Rows)
{
var Atke = new AtkE()
{
Id = Convert.ToInt32(row["AtkE_Id"]),
};
Atke.Nome = "E";
return(Atke);
}
}
}
AtkE at = new AtkE();
at.Nome = "N";
return(at);
}
// Update is called once per frame
void Update()
{
if (!pause)
{
if (UnityEngine.SceneManagement.SceneManager.GetActiveScene().name == "inicial")
{
if (!jaIniciouHeroi)
{
Spawn.Start();
SpawnItens.Start();
jaIniciouHeroi = true;
}
else
{
Spawn.Update();
SpawnItens.Update();
}
}
gCombo.Update();
AtkE.Update();
}
}
public AtkE Buscar(int I)
{
using (SqlConnection conn = new SqlConnection(@"Initial Catalog=HNI;Data Source = localhost; Integrated Security=SSPI"))
{
string strSQL = @"SELECT * FROM AtkE where Id = '" + I + "'";
using (SqlCommand cmd = new SqlCommand(strSQL))
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = strSQL;
var dataReader = cmd.ExecuteReader();
var dt = new DataTable();
dt.Load(dataReader);
conn.Close();
foreach (DataRow row in dt.Rows)
{
var A = new AtkE()
{
Id = Convert.ToInt32(row["Id"]),
Nome = row["Nome"].ToString(),
Imagem = row["Imagem"].ToString(),
Mana = Convert.ToInt32(row["Mana"]),
Hp = Convert.ToInt32(row["Hp"]),
AtkF = Convert.ToInt32(row["AtkF"]),
AtkM = Convert.ToInt32(row["AtkM"]),
Def = Convert.ToInt32(row["Def"]),
};
return(A);
}
}
}
AtkE E = new AtkE();
return(E);
}
public void DisparaEspecial()
{
AtkE.Iniciar();
GameObject.FindWithTag("Player").GetComponent <EstadoDePersonagem_Gerente>().ApComandos.Mov.PararMovimento();
}
