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

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

so, yes. all 5 points without a problem.

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

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.

still needing help...

will this work on 3.5.3?

SQL Error

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

then i get a SQL error

As you see it chops off the db name for some reason !?

Any ideas of whats wrong and can be done ?

*bump*

No one ?

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

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

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

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

Got this

and this

Questions

Where is the button for creating this table
I for sure dont get one

Since you release this with limited support

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

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.

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

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?

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 ?

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.

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

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/fi...online_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?

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.

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

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

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.

Any news on this mod ?

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

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.

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?

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.

going to try this out

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.

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:

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!

This hack is working perfectly, thanks man

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

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?

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

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?

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

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

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

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.

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