Whos On Teamspeak

[Mephisteus]

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 (http://www.16aa.com)

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 :p 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]

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

[Jason McConnell]

yup, this is cool and no problems encountered

Quick questions before I install: A lot of the file names in the gllcts2_4 folder have corresponding names in my /forum/ directory. Is that where they should be uploaded to?

[twitch]

upload them to any folder you want to create, it will find it as long as it is installed to the same database as vbulletin

[Jason McConnell]

upload them to any folder you want to create, it will find it as long as it is installed to the same database as vbulletin

thanks! :)

[teyron]

Active Servers: 0 | Users Online: MySQL Error in [ SELECT * FROM gllcts2_weblist WHERE clients_current > 0 ]: Unknown column 'clients_current' in 'where clause'

Please contact a the site admin immediately.

i get this after logging into the gglcts scripts admin file, until i fix this i dont intend to go further with the vb xml

[jluerken]

Mehpisteus I have a question.

I managed to install my teamspeak server using MySQL instead of sqlite.
This means that all the data is exactly in the same db like the forum or webpost is using.

At the moment I don't see the need to have Webpost installed then cause now the MySQL DB is anyway storing which user is online and which not or?

Would it be possible to modify your plugin so that there is no need to have Webpost installed?
This means to modify the routine NOT to read from the webpost tables but now diretly from the TS2 MySQL Tables.

I think this is the better way and you can:
1. get rid of Webpost cause its not needed
2. can be the reason because your hack is not working for everyone
3. reduces the security risk on a server cause an app is not installed anymore (webpost)

What do you think?

[:SFA:BlackDog]

Could use some help here from anyone willing.

I've been banging my head against the wall trying to install gllcTS2 on a local test server and getting nowhere. I'm using php v5.1.2 and mySQL v5.8.18-nt and using the zipped files provided by Mephisteus.

I'm running my sql database wide open with username as root and no password (no need for security because nobody can acces the db), SO.. the config file settings look something like this:

$gllcts2_dbhost = "localhost"; // Host
$gllcts2_dbuser = "root"; // Username
$gllcts2_dbpass = ""; // Password
$gllcts2_dbname = "gllcts2"; // Database
$gllcts2_dbprefix = "gllcts2_"; // Prefix for tables

When I try to run the admin/install.php script, however, I keep getting this damned error message!!!!!!!:

Parse error: syntax error, unexpected $end in C:\wamp\www\sfa\gllcTS2\admin\install.php on line 209

Line 209 is the last line of code and I'm not great with debugging html with php in it. I get the feeling I'm using a newer and incompatible version of php, hence the syntax error (or have I missed something obvious?). This is driving me crazy. :-/

I figured it out on my own. I found the more current version 4.2.2 and it worked perfectly with php5