vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Whos On Teamspeak (https://vborg.vbsupport.ru/showthread.php?t=98402)

Mephisteus 10-13-2005 10:00 PM
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
Code:
if ($activeusersts == '') {
        $activeusersts = "No people online";
}
1.00
Initial release

jluerken 10-14-2005 06:58 PM
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 10-14-2005 07:19 PM
kickass!

but I get this error

Code:
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 10-14-2005 08:43 PM
Wups, mistake :p Fixed

@jluerken

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

Quote:
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 10-15-2005 10:27 AM
After importing the .xml File forumhome cannot be displayed anymore.

Mephisteus 10-15-2005 02:56 PM
Whats the error?

jluerken 10-15-2005 04:12 PM
Quote:
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 10-15-2005 04:40 PM
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 10-15-2005 05:15 PM
Nice stuff buddy :) tnx for sharing.

twitch 10-15-2005 08:37 PM
yup, this is cool and no problems encountered

Jason McConnell 11-10-2005 03:19 PM
Quote:
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 11-10-2005 08:30 PM
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 11-11-2005 04:27 AM
Quote:
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 01-09-2006 09:07 PM
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 01-18-2006 06:33 PM
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 01-26-2006 02:01 AM
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]


All times are GMT. The time now is 06:27 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.01170 seconds
  • Memory Usage 1,755KB
  • 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
  • (2)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (16)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete