Integration with vBulletin - gTeamSpeak - TeamSpeak User Management

What is it?
[hr]-[/hr]gTeamSpeak* is a addon for vBulletin which allows your choice of usergroups to register for a TeamSpeak server. It creates a system in which you can link TeamSpeak users to a forum user accounts.

If you use this mod, please Mark as Installed, and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!

You can find more information about TeamSpeak at http://www.teamspeak.com. You should have good knowledge about running your own TeamSpeak server prior to using the mod.

* gTeamSpeak was previously known as vBTeamSpeak.

Follow me on twitter!

Support
[hr]value[/hr]I use my released mods daily, if I find an issue with them or add features for myself I will release updates. If there are significant bugs or simple feature requests I will do my best to release fixes. Some of my mods rely on fetching data from 3rd party websites, due to the unreliable results, my mods will require users to troubleshoot for themselves if they find the addon is not working for them specifically. I am offering my personal mods that work ok for me for you to use, I am sorry I do not have time to troubleshoot many user specific issues. Thank you for your understanding.

Features
[hr]-[/hr]

• Optionally connect to a remote TeamSpeak database you have administrative control over if TeamSpeak is not hosted on the same db as your vBulletin.
• Optionally automatically add links to navbar and quick launch menu.
• Choose what usergroups get SA by default.
• Choose what usergroups can access the sign up form.
• Limit access by days registered.
• Limit access by user post count.
• Promote/Demote SA.
• Delete user accounts.
• Ban users from creating accounts.
• Send broadcast message to server.
• Send text message to a user.
• Prune inactive users.
• Display who is online on forum home.
• Cron checks vBulletin ban list every 10 minutes and bans users from TeamSpeak accordingly.
• Plugins: People can write their own feature plugins for doing things like banning, kicking, messaging users etc...

Support
[hr]-[/hr]
I will offer limited setup/installation support this script. While I do use the Remote Server option personally, I will not support this feature, you should have advanced knowledge of your server setup and troubleshoot this yourself. If you have purchased TeamSpeak hosting from a voice comm service provider, it is highly unlikely they will grant you database access. For best results and performance, have your TeamSpeak server use your vBulletin database as it's database.

1. Setup TeamSpeak to use mySQL
[hr]-[/hr]By default TeamSpeak uses a file system called SQLite. To make it use a mySQL database edit the server.ini and add:

