Содержимое файла | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
4 | diffor | 1 | <?php |
2 | require_once dirname(__FILE__)."/lib/init.php"; |
||
3 | include "./inc/header.htm"; |
||
4 | ?> |
||
5 | <h2>niX-FILES</h2> |
||
6 | <h1>Участники проекта</h1> |
||
7 | <?php |
||
8 | // table header |
||
9 | $mems =& $db->query("SELECT * FROM members"); |
||
10 | echo "<table>"; |
||
11 | echo "<tr>"; |
||
12 | echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>"; |
||
13 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
||
14 | $ranks =& $db->query("SELECT * |
||
15 | FROM res_mem_rank |
||
16 | JOIN res_net_stat ON res_mem_rank.res_net_id = res_net_stat.id |
||
17 | JOIN networks ON networks.id = res_net_stat.network_id |
||
18 | JOIN resources ON resources.id = res_net_stat.resource_id |
||
19 | WHERE member_id=".$info_mems['id']); |
||
20 | $ranklist = ""; |
||
21 | while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
||
22 | $ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>"; |
||
23 | } |
||
24 | echo "<tr><td>".$info_mems['nick']."</td><td><img src='".$info_mems['avatar']."'</td><td>".$info_mems['jabber']."</td><td>".$ranklist."</td></tr>"; |
||
25 | } |
||
26 | // table footer |
||
27 | echo "</table>"; |
||
28 | include "./inc/footer.htm"; |
||
29 | ?> |