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)

PlymWS 07-22-2008 04:26 PM

Quote:

Originally Posted by Kagemaru (Post 1567255)
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). :)

[high]* Kagemaru subscribes to thread[/high]

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

Roby75 07-24-2008 07:30 AM

1 Attachment(s)
i've a problem with TS image, with template change is disappeared

see attachment.

Gryphon 07-28-2008 06:29 PM

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@ 08-09-2008 04:14 PM

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 08-13-2008 05:42 AM

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@ 08-13-2008 01:56 PM

Quote:

Originally Posted by butler312 (Post 1597516)
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 08-13-2008 04:07 PM

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 08-13-2008 04:34 PM

Quote:

Originally Posted by LittleB@ (Post 1597792)
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@ 08-15-2008 04:18 PM

Quote:

Originally Posted by butler312 (Post 1597904)
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 08-18-2008 01:18 AM

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

Gryphon 08-18-2008 09:05 PM

Quote:

Originally Posted by GaryT (Post 1597873)
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.

It is very specific to TeamSpeak, it would need a complete re-write. I am not a fan of Ventrilo nor have any personal need for such a project, which is what motivates me to create the mods that I do. I am afraid that someone else will have to fill the void.

Quote:

Originally Posted by butler312 (Post 1597516)
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.

There shouldn't be any need for someone to duplicate here what has been addressed several times at http://www.teamspeak.com

Quote:

Originally Posted by butler312 (Post 1601114)
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.

This mod release is independent from setting up a server. The best place for getting your questions answered will be on the TeamSpeak forums where it is much more likely someone will have the answers.

LittleB@ 09-09-2008 09:54 PM

Hi G, I know you only provide limited support but figured you might have run into the same problem yourself and I was hoping you had a solution.

Thing is when I upgraded my vB to the latest 3.7.3 PL1 I was not able to log in to the forums, all I got was this:

Fatal error: Maximum execution time of 120 seconds exceeded in /**/forum/includes/class_cyts.php on line 1953

I then proceeded with disabling all my plugins to track down the problem and found out that I can have all my plugins activated except your gTeamspeak, would you say this is something that happened only to me or did you have the same problem when you upgraded your forums? (if you did upgrade).

Thnx for any help and above all, for this wonderful mod :)

*Edit*

Seems I am blaming the wrong person here, sorry ;) It turned out that during my recent server migration the mysql addresses in my database were the only thing the support team forgot to change hence the plug-in here tried to connect to the old database server with obvious failure

this rendered me unable to view any page that had gTeamspeak code executed (for example my private forums where I can see whos online on TS atm)

To perhaps help you in maintaining this plug-in perhaps you could look into a way of reporting this error to the user before he finds himself in some mysterious and endless loop? Im no php/mysql programmer but just to give you a hint that the problem can arise and if so you might want to see some kind of message, hope this helps :)

and thnx again for this plug-in, I love it =)

Insanity.TM 09-23-2008 03:59 PM

Datenbankfehler in vBulletin 3.7.3:

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

MySQL-Fehler : Table 'db252288009.ts2_clients' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Tuesday, 23.09.2008 @ 18:53:53
Datum : Tuesday, 23.09.2008 @ 18:53:54
Skript : http://www.fallen-angels-ambossar.de/gteamspeak.php
Referrer : http://www.fallen-angels-ambossar.de/index.php
IP-Adresse : 85.182.9.80
Benutzername : Nubyel?
Klassenname : vB_Database
MySQL-Version : 5.0.51a-log

this ist my error,...

Gryphon 09-23-2008 10:46 PM

Quote:

Originally Posted by Insanity.TM (Post 1628665)
Datenbankfehler in vBulletin 3.7.3:

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

MySQL-Fehler : Table 'db252288009.ts2_clients' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Tuesday, 23.09.2008 @ 18:53:53
Datum : Tuesday, 23.09.2008 @ 18:53:54
Skript : http://www.fallen-angels-ambossar.de/gteamspeak.php
Referrer : http://www.fallen-angels-ambossar.de/index.php
IP-Adresse : 85.182.9.80
Benutzername : Nubyel?
Klassenname : vB_Database
MySQL-Version : 5.0.51a-log

this ist my error,...

You have not setup your TeamSpeak database properly.

Hamednet 09-29-2008 09:39 AM

thanks dear

very nice !

jluerken 10-10-2008 05:22 PM

Hey Gryphon,

its me again :-)
I am using vB 3.7.3pl1 at the moment with the actual version of your addon and have a strange bug.
I am using your hack on two forums with two own teamspeakservers which use the same teamspeak database.
Everything was working for month but today I got a strange error.
People in the database got the passwords from other people in the db.
So far I could not find out how this happened.
Do you have any idea how I can get the correct password again connected to the correct usernames?

jluerken 10-10-2008 06:15 PM

No idea how this happened so far. I can only imagine one of the vbulletin maintenance functions but I don't think that I am right there.

Gryphon I need a db query to do the following:
Delete all passwords from table ts_clients, field s_client_password and b_client_privilege_serveradmin is not -1 and i_client_server_id is 0

