Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
gTeamSpeak - TeamSpeak User Management Details »
gTeamSpeak - TeamSpeak User Management
Mod Version: 3.31, by Gryphon (Coder) Gryphon is offline
Developer Last Online: May 2017 I like it Show Printable Version Email this Page

vB Version: 3.7.x Rating: (18 votes - 4.33 average) Installs: 182
Released: 26 Jul 2006 Last Update: 30 Oct 2008 Downloads: 1750
Not Supported DB Changes Uses Plugins Template Edits Auto-Template Additional Files External Content  

What is it?

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

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

  • 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


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

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

  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


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


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

  • I will consider hook requests.

Copyright

gTeamSpeak, Copyright © Ryan Snook (www.gryphonllc.com)
Please do not redistribute this script without my consent. While updates may not be made to this product regularly, I still maintain it. If you have fixes, improvements or other additions to make to this mod, please contact me at rsnook@gmail.com for collaboration. I appreciate your consideration.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	usercp.1.gif
Views:	6753
Size:	61.6 KB
ID:	51081   Click image for larger version

Name:	gts_options_1.jpg
Views:	2482
Size:	66.3 KB
ID:	61467   Click image for larger version

Name:	gts_options_2.jpg
Views:	1222
Size:	68.0 KB
ID:	61468   Click image for larger version

Name:	gts_options_3.jpg
Views:	1101
Size:	41.8 KB
ID:	61469  

Click image for larger version

Name:	gts_user_management.jpg
Views:	3171
Size:	231.8 KB
ID:	61470   Click image for larger version

Name:	gts_plugin_management.jpg
Views:	2128
Size:	44.2 KB
ID:	61471  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Administrative and Maintenance Tools Un-Activated User Management 3.1 sabret00the vBulletin 3.8 Add-ons 215 18 Nov 2012 09:33
Un-Activated User Management sabret00the vBulletin 3.0 Full Releases 204 02 Feb 2007 17:52

  #151  
Old 07 Jul 2007, 13:37
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Originally Posted by silral View Post
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.
Na da es was mit Teamspeak zu tun hat, solltest du auch besser nicht hier suchen sondern im Teamspeak board
http://forum.goteamspeak.com/
__________________
Ciao jluerken
Reply With Quote
  #152  
Old 08 Jul 2007, 02:43
Dr.NoTime Dr.NoTime is offline
 
Join Date: Nov 2006
Real name: Rob
Very nice. Finally got the install done.

One small problem, maybe someone can help. If I enable the super admin feature, my forum will lock up and I get an error 500 internal server error. I am guessing it has to do with port 51234 being denied by my provider, but I was hoping for some confirmation by someone who is who is far more experienced before contacting them.

Thanks,
Rob
Reply With Quote
  #153  
Old 08 Jul 2007, 07:09
RogerChristie RogerChristie is offline
 
Join Date: Jul 2007
Unhappy GTeamspeak: Can't replace remote IP with localhost now

I set gTeamspeak up to use a remote database, then realised I could host it on the Linux box I had SSH access to. When I went to change the settings to using the local database, it said the changes were made successfully but when I try to access the gteamspeak.php file, I get this:

---------------------------------------------------------------------------------------------------------------
Database error in vBulletin 3.6.7:

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

MySQL Error : Table 'thcministryforum.ts2_clients' doesn't exist
Error Number : 1146
Date : Sunday, July 8th 2007 @ 12:03:14 AM
Script : http://www.thc-ministry.org/forum/gteamspeak.php
Referrer :
IP Address : 66.75.110.135
Username : SacredPlanter
Classname : vB_Database
-----------------------------------------------------------------------------------------------------------------

I can blank out the info in all the fields in GTeamspeak Options, and Advanced Options (set to "No" to use localhost instead of remote database) and it seems to save the data but when I log in apparently it isn't writing the new data to the database. I've searched all over my database and can't even find where it's writing the 66.75.110.135 addy and I also don't see it in any of the files I uploaded for the package itself. I've tried uninstalling and reinstalling the whole package, using 'Overwrite' with zero success.

Please help!:
Reply With Quote
  #154  
Old 08 Jul 2007, 18:16
silral silral is offline
 
Join Date: Jun 2007
Originally Posted by jluerken View Post
Na da es was mit Teamspeak zu tun hat, solltest du auch besser nicht hier suchen sondern im Teamspeak board
http://forum.goteamspeak.com/
was ich prompt auch tat, leider ebenso ohne Erfolg wie hier.

Ich denke auch nicht, das es an dem Teamspeaker selbst liegt, sondern an dem Modul hier, denn dieses sollte doch alle DB Tables installieren, welche benötigt werden, oder liege ich da falsch?

Ich hatte bis vor kurzem ein WBB Forum, wo das alles reibungslos lief.
Na ja, wie auch immer, ich werde weiter suchen und selbst probieren. Danke.
Reply With Quote
  #155  
Old 09 Jul 2007, 21:24
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Originally Posted by Dr.NoTime View Post
If I enable the super admin feature, my forum will lock up and I get an error 500 internal server error. I am guessing it has to do with port 51234 being denied by my provider, but I was hoping for some confirmation by someone who is who is far more experienced before contacting them.
Correct, with SA enabled it sends a TCP query when you access the page to use the extra features tcp provides.

Originally Posted by RogerChristie View Post
I set gTeamspeak up to use a remote database, then realised I could host it on the Linux box I had SSH access to. When I went to change the settings to using the local database, it said the changes were made successfully but when I try to access the gteamspeak.php file, I get this:
If you use local, the tables for ts2 need to be in the same database as vB. So you need to setup TS to use your vBulletin database. I don't know if you setup a second database on your vbulletin server for teamspeak, if you did, you still need to use remote option.

