[Release] gllcTS2 Webpost for TeamSpeak 2 [Archive] - Page 2

View Full Version : [Release] gllcTS2 Webpost for TeamSpeak 2

Pages : 1 [2] 3

maletin

20-06-2003, 10:01

Vortex

20-06-2003, 23:09

Originally posted by maletin

Maybe you need to enable cookies or javascript for this site?

Thought of that already, cookies are accepted and java is enabled.

DeeeJay

21-06-2003, 17:42

Where can I find a description of "Webpost2 for TeamSpeak 2" in german?

Please check it for me! Thx! :cool:

Another question:

How can I bind it in my HomePage?
With HTML?
With Java-Script?
Or do I got to have a PHP- and SQL-Account/WebSpace?

BLIND

21-06-2003, 18:57

Perhaps you should include what server versions and port numbers should used when working with each version of the script.

Woelfchen

22-06-2003, 10:34

You need a php- and mysql-webspace! For embedding in your hompage, you must only open a php-file. (index.php)

DerJoker

22-06-2003, 12:17

thtas right, you need php and sql..... und dann ist beim webpost auch alle in deutsch beschrieben soweit ich mich erinnere ansonsten schick mir ne mail dann helf ich dir ;)

SenTencE

22-06-2003, 13:50

DeeeJay

25-06-2003, 20:11

Once again ...

Where can I find a description of "Webpost2 for TeamSpeak 2" in german?

Please check it for me! Thx! :cool:

CowboyGuy

26-06-2003, 02:50

I'm migrating from a debian version of linix to a Red Hat, and the upgrade includes the newer Apache and PHP packages.

First off, it looks like all the <?'s and <?='s need to be changed to <?php to allow the system to work. After I did this to all the files, I finally got some display - although not what I expected... missing most info and ood background colors.

I have a fresh install, but the MySQL database was restored (along with a number of others) from the older machine.

The Linux server has the webpost url, but doesnot seem to make updates to the database.

Anyone done this yet? Got any suggestions?

ScratchMonkey

26-06-2003, 06:37

Edit /etc/php.ini and change short_open_tag to "On" to allow the "<?" to work.

CowboyGuy

28-06-2003, 02:30

wow... should have read the manual! that was much easier and would have been quicker than what I did!

ScratchMonkey

28-06-2003, 03:08

Us old timers use the acronym "RTFM". ;)

CowboyGuy

28-06-2003, 03:51

old timers.... hmmmm

Well, I don't have to save money on letters... I can use as many as I want atno extra charge :D

besides, I live in acronym he11 all day at work....

Evil Els

29-06-2003, 02:27

LOOK AT THIS! (http://141.76.120.107/teamspeak/)

it seams webpost shows all users ever connected to my server even if there is nobody online :confused:

i already flushed all databases and reinstalled webpost without success.

latest php, mysql, ts and webpost

whats wrong???

zoomzoom

17-07-2003, 14:52

ich habe einen Webspace mit php und mysql.trotzdem bekomme ich bei der installation diesen Fehler:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, root@server.net-4-all.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Warum geschiet dies??

folgende Settings hat der Server:
Server Settings (http://www.netclusive.de/info.php)

Benutze die neuste version von webpost

zoomzoom

TR-13

17-07-2003, 16:19

Welche Datei rufst du den auf ?

zoomzoom

17-07-2003, 16:28

ist egal welche datei ich aufrufe.
wollte zu aller erst mal die Install.php aufrufen

normalerweise sollte er ja auch den Ordner anzeigen wegen der index.php

zoomzoom

Buster.de

24-07-2003, 14:37

.htaccess Datei mal löschen. Ab und an sollte man eben doch mal die Readme lesen ;)

zoomzoom

24-07-2003, 14:44

ja das wollte ich schon machen nur finde ich die htaccess nicht auf dem Server sie wird nicht angezeigt.wie kann ich sie löschen??

Buster.de

24-07-2003, 15:31

kommt auf den FTP-client an. Meist reicht es versteckte Dateien anzeigen zu lassen oder den LIST-Typ auf "LIST -la" umzustellen.
Notfalls per Hand den Befehl "DELE .htaccess" an den FTP-Server senden ;)

zoomzoom

24-07-2003, 15:59

er sagt leider das es das file nicht gibt.....

kann das sein und beim auflisten aller dateien hängt er sich auf

-={B4MB4M}=-

28-07-2003, 01:11

Originally posted by Vortex
When I go to http://myserver/webpost2/admin/login.php, type in the admin login and password, I get the admin page. But when I click :

Settings or admin E-mail, I get the login screen again.

What am I doing wrong ??
Originally posted by SenTencE

Ok, i got the same problem... anybody find a solution ??

Btw, gibts hier auch jemanden der mir das in Deutsch erklären könnte ;)

I also have this same problem, Get to the login dialog, enter login and pass, see the admin page....but whatever I click from there , I always return to the login Dialog :(

Anybody a Solution yet ?

regards
B4M

BLIND

28-07-2003, 21:57

I don't think finding the solution is the problem, but recreating the problem. I got mine to work fine at go. Did you have MySQL running correctly before this? Perhaps a permissions problem on the webserver? Sessions variables correct?

-={B4MB4M}=-

29-07-2003, 01:00

I think I got my Mysql workin ok...Got a phpBB running without any problems, so that (I think) should not be the problem.

Ive tried to reinstall the webpost2 scripts a few times now and every time it works the same.

I Create through phpadmin a DBase called : webpost2

I edit the config.php script :

$dblink = "localhost"; // Host
$dbuser = "webpost"; // Username
$dbpw = "password"; // Password
$dbname = "webpost2"; // Database
$dbprefix = "ts2_"; // Prefix for tables

The I start the install script and check the settings , and fill in an username and pass for the admin page.

Once I get that done, I am send to the admin page, and I can edit colors etc... and as long as I stay in there I can do what ever I want, BUT as soon as I close the window and try to get back in again, I find myself in this never ending loop.

any thoughts ?

regards
B4M

N3NCY

29-07-2003, 03:22

First, I had to create the webpost2 database by hand.
Then the install.php worked.
Then I went through the setup once.
Now I CAN'T log back into admin pages to make changes.

Thoughts?

Ernie:confused:

Lazyboneshome

01-08-2003, 11:27

Hi guys,

the reason that you can't access the admin menu to do changes on your settings is:

The login data is saved in a session and if the script doesn't has the chance to save it, it will send you back to the login page.

All you have to do is to check with phpinfo where the folder for your session data is supost to be ( look at the topic "session" / line "session.save_path") . Check if you realy have it !

For an apache webserver it should be "apache/cgi-bin/sessiondata/" but the apache or either PHP doesn't create that for you. So you have to do it by your self.

I hope it is the fix for you guys too. At least it fixed the login problem i had.

Good luck

bspiller

06-08-2003, 00:46

Would be nice if the link on your site worked... Maybe you can post a working link so I can grab it? It jsut reloads the page when you click download...

Lazyboneshome

06-08-2003, 20:40

Here we go this Link should work.

http://www.thzclan.com/files/index.php?cat=29&file=53

Have fun.

Lazyboneshome

bspiller

06-08-2003, 21:00

Originally posted by Lazyboneshome
Here we go this Link should work.

http://www.thzclan.com/files/index.php?cat=29&file=53

Have fun.

Lazyboneshome

Can you read?

Would be nice if the link on your SITEworked... Maybe you can post a working link so I can grab it? It jsut reloads the page when you click download...

THe download button on the site does nothing

Dummer Sack

07-08-2003, 01:53

Well it works here ...

Germeshausen.de

13-08-2003, 20:06

Originally posted by bspiller

Can you read?

Would be nice if the link on your SITEworked... Maybe you can post a working link so I can grab it? It jsut reloads the page when you click download...

THe download button on the site does nothing

same here...
so i am working with 3.1.1 i think. :rolleyes:

Gryphon

19-08-2003, 18:10

Sorry I have not been around. I have a ton of projects keeping me busy. I realize that there is a problem with the admin login sessions. I will have to change this.

I have also purchased a dedicated server with of course has all the latest software and yes, webpost broke for me too. I am going to have really dig into it and fix it all up.

I am not sure how soon I can get it fixed. Sorry I can't give any ETA :(

Germeshausen.de

19-08-2003, 18:27

Could you be so kind and give another mirror or link which is working? If give me the permission, i will create one for you.

Here are a lot of nice guys which are interested in your work. If you need some support, just ask. I am sure that some will help you where ever they can.

Greetz

Crow

-={B4MB4M}=-

21-08-2003, 15:48

Originally posted by Gryphon
Sorry I have not been around. I have a ton of projects keeping me busy. I realize that there is a problem with the admin login sessions. I will have to change this.

I have also purchased a dedicated server with of course has all the latest software and yes, webpost broke for me too. I am going to have really dig into it and fix it all up.

I am not sure how soon I can get it fixed. Sorry I can't give any ETA :(

Thnx,

no problems with the unknown ETA.....I check his forum religiously for the solution.

regards
B4M

InvictuZ

24-08-2003, 09:43

Hey Gryphon, open suggestion...

Could you add a HTML tag filter? My Clans tags are:
>V<playername

But it replaces those with HTML code, and none of our guys name shows up in the players listing. :/

Brain

24-08-2003, 12:07

Quick patch: Look where the name output is and use htmlspecialchars() on it.

CyberWolf

03-09-2003, 05:08

Hello,
Why is it when I see my server here and click details
http://www.thzclan.com/ts2/listing.php
I see the channels and users BUT

When I run the WebPost script on my WebHost I see the server but when clicking on Details I get an error?

http://www.wmhq.org/ts2/listing.php

Data unavailable.
TCPQueryPort may not be open.

riptide00

16-09-2003, 23:46

Great Product thanks for the hard work.

frankenberrie

29-09-2003, 17:15

This script is great, only thing is I get this way to many times!

[DATABASE ERROR:]1016: Can't open file: 'ts2_user.MYI'. (errno: 145)

It's simple to log into MyPhpadmin and do a Repair & Optimize table.... But it becomes a hassle when it has to be done 2 - 3 times a day! :mad:

BLIND

02-10-2003, 22:43

Originally posted by CyberWolf
Hello,
Why is it when I see my server here and click details
http://www.thzclan.com/ts2/listing.php
I see the channels and users BUT

When I run the WebPost script on my WebHost I see the server but when clicking on Details I get an error?

http://www.wmhq.org/ts2/listing.php

Data unavailable.
TCPQueryPort may not be open.

Because the data is unavailible...your TCPQueryPort is not open....

Ravyn

04-10-2003, 12:07

Ive set up the webpost script in my web dir. Gone through the login and have access to the admin control panel.

I changed the settings in my TS administration to set the Webpost URL=http://mydomain/webpost/webpost.php

which is where i have the webpost script, and have since waited close to a 1/2 hour, and still the server hasnt shown up in the Active server listing.

Any help would be appreciated

Ive read other posts and it seems that the PHP version makes a difference, I have PHP 4.2.2 running on the Linux box, so what changes would need to be made to the script if thats the problem.

Thanks

Ravyn

Sommer

11-10-2003, 22:50

where can you get it.... I can't get it from The hounds of Zeus, it is just reloading the site.... Any one who has it??

MrPickles

12-10-2003, 00:33

Don't know why, but I had to completely shut down my firewall to download it.

Sommer

12-10-2003, 09:56

Yea, I also tried that after you reply.... shout down your firewall and it works. THAT SUCKS!

Qxs

16-10-2003, 19:09

Ok, webpost doesn't update the channels/users online.

Broken:
PHP: v4.3.2
Sql: unknown

Working:
PHP: 4.1.2
MySql: 3.23.49 *I think (debian)

However, after looking at the code for webpost.php and db_inc.php among others I kinda think it's a database issue.
I didn't see anything terribly complex in the sections that update the table2 and table3 where it seems the info is stored.

I do know that if I reset the ts server it records the info correctly the first time
(from an empty webpost server list). So I assume it's the update functions that are failing.
Note: the server is being updated every 5 minutes, I've been watching to make sure that is working...

Unfortunately, I really know nothing about sql or php, I simply recognize the logic of programming and know how to use a manual :)

I was hoping someone with a background in php and mysql might be able to point out any changes in the way calls to the database are made, tables, etc.

jracca

10-11-2003, 23:50

Is there some doc. that will help me setup my database? Like a big readme for a stupid person?

Qxs

24-11-2003, 07:05

search google for your sql...
like for instance mysql
.. theres only a couple things really to do for the actual database...

I see there's been no new info posted here :/

I still have the same problem.. sometimes it adds multiple entries .. so I see Username-BOD- like 8 times.

w00ter

27-11-2003, 15:02

Righteo,

I got the latest webpost working and it shows 2 external servers. Everything works properly with those! However on the same box as the webpost I've got a TeamSpeak server running. This one fails to show up.

I tried the following things as webpost IP:
127.0.0.1
192.168.1.1
the dnsname (which works for the other servers)

Is there anything else I could try to make it show up?

Dummer Sack

27-11-2003, 15:34

Just a guess what your problem is:

The webpost script is hosted via a virtual domain. That is why 127.0.0.1 and 192.168.1.1 fail.
Also your web server is behind a router or a firewall that does not support to redirect addresses on the LAN interface. That is why the domain name method fails (since the domain name is matched to your WAN IP and has to be redirected).

Your solution would be to make an entry in your /etc/hosts file that matches your domain name to 192.168.1.1 (Or whatever the LAN IP of the server with the webpost script is). Then give the hosts file priority over external dns resolution in the resolution process (configured in nsswitch.conf on many distros). This should not hamper normal operation, it just tells that your systen should look up computer names first in the hosts file and if it is not finding them there do normal dns lookups.

Then enter the domain name as your webpost url and everything should work fine.
If you use windows there is a similar file called lmhosts. But I don't know how to configure it.

w00ter

27-11-2003, 15:53

127.0.0.1 localhost
192.168.1.1 butjesserver.BUTJESGROUP butjesserver

This is already in the hosts.

I've now tried the butjesserver.BUTJESGROUP and butjesserver ones. No effect yet.

This is the content of my nsswitch:
# /etc/nsswitch.conf
#
# Example configuration of GNU Name Service Switch functionality.
# If you have the `glibc-doc' and `info' packages installed, try:
# `info libc "Name Service Switch"' for information about this file.

passwd: **
group: **
shadow: **

hosts: files dns
networks: files

protocols: db files
services: db files
ethers: db files
rpc: db files

netgroup: nis

I am not quite sure what to change here.

Dummer Sack

27-11-2003, 15:58

nsswitch.conf looks ok.

But I doubt that butjesserver.BUTJESGROUP is the domain under which your webpost script is running.
It must be the same domain name that you entered as webpost url at the other servers (maybe even some dyndns or no-ip domain).

EDIT: Do not delete butjesserver.BUTJESGROUP. Just add a new one with the correct domain name and the IP 192.168.1.1.

This way on your host it resolvs to 192.168.1.1 but external hosts will resolve it to your WAN IP.
Another solution is to install a new virtual domain in your apache.conf with the name butjesserver.BUTJESGROUP that points to the same scripts as your other doimain on witch the scripts are running.
(Just dublicate the virtual domain config and change the name)

But I would recommend the hosts solution.

w00ter

27-11-2003, 16:08

From the LAN i can reach the webpost from basically any of these:
http://butjesserver/
http://192.168.1.1/
http://my-own-ip/
http://butjes.no-ip.com/

(not posting my real ip since prolly would load my little server a bit)

Dummer Sack

27-11-2003, 16:25

Ok here we have it:

butjes.no-ip.com

I think that is the domain that you entered at the external TS servers for webpost.

Now add an entry to your /etc/hosts:

192.168.1.1 butjes.no-ip.com butjes

And then put as webpost url to your local TS server the same that you have put in the others.

EDIT: After updating the /etc/hosts file you should get 192.168.1.1 as ip if you ping butjes.no-ip.com form your server and not your WAN IP.

w00ter

27-11-2003, 16:35

Hmm, i did add that to hosts now and restarted networking but pinging still gives me the WAN ip instead of 192.168.1.1 ..

However if i ping butjesserver it will give me the 192.168.1.1 IP.

Too bad it wouldn't work when i filled it in in the webpostURL.

Dummer Sack

27-11-2003, 16:40

Hmm ok. What does your /etc/resolv.conf look like?

w00ter

27-11-2003, 16:41

nameserver 62.216.31.50
nameserver 62.216.31.60
search adsl.cistron.nl

Dummer Sack

27-11-2003, 16:46

Hmm too bad. I don't know waht the problem is an why you get the WAN IP instead of 192.168.1.1.

So you may want to try the apache.conf solution.

Dublicate the virtual domain entry for webpost and change the domainname in the dublicate to butjesserver.
Then use butjesserver in your webpost url.

[ASF]ODDYSEY

13-12-2003, 08:14

