6,11 → 6,6 |
<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>"; |
86,25 → 81,6 |
// table footer |
echo "</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; |
} |
|
include "./inc/footer.htm"; |
?> |