Forum ‹ BigDB ‹ Deleting inactive players

[capitaljmedia]

Hey all,

Any advice on how to automatically delete inactive players? I know that I can just run a check on the server whenever anyone joins the game to see if there are any players that have been inactive for a while, but I don't really want this check run during every player's login. I would just want it run once a day, it would be great if there was a way to run a maintenance room once a day that went through the DB and checked for things like this.

-JJ

[Vania]

I need to do this too since the database is full of trash and my games are disabled.

I wonder if playerio keeps information about the last time a player logged in, etc...

[johnnyk427]

Related question: Is there a way to delete an entire database from the web interface?

[Benjaminsen]

You could have something that runs once a day, by checking BigDB to see if it has already been run when a room is created.

Tabels can be truncated from the web-admin yes.

[capitaljmedia]

But that can only be run when a room is created. If for some reason no rooms are created for a few days then the database cleaning will not run, correct?

-JJ

[Benjaminsen]

But that can only be run when a room is created. If for some reason no rooms are created for a few days then the database cleaning will not run, correct?

-JJ

Correct, but if you don't have any users online, you really have other issues to worry about