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)

Gryphon 02-01-2007 03:55 PM

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

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

Chadi 02-20-2007 01:09 AM

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

Gryphon 02-20-2007 05:11 AM

Just remove them like any other user profile.

ringoflight 03-02-2007 03:42 PM

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 03-02-2007 04:23 PM

Doubtful it uses mySQL to interface with accounts and passwords.

jluerken 03-07-2007 08:09 AM

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

Quote:

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 03-07-2007 08:22 AM

Ok here we go:

This is the old table

Quote:

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

Quote:

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

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 03-07-2007 08:44 AM

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 03-07-2007 01:49 PM

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 03-08-2007 06:21 AM

Importing v 3.2.0 brings this error

Quote:

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 03-08-2007 02:24 PM

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 03-08-2007 02:49 PM

Quote:

Originally Posted by Blackjack (Post 1198811)
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 03-08-2007 03:31 PM

You will not lose existing TeamSpeak user data by uninstalling.

jluerken 03-08-2007 03:36 PM

Quote:

Originally Posted by Blackjack (Post 1198851)
You will not lose existing TeamSpeak user data by uninstalling.

I tried but the error is still coming up

TheBlackPoet 03-08-2007 05:19 PM

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 03-08-2007 06:24 PM

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 03-13-2007 12:33 PM

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 03-13-2007 03:07 PM

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 03-15-2007 08:52 AM

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 04-22-2007 06:55 AM

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 04-22-2007 08:08 AM

Quote:

Originally Posted by scan-pa (Post 1233192)
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 04-22-2007 01:15 PM

Quote:

Originally Posted by jluerken (Post 1233221)
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

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 04-22-2007 01:29 PM

Quote:

Originally Posted by scan-pa (Post 1233339)
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 04-22-2007 01:34 PM

Quote:

Originally Posted by jluerken (Post 1233346)
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 04-22-2007 08:24 PM

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 04-22-2007 08:56 PM

Quote:

Originally Posted by Blackjack (Post 1233594)
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 04-22-2007 10:27 PM

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 04-24-2007 12:24 AM

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 04-24-2007 01:15 AM

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 04-24-2007 05:22 PM

Quote:

Originally Posted by Blackjack (Post 1234387)
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 05-08-2007 09:05 PM

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 05-09-2007 05:50 PM

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 05-10-2007 04:05 PM

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 05-10-2007 05:39 PM

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 05-11-2007 08:21 AM

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 05-11-2007 09:37 AM

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 05-11-2007 06:16 PM

Quote:

Originally Posted by dooch (Post 1245460)
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.

Quote:

Originally Posted by Elite-Programs (Post 1245480)
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 05-12-2007 03:50 AM

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 05-12-2007 07:31 AM

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


All times are GMT. The time now is 12:54 PM.

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.01375 seconds
  • Memory Usage 1,848KB
  • 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
  • (15)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