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

<?php

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

        include "./inc/header.htm";

?>

 <h2>niX-FILES</h2>

 <h1>Участники проекта</h1>

<?php

        // table header

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

        echo "<table>";

        echo "<tr>";

        echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>";

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

            $ranks =& $db->query("SELECT *

            FROM res_mem_rank

            JOIN resources ON resources.id = res_mem_rank.resource_id

            JOIN networks ON networks.id = res_mem_rank.network_id

            JOIN members ON members.id = res_mem_rank.member_id

            WHERE member_id=".$info_mems['id']);

            $ranklist = "";

            while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) {

                $ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>";

            }

            echo "<tr><td>".$info_mems['nick']."</td><td><img src='".$info_mems['avatar']."'</td><td>".$info_mems['jabber']."</td><td>".$ranklist."</td></tr>";

        }

        // table footer

        echo "</table>";

        include "./inc/footer.htm";

?>