vBa CMPS: Teamspeak Block

Hack name: vBa CMPS: Teamspeak Block
Version: 2.0
Author: DarkSSJ3 (Mephisteus)

Steps:
1 upload
1 new vBa CMPS Module
1 new template
1 style edit

Info:
A simple yet effective way of showing who is on teamspeak, it updates every 5 minutes. Since 2.0 it also shows who is on ts that isnt on the forums.
For a demo look on http://www.16aa.com/.

2.0
2.0 has completed its beta stage, 1.0 has been removed.
Version 2.0 adds a number of nice 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 on the block Feature readded
Note that the attached screenshot includes flags. These are NOT part of the hack released.

Also all file edits and database modifications have been eliminated. A week or so after this release version 1 will be removed Version 1 removed

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

Important
If you use vBa CMPS 2 you need to remove the <table> tags and the first <tr> and <td> tags from the template in order to have it display properly

[Mephisteus]

You have it set up internally... Not sure if that is the problem though.

I have set my server to point at it and that does work properly.

So it actually does look like the internal ip is the problem...

[ChaoticMageDDC]

Originally Posted by DarkSSJ3

You have it set up internally... Not sure if that is the problem though.

I have set my server to point at it and that does work properly.

So it actually does look like the internal ip is the problem...

hmm how do i change that? I tried to find where to change the internal IP and i don't see it anywhere.

The problem is the TS server is hosted on the same server the website is on and it's internal to my network since i run it how would i go about assiging it an external ip address when it's internal??? lol :speechless:

[Mephisteus]

Try this: http://www.gryphonllc.com/forum/show...hp?threadid=59

[ChaoticMageDDC]

Good info but it still has not solved my problem =\

I tried all of their suggestions with no luck.

[Acedeal]

Great mod--
Just ported over 100k post and about 2k users (been running phpbb for about 4 years)
Just got VB about 3 / 4 days ago-
Still learning the way it's setup but---

Took some editing to get it work correctly but works great

To see it in action
http://www.dow-gamers.net/
left side 3 module down

[Mephisteus]

Updated to version v2 final as of this point. Previous versions are not supported in any way (officially neither is this version but I'm willing to look into it )

[Acedeal]

This one is not working as expected

Database error in vBulletin 3.0.7:

Invalid SQL: 
	SELECT user.username,user.userid,gllcts2_user.pl_nickname,gllcts2_user.pl_playerflags,gllcts2_user.server_timestamp 
	FROM gllcts2_user AS gllcts2_user
	LEFT JOIN user AS user ON(user.username=gllcts2_user.pl_nickname)
	WHERE gllcts2_user.server_timestamp>=1121691062
	ORDER BY gllcts2_user.pl_nickname

mysql error: Table 'dow-gamers_net-vb.user' doesn't exist

mysql error number: 1146

Date: Monday 18th of July 2005 07:57:02 AM
Script: http://www.dow-gamers.net/?
Referer: http://www.dow-gamers.net/vb/showthread.php?p=108192

UPDATE--
You forgot the
" . TABLE_PREFIX . "
on your
LEFT JOIN Statement
should read

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.username=gllcts2_user.pl_nickname)

[Mephisteus]

Sorry, its added now

[TsirhCitna]

I've got this installed, but it says 0 users online and breaks all the tables.

[Mephisteus]

I'll need some more info then that Tsirh, did you also install gllcts2 4.1.7. And on the breaking of the tables, dont know whats up with that. It works fine here :/ (I installed the hack using the info given here).