Ok, My sql server has a table called Locations which has the information on what creatures are located in what zone and how many creatures are in the zone. In the creatures table it has the creature I.D. name, and all its stats along with how long it takes to respawn. How am I able to have the server keep track of the respawn time in seconds. Like if Player A kills Creature 3 than set off Creature 3's respawn timer until it reaches zero which will then load it back to default so other players can kill it. It is a text based MMORPG being written in C++ btw.
Thanks, any help is appreciated