Logo, jluerken; thanks for the language support

Last edited by Gryphon; 09 Jul 2007 at 21:28.
Reply With Quote
  #156  
Old 10 Jul 2007, 14:50
silral silral is offline
 
Join Date: Jun 2007
Originally Posted by Blackjack View Post

Logo, jluerken; thanks for the language support
Yes, it's super...

..but my problem exists still .
Reply With Quote
  #157  
Old 15 Jul 2007, 20:27
RogerChristie RogerChristie is offline
 
Join Date: Jul 2007
Originally Posted by Blackjack View Post
Correct, with SA enabled it sends a TCP query when you access the page to use the extra features tcp provides.



If you use local, the tables for ts2 need to be in the same database as vB. So you need to setup TS to use your vBulletin database. I don't know if you setup a second database on your vbulletin server for teamspeak, if you did, you still need to use remote option.
I did all that, had to install mysql shared object libraries, did that, then it was able to show the gteamspeak page ... BUT I had to run all the sql files manually by actually pasting the queries into the sql query window of phpmyadmin.... it did NOT populate the new teamspeak tables with the vbulletin userdata or use the data from the existing vbulletin tables either, resulting in zero accounts available for login on the teamspeak server, and also no login image (odd!). I checked permissions on the image (the Teamspeak settings dialogue image that fills in with the user's details if working properly) and it's 777. I can go directly to the image file and view it no problem but it doesn't show up normally on the main gteamspeak.php page.

What to do now?
Reply With Quote
  #158  
Old 19 Jul 2007, 11:02
dooch dooch is offline
 
Join Date: Dec 2005
Originally Posted by dooch View Post
This is my most favorite mod here.

Its fantastic and works a charm.

I've installed it on my clan website and the boys love it.

ONE HUGE question though.

Is it possible to alter the coding so the SA's get a clan tag infront of their name on TS. So the nickname bit added "{RD}" infront of their nickname if they register as SA. The rest just get their usual forum name.

If someone could help me alter the code so it did this I'd be very happy.

Thanks again.

Dooch
Originally Posted by Gryphon View Post
The name that shows up in TS is not determined or stored server side, it is determined by whatever they put into their client for a nickname on step five of the registration instructions. You will need to just ask that your members update their nickname in their addressbook.
Originally Posted by dooch View Post
I understand however your quick connect buttons dont allow this, they use your forum name as the nickname and this is not changeable unless you manually connect to the server via TS itself..

Surely there is an if statement to say

if SA then add "{RD}" infornt of nickname

for the quick connect?

I'm no coder but this is what I'd like.

Thanks
Originally Posted by Gryphon View Post
Ahh yeah, I see what you mean. That is possible, I will try and look into that.
Gryphon,

Any luck with my original request. Still hoping the connect button will add a "clan tag" infront of the username for SA users.

MANY Thanks for this mod.

Reply With Quote
  #159  
Old 19 Jul 2007, 18:43
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Sorry I have no looked into that yet. I find myself hopping projects too much hehe.
Reply With Quote
  #160  
Old 23 Aug 2007, 16:33
p4rad0x p4rad0x is offline
 
Join Date: Apr 2006
Hi Gryphon,

I installed everything correct but these two errors got freakin' me out. My solution: Installing in the same database and now it works fine! ;-)

Last edited by p4rad0x; 24 Aug 2007 at 00:06.
Reply With Quote
  #161  
Old 23 Aug 2007, 18:37
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Look under Advanced Options to setup TS as an external database.
Reply With Quote
  #162  
Old 25 Aug 2007, 04:56
Chadi's Avatar
Chadi Chadi is offline
 
Join Date: May 2004
Not sure what I'm doing wrong here, but I added this to the bottom of the server.ini file and of course, edited the necessary fields.

[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


Now, I get this:

root@server [/home/teamspeak/public_html/tss2_rc2]# ./teamspeak2-server_startscript start
WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
starting the teamspeak2 server
Error starting daemon. Aborted


Even if I try to run as teamspeak user, I get this:

teamspeak@server [~/public_html/tss2_rc2]# ./teamspeak2-server_startscript start
starting the teamspeak2 server
Error starting daemon. Aborted


My permissions


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
...............................
Talk Jesus Forums: Christian Chat
games . chat . gallery . bible . videos
Reply With Quote
  #163  
Old 25 Aug 2007, 11:47
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Chadi check the server.log file. The error is logged there
__________________
Ciao jluerken
Reply With Quote
  #164  
Old 25 Aug 2007, 13:47
Chadi's Avatar
Chadi Chadi is offline
 
Join Date: May 2004
sorry forgot about that


24-08-07 23:16:41,ALL,Info,server, Server init initialized
24-08-07 23:16:41,ALL,Info,server, Server version: 2.0.23.19 Linux
24-08-07 23:16:41,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./libmysqld.a
24-08-07 23:16:41,ERROR,All,SERVER, Start_Server: unable to open database



This is what I have (with orange actual info, which I know is correct)



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
...............................
Talk Jesus Forums: Christian Chat
games . chat . gallery . bible . videos
Reply With Quote
  #165  
Old 25 Aug 2007, 14:51
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Your problem has nothing to do with this hack at all.
You simply have problems connecting to the mysql database.
Even without this hack you would have the problem

Database initialization error: EDatabaseError.Unable to Load ./libmysqld.a
The library cannot be loaded!

This is what I have
[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=xxx
Hostname=xxx
User_name=xxx
Password=xxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1
The library you have to load depends on the operating system and the mysql version you're running!

Fix this first before trying to use this hack!
__________________
Ciao jluerken
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 19:29.

Layout Options | Width: Wide Color: