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.


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:
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.

wow! nice addition anychance it will be getting whos online on forum home?

There is already a pretty good one available here. I may create similar functionality, but I have a few other ideas in mind I want to work on to :D

Question: I have teamspeak installed myself on my own webserver... (not located on my pc)...

I just run the install script that comes with the linux server package... now how would I make it use a specfic MySQL Database... ?

I believe a deeper explanation and instruction set will allow more people to install this.

But thanks a lot...its a great product and I will be installing this... just as soon as I learn how to do it correctly.

- SKNY

Wait nevermind.. I didn't look at the pictures..

From what I believe.. I just install the server the regular way and then provide the product the details to my sever and it logins and does everything it self?

Is that correct?

- SKNY

I have updated the instructions with information on how to make TeamSpeak use a mySQL server.

Now that helps a lot more...

Thank you, I will be probably install this this week or next.. will let you know how it goes.

Thanks

- SKNY

What about an addition?

1. Ban users on Teamspeak automatically if they're in the vB Banned Users Group
2. Delete Teamspeak account if the vBulletin account is deleted
(except for SAs)
3. Add an additional page to show who's currently online
4. Stats page with:
How many users, channels, uptime etc.
5. Form to request a Channel or Channelchange


Questions:
1. Can also a secondary group make users automatically SA or only primary?
2. What about adding an option to sync the userdbs?
Currently I have >2200 vBulletin Members. It would be nice if they don't need to create a new account but if they can directly logon to the ts with their vB login. Is this possible?
3. Is the login page fully phrased?

Thanks for the great hack such as this one!

1. Currently working on that.
2. Working on that.
3. Working on that.
4. Working on that.
5. Will look into that.

1. I believe it will work for secondary groups, I haven't explicitly tested that, I believe it should work.
2. Not possible, vBulletin user passwords are not only encrypted but additional measures are tossed into the encryption and TeamSpeak is plain text.
3. It is not currently fully phrased.

Great hack. I allready have something like this coded at fusionclan.com, but this seems to be far better. I was planning to release mine, but you obviously beat me too it :).

Thanks, I developed it a while ago as a non-vB feature on one of my sites and decided to convert it into my first vB product.

Hey mate I keep getting this error on the teamspeak.php page

and in admincp/vbteamspeak.php i get this error

On the first error, are you accessing a remote database for TeamSpeak or is TeamSpeak sharing your vBulletin DB?

For the second, that is my fault I will fix the error, however the error is happening because you do not have your User ID in the config file under super admins. I will look into a way to improve that.

Hi Blackjack, I installed your hack and while creating an account I get this error

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO teamspeak2.ts2_forum_account SET ts2_client = '386', userid = '3', username = 'CFN|LordSoth';

MySQL Error : Table 'teamspeak2.ts2_forum_account' doesn't exist
Error Number : 1146
Date : Sunday, August 6th 2006 @ 12:01:44 AM
Classname : vb_database

Can you help please?

TS2 is running in a different db on the same server. Data is correct.

Did you do step 4 and create the table?

I have a new version in the works that will make that table not needed. I should have it available next week.

I made step 4 and now its working.

The picture on the right side is not showing up and I found something nice.
I had an admin and he created an ts account. He got SA as normal.
Now I made him a normal user but he has still SA on the TS Server.

There should be a job in the sheduled task area that checks such things.

Maybe you can keep this in mind for your next version :D

In the admincp I get the following error message:

go to line 30 in admincp/vbteamspeak.php

change:
rpm_print_stop_back("You don't have permission to access this page.");

to:
print_cp_no_permission();

cheers :)

This is not working rouven. It removes the error message but still my normal admins do not have access to this page.
It seems that only superadmins have that permission but normal admins not.

Currently only superadmins are allowed to access it, I have changed that in the next version.

For the image, put ts2/teamspeak_help.gif in the misc folder for any custom style you have.

For SA they need to drop/join for it to take effect, I can probably make the change take effect immediately, but it will only work if you have the tcp query port available, otherwise it is not possible.

Sounds like a really cool mod!

I've set everything up and put all of the sql database name, my login,pass all correctly, but it just doesn't seem to work. Any way I can manually add all the database tables needed in SQL? I know how to do that...just need to know what to add.

Thanks

Well, if the script isn't creating the tables, then it probably isn't connecting to the database. Are you sure your TeamSpeak database allows remote connection from your vBulletin server?

What do you mean by it just doesn't seem to work? Is there any particular error you get?

I'm probably not to familiar with this installation.

I have a web site hosted with a hosting company. I logged into my control panel and created a new database and database username/pass for added security. I then uploaded all of your files and filled out all of the information. Call me dumb...but do I have to have the TS Server installed on my server? If so, do I just upload the files that I executed on my computer to the webserver? Not sure how to install an .exe file on a server...never did that before.

Ya, you need to have a TeamSpeak server running, but that is a bit more than I want to support here. You can learn more about TeamSpeak at www.goteamspeak.com, however not a lot of hosts allow you to run applications on your server, you will have to find out from your host.

Hi Blackjack,

Thanks for an excellent hack. I run a forum and a teamspeak server on my own server hosted at a hosting company. I currently just run it under the default sqlite DB. When I add the part explained above to the server.ini file, I get an error as follows:

