public ServantClass GetServant(int id)
{
ConnectToDB("SimpleGame.db");
ServantClass servant = new ServantClass();
servant.id = id;
dataReader =
ExecuteQuery("SELECT Name, Attack, Defense, Speed FROM Servant WHERE ID = " + id + ";");
while (dataReader.HasRows)
{
if (dataReader.Read())
{
servant.name = dataReader.GetString(0);
servant.atk = dataReader.GetInt32(1);
servant.def = dataReader.GetInt32(2);
servant.speed = dataReader.GetInt32(3);
}
}
CloseConnection();
return(servant);
}
public void SaveServant(ServantClass servant)
{
ConnectToDB("SimpleGame.db");
dbCommand = dbConnection.CreateCommand();
dbCommand.CommandText =
"UPDATE Servant SET Name = '" + servant.name + "', Attack = " + servant.atk + ", Defense = " + servant.def + ", Speed = " + servant.speed + " WHERE ID = " + servant.id;
dbCommand.ExecuteNonQuery();
CloseConnection();
}
public void CreateServant(ServantClass servant)
{
ConnectToDB("SimpleGame.db");
dbCommand = dbConnection.CreateCommand();
dbCommand.CommandText =
"INSERT INTO Servant (ID, Name, Attack, Defense, Speed) VALUES (" + servant.id + ", '" + servant.name + "', " + servant.atk + ", " + servant.def + ", " + servant.speed + ")";
dbCommand.ExecuteNonQuery();
CloseConnection();
}
// Start is called before the first frame update
void Start()
{
skillNameText.GetComponent <Renderer>().enabled = false;
object_hero = GameObject.Find("Hero");
object_pet = GameObject.Find("Pet");
object_servant = GameObject.Find("Servant");
object_enemy1 = GameObject.Find("Enemy1");
object_enemy2 = GameObject.Find("Enemy2");
object_enemy3 = GameObject.Find("Enemy3");
object_enemy4 = GameObject.Find("Enemy4");
object_enemy5 = GameObject.Find("Enemy5");
object_enemy6 = GameObject.Find("Enemy6");
hero = object_hero.transform.GetComponent <HeroManager>();
pet = object_pet.transform.GetComponent <HeroManager>();
servant = object_servant.transform.GetComponent <HeroManager>();
enemy1 = object_enemy1.transform.GetComponent <HeroManager>();
enemy2 = object_enemy2.transform.GetComponent <HeroManager>();
enemy3 = object_enemy3.transform.GetComponent <HeroManager>();
enemy4 = object_enemy4.transform.GetComponent <HeroManager>();
enemy5 = object_enemy5.transform.GetComponent <HeroManager>();
enemy6 = object_enemy6.transform.GetComponent <HeroManager>();
object_heroTeam = new List <GameObject>();
object_enemyTeam = new List <GameObject>();
heroTeam = new List <HeroManager>();
enemyTeam = new List <HeroManager>();
object_heroTeam.Add(object_pet);
object_heroTeam.Add(object_hero);
object_heroTeam.Add(object_servant);
object_enemyTeam.Add(object_enemy1);
object_enemyTeam.Add(object_enemy2);
object_enemyTeam.Add(object_enemy3);
object_enemyTeam.Add(object_enemy4);
object_enemyTeam.Add(object_enemy5);
object_enemyTeam.Add(object_enemy6);
heroTeam.Add(pet);
heroTeam.Add(hero);
heroTeam.Add(servant);
enemyTeam.Add(enemy1);
enemyTeam.Add(enemy2);
enemyTeam.Add(enemy3);
enemyTeam.Add(enemy4);
enemyTeam.Add(enemy5);
enemyTeam.Add(enemy6);
DBManager dbm = new DBManager();
HeroClass hc = new HeroClass();
hc = dbm.GetHero(gameID);
theHero = hc;
hero.atk = hc.atk;
hero.def = hc.def;
hero.speed = hc.speed;
hero.health = hc.life;
hero.shownName = hc.name;
PetClass pc = new PetClass();
pc = dbm.GetPet(gameID);
pet.atk = pc.atk;
pet.def = pc.def;
pet.speed = pc.speed;
pet.shownName = pc.name;
ServantClass sc = new ServantClass();
sc = dbm.GetServant(gameID);
servant.atk = sc.atk;
servant.def = sc.def;
servant.speed = sc.speed;
servant.shownName = sc.name;
List <EnemyClass> enemyList = dbm.GetAllEnemy();
for (int i = 0; i < enemyTeam.Count; i++)
{
EnemyClass ec = enemyList[Random.Range(1, enemyList.Count)];
enemyTeam[i].atk = ec.atk;
enemyTeam[i].def = ec.def;
enemyTeam[i].speed = ec.speed;
enemyTeam[i].shownName = ec.name;
enemyTeam[i].health = ec.life;
}
pet.isLive = false;
servant.isLive = false;
object_pet.SetActive(false);
object_servant.SetActive(false);
foreach (HeroManager heros in heroTeam)
{
float time = 200.0f / heros.speed;
Invoke("AttackTimer_" + heros.name, time);
}
//Invoke("AttackTimer_Hero", 0.9f);
foreach (HeroManager enemys in enemyTeam)
{
float time = 200.0f / enemys.speed;
Invoke("AttackTimer_" + enemys.name, time);
}
skillList = dbm.GetAllSkill();
}
public static void Main(string[] args)
{
while (true)
{
ServantClass.ShowMenu();
string option = ServantClass.ReadInput();
switch (option)
{
case ServantClass.ShowUsers:
WorkWithUsers.ShowUsers();
ServantClass.PressAnyKey();
break;
case ServantClass.GetUser:
WorkWithUsers.GetUserById();
ServantClass.PressAnyKey();
break;
case ServantClass.AddUser:
WorkWithUsers.AddUser();
ServantClass.PressAnyKey();
break;
case ServantClass.UpdateUser:
WorkWithUsers.UpdateUser();
ServantClass.PressAnyKey();
break;
case ServantClass.RemoveUser:
WorkWithUsers.RemoveUser();
ServantClass.PressAnyKey();
break;
case ServantClass.ShowAwards:
WorkWithAwards.ShowAwards();
ServantClass.PressAnyKey();
break;
case ServantClass.AddAward:
WorkWithAwards.AddAward();
ServantClass.PressAnyKey();
break;
case ServantClass.RemoveAward:
WorkWithAwards.RemoveAward();
ServantClass.PressAnyKey();
break;
case ServantClass.GiveAward:
WorkWithAwards.GiveToUser();
ServantClass.PressAnyKey();
break;
case ServantClass.TakeAward:
WorkWithAwards.TakeFromUser();
ServantClass.PressAnyKey();
break;
case ServantClass.Quit:
return;
default:
break;
}
}
}
