//SPAWN MUSHROOMS
void SpawnMushrooms()
{
// If any mushrooms are found in the database
if (mushroomCount > 0)
{
/* Stores the command in a string
* The command selects the values from the player table which are for the character name selected inside the PlayerMainScript
*/
string sqlQueryMushrooms = "SELECT mushID, posX, posY, posZ, currentAge, deathAge FROM MushroomsTable WHERE id = '" + charName + "';";
dbcmd.CommandText = sqlQueryMushrooms;
IDataReader readerMushrooms = dbcmd.ExecuteReader();
while (readerMushrooms.Read())
{
//sets the results into variables
int mushroomID = readerMushrooms.GetInt32(0);
float mushroomPosX = readerMushrooms.GetFloat(1);
float mushroomPosY = readerMushrooms.GetFloat(2);
float mushroomPosZ = readerMushrooms.GetFloat(3);
float mushroomAge = readerMushrooms.GetFloat(4);
float mushroomDeathAge = readerMushrooms.GetFloat(5);
/* Uses the CreateDBMushroom script, which is described inside the mushroom script
* in order to spawn the mushrooms loaded from the database
* Also displays their information into the console
*/
mushroomScript.CreateDBMushroom(mushroomID, mushroomPosX, mushroomPosY, mushroomPosZ, mushroomAge, mushroomDeathAge);
Debug.Log("Mushroom Created. ID: " + mushroomID + " x = " + mushroomPosX + " y = " + mushroomPosY + " z = "
+ mushroomPosZ + " Age: " + mushroomAge + " Death Age: " + mushroomDeathAge);
}
//closes the reader and makes sure it's null (debugging purposes)
readerMushrooms.Close();
readerMushrooms = null;
}
//Spawns random mushrooms
else
{
mushroomScript.CreateMushrooms();
}
}
