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)

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


All times are GMT. The time now is 05:50 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.01469 seconds
  • Memory Usage 1,746KB
  • 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
  • (3)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