socket script problem

daydie2008

i have recived a script from a friend to check if private servers are online. it used socket reading,

The problem i have that t keeps saying, "Your server is currently not online, so it cannot be added." When the server is %100 online. it only seems to be doing it on my web server for some reason, its working on my friends.

Can somebody help me please.

Here is most of the script.

if(!$url) {

echo "<span class=\"style5\">Please enter your server's website URL.</span>"; exit;

}

if($port < "7000") {

echo '<span class="style5">Invalid port.</span>'; exit;

}

if($port > "7200") {

echo '<span class="style5">Invalid port.</span>'; exit;

}

$query = mysql_query("SELECT * FROM `servers`");



	while($row = mysql_fetch_array($query)){

	if($row["name"] == $name || $row["ip"] == $ip)

	{

	echo '<span class="style5">Monitor already exists.</span>'; exit;

	}

	}



	$onlinetext = "<font color='green'><b>Online</b></font>";

	$offlinetext = "<font color='red'><b>Offline</b></font>";

	if(@fsockopen($ip,$port,$errno,$errstr,1)) {

		if(@fsockopen($ip,3000,$errno,$errstr,1)) {

		$add = mysql_query("INSERT INTO `servers` (`name`, `ip`, `port`, `url`) VALUES ('$name', '$ip', '$port', '$url')") or die(mysql_error());

		$getid = mysql_query("SELECT * FROM `servers` WHERE `name` = '$name' AND `ip` = '$ip'") or die("Tick: ". mysql_error() );

$rowid = mysql_fetch_array($getid);

$idofrow = $rowid["id"];

$q1 = mysql_query("UPDATE `servers` SET `serverID` = '$idofrow' WHERE id = '$idofrow'") or die("Error");

$q2 = mysql_query("UPDATE `servers` SET `Gate` = 'Game Server' WHERE id = '$idofrow'") or die("Error");

$q3 = mysql_query("UPDATE `servers` SET `Value` = '1' WHERE id = '$idofrow'") or die("Error");

$q4 = mysql_query("UPDATE `servers` SET `ticker` = 'Now()' WHERE id = '$idofrow'") or die("Error");

$q5 = mysql_query("UPDATE `servers` SET `Value2` = '0' WHERE id = '$idofrow'") or die("Error");

$q6 = mysql_query("UPDATE `servers` SET `type` = '$type' WHERE id = '$idofrow'") or die("Error");

echo '<span class="style5">Successfully added server.</span>';

		} else { echo '<span class="style5">Your server does not have port 3000 open which is vital so that our usercount function can work, so it cannot be added. Please open port 3000 on your server so that you can add it.</span>'; exit;

}	} else {

		echo '<span class="style5">Your server is currently not online, so it cannot be added.</span>'; exit;

	}

echo '</body>

</html>';

daydie2008

someone please help me.

djjjozsi

put this into your first lines (after the <?php start block)
i did not see where you connect to the mysql server. you might check.

If you add this server with a form, and in the form the url textfield's name is url

if(empty($_POST["url"]))
print "url is empty.";
else
$url=$_POST["url"];

If you search where is a code missing or has an error, do not use functions and variables with an @ addition, becouse that hides over the error reports.

daydie2008

Sorry dude i shuda posted full script. here it is:

<?php

$url=$_POST["url"];

$host = "xxxx";

$user = "xxxx";

$pass = "xxxx";

$data = "xxxx";

$ms = mysql_pconnect($host, $user, $pass);
if( !$ms )

	{

	echo "Couldn't connect to database...";

	}
mysql_select_db($data);

function clean($str)

