code from 1 script into another?

[stevey]

hi, what im trying to do is to get http://www.tbksquad.info/index.php?action=servers&id=1 where it list players bottom right side to display in a scrolling display in this script http://www.tbksquad.info/serverStatus.php

the first script where im getting the info from is this:

<?


$conditions = "";
if(isset($id) && $id != "") $conditions = "WHERE id='$id'";

$query = DBQuery("SELECT * FROM $servers_table $conditions ORDER BY name ASC");
$stats = DBQuery("SELECT COUNT(player) AS num, SUM(kills) AS kills, MAX(last_played) AS last_active FROM $stats_table WHERE server = '$id' GROUP BY server");
$mstats = DBQuery("SELECT SUM(games) AS games, SUM(time) AS time, SUM(maps) AS maps 
                   FROM $serverstats_table WHERE serverid = '$id'");
$gstats = DBQuery("SELECT * FROM $serverstats_table WHERE serverid = '$id'");

if(file_exists($base_folder."templates/servers.htm")) {
  $tpl = new phemplate();
  $tpl->set_file("template", $base_folder."templates/servers.htm", 1);

  $thetime = time();

  if(!isset($id) || $id == "") {

$servers = array();
$row     = array();
$count   = 0;

while($row = DBFetchArray($query)) {
  if($count % 2 == 0){
    $row["class"] = $rowclass1;
  } else {
    $row["class"] = $rowclass2;
  }

  $row["name"]        = htmlspecialchars($row["name"]);

  if($thetime - $row["time"] > 120) {
    $row["status"]      = "offline"; 
    $row["server_name"] = "";
    $row["map_name"]    = "";
    $row["dedicated"]   = "";
    $row["players"]     = "";
    $row["game_type"]   = "";
    $row["game"]        = "";
    $row["map_thumbnail"]   = "<p class=\"main\">Image N/A</p>";
  } else {
    $map_query = DBQuery("SELECT * FROM $maps_table WHERE name='".$row["map_name"]."'");
    if(DBNumRows($map_query) != 0) {
      $map_row = DBFetchArray($map_query);
      if($map_row["thumbnail"] != "") {
        $row["map_thumbnail"] = "<img src=\"".$base_folder.$map_row["thumbnail"]."\" border=\"0\">";
      } else {
        $row["map_thumbnail"] = "<p class=\"main\">Image N/A</p>";
      }
    } else {
      $row["map_thumbnail"] = "<p class=\"main\">Image N/A</p>";
    }
    $row["status"]      = "online";

    $row["server_name"] = htmlspecialchars(base64_decode($row["server_name"]));
    $row["map_name"]    = htmlspecialchars(base64_decode($row["map_name"]));
    $row["players"]     = $row["num_players"]."/".$row["max_players"];
    $row["game_type"]   = ShortenGameType($row["game_type"]);
    $row["game"]        = ShortenGameName($row["game"]);
  }

  $row["num"]      = $count + 1;
  $servers[$count] = $row;
  $count++;
}

$tpl->set_var("mainscript", $mainscript);
$tpl->set_var("base",       $base_folder);
$tpl->set_loop("servers",   $servers);
$tpl->process("template", "main");
$content = $tpl->process("", "template", 1);

  } else {

$row = DBFetchArray($query);
$srow = DBFetchArray($stats);
$msrow = DBFetchArray($mstats);
foreach($gametypes as $type) {
  $row["$type"] = '0';
}

while($grow = DBFetchArray($gstats)){
  $games = array($grow["games"] => $grow["game_type"]);
  foreach($games as $index => $value) {
    $row["$value"] = $index;
  }
}

if(!($row["age"])){$row["age"] = "";} else {$row["age"] = FormatTime($row["age"]);}

$field = array("todays", "yesterdays", "this_week", "last_week", "this_month", "last_month", "this_year", "last_year");
foreach($field as $value) {
  $row["$value"] = GetLogins($value, $id);
  if(!($row["$value"])) $row["$value"] = 0;
}

if(!($srow["kills"])){$row["kills"] = 0;} else {$row["kills"] = $srow["kills"];}
if(!($srow["num"])){$row["total_players"] = 0;} else {$row["total_players"] = $srow["num"];}
if(!($srow["last_active"])){$row["last_active"] = 0;} else {$row["last_active"] = $srow["last_active"];}
if(!($msrow["games"])){$row["games"] = 0;} else {$row["games"] = $msrow["games"];}
if(!(FormatTime($msrow["uptime"]))){$row["uptime"] = '00:00:00';} else {$row["uptime"] = FormatTime($msrow["time"]);}
if(!($msrow["maps"])){$row["maps"] = 0;} else {$row["maps"] = $msrow["maps"];}
if(!($crow["num"])){$row["today"] = 0;} else {$row["today"] = $crow["num"];}
if(!($yrow["players"])){$row["yesterday"] = 0;} else {$row["yesterday"] = $yrow["players"];}

$row["name"] = htmlspecialchars($row["name"]);

if($thetime - $row["time"] > 120) {
  $row["status"]      = "offline"; 
  $row["server_name"] = "";
  $row["map_name"]    = "";
  $row["dedicated"]   = "";
  $row["players"]     = "";
  $row["game_type"]   = "";
  $row["game"]        = "";
  $row["map_image"]   = "<p class=\"main\">Image N/A</p>";
} else {
  $map_query = DBQuery("SELECT * FROM $maps_table WHERE name='".$row["map_name"]."'");
  if(DBNumRows($map_query) != 0) {
    $map_row = DBFetchArray($map_query);
    if($map_row["image"] != "") {
      $row["map_image"] = "<img src=\"".$base_folder.$map_row["image"]."\" border=\"0\">";
    } else {
      $row["map_image"] = "<p class=\"main\">Image N/A</p>";
    }
  } else {
    $row["map_image"] = "<p class=\"main\">Image N/A</p>";
  }
  $row["status"]      = "online";

  $row["server_name"] = htmlspecialchars(base64_decode($row["server_name"]));
  $row["map_name"]    = htmlspecialchars(base64_decode($row["map_name"]));
  $row["players"]     = $row["num_players"]."/".$row["max_players"];
  $row["game_type"]   = ShortenGameType($row["game_type"]);
  $row["game"]        = ShortenGameName($row["game"]);
}

foreach($row as $field=>$value) {
  $tpl->set_var($field, $value);
}

$players = array();
$player  = array();

if($row["status"] == "online") {
  $player_names   = explode("\n", $row["player_names"]);
  $player_teams   = explode("\n", $row["player_teams"]);
  $player_weapons = explode("\n", $row["player_weapons"]);

  for($i = 0; $i < count($player_names); $i++) {
    if($i % 2 == 0){
      $player["class"] = $rowclass1;
    } else {
      $player["class"] = $rowclass2;
    }
    $player["name"]         = htmlspecialchars(base64_decode($player_names[$i]));
    $player["weapon"]       = $player_weapons[$i];
    $player["team"]         = $player_teams[$i];
    if(isset($wpn_img[trim($player["weapon"])])) {
      $player["weapon_image"] = "<img src=\"".$base_folder.$wpn_img[trim($player["weapon"])]."\" border=\"0\" alt=\"".$player["weapon"]."\">";
    } else {
      $player["weapon_image"] = "";
    }
    $player["num"] = $i + 1;
    $players[$i]   = $player;
  }
}

$tpl->set_var("mainscript", $mainscript);
$tpl->set_var("base",       $base_folder);
$tpl->set_loop("players",   $players);
$tpl->process("template", "server_info");
$content = $tpl->process("", "server_info", 1);
  }
} else {
  $content = "Error: template 'servers' does not exist";
}

?> 

and this is what ive got so far:

[stevey]

<?
class Server {
  function _getConnection() {
   $host  = "localhost";      // Database hostname.
   $user  = "removed"; // Database username.
   $pass  = "removed";    // Database password.
   $db    = "tbksinfo_stats"; // Database name.
   $path  = "/";  // Database url to stats, must have trailing /.

   //DO NOT EDIT BELOW THIS LINE.
   $conn = mysql_connect($host, $user, $pass) or die('<br>ERROR! - Failure connecting to the database!');
   $conn = mysql_select_db($db, $conn) or die('<br>ERROR! - Failure selecting the database!');
   return $path;
  }

  function _getServerDetails($id) {
   $sql = "SELECT * FROM st2ats_servers WHERE st2ats_servers.id = $id LIMIT 1";
   $rs = mysql_query($sql);
   mysql_num_rows($rs)  or die ('<br>ERROR! - Failure getting server details from the database!');
   $data = array();
   $data = mysql_fetch_assoc($rs);
   foreach($data as $index => $value) {
     $this->$index = $value;
   }
   return $data;
  }

  function _getMapImage($name) {
    $this->path = Server::_getConnection();
   $sql = "SELECT image FROM st2ats_maps WHERE name = '$name' LIMIT 1";
   $rs = mysql_query($sql);
   mysql_num_rows($rs);
   $data = array();
   $data = mysql_fetch_array($rs);
   if (!$data['image']) {
     $this->image = "<img src='http://www.tbksquad.info/maps/l_none.jpg' width=\"87\" height=\"65\"></a>";
   } else {
     $this->image = "<a href='".$this->path."index.php?action=servers&id=".$this->id."'target='_blank'>
                     <img src='".$this->path.$data['image']."' width=\"87\" height=\"65\"></a>";
   }
   $this->statsLink = "<a href='".$this->path."index.php?action=servers&id=".$this->id."'target='_blank'>Click for stats</a>";
   return $this->image;
   return $this->statsLink;
  }

  function _getServers() {
    Server::_getConnection();
   $sql = "SELECT * FROM st2ats_servers";
   $rs = mysql_query($sql) or die ('Could not select from the database!');
   mysql_num_rows($rs) or die ('No servers in the database!');
   $id = array();
   while($data = mysql_fetch_assoc($rs)) {
     $time = $data['time'];
     $thetime = time();
      if (($thetime - $time) < 120) {
       $id[] = $data['id'];
     } else {
     }
   }
   if(!($id) || $id == "") print "<div align=\"center\"><img src='http://www.tbksquad.info/maps/l_new.jpg' width=\"87\" height=\"65\"></a></div>";
   return $id;
  }

  function _getDetails($id) {
    $arData = Server::_getServerDetails($id);
   $this->_servers = Server::_getServerDetails($id);
   $this->server_name = htmlspecialchars(base64_decode($this->server_name));
   $this->image = Server::_getMapImage($this->map_name);
   $this->map_name = htmlspecialchars(base64_decode($this->map_name));
   $this->age = Server::FormatTime($this->age);
   $this->player_names = htmlspecialchars(base64_decode($this->player_names));
   $this->player_teams = $this->player_teams;

for($i = 0; $i < count($this->player_names); $i++) {
    if($i % 2 == 0){
      $player["class"] = $rowclass1;
    } else {
      $player["class"] = $rowclass2;
    }

   //print $this->server_name."<br></br>";
   print $this->image."<br></br>";
   print "".$this->map_name."<br>";
   print "".$this->game_type."<br>";
   print "Players: ".$this->num_players."/".$this->max_players."<br>";
   print "Map Age: ".$this->age."<br>";
   include("http://www.tbksquad.info/usaping.php");

 //  print "Players: ".$this->player_names."<br>";  //show players
   print "<br> <a href='http://www.tbksquad.info/index.php?action=kill_stats' target='_blank'>View Stats</a>";  //show players
  }

  //Baboon's Babstats Script Function
  function FormatTime($seconds) {
    $hours    = floor($seconds/3600);
    $seconds -= $hours * 3600;
    $minutes  = floor($seconds/60);
    $seconds -= $minutes * 60;
    return sprintf("%d:%02d:%02d", $hours, $minutes, $seconds);
  }
}
?>

can anyone help / point me in the right direction, ive managed to get it to display one persons name (not scrolling or coloured), but that is all, and above is my latest attempt

thanks