PDA

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


Pages : 1 [2] 3

maletin
20-06-2003, 09:01
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 ??
Maybe you need to enable cookies or javascript for this site?

Vortex
20-06-2003, 22: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, 16: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, 17: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, 09: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, 11: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, 12:50
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 ??


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

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

DeeeJay
25-06-2003, 19: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, 01: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, 05:37
Edit /etc/php.ini and change short_open_tag to "On" to allow the "<?" to work.

CowboyGuy
28-06-2003, 01:30
wow... should have read the manual! that was much easier and would have been quicker than what I did!

ScratchMonkey
28-06-2003, 02:08
Us old timers use the acronym "RTFM". ;)

CowboyGuy
28-06-2003, 02: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, 01: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, 13: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, 15:19
Welche Datei rufst du den auf ?

zoomzoom
17-07-2003, 15: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, 13:37
.htaccess Datei mal löschen. Ab und an sollte man eben doch mal die Readme lesen ;)

zoomzoom
24-07-2003, 13: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, 14: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, 14: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, 00: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, 20: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, 00: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, 02: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, 10: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
05-08-2003, 23: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, 19: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, 20: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, 00:53
Well it works here ...

Germeshausen.de
13-08-2003, 19: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, 17: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, 17: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, 14: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, 08: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, 11:07
Quick patch: Look where the name output is and use htmlspecialchars() on it.

CyberWolf
03-09-2003, 04: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, 22:46
Great Product thanks for the hard work.

frankenberrie
29-09-2003, 16: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, 21: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, 11: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, 21: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
11-10-2003, 23:33
Don't know why, but I had to completely shut down my firewall to download it.

Sommer
12-10-2003, 08:56
Yea, I also tried that after you reply.... shout down your firewall and it works. THAT SUCKS!

Qxs
16-10-2003, 18: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, 22:50
Is there some doc. that will help me setup my database? Like a big readme for a stupid person?

Qxs
24-11-2003, 06: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, 14: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, 14: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, 14: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, 14: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, 15: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, 15: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, 15: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, 15:40
Hmm ok. What does your /etc/resolv.conf look like?

w00ter
27-11-2003, 15:41
nameserver 62.216.31.50
nameserver 62.216.31.60
search adsl.cistron.nl

Dummer Sack
27-11-2003, 15: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, 07: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, 02: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, 18: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, 21: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, 12: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, 08: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, 14: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
14-01-2004, 23: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
14-01-2004, 23:51
i have activated your account on my site Gryphon

GASCRLModernAge
19-01-2004, 01: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, 19: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, 00: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
06-02-2004, 23: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, 22: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, 00: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, 15: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, 06:41
Just click in the button in the midde titled "gllcTS2" The download should automatically begin then.

Profi
08-03-2004, 16:18
I click the button and nothing happens....

jayt
09-03-2004, 13: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, 19: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, 19: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, 22:24
Thank you. The email-sending help me out. :)

Gryphon
10-03-2004, 23: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, 22: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, 22: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, 09: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, 18:50
nevermind, got it to work, and its running now

AnthonyB
13-04-2004, 10: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, 20: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, 15: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, 17: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, 18: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, 19: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, 09: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, 00:24
I will check on the server name entry.

JamieWolf
11-05-2004, 19: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, 22: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, 18: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, 18: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, 06: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, 04: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, 07: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, 22:57
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?

McAfee
15-06-2004, 01: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, 02: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, 15: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, 10:15
Thanks for the update - was wondering what was going on in the background ;)

AnthonyB
23-07-2004, 07:58
So, has anyone tried this with PHP v5.0 yet? If so, does it all work OK?

Gav-Aus
29-07-2004, 08: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, 04: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, 06: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, 17: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, 10: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, 10:02
Well i get a error message like

"Could not connect to main MySQL."

Why???

silat
10-08-2004, 13:36
ok, i find my solution lol,
theres a third port to open and map : 51234
:D

silat
10-08-2004, 13: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, 15: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, 17: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, 17: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, 19: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, 20: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, 09: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, 18: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, 00:03
I have not tested it with php5, but from reports it sounds like it does not work.

hideos
26-08-2004, 00: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, 11:00
nvm. Sorted it. :)

K9Trooper
26-08-2004, 17: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, 19: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, 15: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, 15: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, 14: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, 15: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, 18: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, 19: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, 13: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, 22: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, 01: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, 09: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, 15:24
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?:

f ($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:

Easyy-S
18-10-2004, 16: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, 19: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, 13: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, 15:39
You may need to ipconfig /all in your msdos screen, or in your run menu type in winipcfg

AndreasB
05-11-2004, 20: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, 07: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, 14:28
thats it. THANK YOU :o

AndreasB
15-11-2004, 09: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, 15: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, 15:53
Have you entered the correct path to your webpost.php in the admin control panel of your teamspeak server?

K9Trooper
29-11-2004, 18:28
Is there any plans to get this compatable with php 5 yet?

Gryphon
30-11-2004, 21:18
No plans at the moment. I believe McAfee has got it working on php5.

cactus5
01-12-2004, 00: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, 11: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
04-12-2004, 23: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, 09:06
Same problem as: cactus5.

KOM
31-12-2004, 01: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, 20: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, 12: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, 10: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, 10: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, 10: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, 21: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, 06: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, 07: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, 08:00
Im new at php and MySql

swtdivalove
29-01-2005, 20: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, 22: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, 18:10
Add quotes to Private, either single quotes or double quotes.

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

Gryphon
04-02-2005, 18: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, 20: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, 21: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, 21: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, 22: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, 00: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, 15:14
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????????????????????????????????

Germeshausen.de
25-03-2005, 22: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, 20: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, 01: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, 00:38
If it is your first time using the script, rename config.php.new to config.php

PV2-Rinaldi[9TEF]
06-05-2005, 05: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, 11: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, 18: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
02-06-2005, 23: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, 08: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, 17: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, 17: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, 10: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, 06: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, 22: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, 22:29
Rename config.php.new to config.php

bigshooter
31-07-2005, 22: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, 22:51
localhost is usually fine if the database is on the same computer as the php scripts.

bigshooter
01-08-2005, 05: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, 22: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, 17:07
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?


Never mind.. Today its back to normal.. :confused:

slash2744
18-09-2005, 00:07
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

mrdeath
18-09-2005, 06: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, 17: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
16-10-2005, 23: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
16-10-2005, 23:42
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?

This should be clear: he can'T find the config.php in the admin folder. Did you read the readme and renamed the example config file.

fatrat
17-10-2005, 07: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, 10: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, 16:18
fixed thanks

neuman1812
18-10-2005, 05:33
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?

marcelrx
18-10-2005, 10: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, 14:14
ran a test script OK.. php v5

Cyrus
20-10-2005, 14: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, 22:07
how can i tell?

http://209.59.2.120/test.php

php 5.0.5
mysql 4.1
apache 2.055
Winxp

neuman1812
24-10-2005, 23: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
20-11-2005, 23: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, 14:35
Check if TCPQueryPort is reachable and set.

florre
29-11-2005, 16:17
Hi,
is there still no solution for teamspeak-servers not showing up???

My Te