Code:
public static void LoadMonsterSpawns()
{
lock (DatabaseConnection.Connection)
{
MySqlCommand Cmd = new MySqlCommand("SELECT * FROM `mobspawns`", DatabaseConnection.Connection);
MySqlDataReader DR = Cmd.ExecuteReader();
int TotalSpawns = 0;
while (DR.Read())
{
MonsterSpawn MS = new MonsterSpawn();
MS.Map = Convert.ToInt32(DR["Map"]);
MS.MobID = Convert.ToInt32(DR["ID"]);
MS.SpawnID = Convert.ToInt32(DR["UniSpawnID"]);
MS.SpawnNumber = Convert.ToInt32(DR["NumberToSpawnf"]);
MS.MaxSpawnNumber = MS.SpawnNumber;
TotalSpawns += MS.SpawnNumber;
MS.X = Convert.ToInt32(DR["x-start"]);
MS.XStop = Convert.ToInt32(DR["x-stop"]);
MS.Y = Convert.ToInt32(DR["y-start"]);
MS.YStop = Convert.ToInt32(DR["y-stop"]);
if (!Nano.MonsterSpawns.ContainsKey(MS.SpawnID))
{
Nano.MonsterSpawns.Add(MS.SpawnID, MS);
}
}
Console.WriteLine("[GameServer] Loaded " + Nano.MonsterSpawns.Count + " unique monster spawns.");
Console.WriteLine("[GameServer] Will theoretically spawn " + TotalSpawns + " monsters into the world.");
DR.Close();
}
}