Can you help me with this please?

zoomgod 10-18-2008 01:05 PM

I have used this before and it installed easy and worked great on 3.7.3.

Now I brought up another site for a clan also using 3.7.3, problem is when I click on options, who's online or advanced options nothing is there so I can't configure it, anybody have any ideas?

I've re-installed it like 3 times now.

BucWiLd 10-19-2008 11:11 PM

i wish i would be able to install this but i see it is wayyyy to difficult..lol

Gryphon 10-22-2008 05:34 AM

Quote:

Originally Posted by jluerken (Post 1642102)
People in the database got the passwords from other people in the db.

The TeamSpeak account is associated to vBulletin accounts by vBulletin userid. Bob with userid 35 on forum 1 and Jim with userid 35 on forum 2 are going to conflict. There is no way around this at the moment with the way the mod is designed.

Quote:

Originally Posted by jluerken (Post 1642129)
Gryphon I need a db query to do the following:
Delete all passwords from table ts_clients, field s_client_password and b_client_privilege_serveradmin is not -1 and i_client_server_id is 0

Can you help me with this please?

Untested and off the top of my head: DELETE `s_client_password` FROM `ts_clients` WHERE `i_client_server_id` = '0' AND `b_client_privilege_serveradmin` != '-1';

Make a backup, I am not positive.

@zoomgod make sure the TeamSpeak server telnet ports are open.

zoomgod 10-26-2008 03:47 AM

Are you referring to the TCPQuery port or the HHTP port? Either way both and accessible from my PC to the TS server.

Just to clarify the problem, It is step 5 of installing, there is only a blank page for configuration no way to fill in server info. Something seems to be failing on install

EDIT: NM, I just discovered I can set it under vBulletin options, would still be nice if options under gTeamspeak worked though.

thomaskant 10-26-2008 06:10 PM

Hello,

my English is not so good.

I get the MOD not to run. Server.log:
17-05-08 21:59:00, ALL, Info, server, server init initialized
17-05-08 21:59:00, ALL, Info, server, the server version: Linux 2.0.23.19
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_servers
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_server_privileges
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_channels
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_channel_privileges
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_clients
17-05-08 21:59:00, WARNING, Info, SQL, created table ts2_bans
17-05-08 21:59:00, ALL, Info, server, Starting virtual server id: 1 with port: 8767
17-05-08 21:59:00, ALL, Info, server, virtual server Started id: 1 with port: 8767
17-05-08 21:59:00, WARNING, Info, SERVER, default virtual server created
17-05-08 21:59:00, WARNING, Info, SERVER, admin account info: username: admin password: XXXXXX
17-05-08 21:59:00, WARNING, Info, SERVER, super admin account info: username: super admin password: XXXXX
17-05-08 21:59:06, ALL, Info, server, server finished init
17-05-08 21:59:06, WARNING, Info, server, Teamspeak server daemon activated
17-05-08 22:32:45, ALL, Info, server, server shutdown initialized
17-05-08 22:32:45, ALL, Info, server, virtual server Stopping id: 1 with port: 8767
17-05-08 22:32:46, ALL, Info, server, Virtual Server Stopped id: 1 with port: 8767
17-05-08 22:32:48, ALL, Info, server, server shutdown finished

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=XXX
Hostname=localhost
User_name=XXX
Password=XXXX
GetDriverFunc=getSQLDriverMySQL
VendorLib=libmysql.dll
LibraryName=dbexpmda.dll
Active=1
***********
Mysql 5

My TS IP: 87.106.94.90:7777

I ask for help if possible in German.

MFG thank Thomas

Gryphon 10-30-2008 04:59 PM

@zoomgod Sorry, I see what you mean now. I did not understand before. I am not sure why those option links are not working. I will look into it, it appears that vBulletin changed something in their nav menu system that is breaking the links.

ViperMaul 11-15-2008 05:48 AM

Hi Grypon,

This has been a great tool for us for many months now.
However, we have started receiving the following error when we click on
Manage Users from the gTeamSpeak section of the admin Control Panel if you wait for a very long time...

Code:

Database error in vBulletin 3.7.1:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110
/home/theatreo/public_html/devforums/includes/class_core.php on line 311

MySQL Error  :
Error Number  : 0
Request Date  : Friday, November 14th 2008 @ 12:39:17 PM
Error Date    : Friday, November 14th 2008 @ 12:43:47 PM
Script        : http://www.theatre-of-war.com/devforums/admincp/gteamspeak.php?do=manageusers
Referrer      : http://www.theatre-of-war.com/devforums/admincp/index.php?do=nav
IP Address    : {masked}
Username      : {7}Maj.ViperMaul
Classname    : vB_Database
MySQL Version : 5.0.51a-community-log

Do you have any ideas on how to trouble shoot this?
I need a super hero to help me solve this.
Its probably my server host. We shall see.

zoomgod 12-02-2008 01:42 PM

Thanks for fixing the navigation, works great now!
I'm sure that will help avoid some others being confused lol

