1. Setup TeamSpeak to use mySQL
By default TeamSpeak uses a file system called SQLite. To make it use a mySQL database edit the server.ini and add:
Quote:
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=database_name
Hostname=localhost
User_name=database_username
Password=database_password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1
When you start the server it will create all the necessary tables:
* ts2_bans
* ts2_channels
* ts2_channel_privileges
* ts2_clients
* ts2_servers
* ts2_server_privileges
Make sure these tables exist and that your TeamSpeak server is actively using your mySQL database properly before even downloading the gTeamSpeak modification.
For more information about setting TeamSpeak up to use a mySQL database visit
TeamSpeak - Welcome to TeamSpeak.
2. gTeamSpeak Installation
1. Make sure that your TeamSpeak server is setup to use a mySQL database prior to installing this product. For best results prevent users and admins ability to register with the server via client. Also password the server to something gibberish as you will not be supplying the password to anyone. Also disable the ability for SA to grant SA for security.
2. Upload all files prior to installing product.
3. Install the product.
4. Create a Single-Selection Menu User Profile Field.
* /admincp/?loc=profilefield.php%3Fdo%3Dadd
* Single-Selection Menu
* Continue
* Title: TeamSpeak Access
* Description: Can register self with TeamSpeak server.
* Options:
o yes
o no
* Set Default: Yes, but No First Blank Option
* Field Required: No
* Field Editable by User: No
* Private Field: Yes
* Field Searchable on Members List: No
* Show on Members List: No
* Save
* Look and see what the field name is for TeamSpeak Access, example field25.
5. Fill in the gTeamSpeak configuration options.
6. Install any plugins you wish to use from the /admincp/gtsplugin directory.
7. That is all, send people to the form to sign up.
Note: You need to add your user id to the config.php under superadministrators. I will attempt to remove the need to require this in a future version.
TeamSpeak Access Profile Field Usage
This is used if you want to ban a user from TeamSpeak and do not want to ban them entirely from the forums or change their usergroup.
* Set this profile option to No to prevent a user from creating a TeamSpeak account.
* When a user is banned from the gTeamSpeak user management, this option is automatically set to No. If you wish to unban them, set this option to Yes and they will be able to create a TeamSpeak account again.