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

  #91  
Old 08 Mar 2007, 08:21
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Importing v 3.2.0 brings this error

Database error in vBulletin 3.6.5:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'gts_sa_enable',
'gts_group2',
'1',
'0',
'boolean',
'yesno',
400,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_client_name',
'gts_group2',
'',
'0',
'free',
'',
405,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_client_password',
'gts_group2',
'',
'0',
'free',
'',
406,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_display_online',
'gts_group2',
'1',
'1',
'boolean',
'yesno',
410,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_display_online_forumhome',
'gts_group2',
'1',
'1',
'boolean',
'yesno',
420,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_whos_online_usergroup',
'gts_group2',
'0',
'0',
'free',
'',
430,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_whos_online_timeout',
'gts_group2',
'15',
'15',
'free',
'',
440,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_whos_online_display_idle',
'gts_group2',
'1',
'1',
'boolean',
'yesno',
450,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_whos_online_hide_empty',
'gts_group2',
'1',
'1',
'boolean',
'yesno',
460,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_whos_online_flag_aw',
'gts_group2',
'text-decoration: line-through;',
'text-decoration: line-through;',
'free',
'',
470,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_whos_online_flag_sa_ca',
'gts_group2',
'font-weight: bold;',
'font-weight: bold;',
'free',
'',
480,
0,
1,
'',
0,
'gTeamSpeak'
),
(
'gts_whos_online_flag_sa',
'gts_group2',
'color: #33CC00;',
'color: #33CC00;',
'free',
'',
490,
0,
1,
'',
0,
'gTeamSpeak'
);

MySQL Error : Duplicate entry 'gts_client_name' for key 1
Error Number : 1062
__________________
Ciao jluerken
Reply With Quote
  #92  
Old 08 Mar 2007, 16:24
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Hmm, I can not reproduce that. It looks like something went awry with the product installer as that query is handled by vBulletin's product system.
Reply With Quote
  #93  
Old 08 Mar 2007, 16:49
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Originally Posted by Blackjack View Post
Hmm, I can not reproduce that. It looks like something went awry with the product installer as that query is handled by vBulletin's product system.
If I uninstall the product and reinstall the v 3.2 will I loose the user data then?
__________________
Ciao jluerken
Reply With Quote
  #94  
Old 08 Mar 2007, 17:31
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
You will not lose existing TeamSpeak user data by uninstalling.
Reply With Quote
  #95  
Old 08 Mar 2007, 17:36
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Originally Posted by Blackjack View Post
You will not lose existing TeamSpeak user data by uninstalling.
I tried but the error is still coming up
__________________
Ciao jluerken
Reply With Quote
  #96  
Old 08 Mar 2007, 19:19
TheBlackPoet's Avatar
TheBlackPoet TheBlackPoet is offline
 
Join Date: May 2006
Real name: Malik Ali Shabbazz
im so lost.. but im determined to make this work....
my host company siteground.... i need to find out if they host this.. or how to configure it through my side...
Reply With Quote
  #97  
Old 08 Mar 2007, 20:24
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
You need to find out if you and run executable on your server. This is uncommon for a lot of the general web services. A really quick search appears that SiteGround will not host a TeamSpeak server. However, I could be wrong.
Reply With Quote
  #98  
Old 13 Mar 2007, 14:33
sys4096 sys4096 is offline
 
Join Date: Oct 2006
Fantastic product.

It makes my life a lot easier, I run a VB and teamspeak forum for a gaming (eve-online) community.

I have several vbulletin usergroups which correspond to in game groups ("corporations") and as players leave their in game corporation, so the individual group leaders remove them from the forum group that corresponds to their in game corporation.

Would it be easy to add an option to delete teamspeak accounts that are not members of the "allowed to use teamspeak" list of groups set in the options?

Or perhaps modify the cron so that it can delete accounts that are banned or not in my list of allowed groups to use teamspeak.

Cheers,
Paul.
Reply With Quote
  #99  
Old 13 Mar 2007, 17:07
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Yeah, I plan to add it to the cron to check for users who are no longer in a usergroup previously allowed access to the TeamSpeak server soon.
Reply With Quote
  #100  
Old 15 Mar 2007, 10:52
sickboy6ths sickboy6ths is offline
 
Join Date: Apr 2005
Fantastic product indeed... But I can't get the Remote MySQL server option to work... I have tried it on MySQL 5.0 and 4.1 Servers, (Password in OLD Encryption etc etc), but I simply dont get an error but also can't manage users, can't create new accounts (Page looks as if you didnt fill in a password yet.... filling it in and clicking 'Go' Simply refreshes the page and nothing happens. (Connectivity between servers is fine, there are no MySQL errors coming up)

It's a feature I actually need very much, any help would be much appreciated! thanks
Reply With Quote
  #101  
Old 22 Apr 2007, 08:55
scan-pa scan-pa is offline
 
Join Date: May 2006
Real name: Peter Kirk
Has there been any answers given to users of PHP5 & MySql 5?

I get this error:

Unable to Load /usr/lib/libmysqlclient_r.so.10.0.0

I need a quick solution to get this vB mod working asap.

Thanks in advanced.
Reply With Quote
  #102  
Old 22 Apr 2007, 10:08
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Originally Posted by scan-pa View Post
Has there been any answers given to users of PHP5 & MySql 5?

I get this error:

Unable to Load /usr/lib/libmysqlclient_r.so.10.0.0

I need a quick solution to get this vB mod working asap.

Thanks in advanced.
I don't think that this has something to do with the mod.
First you have to make sure that you got your teamspeak running with your DB.
Then you can start installing and using this hack.

For teamspeak related questions and how to install it --> www.goteamspeak.org
__________________
Ciao jluerken
Reply With Quote
  #103  
Old 22 Apr 2007, 15:15
scan-pa scan-pa is offline
 
Join Date: May 2006
Real name: Peter Kirk
Originally Posted by jluerken View Post
I don't think that this has something to do with the mod.
First you have to make sure that you got your teamspeak running with your DB.
Then you can start installing and using this hack.

For teamspeak related questions and how to install it --> www.goteamspeak.org
The mod poster has this as step one:

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:

Quote:
[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

there is an error with this on PHP 5 / mysql 5 servers. This needs corrected ASAP.

Now for the second time, can someone please tell me how to get this working, so I can continue to step 2.

Thanks again,
Reply With Quote
  #104  
Old 22 Apr 2007, 15:29
jluerken's Avatar
jluerken jluerken is offline
 
Join Date: Aug 2003
Location: Germany
Originally Posted by scan-pa View Post
Now for the second time, can someone please tell me how to get this working, so I can continue to step 2.
The author gave an example for a default installation. You are using a different system.
Have you tried the other libraries? If you don't have success with them try to get old ones, copy them to the lib directory and use them.
It worked for me.

And now for the second time from me: This has nothing to do with the mod, its about basic linux knowledge!
__________________
Ciao jluerken
Reply With Quote
  #105  
Old 22 Apr 2007, 15:34
scan-pa scan-pa is offline
 
Join Date: May 2006
Real name: Peter Kirk
Originally Posted by jluerken View Post
The author gave an example for a default installation. You are using a different system.
Have you tried the other libraries? If you don't have success with them try to get old ones, copy them to the lib directory and use them.
It worked for me.

And now for the second time from me: This has nothing to do with the mod, its about basic linux knowledge!

When it comes to PHP / mysql files, that is handled by the webhost, and they replied back to me about those lib files with, " Huh?"

I have teamspeak up and running, but would love to add this hack, can you help?
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 03:04.

Layout Options | Width: Wide Color: