gTeamSpeak - TeamSpeak User Management

[Gryphon]

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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=122221), 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.

https://vborg.vbsupport.ru/external/2008/02/14.png Follow me on twitter! (http://www.twitter.com/ghryphen)

Support
valueI 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
-
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.
Upload all files prior to installing product.
Install the product.
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.

Fill in the gTeamSpeak configuration options.
Install any plugins you wish to use from the /admincp/gtsplugin directory.
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 (https://vborg.vbsupport.ru/member.php?u=209647).


v3.21 - Import product with Overwrite enabled.

Fixed potential XSS vulnerability. Thanks Apophis (https://vborg.vbsupport.ru/member.php?u=33410).


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
-gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

[P.Jackson]

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

[Gryphon]

There is already a pretty good one available here (https://vborg.vbsupport.ru/showthread.php?t=99032). I may create similar functionality, but I have a few other ideas in mind I want to work on to :D

[SKNY]

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

[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

[Gryphon]

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

[SKNY]

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

[jluerken]

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?

[Snake]

Thanks for the great hack such as this one!

[Gryphon]

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?

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.

[DeMiNe0]

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

[Gryphon]

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.

[SCS_Rocket-Devi]

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

Database error in vBulletin 3.6.0 Release Candidate 3:

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

MySQL Error : Table 'vbulletin6.ts2_clients' doesn't exist
Error Number : 1146
Date : Monday, July 31st 2006 @ 01:22:48 PM
Script : http://www.*******.org/forum/teamspeak.php
Referrer :
IP Address : 86.140.217.226
Username : SCS_Rocket-Devil
Classname : vB_Database

and in admincp/vbteamspeak.php i get this error

Fatal error: Call to undefined function rpm_print_stop_back() in f:\domains\*******.org\wwwroot\forum\admincp\vbtea mspeak.php on line 30

[Gryphon]

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.

[jluerken]

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.

[Gryphon]

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.

[jluerken]

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:

Fatal error: Call to undefined function: rpm_print_stop_back() in /path/forum/admincp/vbteamspeak.php on line 30

[rouven]

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

[jluerken]

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.

[Gryphon]

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.

[RidinHighSpeeds]

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

[Gryphon]

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?

[RidinHighSpeeds]

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.

[Gryphon]

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.

[Firestar.chkn]

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:

Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so.10.0.0

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

[Gryphon]

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.

[Firestar.chkn]

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

[Gryphon]

I should have it available next week.
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 (https://vborg.vbsupport.ru/showthread.php?t=122955)?)
Clean up the plugin feature, it is kind of ugly
Product upgrade code


Future Release:

Channel Management
Other undetermined features :)

[computer1]

where can I download this to fedoracore4 ????

[jluerken]

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

[computer1]

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

[RidinHighSpeeds]

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

[Gryphon]

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.

[lanc3lot]

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

[rouven]

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

[rouven]

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?

[Gryphon]

Any chance to make a similar hack for Ventrilo? :)
Unfortunately no, I hate Ventrilo personally ;)

which ports need to be opened for this to work
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.

[rouven]

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

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? ;)

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


Welcome to the XXXXXXXX TeamSpeak server. Please do not disrupt any channels or harass any users or you will be removed from the server.

User Name: userid.1
Password: ______________________
[GO]

Not encrypted, do not use your forum password.


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

[rouven]

i am not alone :D

[jluerken]

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?


Sorry for my question but I've never seen someone who got TS2 working with MySQL 5 :D

Have you done the following:
1. Test teamspeak alone without the hack, meaning creating a user and connect to the ts server
2. Checked the ts2 server.log file
3. Updated the .sql files so that ts2 really works with teamspeak
4. Changed the password hashing for the mysql server.

TS2 is running with mysql if you use the old mysql 3.x libraries. Newer libraries use another password hashing. For the teamspeak db you have to change this hashing method manually.

BUT!!!!
All 5 points have nothing to do with the hack here. These are things you have to check and do BEFORE you try this hack :D

[rouven]

hi, ts2 is running without a problem. mysql5, no problem at all :)


BUT!!!!
All 5 points have nothing to do with the hack here. These are things you have to check and do BEFORE you try this hack

so, yes. all 5 points without a problem.

[PsiNyde]

silly question - i see that this is for vB 3.6.0, but will it work with 3.5.4 right off the bat? i'm going to try to install this by the weekend unless i'm told this won't work with 3.5.4.....

[aidler]

If you are searching for the libmysqlclient_r.so.10.0.0 and need more information how to set up Teamspeak for Mysql then take a look here (http://forum.goteamspeak.com/showthread.php?t=29329&highlight=mysql).

[rouven]

still needing help...

[blind-eddie]

will this work on 3.5.3?

[orphan]

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 ?

[orphan]

*bump*

No one ?

Is this a code error or is it the mysql client that messes with me?
Any suggestions is appreciated

[orphan]

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!?

[orphan]

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 ??

[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

[orphan]

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

[orphan]

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

[Gryphon]

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.

[orphan]

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

[Gryphon]

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?

[maf1973]

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 ?

[Gryphon]

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.

[orphan]

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

[maf1973]

I solved the Problem.
I deleted the double entries in the Profile Box.
Now it works.

[jluerken]

I solved the Problem.
I deleted the double entries in the Profile Box.
Now it works.

I had the same. The uninstaller routine of version 1.01 seems to forget to remove this field.

I also found another nice bug
http://www.clanforums.com/gallery/files/3-ts2whosonline_bug.jpg

I have two Who is Online in TS2 Hacks installed and as you can see vBTeamspeak who is online is not working correct.

1. The <NAME> is forgotten and not displayed
2. Its not showing (R) behind the name. This should be added
3. If you move your mouse over the name you get <font....> stuff displayed
This happens cause I modified the TODAY and YESTERDAY phrases to be coloured. vBTeamspeak should use an own phrase for this to work.

BlackJack can you fix/add this?

[Gryphon]

orphan: The plugins are in a folder in the zip file, they need to be each be imported if you want to use them. They are not necessary so they are optional install. I got the foreach() error today while moving servers around. I can fix this for future users.

maf1973: This is sort of a known bug. Because I can't create profile field by plugin, I have to do it by php and then store the fieldid for use during uninstall. On some systems it doesn't seem to store the fieldid so the uninstall misses it. I will see if I can improve upon this.

jluerken: My who's online is completely different than ts2live and written entirely by me, so yeah they aren't going to display the same. I guess I didn't expect people to put style information into a phrase, style should be handled by styles, I didn't see any reason to recreate a phrase that already exists. I also do not show (R) because everyone should be registered, there shouldn't be any unregistered people on the TS with this system. vBTeamSpeak also assumes that every single registered user has signed up with this form because it requires a specific loginname format to perform some of the functions, you should be starting with a blank userbase in order for vBTS to work properly.

[orphan]

OK
Found the plugin-ins and they seems to work

Now i only need a way to get the users into the Db from the vbteamspeak.php

[jluerken]

Is there a way to change this script that also normal admins can access it?
At the moment only superadmins get access to it.

[Gryphon]

orpha: I will look into more and see if I can find out why it is doing that.

jluerken: I'm sure it can, will have to look into it. Currently no.

[orphan]

Any news on this mod ?

[jluerken]

In the admincp under manage users it would be nice to have some sort options.

Sort listed users via name, creation date, last online etc

[Gryphon]

orphan: I haven't been able to check on that yet.

jluerken: The timestamps for last on and creation date do not sort properly and would require some performance hindering hack attempts because the default data table for TeamSpeak clients aren't in a very sort friendly format. I plan on adding pagination, but sort options are just too complicated with the TS database.

[FSFwebmaster]

Alright I've been messing with this all night.

As far as I can tell its installed. From the looks of it my either my webhost blocks out bound 3303 or my dedicated box provider blocks in bound 3303.

So my question is, is there a way to hack this to specify a port just like vbulletin it self?

[Gryphon]

You have to grant permission for your vBulletin IP access to your TS mySQL.

Here is a quick Google result http://help.hardhathosting.com/question.php/87

I use cPanel which allows me just to enter the remote IP, usually mySQL only allows localhost connections unless an IP is specifically granted.

Really, if you can, you should have TS use your vBulleting database and skip the remote access; it will be faster and more reliable.

[vbreal]

going to try this out

[sys4096]

apologies if this is staring me in the face or should be obvious, but what are the files I edit to give my users a nice display when they click on the vbteamspeak link to join the server?

They see the help picture and about half of the instructions, but I would like to have something like "welcome to my teamspeak server, rules are" etc similar to the example picture at the top of this thread.

Fantastic mod, much appreciated.
---------------------------------------------------------------------------------------

found the answer - instructions were only half complete because I hadn't done the second install. Alterations made in phrases.

Love this mod makes life so much simpler.

[frick]

Hello,

I have followed the instructions exactly and have had this working before with earlier versions, but cant get it to work with version 2.00.

Here is the error i get:

Database error in vBulletin 3.6.3:

Invalid SQL:
INSERT INTO vb_setting VALUES ('vbts_client_name', '0', '', 100, 'ts2_group_setting', '0', 0, 1, 'vBTeamSpeak_setting', 'free', 0, '');;

MySQL Error : Duplicate entry 'vbts_client_name' for key 1
Error Number : 1062
Date : Monday, November 20th 2006 @ 05:15:54 PM
Script : http://www.xxxxxx.com/forums/vbteamspeak.php
Referrer :
IP Address : xx.xx.xx.xx
Username : xxxx
Classname : vb_database


After I install it initially works the first time I go to the vbteamspeak page, but I get the error every time after. I made sure to delete all the teamspeak and other custom user profile fields, but can not get this to work. Any help would be apprecieated. Thanks!

[jluerken]

This hack is working perfectly, thanks man

Here a video tutorial for user in german
http://www.clanforums.com/forum/cms/flash_ts2_german.html
and english
http://www.clanforums.com/forum/cms/flash_ts2_english.html

[FSFwebmaster]

I know the plugin deletes users upon deletion from the forums, but I'm finding that it doesn't delete users when you change there user group to a group that doesn't have TS access and have to manually go in and remove them.

Our gaming squad runs our forums and ts on a membership basis. We were hoping this plugin would automatically revoke TS access when there user group was changed to one that doesn't have TS access.

Is it possible to create a routine to add to the cron jobs area to look for user group changes and delete demoted users or something similar thats automated?

[Logo]

Hello,

I have followed the instructions exactly and have had this working before with earlier versions, but cant get it to work with version 2.00.

Here is the error i get:

Database error in vBulletin 3.6.3:

Invalid SQL:
INSERT INTO vb_setting VALUES ('vbts_client_name', '0', '', 100, 'ts2_group_setting', '0', 0, 1, 'vBTeamSpeak_setting', 'free', 0, '');;

MySQL Error : Duplicate entry 'vbts_client_name' for key 1
Error Number : 1062
Date : Monday, November 20th 2006 @ 05:15:54 PM
Script : http://www.xxxxxx.com/forums/vbteamspeak.php
Referrer :
IP Address : xx.xx.xx.xx
Username : xxxx
Classname : vb_database


After I install it initially works the first time I go to the vbteamspeak page, but I get the error every time after. I made sure to delete all the teamspeak and other custom user profile fields, but can not get this to work. Any help would be apprecieated. Thanks!


i have the same problem.... :( anyone can help us ?

[storpappa]

This looks like an excellent addition, but it seems to be tailored for a single TS server. Has anyone modified it to work across multiple servers or multiple server ports on a single server?

[dooch]

i have the same problem.... :( anyone can help us ?

yes i have the same problem....

EDIT

Ok im getting to grips with this, its a nightmare to get going but the mysql errors are due to my webhost not allowing connection to the remote mysql server which TS is on.

My TS is on windows, my webhost is Linux so problems...

EDIT

One major problem which was giving me the mysql errors was "root" only had local host connections allowed!

So nearly there!!!!!

EDIT

Ok after wasting a day on this i still have a problem

I can register ONE person using this sytem, anymore and I get this error

Database error in vBulletin 3.6.4:

Invalid SQL:
INSERT INTO ts.ts2_clients SET i_client_server_id = '1', b_client_privilege_serveradmin = '-1', s_client_name = 'admin.2', s_client_password='whatever', dt_client_created='03012007003238000';

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Date : Wednesday, January 3rd 2007 @ 12:32:38 AM
Script : http://www.xxxxxxxx/forum/vbteamspeak.php
Referrer : http://www.xxxxxxx/forum/vbteamspeak.php
IP Address : xxxxxxx.251
Username : admin
Classname : vb_database

Any ideas??

Many Thanks!

EDIT

SOLUTION - GOT IT WORKING

Ok for the ppl out there that are trying to get this working with a LINUX webserver "virtual" host and a M$ dedicated box with TS here's how.

Delete all previous TS and start a fresh install of TS.
Run TS, make a note of the new SA and A passwords.
Close TS.
Add the two attached files to the TS directory (libmysql.dll and dbexpmda.dll)
Edit the server ini and add the following to the the bottom

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=yourdatabasename
Hostname=localhost
User_name=root
Password=yourpasswordhere
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1

Then copy all the files from sqlite_sql to mysql_sql. When it says overwrite say NO, so its just the new files.

There is a handy program found on the goteamspeak forums to check your connection settings to the database. I used this program to add a few more users to check it was working. Refer to your mysql db to see if theyre being added.

If youre using xampp for the local mysql databse ensure root has all priv's and NOT just on local, change it to %.

Launch TS and check the server log to look for any errors. It should come back fine.

Then install the product etc.

Ensure you complete the options and the advanced options.

Job done.

This has taken me some serious handbanging but its an excellent product so was worth the headache and the 600 cigs i smoked!

INSTALLED

THANKS

[dooch]

just to let you know the dll is only a 30 day tiral so its not a fix... unless u wanna pay $70 which i dont for a poxy dll.

[Spank]

If I install this hack, does teamspeak run from my host or from teamspeak? or to put it another way, will it use all my bandwidth?

Thanks =D

[Gryphon]

Well, I am not sure this mod is for you because I get the impression that you don't know how a TeamSpeak server works.

[Spank]

That's probably very true =D. Just curious, 'tis all. It does sound like a good feature to have though.

[Chadi]

Although mentioned as a bug, how do I remove the profile fields after I've uninstalled the plugin?

[Gryphon]

Just remove them like any other user profile.

[ringoflight]

Does this Support Teamspeak servers which don't run through a Database?
My Teamspeak installation is running on server hosted by my hosting company, and have only provided me with the Address, and Port number, aswell as the username and password.....

[Hamma]

Doubtful it uses mySQL to interface with accounts and passwords.

[jluerken]

Hi, I just updated from v2.0.0 to 3.1.0 and when I try to enable/disable a plugin I get this error message

Database error in vBulletin 3.6.5:

Invalid SQL:
UPDATE vb3_gteamspeak_plugin SET `enabled` = '0' WHERE `id` = '0';

MySQL Error : Unknown column 'id' in 'where clause'
Error Number : 1054
Date : Wednesday, March 7th 2007 @ 11:20:06 AM


It seems that the autoincrement field named "id" is missing.

Please can you tell me how to fix this?

[jluerken]

Ok here we go:

This is the old table

CREATE TABLE `vb3_vbteamspeak_plugin` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`version` varchar(255) NOT NULL default '',
`order` int(11) NOT NULL default '0',
`reqsa` int(11) NOT NULL default '0',
`enabled` int(11) NOT NULL default '0',
`menu` text NOT NULL,
`code` text NOT NULL,
`function` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

and this the new one

CREATE TABLE `vb3_gteamspeak_plugin` (
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`version` varchar(255) NOT NULL default '',
`order` int(11) NOT NULL default '0',
`reqsa` int(11) NOT NULL default '0',
`enabled` int(11) NOT NULL default '0',
`menu` text NOT NULL,
`code` text NOT NULL,
`function` text NOT NULL,
PRIMARY KEY (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


I got v3.1.0 running with this

CREATE TABLE `vb3_gteamspeak_plugin` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`version` varchar(255) NOT NULL default '',
`order` int(11) NOT NULL default '0',
`reqsa` int(11) NOT NULL default '0',
`enabled` int(11) NOT NULL default '0',
`menu` text NOT NULL,
`code` text NOT NULL,
`function` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Please if this is correct update the archive file

[jluerken]

Hi Blackjack,

v3.1.0 is working well after the above sql modification.

What about these old things?

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

Questions:
1. Can also a secondary group make users automatically SA or only primary?
2. Is the login page fully phrased?

[Gryphon]

Ah, well the id field should be missing, I just forgot to update the plugin query for enable/disable. I will fix that.

Requests: 1. User accounts are currently deleted if the forum account is deleted.

Questions: 1. Yes, 2. Yes.

[jluerken]

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

[Gryphon]

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.

[jluerken]

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?

[Gryphon]

You will not lose existing TeamSpeak user data by uninstalling.

[jluerken]

You will not lose existing TeamSpeak user data by uninstalling.

I tried but the error is still coming up

[TheBlackPoet]

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

[Gryphon]

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.

[sys4096]

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.

[Gryphon]

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.

[sickboy6ths]

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

[scan-pa]

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.

[jluerken]

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

[scan-pa]

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 (http://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,

[jluerken]

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!

[scan-pa]

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?

[Gryphon]

You have TeamSpeak running on SQLite most likely. You need to set it up to use mySQL, that is beyond the scope of this mod, you need to find out how to configure TeamSpeak to use mySQL on the TeamSpeak forums.

[scan-pa]

You have TeamSpeak running on SQLite most likely. You need to set it up to use mySQL, that is beyond the scope of this mod, you need to find out how to configure TeamSpeak to use mySQL on the TeamSpeak forums.


there is about 20 + dead topics on that dead forum (teamspeak) that several people have asked the same thing, with the same results (teamspeak can not use mysql5) without the files from late version 3 or early version 4.

The host we have our site on, has already replied that they will not add the needed files.

The sad thing is our dedicated host were moving too, also only allows php5 & mysql 5 to be loaded on the server.

:) Guess we will do without this mod.

Thanks,

[jluerken]

Thats what I said, its not a mod issue :D
btw. your host does not need to "install" the old libraries.
Its enough if they put them in the lib directory so that you have access to them.

Its only copying the files not more.
It does not matter for other installed things cause they still use the newer libraries anyway.
If you would like to be able to change such things in future on your own you should get a root server where the host is not managing the machine or restricting things.
But before doing so please increase your linux knowledge.

I hope to see Teamspeak3 coming this year with integrated db support.
Hopefully Blackjack is going to upgrade the mod then for this version :D

[Apophis]

I got this installed tonight and it's a very interesting product. I'm quite pleased with it. I do have a question that might be more of a feature request, Is it possible to be able to utilize groups OTHER than just Registered and SA? Specifically groups such as Operator, and to a lesser extent, Channel Admin? I use those groups quire extensively and I find it a bit odd that it's an all-or-nothing approach with either giving a user (R) or (SA) but nothing in between.

Other than that. Great product!!

[Gryphon]

Those flags are specific to the channel in which you grant the permission for the user. I currently do not have the structure setup to handle any channel settings, they are best handled from the TS client.

[Apophis]

Those flags are specific to the channel in which you grant the permission for the user. I currently do not have the structure setup to handle any channel settings, they are best handled from the TS client.

Ahhh.. Understood.. It's still a great product! :)

[sinistergaming]

alright i set this up but i keep getting the error that it cannot connect to db server
my teamspeak is on a seperate host from the db my site runs on.
i have put the appropriate settings in the server.ini and confirmed it with my webhoster.
but still it cannot connect.
is there a particular port that must be opened on my database side for the teamspeak to connect to my db server, or will it even work like that ?

[Gryphon]

I am not positive, but might be port 3306. You will have to grant access to allow the remote IP as well. With cPanel, it is as easy as entering the IP and pressing submit. See http://dev.mysql.com/doc/refman/4.1/en/connecting.html for more information.

[dooch]

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

[Gryphon]

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.

[dooch]

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

[Elite-Programs]

Excess me wen i Insalled your soft wire on my site this happin i uninsalled it its still like this can u help http://www.elite-programs.com/forum.php

[Gryphon]

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

Ahh yeah, I see what you mean. That is possible, I will try and look into that.

Excess me wen i Insalled your soft wire on my site this happin i uninsalled it its still like this can u help http://www.elite-programs.com/forum.php

I am not sure what could cause such a problem, please explain better what process you did which cause such a thing.

[sinistergaming]

ok i got it to connect to my database server it wrote the tables
but then the ts server aborts and gives me this :
dbExpress Error: Operation Not Supported
any thoughts?

[Elite-Programs]

All i did was insall the XML then Uploaded the files an then Wam that happin ? its thing or no one eles files but this one i have never EVER Had a proble like this an dum ace me didt back it up lol but i got a restore one ummm let me try an reupload my mysql File

[Elite-Programs]

Can anyone tell me y this happin i added INC floder an now i got this
http://www.elite-programs.com/forum.php
An i removed all of your files an i still get this crap GRRRRRRRRRRRRRRRRRR
Parse error: syntax error, unexpected '=' in /home/elitepro/public_html/inc/config.php on line 2

[Gryphon]

I am not sure why this is happening for you. You can disable all hacks by editing your config.php and adding the following code:

define('DISABLE_HOOKS', true);

The files for this hack should be in your forum directory before you add or remove the product xml.

[tctransporter]

Is there a way to get this installed on my website? I mean once i get the files on my server how do I initialize it? As you don't include that in your instructions so i'm not sure what to do :(

Please respond ASAP, as i would like to start using this soon.

Thanks,

tcTransporter

PS. I have multiple servers, as I am running more than one Server Instance will this support those as well? or no?

[jluerken]

Is there a way to get this installed on my website? I mean once i get the files on my server how do I initialize it? As you don't include that in your instructions so i'm not sure what to do :(


Install a TS on your page which is using a mysql database. Then install this hack, enter the db data and use it.


PS. I have multiple servers, as I am running more than one Server Instance will this support those as well? or no?

No, only one

[tctransporter]

Ok, thanks :) good to know, i'm still trying to figure out how to get it to show and all.

I'm trying to do remote i have a server & my TS servers are hosted on my pc, i'll try to figure it out and get them to work :) If not then i'll just figure something else out.

Does anyone know of a system that allows management of TS servers with a VB forum? I have seen that b4 but........... now i can't find it when i actually can use it :).

Any help would be appreciated.

[jluerken]

Does anyone know of a system that allows management of TS servers with a VB forum? I have seen that b4 but........... now i can't find it when i actually can use it :).


This is currently the only hack working with the latest vB Release

[tctransporter]

ok thanks for the info. jluerken :D Appreciated ;)

[dt-pain]

I no you dont give help with database. But! I can get TS running on my db. My only problem is! I use putty to start TS server and every thing works fine. The problem is once I exit putty I lose connection to the database. If I use TS with only MySqlLite every thing works fine even after i exit putty. I have asked for help at the TS forums with no luck. Thanks for any help..

[jluerken]

dt-pain try to start teamspeak in a screen

connect via putty to your server. start a screen. start teamspeak. disconnect the screen. logoff with putty and test if this works for you

[dt-pain]

Thanks. but i due not no what you mean by starting TS with a screen. Also this is on a detected server on Linux ..Thanks

[jluerken]

Thanks. but i due not no what you mean by starting TS with a screen. Also this is on a detected server on Linux ..Thanks

login via putty and enter SCREEN on the shell. Its a linux application and you can use it to run processes in the background.

MAN SCREEN for more info

[dt-pain]

When i enter screen this is all I get


Screen version 4.00.02 (FAU) 5-Dec-03

Copyright (c) 1993-2002 Juergen Weigert, Michael Schroeder
Copyright (c) 1987 Oliver Laumann

This program is free software; you can redistribute it and/or modify it under
the terms of the GNU General Public License as published by the Free Software
Foundation; either version 2, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with
this program (see the file COPYING); if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.

Send bugreports, fixes, enhancements, t-shirts, money, beer & pizza to
screen@uni-erlangen.de


[Press Space or Return to end.]

[jluerken]

well thats correct.

Press enter then, start your teamspeak server and press STRG-D to disconnect from the screen session.
Your ts should still run.

to return to this session, enter SCREEN -R to see all sessions if you have running more than once.

Enter SCREEN -R (name or number) then to jump into this session.

Linux basics!

[dt-pain]

Thanks for the help. Im learning linux. I don't no what you mean by "press STRG-D to disconnect from the screen session" I entered STRG-D and it says "command not found" Sorry for being a n00b but thanks for your help..
would you like My msn or Xfire so we don't post here so much? Thanks again

[jluerken]

dt-pain this was my failure, sorry. Its STRG-A-D
You can write me a PM here so that we do not use this thread for your case

[TheHeartSmasher]

Or type SCREEN -D
Is there anyway to auto assign a password to a user and if they loose it email it to them?

This way you can assign the user a nice 32 digit alphanumeric password then set an interval for it to be changed then have it encrypted with md5

[Gryphon]

They can not lose their password, they can always go to the form and it is displayed to them. TeamSpeak only uses plain text passwords.

[TheHeartSmasher]

Cool how about a random password generator that gives them their password and is a disabled text field so they can not actually create a password but can only view what their password will be the first time they use it.

Maybe implement this (http://www.phpfreaks.com/quickcode/Megapunk_-_Random_Password_Generator/71.php)somehow for the username password registration or use salt and md5 or some multiple form of encryption

This way the passwords will be harder to brute force as they are pretty long and random.

I am getting these error on the forum home page from when gteamspeak is enabled for viewers to view when Enable Super Admin Permissions.


Warning: Invalid argument supplied for foreach() in /index.php(63) : eval()'d code(77) : eval()'d code on line 14
This error when viewing the gTeamspeak from the AdminCP above the plugins:
Temporary Ban Player
Send Message to User

Invalid argument supplied for foreach() in /admincp/gteamspeak.php(82) : eval()'d code on line 10

Also the teamspeak bar on forum home is not visible

[LaCN]

What is needed to to update from 3.20 to 3.21 ?
I remember I changed some of the files, back then, but not which ones :p

Could u tell me in which area in the xml file, the changes have been made ?

[Gryphon]

v3.21 is just a product update, no other files need to be updated. Just install the product with overwrite enabled.

[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 (https://vborg.vbsupport.ru/showthread.php?t=134603)

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

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

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.

[jluerken]

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 :D
http://forum.goteamspeak.com/

[Dr.NoTime]

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

[RogerChristie]

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

[silral]

Na da es was mit Teamspeak zu tun hat, solltest du auch besser nicht hier suchen sondern im Teamspeak board :D
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.

[Gryphon]

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.

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

[silral]

Logo, jluerken; thanks for the language support :D

Yes, it's super...

..but my problem exists still .

[RogerChristie]

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?

[dooch]

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

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.

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

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.

:up:

[Gryphon]

Sorry I have no looked into that yet. I find myself hopping projects too much hehe.

[p4rad0x]

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! ;-)

[Gryphon]

Look under Advanced Options to setup TS as an external database.

[Chadi]

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

drwxr-xr-x 7 teamspeak teamspeak 4.0K Aug 24 22:48 ./
drwxr-xr-x 4 teamspeak teamspeak 4.0K Aug 24 22:46 ../
-rw-r--r-- 1 teamspeak teamspeak 7 Aug 24 22:48 bad_names.txt
drwxr-xr-x 4 teamspeak teamspeak 4.0K Aug 2 12:57 httpdocs/
-rw-r--r-- 1 teamspeak teamspeak 2.6K Aug 2 07:07 INSTALL
-rw-r--r-- 1 teamspeak teamspeak 3.1K Aug 2 06:38 INSTALL.mysql
-rw-r--r-- 1 teamspeak teamspeak 229K Mar 9 2004 libsqlmy.so
-rw-r--r-- 1 teamspeak teamspeak 21K Aug 2 06:38 LICENSE
drwxr-xr-x 2 teamspeak teamspeak 4.0K Mar 9 2004 Manual/
-rw-r--r-- 1 teamspeak teamspeak 353 Mar 9 2004 manual.html
drwx------ 2 teamspeak teamspeak 4.0K Aug 2 06:25 mysql_sql/
-rw-r--r-- 1 teamspeak teamspeak 3.9K Aug 2 06:49 README
-rw-r--r-- 1 teamspeak teamspeak 20K Aug 24 22:48 server.dbs
-rw-r--r-- 1 teamspeak teamspeak 789 Aug 24 22:52 server.ini
-rwxr--r-- 1 teamspeak teamspeak 927K Aug 2 06:50 server_linux*
-rw-r--r-- 1 teamspeak teamspeak 2.5K Aug 24 22:52 server.log
-rw-r--r-- 1 teamspeak teamspeak 247K Mar 9 2004 sqlite.so
drwx------ 2 teamspeak teamspeak 4.0K Aug 2 06:25 sqlite_sql/
drwxr-xr-x 2 teamspeak teamspeak 4.0K Mar 9 2004 tcpquerydocs/
-rwxr-xr-x 1 teamspeak teamspeak 2.5K Mar 9 2004 teamspeak2-server_startscript*
-rw-r--r-- 1 teamspeak teamspeak 0 Aug 24 22:48 whitelist.txt
root@server [/home/teamspeak/public_html/tss2_rc2]# ./teamspeak2-server_startscript start

[jluerken]

Chadi check the server.log file. The error is logged there

[Chadi]

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)


[DBEXPRESS]
sqldir=/var/lib/mysql
Drivername=mysql
Database=database_name
Hostname=localhost
User_name=database_username
Password=database_password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.14.0.0
LibraryName=./libmysqld.a
Active=1


root@server [/usr/lib]# ls *mysql*
libmysqlclient_r.so@ libmysqlclient_r.so.14.0.0* libmysqlclient.so.14@ libmysqlclient.so.6@
libmysqlclient_r.so.14@ libmysqlclient.so@ libmysqlclient.so.14.0.0*

mysql:
./ libheap.a libmyisam.a libmysqlclient.la* libmysqld.a libnisam.a libz.la*
../ libmerge.a libmyisammrg.a libmysqlclient_r.a libmystrings.a libvio.a mysqld.sym
libdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.la* libmysys.a libz.a

[jluerken]

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!

[Chadi]

I cannot find any download for libsqlmy.so via Google.

[jluerken]

I cannot find any download for libsqlmy.so via Google.

Like I said, this has nothing to do with this hack. Please check out www.goteamspeak.com

[Gryphon]

Thank you for helping out jluerken, you have answered these questions better than I could have.

[Foxtrotelite]

I rent a teamspeak from a hosting company. Will this mod work with the remote ts?

[jluerken]

Yes you can enter a remote ServerIP but your Teamspeak Host needs two things:

1. TS must be installed in a mysql database. Normally hosters do not do so, they use the standard sqllite.
2. The remote TS must allow TCP Query. This should be working but some TS Hosters disable this with a firewall for whatevery reason.

btw. with vB 3.5 we got the product installation feature so before asking if a product will work for you or not, simply make a db backup, install and and test it. If its not working remove the product with a single click again.

[RogerChristie]

Yes you can enter a remote ServerIP but your Teamspeak Host needs two things:

1. TS must be installed in a mysql database. Normally hosters do not do so, they use the standard sqllite.
2. The remote TS must allow TCP Query. This should be working but some TS Hosters disable this with a firewall for whatevery reason.

btw. with vB 3.5 we got the product installation feature so before asking if a product will work for you or not, simply make a db backup, install and and test it. If its not working remove the product with a single click again.


I did not use a firewall on the remote TS/MySQL database, yet the TCP queries apparently just did not get through (this was using a Linux version of the server, which was tested and shown to be working). Mystified. Worse yet, when trying to run Teamspeak on this remote Windows 2000 Server installation, upon attempting to start the TS server, I see the tray icon appear for a split second, then it disappears and the TS server will not load. I looked for an error log but it does not even generate one so I can't find out what the trouble is. When I change the server.ini file back to using SQLite, the TS server starts normally. My MySQL database and permissions, and file permissions are all "grant all" for the MySQL database user, the database itself works fine by itself. I'm getting aggravated with Teamspeak already, I cannot believe these flaws have not been fixed after so many years of TS being in existence now. Please help!!!! :eek::eek::eek::eek::(

[jluerken]

This has nothing to do with this hack. You should ask for support at www.goteamspeak.com

Linux:
Accessing the mysql remotely has most of the times nothing to do with the rights for a db.
You should check you "skip-networking" variable in your my.cnf (/etc/my.cnf).
Change it to "#skip-networking" and restart the mysql server.

Windows:
I've never tested a mysql and ts2 installation on windows and do not see a need for doing so but
it could be the same issue like described above.

If you have >= Mysql 4.1 you MUST change the password hashing for the TS database to the old format
cause the ts libraries cannot use the new one.

[heugabel]

i become this error:

Invalid SQL:
INSERT INTO ts2.ts2_clients SET i_client_server_id = '1', b_client_privilege_serveradmin = '0', s_client_name = 'test.19', s_client_password='xxxxxxxx', dt_client_created='28082007195255000';

MySQL-Fehler : Duplicate entry '0' for key 1

[jluerken]

i become this error:

Invalid SQL:
INSERT INTO ts2.ts2_clients SET i_client_server_id = '1', b_client_privilege_serveradmin = '0', s_client_name = 'test.19', s_client_password='xxxxxxxx', dt_client_created='28082007195255000';

MySQL-Fehler : Duplicate entry '0' for key 1


Sure you get it cause you use the wrong statements. Check out this

http://forum.goteamspeak.com/showthread.php?t=26982&highlight=4.1

[heugabel]

Sure you get it cause you use the wrong statements. Check out this

http://forum.goteamspeak.com/showthread.php?t=26982&highlight=4.1

i have changed the entries but i become the same error...

this error comes when i filled out the password field

sorry for my bad english :D



the first person who has entered a password he becomes the "i_client_id" "0"

every other persons become the same id and this is the duplicate

[heugabel]

i have found the error....

for field "i_client_id" must activate "auto_increment"

it works

but is this correct for all other functions?

[jluerken]

This is correct. Auto increment is ok

[Chadi]

I really would appreciate someone helping me to get TS at least installed right. Its been a nightmare.
---------------------------------------------------------------
-------------- log started at 30-08-07 14:58 -------------
---------------------------------------------------------------
30-08-07 14:58:54,ALL,Info,server, Server init initialized
30-08-07 14:58:54,ALL,Info,server, Server version: 2.0.23.19 Linux
30-08-07 14:58:54,ERROR,All,SERVER, VirtualServer Startup(1) Exception: EDatabaseError.dbExpress Error: Operation Not Supported
30-08-07 14:58:54,ALL,Info,server, Server init finished
30-08-07 14:58:54,ERROR,Info,server, Unable to createpid file, stopping daemon
30-08-07 14:58:54,ALL,Info,server, Server shutdown initialized
30-08-07 14:58:54,ALL,Info,server, Stopping VirtualServer id:0 with port:8767
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 30-08-07 14:59 --------------
---------------------------------------------------------------

File: read_servers.sql

SELECT * FROM ts2_servers WHERE i_server_id > 0;

I tried starting it in root user mode, it works just not in teamspeak user mode

[jluerken]

chadi this is a vbhacks site. for teamspeak support visit www.goteamspeak.com

[SocialNetworkBuzz]

I can't get teamspeak to start after making these changes. if I remove it from the .ini it starts up again. .log is showing that it is failing on

-------------- log started at 29-09-07 13:15 -------------
---------------------------------------------------------------
29-09-07 13:15:11,ALL,Info,server, Server init initialized
29-09-07 13:15:11,ALL,Info,server, Server version: 2.0.23.19 Linux
29-09-07 13:15:11,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient$
29-09-07 13:15:11,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 29-09-07 13:15 --------------
---------------------------------------------------------------

I have both the % wildcard and the IP to my shell server which houses my TS and IRC server in cPanel of the server that houses my vB forum.

I'm assuming using libmysqlclient_r.so.14.0.0 is ok as that is what is in my /usr/lib there is no 10.0.0 in the folder.

[SocialNetworkBuzz]

I downloaded 10.0.0 and now that loads. But it is still failing. Now I receive DatabaseError.dbExpress Error: Invalid Username/Password but the .ini settings
are the same as my vbulletin config file.

[SocialNetworkBuzz]

for anyone who doesn't have 10.0.0 on your server..

[jluerken]

Hi Gryphon,

I am using your hack now for a few month and its great.
I found out that people register to use the teamspeak, but never write a forum thread/post.

It would be nice to add a feature to this hack that checks this.

Example:
Group A must have X threads/posts within Y days.
If a user tries to connect to the teamspeak server the hack should check if the set minimum thread/post value for the set timeframe is reached and allow/disallow access.

Do you think you can integrate this?

[jluerken]

I downloaded 10.0.0 and now that loads. But it is still failing. Now I receive DatabaseError.dbExpress Error: Invalid Username/Password but the .ini settings
are the same as my vbulletin config file.

Which MySQL Version do you have?
If 4.1x or higher pls. check that you set the old password hashing method for the teamspeak database cause the teamspeak libraries cannot handle the new system.

[SocialNetworkBuzz]

Which MySQL Version do you have?
If 4.1x or higher pls. check that you set the old password hashing method for the teamspeak database cause the teamspeak libraries cannot handle the new system.


How do you do that? Yes, I'm using 4.1.22

[Gryphon]

Group A must have X threads/posts within Y days.

Do you think you can integrate this?

Options added.

[jluerken]

How do you do that? Yes, I'm using 4.1.22

If you get an error about client authentication version when connecting to MySQL then it may be because your server is using the new
password format, while your mysql client (or PHP script, or JDBC code) is using the old password format. See: http://dev.mysql.com
/doc/mysql/en/Application_password_use.html.

You can change a new password to an old password like this:
bash shell>mysql -u root -p
passwort: rootpw

mysql> USE mysql
mysql> update user set password = old_password('passwordhere') where user = 'teamspeak'; flush privileges;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select user, password from user;
+-------+-------------------------------------------+
| user | password |
+-------+-------------------------------------------+
| root | *BA3E2F47E409A6ABA83D219D70631A02FE28539E |
| root | *BA3E2F47E409A6ABA83D219D70631A02FE28539E |
| | |
| | |
| teamspeak | 09a6e3834c6d11c9 |
+-------+-------------------------------------------+
5 rows in set (0.00 sec)


In this case root has a new, longer password. While the teamspeak user has the shorter, old password format. In PHP something like mys
ql_connect('localhost', 'teamspeak', 'passwordhere') should now successfully create a connection.

Replace "teamspeak" with the user you start your teamspeak server with.

Attention:

1. Never use ROOT to start your teamspeak server
2. Always update teamspeak with the latest server library
3. This is basic teamspeak knowledge and has nothing to do with this hack.
4. Don't forget to change some .sql statement if you use teamspeak with mysql instead of the sqllite system, otherwise it will not work

Get your teamspeak running before you install this hack!

[jluerken]

Options added.

Great news, thanks.
I will test the update later on and give you Feedback gryphon

[Gryphon]

vBulletin also has tools which could have been used as well to manipulate access control without these added options. By creating a usergroup which has access to the teamspeak signup and then create a usergroup promotion with the post/reputation/days registered ect. to promote them to that usergroup.

But it was only 10 lines of code I had already done for another project so it was a simple update ;)

[jluerken]

No its not the same. Promoting a user if he has for example 30 posts is something different than checking if the user has written 30 posts within the last X days.
Thats what I was looking for.

Not check the post amount but check the post amount for the last x days :D

Did you get it now? Sorry that I did not describe it better in my initial posting

[Gryphon]

I see, what I added will not do that. I may look into doing what you are asking, however I am unsure how soon I can do that.

[JokeAss]

Nice plugin!

But why is it that you need it to switch to MySQL? o_O

It should be possible to do all this via the TCP interface.

[mjdnet]

Not sure if I have made an install mistake but I cannot access this and do not see the Navbar entry? I have selected the Navbar and quick link entry but neither show. If I add the gteamspeak.php path manually I get a message that I am not authorised to view this,,,

Any help?

[Gryphon]

Not sure if I have made an install mistake but I cannot access this and do not see the Navbar entry? I have selected the Navbar and quick link entry but neither show. If I add the gteamspeak.php path manually I get a message that I am not authorised to view this,,,

Any help?
The navbar and quicklink entries are style dependant, if there are any modifications to the style they probably won't get added properly.

When going to gteamspeak.php and you get the message that you are not authorized to view, you need to setup the usergroup access permissions and custom profilefield, though, admin should be enabled by default.

There isn't really much I can do to help without knowing how your board is setup or what you did to setup the mod, just make sure you go over all instructions and settings carefully, this mod isn't plug n' play, it takes some setup time.

[Iratus]

Hi Gryphon,

Great mod but I'm having the PHP 5 / MySQL 5 compatability issue where you enter your password to create the account but it just refreshes the screen and never proceeds (and doesn't create the table entry)

I have Teamspeak working just dandy on SQL and so I know that's not the problem so I'm wondering if it's a PHP compatability issue. Any chance you can point me at where the user creation section of the script is, I'm going to have a crack at fixing it but am having a blonde moment and can't see it.

Cheers,

Iratus

[jluerken]

Hi Iratus,

can you please do the following?
Empty the server.log file, start your server and try to manage it via this mod.
Wait for the error and then post the content of your server.log file here?

/jluerken

[Iratus]

It isn't erroring in the TS log, that's what's making me think that it's some type of PHP error, IE it's never getting as far as the SQL


---------------------------------------------------------------
-------------- log started at 26-11-07 10:44 -------------
---------------------------------------------------------------
26-11-07 10:44:23,ALL,Info,server, Server init initialized
26-11-07 10:44:23,ALL,Info,server, Server version: 2.0.24.1 Linux
26-11-07 10:44:24,ALL,Info,server, Starting VirtualServer id:1 with port:8767
26-11-07 10:44:24,ALL,Info,server, Started VirtualServer id:1 with port:8767
26-11-07 10:44:25,ALL,Info,server, Server init finished
26-11-07 10:44:25,WARNING,Info,server, TeamSpeak Server daemon activated


and just for congruity to show I'm hooking into sql properly


[Main Config]
BoundToIp1=
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
Password=******
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

[WebPost]
AdminEmail=na
ISPLinkURL=na
ISPName=Private
ISPCountryNumber=5317
Enabled=1
PostURL=
ListPublic=0
UserAgent=teamspeak

[log]
access_r=0
access_u=0
channel_registerred=0
channel_unregisterred=0
sa=0
chat=0
kick_server=0
kick_channel=0

[Spam]
max_commands=10
in_seconds=2

Just for reference

PHP Version 5.2.3
Apache 2.2.3
MySQL 5.0.27
(So typical of Linux that staying on top of security updates has screwed me :) )

I was taking Gryphons advice that he wouldn't support it to a seperate database so I could have a problem with the connection but as it uses the same login details as TS itself I can't see where the problem is. Shall I just try connecting it to my VBulletin Database and creating the tables there and see if that works? I was trying to avoid it because I'd have to do the password compatibility change on the VBulletin dba account.

[Gryphon]

I am not positive of the differences in PHP 4/5 and MySQL 4/5 so unfortunately I can not help much in that regard. I am unsure why this would be happening and it will require that someone who does know help answer this and I will implement a possible compatibility fix if needed.

[Brandje]

In installed this on my TS server that was allready running a Mysqldb, and it works like a charm! thanks for the great mod!

Ohw, and I am using php5/mysql5, and found no errors what so ever

[xTerMn8R]

Will this hack work if I'm connecting to MYSQL using dbxODBC instead of dbxmda which costs 70-150 bucks. My 30 days just ran out and I see on goteamspeak they have alternative methods of connecting TS to MySQL using odbc.

Thanks,
xTerMn8R
www.superskunkracing.org

[xTerMn8R]

Yup went thought the process they suggest and went smooth as cake. Remember to take the <> out of the example they give for the entries in the ini file... ie: DSN, DB, Username, and Password. That threw me a curve but after looking at the other code in my ini I saw that no of the other valures required the <> so I took um out and bam everything worked and it connected to my existing db with NO changes necessary.

Screw that dbxmda.dll Crap, now I know I'm good to go LONG term :)

[xTerMn8R]

Is there any way to change the Blue color to another color in the team speak Client background?

Thx

[Gryphon]

Yes. There is a program someone made that hacks the TeamSpeak.exe and changes the colors. I host the file at http://www.thzclan.com/files/index.php?cat=47.

[xTerMn8R]

Cool but I found the stylesheet and made the changes there... and it worked
Thx for the reply though ... ^5

[Gryphon]

Stylesheet? Hmm, I must not have followed what blue background you were requesting before.

[Hawaiian-TV]

First of all thanks for writing such great products and plugins!! I followed all the installation steps on the currently updated official gTeamspeak page here at the VBulletin.Org Official Modifications Site (forum). Just today I upgraded from 3.24 to 3.27 and also for the first time noticed new instructions explaining what to fill in in some of the Custom User Profile Fields. I did it exactly as shown there (although the bottom two sections, for "Optional Input" and "Display Page"; there were no instructions for how to set these, maybe that's part of the problem?)


gTeamspeak 3.27 works perfectly for me so far except for two problems:

I keep getting the following message in the Manage Users page and at the bottom of the gTeamspeak main configuration page:

Array
(
[0] => Array
(
[cmd] =>
[rpl] => Connection refused
)
in a big black square that looks like a borderless console window.

I searched various threads but couldn't even find "[rpl] => Connection refused"
doing a Google search (http://www.google.com/search?hl=en&safe=off&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&hs=9MY&q=%22%5Brpl%5D+%3D%3E+Connection+refused%22&btnG=Search).
)

This means I can't use any of the plugins and probably cannot auto-ban users from
the Teamspeak server when they are banned by usergroup. (?)

The other problem I'm having (probably related to the above one?) is that the Who's Online
part of the product isn't working for me. It's permanently stuck at "0 Active and 1 Inactive Users"
no matter how many people log in to both the site and the voice chat system or how long they stay
logged on. Everything else in both the TS server itself and the product seems to work perfectly so far though.


It's VBulletin version 3.6.8 Patch 2, gTeamspeak v.3.27,
being run on Red Hat Linux Enterprise ES 4.5, Apache 2.0.52 handler, PHP 5.2.1, MySQL v. 5.0.27 etc. as below.

Here's my MySQL and PHP info (xxxxxxx's substituted in places for privacy):



MySQL Stats mysql_stat() Uptime: 4375
Threads: 2
Questions: 8855
Slow queries: 0
Opens: 431
Flush tables: 1
Open tables: 400
Queries per second avg: 2.024

MySQL Status query: SHOW STATUS Aborted_clients: 0
Aborted_connects: 0
Binlog_cache_disk_use: 0
Binlog_cache_use: 0
Bytes_received: 8684117
Bytes_sent: 203496648
Com_admin_commands: 0
Com_alter_db: 0
Com_alter_table: 3
Com_analyze: 0
Com_backup_table: 0
Com_begin: 0
Com_change_db: 324
Com_change_master: 0
Com_check: 0
Com_checksum: 0
Com_commit: 0
Com_create_db: 0
Com_create_function: 0
Com_create_index: 0
Com_create_table: 3
Com_dealloc_sql: 0
Com_delete: 91
Com_delete_multi: 0
Com_do: 0
Com_drop_db: 0
Com_drop_function: 0
Com_drop_index: 0
Com_drop_table: 5
Com_drop_user: 0
Com_execute_sql: 0
Com_flush: 0
Com_grant: 0
Com_ha_close: 0
Com_ha_open: 0
Com_ha_read: 0
Com_help: 0
Com_insert: 135
Com_insert_select: 3
Com_kill: 0
Com_load: 0
Com_load_master_data: 0
Com_load_master_table: 0
Com_lock_tables: 5
Com_optimize: 1
Com_preload_keys: 0
Com_prepare_sql: 0
Com_purge: 0
Com_purge_before_date: 0
Com_rename_table: 0
Com_repair: 0
Com_replace: 147
Com_replace_select: 0
Com_reset: 0
Com_restore_table: 0
Com_revoke: 0
Com_revoke_all: 0
Com_rollback: 0
Com_savepoint: 0
Com_select: 2335
Com_set_option: 0
Com_show_binlog_events: 0
Com_show_binlogs: 0
Com_show_charsets: 0
Com_show_collations: 0
Com_show_column_types: 0
Com_show_create_db: 0
Com_show_create_table: 350
Com_show_databases: 0
Com_show_errors: 0
Com_show_fields: 12
Com_show_grants: 0
Com_show_innodb_status: 0
Com_show_keys: 6
Com_show_logs: 0
Com_show_master_status: 0
Com_show_ndb_status: 0
Com_show_new_master: 0
Com_show_open_tables: 0
Com_show_privileges: 0
Com_show_processlist: 0
Com_show_slave_hosts: 0
Com_show_slave_status: 0
Com_show_status: 3
Com_show_storage_engines: 0
Com_show_tables: 16
Com_show_variables: 10
Com_show_warnings: 0
Com_slave_start: 0
Com_slave_stop: 0
Com_stmt_close: 0
Com_stmt_execute: 0
Com_stmt_prepare: 0
Com_stmt_reset: 0
Com_stmt_send_long_data: 0
Com_truncate: 3
Com_unlock_tables: 5
Com_update: 2215
Com_update_multi: 3
Connections: 330
Created_tmp_disk_tables: 11
Created_tmp_files: 0
Created_tmp_tables: 67
Delayed_errors: 0
Delayed_insert_threads: 0
Delayed_writes: 0
Flush_commands: 1
Handler_commit: 0
Handler_delete: 379
Handler_discover: 0
Handler_read_first: 1171
Handler_read_key: 132793
Handler_read_next: 83642
Handler_read_prev: 261
Handler_read_rnd: 7688
Handler_read_rnd_next: 1678508
Handler_rollback: 0
Handler_update: 758
Handler_write: 8017
Key_blocks_not_flushed: 0
Key_blocks_unused: 57031
Key_blocks_used: 959
Key_read_requests: 352700
Key_reads: 1082
Key_write_requests: 11023
Key_writes: 1367
Max_used_connections: 3
Not_flushed_delayed_rows: 0
Open_files: 782
Open_streams: 0
Open_tables: 400
Opened_tables: 431
Qcache_free_blocks: 37
Qcache_free_memory: 60639360
Qcache_hits: 2853
Qcache_inserts: 1908
Qcache_lowmem_prunes: 0
Qcache_not_cached: 427
Qcache_queries_in_cache: 599
Qcache_total_blocks: 1574
Questions: 8855
Rpl_status: NULL
Select_full_join: 11
Select_full_range_join: 0
Select_range: 566
Select_range_check: 0
Select_scan: 635
Slave_open_temp_tables: 0
Slave_retried_transactions: 0
Slave_running: OFF
Slow_launch_threads: 0
Slow_queries: 0
Sort_merge_passes: 0
Sort_range: 49
Sort_rows: 71093
Sort_scan: 295
Table_locks_immediate: 6765
Table_locks_waited: 1
Threads_cached: 1
Threads_connected: 2
Threads_created: 3
Threads_running: 1
Uptime: 4375 MySQL Vars query: SHOW VARIABLES back_log: 50
basedir: /usr/local/mysql-standard-4.1.22-linux-i686/
binlog_cache_size: 32768
bulk_insert_buffer_size: 8388608
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/mysql-standard-4.1.22-linux-i686/share/mysql/charsets/
collation_connection: latin1_swedish_ci
collation_database: latin1_swedish_ci
collation_server: latin1_swedish_ci
concurrent_insert: ON
connect_timeout: 5
datadir: /var/lib/mysql/
date_format: %Y-%m-%d
datetime_format: %Y-%m-%d %H:%i:%s
default_week_format: 0
delay_key_write: ON
delayed_insert_limit: 100
delayed_insert_timeout: 300
delayed_queue_size: 1000
expire_logs_days: 0
flush: OFF
flush_time: 0
ft_boolean_syntax: + -><()~*:""&|
ft_max_word_len: 84
ft_min_word_len: 4
ft_query_expansion_limit: 20
ft_stopword_file: (built-in)
group_concat_max_len: 1024
have_archive: YES
have_bdb: NO
have_blackhole_engine: NO
have_compress: YES
have_crypt: YES
have_csv: NO
have_example_engine: NO
have_geometry: YES
have_innodb: DISABLED
have_isam: NO
have_merge_engine: YES
have_ndbcluster: NO
have_openssl: NO
have_query_cache: YES
have_raid: NO
have_rtree_keys: YES
have_symlink: YES
init_connect:
init_file:
init_slave:
innodb_additional_mem_pool_size: 1048576
innodb_autoextend_increment: 8
innodb_buffer_pool_awe_mem_mb: 0
innodb_buffer_pool_size: 8388608
innodb_data_file_path:
innodb_data_home_dir:
innodb_fast_shutdown: ON
innodb_file_io_threads: 4
innodb_file_per_table: OFF
innodb_flush_log_at_trx_commit: 1
innodb_flush_method:
innodb_force_recovery: 0
innodb_lock_wait_timeout: 50
innodb_locks_unsafe_for_binlog: OFF
innodb_log_arch_dir:
innodb_log_archive: OFF
innodb_log_buffer_size: 1048576
innodb_log_file_size: 5242880
innodb_log_files_in_group: 2
innodb_log_group_home_dir:
innodb_max_dirty_pages_pct: 90
innodb_max_purge_lag: 0
innodb_mirrored_log_groups: 1
innodb_open_files: 300
innodb_table_locks: ON
innodb_thread_concurrency: 8
interactive_timeout: 28800
join_buffer_size: 67104768
key_buffer_size: 67108864
key_cache_age_threshold: 300
key_cache_block_size: 1024
key_cache_division_limit: 100
language: /usr/local/mysql-standard-4.1.22-linux-i686/share/mysql/english/
large_files_support: ON
lc_time_names: en_US
license: GPL
local_infile: ON
locked_in_memory: OFF
log: ON
log_bin: OFF
log_error:
log_slave_updates: OFF
log_slow_queries: OFF
log_update: OFF
log_warnings: 1
long_query_time: 10
low_priority_updates: OFF
lower_case_file_system: OFF
lower_case_table_names: 0
max_allowed_packet: 67107840
max_binlog_cache_size: 4294967295
max_binlog_size: 1073741824
max_connect_errors: 10
max_connections: 100
max_delayed_threads: 20
max_error_count: 64
max_heap_table_size: 67107840
max_insert_delayed_threads: 20
max_join_size: 4294967295
max_length_for_sort_data: 1024
max_prepared_stmt_count: 16382
max_relay_log_size: 0
max_seeks_for_key: 4294967295
max_sort_length: 1024
max_tmp_tables: 32
max_user_connections: 0
max_write_lock_count: 4294967295
myisam_data_pointer_size: 4
myisam_max_extra_sort_file_size: 2147483648
myisam_max_sort_file_size: 2147483647
myisam_recover_options: OFF
myisam_repair_threads: 1
myisam_sort_buffer_size: 8388608
myisam_stats_method: nulls_unequal
net_buffer_length: 16384
net_read_timeout: 30
net_retry_count: 10
net_write_timeout: 60
new: OFF
old_passwords: OFF
open_files_limit: 65535
pid_file: /var/lib/mysql/hawaiian-tv.com.pid
port: 3306
preload_buffer_size: 32768
prepared_stmt_count: 0
protocol_version: 10
query_alloc_block_size: 8192
query_cache_limit: 131072
query_cache_min_res_unit: 4096
query_cache_size: 67108864
query_cache_type: ON
query_cache_wlock_invalidate: OFF
query_prealloc_size: 8192
range_alloc_block_size: 2048
read_buffer_size: 67104768
read_only: OFF
read_rnd_buffer_size: 262144
relay_log_purge: ON
relay_log_space_limit: 0
rpl_recovery_rank: 0
secure_auth: OFF
server_id: 0
skip_external_locking: ON
skip_networking: ON
skip_show_database: OFF
slave_net_timeout: 3600
slave_transaction_retries: 0
slow_launch_time: 2
socket: /var/lib/mysql/mysql.sock
sort_buffer_size: 67108856
sql_mode:
sql_notes: ON
sql_warnings: ON
storage_engine: MyISAM
sync_binlog: 0
sync_frm: ON
sync_replication: 0
sync_replication_slave_id: 0
sync_replication_timeout: 0
system_time_zone: MST
table_cache: 32712
table_type: MyISAM
thread_cache_size: 80
thread_stack: 131072
time_format: %H:%i:%s
time_zone: SYSTEM
tmp_table_size: 8388608
tmpdir:
transaction_alloc_block_size: 8192
transaction_prealloc_size: 4096
tx_isolation: REPEATABLE-READ
version: 4.1.22-standard-log
version_comment: MySQL Community Edition - Standard (GPL)
version_compile_machine: i686
version_compile_os: pc-linux-gnu
wait_timeout: 28800+++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++

PHP INFO:


PHP Version 5.2.1


System Linux hawaiian-tv.com 2.6.9-42.0.3.ELsmp #1 SMP Mon Sep 25 17:28:02 EDT 2006 i686 Build Date Mar 4 2007 14:46:57 Configure Command './configure' '--prefix=/usr/local/php' '--enable-safe-mode' '--enable-sockets' '--enable-ftp' '--enable-mbstring' '--enable-dbx' '--enable-dio' '--enable-memory-limit' '--enable-bcmath' '--enable-calendar' '--enable-dbase' '--enable-exif' '--enable-mbregex' '--enable-track-vars' '--enable-soap' '--enable-zend-multibyte' '--enable-dba' '--disable-mbstr-enc-trans' '--with-dom' '--with-bz2' '--with-pear' '--with-ldap=/usr/local/php/dependencies' '--with-xmlrpc' '--with-gd' '--with-openssl' '--with-imap-ssl' '--with-regex=system' '--with-config-file-path=/etc' '--with-apxs2=/usr/sbin/apxs' '--with-gettext=/usr/local/php/dependencies' '--with-jpeg-dir=/usr/local/php/dependencies' '--with-png-dir=/usr/local/php/dependencies' '--with-ttf=/usr/local/php/dependencies' '--with-pgsql=/usr/local/php/dependencies' '--with-mysql=/usr/local/php/dependencies' '--with-mysqli=/usr/local/php/dependencies/bin/mysql_config' '--with-pdo-mysql=/usr/local/php/dependencies' '--with-pdo-pgsql=/usr/local/php/dependencies' '--with-mssql=/usr/local/php/dependencies' '--with-db4=/usr/local/php/dependencies' '--with-freetype-dir=/usr/local/php/dependencies' '--with-iconv=/usr/local/php/dependencies' '--with-iconv-dir=/usr/local/php/dependencies' '--with-gmp=/usr/local/php/dependencies' '--with-t1lib=/usr/local/php/dependencies' '--with-mhash=/usr/local/php/dependencies' '--with-mcrypt=/usr/local/php/dependencies' '--with-zlib=/usr/local/php/dependencies' '--with-expat-dir=/usr/local/php/dependencies' '--with-xsl=/usr/local/php/dependencies' '--with-libxml-dir=/usr/local/php/dependencies' '--with-curl=/usr/local/php/dependencies' '--with-imap=/home/php5/src/dependencies/imap-2006f' '--with-pspell=/usr/local/php/dependencies' '--with-magickwand=/usr/local/php/dependencies' Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php.ini PHP API 20041225 PHP Extension 20060613 Zend Extension 220060519 Debug Build no Thread Safety disabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with eAccelerator v0.9.5, Copyright (c) 2004-2006 eAccelerator, by eAccelerator
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.2.2, Copyright (c) 1998-2006, by Zend Technologies

PHP Credits (http://admincp/server_info.php?=PHPB8B5F2A0-3C92-11d3-A3A9-4C7B08C10000)

Configuration

PHP Core

DirectiveLocal ValueMaster Value allow_call_time_pass_referenceOnOn allow_url_fopenOnOn allow_url_includeOnOn always_populate_raw_post_dataOffOff arg_separator.input&& arg_separator.output&& asp_tagsOffOff auto_append_fileno valueno value auto_globals_jitOnOn auto_prepend_fileno valueno value browscapno valueno value default_charsetno valueno value default_mimetypetext/htmltext/html define_syslog_variablesOffOff detect_unicodeOnOn disable_classesno valueno value disable_functionsno valueno value display_errorsOffOff display_startup_errorsOffOff doc_rootno valueno value docref_extno valueno value docref_rootno valueno value enable_dlOnOn error_append_stringno valueno value error_logno valueno value error_prepend_stringno valueno value error_reporting61356135 expose_phpOnOn extension_dir/usr/local/php/lib/php/extensions/no-debug-non-zts-20060613/usr/local/php/lib/php/extensions/no-debug-non-zts-20060613 file_uploadsOnOn highlight.bg#FFFFFF#FFFFFF highlight.comment#FF8000#FF8000 highlight.default#0000BB#0000BB highlight.html#000000#000000 highlight.keyword#007700#007700 highlight.string#DD0000#DD0000 html_errorsOnOn ignore_repeated_errorsOffOff ignore_repeated_sourceOffOff ignore_user_abortOffOff implicit_flushOffOff include_path.:/php/includes:/usr/local/lib/php:/usr/local/php/lib/php.:/php/includes:/usr/local/lib/php:/usr/local/php/lib/php log_errorsOffOff log_errors_max_len10241024 magic_quotes_gpcOnOn magic_quotes_runtimeOffOff magic_quotes_sybaseOffOff mail.force_extra_parametersno valueno value max_execution_time36003600 max_input_time36003600 memory_limit2000M2000M open_basedirno valueno value output_buffering40964096 output_handlerno valueno value post_max_size5000M5000M precision1212 realpath_cache_size16K16K realpath_cache_ttl120120 register_argc_argvOnOn register_globalsOffOff register_long_arraysOnOn report_memleaksOnOn report_zend_debugOnOn safe_modeOffOff safe_mode_exec_dirno valueno value safe_mode_gidOffOff safe_mode_include_dirno valueno value sendmail_fromno valueno value sendmail_path/bin/sendmail -t -i/bin/sendmail -t -i serialize_precision100100 short_open_tagOnOn SMTPlocalhostlocalhost smtp_port2525 sql.safe_modeOffOff track_errorsOffOff unserialize_callback_funcno valueno value upload_max_filesize5000M5000M upload_tmp_dirno valueno value user_dirno valueno value variables_orderEGPCSEGPCS xmlrpc_error_number00 xmlrpc_errorsOffOff y2k_complianceOffOff zend.ze1_compatibility_modeOffOff
apache2handler

Apache Version Apache/2.0.52 (Red Hat) Apache API Version 20020903 Server Administrator Postmaster@hawaiian-tv.com Hostname:Port vip-hawaii.com:0 User/Group hawaiian-tv(2222)/101 Max Requests Per Child: 4000 - Keep Alive: on - Max Per Connection: 100 Timeouts Connection: 300 - Keep-Alive: 15 Virtual Server Yes Server Root /etc/httpd Loaded Modules core prefork http_core mod_so mod_access mod_auth mod_auth_anon mod_auth_dbm mod_auth_digest util_ldap mod_auth_ldap mod_include mod_log_config mod_env mod_mime_magic mod_cern_meta mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_asis mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_imap mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy proxy_ftp proxy_http proxy_connect mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_fastcgi mod_fpcgid mod_perl mod_python mod_php5 mod_ssl
DirectiveLocal ValueMaster Value engine11 last_modified00 xbithack00



MSSQL Supportenabled Active Persistent Links 0 Active Links 0 Library version FreeTDS
DirectiveLocal ValueMaster Value mssql.allow_persistentOnOn mssql.batchsize00 mssql.charsetno valueno value mssql.compatability_modeOffOff mssql.connect_timeout55 mssql.datetimeconvertOnOn mssql.max_linksUnlimitedUnlimited mssql.max_persistentUnlimitedUnlimited mssql.max_procsUnlimitedUnlimited mssql.min_error_severity1010 mssql.min_message_severity1010 mssql.secure_connectionOffOff mssql.textlimitServer defaultServer default mssql.textsizeServer defaultServer default mssql.timeout6060
mysql

MySQL Supportenabled Active Persistent Links 0 Active Links 1 Client API version 5.0.27 MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/local/php/dependencies/include/mysql MYSQL_LIBS -L/usr/local/php/dependencies/lib/mysql -lmysqlclient
DirectiveLocal ValueMaster Value mysql.allow_persistentOnOn mysql.connect_timeout9090 mysql.default_hostno valueno value mysql.default_passwordno valueno value mysql.default_portno valueno value mysql.default_socket/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sock mysql.default_userno valueno value mysql.max_linksUnlimitedUnlimited mysql.max_persistentUnlimitedUnlimited mysql.trace_modeOffOff
mysqli

MysqlI Supportenabled Client API library version 5.0.27 Client API header version 5.0.27 MYSQLI_SOCKET /tmp/mysql.sock
DirectiveLocal ValueMaster Value mysqli.default_hostno valueno value mysqli.default_port33063306 mysqli.default_pwno valueno value mysqli.default_socket/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sock mysqli.default_userno valueno value mysqli.max_linksUnlimitedUnlimited mysqli.reconnectOffOff


PDO supportenabled PDO drivers sqlite2, sqlite, pgsql, mysql
pdo_mysql

PDO Driver for MySQL, client library version5.0.27
pdo_pgsql

[Gryphon]

I did it exactly as shown there (although the bottom two sections, for "Optional Input" and "Display Page"; there were no instructions for how to set these, maybe that's part of the problem?)
The defaults that are there are fine.

I keep getting the following message in the Manage Users page and at the bottom of the gTeamspeak main configuration page:

in a big black square that looks like a borderless console window.

You have enabled debug mode in advanced options. This is showing you the information that is happening when it is trying to connect to the teamspeak server to access live data via tcp.

This means I can't use any of the plugins and probably cannot auto-ban users from
the Teamspeak server when they are banned by usergroup. (?)

No, that is done by database access and if you can add members ok, they can be banned ok. The advanced options just allow you to do live things to the users like kick and message and obtain whois online information.

The other problem I'm having (probably related to the above one?) is that the Who's Online
part of the product isn't working for me. It's permanently stuck at "0 Active and 1 Inactive Users"
no matter how many people log in to both the site and the voice chat system or how long they stay
logged on. Everything else in both the TS server itself and the product seems to work perfectly so far though.

Yup, that is handled by the tcp connection for live data. You will have to enter a admin username and password to access tcp. The script is pretty smart, it can try and figure out the name and pass on its own and fill those values in automatically, and if it cant it will create a randomly named admin and pass for access. If you still cant access, it is probably due to something blocking the ports on the TeamSpeak server for tcp access. There are tools to determine the accessibility on the TeamSpeak forums.

The most important feature of the script, user access, will work just fine without tcp information. The tcp data is for fluff and fun, and unfortunately setting that up is something you will have to troubleshoot as there is no general fix all solution. There is a lot of information available on the TeamSpeak forums and I think Planet TeamSpeak has a port checking form on their site.

Good luck, thank you for the complements.

[TomJames]

Hey, just wondering if there is any reason this wouldn't show who's on?

https://vborg.vbsupport.ru/external/2008/02/21.png

[Gryphon]

Possibly if you allowed people to register without this system. Login names need to be in a specific format, so you should have an empty TS database and only allow registration through this mod. If you have done that, any another reason escapes me at the moment.

[gdavis480]

how does this mod work? does the server and the site have to be on the same system?

[Gryphon]

No, they can be on separate systems. You need remote access to the database on the TeamSpeak system however.

[jluerken]

Hi Gryphon,

I found a big logic bug in your hack and I hope you can write an update.

Background:
I am running a Teamspeak Server with 3 Virtual Servers (3 different Ports).
The Teamspeak Server is using its own Database.
I've installed two vBulletin Systems now on the Webserver and both vB Installations have
gTeamspeak installed.

Now the problem:
If you have a user called "test" with the id1 on both Servers you cannot delete it for only one.
Also the MANAGE USERS option in the AdminCP shows all users in the database but it should only show Users which use this gTeamSpeak installation, otherwise it could happen that Admins delete or ban the wrong users.

Possible solution:
gTeamSpeak should internally use the following system to store user information:
<username>.<boardid>.<serverport>

All User manage options should then show and use only users where the port matches the one entered in the gteamspeak settings.

I hope you got the problem?
I never thought about this but now where I have this setup I think this could be critial.

Kind regards
jluerken

[jluerken]

Update:

Hi Gryphon,

you should update the product .xml file
<template name="gts_vbnav_navbarlink" templatetype="template" date="0" username="Gryphon" version="1.00"><![CDATA[<td class="vbmenu_control"><a href="gteamspeak.php$session[sessionurl_q]">$vbphrase[gts_vbnav]</a></td>]]></template>
<template name="gts_vbnav_quicklink" templatetype="template" date="0" username="Gryphon" version="1.00"><![CDATA[<tr><td class="vbmenu_option"><a href="gteamspeak.php$session[sessionurl_q]">$vbphrase[gts_vbnav]</a></td></tr>]]></template>

should be
<template name="gts_vbnav_navbarlink" templatetype="template" date="0" username="Gryphon" version="1.00"><![CDATA[<td class="vbmenu_control"><a href="$vboptions[bburl]/gteamspeak.php$session[sessionurl_q]">$vbphrase[gts_vbnav]</a></td>]]></template>
<template name="gts_vbnav_quicklink" templatetype="template" date="0" username="Gryphon" version="1.00"><![CDATA[<tr><td class="vbmenu_option"><a href="$vboptions[bburl]/gteamspeak.php$session[sessionurl_q]">$vbphrase[gts_vbnav]</a></td></tr>]]></template>

Kind regards
jluerken

[Gryphon]

Hi Gryphon,

I found a big logic bug in your hack and I hope you can write an update.

Yeah, I have know about this. The script was never intended to work across multiple boards using the same TeamSpeak database. I really want to just rewrite the entire script.

Update:

Hi Gryphon,

you should update the product .xml file

Thank you. However absolute urls are not standard coding practice for vBulletin templates. As well, I despise absolute urls as it hinders portability and boards with parked domains.

[boxerman]

will this work with 3.7 beta 5?

[Gryphon]

will this work with 3.7 beta 5?

Yes

[shcchief]

nice mod, but yep i'm another user that has multiple boards therefore cannot use it.

will check back in the future for an update.

Thanks.

[socom0810]

i went in the config.php and changed it to 1 and 6 but still when i click plugins that command prompt it says super.admin and a pass but thats not my user nam or my pass where do i enter that at?

[PlymWS]

I have a slight problem with this hack.

I have my TS server running with a MySQL Db fine. The tables are present and when I use the hack to create a user the data is inserted correctly into the tables.

However when I try and connect to the server through the TS client I get a Bad Login error from the client.

If I login using the default admin or superadmin details that were created by TS I log in fine, so the server is running as it should.

It appears that only the plain text stored passwords ( i.e. the ones generated by this hack ) are the ones that can't connect.

I'm using MySQL 5 . Any help on this would be much appreciated as this will be very useful for my forum.

[Gryphon]

@socom0810 I am unsure why it would not be working for just your board.

@PlymWS TeamSpeak only uses plain text passwords, this mod does not do anything differently. First thing that pops to mind is really make sure both are accessing the same database, make sure TS didn't somehow default back to sqlite. I am not sure how mySQL 5 interacts with the script, I don't imagine there should be any issue. If you create a user view the TS client, does that user appear in the database?

[PlymWS]

If I create a user through the TS backend, the user is added to the MySQL DB fine. The password is hashed as it's not the same as the plain text.

If I create a user through the hack that user also appears in the MySQL DB fine and the password is visible in plain text.

However the TS-created user can connect but the hack-created user gets a bad login message.

Other than that the hack works perfectly. I'll investigate this as well and let you know if I get anywhere.

[Gryphon]

Hmm, in mySQL 4.0 TS users are plain text. I know that as of 4.1 there was some password changes, but didn't realize it would affect the TS password field. I will have to look into that.

[PlymWS]

There's MD5 hashing on my passwords for some reason. Possibly a change in MySQL 5.

[PlymWS]

I'm pretty sure this is to do with the way MySQL 5 hashes passwords. Just to make sure if someone could post me their TS install folder, minus server.ini and server.log so I can try with that I would appreciate it.

[jluerken]

There's MD5 hashing on my passwords for some reason. Possibly a change in MySQL 5.

If you get an error about client authentication version when connecting to MySQL then it may be because your server is using the new password format, while your mysql client (or PHP script, or JDBC code) is using the old password format.
See: http://dev.mysql.com/doc/mysql/en/Application_password_use.html


You can change a new password to an old password like this:
bash shell>mysql -u root -p
passwort: rootpw

mysql> USE mysql
mysql> update user set password = old_password('passwordhere') where user = 'teamspeak'; flush privileges;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select user, password from user;
+-------+-------------------------------------------+
| user | password |
+-------+-------------------------------------------+
| root | *BA3E2F47E409A6ABA8AF34A430631A02FE28539E |
| root | *BA3E2F47E409A6ABA8AF34A430631A02FE28539E |
| | |
| | |
| teamspeak | 09a6e3834c6d11c9


This means your teamspeak db is now storing passwords in the old format.
Teamspeak2 needs this to work, it has nothing to do with this hack.

I am quite sure this will work for you.

[PlymWS]

I followed that and got the correct mysql output from the command prompt.

The passwords from the hack are still stored in plain text though and this means they don't connect to the server. I have the following in the database :

tscreateduser - password : 1d427ce2b82bc4e30b2012c6f6df2e6a (tsuser in plain text)
gteamspeakuser - password : tsuser ( stored in plain text )

I'm going to look today at how I might change the PHP to incorporate the new MySQL 5 hashing of passwords.

[jluerken]

There is an option to turn the hashing off. If I am correct its "--disable-hash" but I am not using MySQL 5 and cannot say how this works for a single db.
You can try to check this db with phpMyAdmin and see if you have an option there to turn hashing off.
phpMyAdmin often surprises me which such things :-)

[PlymWS]

I have done the opposite :) I went into phpMyAdmin and used the MD5 function on a plain text password to create a hashed pass. This then works fine. Now to get it to do this automatically with all passwords :)

EDIT:

OK, what I've done is edit gteamspeak.php, Line 98 (password updates) to read
func_gts_query("UPDATE " . $ts2db['name'] . "ts2_clients SET s_client_name = '" . $ts2info['username'] . "', s_client_password = MD5('" . $ts_password . "') WHERE s_client_name = '" . $ts2info['username'] . "' AND i_client_server_id = '" . $ts2db['serverid'] . "'");

and line 114 (initial user setup) to read

func_gts_query("INSERT INTO " . $ts2db['name'] . "ts2_clients SET i_client_server_id = '" . $ts2db['serverid'] . "', b_client_privilege_serveradmin = '" . $sa_status . "', s_client_name = '" . $ts2info['username'] . "', s_client_password=md5('" . $ts_password . "'), dt_client_created='" . $createtime . "'");

so that passwords are MD5 encrypted and sent to the DB. This works but the password is displayed as an MD5 string in the password box and the info page lists the password as the MD5 string. Also the Connect/Quick Connect links don't work as the password is called by the product in plain text.

I can live with this for now as I'll just comment out the references and display some text instead and delete the connect links.

I'll work on this further if anyone else wants these features to work.

[atlambros83]

I'm confused...can I not use this mod if I have a teamspeak server setup somewhere like www.defconservers.com ? I'd really like to incorporate my teamspeak server into my forums if at all possible.

[swissknife]

Is the following plugin possible ?

via cron : Check if the teamspeak-user has a forumaccount, if not: ban from the ts ?

Thank you!

[otstrel]

Any chance to see channel editor?

[molieman]

Could somebody give me directions on how to move the "Current gTeamSpeak Users:" box under the navbar, even if it's a second one.

[berry05]

if i get this does that mean people still have to download teamspeak in order to work it?

[blind-eddie]

if i get this does that mean people still have to download teamspeak in order to work it?

Yes, they still have to download TeamSpeak.

[alqloob alsahya]

thank"s man good jop nice

[Jamesmaps]

I've having the problem that when I enter the password into gteamspeak.php and press go, nothing actually happens. It just loads the page again.

I checked the MySQL database and the user is not inserted. It works fine when adding users through the TeamSpeak web interface.

I'm using PHP5 & MySQL 5

[Kagemaru]

Sadly I can't install this mod, because the change to MySQL isn't working. The options are installing MySQL v3.x somewhere *yuck* or just waiting till TS3 comes out and hope you'll support that too (which is what I will do). :)

* Kagemaru subscribes to thread

[C138 Kaysone]

isnt there an instruction txt file so its easier for us to install?

[Chadi]

Getting this error.

Database error in vBulletin 3.7.2:

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

MySQL Error : Table 'admin***_vbulletin.ts2_clients' doesn't exist
Error Number : 1146
Request Date : Monday, July 14th 2008 @ 01:33:18 PM
Error Date : Monday, July 14th 2008 @ 01:33:18 PM
Script : http://www.talkjesus.com/gteamspeak.php
Referrer :
IP Address : xxxxx
Username : Chad
Classname : vB_Database
MySQL Version : 5.0.xxxxx-community


My server.ini is:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=*****
Hostname=localhost
User_name=*****
Password=*****
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1


The actual new database I created does have the inserted, newly created 6 tables as well. The teamspeak server did start up without errors also.


Maybe this part is my problem:

Enter in the server ID assigned to the server. This can be found in the TeamSpeak database.

Exactly where is this found "in the database"? Is there referring to PID for TS process or something else?

[Chadi]

I'm getting the below error when attempting to connect to my TS:

[17:46:38] No reply from server
Maybe the server is offline
or maybe teamspeak is not running on it

However, the TS server is running

In the firewall, I have these enabled

TCP_IN = 8767,51234,14534
TCP_OUT = 8767,51234,14534

I tried the main server IP and even the IP that the domain is hosted on.

For http port, I also tried 80 default. I have no idea what goes in "server id" anyway

root@server [/home/teamspeak/tss2_rc2]# netstat -nap | grep -i "teamspeak"
root@server [/home/teamspeak/tss2_rc2]# netstat -nap | grep -i "ts"

root@server [/home/teamspeak/tss2_rc2]# netstat -nap | grep -i "ts"
tcp 0 0 0.0.0.0:1 0.0.0.0:* LISTEN 5472/portsentry
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 5472/portsentry
Active UNIX domain sockets (servers and established)
unix 2 [ ] DGRAM 25277568 1049/netstat

I've tried so many variations.

the server IP is its own default main IP 147.202.66.2

The domain (vbulletin forum) is on the same server, but a different IP of 147.202.66.3

I tried port 5472 enabled in the firewall tcp in and out

[PlymWS]

Sadly I can't install this mod, because the change to MySQL isn't working. The options are installing MySQL v3.x somewhere *yuck* or just waiting till TS3 comes out and hope you'll support that too (which is what I will do). :)

* Kagemaru subscribes to thread

I use MySQL 5 with the 3.x and 4.x compatibility libraries and my TS and this plugin work fine for me.

[Roby75]

i've a problem with TS image, with template change is disappeared

see attachment.

[Gryphon]

Make sure to upload the included misc/ images for gTeamSpeak to each style's misc directory. The reason for this system is to allow you to have a different TeamSpeak image per style if you wish.

[LittleB@]

In case you have the time for it:
I tried the "prevent user from registering"-option just now and it seems as long as the user is a member of any allowed user groups he/she is able to register no matter what option I choose in the profile field.

I'm pretty sure I have the correct field name in the configuration so any chance this is generated in the back end? Yes, I am probably the one doing soemthing wrong ^^ Any way, if you got the time I would appreciate if you checked this out.

[butler312]

Would anyone happen to have a simple set of instructions for how to get teamspeak running on my vbulletins database. I have verified with my host that I can do so, but the instructions on teamspeak are just jibberish to me.

[LittleB@]

Would anyone happen to have a simple set of instructions Make sure to provide things like server version and OS when you are looking for that kind of help :)

[K4GAP]

Could this be adapted as easily for those using Ventrilo? There are hundreds if not thousands of gaming groups that use Ventrilo exclusively and would jump on an add on like this for their sites.

[butler312]

Make sure to provide things like server version and OS when you are looking for that kind of help :)

I'm pretty sure the hosting server I'm using is a linux server and my operating system is a Mac OS X.

[LittleB@]

I'm pretty sure the hosting server I'm using is a linux server and my operating system is a Mac OS X.

I guess you would find the information you are looking for simply by searching the www.goteamspeac.com forums, let me know if you cannot find it and I'll do a search myself.

[butler312]

I did search, and I found some explanations, but they don't make any sense to me. It is telling me to do things that I simply have no idea how to do. It gives me commands to use that give me error messages when I try them. It just simply does me no good.

Edit: sorry for the very vague post. I'm not at home right now and don't have time to actually look up and post exactly what was giving me errors and such. I'll post more info on my problem tonight when I get home