| 105,27 → 105,6 |
|---|
| } |
| echo "</table>"; |
| break; |
| case 2: |
| $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>"; |
| } |
| echo "</table>"; |
| break; |
| } |
| |
| include "./inc/footer.htm"; |
| ?> |