Hackked
10-04-2003, 07:05
Ok, here goes...
Here are my system specs:
Win XP Pro Service Pack 1 - all updates prior also installed
Apache 2.0.45 win32 binaries - http://mirrors.midco.net/pub/apache.org/httpd/binaries/win32/apache_2.0.45-win32-x86-no_ssl.msi
PHP 4.3.1 - http://www.php.net/get/php-4.3.1-installer.exe/from/a/mirror
MySQL Server - 4.0.12 MySQL Client - 3.23.36
TeamSpeak Client - 2.0.28.40
TeamSpeak Server - 2.0.19.16
WebPost Script - 3.1.1
Working from behind a network router with port forwarding and NOT DMZ.
__________________________________________________
First, download the webpost script from here - http://www.thzclan.com/files/file.php?id=53 . Next unzip and extract it to a web folder on your local web server. Now, you wanna navigate to the folder you extracted to and edit the "config_inc.php" file. Editing these settings in Dreamweaver is a breeze, but Notepad will work just fine as well. The main settings are these, which are located at the top of the script:
$dblink = "localhost"; // Host - Host name of the database, usually localhost if running on a home server
$dbuser = "**********"; // Username - Username of the database
$dbpw = "**********"; // Password - Password of the database
$dbname = "teamspeak"; // Database - Name of the database
$dbtable = "ts2_weblist"; // Table for servers - This is the default name
$dbtable2 = "ts2_user"; // Table for server details - This is the default name
$dbtable3 = "ts2_channel"; // Table for server details - This is the default name
$dbtable4 = "ts2_group"; // Table for server isp groups - This is the default name
$showgroups = "no"; // set to "yes" to show isp groups
$homepage = "index"; // did you change the name of index.php? update it here - You arent going to change this, so no need to fool around with it
Save and close the file.
This example is assuming you are running your own MySQL server. Next, you need to create a new database and build the tables into the database using the "webpost.sql" file located in the extracted folder. You can read up on how to do this at:
http://www.mysql.com/documentation/mysql/bychapter/index.html You can also use a script like Mpanel from Matt's Script at http://www.mattsscripts.co.uk/mpanel.htm to import the webpost2.sql file (located in the folder you extracted to) and have it create the tables for you.
After you get the tables built, go ahead and go back to the script install folder and delete the .htaccess file.
__________________________________________________
Next, check your server.ini file located in the TeamSpeak server install folder and open it with NotePad. Here is what mine looks like:
[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL
[Main Config]
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
BoundToIp=
[WebPost]
AdminEmail=teamspeak@undeadhorde.com
ISPLinkURL=http://www.undeadhorde.com
ISPName=Undead Horde
ISPCountry=USA
Enabled=1
PostURL=http://www.undeadhorde.com/ts/webpost.php
ListPublic=1
[ISP]
GFX URL=
[log]
access=0
The PostURL needs to be set to the location of your Webpost script ie. http://www.yoursite.com/teamspeak/webpost.php (this is assuming you have already unzipped the Webpost script into a web accessable dir on your local web server). Leave the TCPQueryPort at its default setting for the time being. The other entries are pretty trivial and dont have much of an impact as far as your server info getting posted.
Save and close the file.
__________________________________________________
Next, you need to get into your PHP.INI file located in your Windows folder. Depending on Platform used, it could be "C:\Windows" or "C:\WINNT". There are a ton of files in here but if you have yours organized like I do finding the PHP.INI file shouldn't be that hard. Once located, open it up in Notepad and hit "Ctrl+F" and type in "register_globals" without the quotes. The setting should look like this:
register_globals = On
Save and close the file.
__________________________________________________ _
At this point, your server should begin reportin to the script, but lets go a bit further before we do any tests. Lets configure your router to allow the update trafic to pass through to the TCPQueryPort and allow your server to communicate in general with the outside world. This is called Port Forwarding.
Open your router config admin screen - generally it's something like "192.168.0.1 or 192.168.254.254". Check your router manual if in doubt. Next, go to the virtual server section, possibly located under the "Advanced" section. You will want to create a new server connection. Type in "TCPQueryPort" as the name, assign the local computer running the server, choose TCP as the data stream type (TCP and UDP are the only 2 choices) and for the internal and external port numbers, type in "51234" for both. Save this new server type.
Next, you will want to create a new server connection. Type in "TeamSpeak" as the name, assign the local computer running the server, choose TCP/UDP as the data stream type (so use the both option this time and not just TCP) and for the internal and external port numbers, type in "8767" for both
Save the connections and logout.
__________________________________________________
Next, login to the web based admin panel of your TeamSpeak server and go to "Server Settings". Locate the WebPost URL and type in "http://www.mywebsite.com/teamspeak_dir/webpost.php" replacing the example with your real script location (believe it or not, people forget to do this). Click save and then logout.
__________________________________________________
Now, lets try to finally test your Webpost script. Open a new browser and type in the webpost.php address and give it a few minutes to register itself onto the website. Voila! It should be there.
If you are still having problems, try restarting the TeamSpeak server. Or, if you arent that good at troubleshooting, reboot the whole machine. PHP generally doesnt require a reboot as it re-reads the PHP.INI file every time it gets used. And the MySQL database shoulnt require a reboot at all.
_________________________________________________
Hope this helps...
Cheers!
Here are my system specs:
Win XP Pro Service Pack 1 - all updates prior also installed
Apache 2.0.45 win32 binaries - http://mirrors.midco.net/pub/apache.org/httpd/binaries/win32/apache_2.0.45-win32-x86-no_ssl.msi
PHP 4.3.1 - http://www.php.net/get/php-4.3.1-installer.exe/from/a/mirror
MySQL Server - 4.0.12 MySQL Client - 3.23.36
TeamSpeak Client - 2.0.28.40
TeamSpeak Server - 2.0.19.16
WebPost Script - 3.1.1
Working from behind a network router with port forwarding and NOT DMZ.
__________________________________________________
First, download the webpost script from here - http://www.thzclan.com/files/file.php?id=53 . Next unzip and extract it to a web folder on your local web server. Now, you wanna navigate to the folder you extracted to and edit the "config_inc.php" file. Editing these settings in Dreamweaver is a breeze, but Notepad will work just fine as well. The main settings are these, which are located at the top of the script:
$dblink = "localhost"; // Host - Host name of the database, usually localhost if running on a home server
$dbuser = "**********"; // Username - Username of the database
$dbpw = "**********"; // Password - Password of the database
$dbname = "teamspeak"; // Database - Name of the database
$dbtable = "ts2_weblist"; // Table for servers - This is the default name
$dbtable2 = "ts2_user"; // Table for server details - This is the default name
$dbtable3 = "ts2_channel"; // Table for server details - This is the default name
$dbtable4 = "ts2_group"; // Table for server isp groups - This is the default name
$showgroups = "no"; // set to "yes" to show isp groups
$homepage = "index"; // did you change the name of index.php? update it here - You arent going to change this, so no need to fool around with it
Save and close the file.
This example is assuming you are running your own MySQL server. Next, you need to create a new database and build the tables into the database using the "webpost.sql" file located in the extracted folder. You can read up on how to do this at:
http://www.mysql.com/documentation/mysql/bychapter/index.html You can also use a script like Mpanel from Matt's Script at http://www.mattsscripts.co.uk/mpanel.htm to import the webpost2.sql file (located in the folder you extracted to) and have it create the tables for you.
After you get the tables built, go ahead and go back to the script install folder and delete the .htaccess file.
__________________________________________________
Next, check your server.ini file located in the TeamSpeak server install folder and open it with NotePad. Here is what mine looks like:
[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL
[Main Config]
ExternalIPDectection=1
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
BoundToIp=
[WebPost]
AdminEmail=teamspeak@undeadhorde.com
ISPLinkURL=http://www.undeadhorde.com
ISPName=Undead Horde
ISPCountry=USA
Enabled=1
PostURL=http://www.undeadhorde.com/ts/webpost.php
ListPublic=1
[ISP]
GFX URL=
[log]
access=0
The PostURL needs to be set to the location of your Webpost script ie. http://www.yoursite.com/teamspeak/webpost.php (this is assuming you have already unzipped the Webpost script into a web accessable dir on your local web server). Leave the TCPQueryPort at its default setting for the time being. The other entries are pretty trivial and dont have much of an impact as far as your server info getting posted.
Save and close the file.
__________________________________________________
Next, you need to get into your PHP.INI file located in your Windows folder. Depending on Platform used, it could be "C:\Windows" or "C:\WINNT". There are a ton of files in here but if you have yours organized like I do finding the PHP.INI file shouldn't be that hard. Once located, open it up in Notepad and hit "Ctrl+F" and type in "register_globals" without the quotes. The setting should look like this:
register_globals = On
Save and close the file.
__________________________________________________ _
At this point, your server should begin reportin to the script, but lets go a bit further before we do any tests. Lets configure your router to allow the update trafic to pass through to the TCPQueryPort and allow your server to communicate in general with the outside world. This is called Port Forwarding.
Open your router config admin screen - generally it's something like "192.168.0.1 or 192.168.254.254". Check your router manual if in doubt. Next, go to the virtual server section, possibly located under the "Advanced" section. You will want to create a new server connection. Type in "TCPQueryPort" as the name, assign the local computer running the server, choose TCP as the data stream type (TCP and UDP are the only 2 choices) and for the internal and external port numbers, type in "51234" for both. Save this new server type.
Next, you will want to create a new server connection. Type in "TeamSpeak" as the name, assign the local computer running the server, choose TCP/UDP as the data stream type (so use the both option this time and not just TCP) and for the internal and external port numbers, type in "8767" for both
Save the connections and logout.
__________________________________________________
Next, login to the web based admin panel of your TeamSpeak server and go to "Server Settings". Locate the WebPost URL and type in "http://www.mywebsite.com/teamspeak_dir/webpost.php" replacing the example with your real script location (believe it or not, people forget to do this). Click save and then logout.
__________________________________________________
Now, lets try to finally test your Webpost script. Open a new browser and type in the webpost.php address and give it a few minutes to register itself onto the website. Voila! It should be there.
If you are still having problems, try restarting the TeamSpeak server. Or, if you arent that good at troubleshooting, reboot the whole machine. PHP generally doesnt require a reboot as it re-reads the PHP.INI file every time it gets used. And the MySQL database shoulnt require a reboot at all.
_________________________________________________
Hope this helps...
Cheers!