Whos On Teamspeak

A port of https://vborg.vbsupport.ru/showthread.php?t=93798
Hack name: Whos On Teamspeak
Version: 1.01
Author: Mephisteus (DarkSSJ3)

Steps:
1 product import
1 template edit
1 style edit

Info:
A simple yet effective way of showing who is on teamspeak, it updates every 5 minutes. You must have gllcts2_4.1.7 or similar installed.

Features
- Display unknown users (known users are still linked)
- If a user has micofone(/speakers) muted or is on status away it will be displayed in the area.

MAKE A BACKUP
I will not be held responsible for any damage this hack causes to your forum.
This hack is NOT supported. If you get support, consider yourself lucky.
I reserve the right to REMOVE the hack at any time without prior notice.

Please keep any bug reports in this thread.

This hack was made by me for the 16 Air Assault Brigade

History
1.01
Fixed a bug that would cause users online on the forums to display empty if teamspeak was empty due to a misassigned variable

if ($activeusersts == '') {
	$activeusersts = "No people online";
}

1.00
Initial release

[jluerken]

Great but I am missing the .sql File in the gllcts2_4.1.7 package to create the necessary tables.

Could you post this here please?

[twitch]

kickass!

but I get this error

Invalid SQL:

	SELECT user.username,userfield.field23,usergroup.orderid,user.userid,gllcts2_user.pl_nickname,gllcts2_user.pl_playerflags,gllcts2_user.server_timestamp 
	FROM gllcts2_user AS gllcts2_user
	LEFT JOIN vb3_user AS user ON(user.username=gllcts2_user.pl_nickname)
	LEFT JOIN vb3_usergroup AS usergroup ON(usergroup.usergroupid=user.usergroupid)
	LEFT JOIN vb3_userfield AS userfield ON(userfield.userid=user.userid)
 	WHERE gllcts2_user.server_timestamp>=1129321357
	ORDER BY usergroup.orderid DESC, gllcts2_user.pl_nickname;

MySQL Error  : Unknown column 'userfield.field23' in 'field list'
Error Number : 1054
Date         : Friday, October 14th 2005 @ 03:28:37 PM
Script       : http://www.s2tg.com/forum/
Referrer     : http://www.s2tg.com/
IP Address   : XXXXXXXXXXXX
Username     : |s2tg|twitch
Classname    : vb_database

[Mephisteus]

Wups, mistake Fixed

@jluerken

It has an installer. Read the readme.txt from gllcTS

To Install:
1. Open admin/config.php.new in notepad and enter your database information and
and save as admin/config.php

2. Upload all files to server and run the admin/install.php script from the browser
and follow the prompts.

3. Open your TeamSpeak server admin panel and choose "Server settings" from
the menu and set the PostUrl to your webpost.php and (optionally) LinkUrl to
your home page.

Server WebPost PostUrl: http://www.yoursite.com/webpost.php
Server WebPost LinkUrl: http://www.yoursite.com

4. It will take several minutes for your server to be displayed.

5. To change your webpost settings, go to
http://www.yoursite.com/admin

[jluerken]

After importing the .xml File forumhome cannot be displayed anymore.

[Mephisteus]

Whats the error?

[jluerken]

Originally Posted by DarkSSJ3

Whats the error?

No error message at all. Simply every link to forum home is not working anymore what makes the board complety inoperative.

[Mephisteus]

Every link isnt working anymore? I just reinstalled from the steps listed here and have encountered no problems. If you want I can have a look at it directly?

[Floris]

Nice stuff buddy tnx for sharing.

[twitch]

yup, this is cool and no problems encountered