Ts3 mysql db connect

[OvO]

Hello Community,
is there a way to connect to the teamspeak server database via for example HeidiSql or Navicat ?

Best Regards.

 

[kalle]

HeidiSql or Navicat

TS3 is using sqlite for DB. You can use something like https://sqlitebrowser.org/dl/

 

[OvO]

TS3 is using sqlite for DB. You can use something like https://sqlitebrowser.org/dl/

Ok nice! But it is possible to execute sql queries via php ?

 

[Asphyxia]

Ok nice! But it is possible to execute sql queries via php ?

Can you give me an example of what type of queries you're looking to execute or what overall task you are wanting to accomplish so I can better direct an appropriate response?

 

[OvO]

Can you give me an example of what type of queries you're looking to execute or what overall task you are wanting to accomplish so I can better direct an appropriate response?

So i want to for example insert and remove bans via php with sql queries

 

[Asphyxia]

So i want to for example insert and remove bans via php with sql queries

Just out of curiosity, why would you do this with SQL queries when you could do this with the server query via banclient?

 

[kalle]

Just out of curiosity, why would you do this with SQL queries when you could do this with the server query via banclient?

I agree with you. Its not wise to edit db from 3rd party, rather use TS3 php framework to make that functionality over server query.

 

[OvO]

I will try to make an GLOBAL ban list for two different servers like if one user banned on one server he is automaticaly banned on the other server its like i sad „ban list sync“

 

[Asphyxia]

if one user banned on one server he is automaticaly banned on the other server

How do you want this done? Via client IP address or user identity?

 

[Alligatoras]

How do you want this done? Via client IP address or user identity?

Don't forget the 3rd ban type "myteamspeak id".
From version 3.5.1 when you ban someone his ts uid, ip and myts id get banned too.

 

[OvO]

How do you want this done? Via client IP address or user identity?

If i ban on the first server one guy via my Webinterface it will execute the ban on the other server at the same time or if its possible to get the banlist data via sql to insert the bans or sync then that all servers have the same banlist.

I dont know if its possible to ban all three data

 

[Alligatoras]

I dont know if its possible to ban all three data

i don't know how to do this exactly but i can answer this question. When you ban something all these data get banned together.

 

[kalle]

If i ban on the first server one guy via my Webinterface it will execute the ban on the other server at the same time or if its possible to get the banlist data via sql to insert the bans or sync then that all servers have the same banlist.

I dont know if its possible to ban all three data

Yes u can. But you will need to modify a little bit script.
To make ban on all servers, parse trough all virtual servers and add ban to the list.
Also you can display bans from all servers, but if you have same bans exclude them from list.