vBa CMPS: Teamspeak Block [Archive]

Mephisteus

10-12-2004, 10:00 PM

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

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

Polo

10-13-2004, 01:20 PM

Thanks for sharing with the community DarkSSJ3, i'm sure many will find this useful :)

rinkrat

10-14-2004, 01:08 AM

Looks great, what's teamspeak?

Mephisteus

10-14-2004, 08:46 AM

<a href="http://www.goteamspeak.com" target="_blank">www.goteamspeak.com</a>

It's a voice communication programn

Sirius Black

10-16-2004, 05:42 PM

What do you use the Database for ? I created a CMPS TeamSpeak Module of my own that is completely independent of the database.

Mephisteus

10-16-2004, 07:57 PM

What do you use the Database for ? I created a CMPS TeamSpeak Module of my own that is completely independent of the database.
I use the database to link it to the userid's so I can create valid links, and I have a specific order based on membergroups on my forum (it's a clan forum, and the order is based on rank).

But due to the many requests I decided to release it even though it could be done more efficiently.

Sirius Black

10-17-2004, 12:56 AM

I use the database to link it to the userid's so I can create valid links, and I have a specific order based on membergroups on my forum (it's a clan forum, and the order is based on rank).

But due to the many requests I decided to release it even though it could be done more efficiently.
Oh - I never even thought of doing something like that with mine. It just displays the channels and the names - Might have to give yours a try though cause I run a Clan forum as well.

Mephisteus

10-17-2004, 11:25 AM

It requires a few modifications to be made and the query to be used adapted, let me know if you need any help with that.

Dark_Wizard

10-17-2004, 12:06 PM

Do you have any screen shots?

Mephisteus

10-17-2004, 01:52 PM

No, I don't, and the teamspeak server is currently messed but it looks like this

2LT-Blabla
SGT-Albalb
PVT-dingdong
PVT-eingeong
RCT-Aaaaa

All linking to their forum profiles

Dark_Wizard

10-17-2004, 03:19 PM

Ok..thx.

bspiller82

10-20-2004, 06:35 PM

Screenshot in action?

Mephisteus

10-29-2004, 01:34 PM

Added a screenshot

bspiller82

10-29-2004, 07:23 PM

Whats your website to see it in the full page:) Looks very nice. If you clcik on the name does it load TeamSPeak up? I noticed the underlines.

bspiller82

10-30-2004, 02:18 AM

Seems when you edit the
/admin/db_inc.php
then try to veiw the teamspeak index.php it says

MySQL Error in [ UPDATE user SET tsserver_timestamp='' where (tsserver_timestamp + 900) < '1099104646' ]: Table 'user_teamspeak.user' doesn't exist

Please contact a the site admin immediately.

bspiller82

10-30-2004, 02:19 AM

if you use the orig. db_inc.php you see all the servers and users. It also shows server as being empty on the vba page.

Mephisteus

11-04-2004, 03:19 PM

What is your exact problem? I recently reinstalled it on my own board using the files attached and encountered no problems at all...

bspiller82

11-04-2004, 05:22 PM

Seems when I edit db_inc.php with the file edits you mentioned it displays MySQL Error in [ UPDATE user SET tsserver_timestamp='' where (tsserver_timestamp + 900) < '1099104646' ]: Table 'user_teamspeak.user' doesn't exist. I'll link it so you can see an example.

