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.

[Gryphon]

Originally Posted by GaryT

Could this be adapted as easily for those using Ventrilo? There are hundreds if not thousands of gaming groups that use Ventrilo exclusively and would jump on an add on like this for their sites.

It is very specific to TeamSpeak, it would need a complete re-write. I am not a fan of Ventrilo nor have any personal need for such a project, which is what motivates me to create the mods that I do. I am afraid that someone else will have to fill the void.

Originally Posted by butler312

Would anyone happen to have a simple set of instructions for how to get teamspeak running on my vbulletins database. I have verified with my host that I can do so, but the instructions on teamspeak are just jibberish to me.

There shouldn't be any need for someone to duplicate here what has been addressed several times at http://www.teamspeak.com

Originally Posted by butler312

I did search, and I found some explanations, but they don't make any sense to me. It is telling me to do things that I simply have no idea how to do. It gives me commands to use that give me error messages when I try them. It just simply does me no good.

This mod release is independent from setting up a server. The best place for getting your questions answered will be on the TeamSpeak forums where it is much more likely someone will have the answers.

[LittleB@]

Hi G, I know you only provide limited support but figured you might have run into the same problem yourself and I was hoping you had a solution.

Thing is when I upgraded my vB to the latest 3.7.3 PL1 I was not able to log in to the forums, all I got was this:

Fatal error: Maximum execution time of 120 seconds exceeded in /**/forum/includes/class_cyts.php on line 1953

I then proceeded with disabling all my plugins to track down the problem and found out that I can have all my plugins activated except your gTeamspeak, would you say this is something that happened only to me or did you have the same problem when you upgraded your forums? (if you did upgrade).

Thnx for any help and above all, for this wonderful mod

*Edit*

Seems I am blaming the wrong person here, sorry It turned out that during my recent server migration the mysql addresses in my database were the only thing the support team forgot to change hence the plug-in here tried to connect to the old database server with obvious failure

this rendered me unable to view any page that had gTeamspeak code executed (for example my private forums where I can see whos online on TS atm)

To perhaps help you in maintaining this plug-in perhaps you could look into a way of reporting this error to the user before he finds himself in some mysterious and endless loop? Im no php/mysql programmer but just to give you a hint that the problem can arise and if so you might want to see some kind of message, hope this helps

and thnx again for this plug-in, I love it =)

[Insanity.TM]

Datenbankfehler in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM ts2_clients WHERE s_client_name = 'nubyel.1' AND i_client_server_id = '152';

MySQL-Fehler : Table 'db252288009.ts2_clients' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Tuesday, 23.09.2008 @ 18:53:53
Datum : Tuesday, 23.09.2008 @ 18:53:54
Skript : http://www.fallen-angels-ambossar.de/gteamspeak.php
Referrer : http://www.fallen-angels-ambossar.de/index.php
IP-Adresse : 85.182.9.80
Benutzername : Nubyel?
Klassenname : vB_Database
MySQL-Version : 5.0.51a-log

this ist my error,...

[Gryphon]

Originally Posted by Insanity.TM

Datenbankfehler in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM ts2_clients WHERE s_client_name = 'nubyel.1' AND i_client_server_id = '152';

MySQL-Fehler : Table 'db252288009.ts2_clients' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Tuesday, 23.09.2008 @ 18:53:53
Datum : Tuesday, 23.09.2008 @ 18:53:54
Skript : http://www.fallen-angels-ambossar.de/gteamspeak.php
Referrer : http://www.fallen-angels-ambossar.de/index.php
IP-Adresse : 85.182.9.80
Benutzername : Nubyel?
Klassenname : vB_Database
MySQL-Version : 5.0.51a-log

this ist my error,...

You have not setup your TeamSpeak database properly.

[Hamednet]

thanks dear

very nice !

[jluerken]

Hey Gryphon,

its me again :-)
I am using vB 3.7.3pl1 at the moment with the actual version of your addon and have a strange bug.
I am using your hack on two forums with two own teamspeakservers which use the same teamspeak database.
Everything was working for month but today I got a strange error.
People in the database got the passwords from other people in the db.
So far I could not find out how this happened.
Do you have any idea how I can get the correct password again connected to the correct usernames?

[jluerken]

No idea how this happened so far. I can only imagine one of the vbulletin maintenance functions but I don't think that I am right there.

Gryphon I need a db query to do the following:
Delete all passwords from table ts_clients, field s_client_password and b_client_privilege_serveradmin is not -1 and i_client_server_id is 0

Can you help me with this please?

[zoomgod]

I have used this before and it installed easy and worked great on 3.7.3.

Now I brought up another site for a clan also using 3.7.3, problem is when I click on options, who's online or advanced options nothing is there so I can't configure it, anybody have any ideas?

I've re-installed it like 3 times now.

[BucWiLd]

i wish i would be able to install this but i see it is wayyyy to difficult..lol

[Gryphon]

Originally Posted by jluerken

People in the database got the passwords from other people in the db.

The TeamSpeak account is associated to vBulletin accounts by vBulletin userid. Bob with userid 35 on forum 1 and Jim with userid 35 on forum 2 are going to conflict. There is no way around this at the moment with the way the mod is designed.

Originally Posted by jluerken

Gryphon I need a db query to do the following:
Delete all passwords from table ts_clients, field s_client_password and b_client_privilege_serveradmin is not -1 and i_client_server_id is 0

Can you help me with this please?

Untested and off the top of my head: DELETE `s_client_password` FROM `ts_clients` WHERE `i_client_server_id` = '0' AND `b_client_privilege_serveradmin` != '-1';

Make a backup, I am not positive.

@zoomgod make sure the TeamSpeak server telnet ports are open.