Хранилища Subversion www_nix-files

<?php

	require_once dirname(__FILE__)."/lib/init.php";

	include "./inc/header.htm";

?>

 <h2>niX-FILES</h2>

 <h1>любые файлы *nix тематики в локальных сетях Барнаула</h1>

 <h3><i>изучай/пользуй/обновляй линукс вместе с nix-files.org.ru</i></h3>

<?php

$srv = abs(intval($_GET["srv"]));

if($srv==0) {

	$srvs =& $db->query("SELECT * FROM members JOIN servers ON servers.member_id=members.id");

	echo "<table>";

	echo "<tr>";

	echo "<th>Сервер</th><th>Админ</th><th>IP</th>\n";

	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {

	    echo "<tr>";

	    echo "<td><a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a></td>\n";

	    echo "<td><a href='./members.php?memb=".$info_srvs['member_id']."'>".$info_srvs['nick']."</a></td>\n";

	    $ips =& $db->query("SELECT * FROM ips WHERE server_id=".$info_srvs['id']);

	    echo "<td>";

	    while ($ips->fetchInto($info_ips, DB_FETCHMODE_ASSOC)) {

		echo $info_ips['ip']."<br>";

	    }

	    echo "</td>";

	}

	echo "</table>\n";

}

else {

	$srvs =& $db->query("SELECT * FROM members JOIN servers ON servers.member_id=members.id WHERE servers.id=".$srv);

	while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {

	    echo "<h1>".$info_srvs['server']."</h1>\n";

	    echo "<br>Админ: ".$info_srvs['nick'];

	    echo "<br>IP: <br> | ";

	    $ips =& $db->query("SELECT * FROM ips WHERE server_id=".$info_srvs['id']);

	    echo "<td>";

	    while ($ips->fetchInto($info_ips, DB_FETCHMODE_ASSOC)) {

		echo $info_ips['ip']." | ";

	    }

	    echo "</td>";

	}

}

	include "./inc/footer.htm";

?>