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.

[zoomgod]

Are you referring to the TCPQuery port or the HHTP port? Either way both and accessible from my PC to the TS server.

Just to clarify the problem, It is step 5 of installing, there is only a blank page for configuration no way to fill in server info. Something seems to be failing on install

EDIT: NM, I just discovered I can set it under vBulletin options, would still be nice if options under gTeamspeak worked though.

[thomaskant]

Hello,

my English is not so good.

I get the MOD not to run. Server.log:
17-05-08 21:59:00, ALL, Info, server, server init initialized
17-05-08 21:59:00, ALL, Info, server, the server version: Linux 2.0.23.19
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_servers
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_server_privileges
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_channels
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_channel_privileges
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_clients
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_bans
17-05-08 21:59:00, ALL, Info, server, Starting virtual server id: 1 with port: 8767
17-05-08 21:59:00, ALL, Info, server, virtual server Started id: 1 with port: 8767
17-05-08 21:59:00, WARNING, Info, SERVER, default virtual server created
17-05-08 21:59:00, WARNING, Info, SERVER, admin account info: username: admin password: XXXXXX
17-05-08 21:59:00, WARNING, Info, SERVER, super admin account info: username: super admin password: XXXXX
17-05-08 21:59:06, ALL, Info, server, server finished init
17-05-08 21:59:06, WARNING, Info, server, Teamspeak server daemon activated
17-05-08 22:32:45, ALL, Info, server, server shutdown initialized
17-05-08 22:32:45, ALL, Info, server, virtual server Stopping id: 1 with port: 8767
17-05-08 22:32:46, ALL, Info, server, Virtual Server Stopped id: 1 with port: 8767
17-05-08 22:32:48, ALL, Info, server, server shutdown finished

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=XXX
Hostname=localhost
User_name=XXX
Password=XXXX
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1
***********
Mysql 5

My TS IP: 87.106.94.90:7777

I ask for help if possible in German.

MFG thank Thomas

[Gryphon]

@zoomgod Sorry, I see what you mean now. I did not understand before. I am not sure why those option links are not working. I will look into it, it appears that vBulletin changed something in their nav menu system that is breaking the links.

[ViperMaul]

Hi Grypon,

This has been a great tool for us for many months now.
However, we have started receiving the following error when we click on
Manage Users from the gTeamSpeak section of the admin Control Panel if you wait for a very long time...

Database error in vBulletin 3.7.1:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110
/home/theatreo/public_html/devforums/includes/class_core.php on line 311

MySQL Error   : 
Error Number  : 0
Request Date  : Friday, November 14th 2008 @ 12:39:17 PM
Error Date    : Friday, November 14th 2008 @ 12:43:47 PM
Script        : http://www.theatre-of-war.com/devforums/admincp/gteamspeak.php?do=manageusers
Referrer      : http://www.theatre-of-war.com/devforums/admincp/index.php?do=nav
IP Address    : {masked}
Username      : {7}Maj.ViperMaul
Classname     : vB_Database
MySQL Version : 5.0.51a-community-log

Do you have any ideas on how to trouble shoot this?
I need a super hero to help me solve this.
Its probably my server host. We shall see.

[zoomgod]

Thanks for fixing the navigation, works great now!
I'm sure that will help avoid some others being confused lol

[Scathefire]

just curious, do you have plans on updating this for teamspeak 3 when it (finally) arrives?

[Shawn385]

Seems TS doesn't like working with libmysqlclient_r15.0.0...dang would love to use this but it wont start the server for me.

After reading a TON of these errors in other forums I finally got the TS to work with MYSQL, but now it wont let me login in backend as the admin. It lets me in a superadmin but when I go to edit a server ( name and so forth ) it tells me my server is invalid.

[fgforty2`]

Originally Posted by Scathefire

just curious, do you have plans on updating this for teamspeak 3 when it (finally) arrives?

I'm hoping he does. It looks like there will be a bit more MySQL support for 3. I want to install this mod but library issue thing is a turn off.

[Gryphon]

Yes, though it will most likely be a complete rewrite.

[Sanjiyan]

Hi there, I am running VB 3.7.2, with TS in mysql, the mysql database for TS, is hosted on the same mysql server, but in a different database than vBulletin

As such, it doesnt work.

I do not have any graphics on the TS register screen, it says:
User Name: ranko.1
Password:
Not encrypted, do not use your forum password.

Enter the password, press Go it refreshes and nothing else. (there is no graphic on the screen), even if its in the style image misc folder.

-----

Now on the admincp side of it, it is setup.
Please see attachments, as they better explain it I think (I've enabled the debug information).

So, image1 shows the manage users, as you can see theres an error displayed this I think is the root cause of my entire problem.

Image5, lists the remote database, now I can remotely access the MySQL database server using Navicat, the user for the TS database itself allows remote access etc.

As you can see from all the screenshots they all display the same error type:

Array
(
[0] => Array
(
[cmd] =>
[rpl] => [TS]

)

[1] => Array
(
[cmd] => SEL 8767
[rpl] => OK

)

[2] => Array
(
[cmd] => SLOGIN
[rpl] => ERROR, invalid paramcount

)

)

My server details:

CentOS 5.2
Apache 2
MySQL 5.0.45
PHP 5.2.6
TS 2 (latest build from goteamspeak)