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

<?php

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

        include "./inc/header.htm";

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

if($memb==0) {

        $mems =& $db->query("SELECT * FROM members");

        echo "<table>";

        echo "<tr>";

        echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Куратор</th><th>Админ</th>\n";

        while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {

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

            echo "<td><img src='".$info_mems['avatar']."' alt='avatar'></td><td><img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."</td>\n";

            echo "<td>";

            $ress =& $db->query("SELECT * FROM resources WHERE member_id=".$info_mems['id']);

            while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {

                echo "<img src='".$info_ress['picture']."' alt='".$info_ress['resource']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a><br>";

            }

            echo "</td>";

            echo "<td>";

            $srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$info_mems['id']);

            if ($srvs->numRows()==0)

                 echo "&mdash";

            else

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

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

            }

            echo "</td>\n";

            echo "</tr>\n";

        }

        echo "</table>";

}

else {

        $mems =& $db->query("SELECT * FROM members WHERE id=".$memb);

        while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {

            echo "<h2>".$info_mems['nick']."</h2>\n";

            echo "<h2>".$info_mems['fio']."</h2>\n";

            echo "<img src='".$info_mems['avatar']."' alt='avatar'><br>\n";

            echo "<img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."<br>\n";

            echo "<br>Курирует:<br> | ";

            $ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);

            while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {

                echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a> | ";

            }

            echo "<br>";

            echo "<br>Администрирует:<br> | ";

            $srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);

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

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

            }

        }

}

        include "./inc/footer.htm";

?>