vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Integration with vBulletin - gTeamSpeak - TeamSpeak User Management (https://vborg.vbsupport.ru/showthread.php?t=122221)

vbreal 11-13-2006 09:44 PM

going to try this out

sys4096 11-17-2006 12:42 AM

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 11-20-2006 09:24 PM

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:

Code:

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 11-24-2006 08:17 AM

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

FSFwebmaster 11-26-2006 10:06 PM

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 12-23-2006 02:58 PM

Quote:

Originally Posted by frick (Post 1121801)
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:

Code:

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 01-02-2007 01:38 PM

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 01-02-2007 05:14 PM

1 Attachment(s)
Quote:

Originally Posted by Logo (Post 1144026)
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

Quote:

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

Quote:

[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 01-16-2007 05:20 PM

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 01-31-2007 02:53 PM

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


All times are GMT. The time now is 12:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01322 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete