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

<?php

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

	include "./inc/header.htm";

$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 "<h2>".$info_srvs['server']."</h2>\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";

?>