Users in Server Group

[ARCHI]

Okey, let's make it simple. I have 2 server groups on my server. Verified and Non-Verified. Non-Verified group is a default, temporary group without access to poke and chat with other users. Verified group is pernament group with access to poke and chat to other users. I don't have any problem with permissions and such stuff but main problem is... database. Clients in Verified group are not automatically deleted (that is intended, I know) and I would want to ask a question. Is there any way to delete inactive clients from database w/o deleting everyone? I'm running MySQL Database and I think that I can do that manualy with queries but firstly I would like to ask if there is any "software" way to do that.

Also it would be very cool if TeamSpeak group could add a checkbox in server group permissions "Delete inactive clients" with value of days after delete (and zero by default which means don't delete). I think that it would be cool for me and probably for much people around here because actually the only cleaning way is delete everyone from every group and wait untill they'll get automatically deleted.

Thanks for support.

[SilentStorm]

There is no automated way to delete someone from the Database after they didn't show for some period of time, and if I am not mistaken something like this was requested and rejected before.

However there is a manual way to delete Clients. Permissions -> List all Clients. In that Dialog you can right click and delete someone, it will delete them from the database. That dialog also displays when they were last logged in so you can check it there.
Only problem is: It doesn't sort correctly (well it does but only those that are displayed) so you would need to click More multiple times until every client is loaded to get sorting through all the clients. If you need to know who wasn't around for the longest time or somethin g like that.

[ARCHI]

Thank you for your reply SilentStorm. It's not that bad. I will click "More" button for about 5 minutes and list them all. Hopefully I can at least delete multiple clients at one time.

Anyway I think that such feature is really needed. Somebody from Dev team should look into that. I'm some kind of "deleting-unused-things" fanatic and teamspeak database is only getting bigger . As for now - this option isn't that bad, especially for small-medium servers like mine but later somebody should make a real solution for that. After a year my current highest db id is 5031, let's say 3000 people are in database when I don't have more than 120 people on server at one time. That's sad .

[eckart]

Workaround:
check your database/clients table, sort by client_lastconnect. The value is a normal timestamp.
Take the client id.
Now connect to the queryport (usefully by a script) and you can delete the clients.
(beware: the first id is the serveradmin!)