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.


All times are GMT. The time now is 12:41 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.01221 seconds
  • Memory Usage 1,740KB
  • 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
  • (4)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