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
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 08:33
Un-Activated User Management sabret00the vBulletin 3.0 Full Releases 204 02 Feb 2007 16:52

  #46  
Old 07 Sep 2006, 11:15
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Real name: Tim McGraw
will this work on 3.5.3?
__________________
LONG LIVE 3.8 SERIES
National Arcade Competition Club- NACC
Check out my heavily modified ibproarcade with over 45,000 games for you, free of charge!
Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade
Reply With Quote
  #47  
Old 08 Sep 2006, 14:40
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
SQL Error

Hi this seems to work fine up til im trying to access the Teamspeak CP

then i get a SQL error

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM eu-chron_t.ts2_clients WHERE i_client_server_id = '0' AND b_client_privilege_serveradmin = '-1' ORDER BY i_client_id ASC LIMIT 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-chron_t.ts2_clients WHERE i_client_server_id = '0' AND b_client_privilege_serve' at line 1
Error Number : 1064
Date : Friday, September 8th 2006 @ 04:27:28 PM
Script : http://www.mysite.com/forum/admincp/vbteamspeak.php
Referrer : http://www.mysite.com/forum/admincp/index.php?do=nav
IP Address : XXXXXXXXXXXX
Username : forumadmin
Classname : vB_Database
As you see it chops off the db name for some reason !?

Any ideas of whats wrong and can be done ?
Reply With Quote
  #48  
Old 11 Sep 2006, 16:46
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
*bump*

No one ?

Is this a code error or is it the mysql client that messes with me?
Any suggestions is appreciated
Reply With Quote
  #49  
Old 13 Sep 2006, 17:45
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
Originally Posted by SKNY
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

got the same result

TS running fine connected to mysql 5.0.24a-standard, (php 5.1.6)
Got the mod installed and all looks fine, ts2_forum_account table is created as suposed too

But when i access my teamspeak.php to enter my password
Page shows up fine but when hitting the "GO-button" nothing happens!?
Reply With Quote
  #50  
Old 16 Sep 2006, 08:24
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
Problem seems to be that this script is developed for an older version of MySQL (v4)!

So the question is this script still suported or is there a new version comming ??
Reply With Quote
  #51  
Old 16 Sep 2006, 20:21
daystorm daystorm is offline
 
Join Date: Apr 2006
Hello,

first I believe I did this right, but... where would I find this to change it? server.ini

Second, when I try to connect to the client, if I click anonymous I can connect. But if I put in the login name and user password and click registered from the vb that gets created, I receive the error: Bad Login (name and/or password wrong)

How do I fix this?

Thank you,
Ella
Reply With Quote
  #52  
Old 17 Sep 2006, 10:38
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
Originally Posted by daystorm
Hello,

first I believe I did this right, but... where would I find this to change it? server.ini

Second, when I try to connect to the client, if I click anonymous I can connect. But if I put in the login name and user password and click registered from the vb that gets created, I receive the error: Bad Login (name and/or password wrong)

How do I fix this?

Thank you,
Ella
Well first part is easy

Server.ini is found in same directory as the rest of TS-server files
Depending on OS or your choice of installation that could vary

The second question could depend on alot of reason
But i recomend you check in the database if any account really been created

If you read up on the thread you'll find that seems to be a pretty common error, atleast if you run mysql 5

cheers
Reply With Quote
  #53  
Old 19 Sep 2006, 18:24
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
Got this

Warning: Missing argument 1 for ts2_fromunix(), called in //www/forum/teamspeak.php on line 80 and defined in /includes/functions_vbteamspeak.php on line 197
and this

Warning: Invalid argument supplied for foreach() in /index.php(63) : eval()'d code on line 121
Questions

Where is the button for creating this table
4. Go the vBTeamSpeak management page and press Create Tables found at the bottom of the page. This will create a table that will store the users forum id and TeamSpeak id for later use.
I for sure dont get one

Since you release this with limited support