Scathefire 12-10-2008 07:11 AM

just curious, do you have plans on updating this for teamspeak 3 when it (finally) arrives?

Shawn385 12-15-2008 05:00 PM

Seems TS doesn't like working with libmysqlclient_r15.0.0...dang would love to use this but it wont start the server for me.

After reading a TON of these errors in other forums I finally got the TS to work with MYSQL, but now it wont let me login in backend as the admin. It lets me in a superadmin but when I go to edit a server ( name and so forth ) it tells me my server is invalid.

fgforty2` 12-19-2008 03:17 AM

Quote:

Originally Posted by Scathefire (Post 1682174)
just curious, do you have plans on updating this for teamspeak 3 when it (finally) arrives?

I'm hoping he does. It looks like there will be a bit more MySQL support for 3. I want to install this mod but library issue thing is a turn off.

Gryphon 12-19-2008 10:37 PM

Yes, though it will most likely be a complete rewrite.

Sanjiyan 12-31-2008 02:07 PM

1 Attachment(s)
Hi there, I am running VB 3.7.2, with TS in mysql, the mysql database for TS, is hosted on the same mysql server, but in a different database than vBulletin

As such, it doesnt work.

I do not have any graphics on the TS register screen, it says:
User Name: ranko.1
Password:
Not encrypted, do not use your forum password.

Enter the password, press Go it refreshes and nothing else. (there is no graphic on the screen), even if its in the style image misc folder.

-----

Now on the admincp side of it, it is setup.
Please see attachments, as they better explain it I think (I've enabled the debug information).

So, image1 shows the manage users, as you can see theres an error displayed this I think is the root cause of my entire problem.

Image5, lists the remote database, now I can remotely access the MySQL database server using Navicat, the user for the TS database itself allows remote access etc.

As you can see from all the screenshots they all display the same error type:

Array
(
[0] => Array
(
[cmd] =>
[rpl] => [TS]

)

[1] => Array
(
[cmd] => SEL 8767
[rpl] => OK

)

[2] => Array
(
[cmd] => SLOGIN
[rpl] => ERROR, invalid paramcount

)

)

My server details:

CentOS 5.2
Apache 2
MySQL 5.0.45
PHP 5.2.6
TS 2 (latest build from goteamspeak)

Cybershaolin 01-10-2009 01:23 AM

This mod is really cool. Works very well with 3.6.8 too.

One question: How could I add a instant messaging icon for TS, as for MSN, Skype, etc when viewing our profiles?

Cybershaolin 01-12-2009 05:12 PM

No idea folks?

Gryphon 01-12-2009 05:24 PM

This probably isn't the place to discuss that. Also, what would you link such a profile field to or what would you display as a username? TS doesn't really work like MSN, Skype etc.

Cybershaolin 01-12-2009 05:52 PM

Thinking about it, you're right! :) Thanks for your answer.

Cybershaolin 01-12-2009 06:16 PM

BTW I would have two more questions:

1- I've noticed even if I have setted up the permissions for server and channel admin, once in Teamspeak, I cannot op or voice any regular registered user. Is this caused by TeamSpeak itself or by the hack?

2- I have some users who log in but they have a "Guest01" or Guest02" nicknames! How can that happen? Does it mean they got the login info by somebody else? Is there a way tp prevent this? It's because those are not supposed to be able to access TS...

Gryphon 01-14-2009 09:57 PM

1. I am not positive, there are a few ways this could happen. You simply aren't logging in with an user that doesn't have permission, or you have setup your TeamSpeak's own permissions to not allow it. It isn't anything in this mod, just a setting that you are overlooking.

2. They just aren't filling in their name they want. They are still assigned to vBulletin accounts, but TeamSpeak usernames can still be anything they want, they are separate from the login name.

Cybershaolin 01-15-2009 01:14 AM

1 Attachment(s)
1- Well, I'm logged as a server and channel admin. According to the permissions I have setup, I would supposed to be able to grant permissions to op or voice other registered users but when I right click on a user, the options are grayed out as you can see on all the pictures included.

So, you are saying it does not anything to do with this mod, is that it?

2- I'm not sure to understand the way you've explained it sorry.

Gryphon 01-15-2009 02:39 AM

1. I am not sure why they are grayed out, this mod can't do anything about that, the user you are logged in as doesn't have permission by some TS setting not readily apparent. You have SA next to your name when you login?

2. step 5 of the registration process, they are not entering their Nickname, Guest is the default for TS users who do not enter a name. They still need to use step 7 and 8 assuming that you have passworded your server to something random, otherwise people can still join without registering. Only one login can be used at a time, no two people can use the same login at the same time. If you right click their name and look at the connection info, you can see the login id.

Cybershaolin 01-15-2009 04:10 AM

1- Yes, SA and CA are next to my nickname...

2- OK I got it for that. Thanks.

Gryphon 01-15-2009 04:26 AM

I am afraid I am not sure why you do not have the options available.


All times are GMT. The time now is 01:08 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.01675 seconds
  • Memory Usage 1,849KB
  • 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
  • (1)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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