Редакция 30 | Редакция 33 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS
Редакция | Автор | № строки | Строка |
---|---|---|---|
30 | diffor | 1 | <?php |
2 | require_once dirname(__FILE__)."/lib/init.php"; |
||
3 | include "./inc/header.htm"; |
||
4 | ?> |
||
5 | <h2>niX-FILES</h2> |
||
6 | <h1>любые файлы *nix тематики в локальных сетях Барнаула</h1> |
||
7 | <h3><i>изучай/пользуй/обновляй линукс вместе с nix-files.org.ru</i></h3> |
||
8 | <?php |
||
9 | |||
10 | $net = abs(intval($_GET["net"])); |
||
11 | |||
12 | if($net==0) { |
||
13 | echo "<table>"; |
||
14 | echo "<tr>"; |
||
15 | echo "<th>Сеть</th><th>Подсети</th><th>Ресурсы</th>"; |
||
16 | |||
17 | $nets =& $db->query("SELECT * FROM networks"); |
||
18 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
||
19 | |||
20 | echo "<tr>"; |
||
21 | echo "<td>".$info_nets['network']."</td>"; |
||
22 | |||
23 | echo "<td>"; |
||
24 | $snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$info_nets['id']); |
||
25 | while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
||
26 | echo $info_snets['subnet']."<br>"; |
||
27 | } |
||
28 | echo "</td>"; |
||
32 | diffor | 29 | |
30 | echo "<td>"; |
||
30 | diffor | 31 | $res =& $db->query("SELECT * |
32 | FROM res_net_stat |
||
33 | JOIN resources ON resources.id = res_net_stat.resource_id |
||
34 | WHERE res_net_stat.network_id=".$info_nets['id']); |
||
35 | while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
||
32 | diffor | 36 | echo "<img src='".$info_res['picture']."' alt='logo'><a href='./details.php?res=".$info_res['id']."'>".$info_res['resource']."</a><br>"; |
30 | diffor | 37 | } |
32 | diffor | 38 | echo "</td>"; |
39 | echo "</tr>"; |
||
30 | diffor | 40 | } |
41 | echo "</table>"; |
||
42 | } |
||
43 | else { |
||
32 | diffor | 44 | $nets =& $db->query("SELECT * FROM networks WHERE id=".$net); |
45 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
||
46 | echo "<h1>".$info_nets['network'].".niX-FILES</h1>"; |
||
47 | |||
48 | echo "<br>Проекты:<br> | "; |
||
49 | $ress =& $db->query("SELECT * FROM res_net_stat JOIN resources ON resources.id=res_net_stat.resource_id WHERE network_id=".$net); |
||
50 | while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) { |
||
51 | echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress['id']."'>".$info_ress['resource']."</a> | "; |
||
52 | } |
||
53 | |||
54 | echo "<br><br>В подсетях:"; |
||
55 | echo "<table>"; |
||
56 | $snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$net); |
||
57 | while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
||
58 | echo "<tr><td>".$info_snets['subnet']."</td></tr>"; |
||
59 | } |
||
60 | echo "</table>"; |
||
61 | |||
62 | } |
||
30 | diffor | 63 | } |
64 | |||
65 | include "./inc/footer.htm"; |
||
66 | ?> |