Click Here (http://www.247xtreme.com/teamspeak/listing.php)

Mephisteus

11-05-2004, 11:14 AM

Have you followed all steps to the letter? It seems a reference is made to a non existing table that the script is not referring to

DutchyNL

11-10-2004, 10:31 AM

Thanks for the share, going to try this one out.

bspiller82

11-12-2004, 12:38 AM

Have you followed all steps to the letter? It seems a reference is made to a non existing table that the script is not referring to
Yea I did. Maybe if you have soem time you can walk me though it on messanger or something?

Mr Peabody

11-12-2004, 08:34 PM

Does gllcts2 have to be installed into the VB database or can you create its own.

Mephisteus

11-13-2004, 05:59 PM

has to be in the vb database

DS MrSinister

11-18-2004, 09:33 PM

has to be in the vb database

how would i do this part?

Mephisteus

11-20-2004, 02:34 PM

Simply install it in the same database as vBulletin

kamu

11-25-2004, 03:21 AM

Will I need teamspeak and vbulletin running on the same server for this to work? I'm renting a TS server and don't know how to connect the two.

Thanks.

engquist

11-27-2004, 05:33 AM

I want to install this hack, I started to work on it, but I'm unclear why there are 2 downloads.

I also am unclear about why I'm supposed to upload a new index.php and new login.php files, I don't want to overwrite the files I currently have, I hacked them from other hacks.

the directions say only 1 file needs to be uploaded (top post in the thread) but there are a bunch of files in the gllcts2 4.1.7.zip so I'm a bit confused...

Mephisteus

11-27-2004, 02:28 PM

kamu:
That is possible with this hack, the only teamspeak side setting is the webpost, this means that the regular installation procedures apply (my teamspeak is hosted by someone else aswell)

engquist:
gllcts2 4.1.7.zip is the checker for who is on teamspeak, so I didn't count that. You have to but that in a seperate vBulletin directory

kamu

11-29-2004, 12:05 AM

Great, works flawlessly! But is there any way to include users who aren't registered also?

dcevoclub

11-29-2004, 03:35 PM

ok i have it installed to the vb datbase but it doesn't show up, no members show up on the main page...

Mephisteus

11-29-2004, 08:13 PM

Are they showing up in gllcts? If so, have you applied the file changes to db_inc.php? If so, have you put it in the vBulletin database? If so, are your members using their actual member names?

engquist

11-30-2004, 05:24 AM

Mephisteus

11-30-2004, 10:04 AM

You put gllcts inside A directory that IS NOT your forum directory

Eg. www.yourhost.com/forums/teamspeak
www.yourhost.com/teamspeak

KOM

01-02-2005, 05:09 PM

is there a way to show all the people ? not just the ones that use there forum name ?

kamu

01-03-2005, 05:05 AM

Yes, my users are either too lazy or to stupid to synchronize the two. It would be great to have the option of disabling the vb/profile integration functionality so users who either aren't registered on my forum or are to lazy/stupid to synchronize can still be listed. The incorporation of this hack and the vB database is very well done, but despite how impressive the feature is, ironically, it reduces some more important functionality for users like me.

Mephisteus

01-07-2005, 11:56 AM

I will look into having it variable in the future. If the profiles match it will show a link. If it doesnt match it will simply show the user.

This may however, take some time due to real life issues.

Cyricx

04-19-2005, 12:05 PM

Looks like the newest version of gllcts changed the remove inactive function..

Have you updated yours Dark? if so, do you have the modified code for the last file edit?

ChaoticMageDDC

04-27-2005, 07:16 PM

Well i was able to get the block installed and everything displayed on my CMPS page. It appears everything is working ok but for some reason it is not updating users that sign onto TS... If i go into the Admin page of the script i can see the server and amount of users are showing correctly. For some reason it's not being pushed out to the front page of my site... I also have verfied that the users are using the same name on TS as they have registered with on the Forums.

You can find the module here www.goaguild.com

Also i get this error MySQL Error in [ UPDATE user SET tsserver_timestamp='' where (tsserver_timestamp + 900) < '1114633609' ]: Table 'tsonline.user' doesn't exist

Please contact a the site admin immediately.

When i go to www.goaguild.com/tsonline not sure if that means anything since i would never have a need to use that URL, i was just putting it in for testing purposes and came accross this.

Anyone have any idea why?

Mephisteus

04-28-2005, 12:58 PM

ChaoticMageDDC

04-28-2005, 03:46 PM

From what I can see at your error you created a seperate database, or have a prefix.

1. If you have a seperate database you need to put the ts monitoring script in the same database as vBulletin.
2. If you have a prefix you need to change the query to
UPDATE prefix_user SET tsserver_timestamp='' where (tsserver_timestamp + 900) < '1114633609'

I hope this is the solution to your problems :)

I did create a seperate database outside of my forum DB. I usually like to keep those things seperated but i wasn't aware this had to be installed into the forum db :ermm: I will reinstall it thanks :nervous:

Mephisteus

04-28-2005, 03:48 PM

I did create a seperate database outside of my forum DB. I usually like to keep those things seperated but i wasn't aware this had to be installed into the forum db :ermm: I will reinstall it thanks :nervous:
It's still required, but I do suggest you go for v2 which saves on file edits and querys ;)

ChaoticMageDDC

04-28-2005, 03:58 PM

It's still required, but I do suggest you go for v2 which saves on file edits and querys ;)

ok the listings are showing up correctly now... What TCP Query port has to be opened in order for it to show the users?

