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.

[xTerMn8R]

I'm Running Windows XP Pro, Vbulletin 3.5.4 MySQLv.4.0.18 PHP v.4.3.8

Tried installing this and have had little luck... tooks 4 hrs to finally get MySQL to work with TS ... Had to use a library written for Mysql 3.x and that wasnt easy to find for me. Lots of Post all about it but no one provided the file... finally found the right one on a dllfile download page... OK Back to the install,

When I try and "Install the Product" I get the following error in my Product import CP and a Yellow |||||||||| goes across my screen forever...

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
	(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
	('1', '5', 'gTS: Cache', 'cache_templates', '$globaltemplates[] = \'gts_vbnav_quicklink\';\r\n$globaltemplates[] = \'gts_vbnav_navbarlink\';\r\n$globaltemplates[] = \'gts_whos_online\';', 'gTeamSpeak');

MySQL Error  : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date         : Thursday, June 28th 2007 @ 07:37:06 PM
Script       : http://www.superskunkracing.org/admincp/plugin.php
Referrer     : http://www.superskunkracing.org/admincp/plugin.php?do=productadd
IP Address   : 192.168.1.1
Username     : xTerMn8R
Classname    : vb_database

I have no idea where and why its getting the 192.168.1.1 addy from (of course that My Routers Lan Addy) and I've checked the TS server and MySQL Operation and thats just as ya said it should be. Table entries are all correct and TS is workin fine. I'm doing this install right on the Server (Local) so it shouldnt even have to look at the router. and help would sure be appreciated....

[xTerMn8R]

Here's the libmysql.dll file that caused me to waste so much time. Hopefully this will save someone a lot of aggravation...

**Note** After getting TS and MySQL to work together and I relaxed a bit and went back and read EVERY POST in this thread I see someone DID provide the files I had such a hard time finding... ,

Still need help for that Error I Posted above please....

Thumbs up to Dooch for making them available...


Fixed by finding this great little product that adds the fix. BIG BIG Thumbs up Quarterbore :up:

Here's the link to the

Fix for the executionorder ERROR

[xTerMn8R]

Well most of it is working I got the Admin Menu Sheets and templates and it functions on the pages, but it wont let me add the plugins, from either VB's plugin manager or the one in the gteamspeak menu.

Fatal error: Cannot instantiate non-existent class: vb_xml_parser in E:\rFactor\includes\functions_gteamspeak.php on line 364

During lasts night research someone, somewhere said I needed the php_xml.dll extension in PHP enabled in the php.ini but I dont have the entry or the actual file in my php.ini, or extensions folder and cant find it anywhere on the net. I also read to use the php_xmldom.php but that wont load for me and when I look at the class_xml.php it has a reference to the php_xml.dll file as well.

Anyone got any Ideas whats going on here and how I can fix it?

Thanks ...

Oh One more thing, it adds a .# to the chosen username after a user Joins my TS from the homepage.

eg. xTerMn8R=xtermn8r.1 , Termi=termi.104 ???? Whats with that?

[Gryphon]

You definitely won't be able to install the plugins via vB plugin manager. They are only meant to be installed from the vBTeamSpeak admin section. I am not sure why they are not installing ok for you. They should work just like installing a vBulletin plugin, it uses all vB functions.

The .# is their forum id, it is how it associates TeamSpeak logins with forum accounts and assures unique login names.

[xTerMn8R]

Ok I see the .# doesnt show in the TS so thats not really and issue but I still cant import the plugins... They just sit there pumping out those Yellow status bars forever. I've rednloaded them just in case they were corupted but no go. Are they dependent on the Tables that were created in Database. Maybe My tables arent right ? I dont know I'm stumped and tired. Thanks for your reply I appreciate it

Peace...

Oh BTW no More Fatal error: Cannot instantiate non-existent class: vb_xml_parser in E:\rFactor\includes\functions_gteamspeak.php on line 364 errors but the plugins still dont load. I assume they should load rather quickly. Am I not wainting long enough? I waited about 2 or 3 minutes, ya know I shut off error reporting in php.ini thats probably why I dont see theXML Parsing error. So thats where the problem is bro I dont have any idea how to fix it... vb_xml_parser

[silral]

Sorry, my english is not good...
I have This Error:

Datenbankfehler in vBulletin 3.6.7:

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

MySQL-Fehler : Tabelle 'vbulli.ts2_clients' existiert nicht
Fehler-Nr.   : 1146
Datum        : Saturday, July 7th 2007 @ 07:38:38 AM
Skript       : http://www.silral.net/forum/gteamspeak.php
Referrer     : http://www.silral.net/forum/index.php
IP-Adresse   : 77.180.154.162
Benutzername : silral
Klassenname  : vb_database

who can help me thereby?

[Logo]

die Tabelle 'vbulli.ts2_clients' existiert nicht in der Datenbank das is der Fehler

[silral]

Das weiss ich auch, aber in der Installation ist diese auch nicht angegeben.
Wenn jemand diese tabelle zur Verfügung stellen könnte, wäre ich sehr dankbar.

[jluerken]

Originally Posted by silral

Das weiss ich auch, aber in der Installation ist diese auch nicht angegeben.
Wenn jemand diese tabelle zur Verf?gung stellen k?nnte, w?re ich sehr dankbar.

Nat?rlich ist sie das nicht denn sie geh?rt nicht zu diesem Hack sondern zur TS2 MySQL Installation.

[silral]

und jetzt noch den Link daf?r, das w?re die Vollendung..
Ich hab das ganze Board durchsucht, aber nichts f?r meine Version (3.67) finden k?nnen.