(root)/trunk/members.php - Редакция 4
Авторство |
Последнее изменение |
Открыть журнал
| RSS
<?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 res_net_stat ON res_mem_rank.res_net_id = res_net_stat.id
JOIN networks ON networks.id = res_net_stat.network_id
JOIN resources ON resources.id = res_net_stat.resource_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";
?>