I will offer limited support this script. I developed this script for my own use, it works for me on 3 different installs of vBulletin on varying machines. I will entertain requests for new features and confirmed bugs that offer details. I will NOT troubleshoot "Nothing is happening for me" reports, I can't assume what your system is like.
I think you should tell us on what kind of system you got this working !?

and if you like to know whats "Nothing is happening for me" looks like check the pic enclosed. Seems to be missing some templates ..
Attached Images
File Type: jpg vbTeamspeak.jpg (10.6 KB, 60 views)
Reply With Quote
  #54  
Old 20 Sep 2006, 03:19
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Oop I forgot to mention there is a known bug. For some reason the phrases are not installed when you first install v2, you have to install v2 a second time over the top of the previous install. I am not sure why this is doing that if anyone has insight as to why this would be I would appreciate the information.

Regarding the errors, I will look into those tomorrow.

Also the create table button is no longer necessary, during install it creates a table in the vB database to store the plugins. The only reason why there was a manual create tables in v1 is that it required information that was only available after install.

It is currently installed in live use on two of my boards:

Server1:
Apache v1.3.36
PHP 4.4.2
MySQL Version 4.0.27-standard

Server2:
Apache v1.3.33
PHP 4.3.11
MySQL Version 4.0.27-standard

However, there should be nothing version specific in this hack. If there is, I am completely oblivious to the reason and I will need some direction to tell me where the problem could be.
Reply With Quote
  #55  
Old 20 Sep 2006, 03:52
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
OK found it, db-table (vbteamspeak_plugin) is created!
Second import also done

But still no data reaches the table

My knowledge of php is limited but my guess is that the problem lies in versions of mySQL & PHP and hows the db connection is handled


Im running
  • MySQL Version 5.0.24a-standard
  • PHP 5.1.6
And im using mysqli

It's great hack and i really would love to get it working
Reply With Quote
  #56  
Old 20 Sep 2006, 16:27
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
Ack, ok for the first error, I forgot to mention yet another change I made. The public file changed from teamspeak.php to vbteamspeak.php for consistency.

Where did the second error appear? Your forum index it appears? Is your mysql version the same for the teamspeak database as your vbulletin database? Are they using the same database?

Last edited by Gryphon; 20 Sep 2006 at 16:31.
Reply With Quote
  #57  
Old 20 Sep 2006, 16:51
maf1973 maf1973 is offline
 
Join Date: Oct 2005
Real name: Markus
If i try as Admin to open the teamspeak.php in the forum, i receive an error Message "You have no rights to view......bla bla.."

Any Ideas ?
Reply With Quote
  #58  
Old 20 Sep 2006, 18:21
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Real name: Ryan Snook
You need to add your user id to the config.php under superadministrators. I have not learned how to avoid having to do this at the moment.
Reply With Quote
  #59  
Old 20 Sep 2006, 20:15
orphan's Avatar
orphan orphan is offline
 
Join Date: Dec 2005
Originally Posted by Blackjack
Ack, ok for the first error, I forgot to mention yet another change I made. The public file changed from teamspeak.php to vbteamspeak.php for consistency.

Where did the second error appear? Your forum index it appears? Is your mysql version the same for the teamspeak database as your vbulletin database? Are they using the same database?
ahh ok that solved the Error i got on the teamspeak.php page
the other error was cased by me and soleved itself when i put in the right teamspeak ports

However nothing stills endup in the in the vb_vbteamspeak_plugin table

Yes i use the same mysql version for both Forum and Teamspeak but they are not on the same database
Reply With Quote
  #60  
Old 20 Sep 2006, 23:46
maf1973 maf1973 is offline
 
Join Date: Oct 2005
Real name: Markus
I solved the Problem.
I deleted the double entries in the Profile Box.
Now it works.
Attached Images
File Type: jpg profile.JPG (30.6 KB, 80 views)

Last edited by maf1973; 21 Sep 2006 at 05:23.
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 10:00.

Layout Options | Width: Wide Color: