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)

SocialNetworkBuzz 09-29-2007 09:33 AM

I downloaded 10.0.0 and now that loads. But it is still failing. Now I receive DatabaseError.dbExpress Error: Invalid Username/Password but the .ini settings
are the same as my vbulletin config file.

SocialNetworkBuzz 09-29-2007 09:34 AM

1 Attachment(s)
for anyone who doesn't have 10.0.0 on your server..

jluerken 09-30-2007 05:26 AM

Hi Gryphon,

I am using your hack now for a few month and its great.
I found out that people register to use the teamspeak, but never write a forum thread/post.

It would be nice to add a feature to this hack that checks this.

Example:
Group A must have X threads/posts within Y days.
If a user tries to connect to the teamspeak server the hack should check if the set minimum thread/post value for the set timeframe is reached and allow/disallow access.

Do you think you can integrate this?

jluerken 09-30-2007 05:27 AM

Quote:

Originally Posted by Stabatha (Post 1349465)
I downloaded 10.0.0 and now that loads. But it is still failing. Now I receive DatabaseError.dbExpress Error: Invalid Username/Password but the .ini settings
are the same as my vbulletin config file.

Which MySQL Version do you have?
If 4.1x or higher pls. check that you set the old password hashing method for the teamspeak database cause the teamspeak libraries cannot handle the new system.

SocialNetworkBuzz 09-30-2007 06:50 AM

Quote:

Originally Posted by jluerken (Post 1350010)
Which MySQL Version do you have?
If 4.1x or higher pls. check that you set the old password hashing method for the teamspeak database cause the teamspeak libraries cannot handle the new system.


How do you do that? Yes, I'm using 4.1.22

Gryphon 10-01-2007 10:14 PM

Quote:

Originally Posted by jluerken (Post 1350007)
Group A must have X threads/posts within Y days.

Do you think you can integrate this?

Options added.

jluerken 10-02-2007 05:08 PM

Quote:

Originally Posted by Stabatha (Post 1350048)
How do you do that? Yes, I'm using 4.1.22

If you get an error about client authentication version when connecting to MySQL then it may be because your server is using the new
password format, while your mysql client (or PHP script, or JDBC code) is using the old password format. See: http://dev.mysql.com
/doc/mysql/en/Application_password_use.html.

You can change a new password to an old password like this:
bash shell>mysql -u root -p
passwort: rootpw

mysql> USE mysql
mysql> update user set password = old_password('passwordhere') where user = 'teamspeak'; flush privileges;
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select user, password from user;
+-------+-------------------------------------------+
| user | password |
+-------+-------------------------------------------+
| root | *BA3E2F47E409A6ABA83D219D70631A02FE28539E |
| root | *BA3E2F47E409A6ABA83D219D70631A02FE28539E |
| | |
| | |
| teamspeak | 09a6e3834c6d11c9 |
+-------+-------------------------------------------+
5 rows in set (0.00 sec)


In this case root has a new, longer password. While the teamspeak user has the shorter, old password format. In PHP something like mys
ql_connect('localhost', 'teamspeak', 'passwordhere') should now successfully create a connection.

Replace "teamspeak" with the user you start your teamspeak server with.

Attention:

1. Never use ROOT to start your teamspeak server
2. Always update teamspeak with the latest server library
3. This is basic teamspeak knowledge and has nothing to do with this hack.
4. Don't forget to change some .sql statement if you use teamspeak with mysql instead of the sqllite system, otherwise it will not work

Get your teamspeak running before you install this hack!

jluerken 10-02-2007 05:11 PM

Quote:

Originally Posted by Gryphon (Post 1351017)
Options added.

Great news, thanks.
I will test the update later on and give you Feedback gryphon

Gryphon 10-02-2007 05:21 PM

vBulletin also has tools which could have been used as well to manipulate access control without these added options. By creating a usergroup which has access to the teamspeak signup and then create a usergroup promotion with the post/reputation/days registered ect. to promote them to that usergroup.

But it was only 10 lines of code I had already done for another project so it was a simple update ;)

jluerken 10-02-2007 10:04 PM

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


All times are GMT. The time now is 01:23 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.01381 seconds
  • Memory Usage 1,745KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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