I would like to look at the code that populates a land

[donaldcanard]

Thanks Thalix for the quick reply.

I had a C course over 40 years ago and only used it once or twice since than for small personal projects. So the C++ links you provide are way over my head.

But even though I have had no formal training in SQL, I enjoy it and have done several small personal projects using it. So I mostly understand your SQL suggestion on how to get the info I want. But when I do a cut and paste of your query I get an error that I don't understand:

ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp850_general_ci,IMPLICIT) for operation '='

Even though it is my own server (and I am the only one using it), I do not want to "cheat" by shortening the spider respond time, I just want to know if there are other mobs I could kill that would increase the chance a a spider responing.

[Thalix]

No idea why the SQL does not work for you. It works under HeidiSQL and phpmyadmin (both with mariadb) without problems.

To your question, in this case you have to look in the spawngroup table. The Spawns are organized in groups. E.g. Spider1 33%, Spider2 33%, Bat1 33%. If that would be the case, you would have to kill the Bat1 as well as the spiders to get a 33% higher spawn chance for Spider1/2.

Edit: Found this on google about your SQL Error: https://stackoverflow.com/questions/...ns-mysql-error