6,6 → 6,11 |
<h1>любые файлы *nix тематики в локальных сетях Барнаула</h1> |
<h3><i>изучай/пользуй/обновляй линукс вместе с nix-files.org.ru</i></h3> |
<?php |
|
$mod = abs(intval($_GET["mod"])); |
|
switch($mod) { |
case 0: |
// table header |
$nets =& $db->query("SELECT * FROM networks"); |
echo "<table>"; |
77,15 → 82,47 |
} |
// table footer |
echo "</table>"; |
?> |
<br> |
<table id="legend"> |
<tr><td><img src="./img/state/main.png" alt="main"></td><td>Основной ресурс.</td></tr> |
<tr><td><img src="./img/state/mirror.png" alt="mirror"></td><td>Зеркало ресурса.</td></tr> |
<tr><td><img src="./img/state/access.png" alt="access"></td><td>Есть свободный высокоскоростной доступ к ресурсу.</td></tr> |
<tr><td><img src="./img/state/freeze.png" alt="freeze"></td><td>Проект временно недоступен.</td></tr> |
</table> |
include "./inc/legend.htm"; |
break; |
case 1: |
$nets =& $db->query("SELECT * FROM networks"); |
echo "<table>"; |
echo "<tr>"; |
echo "<th>Сеть</th><th>Описание</th><th>Подсети</th><th>Ресурсы</th>"; |
while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
$res =& $db->query("SELECT * |
FROM res_net_stat |
JOIN resources ON resources.id = res_net_stat.resource_id |
WHERE res_net_stat.network_id=".$info_nets['id']); |
$reslist = ""; |
while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
$reslist .= $info_res['resource']."<br>"; |
} |
echo "<tr><td>".$info_nets['network']."</td><td></td><td></td><td>".$reslist."</td></tr>"; |
} |
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; |
} |
|
<?php |
include "./inc/footer.htm"; |
?> |