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

[Jason McConnell]

Originally Posted by twitch

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]

Originally Posted by 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

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. :-/

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