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