{
$str = strip_tags(addslashes(stripslashes(htmlspecialchars($str))));

$str = mysql_real_escape_string($str);

return $str;
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Add to Status</title>

<style type="text/css">



</style>

</head>

<body>

<?php

if($_POST['ip']) {

$name = clean($_POST['name']);

$ip = clean($_POST['ip']);

$port = clean($_POST['port']);

$type = clean($_POST['type']);

$url = clean($_POST['url']);

if($type == "Please Select") {

echo '<span class="style5">Please select a server type.</span>'; exit;

}

if(!$url) {

echo "<span class=\"style5\">Please enter your server's website URL.</span>"; exit;

}

if($port < "7000") {

echo '<span class="style5">Invalid port.</span>'; exit;

}

if($port > "7200") {

echo '<span class="style5">Invalid port.</span>'; exit;

}
$query = mysql_query("SELECT * FROM `servers`");



	while($row = mysql_fetch_array($query)){

	if($row["name"] == $name || $row["ip"] == $ip)

	{

	echo '<span class="style5">Monitor already exists.</span>'; exit;

	}

	}



	$onlinetext = "<font color='green'><b>Online</b></font>";

	$offlinetext = "<font color='red'><b>Offline</b></font>";

	if(@fsockopen($ip,$port,$errno,$errstr,1)) {

		if(@fsockopen($ip,3000,$errno,$errstr,1)) {

		$add = mysql_query("INSERT INTO `servers` (`name`, `ip`, `port`, `url`) VALUES ('$name', '$ip', '$port', '$url')") or die(mysql_error());

		$getid = mysql_query("SELECT * FROM `servers` WHERE `name` = '$name' AND `ip` = '$ip'") or die("Tick: ". mysql_error() );

$rowid = mysql_fetch_array($getid);

$idofrow = $rowid["id"];

$q1 = mysql_query("UPDATE `servers` SET `serverID` = '$idofrow' WHERE id = '$idofrow'") or die("Error");

$q2 = mysql_query("UPDATE `servers` SET `Gate` = 'Game Server' WHERE id = '$idofrow'") or die("Error");

$q3 = mysql_query("UPDATE `servers` SET `Value` = '1' WHERE id = '$idofrow'") or die("Error");

$q4 = mysql_query("UPDATE `servers` SET `ticker` = 'Now()' WHERE id = '$idofrow'") or die("Error");

$q5 = mysql_query("UPDATE `servers` SET `Value2` = '0' WHERE id = '$idofrow'") or die("Error");

$q6 = mysql_query("UPDATE `servers` SET `type` = '$type' WHERE id = '$idofrow'") or die("Error");
echo '<span class="style5">Successfully added server.</span>';
		} else { echo '<span class="style5">Your server does not have port 3000 open which is vital so that our usercount function can work, so it cannot be added. Please open port 3000 on your server so that you can add it.</span>'; exit;

}	} else {

		echo '<span class="style5">Your server is currently not online, so it cannot be added.</span>'; exit;

	}
echo '</body>

</html>';

}

else {

?>

<form method="post" action="">

<table width="250" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000">

<tr>
<td width="50%"><span class="style5">Server Name:</span></td>

<td width="50%">

  <input type="text" name="name" id="name" />    </td>
</tr>

<tr>
<td width="50%"><span class="style5">IP:</span></td>

<td width="50%">

  <input type="text" name="ip" id="ip" />    </td>
</tr>

<tr>
<td><span class="style5">Port:</span></td>

<td><input type="text" name="port" id="port" /></td>
</tr>

<tr>
<td><span class="style5">URL to Website:</span></td>

<td><input name="url" type="text" id="url" value="http://" /></td>
</tr>

<tr>
<td><span class="style5">Server Type:</span></td>

<td><div align="center">

  <select size="1" name="type" id="type">

      <option disabled="disabled">Please Select</option>

      <option disabled="disabled">-- Mir2 --</option>

		<option value="1.9">   - 1.9</option>

		<option value="2.3">   - 2.3</option>

		<option value="2.3">   - 2.6</option>

		<option value="2.3">   - Unlsd</option>

		<option value="2.3">   - DM2</option>

       <option disabled="disabled">-- Mir3 --</option>

     	<option value="Mir3" selected="selected">   - Mir3</option>

  </select>

</div></td>
</tr>

<tr>
<td><span class="style5">Submit:</span></td>

<td><div align="center">

  <input type="submit" name="submit" id="submit" value="Submit" />

</div></td>
</tr>

</table>

</form>

</body>

</html>

<?php } ?>

dagon

fsockopen is failing, why not check the error string to see why.

change

echo '<span class="style5">Your server is currently not online, so it cannot be added.</span>';

echo '<span class="style5">Your server is currently not online, so it cannot be added.  Error number: ' . $errno . '(' . $errstr . ')'; </span>';

daydie2008

i think that code is wrong, makes the codes below it go black not red, and says this eror:

Parse error: syntax error, unexpected '<' in /home/content/d/a/y/daydie/html/Serverlist/addtostatus.php on line 153

foyer

If it works on your friends server but not yours.. I wouldn't think it's a PHP problem.

And yes there is a syntax error in dagon's code

daydie2008

well my friend said it works but he isnt going to help me try to fix no more. i think he is hiding something from me to do to make it work.

This script seems good to use bu, some reason its just giving me the error when i enter the server details. and says it check port 7000/3000 and its offline.

Is there any reason fopensock would say connection closed if it was open? ive CHMOD 777. i dont know what else to do.

If any1 can help me fix this script i will give them £10 to buy themself's a crate of fosters or something. I will give u FTP access and access to files also.

djjjozsi

can you send us the an online server parameters? which is absolutely working.

and what is the difference between serverID and id in your tables ?

http://phpcode.hu/url/show.php?id=7

djjjozsi

deleted

daydie2008

its not working. it says all servers offline. so its something to do with the port reading.

fsock thing.

daydie2008

i used that script and i get this:

Warning: fsockopen() [function.fsockopen]: unable to connect to 86.3.237.222:7200 (Connection timed out) in /home/content/d/a/y/daydie/html/Serverlist/addserver.php on line 97

djjjozsi

on my server(s): <span class="style5">Successfully added server.</span></body>

so you have no right to run this command. ask your host, or enable somehow.

daydie2008

okay ill ask, thanks for your help djjj ill post back what i get from them.

foyer

n/m

daydie2008

godaddy dont allow this on shared hosting =/ bit gay, what hosting service provider do you use?

djjjozsi

mainly i use one host (silihost.hu),
but for testing i use home local servers, and free services too.
Hello, jjozsi.

daydie2008

i have access to SSH and stuff, will i be able to activate it myself so i can use the code?

If so how can i do it buddy?

daydie2008

also if i cant do it that way. is there any other way to code my script to it works,

daydie2008

the Godaddy team say its my script :S they say if its our servers basicly prove it.

Is there any script to test fsock command.