Хранилища 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>Админ</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>";

            echo "<img src='./img/srv/cpu.png' alt='cpu'>".$info_srvs['cpu']."<br>";

            echo "<img src='./img/srv/ram.png' alt='ram'>".$info_srvs['ram']."<br>";

            echo "<img src='./img/srv/hdd.png' alt='hdd'>".$info_srvs['hdd'];

            echo "</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";

?>