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)

Cybershaolin 01-15-2009 05:02 AM

If I find out why and/or how to resolve this, I'll let you know... Thanks for trying to help about this issue. I find it weird but I'll investigate...

Dekard 01-20-2009 04:21 PM

Quote:

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

I would love to see this feature too. Perhaps in the version 3 updates.

Quote:

Originally Posted by Cybershaolin (Post 1712979)
If I find out why and/or how to resolve this, I'll let you know... Thanks for trying to help about this issue. I find it weird but I'll investigate...

This is almost certainly a permissions issues within TeamSpeak. You would fix this at the TeamSpeak webadmin.

Cybershaolin 01-21-2009 05:48 PM

Have you look at the screenshots in post #277? All permissions are set... but it just does not work.

Dekard 01-21-2009 07:15 PM

Cyber, have you tried deleting the TS files & DB from your server and starting over? Perhaps there's some corruption you can't account for.

HaS?R 01-28-2009 05:41 PM

Thanks.

LeatherNeck 02-20-2009 10:25 AM

1 Attachment(s)
Excellent work, working like a charm on 3.8.1:D

Hope it's ok, but a lot of people have trouble getting TS to work on linux with mysql, so here is how I did it (tested on Centos5 and mysql 5 ;) )

Add the following to the very bottom of your server.ini
Code:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=*************
Hostname=127.0.0.1
User_name=**********
Password=*****************************
GetDriverFunc=getSQLDriverMYSQL
VendorLib=FULL/SERVER/PATH/TO/LIBS/libmysqlclient_r.so.10.0.0
LibraryName=FULL/SERVER/PATH/TO/LIBS/libsqlmy.so
Active=1

WITH THIS YOU NEED TO RUN AT THE MYSQL PROMPT
mysql>
Code:

SET PASSWORD FOR
'TheTSdbUser'@'localhost' = OLD_PASSWORD('***************');

ATACHED ARE THE LIBS NEEDED TO CONNECT TO MYSQL

Cybershaolin 02-20-2009 12:01 PM

Quote:

Originally Posted by Dekard (Post 1720417)
Cyber, have you tried deleting the TS files & DB from your server and starting over? Perhaps there's some corruption you can't account for.

Yes tried that but still the same. Am I the only one with this problem?

LeatherNeck 02-20-2009 05:39 PM

Cyber, have you tried logging into the Web Admin of TS and checking what permissions are set for the user groups?

Cybershaolin 02-20-2009 06:23 PM

Yes, as you can see in post here: https://vborg.vbsupport.ru/showpost....&postcount=277

Does your permissions work for yourself? I mean can you put people Operator or Voice?

LeatherNeck 02-20-2009 07:10 PM

After a little investigation, it would seem that this is a TS2 issue, hopefully the upcoming release of TS3 will sort all this out.

Certainly not an issue with the mod.

Cybershaolin 02-20-2009 07:20 PM

OK thanks for having looked at this. I was under the impression that I was alone having this issue.

Just one more question: By investigation what do you mean? You asked the TS guys or you saw by yourself that you had the same problem than me?

LeatherNeck 02-20-2009 07:25 PM

No worries ;)

Quote:

Originally Posted by Cybershaolin (Post 1750119)
By investigation what do you mean? You asked the TS guys or you saw by yourself that you had the same problem than me?

Both, and also chatting with a few friends that are far more advanced than me and code in thier dreams.:)


It appears that you have done everything right and the problem is with the server application not the user ;)

Cybershaolin 02-20-2009 08:56 PM

Thanks bud.

Brandje 02-23-2009 06:31 PM

Quote:

Originally Posted by LeatherNeck (Post 1749799)
Excellent work, working like a charm on 3.8.1:D

Hope it's ok, but a lot of people have trouble getting TS to work on linux with mysql, so here is how I did it (tested on Centos5 and mysql 5 ;) )

Add the following to the very bottom of your server.ini
Code:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=*************
Hostname=127.0.0.1
User_name=**********
Password=*****************************
GetDriverFunc=getSQLDriverMYSQL
VendorLib=FULL/SERVER/PATH/TO/LIBS/libmysqlclient_r.so.10.0.0
LibraryName=FULL/SERVER/PATH/TO/LIBS/libsqlmy.so
Active=1

WITH THIS YOU NEED TO RUN AT THE MYSQL PROMPT
mysql>
Code:

SET PASSWORD FOR
'TheTSdbUser'@'localhost' = OLD_PASSWORD('***************');

ATACHED ARE THE LIBS NEEDED TO CONNECT TO MYSQL

I have done exactly the same on my server, and it works, now im moving servers, copied all files from my old server, changed the database user / pass, en now i get:
Code:

-------------- log started at 23-02-09 15:29 -------------
---------------------------------------------------------------
23-02-09 15:29:57,ALL,Info,server,        Server init initialized
23-02-09 15:29:57,ALL,Info,server,        Server version: 2.0.24.1 Linux
23-02-09 15:29:57,ERROR,All,SQL,        Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
23-02-09 15:29:57,ERROR,All,SERVER,        Start_Server: unable to open database
----------------------------------------------------------