When i go into the listings and go to the users info i get this.

Gods of Azgalor

Data unavailable.
TCPQueryPort may not be open.

Mephisteus

04-28-2005, 04:09 PM

And your not getting an error on the 3rd party programn?

ChaoticMageDDC

04-28-2005, 04:14 PM

everything is displaying correctly. Go to this link http://www.goaguild.com/tsonline/listing.php

If you click on users online it's saying there is no data from the server yet the server shows up. Plus my front page script isnt updating. I have another script that runs at the bottom of the Whos Online field and that one is working correctly so i would assume the correct ports where open.

www.goaguild.com

EDIT: I just noticed that it's pointing to an old link, yet i updated it to the new one :tired: Wonder what else i missed... Where else does this script pull the webpost info from?

Mephisteus

04-28-2005, 05:00 PM

I don't really know whats up with that, looks like an error with the listing script

http://www.goaguild.com/tsonline/listing.php?detail=192.168.1.1&detailport=8767

This is the part where it should list properly (like this: http://www.16aa.com/forums/teamspeak/listing.php?detail=66.246.224.0&detailport=8512.

ChaoticMageDDC

04-28-2005, 05:19 PM

I see when i click details it displays correctly. Any idea why i keep getting this error? Or what i can do to try and fix it?

Data unavailable.
TCPQueryPort may not be open.

I'm 100% sure that port 8767 is completely wide open. It works on the other script i have running but i can't get it to display on yours =\

Mephisteus

04-28-2005, 05:34 PM

Link error :p

Does the other one require that you aim it to a webpost adres? Because the 3rd party script I use does it aswell...

(if not I'll be happy to look into it in more detail tomorrow)

ChaoticMageDDC

04-28-2005, 05:43 PM

Link error :p

Does the other one require that you aim it to a webpost adres? Because the 3rd party script I use does it aswell...

(if not I'll be happy to look into it in more detail tomorrow)

Nope, it does not :ermm:

Thanks for the help let me know if you find out anything :)

Mephisteus

04-28-2005, 06:27 PM

Alright. Did you set the webpost adres from the teamspeak control panel?

ChaoticMageDDC

04-29-2005, 01:15 AM

Alright. Did you set the webpost adres from the teamspeak control panel?

Yes, I did.

Your script finds my server no problem as you can see it listed there. The problem is when you go to details it says my query port isn't open or something like that and no data will display. Since that happens no TS info is being pushed to the webpost.php file on my site... I know 100% that my query port is wide open because as i stated eariler its working with another TS script that runs under the Who's online table....

It's wierd i don't know why it's not working... :ermm:

Mephisteus

04-29-2005, 09:16 AM

ChaoticMageDDC

04-29-2005, 05:05 PM

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

04-29-2005, 09:43 PM

Try this: http://www.gryphonllc.com/forum/showthread.php?threadid=59

ChaoticMageDDC

05-03-2005, 05:49 PM

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

I tried all of their suggestions with no luck.

Acedeal

07-08-2005, 04:54 AM

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

07-17-2005, 08:17 PM

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

Acedeal

07-18-2005, 12:00 PM

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_t imestamp
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

07-19-2005, 09:57 AM

Sorry, its added now :p

TsirhCitna

07-29-2005, 05:07 AM

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

Mephisteus

07-30-2005, 11:01 AM

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).

TsirhCitna

07-30-2005, 03:27 PM

Well it seems to have stopped breaking the tables now...?

Since it's not breaking them here's the link to the CMPS http://www.tenstones.net/index.php? and here's the link to the gllcts2 http://www.tenstones.net/teamspeak/

It shows people online in the gllcts, but not on the CMPS.

Mephisteus

07-30-2005, 03:47 PM

Tenstones TS
Data unavailable.
TCPQueryPort may not be open.

Thats what I get in gllcts

TsirhCitna

07-30-2005, 04:21 PM

Yeah, I noticed that too, I sent an email to the person that owns the server to open TCP for port that TeamSpeak uses, do you know if that's the same port gllcts connects to?

Mephisteus

07-30-2005, 07:33 PM

Im not sure actually. I never had that problem :/

twitch

08-07-2005, 09:36 PM

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

My install does the same thing, how were you able to fix it?

twitch

08-07-2005, 11:31 PM

I have everything working and it shows all the people in TeamSpeak but it spreads my template out really crazy.

Take a look at the attached image. Would also be nice if it was scrollable in order to keep it from getting to much heighth

Hope someone can help