<?php

include_once('../global.php');
include_once('code.php'); 

$User = array(0 => array('fullname' => ''));
$DbResult = $Database->select('users', '*,CONCAT(second_name, " ",first_name) as fullname');
while($Row = $DbResult->fetch_array())
{
  $User[$Row['id']] = $Row;
}

$DbResult = $Database->select('hosts','*','1 ORDER BY id');
while($Row = $DbResult->fetch_array())
{
  $Row = $Row['id'].':'.$Row['parent'].':'.$Row['name'].':'.$Row['IP'].':'.$User[$Row['user']]['fullname'].':'.$Row['block']."\n";
  $Row = StrTr($Row, "\xA9\xAB\xAE\xB9\xBB\xBE", "\x8A\x8D\x8E\x9A\x9D\x9E");
  echo($Row); 
}
  
?>