screen -A -m -S 10-srv207 ./Script.sh

<?php
$id= $_GET['serverid'];
 $dbname='swift';
$link = mysql_connect('localhost', $dbname, 'yoursqldbpassword');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully <br/>';

// This could be supplied by a user, for example
//Formulate Query
// This is the best way to perform an SQL query
// For more examples, see mysql_real_escape_string()
$query = sprintf("SELECT ipid, game, query, user, password, homedir  FROM swift.server WHERE serverid='%s' ",
    mysql_real_escape_string($id));

// Perform Query
$result = mysql_query($query);

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
  $ipid = $row['ipid'];
  $game = $row['game'];
  $valve = $row['query'];
  $user = $row['user'];
  $pass = $row['password'];
  $homdir = $row['homedir'];
}

if (!($valve == 'valve')){
  die( "Not a Steam game.<a href='JavaScript:window.close()'>Close</a>");
 } else {

  if ($game == 'Team Fortress 2'){
    $game = '"tf"';
  }
  if ($game == 'Counter-Strike 1.6'){
    $game = '"cstrike"';
  }
  if ($game == 'Counter-Strike: Source'){
    $game = '"Counter-Strike Source"';
  }
  if ($game == 'Counter-Strike: Condition Zero'){
    $game = '"czero"';
  }
  if ($game == 'Left4Dead'){
    $game = '"left4dead"';
  }
  if ($game == 'Left4Dead2'){
    $game = '"left4dead2"';
  }
   if ($game == 'Day of Defeat'){
    $game = '"dod"';
  }
  if ($game == 'Day of Defeat: Source'){
    $game = '"dods"';
  }
  if ($game == 'Garrys Mod'){
    $game = '"garrysmod"';
  }
  if ($game == 'Half Life TV'){
    $game = '"valve"';
  }
 
// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);

$query2 = sprintf("SELECT ip  FROM swift.ip WHERE ipid='%s' ",
    mysql_real_escape_string($ipid));

$result = mysql_query($query2);

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
  $ip = $row['ip'];
}

mysql_free_result($result);

mysql_close($link);

// echo "<br/>";
// echo  $ipid  ;
//echo "<br/>";
// echo  $game  ;
//echo "<br/>";
// echo  $valve ;
//echo "<br/>";
// echo  $user  ;
//echo "<br/>";
// echo  $pass  ;
//echo "<br/>";
// echo  $homdir;
//echo "<br/>";
// echo  $ip    ;
 }
if (!function_exists("ssh2_connect")) die("function ssh2_connect doesn't exist");
// log in at server1.example.com on port 22
if(!($con = ssh2_connect($ip, 22))){
  echo "fail: unable to establish connection\n";
} else {
    // try to authenticate with username, password
  if(!ssh2_auth_password($con, $user,$pass)) {
        echo "fail: unable to authenticate\n";
    } else {
        // allright, we're in!
        echo "OK: Logged in...\n<br/><br/>";

        // execute a command
	$command0='./steam ';
	$command1='-command update ';
	$command2='-game ';
	$command3=' -dir .';
	$command= $command0. $command1. $command2. $game. $command3;
	//	echo $command ;
        if (!($stream = ssh2_exec($con,$command  ))) {
            echo "fail: unable to execute command\n";
        } else {
            // collect returning data from command
            stream_set_blocking($stream, true);
	    echo nl2br( stream_get_contents($stream));  
            //echo "Updating Steam...\n<br/><br/>";	  
//print_r($output);

// echo stream_get_line($stream,75,'...');
            echo "<br/><br/>"; 
	    
$data = "";
            while ($buf = fread($stream,4096)) 
{
                $data = $buf;
  
            }           
	    
	    fclose($stream);
        }
    }
}

echo "Done...\n";


?>
<br/>
<input name="button" type="button" onclick="window.location='serversummary.php?id=<?php echo $id; ?>
'" value="Back" />