I have searched on the teamspeak forums, but all the results expects you to actually have that file on your server. I have none of the lbmysqlclient files on my server. Is there something I'm missing?

Thanks
Firestar

That is beyond what I want to support here, however, I believe there is something about using libmysqlclient from mySQL 3.xx you will have to find and install.

Thanks for the reply, Blackjack. I'll see if I can find it :)

Sorry family arrived and there are still a couple features I would like to implement before the next release.

Currently Ready:

• Plugins: People can write their own feature plugins for doing things like banning, kicking, messaging users etc...
• Users template is phrased.
• If you change a persons forum username, their TeamSpeak login name is changed with it.
• If you delete a forum account, their TeamSpeak account is deleted.
• Some code restructuring to make adding features and updates easier.
• Display who is online on forum home.

Still working on for next release:

• Hook forum banning (help?)
• Clean up the plugin feature, it is kind of ugly
• Product upgrade code

Future Release:

• Channel Management
• Other undetermined features :)

where can I download this to fedoracore4 ????

This is only a hack to integrate a running Teamspeak2 Server (mysql installation) into vBulletin.
You can get Teamspeak here http://www.goteamspeak.com

All your questions regarding teamspeak should be asked here http://forum.goteamspeak.com

Ok
but have you install this if can you give me link so I can se that bequse I´m very intressed off this

I have a server up and running on my computer. Ports 8767 UDP, 14534 TCP, 51234 TCP are all open. I am able to connect to the server as well as the members on my forum.

Under vBTeamSpeak options:
Server IP, port, etc.. are all set.

For Server Address..I used the same address as the Server IP, not defendingthetruth.com

Remote User Database is where I am confused...If the server is on my computer, could it be possible to set this up so it connects to my computer?? Eh...all confused

Are you running mySQL database on your computer? If so, yes as long as you give the proper permissions to allow your vBulletin server to communicate with your home computer. But I would imagine that if you were running your own mySQL server you would also know how to do this, so I am making a guess that you don't and this modification will not work with what you have setup.

As an update to the progress of the next version, I am having certain issues with some of the new features I have developed and I am still working on squashing these bugs before I release the next update.

Any chance to make a similar hack for Ventrilo? :)

We use Ventrilo for our WoW Guild, as it has better sound :)

Hope u can mate :D

is there any new version out? it still does not work for me, the user table is always empty...

just to get it as clear as possible...
which ports need to be opened for this to work, between the enduser with the browser, the webserver and the ts2 server. i thought it need to be only:

client => ts2 (ts2 port 8767)
webserver => ts2 14534 TCP, 51234 UDP

or does the client need 14534 TCP, 51234 UDP, too?

Unfortunately no, I hate Ventrilo personally ;)

None of the TeamSpeak ports need to be accessible. vBTeamSpeak will work as intended without any port access, all it needs is to be able to connect to your TeamSpeak's mySQL database.

Easiest setup (more common):
Host TeamSpeak on the server your vBulletin is on and change the server.ini to point to your vBulletin Database. Now that TeamSpeak is setup to use mySQL to store it's user data, vBTeamSpeak will insert new users directly into the database for TeamSpeak. No ports needed (though you can enable TeamSpeak ports for extra features but are not required).

Harder setup (less common and this is the way I use it):
Host TeamSpeak (AND mySQL) on a machine separate from your vBulletin install. Grant permissions on your mySQL server that will allow your vBulletin server to have access to it (authorized IP's). Fill in the Remote Database portion of the options. (Database Username and Password should be different than your vBulletin install, for some reason vBulletin doesn't like to connect if they are identical).

I hope that clears some things up. Basically if you don't know if your TeamSpeak is using mySQL or not, or if you are just hosting TeamSpeak on you home computer, using this addon may be beyond your technical knowledge.

Ok, same for me. ts and vb are on the same machine with a different db and a different user with rights for their own db. i filled up the remote database things and he is creating the ts2_forum_account, which seems to be empty regardless what i am doing.
does the ts2 db user need access rights to the vb db? it should not, or am i wrong. the problem is, that i am not seeing any ts2 users to manage and not seeing the full frontend view. very strange for me.
is there any debug=true switch? ;)

Just got around to using it and same problem as Rouven.

I have TeamSpeak and the forum installed on the same server, however TeamSpeak is just installed under a different domain, however the entire system uses the same MySQL Server. It looks like the system can connect to the TeamSpeak server database and it creates the table when I click “Create Table” and that’s about it.

All I see on the vbteamspeak.php page is the following...

Now when the user puts in the password and clicks GO; nothing happens.

Also I’m using PHP Version 5.1.2/MySQL 5.0.18, does that create an issue, also does this system have any special requirements?

Maybe I have the server configuration setup wrong... So maybe you should tell me if the following is correct.

Server IP: Is this the ip address we put in teamspeak or the ip address we enter to access webadmin.
Server Port: 8767 (default)
Query Port: 51234 (default)
Web Port: 14534 (default)
Server ID: Whatever the id is. (1 in my case)
Server Address: I’m guessing TS Server IP, the one we enter into TS.

So what exactly am I doing wrong?

Thanks

i am not alone :D