Originally posted by Evil Els
LOOK AT THIS! (http://141.76.120.107/teamspeak/)

it seams webpost shows all users ever connected to my server even if there is nobody online :confused:

i already flushed all databases and reinstalled webpost without success.

latest php, mysql, ts and webpost

whats wrong???

Same problem here also. For some reason the script wont flush users when the disconnect from the server. They just keep re-adding them over and over. Does anyone have a solution on this?

Thanks

Cigar_Man

31-12-2003, 03:09

I have the latest files, webpost2_4.0.2, and I am having a problem with the Server WebPost PostUrl being placed in front of the Server WebPost LinkUrl as seen here (http://www.thzclan.com/ts2/listing.php?page=4&sort=server_name&direction=asc&showgroup=all) with the [DK] an |NXA| clan server links. If you hover over the team name, you see the incorrect link as so:

http://www.thzclan.com/ts2/www.dk-clan.us

http://www.thzclan.com/ts2/www.r0am.com/nxa/nxa.htm

In these two examples, the PostUrl is http://www.thzclan.com/ts2 with the actual server link (www.dk-clan.us and www.r0am.com/nxa/nxa.thm) added after the ts2/.

Can anyone help me correct these links to show the proper website links?

drmadd

31-12-2003, 19:56

Here is my issue,

Everything works fine... Only thing I need to be able to do is put my DOMAIN NAME instead of IP address....

Example,

It shows up

192.168.0.100:8767

I want it to show up DOMAIN-NAME.com:8767

When external users click the link, they get nothing because they are linking to a non routable IP addy...

Where do I change this at ?

satcom

05-01-2004, 22:06

hi there,

i just wanted to say that im working on the script, and port it to a PHPNUKE module, since i cannot find any nukemodule slick like this webpost script!

im also working on a Webpost Hub script, which makes it possible to distribute your serverstatus to more webpost-pages!

mamorex

09-01-2004, 13:31

Originally posted by satcom
i just wanted to say that im working on the script, and port it to a PHPNUKE module, since i cannot find any nukemodule slick like this webpost script!

fine idea:) but it is possible to make such a module or Block for PostNuke?? that was great :D

Binar

11-01-2004, 09:46

Where do I find the webpost2.sql file?

the file http://www.thzclan.com/files/index.php?cat=29&file=53 does not have it....

bigsteve

14-01-2004, 15:32

Hi it works wonders, and with a little recoding i got it working in a block on mx-system/phpBB based site.
Look HERE (http://www.stormhawks.co.uk) .

Gryphon

15-01-2004, 00:46

Looks nice, though you need an account on the site to see it. (Vanu > NC :p)

I'm still alive and working on the next version in my spare time. It has some fixes, primarily the session login problems and code optimizations.

bigsteve

15-01-2004, 00:51

i have activated your account on my site Gryphon

GASCRLModernAge

19-01-2004, 02:58

hmmm...looks like when I upgraded to PHP 4.3.4 and MySQL 4.0 everything broke

:confused:

APG-Jona~TSC~

02-02-2004, 20:41

I am trying to use this on an updated server. I donot run the server, but have access to my MySQL db. When trying to install I get access denied errors. I checked the log in info and all is well.

Can you please post what versions of PHP and MySQL this will work in. I am wondering if that is my issue.

Zhivotnoya

03-02-2004, 01:55

Ok. Great script dood! But a question. When you click on a channel name and go thru the login information, it takes you to a screen that says "click here to login"...

but when I click on it, it gives me the generic 'page not found' in IE6, and in netscape, it says 'teamspeak' isn't a registered protocol.

Any ideas?

just for grins and giggles, here's the site: http://webpost.strengthandhonour.net/

Trusty

07-02-2004, 00:39

hi, ich habe alles installieren können, jedoch wird mein TS2 Server nicht aufgelistet, die post und link url hab ich im adminbereich vom ts server eingegeben, was kann das noch sein???

hier mal der link zu der webpost.php : http://www.bunny-hunters.de/ts-webpost/webpost.php

ne vermutung von mir, kann es auch sein, das es vom ts server gesperrt wurde was nach draussen zu senden??? :(

iderdik

17-02-2004, 23:32

Originally posted by [ASF]ODDYSEY

Same problem here also. For some reason the script wont flush users when the disconnect from the server. They just keep re-adding them over and over. Does anyone have a solution on this?

Thanks I'm having the same issue. Has anyone found a solution for this yet?

Dmkaz

02-03-2004, 01:50

**Edit**
I am a bit new to php so I am kinda clueless about this error.

Warning: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /homepages/43/d91743808/htdocs/ts/admin/db_inc.php on line 54

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /homepages/43/d91743808/htdocs/ts/admin/db_inc.php on line 54

[DATABASE ERROR:]2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I know I did complete the config file right though. The only part I wasnt sure on was the table prefix.

Also updated and tried to isntall the newest version of webpost, same error.
Thanks

Profi

07-03-2004, 16:58

Nice script, but i can not download the script.

i click on the button of http://www.thzclan.com/files/file.php?id=53
and nothing does download.

can anyone send me a link to download the webpost 4.1.0

Dmkaz

08-03-2004, 07:41

Just click in the button in the midde titled "gllcTS2" The download should automatically begin then.

Profi

08-03-2004, 17:18

I click the button and nothing happens....

jayt

09-03-2004, 14:43

thats my problem too ^^
i klick on the button and nothing happens .. :(
can someone send me a link or the file (jaytee********) ?

Gryphon

09-03-2004, 20:34

On the download page click the "Problems with download? Click Here" at the bottom. No, you didn't miss that ;), it's a new option.

Germeshausen.de

09-03-2004, 20:56

I got the same Problem too. Shut your firewall and advertise blocker down, reload the page and try the download again. Normally it starts. After downloading you can switch the firewall and advertise blocker on.

For me it works

Profi

10-03-2004, 23:24

Thank you. The email-sending help me out. :)

Gryphon

11-03-2004, 00:12

Going to have to make some modifications for v2.0.20.1, currently it is not compatible.

*edit
Quick fix is up.

EagleEyE@GCC

20-03-2004, 23:58

I have a slight problem that at this point isnt huge but might be eventually.

And a suggestion as well possibly.

I was just at your display page and ran a test

When using ticker.php i just cannot seem to get it to accept the ?name= switch ATM im down to only hosting 2 servers so this doesnt cause much of a problem considering one of them is my public server.

It is an annoyance though.

http://tsview.game-connect.com is where my scripts are located The teamspeak server is on a different machine.

Now as for the suggestion How hard would it be to add port to the mix to pull individual servers up in ticker.

And is it possible to get more information on the ticker than the IP and people actively on the server?

Guess i really should start learning more about php hehe

DennisTheMenace

21-03-2004, 23:39

I had the script working on my webserver and I was having the allow_call_time_pass_reference errors but I figured it out (had to comment our 300 and 369) but in my attempts to fix it I must have changed some thing the script didnt update so I didnt notice. It now displays how many users but It dosnt display the users it gives me the Data unavailable. TCPQueryPort may not be open. error and I cant figure out how to fix it. In my server config I have

ServerWebPost PostUrl: http://teamspeak.us/ts2post/webpost.php
Server WebPost LinkUrl:
Server UDP Port: 8767

but i'm still getting the error. I dont think it's a matter of the port being blocked becuase it was working befor. This is a Windows 2003 Server system. My teamspeak server is the same ip as my webserver so I have teamspeak.us pointed at my IP.

bongo25

11-04-2004, 10:40

When doing the browser install Im only getting 3 out of the 5 tables. No errors installing.

this is the Config file info:
: // Begin User Config

$dblink = "localhost"; // Host
$dbuser = "ts2"; // Username
$dbpw = "XXXXX"; // Password
$dbname = "teamspeak2"; // Database
$dbprefix = "teamspeak2_"; // Prefix for tables

// End User Config

the folder is is installing to is this:
www.*MYSITE*.net/teamspeak2/
( of course the *MYSITE* is not the real name )
This is what is supposed to be installed.

Table 1: teamspeak2_weblist
Table 2: teamspeak2_user
Table 3: teamspeak2_channel
Table 4: teamspeak2_group
Table 5: teamspeak2_admin

But it only creates 3 tables not 5:

teamspeak2_admin
teamspeak2_channel
teamspeak2_group

And here is the error I get when viewing from the browser:

Active Servers: MySQL Error in [SELECT * FROM teamspeak2_weblist]: Table 'teamspeak2.teamspeak2_weblist' doesn't exist

Please contact a the site admin immediately.
--------------------------------------------
MySQL Error in [delete from teamspeak2_weblist where (server_timestamp + 900) < '1081672042']: Table 'teamspeak2.teamspeak2_weblist' doesn't exist

Please contact a the site admin immediately.
--------------------------------------------

MySQL VERSION: 4.0.16-globat
PHP VERSION: 4.3.4

what do i need to do to get those other two tables to show up on the install?

bongo25

12-04-2004, 19:50

nevermind, got it to work, and its running now

AnthonyB

13-04-2004, 11:23

Am using gllcts2_4.1.1 with PHP 4.3.3 and MySQL 4.0.17 under Win2K SP4 and am finding that it's still not liking apostrophe's in the server name.

As soon as I removed the apostrophe from my server name it suddenly showed up.

JayBaen

25-04-2004, 21:50

Losing my mind ...

I've been using varying forms of this script for a while, it's never mystified me.

I'm also convinced that the issue I'm having has to be something on this particular server's end.

I have several TS servers running under one application (from obviously, one machine). All of them are advertising to different wepost.phps on different web servers.

Most of them work, I have one that doesn't. About the only conclusion I can come to is the php and/or mysql configuration on the unresponsive server must be different. The script installed and created tables just fine. The listing.php page looks fine, minus the server information. I can point currently "working" servers to the webpost in question, and they stop posting. I can take the "non-posting" server, point it to a different web server running the script, and it posts.

So, obviously, it's the receiving server at fault ... but what? PHP (4.2.2) and mySQL (3.23.58) are both installed and working correctly. There are NO firewalls in the way.

Is there a php setting that needs to be opened up a bit more or simply configured differently?

Help.

JB

AnthonyB

28-04-2004, 16:45

Just an FYI, upgraded to gllcts2_4.1.2 from 4.1.1 and am finding that it's still not liking apostrophe's in the server name. As soon as I removed the apostrophe from my server name it suddenly showed up on the list.

Am running with PHP 4.3.6 (with fsockopen() lines remmed to prevent allow_call_time_pass_reference errors) and MySQL 4.0.18 under Win2K SP4

Gryphon

28-04-2004, 18:14

That is interesting. Here (http://php.gryphonllc.com/gllcts2/listing.php?detail=69.93.150.93&detailport=8817) is a server on the development site with a ton of apostrophes. I will have to investigate further.

The fsockopen errors 'should' be suppressed by default now.

JamieWolf

30-04-2004, 19:22

Hi Gryphon,

thanks for the new Version, it's working fine with me :) But I have a suggestion for the next Version

Would it be Possible to crypt the passwords, so that they ain't in plain Text? I would recomment the md5(); function of PHP

Also there are some minor Bugs in the Templates:

When editing Settings in Admin Panel:
http://62.75.177.34/tech/nuke7.1/html/modules/ts2/webpost/admin/index.php?action=submit&what=settings

And on the install.php it said that there was some variable missing in some TPL file, now after I installed webpost it works just fine! :eek:

Gryphon

30-04-2004, 20:30

Arg, can't seem to keep up with my own bugs when fighting bugs. I'll get a new version out shortly as I have found that the login popup is broken as well.

The password I will work on encrypting, it hasn't been a high priority since it isn't that critical of a script to keep secure.

AnthonyB

03-05-2004, 10:02

Originally posted by Gryphon
That is interesting. Here (http://php.gryphonllc.com/gllcts2/listing.php?detail=69.93.150.93&detailport=8817) is a server on the development site with a ton of apostrophes. I will have to investigate further.

The fsockopen errors 'should' be suppressed by default now.

My problem is with the server name containing apostrophes, not the channel name. In saying that, I can see a server listed on your site with an apostrophe in the name... hmmm... it is a Linux server however.. could it be an issue with PHP on Windows only not handling apostrophes in server names?

BTW, I've upgraded to gllcts2_4.1.4 and still same problem. Rest of config is PHP 4.3.6 and MySQL 4.0.18 under Win2K SP4.

Gryphon

04-05-2004, 01:24

I will check on the server name entry.

JamieWolf

11-05-2004, 20:22

@Gryphon

I've another suggestion to the Script :)
Did you ever think about using classes or function Libaries with your webpost script?

Cuz I trying to port the script to a PHP-Nuke compatible one, and since you use a lot of HTML code with in the script it's kind of hard to port :)
Also it would be easier to track down Bugs, cuz you will have less code :p

Anyways thanks for the great script

Gryphon

11-05-2004, 23:45

I know a ton more than I did when I started this project, it is due for a complete rewrite. However, finding the time to do that is another issue, so fixing the current code little by little is all I have the time for right now.

JamieWolf

12-05-2004, 19:44

Its the same with me :)

When I started coding I didn't know much :)

If you want i could help you with recoding the hole thing into a function based script (or even classes, altought I don't have much experience with them)

Gryphon

13-05-2004, 19:22

Thanks, JamieWolf. I currently have some plans for the script swimming around in my noggin, I will keep you in mind if I need some help.

Version 4.1.6 has been released, it is important to update your config.php with this version.

AnthonyB

15-05-2004, 07:06

Just an FYI, Server name with an apostrophe still not working.
gllcts2_4.1.6, PHP 4.3.6 and MySQL 4.0.18 under Win2K SP4

.Tantric.

10-06-2004, 05:01

I just downloaded and semi-integrated the latest version of Webpost on our server. It displays well, but for some reason, it isn't updating when people leave the server. Meaning, there's no one on the server, but now (4 hours after they've left) they're still showing on the server.

Another problem. We changed ports on our TS2 server today and it's still showing the old server (same server, different port) as being active. Is there any way to remove the non-active servers from the listing?

Teamspeak Display (http://www.bestwerx.com/aof/ts2/listing.php?detail=172.30.30.35&detailport=7778&page=1&sort=server_name&direction=asc&showgroup=all)

Running MySQL 4.0.18-nt with php ver. 4.3.6 on a Windows 2k3 Server box. I have full access to the box if need be.

Thanks for the great work on this project. And thanks for any help that is lent.

McAfee

10-06-2004, 08:23

there is a setting called "Delete Inactive Servers" on the gllcTS2 admin panel.
It should be set to 900 (seconds). This will also delete old users/channels.

Fio27

14-06-2004, 23:57

McAfee

15-06-2004, 02:58

The server encountered an internal error or misconfiguration and was unable to complete your request.

Try NOT using the .htaccess file that is supplied with gllcTS2. Simply delete it from your webpost folder.

Lynx

18-06-2004, 03:15

Hello,
I have been running the script for over six months. Today when I got home I notice the script was stating an error.
[DATABASE ERROR:]1030: Got error 127 from table handler

Can anyone tell me what is wrong with it ?

Thanks

JamieWolf

11-07-2004, 16:38

Hi there :)

I heard Gryphon is currently on developing Version 4.2 of his script, hope its going fine. I myself are currently recoding the hole script (4.1.7) to classes, so it will be easyier to include it in Portalsystems like Nuke or what ever.

I'm also on a new way of templateing the hole Script, with just two or three files (maybe some more, who knows I didn't finish it)
So far everything is working fine.

Greetz JamieWolf

p.s. Just wanted to give out the info :)

AnthonyB

12-07-2004, 11:15

Thanks for the update - was wondering what was going on in the background ;)

AnthonyB

23-07-2004, 08:58

So, has anyone tried this with PHP v5.0 yet? If so, does it all work OK?

Gav-Aus

29-07-2004, 09:50

I can't get the installer to work. IDK why it won't. I have the 4.0.1.7 version.

Here's my other important info:

PHP version: 4.3.7
MySQL version: 4.0.18-standard
Apache version: 1.3.31 (Unix)

Config:
$gllcts2_dbhost = "localhost";
$gllcts2_dbuser = "prefix_ts2";
$gllcts2_dbpass = "XxXxXxXx";
$gllcts2_dbname = "prefix_teamspeak2";
$gllcts2_dbprefix = "teamspeak2_";

Whenever I try to run the install script I get this error:
-----------------------------------------------------------------------------------------
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@warmart.hostcubix.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/1.3.31 Server at warmart.hostcubix.com Port 80
-----------------------------------------------------------------------------------------

I tried to change my permission settings and reuploading, switching the user and db names around in the config, nothing works. Can someone please help?

I have spent the last few days on and off trying to get this to work and so far dead in the water. I had the last version and it ran without issue for such a long time, then for some reason the info would not show on the site. I read a number of others having the same issue so left things alone. Then I found and read right through this thread, downloaded the latest version and this is where the last few days came to play.

I have the same issue as above, have tried this and that without result and now give up, I wish to pass thanks to the creator for his time and effort, this is not stab because I can see loads of people have theirs working so I know that the issue is me :) so cheers again and I will keep an eye out for any new news.

McAfee

30-07-2004, 05:15

If you actually read this thread, you'll notice I already replied to that specific error...
Did you try that solution?

Gav-Aus

30-07-2004, 07:50

Try NOT using the .htaccess file that is supplied with gllcTS2. Simply delete it from your webpost folder.

Yes Sir, that I did.. as said it's cool we ran our four TS servers without it on our web site prior and we can do it again :)

Germeshausen.de

01-08-2004, 18:28

While changing the message of the day and submitting it i get this error:
Not Acceptable

An appropriate representation of the requested resource /admin/index.php could not be found on this server.

leaving the field blank, there is no error.

Version 4.17

Update: Without html-tags there is no error upcoming.

silat

09-08-2004, 11:44

hello, im trying to make your nice script working and i have the msg when i go details :
Data unavailable.
TCPQueryPort may not be open.
okay, im behind a hardware router/fw and both 8767 and 14534 ports are opened and mapped to the server.
server works fine, also is web administration
have i forgotten something??
thxxx for ur work

drake008

10-08-2004, 11:02

Well i get a error message like

"Could not connect to main MySQL."

Why???

silat

10-08-2004, 14:36

ok, i find my solution lol,
theres a third port to open and map : 51234
:D

silat

10-08-2004, 14:38

-> Drake
did u change the file admin>config.php.new with your sql database settings, and saved this file as config.php?

drake008

10-08-2004, 16:39

Well actually I don`t know much about all this :eek: . Well in the config.php (from the admin dir) there is just a change in the password that i made. Everything else was left untouched. I made a new database called "gllcts2" in the php directory.

So just the password made a change. It looks like so here

<?
// Begin User Config

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

// End User Config

silat

10-08-2004, 18:21

are you sure of ur dbhost and dbuser values?
well it seems you're hosting ur own php/mysql server isnt it?

drake008

10-08-2004, 18:43

Well i try it with XAMPP to host all this things on a second machine.

And there are some mistakes in this config file ??? Maybe you can get me some hints???

K9Trooper

10-08-2004, 20:18

Drake here is a dumb question but has to be asked...
Did you go in to MySQL and create the database cannister "test2" and right click on the canister and click "Connect"?

If you haven't already got here ( http://dev.mysql.com/downloads/other/mysqlcc.html ) and get the MySQL Control Center. It will help you setup and connect the database easier.

drake008

10-08-2004, 21:26

Well I didn`t make the connect ... It is obvious that I`m absolute new to this, is it?

After that you have to make some changes in the TS Server, or? Well, I made these changes:

Server WebPost PostUrl: http://www.xyz.com/webpost.php
Server WebPost LinkUrl: http://www.xyz.com

If I call the site localhost/webpost.php i`ll get this message now:

Parse error: parse error, unexpected T_PRIVATE in webpost.php on line 72

Maybe it`s a little bit too much for just one TS server ... maybe there is something, like a little RED or GREEN Dot on my page to see if the server is on or off ....

FireMarshal

12-08-2004, 10:40

I have everything install correctly I believe, I have no errors of any kind and my page pulls up fine (admin and index) but does not list my TS server. I have no firewalls and ports are all open. I have TS pointing at my webpost.php but still nothing showing on the list. Any thoughts and or any questions to further identify the issue?

Server Info
--------------------------------------------------------------------------------
gllcTS2: v4.1.7
PHP: v4.3.8
MySQL: 4.0.20-standard
Server: Linux
PHP Info

K9Trooper

24-08-2004, 19:03

I am having an issue with webpost. I had it working until I updated my Apache, My SQL and php. Once I did that all went sour. I had in the past 2 main servers w/ a total of 5 sub-servers listed. 2 on the local and 3 on a different box w/ different IP's. Now I get no responce.

Server Info
-----------------------------
gllcTS2: v4.1.7
PHP: v5.0.0
MySQL: 4.0.20a-nt-log
Server: WINNT

Is there an issue with PHP 5.0.0 or MySQL 4.0.20? It is on a Windows 2003 box.

Gryphon

26-08-2004, 01:03

I have not tested it with php5, but from reports it sounds like it does not work.

hideos

26-08-2004, 01:46

How do I change the Submit button, from the login.php, so that it opens in a new window. Or change submit so that it does this action directly: (teamspeak://:/nickname=?loginname=?password=?channel=opa-ages?channelpassword=)?

The reason why I need it to open in a new tab/window, is that I am trying to use TeamSpeak for an IRC channel.

Here is a pic of what I am trying to do:
http://hideos.mine.nu/uploads/teamspeak.jpg

I would link to the site, but I am still trying to get it to work. i.e constant changes.

hideos

26-08-2004, 12:00

nvm. Sorted it. :)

K9Trooper

26-08-2004, 18:12

I have not tested it with php5, but from reports it sounds like it does not work.

Any idea on when it will be updated to work with php5?

Gryphon

27-08-2004, 20:40

Any idea on when it will be updated to work with php5?
I don't have any plans to upgrade to php5 for a while unfortunately.

gAlAX-e

05-09-2004, 16:02

Hi.

Server Info
gllcTS2: v4.1.7
PHP: v4.3.3
MySQL: 4.0.15-max-debug
Server: WINNT

I've installed the script and configured it. No errors so far, but it doesn't show any active server. The server is running and working and i have triplechecked all configurations.

I've seen the replies in this thread of people having the same problem, but i didn't see any solution yet.

any help would be appreciated :)

gAlAX-e

05-09-2004, 16:55

I'm sorry, ignore my last post, it was my firewall blocking :rolleyes:

/me slaps himself with a misconfigured firewall

However, that script is great, thanks a lot for releasing it as freeware!

Goodnight

15-09-2004, 15:04

A little problem i guess

I uploaded the webpost script to /webpost as a subdirectory

Configured the config.php

Then i entered http://myserver/admin/install.php

This error occured

Parse error: parse error, unexpected $ in /.../admin/install.php on line 209

register globals=on

The php Version is PHP Version 4.3.8

There is no Var at Line 209 ..

Thanks for help

Goodnight

nEo-1664

28-09-2004, 16:00

I need some help installing the script. I cant get onto Step 2. I click the button with all the data correctly inputte for connection to the database, the link in the address bar changes for Step 2, but the page itself nor do any of the contents actually change. Any ideas ? (I am using the lastest version of the download btw)

MondragU

06-10-2004, 19:47

Hi all :)

In German:

ist hier zufällig jemand der mir eventuell eine 2 listing.php schreiben könnte die nur den Teil Users and Channel enthält für einen Server. Denn das ganze drum herum bracuh ich nicht und gefällt mir auch net so recht. Leider kann ich es nicht selber :(. Die Funktionalität der Anmeldung als Reg oder Anony. sollte enthalten bleiben. Das wär klasse.

In Englisch
i have a question, iss here every one how can code me sec listinig.php that showns only the Users & Channels Area? without the tables at the top?

Sorry for my bad English.

Mondragu

Germeshausen.de

06-10-2004, 20:02

Ja, wäre möglich. Ich schau mal. Gib mir ein wenig Zeit und dann sehen wir mal weiter.

Gruß Crow

Edit: 21:48
Werf mal einen Blick auf meine Seite. Ich denke du findest die Lösung in den News :D Falls Du Fragen dazu hast, wende dich einfach an unser Forum. So können später noch mehr Leute damit arbeiten. Eventuell kommen noch bessere Modifikationen oder Ideen zu Stande.

MondragU

07-10-2004, 14:57

Wollt nur sagen habs hinbekommen :) Hab einfach das Webpost bearbeitet und rausgeschmissen was ich eh nicht brauche :)

Zu sehen HIER (http://www.rapid-action-warriors.net/).

Einfach oben auf Teamspeak klicken :)

Gruß

Mondragu

Zunaynu

11-10-2004, 23:18

I am new to this whole experience and from what I've read about webposting I am very interested in it. I followed the installation instructions but when I try to use the admin/install.php I get this error: Could not connect to main MySQL. What do I need to do to get this working on my website? Any help will be very much appreciated!!! :D

Updated: May 25, 2004
This script has been downloaded 15,520+ times as of April 30, 2004

Current version: 4.1.7
Your config.php must be updated with the release of 4.1.6

Here is my webpost script for TeamSpeak 2. Please post any bugs or any changes or feature suggestions. This webpost was originally meant for showing multiple servers at once and is not optimized for single server situations. So if it isn't quite as customizable as you want, remember it was meant for multiple servers not just one.

This script will support 24-30 servers with moderate server load, more than that and you will notice significant server loads.

Thanks,
Enjoy! :)

This was developed on
PHP 4.3.3
mySQL 4.0.18

DJHotIce

12-10-2004, 02:34

I found a fix to those who claim they have the Error

Data unavailable. TCPQueryPort may not be open.

This may be caused by the TeamSpeak Server not reconizing the server is locally contained on the same system. To correct this we need to tell the script to reconize its real world ip address. I have also discovered that the error may be contributed by the fact that the Team Speak Server is unable to find a real-world IP address, this is shown in the log file.
ERROR,All,frmMain, unable to detect external ip Anyways we will fix this problem.

1) Top apply this mod open up the webpost.php page found in your root folder
2) Look For
$server_ip = getenv("REMOTE_ADDR");
if ($server_ip == '') {
$server_ip = $HTTP_SERVER_VARS["REMOTE_ADDR"];
} It is line 33 on this system.
3) Apply the following code below that code on line 34.
if ($server_ip == '192.168.1.1') {
$server_ip = $_SERVER['SERVER_NAME'];
}

Wait a while as it may take a while for the TS server to repost the data. The default if specified in your admin config is 5 mins. The old results will die within that specified amount of time. This will only work on gllcts2 4.1.7. It may work with previous and soon to come releases of the code, however hasn't been tested. I am not responsible for damages! I hope the author corrects this in the code to prevent this problem in the future. Please verify if this works for you!

Easyy-S

18-10-2004, 10:57

hello @ all

i have a problem with the settings of gllcts2

i installed it on my server and everything seems fine.

but wen i try to edit the settings ( ../admin/index.php ), i got everytime the loginpage.
klick on "settings" = loginpage
klick on "email admins" = loginpage

i cant edit anything :(

i tested it with the firefox, konqueror, msie.

can it be, that there ist something missing on my webserver ?
i run the apache2 on my suse 9.1 server.

jscorrea

18-10-2004, 16:24

Easyy-S

18-10-2004, 17:00

Me he seems that in the archive webpost.php is that I must place my server of TS I am correct?

yes thats right

jscorrea

18-10-2004, 20:55

:)
But, why do not appear the server on my list?

This is my page:

VIPER TEAM SPEAK (http://instaseg.com.br/xoops/modules/xoops_teamspeak/groups.php)

user: GUEST
pass: GUEST

In this lines what is a correct values? :

f ($server_ip == '200.218.170.3'){//<-- LOCAL IP ADDRESS
$server_ip = "teamspeak.tswn.com";//<-- WAN IP ADDRESS

Regards
JS

DJHotIce

19-10-2004, 14:27

I installed the version for Xoops, configured my data base, followed the steps and all good so far. :)

Me he seems that in the archive webpost.php is that I must place my server of TS I am correct?

Is here the line will are edited?:

if ($server_ip == '200.218.170.3'){//<-- LOCAL IP ADDRESS
$server_ip = "teamspeak.tswn.com";//<-- WAN IP ADDRESS

In my case the server is 200.218.170.3:8767

Look this link of my server stats:

WSTATION (http://games.wstation.com.br/ts/listing.php?detail=192.168.0.100&detailport=8767&page=1&sort=server_name&direction=asc&showgroup=all)

Thanks for help and sorry for my bad english :rolleyes:

Ok maybe I didn't explain myself real clear... Sorry bout that :)

The first one is the actual internal router IP address most have this at what I set above, use this. If your network also holds the web server, (NOT pertaining to TS at this moment) then leave the second line alone. This will set the external ip address correctly (if your server config is set up correctly). Also the External IP address can be inserted in the 2nd Line.

DJHotIce

23-10-2004, 16:39

You may need to ipconfig /all in your msdos screen, or in your run menu type in winipcfg

AndreasB

05-11-2004, 21:44

Does anyone know this Error Message by admin/install in Browser?
My Database and PW are also correct. This Message is on other Servers too.

Warning: main(): Unable to access ./admin/config.php in /srv/www/htdocs/web1/html/TS/admin/db_inc.php on line 26

Warning: main(./admin/config.php): failed to open stream: No such file or directory in /srv/www/htdocs/web1/html/TS/admin/db_inc.php on line 26

Warning: main(): Failed opening './admin/config.php' for inclusion (include_path='.:/usr/share/php') in /srv/www/htdocs/web1/html/TS/admin/db_inc.php on line 26
Unable to select database.

McAfee

06-11-2004, 08:13

This usually happens when you don't configure the config.php.new file and rename it to config.php

Check the ReadMe

AndreasB

07-11-2004, 15:28

thats it. THANK YOU :o

AndreasB

15-11-2004, 10:01

Why it always show the Users on the TS from Yesterday after one day -> under <Details> (the stats of the menu are all right)? Did this not refresh automatically - whats the refreshing time?

zike

21-11-2004, 16:36

I installed it on my TeamSpeak server,but no servers are being shown even after 1 hour:
http://www.wettstein.us/ts2/listing.php

Anyone got any ideas what would cause it not to read the TeamSpeak Servers currently running? Thanks

Germeshausen.de

21-11-2004, 16:53

Have you entered the correct path to your webpost.php in the admin control panel of your teamspeak server?

K9Trooper

29-11-2004, 19:28

Is there any plans to get this compatable with php 5 yet?

Gryphon

30-11-2004, 22:18

No plans at the moment. I believe McAfee has got it working on php5.

cactus5

01-12-2004, 01:03

Hello Gryphon I would like to thank you for your last script i use, it work very well, but now is time to upgrade everything.
my problem is when doing the browser install Im only getting 3 out of the 5 tables in mysql database. No errors installing.

this is the Config file info:
: // Begin User Config

$dblink = "localhost"; // Host
$dbuser = "ts2"; // Username
$dbpw = "XXXXX"; // Password
$dbname = "teamspeak2"; // Database
$dbprefix = "teamspeak2_"; // Prefix for tables

// End User Config

I created a folder called teamspeak2, and unzip the files to that location.:
http://www.localhost/teamspeak2/

This is what is supposed to be installed.

Table 1: teamspeak2_weblist
Table 2: teamspeak2_user
Table 3: teamspeak2_channel
Table 4: teamspeak2_group
Table 5: teamspeak2_admin

But it only creates 3 tables not 5:

teamspeak2_admin
teamspeak2_channel
teamspeak2_group

Im missing teamspeak2_weblist and teamspeak2_user in my database.

And here is the error I get when viewing from the browser:

Active Servers: MySQL Error in [SELECT * FROM teamspeak2_weblist]: Table 'teamspeak2.teamspeak2_weblist' doesn't exist

Please contact a the site admin immediately.
--------------------------------------------
MySQL Error in [delete from teamspeak2_weblist where (server_timestamp + 900) < '1081672042']: Table 'teamspeak2.teamspeak2_weblist' doesn't exist

Please contact a the site admin immediately.
--------------------------------------------
Please if anyboby could help, I will very thankfull.

Cornish

01-12-2004, 12:22

Hi,
I'm using PHP 4.3.6 and I get the same prob you have spoken about, but how can I solve it?
Pls link me the modifications I have to put.
Thank you very much.

udshannibal

05-12-2004, 00:25

I too have iinstalled the script from Gryphons (gllscts2) and I am getting no response from the server. I rent my dedicated server from Defconservers. I have admin rights and have changed the Server WebPost PostUrl and Server WebPost LinkUrl several times thinking I may have added the wrong url's & links but nothing either way I try. I have gone perfectly thru the readme's and installed the database a couple of times to assure proper installation. Still nothing. HELPPPPPPP!

UDS Hannibal :(

Website: http://www.csprag.com/udsclan

SLN

14-12-2004, 10:06

Same problem as: cactus5.

KOM

31-12-2004, 02:11

OK i'm having a little truble with this thing. I have it al installed. It looks like it is working ok but one thing . when I hit details where you would see the people that our in my server is just says

___
Data unavailable.
TCPQueryPort may not be open.
___

But yet if I go to some one's page that use's the same thing I can see all the people fine. So why can't I see them in mine ?

http://www.wvgl.net/ts2/groups.php

KOM

02-01-2005, 21:12

Man I love the help here

I was talking to our TS host and this is what he said.

kombat2010: can you help with this .
kombat2010: I'm not sure if it's on your end or not
kombat2010: http://www.wvgl.net/ts2/listing.php?detail=69.9.161.68&detailport=8806&page=1&sort=server_name&direction=asc&showgroup=all
kombat2010: TCPQueryPort may not be open.
KobazMYG: its open
kombat2010: that's just what the app says
kombat2010: somthing is not try
kombat2010: I have tryed 7 diff ones
kombat2010: and none of them work
KobazMYG: the only port that will work for the query port is the query port listed in the control panel
kombat2010: yea I have telneted it
kombat2010: hmm
kombat2010: that's what I have in there
kombat2010: *************************
$ip = "69.9.161.68"; // IP Address to server
$tPort = "14572"; // Server QueryPort number
$port = "8806"; // Port number to the TS2 server

KobazMYG: theres most likely a bug in the app your using then
kombat2010: k

So there you have it.

mrdeath

03-01-2005, 13:53

Man I love the help here

I was talking to our TS host and this is what he said.

So there you have it.

Do you have the TS2 server and the gllcts2 on the same pc? Win or Linux? the "hosts" file may help you (win = C:\<win dir>\system32\drivers\etc\hosts Linux = /etc/hosts), set "192.168.0.100 your.hostname.com" (or whatever you have).. this “may” help..

But I don’t think it’s a problem I the app. More likely to be connection problem between the two app.’s ..

tossnig

23-01-2005, 11:01

Hello,

I get the following error:

---------------------------------------------------------------------
MySQL Error in [ DELETE FROM gllcts2_weblist WHERE (server_timestamp + ) < '1106474188' ]: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') < '1106474188'' at line 1

Please contact a the site admin immediately.
---------------------------------------------------------------------

Can someone help?

ScratchMonkey

23-01-2005, 11:21

What's in the source code after the plus sign? Looks like it's expanding to an empty string instead of some constant.

tossnig

23-01-2005, 11:26

I think its coming from db_inc.php

if ($var1 != '0' && !preg_match("/admin/i", $PHP_SELF)) {
query("DELETE FROM $dbtable1 WHERE (server_timestamp + $var1) < '$server_timestamp'");
query("DELETE FROM $dbtable2 WHERE (server_timestamp + $var1) < '$server_timestamp'");
query("DELETE FROM $dbtable3 WHERE (server_timestamp + $var1) < '$server_timestamp'");
query("DELETE FROM $dbtable4 WHERE (server_timestamp + $var1) < '$server_timestamp'");
}

Gryphon

24-01-2005, 22:56

I think I broke something when I made a minor change to try and fix a glitch and made it worse. I have released a new version, I hope it fixes some problems that have been around.

-BW-Renegade

26-01-2005, 07:36

ok this may be simple but im not new to php but im stumpbed

i installed your software

http://www.bwclan.net/home/modules/ts2/listing.php

and i get a error

-BW- Primary TeamSpeak
Data unavailable.
TCPQueryPort may not be open.

but the port is open what do i need to do to fix this also i was going to try to edit the config like mentioned like page 2-3 but me config looks nothing like the one you have posted here

The Mole

29-01-2005, 08:51

I cant get it to work, it writs this "Could not connect to main MySQL"
Try it your selv http://www.clan-kgsl.dk/gllcts2_4.2.0/ :confused:

The Mole

29-01-2005, 09:00

Im new at php and MySql

swtdivalove

29-01-2005, 21:13

You need to make sure the config.php file points to your MySQL host.

$gllcts2_dbhost = "yourhost"; //

You also need to make sure that you have access to the datbase.

Serval_nl

02-02-2005, 23:31

Gryphon,

Can you hlep me with this piece of code?
It seems to be all that is standing in the way for usage with PHP 5:

From the webpost.php:
if ($server_ispname == 'na') {
$server_ispname = Private;
}

This code gives and Unexpected T_Private error
When I remove it the script runs OK.

What is it meant for exactly?
Will still all servers be listed OK if it is not there?

McAfee

04-02-2005, 19:10

Add quotes to Private, either single quotes or double quotes.

Examples:
$server_ispname = 'Private';
or
$server_ispname = "Private";

Gryphon

04-02-2005, 19:34

I have finally made the changes specified by McAfee and released 4.2.1, sorry for the delay in making those changes.

Berbe

23-02-2005, 21:51

Hi !

I would like to know how does SQL fields have changed since v4.1.7...

You've added 3 in the***_admin table, but is that all ?

Because I don't wan't to delete my fiels and re-install them : I've spent a lot of time to configure colors and theme... I don't want to do that again at all...

Can u help me ?

Berbe

23-02-2005, 22:48

I've a problem with the script...
The script saus that "data is unavailable"

My TCPQueryport was set to : 51234 (default)
So I've checked the SQL database and I was surprising to discover that in the table "weblist", server_queryport was set to 8767...

Then I've changed the TCPQueryport port to 8767 (in the .ini file)

Then, I've set the redirection in my router to join the 8767 TCP port from the router to the 8767 TCP port of my computer... (The UDP redirection from 8767 to 8767 has already been set, and there's no problem : players can connect on my server...)

But nothing has changed... The script can't recover data...

Can you explain me what I've to do ?

P.S. : These tests have been made on another server, where gllcts2 has been installed in a clean place with the brand-new version...

Berbe

24-02-2005, 22:51

I have done some other tests...

I have configured my router in DMZ (for those who don't know what is it : it means that all ports of the router are redirected on my computer).

The problem appears when the script attempt to connect to the server...

in the "admin/db_inc.php" file, we can see that, on the function "insertchannelinfo", "fsockopen" is used.

My test creates an entry in a test table (that I've previously created) :
"rien" if !$connection
"connexion" if $connection
and on each time, errno, and errstr is logged...

And the result is :
"rien", errno = 0, and errstr is empty

Or on the page http://www.zend.com/manual/function.fsockopen.php, we can read that :

If the call fails, it will return FALSE and if the optional errno and errstr arguments are present they will be set to indicate the actual system level error that occurred in the system-level connect() call. If the value returned in errno is 0 and the function returned FALSE, it is an indication that the error occurred before the connect() call. This is most likely due to a problem initializing the socket. Note that the errno and errstr arguments will always be passed by reference.

Depending on the environment, the Unix domain or the optional connect timeout may not be available.

The socket will by default be opened in blocking mode. You can switch it to non-blocking mode by using stream_set_blocking(). (http://www.zend.com/manual/function.stream-set-blocking.php)

Is that a way to solve the problem ?

Please help, I really want to understand all that ! :eek: :D :p

Bye !

[EDIT]
Or if you aren't interested in solving the problem, just explain me how to use "stream-set-blocking", because I think I haven't understood that... Thanks !

AOD*Cruiser

02-03-2005, 23:21

this is my sever ini

can ya look tell me if its ok dont work .the web posting

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL
[Main Config]
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}
BoundToIp1=
[WebPost]
AdminEmail=cruiser@teamaod.net
ISPLinkURL=http://www.teamaod.net
ISPName=AOD
ISPCountryNumber=2421
Enabled=1
PostURL=http://www.teamaod.net/gllcts2/webpost.php
ListPublic=0
UserAgent=teamspeak
[log]=1
access_r=0
access_u=0
channel_registerred=0
channel_unregisterred=0
sa=0
chat=0
kick_server=0
kick_channel=0
[Spam]
max_commands=10
in_seconds=2

my web post is

include("./admin/db_inc.php");

if (empty($_POST['server_port'])) {
// header ("location: $setting[homepage]");
}

if ($_POST["gllc_posttest"]) {
$server_ip = $_POST["gllc_posttest"];
} else {
if (getenv("HTTP_X_FORWARDED_FOR")) {
$server_ip = getenv("HTTP_X_FORWARDED_FOR");
if ($server_ip == '') {
$server_ip = $_SERVER["REMOTE_ADDR"];
}
$server_ip = preg_replace( "/,.*$/", "", $server_ip );
} else {
$server_ip = getenv("REMOTE_ADDR");
if ($server_ip == '') {
$server_ip = $_SERVER["REMOTE_ADDR"];
}
}
}

$r = query("SELECT * FROM $dbtable5 WHERE listips LIKE '%$server_ip,%'");
$r2 = query("SELECT * FROM $dbtable1");
$r3 = query("SELECT * FROM $dbtable1 WHERE server_ip = '$server_ip'");
if (mysql_num_rows($r) == '0' && mysql_num_rows($r2) >= $setting["listamount"] && mysql_num_rows($r3) == '0') {
exit;
}

$server_port = $_POST["server_port"];

$sql = query("SELECT * FROM $dbtable1 WHERE server_ip='$server_ip' AND server_port='$server_port'");

$server_adminemail = urldecode($_POST['server_adminemail']);

$server_isplinkurl = urldecode($_POST['server_isplinkurl']);
if (isset($server_isplinkurl) && $server_isplinkurl != 'na' && $server_isplinkurl != '') {
if (preg_match("/http:\/\//i", $server_isplinkurl)) {
$server_isplinkurl = $server_isplinkurl;
} else {
$server_isplinkurl = 'http://'.$server_isplinkurl.'';
}
}

$server_linkurl = urldecode($_POST['server_linkurl']);
if (isset($server_linkurl) && $server_linkurl != 'na' && $server_linkurl != '') {
if (preg_match("/http:\/\//i", $server_linkurl)) {
$server_linkurl = $server_linkurl;
} else {
$server_linkurl = 'http://'.$server_linkurl.'';
}
}

$server_name = urldecode($_POST['server_name']);
$server_name = trim(str_replace("", "", $server_name));

$server_ispname = addslashes(urldecode($_POST['server_ispname']));
$server_ispcountry = addslashes(urldecode($_POST['server_ispcountry']));

$server_password = addslashes(urldecode($_POST['server_password']));

if ($server_ispname == 'na') {
$server_ispname = 'Private';
}

//$server_uptodate = ''.$_POST["server_version_major"].''.$_POST["server_version_minor"].''.$_POST["server_version_release"].''.$_POST["server_version_build"].'';

//if ($server_uptodate < "201940") { // Enter the version number you wish to allow, no decimals. Anything under this version will not be allowed.
// exit;
//}

// update existing server
if (mysql_num_rows($sql)!= 0) {
query("UPDATE $dbtable1 SET
server_adminemail='$server_adminemail',
server_isplinkurl='$server_isplinkurl',
server_ispname='$server_ispname',
server_ispcountry='$server_ispcountry',
server_platform='$_POST[server_platform]',
server_version_major='$_POST[server_version_major]',
server_version_minor='$_POST[server_version_minor]',
server_version_release='$_POST[server_version_release]',
server_version_build='$_POST[server_version_build]',
server_ip='$server_ip',
server_port='$server_port',
server_name='$server_name',
server_uptime='$_POST[server_uptime]',
server_password='$server_password',
server_type1='$_POST[server_type1]',
server_type2='$_POST[server_type2]',
clients_current='$_POST[clients_current]',
clients_maximum='$_POST[clients_maximum]',
channels_current='$_POST[channels_current]',
server_linkurl='$server_linkurl',
server_queryport='$_POST[server_queryport]',
server_timestamp='$server_timestamp'
WHERE server_ip='$server_ip' AND server_port='$server_port'");
} else if ($server_port) {
// insert new server
query("INSERT INTO $dbtable1
(server_adminemail,
server_isplinkurl,
server_ispname,
server_ispcountry,
server_platform,
server_version_major,
server_version_minor,
server_version_release,
server_version_build,
server_ip,
server_port,
server_name,
server_uptime,
server_password,
server_type1,
server_type2,
clients_current,
clients_maximum,
channels_current,
server_linkurl,
server_queryport,
server_timestamp)
VALUES
('$server_adminemail',
'$server_isplinkurl',
'$server_ispname',
'$server_ispcountry',
'$_POST[server_platform]',
'$_POST[server_version_major]',
'$_POST[server_version_minor]',
'$_POST[server_version_release]',
'$_POST[server_version_build]',
'$server_ip',
'$server_port',
'$server_name',
'$_POST[server_uptime]',
'$server_password',
'$_POST[server_type1]',
'$_POST[server_type2]',
'$_POST[clients_current]',
'$_POST[clients_maximum]',
'$_POST[channels_current]',
'$server_linkurl',
'$_POST[server_queryport]',
'$server_timestamp')");
}

if ($server_port) {
$ts_version = "$_POST[server_version_major]" . "$_POST[server_version_minor]" . "$_POST[server_version_release]" . "$_POST[server_version_build]";
insertchannelinfo($server_ip, $_POST["server_queryport"], $server_port, $ts_version);
insertuserinfo($server_ip, $_POST["server_queryport"], $server_port, $ts_version);
}

$sqlg = query("SELECT * FROM $dbtable4 WHERE group_ispname='$server_ispname'");

// update existing server
if (mysql_num_rows($sqlg)!= 0) {
$sqlg2 = query("SELECT * FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$groupservercount = mysql_num_rows($sqlg2);

if (($server_ispname == 'Private') or ($server_ispname == '')) {
$server_ispname = 'Private';
$server_isplinkurl = 'na';
}
$sqlg3 = query("SELECT sum(clients_current) FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$sqlg3data = mysql_fetch_row($sqlg3);

query("UPDATE $dbtable4 SET group_ispurl='$server_isplinkurl', group_ispname='$server_ispname', group_servers='$groupservercount', group_users='$sqlg3data[0]', server_timestamp='$server_timestamp' WHERE group_ispname='$server_ispname'");
} else if ($server_ispname) {
// insert new server
$sqlg2 = query("SELECT * FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$groupservercount = mysql_num_rows($sqlg2);

if (($server_ispname == 'Private') or ($server_ispname == '')) {
$server_ispname = 'Private';
$server_isplinkurl = 'na';
}
$sqlg3 = query("SELECT sum(clients_current) FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$sqlg3data = mysql_fetch_row($sqlg3);

query("INSERT INTO $dbtable4 (group_ispurl,group_ispname,group_servers,group_us ers,server_timestamp) VALUES ('$server_isplinkurl','$server_ispname','$groupser vercount','$sqlg3data[0]','$server_timestamp')");
}
?>

this is what i get on my web page

Data unavailable.

- [0/32]
gllcTS2
Last Updated

AOD*Cruiser

03-03-2005, 01:26

why is it that the webpost shows 1/32 online in stead user name .
it seem to work . if i log out of ts 0/32 .

Data unavailable.
- [1/32]
gllcTS2 <gllcts2/listing.php?detail=70.68.163.14&detailport=8767>
Last Updated:
4:15 PM

sunnlite

09-03-2005, 16:14

Germeshausen.de

25-03-2005, 23:47

@ Gryphon

This script will support 24-30 servers with moderate server load, more than that and you will notice significant server loads.

Since when is this information in the first post of this thread? we have around 100 servers in our webpost list (http://germeshausen.de/index.php?act=teamspeak&cat=tsserver) without any problems. Does this problem beginn with a special version or does it happen in all versions?

Greetz Crow

{KBE}Dragon

29-03-2005, 21:57

ok hope someone can find this one lol i was wondering about posting ones ts server on a webpage how would you do tht for only ONE ts server

DareDoo™

17-04-2005, 02:28

Warning: main(./config.php): failed to open stream: No such file or directory in /home/adr/public_html/admin/install.php on line 25

Warning: main(./config.php): failed to open stream: No such file or directory in /home/adr/public_html/admin/install.php on line 25

Warning: main(): Failed opening './config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/adr/public_html/admin/install.php on line 25

Notice: Undefined variable: gllcts2_dbprefix in /home/adr/public_html/admin/install.php on line 27

Notice: Undefined variable: gllcts2_dbprefix in /home/adr/public_html/admin/install.php on line 28

Notice: Undefined variable: gllcts2_dbprefix in /home/adr/public_html/admin/install.php on line 29

Notice: Undefined variable: gllcts2_dbprefix in /home/adr/public_html/admin/install.php on line 30

Notice: Undefined variable: gllcts2_dbprefix in /home/adr/public_html/admin/install.php on line 31
Unable to select database.

why do I get those errors? the domain is www.adr-clan.com. that is located at http://www.adr-clan.com/admin/install.php

Gryphon

27-04-2005, 01:38

If it is your first time using the script, rename config.php.new to config.php

PV2-Rinaldi[9TEF]

06-05-2005, 06:18

Hey,

Was wondering about this error?

MySQL Error in [ DELETE FROM group WHERE server_timestamp < (1115352909 - 900) ]: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group WHERE server_timestamp < (1115352909 - 900)' at line 1

direwolf

02-06-2005, 12:43

Having a problem that just seemed to appear out of nowhere............had the script configured and working for about a week now....then all of a sudden ( I hadn't changed a thing!)....I'm getting the following where the current channels and users should be shown:

Data unavailable.
TCPQueryPort may not be open.

Again, I have not changed any port settings or anything....happened overnight.........

Any ideas????????????????????????????????

Yep same thing happened to me. Still trying to work out why it is doing it. the script is detecting the server and shows the number of users connected. Just won't show any detail in the chan/user area?????

Berbe

02-06-2005, 19:12

Ok guys... Most of people using this script have problems with the new version... So it isn't hard to deduce that the author has wanted to change a part of the code without knowing all the effects that included... So now, most of the users have a great brand-new code which doesn't work at all...

Is there anyone who hasn't updated its script ? Thanks a lot...

FatesODB

03-06-2005, 00:33

Yep same thing happened to me. Still trying to work out why it is doing it. the script is detecting the server and shows the number of users connected. Just won't show any detail in the chan/user area?????

This is the problem that I am seeing and I am still running the 4.1.7 version. I don't think the problem is in the script...it's in the webhost?

http://forum.goteamspeak.com/showthread.php?t=22503

My webhost just went thru a huge DoS attack, and put up a firewall and blocked even daily users from coming to my website. In the process, my TSWebpost went haywire and so did my AAO Tracker Webpost. All fingers are pointing to my Webhost on this one.

Fates

direwolf

03-06-2005, 09:18

Thanks for that. I have emailed my webhost to see if the port is blocked or not.

EDIT: My webhost opened up the port and now all is good :)

Berbe

03-06-2005, 18:33

I used to make the script working on my computer configured as a server... It worked properly, bue since some things has been changed, there's no way to make the code working... No-one can explain why (including Gryphon), and I would like to know the history of the script, it'd be very helpful...

Nilrym

02-07-2005, 18:56

Ok, sounds like the connection from the ts2 host to the web server works. Now let ts2 run and see if your web logs show any posting to that URL.

Hello,
I've got my TS2 Server on a franken-box that's running Redhat 9 on my internal lan. I'd like to put webpost out on my web host (on my domain). I set up the config.php like this:

$gllcts2_dbhost = "runichearth.game-host.org:51234"; // Host
$gllcts2_dbuser = "adminlogin"; // Username I set up an account on my TS server for this.
$gllcts2_dbpass = "adminpassword"; // Password

My TS server is routed thru DynDNS to get the above domain.
I can telnet into my TS server and login just fine, but when I try to go to the admin page (http://www.runichearth.com/ts/webpost/admin ) to get things set up it takes forever I get this:

Could not connect to main MySQL.

My host provider gives me a MySQL database that I can admin with mysqladmin.

How do I connect the two to get things working?

Berbe

03-07-2005, 11:06

Teamspeak has its own mySQL server...

I don't know if you can change the configuration to use another mysql server, but it could be very nice, as well :)

I think that, to allow this, it's program files that need to be changed... Maybe I'm wrong... Maybe staaf could explain you, or release a special version which allow to use your own mySQL server :D

Bye

Nilrym

04-07-2005, 07:18

Ok,
I thought there was a mysql server in TS ... just not sure how to access it... I guess the main thing I'm looking for is how to point thie following code to the mysql files in my TS dir
DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=Your_Database_Name_Here
Hostname=The_PC_the_MySQL-Server_is_on
User_name=User_name_on_the_MySQL-Server
Password=Password_to_go_with_above_user_name
GetDriverFunc=getSQLDriverMYSQL
VendorLib=path_pointing_at_your_mysql_vendor_lib
LibraryName=path_to_libsqlmy_libary
Active=1

bigshooter

31-07-2005, 23:27

Getting this Error. I've seen it before but everything ive tried to fix it has failed.

Warning: main(./config.php): failed to open stream: No such file or directory in C:\webpages\Hosts\KOS\webpost\admin\install.php on line 25

Warning: main(): Failed opening './config.php' for inclusion (include_path='.;c:\php4\pear') in C:\webpages\Hosts\KOS\webpost\admin\install.php on line 25

Notice: Undefined variable: gllcts2_dbprefix in C:\webpages\Hosts\KOS\webpost\admin\install.php on line 27

Notice: Undefined variable: gllcts2_dbprefix in C:\webpages\Hosts\KOS\webpost\admin\install.php on line 28

Notice: Undefined variable: gllcts2_dbprefix in C:\webpages\Hosts\KOS\webpost\admin\install.php on line 29

Notice: Undefined variable: gllcts2_dbprefix in C:\webpages\Hosts\KOS\webpost\admin\install.php on line 30

Notice: Undefined variable: gllcts2_dbprefix in C:\webpages\Hosts\KOS\webpost\admin\install.php on line 31
Could not connect to main MySQL.

I'm nearly positive that it stems from my MYSQL database. Am I supposed to be using the one that is embedded in the TS2 server? Or my own mysql database? If its the TS2 one, how do I enter that information in the config.php field? :confused:

OS: WinXP
WEB: Apache 2.0.54
PHP: 4.3.1.1

Gryphon

31-07-2005, 23:29

Rename config.php.new to config.php

bigshooter

31-07-2005, 23:46

Ha yes. 2 seconds after i posted that i noticed that notepad was NOT renaming the file the way i was asking it to. had to use an editor to do it. so that problem is solved. now onto the mysql question.

Could not connect to main MySQL.

I assume that I cannot leave the Host as "localhost". But do I need to create a new database in MYSQL for the TS data? Or do I use this elusive "TS2 mysql server"? if so, what the heck is it called?

I promise that is my last dumb question for today.

Gryphon

31-07-2005, 23:51

localhost is usually fine if the database is on the same computer as the php scripts.

bigshooter

01-08-2005, 06:42

Ok 6 hours and several versions / edits / reconfigurations later i give up. This is all I get when I try to run install.php

Unable to select database

I created the database in the MYSQL server
I created the user acct in the MYSQL server
I put the information in config.php
:(

mrdeath

29-08-2005, 23:56

Just a question; gllcTS2 have been running without any problems for months and months on my server, but yesterday it stopped show “users” in the main list (it just say 0/99, same in the summery top of the page), but if you click on the “Details” on the server(s) you see the users?

Any idée?

mrdeath

30-08-2005, 18:07

slash2744

18-09-2005, 01:07

mrdeath

18-09-2005, 07:19

hi i need help on to put my ts on my site i u se dreem wever to edit the site
but you can still get in the ftp to put files in it can someone fix ts on to my site if you have ts come to 69.9.175.73:8889 pass is hell thx this will be a good help for me

Are you talking about getting ts2 (the server app.) on your site or the gllcts2 (the server list) on to your site?

If you’re talking about a ts2 server, it sounds like your better of, if you rent the service from a service provider that host ts2 for you.

If you’re talking about getting gllcte2 on your web site; you need php / mysql to start with… Its more about “rtfm” (http://en.wikipedia.org/wiki/RTFM).

rrwalkertr

30-09-2005, 18:17

Ok I want to explain what i have done, first to make sure that this is going to work. second, i want someone to point their server to my webpost to make sure it is working, because the problem may be on my team speak server.

Ok i uploaded the files to my site, to a folder called public_html/site/gll i could not use the install.php here even tho i changed the permission on that file. so i copied these files to my /public_html/cgi_bin folder and was able to run the install.php there. it set up my databse and looked good. so now i can go to /public_html/site/gll and everything looks right, even admin works. i have a server at home set up, i did everything that i found to do to my server but it never shows up on the webpage. can someone please point a server to this directory to see if it works. also, by installing in the cgi_bin but running it out of the /gll folder, is that going to hurt me, if not mistaken, the only thing the install does is set up the database right? thanks guys the location of my webpost.php is http://www.walkerdw.com/site/gll/
Also, i have read about this tcp_query port but i cant find what exactly its doing, can someone run down and list all the ports i need to forward on my router, and let me know tcp or udp, thanks again.

Donnie Walker

fatrat

17-10-2005, 00:35

can anybody help??

Warning: main(./admin/config.php): failed to open stream: No such file or directory in /home/the5ncom/public_html/webpost/admin/db_inc.php on line 26

Warning: main(): Failed opening './admin/config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/the5ncom/public_html/webpost/admin/db_inc.php on line 26
Could not connect to main MySQL.

how do i sort that out?

marcelrx

17-10-2005, 00:42

fatrat

17-10-2005, 08:55

Unable to select database.

$gllcts2_dbhost = "localhost"; // Host
$gllcts2_dbuser = "the5ncom_fatrat"; // Username
$gllcts2_dbpass = "============"; // Password
$gllcts2_dbname = "gllcts2"; // Database
$gllcts2_dbprefix = "gllcts2_"; // Prefix for tables, best if you have 'something' here, don't make it blank.

i get that error message. guess i aint putting these setting in correctly.

any help?

xfire: 11wfatrat username will be:[5thP]FatRat

Cyrus

17-10-2005, 11:27

Make sure you have a database "gllcts2" on your MySQL Daemon, if not create one or change the dbname value to an existing database.

fatrat

17-10-2005, 17:18

fixed thanks

neuman1812

18-10-2005, 06:33

marcelrx

18-10-2005, 11:20

Problem with installation..

Changed the config file to all the correct database info..but when I try to run the install script, all I get is a blank page, no tables are created in the database.

http://www.usa-clan.com/webpost/admin/install.php

any suggestions?

Does your server supports php scripts?
Make a phpinfo.php file with: <?php phpinfo(); ?>
Then you should get something like that phpinfo (http://www.germeshausen.de/phpinfo.php)

neuman1812

20-10-2005, 15:14

ran a test script OK.. php v5

Cyrus

20-10-2005, 15:40

Do you have mysql, mysqli or both or none of them activated? (These are PHP modules, check in phpinfo())
Also version of your MySQL-Server would be nice to know.

neuman1812

24-10-2005, 23:07

how can i tell?

http://209.59.2.120/test.php

php 5.0.5
mysql 4.1
apache 2.055
Winxp

neuman1812

25-10-2005, 00:00

never mind Figured it out...

forgot to add

# configure the path to php.ini
PHPIniDir "C:/windows/"

to the appache.conf file

VIPERVENOM.DFLW

21-11-2005, 00:26

i get htis after in stalling script.

Data unavailable.
TCPQueryPort may not be open.

it does show the server. but that is it. any adeals on this

Cyrus

21-11-2005, 15:35

Check if TCPQueryPort is reachable and set.

florre

29-11-2005, 17:17

Hi,
is there still no solution for teamspeak-servers not showing up???

My TeamSpeak-server is running on localhost.
It works perfectly when I run the gllcTS2-script also from localhost!

If I upload it to my webspace my TS-server don't show up.
Testing my webpost.php (http://www.gryphonllc.com/forum/showthread.php?threadid=59) however shows the testserver in the list. :confused:

Is this a problem with my ISP blocking something or what???

Hope you can help...
florre

gllcTS2 4.2.2
Apache 2.0.52
PHP 5.0.4
MySQL 4.0.23

kod3brkr

04-12-2005, 12:19

Ok I've actually managed to get this script running. Only took me two hours or so, but with a 3-month old child that's a feat in itself, just find a 2 hour block of time to do something.

Check my Teamspeak server listing here (http://www.acnicholls.com/webpost/listing.php?detail=206.116.62.181&detailport=8767&page=1&sort=server_name&direction=asc&showgroup=all)

My question is really minor. I noticed the channel/user list is aligned to the center of the space it's in. Is there a setting to change this? [edit] I managed to change this, with some minor changes to the script which the copyright says is allowed. [/edit[

If I need to reprogram the php in listing.php, that's not a problem I just need a little direction. It's 3am and I've been working all night, and then came home to set this up. I haven't looked at the code yet but would appreciate some help. TIA

kod3brkr
---------------------------------------------------------
anyone can do anything, with enough willpower

kod3brkr

04-12-2005, 12:22

Hey Florre, check to see if port 51234 is blocked, that'll help your server show up. once I opened that port everything showed up.

also check to see if the WebpostURL is set in global settings and in your server config.

Then wait 5 mins.

kod3brkr
-------------------------------------------------------------
anyone can do anything, with enough willpower

srsclan

07-01-2006, 02:51

Guys,

I am new to this scripts. I have asked my webhost provider to install the webpost and gllcTS2 for me. The did all the install. I run PNC3.0 content management system. I went into the admin panel and enabled the block for teamspeak. And all i get is a block with this messsage

Could not connect to the Team Speak Server.

Webmaster: check your port settings and confirm with your web hoster and TeamSpeak Server hoster they are open.

My webhost has the ports and so as my Teamspeak host.

My temspeak detaisl are as following

adress 202.125.43.147
UDP port: 8762
TCP Query 51234

Also, i logged into gllcTS2 admin page and it says Zero active servers. Do i have to change any settings. How do i point to the webpost. I am new to it, so please bear with me and offer some help

And my website is www.srsclan.com

cheers

Naesstrom

25-02-2006, 13:30

I'm having some realy weird problem...

I have installed the script here (http://koh.naesstrom.net/TS/listing.php) and my srver shows up... but if u press the details link u get a error message:
Data unavailable.
TCPQueryPort may not be open.

I have tried a lot of other scripts to but everyone gives me the same error... I have opened the port on my router (D-link DI-624+) and if I do the telnet connection test with my commandprompt on another comp it seems to work since I get the [ts] command back...

please someone help me with this!

SquadVoice

09-03-2006, 03:39

Alright Hears my info and all ports are open
adress 64.156.59.15
UDP port: 8762
TCP Query 51299

My Question is does the server have to be on 51234

also in the admin seting what do i put hear
IP's Allowed :
List the servers you want to have priority on the list if limited above. Separate IP's with comma.

Cow Killa

21-03-2006, 02:31

ok this may be a gllc webpost issue or its the way i have the ip address bounded but on my page

http://cowkilla.dyndns.org:8080/ts/listing.php

it only shows the internal ip address of the server i have my ts stuff hosted on.

currently i have my server pointing to http://192.168.1.20:8080/ts/webpost.php

but when i have it set to http://cowkilla.dyndns.org:8080/ts/webpost.php it shows my router's ip address instead. and my server isn't directly connected to the router( goes thru a cisco swtich then to the linksys router) and i don't want to put it in the dmz as it is also my fileserver, Active directory server etc. any help would be appreciated. great webpost aside from my issue.

*EDIT* Also when i change my server to http://cowkilla.dyndns.org:8080/ts/webpost.php it also says exactly what Naesstrom has posted.

Cyrus

21-03-2006, 16:59

Hmm nice to know but you did not say what you exactly want to do

Cow Killa

21-03-2006, 20:52

what i'd like to do is have my webpost page show the server address as cowkilla.dyndns.org:8767

I forgot to clarify the issue when i use http://cowkilla.dyndns.org:8080/ts/webpost.php for the webpost URL. What happens when i use that is that none of the people on the server show up but it says the server is up. i forgot what i did to make this happen but i used a different hostname or ip address for my webpost and it showed my router's internal IP and said query port may not be forwarded,but i have it forwarded to the server. However when i put it back to http://192.168.1.20:8080/ts/webpost.php it shows it fine because its on my internal.

PDawG81

23-03-2006, 08:12

anyway to change the ts server update/refresh time lower then 5 minutes

and how do you edit the config.php....what goes where(lol)

orlan

31-03-2006, 03:12

Okay maybe I'm missing something. I just downloaded the zip file and started to install, but I can't find the webpost2.sql file anywhere.

Cow Killa

31-03-2006, 04:54

Okay maybe I'm missing something. I just downloaded the zip file and started to install, but I can't find the webpost2.sql file anywhere.

there is no sql file. the file you need to point your ts server to webpost to is webpost.php

Bamarama

07-05-2006, 01:55

The link for webpost does not work.

I am looking for

A: Code to put a teamspeak block on an asp server.
B: Code for PHP that is NOT for NUKE.
C: Code to put a teamspeak block with asp.NET

or something that I can use to put a teamspeak block on my website.

hopefully one of you smart folks can help me with this please
Thanks
Jeff

warbird

27-07-2006, 14:07

On the bottom of the Script it says that Servers are refreshed in 5 Minutes. Can that be changed, refresh it any minute ?

WarBirD

Cyrus

27-07-2006, 14:09

no, these 5 minutes are hardcoded into teamspeak
but you can use one of those TeamSpeak Viewers that fetch the data directly from TeamSpeak in Realtime

shambala

01-08-2006, 17:45

Could not connect to main MySQL.

I get this error even though I made a database and everything.

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

Makc666

09-08-2006, 15:52

There is misprint in tpl_serverdetail.php

Find:
<td align="center" bgcolor="<?php echo ''.$setting["rowcolor1"].''; ?>" class="listing"><?php echo ''.$row->server_ispname.''; ?></td>

Change to:
<td align="center" bgcolor="<?php echo ''.$setting["rowcolor1"].''; ?>" class="listing"><?php echo ''.$row->server_ispcountry.''; ?></td>

Changes:
server_ispname
to
server_ispcountry

BootinTroubleshootin

10-08-2006, 03:16

good job man, nicely done! :)

shambala

12-08-2006, 18:15

I get this error now

Could not connect to main MySQL.

McAfee

13-08-2006, 07:54

I have updated my PHP-Nuke Block to match gllcTS2 v4.2.4:
http://www.gryphonllc.com/forum/showthread.php?t=201

Bastian

15-08-2006, 22:30

By the way: What's new in version 4.2.4?

I modified the script a lot so I can't update to the latest version without loosing all my changes.

See: http://webpost.teamspeak-einstieg.de/listing.php

Gryphon

16-08-2006, 21:26

From 4.2.2 to 4.2.4

File tpl_serverdetail.php

Find:
<script type="text/javascript" language="javascript">
function jstime(phptime) {
$newdate = new Date(phptime*1000);
$hours = $newdate.getHours();
$mins = $newdate.getMinutes();
$secs = $newdate.getSeconds();
$offset = $newdate.getTimezoneOffset()/-0.6;
if ($hours == 0) {
$hours = "12";
$ap = "AM";
}
else if ($hours < 12) {
$ap = "AM";
}
else if ($hours == 12) {
$ap = "PM";
}
else {
$hours = $hours - 12
$ap = "PM";
}
if ($mins < 10) { $mins = "0"+$mins; }
if ($secs < 10) { $secs = "0"+$secs; }
if (Math.abs($offset) < 1000 ) { $timezone = "0"+Math.abs($offset); }
if ( $offset == 0 ) { $timezone = ""; }
else if ( $offset < 0 ) { $timezone = "-"+$timezone; }
else { $timezone = "+"+$timezone; }
$timezone = "UTC"+$timezone;
//$datestring = $newdate.toTimeString();
$datestring = $hours + ":" + $mins + ":" + $secs + " " + $ap + " " + $timezone;
document.write($datestring);
}
</script>

Replace:
<script type="text/javascript" language="javascript">
function jstime(phptime) {
$newdate = new Date(phptime*1000);
$hours = $newdate.getHours();
$mins = $newdate.getMinutes();
$secs = $newdate.getSeconds();
$offset = $newdate.getTimezoneOffset();

if ($hours == 0) {
$hours = "12";
$ap = "AM";
}
else if ($hours < 12) {
$ap = "AM";
}
else if ($hours == 12) {
$ap = "PM";
}
else {
$hours = $hours - 12
$ap = "PM";
}
if ($mins < 10) { $mins = "0" + $mins; }
if ($secs < 10) { $secs = "0" + $secs; }

$offsetString = Math.floor(Math.abs($offset / 60));
if ( ($offset % 60) != 0 ) { $offsetString = $offsetString + ":" + Math.abs($offset % 60); }
if ( $offset > 0 ) { $timezone = "UTC-" + $offsetString; }
else if ( $offset < 0 ) { $timezone = "UTC+" + $offsetString; }
else { $timezone = "UTC"; }

//$datestring = $newdate.toTimeString();
$datestring = $hours + ":" + $mins + ":" + $secs + " " + $ap + " " + "(" + $timezone + ")";
document.write($datestring);
}
</script>

Find:
<td align="center" bgcolor="<?php echo ''.$setting["rowcolor1"].''; ?>" class="listing"><?php echo ''.$row->server_ispname.''; ?></td>

Replace:
<td align="center" bgcolor="<?php echo ''.$setting["rowcolor1"].''; ?>" class="listing"><?php echo ''.$row->server_ispcountry.''; ?></td>

File admin\db_inc.php

Find:
$wpost2version = "4.2.2";

Replace:
$wpost2version = "4.2.4";

Bastian

17-08-2006, 14:50

Thank you.

I added a lot of stuff to my modified webpost version, such as a textfile with banned servers. Furthermore, I added a footer template and fixed the ISP country bug.

If you are interested in some of the changes, please contact me.

I'm sure the list of banned servers is something that could be realized using the database instead of a text file. I just didn't know anything about MySQL when I implemented this feature. It's just a dirty hack. ;)

shambala

24-08-2006, 03:49

I edited the files and get this:

Warning: main(./config.php): failed to open stream: No such file or directory in /home/tmind132/public_html/admin/install.php on line 25

Warning: main(./config.php): failed to open stream: No such file or directory in /home/tmind132/public_html/admin/install.php on line 25

Warning: main(): Failed opening './config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tmind132/public_html/admin/install.php on line 25

Notice: Undefined variable: gllcts2_dbprefix in /home/tmind132/public_html/admin/install.php on line 27

Notice: Undefined variable: gllcts2_dbprefix in /home/tmind132/public_html/admin/install.php on line 28

Notice: Undefined variable: gllcts2_dbprefix in /home/tmind132/public_html/admin/install.php on line 29

Notice: Undefined variable: gllcts2_dbprefix in /home/tmind132/public_html/admin/install.php on line 30

Notice: Undefined variable: gllcts2_dbprefix in /home/tmind132/public_html/admin/install.php on line 31
Could not connect to main MySQL.

Gryphon

24-08-2006, 03:52

Warning: main(./config.php): failed to open stream: No such file or directory

I can tell right here you didn't rename the config file as the readme says.

shambala

25-08-2006, 22:05

Could not connect to main MySQL.

I did the readme exactly.

McAfee

26-08-2006, 04:12

I'm working on a more verbose installer, which you can find here:
http://mcafee.servegame.com/download/gllcts2_verbose_install.zip

Just put it on the /admin folder of gllcTS2 and access it with your browser.
Consider it beta, It might still not display the information you need, but I'm trying to get there.

shambala

26-08-2006, 07:47

Is there anything wrong with this?

Host: localhost
Username: tmind132_gllcts2
Password: *******
Database: gllcts2

g-star

02-09-2006, 21:08

Warning: Cannot modify header information - headers already sent by (output started at /srv/www/web3/html/admin/config.php:23) in /srv/www/web3/html/admin/index.php on line 32

Was mache ich falsch ?????

Greymane

03-11-2006, 18:16

Vielleicht kann mir hier ja wer helfen.

Also ich hab gerade das Script hochgeladen und es funzt soweit recht gut.
Nur wenn ich einen Channel anklicke öffnet es mir das Popup Fenster, ich geb nun den Nickname und Passwort ein dann klick ich auf "Submit".
Nun hab ich ein leeres Fenster mit nur der Hintergrundfarbe aber es kommt kein "Log in".
An was kann es liegen?

L.G.
Greymane

OikoumE

07-11-2006, 14:45

how do i use this script?
ican i just publiss it and then its done?
can someone "teach"/show me?

Anton27

29-11-2006, 02:39

I have the 'gllcTS2' setup and running fine except for the:

Data unavailable.
TCPQueryPort may not be open.

You can see for yourself here: http://cerulean.no-ip.org/ts/listing.php?detail=142.161.107.18&detailport=8767&page=1&sort=server_name&direction=asc&showgroup=all

PHP Version: 4.3.11
MySQL Version: 4.1.10

Port 51234 is set to TCP (also tried both TCP and UDP).

My config.php file:

<?php
// Begin User Config

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

// End User Config
/*
************************************************** **************
* gllcTS2 for TeamSpeak 2 © Gryphon, LLC (www.gryphonllc.com ) *
************************************************** **************
*
* $Id: config.php.new 5 2005-10-26 23:19:04Z gryphon $
* $Rev: 5 $
* $LastChangedBy: gryphon $
* $Date: 2005-10-26 16:19:04 -0700 (Wed, 26 Oct 2005) $
*/
?>

My webpost.php file:

<?php
/*
************************************************** **************
* gllcTS2 for TeamSpeak 2 © Gryphon, LLC (www.gryphonllc.com ) *
************************************************** **************
*
* $Id: webpost.php 5 2005-10-26 23:19:04Z gryphon $
* $Rev: 5 $
* $LastChangedBy: gryphon $
* $Date: 2005-10-26 16:19:04 -0700 (Wed, 26 Oct 2005) $
*/
include("./admin/db_inc.php");

if (empty($_POST['server_port'])) {
header ("location: $setting[homepage]");
}

if ($_POST["gllc_posttest"]) {
$server_ip = $_POST["gllc_posttest"];
} else {
if (getenv("HTTP_X_FORWARDED_FOR")) {
$server_ip = getenv("HTTP_X_FORWARDED_FOR");
if ($server_ip == '') {
$server_ip = $_SERVER["REMOTE_ADDR"];
}
$server_ip = preg_replace( "/,.*$/", "", $server_ip );
} else {
$server_ip = getenv("REMOTE_ADDR");
if ($server_ip == '') {
$server_ip = $_SERVER["REMOTE_ADDR"];
}
}
}

$r = query("SELECT * FROM $dbtable5 WHERE listips LIKE '%$server_ip,%'");
$r2 = query("SELECT * FROM $dbtable1");
$r3 = query("SELECT * FROM $dbtable1 WHERE server_ip = '$server_ip'");
if (mysql_num_rows($r) == '0' && mysql_num_rows($r2) >= $setting["listamount"] && mysql_num_rows($r3) == '0') {
exit;
}

$server_port = $_POST["server_port"];

$sql = query("SELECT * FROM $dbtable1 WHERE server_ip='$server_ip' AND server_port='$server_port'");

$server_adminemail = urldecode($_POST['server_adminemail']);

$server_isplinkurl = urldecode($_POST['server_isplinkurl']);
if (isset($server_isplinkurl) && $server_isplinkurl != 'na' && $server_isplinkurl != '') {
if (preg_match("/http:\/\//i", $server_isplinkurl)) {
$server_isplinkurl = $server_isplinkurl;
} else {
$server_isplinkurl = 'http://'.$server_isplinkurl.'';
}
}

$server_linkurl = urldecode($_POST['server_linkurl']);
if (isset($server_linkurl) && $server_linkurl != 'na' && $server_linkurl != '') {
if (preg_match("/http:\/\//i", $server_linkurl)) {
$server_linkurl = $server_linkurl;
} else {
$server_linkurl = 'http://'.$server_linkurl.'';
}
}

$server_name = urldecode($_POST['server_name']);
$server_name = trim(str_replace("", "", $server_name));

$server_ispname = addslashes(urldecode($_POST['server_ispname']));
$server_ispcountry = addslashes(urldecode($_POST['server_ispcountry']));

$server_password = addslashes(urldecode($_POST['server_password']));

if ($server_ispname == 'na') {
$server_ispname = 'Private';
}

//$server_uptodate = ''.$_POST["server_version_major"].''.$_POST["server_version_minor"].''.$_POST["server_version_release"].''.$_POST["server_version_build"].'';

//if ($server_uptodate < "201940") { // Enter the version number you wish to allow, no decimals. Anything under this version will not be allowed.
// exit;
//}

// update existing server
if (mysql_num_rows($sql)!= 0) {
query("UPDATE $dbtable1 SET
server_adminemail='$server_adminemail',
server_isplinkurl='$server_isplinkurl',
server_ispname='$server_ispname',
server_ispcountry='$server_ispcountry',
server_platform='$_POST[server_platform]',
server_version_major='$_POST[server_version_major]',
server_version_minor='$_POST[server_version_minor]',
server_version_release='$_POST[server_version_release]',
server_version_build='$_POST[server_version_build]',
server_ip='$server_ip',
server_port='$server_port',
server_name='$server_name',
server_uptime='$_POST[server_uptime]',
server_password='$server_password',
server_type1='$_POST[server_type1]',
server_type2='$_POST[server_type2]',
clients_current='$_POST[clients_current]',
clients_maximum='$_POST[clients_maximum]',
channels_current='$_POST[channels_current]',
server_linkurl='$server_linkurl',
server_queryport='$_POST[server_queryport]',
server_timestamp='$server_timestamp'
WHERE server_ip='$server_ip' AND server_port='$server_port'");
} else if ($server_port) {
// insert new server
query("INSERT INTO $dbtable1
(server_adminemail,
server_isplinkurl,
server_ispname,
server_ispcountry,
server_platform,
server_version_major,
server_version_minor,
server_version_release,
server_version_build,
server_ip,
server_port,
server_name,
server_uptime,
server_password,
server_type1,
server_type2,
clients_current,
clients_maximum,
channels_current,
server_linkurl,
server_queryport,
server_timestamp)
VALUES
('$server_adminemail',
'$server_isplinkurl',
'$server_ispname',
'$server_ispcountry',
'$_POST[server_platform]',
'$_POST[server_version_major]',
'$_POST[server_version_minor]',
'$_POST[server_version_release]',
'$_POST[server_version_build]',
'$server_ip',
'$server_port',
'$server_name',
'$_POST[server_uptime]',
'$server_password',
'$_POST[server_type1]',
'$_POST[server_type2]',
'$_POST[clients_current]',
'$_POST[clients_maximum]',
'$_POST[channels_current]',
'$server_linkurl',
'$_POST[server_queryport]',
'$server_timestamp')");
}

if ($server_port) {
$ts_version = "$_POST[server_version_major]" . "$_POST[server_version_minor]" . "$_POST[server_version_release]" . "$_POST[server_version_build]";
insertchannelinfo($server_ip, $_POST["server_queryport"], $server_port, $ts_version);
insertuserinfo($server_ip, $_POST["server_queryport"], $server_port, $ts_version);
}

$sqlg = query("SELECT * FROM $dbtable4 WHERE group_ispname='$server_ispname'");

// update existing server
if (mysql_num_rows($sqlg)!= 0) {
$sqlg2 = query("SELECT * FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$groupservercount = mysql_num_rows($sqlg2);

if (($server_ispname == 'Private') or ($server_ispname == '')) {
$server_ispname = 'Private';
$server_isplinkurl = 'na';
}
$sqlg3 = query("SELECT sum(clients_current) FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$sqlg3data = mysql_fetch_row($sqlg3);

query("UPDATE $dbtable4 SET group_ispurl='$server_isplinkurl', group_ispname='$server_ispname', group_servers='$groupservercount', group_users='$sqlg3data[0]', server_timestamp='$server_timestamp' WHERE group_ispname='$server_ispname'");
} else if ($server_ispname) {
// insert new server
$sqlg2 = query("SELECT * FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$groupservercount = mysql_num_rows($sqlg2);

if (($server_ispname == 'Private') or ($server_ispname == '')) {
$server_ispname = 'Private';
$server_isplinkurl = 'na';
}
$sqlg3 = query("SELECT sum(clients_current) FROM $dbtable1 WHERE server_ispname='$server_ispname'");
$sqlg3data = mysql_fetch_row($sqlg3);

query("INSERT INTO $dbtable4 (group_ispurl,group_ispname,group_servers,group_us ers,server_timestamp) VALUES ('$server_isplinkurl','$server_ispname','$groupser vercount','$sqlg3data[0]','$server_timestamp')");
}
?>

My appologies if I am forgetting anything.

Fabian_999

31-01-2007, 20:33

yes i have the same problem

sry 4 my bad english :P

Tomas

23-02-2007, 22:13

yes I can
you should set on your TeamSpeak server (in SQL or by webinterface)
Server WebPost PostUrl: to the /webpost.php
and Server WebPost LinkUrl: set to your webpage

for gllcTS2 v 4.2.4
with edited /admin/config.php.new and rename it to config.php
use /admin/install.php in your browser
and you should have it ok.

formfaq

27-02-2007, 10:25

Tomas

28-02-2007, 14:20

Hi there.
Here (http://teamspeakhost.ru/status_block/listing.php?detail=195.138.198.214&detailport=8767) my modification of your great script.
It is a preview version and i also working with full modification of gllts2 interface.
Its a block made for use on website of client for monitoring his server.
If you interest in this modification - please reply in this topic.
Sorry for my bad english.

well now I see where the websites with the similiar skin gets the source code ... they simply change the gllcTS2 ...
looks good ....
One thing I think that the (user flags etc) you have there is not good. I suggest add to remove that border lines. Without them it will be better just try it

formfaq

01-03-2007, 10:39

Thank you for interesting in my modification of gllts2 status script.
I working with fully change of interface of this script. It is a preview release of block for server status on a client website.
I will close to end my work with full reorganisation of gllts2 interface and you will see how it looks in a final version. I will post new info in this thread of forum, if you really like my interface modification.
PS. in a final release i will put all original icons of teamspeak client and gllts2 script.

Tomas

16-03-2007, 16:01

If someone get interest I maybe remake gllcTS2 ....

one note for http://php.gryphonllc.com/gllcts2/ (sry about that testing day ... when was 2 addresses with Array:<port> my mistake.

few things like :
(static)dns names
X_addresses
FWD: TeamSpeak_webpost ; Created by T ; WEByT.NET
multilanguade
show infoboxes onMouseOver channels+users (like tooltip) maybe also(future) server (in listing.php without parameters)
few stylles of look (like text one also for admin_overview)

few of them I statictly hardly added to my changed gllcTS2 (http://tpc.webyt.net/TS/gllcTS2-en/)

Gryphon

16-03-2007, 17:07

Please do not remake gllcTS2 with my code. If you want to suggest fixes and/or improvements, I will consider all submissions. But please do not take my code and re-release it.

Tomas

17-03-2007, 13:53

ok, it will be easyer for me to ONLY make it a part of my pages...
well, the reason is simple ... I want to make some skinable and multilang version of that...
also I get few errors from that yours even in new version (maybe safe_mode in php settings)
I want to make it from nothing ... re... or copy I mean the "skin" that yours is very good.
also not very soon...
ok .. only my webpage will have it

errors suggestions ? (http://tpc.webyt.net/Files/tmp/Fix_bugs_in_gllcTS2/)
( http://forum.goteamspeak.com/showthread.php?t=36207 )

sry for that en

OuT4BlOoD

19-09-2007, 23:07

Hello,

I installed this script and I recieve this error.

TCPQueryPort may not be open.

Any help would be greatly appreciated.

furtif

27-11-2007, 12:55

The link is dead, please upload in a new server