";
//edit this
$host='localhost'; // this is usually localhost, but might be something else
$username='root'; //database username here
$pass=''; //database password here
$database='servers'; // database name here
$sql = 'CREATE TABLE `servers` ('
. ' `id` INT(11) NOT NULL, '
. ' `host` VARCHAR(250) NOT NULL, '
. ' `port` VARCHAR(250) NOT NULL'
. ' )'
. ' ENGINE = myisam'
. ' CHARACTER SET latin1 COLLATE latin1_bin;';
mysql_connect ($host, $username, $pass);
mysql_select_db($database) or die('Could not connect to the Database');
$action = $_GET['action'];
if(!$action){
echo "Add new server
| Address | Port | Status |
";
$query = mysql_query("SELECT * FROM servers");
while ($row = @mysql_fetch_array($query)){
@$fp = fsockopen($row[host], $row[port], $no, $str, 4);
if($fp){
echo "| $row[host] | $row[port] | Online |
";
}else{
echo "| $row[host] | Offline |
";
}}
echo "
Add new server"; }
if($action>0){
echo "Back to server list
";
if(isset($submit)){
@$fp = fsockopen($_POST[host], $_POST[port], $no, $str, 4);
if($fp){
$number = @mysql_num_rows(mysql_query("SELECT * FROM servers WHERE host='$_POST[host]'"));
if($number==0){
mysql_query("INSERT INTO servers(`host`, `port`)VALUES('$_POST[host]', '$_POST[port]')");
echo "$_POST[host] $_POST[port] has succesfully been added to the database"; }
if($number>0){ echo "This host has already been submited to our database"; }
}else{
echo "There was a problem connecting to the set server, please check the feilds
"; }}
if(!isset($submit)){
echo "
"; }
echo "
Back to server list";
}
echo "";
?>