Редакция 22 | Редакция 30 | К новейшей редакции | Весь файл | Учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 22 | Редакция 27 | ||
---|---|---|---|
Строка 103... | Строка 103... | ||
103 | }
|
103 | }
|
104 | echo "<tr><td>".$info_nets['network']."</td><td></td><td></td><td>".$reslist."</td></tr>"; |
104 | echo "<tr><td>".$info_nets['network']."</td><td></td><td></td><td>".$reslist."</td></tr>"; |
105 | }
|
105 | }
|
106 | echo "</table>"; |
106 | echo "</table>"; |
107 | break; |
107 | break; |
108 | case 2: |
- | |
109 | $mems =& $db->query("SELECT * FROM members"); |
- | |
110 | echo "<table>"; |
- | |
111 | echo "<tr>"; |
- | |
112 | echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>"; |
- | |
113 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
- | |
114 | $ranks =& $db->query("SELECT * |
- | |
115 | FROM res_mem_rank
|
- | |
116 | JOIN resources ON resources.id = res_mem_rank.resource_id
|
- | |
117 | JOIN networks ON networks.id = res_mem_rank.network_id
|
- | |
118 | JOIN members ON members.id = res_mem_rank.member_id
|
- | |
119 | WHERE member_id=".$info_mems['id']); |
- | |
120 | $ranklist = ""; |
- | |
121 | while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
- | |
122 | $ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>"; |
- | |
123 | }
|
108 | }
|
124 | echo "<tr><td>".$info_mems['nick']."</td><td><img src='".$info_mems['avatar']."'</td><td>".$info_mems['jabber']."</td><td>".$ranklist."</td></tr>"; |
- | |
125 | }
|
- | |
126 | echo "</table>"; |
- | |
127 | break; |
- | |
128 | }
|
- | |
129 | - | ||
130 | include "./inc/footer.htm"; |
109 | include "./inc/footer.htm"; |
131 | ?>
|
110 | ?>
|