I am 100% sure my user/pass is correct, and my config and files are eactly the same as my old working server.

any idea what i could be missing?

FFTFTCEd 02-23-2009 11:46 PM

I'm confused a bit, my TS is not on the same server as my vB, it is hosted by a third party and I do not have access to the server.ini to edit.

My confusing is that in your Features list it says;
  • Optionally connect to a remote TeamSpeak database if TeamSpeak is not hosted on the same db as your vBulletin.

Yet under Support it says;

For best results and performance, have your TeamSpeak server use your vBulletin database as it's database.


Then you have the Setup mySQL info which ends with;
Make sure these tables exist and that your TeamSpeak server is actively using your mySQL database properly before even downloading the gTeamSpeak modification.

So my question is, can I use your mod or not, it seems that in the feature it would fit my need, yet later it says I must edit the files or not to download.

Thank you for your comments and mod, I hope it can work for my site.

Gryphon 03-04-2009 06:43 PM

RE: Optionally connect to a remote TeamSpeak database...;
If you have purchased TeamSpeak hosting from a voice comm service provider, it is highly unlikely they will grant you database access.

RE: For best results and performance...;
If they share the database it doesn't have to make a slow external connection.

RE: Make sure these tables exist...;
By default TeamSpeak does not use a MySQL database, this is something people who host their own TeamSpeak servers do before even downloading the mod. On top of that, if the MySQL database is remote, you have to take steps to know the authentication information and you have to add the ip of the requesting service to MySQL.

This requirement ensures that the user has at least completed the necessary steps unrelated to this mod, because without them this mod will just add confusion.

FFTFTCEd 03-04-2009 06:58 PM

so.... the answer is no then.

Perhaps you should add your first response (If you have purchased TeamSpeak hosting from a voice comm service provider, it is highly unlikely they will grant you database access.) to the Features list so that ppl in my position are not downloading the mod by mistake.

But thank you for your hard work & mod anyway,
Ed

relaxiha 03-14-2009 08:31 AM

does not work in .8.1?

Gryphon 03-14-2009 09:24 AM

Works fine, not much about it should be version dependent.

LeatherNeck 03-14-2009 12:57 PM

Quote:

Originally Posted by relaxiha (Post 1767710)
does not work in .8.1?

in reply to your pm m8


Quote:

hello
may you help me for install gTeamSpeak - TeamSpeak User Management ?
i can't install
You have
Quote:

VendorLib=/usr/lib/libmysqlclient_r.so.10.0
LibraryName=./libsqlmy.so
you need to change this to:

Example:

Quote:

VendorLib=/home/relaxiha/tss2_rc2/libmysqlclient_r.so.10.0 (the EXACT location on your server)
LibraryName=/home/relaxiha/tss2_rc2/libsqlmy.so the EXACT location on your server)

This works perfectly in 3.8.1, but as i stated, I am running this on CENTOS 5 and mysql 5

relaxiha 03-15-2009 09:37 PM

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 '[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=relaxiha_vb
Hostname' at line 1

relaxiha 03-18-2009 03:40 AM

please help me.
this hack is little troublesome

Hoegaarden 03-23-2009 03:13 AM

Hi, I'm having the issue that a number of people have had--namely, when entering the password on the signup form, it simply refreshes and does nothing else. Nothing is showing in the navbar, and it's not adding the quicklink. I've verified that it's connecting to the DB, because entering incorrect info results in an error.

Has any solution been found to this? Is this a general error that could have a number of underlying causes? How can I go about trying to troubleshoot this? I have no problem with PHP code, so adding extra error logging wouldn't be a problem, but something as large and complex as vBulletin isn't something I want to try to debug.

Skyrider 04-29-2009 04:08 AM

I just wanted to ban someone through the "manage users", and got this error:
Quote:


Invalid SQL:
UPDATE userfield SET 0 = 'no' WHERE userid = '3086';

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 '0 = 'no' WHERE userid = '3086'' at line 1
Great plugin though!

jchamber2010 05-05-2009 11:41 PM

Teamspeak wasn't ment to be used on the newer versions of MySQL, therefore you'll need to find version (i think) 3.x in order for teamspeak to cooperate with it, but then the new version of php doesn't like to communicate with anything but the newest version of MySQL so your sorta between a rock, and a hard place, sorry to say

-John

sinistergaming 06-08-2009 06:15 PM

doews this work on a ts server hosted on windows box ?

icewarp 07-08-2009 06:35 AM

When my TS down, my site index never loading and CPU go to 99% of process...

Only solution is disable addon in AdminCP.

relaxiha 07-13-2009 12:45 AM

Hello.
I think update be here.
installed because it is very hard and a proper training.
The 21 pages and talk to me.
I think if this part of the Update and training with a general and complete explanations by the first.
It is more than what is welcomed by villages will be

TheHardest 07-17-2009 05:33 PM

I got myself a new vps because the webhost I was using had no support for what I wanted to do.

So I had to start over. Created a database etc without 1 problem. I did use the same db as the forums. Everything is working fine.

I only want one thing to add. Or like to know where I could do it myself.
Now the nickname that the forum gives you is the forum name. But I would like to add some tags in front of the forum name. Depending on what Usergroup they are in.


===Edit===

Is there an option to give CA for a Usergroup? I know there is something like that for SA.





Quote:

Originally Posted by sinistergaming (Post 1825872)
doews this work on a ts server hosted on windows box ?

Yes. Look at the install file in the folder where your ts server is installed.

jujubins 07-23-2009 02:36 PM

Can you convert the code to run on sqlite for localhost?

Skyrider 08-26-2009 04:54 PM

I just wanted to say that this plugin is causing a small lag issue on the front mainpage of the forums. Which delays the loading of the sites by a few seconds or less.

Dekard 11-10-2009 04:45 PM

I just wanted to let you know that I'm using this on a regular basis and its quite lovely. We're planning on migration to 4.0 when its released and I'd love to see this product make its way over to the new version. I hope you have time to work on it. Thanks!

Gryphon 11-11-2009 05:27 PM

It should work ok with 4.0. If it doesn't, I will probably only fix it if there are simple issues.

If it is very broken with 4.0 I will probably be focusing on developing for TeamSpeak 3 which will available soon, this mod will likely need to be redesigned from the ground up...if needed at all.

Desiderius 12-19-2009 09:22 AM

At the moment its not working.

I get this errors

Code:

Warning: fetch_template() calls should be replaced by the vB_Template class in [path]/includes/functions.php on line 3889

Parse error: syntax error, unexpected T_STRING in /var/www/.../gteamspeak.php(69) : eval()'d code on line 1

Warning: fetch_template() calls should be replaced by the vB_Template class in [path]/includes/functions.php on line 3889

Warning: fetch_template() calls should be replaced by the vB_Template class in [path]/includes/functions.php on line 3889

Warning: fetch_template() calls should be replaced by the vB_Template class in [path]/includes/functions.php on line 3889

Warning: fetch_template() calls should be replaced by the vB_Template class in [path]/includes/functions.php on line 3889


SirShaw 12-22-2009 01:59 AM

teamspeak 3 is out now, will this mod be converted to support it?

SteveLV702 12-22-2009 02:43 AM

Quote:

Originally Posted by SirShaw (Post 1935096)
teamspeak 3 is out now, will this mod be converted to support it?

I sure hope its converted for TeamSpeak 3 and vBulletin 4 support

alpha.cccp 12-22-2009 08:09 AM

Yeah the new TS3 user management system is COMPLETELY different. Every client has a unique ID, which makes it impossible to create accounts for an individual user. This is kind of silly to me because...you used to be able to lock your server and make a user registration form ( which what this mod basically did ) now you can still lock the server, but users no longer have passwords associated with their accounts ( even though there is a client_password table in the database ) instead, the permissions to the server are associated with the unique ID issued by the client. This makes me wonder if a TS3 registration mod is even possible to make for vBulletin.

The new system uses server side created token that have to be manually used by the client. On the client side you click "Use Token" and use the token given to you by the server, it associates itself with your unique ID and you no longer need the server pass to get in...however, you still need to get into the server to use the token...so I'm slightly lost. You can no longer lock the server and create individual accounts, because you have to give the password out in order for users to even be able to register...

Software is great, but the new user/permissions system is super retarded. I want to see where this can do with vB.

SirShaw 12-24-2009 04:15 AM

you would think they would offer a legacy mode or something for teamspeak 3. I know on mine I have the permissions set pretty tight. I give kudos to them for reworking a lot of the issues that plagued teamspeak 2 but its still not perfect. maybe they will add something later for us running mods such as this at a later date. I know I would hate to have to completely rework this mod :-\

Cybertims 01-04-2010 06:02 PM

Quote:

By default TeamSpeak uses a file system called SQLite. To make it use a mySQL database edit the server.ini and add:
What server.ini?

Cheers

Scathefire 01-05-2010 12:26 PM

Quote:

Originally Posted by alpha.cccp (Post 1935250)
This makes me wonder if a TS3 registration mod is even possible to make for vBulletin.

You could have a field in vbulletin for a user to paste their unique ID from TS3. So a user takes their ID from the TS3 client, then goes to vbulletin site running the mod and pastes in the string: 'h2FKENkbE7MVtISAKLc8O5tmyUi=' into a profile field.

Then I'd imagine you could use the new serverquery stuff in TS3 to manipulate clients into whatever client groups/permission settings you want, via checking usergroups in vbulletin. As well as enforcing some sort of 'reserved' nickname system.


All times are GMT. The time now is 11:34 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.01539 seconds
  • Memory Usage 1,842KB
  • 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
  • (6)bbcode_code_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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