[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 http://www.teamspeak.com.

2. gTeamSpeak Installation
[hr]-[/hr]

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:
     • yes
     • 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
[hr]-[/hr]
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.

Changes
[hr]-[/hr]
v3.31 - Upload files, Import product with Overwrite enabled

• Fix Admin CP nav
• Fix Whois online display

v3.29 - Upload files, Import product with Overwrite enabled

• Non-essential style tweaks.

v3.27 - Import product with Overwrite enabled

• Fix template cache

v3.24 - Import product with Overwrite enabled. Upload gteamspeak.php

• Navbar links now use $template_hook introduced with vBulletin 3.6.6
• Added option to limit access by days registered.
• Added option to limit access by user post count.

v3.22 - Import product with Overwrite enabled.

• Fixed typo in product file.
• Release German translation by Trantor.

v3.21 - Import product with Overwrite enabled.

• Fixed potential XSS vulnerability. Thanks Apophis.

v3.20 - Upload all files, import product with Overwrite enabled.

• Fixed an error with enable/disable plugins.
• Added option to display who's online on TeamSpeak signup form.

v3.10 - Upload all files, import product with Overwrite enabled.

• Cron created to check for banned users and remove their TeamSpeak account.
• Fixed some query statements.

v3.00 - v2.00 users no need to upgrade if you do not wish. If you do, vBTeamSpeak needs to be un-installed, and then follow fresh installation instructions. Your existing TeamSpeak user database will stay intact.

• Initial Re-Release.
• vBTeamSpeak re-branded gTeamSpeak.
• Code clean up.
• User Profile field now needs to be created manually.
• Added a couple phrases.
• Change templates slightly.

Hooks
[hr]-[/hr]

• I will consider hook requests.

Copyright
[hr]-[/hr]gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

[vbreal]

going to try this out

[sys4096]

apologies if this is staring me in the face or should be obvious, but what are the files I edit to give my users a nice display when they click on the vbteamspeak link to join the server?

They see the help picture and about half of the instructions, but I would like to have something like "welcome to my teamspeak server, rules are" etc similar to the example picture at the top of this thread.

Fantastic mod, much appreciated.
---------------------------------------------------------------------------------------

found the answer - instructions were only half complete because I hadn't done the second install. Alterations made in phrases.

Love this mod makes life so much simpler.

[frick]

Hello,

I have followed the instructions exactly and have had this working before with earlier versions, but cant get it to work with version 2.00.

Here is the error i get:

Database error in vBulletin 3.6.3:

Invalid SQL:
INSERT INTO vb_setting VALUES ('vbts_client_name', '0', '', 100, 'ts2_group_setting', '0', 0, 1, 'vBTeamSpeak_setting', 'free', 0, '');;

MySQL Error  : Duplicate entry 'vbts_client_name' for key 1
Error Number : 1062
Date         : Monday, November 20th 2006 @ 05:15:54 PM
Script       : http://www.xxxxxx.com/forums/vbteamspeak.php
Referrer     : 
IP Address   : xx.xx.xx.xx
Username     : xxxx
Classname    : vb_database

After I install it initially works the first time I go to the vbteamspeak page, but I get the error every time after. I made sure to delete all the teamspeak and other custom user profile fields, but can not get this to work. Any help would be apprecieated. Thanks!

[jluerken]

This hack is working perfectly, thanks man

Here a video tutorial for user in german
http://www.clanforums.com/forum/cms/...s2_german.html
and english
http://www.clanforums.com/forum/cms/...2_english.html

[FSFwebmaster]

I know the plugin deletes users upon deletion from the forums, but I'm finding that it doesn't delete users when you change there user group to a group that doesn't have TS access and have to manually go in and remove them.

Our gaming squad runs our forums and ts on a membership basis. We were hoping this plugin would automatically revoke TS access when there user group was changed to one that doesn't have TS access.

Is it possible to create a routine to add to the cron jobs area to look for user group changes and delete demoted users or something similar thats automated?

[Logo]

Originally Posted by frick

Hello,

I have followed the instructions exactly and have had this working before with earlier versions, but cant get it to work with version 2.00.

Here is the error i get:

Database error in vBulletin 3.6.3:

Invalid SQL:
INSERT INTO vb_setting VALUES ('vbts_client_name', '0', '', 100, 'ts2_group_setting', '0', 0, 1, 'vBTeamSpeak_setting', 'free', 0, '');;

MySQL Error  : Duplicate entry 'vbts_client_name' for key 1
Error Number : 1062
Date         : Monday, November 20th 2006 @ 05:15:54 PM
Script       : http://www.xxxxxx.com/forums/vbteamspeak.php
Referrer     : 
IP Address   : xx.xx.xx.xx
Username     : xxxx
Classname    : vb_database

After I install it initially works the first time I go to the vbteamspeak page, but I get the error every time after. I made sure to delete all the teamspeak and other custom user profile fields, but can not get this to work. Any help would be apprecieated. Thanks!

i have the same problem.... anyone can help us ?

[storpappa]

This looks like an excellent addition, but it seems to be tailored for a single TS server. Has anyone modified it to work across multiple servers or multiple server ports on a single server?

[dooch]

Originally Posted by Logo

i have the same problem.... anyone can help us ?

yes i have the same problem....

EDIT

Ok im getting to grips with this, its a nightmare to get going but the mysql errors are due to my webhost not allowing connection to the remote mysql server which TS is on.

My TS is on windows, my webhost is Linux so problems...

EDIT

One major problem which was giving me the mysql errors was "root" only had local host connections allowed!

So nearly there!!!!!

EDIT

Ok after wasting a day on this i still have a problem

I can register ONE person using this sytem, anymore and I get this error

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO ts.ts2_clients SET i_client_server_id = '1', b_client_privilege_serveradmin = '-1', s_client_name = 'admin.2', s_client_password='whatever', dt_client_created='03012007003238000';

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Wednesday, January 3rd 2007 @ 12:32:38 AM
Script : http://www.xxxxxxxx/forum/vbteamspeak.php
Referrer : http://www.xxxxxxx/forum/vbteamspeak.php
IP Address : xxxxxxx.251
Username : admin
Classname : vb_database

Any ideas??

Many Thanks!

EDIT

SOLUTION - GOT IT WORKING

Ok for the ppl out there that are trying to get this working with a LINUX webserver "virtual" host and a M$ dedicated box with TS here's how.

Delete all previous TS and start a fresh install of TS.
Run TS, make a note of the new SA and A passwords.
Close TS.
Add the two attached files to the TS directory (libmysql.dll and dbexpmda.dll)
Edit the server ini and add the following to the the bottom

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=yourdatabasename
Hostname=localhost
User_name=root
Password=yourpasswordhere
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1

Then copy all the files from sqlite_sql to mysql_sql. When it says overwrite say NO, so its just the new files.

There is a handy program found on the goteamspeak forums to check your connection settings to the database. I used this program to add a few more users to check it was working. Refer to your mysql db to see if theyre being added.

If youre using xampp for the local mysql databse ensure root has all priv's and NOT just on local, change it to %.

Launch TS and check the server log to look for any errors. It should come back fine.

Then install the product etc.

Ensure you complete the options and the advanced options.

Job done.

This has taken me some serious handbanging but its an excellent product so was worth the headache and the 600 cigs i smoked!

INSTALLED

THANKS

[dooch]

just to let you know the dll is only a 30 day tiral so its not a fix... unless u wanna pay $70 which i dont for a poxy dll.

[Spank]

If I install this hack, does teamspeak run from my host or from teamspeak? or to put it another way, will it use all my bandwidth?

Thanks =D