void LoadFromDataBase() { listSquadInfo.Clear(); dbconn.Open(); dbcmd = dbconn.CreateCommand(); string sqlQuery = "SELECT * FROM CurrentMissionSquadSetup"; dbcmd.CommandText = sqlQuery; reader = dbcmd.ExecuteReader(); while (reader.Read()) { SquadStruct temp = new SquadStruct(); temp.squadID = reader.GetInt32(0); temp.unit1ID = reader.GetInt32(1); temp.unit2ID = reader.GetInt32(2); temp.unit3ID = reader.GetInt32(3); temp.unit4ID = reader.GetInt32(4); temp.position.x = reader.GetFloat(5); temp.position.y = reader.GetFloat(6); temp.position.z = reader.GetFloat(7); temp.squadHealth = reader.GetFloat(8); listSquadInfo.Add(temp); } dbconn.Close(); }
//Method: Start //Purpose -- This method is mainly used for initialization //of a class' private data fields. Use this method when //initializing stuff, do it here and only here. void Start() { squadInfo = SquadManager.instance.CurrentSquad; //=======Testing righ now. Need to call with parameter to create multiple Golem with golem ID======== SpawnManager.instance.SpawnUnit(1, leftEnd); SetupGolem(); //CameraManager.instance.CameraManager_MainEnemy = listOfGolem[0]; GetAllUnitOnMap(); }