[Release] gllcTS2 Webpost for TeamSpeak 2

[frankenberrie]

I am hosting my own server which is running windows 2003 server, teamspeak 2 rc2, php, mysql (new versions)

My IP for teamspeak is 24.97.120.200
The ip for my server is 192.168.0.100

for webpost, do I put

http://192.168.0.100/teamspeak/webpost.php ?

I cannot get my server to show up on webpost. Can someone help please.. Thanks!

[Novia]

First, thx for thost people release this good webpost.
I have a little Question
My webpost works perfact, but I found......
the USER and CHANNEL have a problem
It's already refreshed, but the user in the channel, still never change.
I means when I joion a channel, the webpost never show anyone there
maybe 2 or 3 mins, the user appear in the channel
In this time, no metter what I do, reopen the web, refresh....


HOW TO FIX THIS PROBLEM ?
THX

[djlightning]

I am hosting my own server which is running windows 2003 server, teamspeak 2 rc2, php, mysql (new versions)

My IP for teamspeak is 24.97.120.200
The ip for my server is 192.168.0.100

I stoped bt your TS server to see if I could help.....your clan mates kinda scratched their heads. Didnt know what I was talking about.

Drop me a post over at my site, maybe I can help.
http://sofclan.net

[[=TLC=]Space Ra]

Hi there!

Right at the beginning of this thread there's an error about that

"Call-time pass-by-reference has been deprecated.... " stuff. Anyone got a workaround (what to replace with what?!) for that? Or did I miss that somwhere in all the answears here?

The script itself works fine for me - but only these errors.

I've got mysql 3.23.54 & php 4.1.2 running on apache linux. BTW - I had to rename the .htaccess as well.

[Foxman]

I've installed webpost (awesome tool btw) and its been running flawlessly for about 5 days up until now.

All I get when viewing ther page is this:

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


Anyone able to tell me what it means (other than an error of course) amd more importantly, how I might fix it?

[BLIND]

sounds like a MySQL permissions problem, or a corrupt table. Try checking permissions, and/or re-creating the webpost databse table.

[Foxman]

Thanks! I rebuilt the database nad its all good so must have been a corrupted table in there somewhere

[mister]

I have that problem from time to time to.. Just use the sql code REPAIR or use phpMyAdmin.

[BLIND]

Originally posted by mister
I have that problem from time to time to.. Just use the sql code REPAIR or use phpMyAdmin.

Yea phpMyAdmin rux, hard. But I wasn't about to send him into command interface with the SQL server since he didn't have a clue what was wrong . Easier for them to just recreate the database.

[woutur]

In true TeamSpeak tradition the manual of this webpost isn't quite............ understandable.
At least not for a newbie like me.
I don't get it

1. Create table in your database with webpost2.sql

How? By using phpmyadmin? Or run webpost2.sql as a command?

Bot things do not really work for me. The output of running webpost2.sql:

: command not found
: command not found
./webpost2.sql: DROP: command not found
: command not found
'/webpost2.sql: line 23: syntax error near unexpected token `(
'/webpost2.sql: line 23: `CREATE TABLE ts2_channel (

I use mysql : Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) on Debian.
I don't quite get what to do as a first step.

[BLIND]

True, but I figure if you have the knowledge and know how to run MySQL, then you should be able to admin it, at least basicly. As far as the example above goes, he pbviously had already setup a table/database for Webpost, so recreating it should be fairly familiar for him ( or her, or whoever else might have the same problem).

But .sql files are basicly for GUI based SQL admin tools. You COULD login to your MySQL database command promt, and type in every line inside the .sql file, but that takes a while.

[woutur]

Sorry.. but I don't get it.

Was I right in assuming you have to run the webpost2.sql in a shell?

If so, how can I prevent getting those error messages?

[BLIND]

Sorry, no you cannot run that in a shell. What do you use to admin your MySQL database? Command prompt only? If so, look into running the phpMyAdmin from the post above.

If your running the command promt, login to your mysql database and run the script file

for example:

shell> mysql -h hostname -u username -p
Enter password: ******

mysql> source webpost2.sql;

That should work.

[woutur]

I'd like to but I'd have to specify a database (when doing mysql from a shell).

And I run phpmyadmin as well, is there an easy way of creating the tables? I can't believe there is no information about this after 14 pages

So odd

Anyway, I can install whatever is necessary... that's no prob. I just have nill experience with mysql and php.

[BLIND]

Well the tough part about finding the answers that you want, is asking the right questions.

So what exactly are you trying to do? create a table? use the create command. I know a great source that help you figure out MySQL commands, here. But phpMyAdmin will let you create tables as well. It also lets you run SQL commands without having to goto a shell.