Hi, I want to move my Teamspeak to another server, last few times I’ve just moved sqlite.db file, and it worked, I have all rooms, icons, avatars etc backuped, but what I want to change is online time of all users on Teamspeak. Because I have bot that counts time of every user on Teamspeak and gives him verified permissions after 5 days online on server so he can poke or send PM. So I want to reset all of my users time to 0, but having all rooms, and icons still up
Download an sqlite editor and execute these two sql commands:
UPDATE clients SET client_totalconnections = 0, client_lastconnected = NULL
UPDATE client_properties SET value = <currentTimeStamp> WHERE ident == "client_created"
You have to reset <currentTimeStamp> with the int value of the unix time.
I really like this one:
https://sqlitebrowser.org/
Keep in mind TeamSpeak does not support this officially.
Also here you can find the current unix time:
Maybe you should also create a backup before tinkering with the database.
1 Like
Absolutely you should 
1 Like
Well I’ll try and I’ll see how it goes. I have almost 200 daily users so I really don’t want to fuck anything haha. But thats the only way to do it so will give it a try
