Редакция 33 | Редакция 35 | К новейшей редакции | Только различия | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
| Редакция 33 | Редакция 34 | ||
|---|---|---|---|
| 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>\n"; |
| 14 | echo "<tr>"; |
14 | echo "<tr>\n"; |
| 15 | echo "<th>Сеть</th><th>Подсети</th><th>Ресурсы</th>"; |
15 | echo "<th>Сеть</th><th>Подсети</th><th colspan='2'>Ресурсы</th>\n"; |
| - | 16 | echo "</tr>\n"; |
|
| 16 | 17 | ||
| 17 | $nets =& $db->query("SELECT * FROM networks"); |
18 | $nets =& $db->query("SELECT * FROM networks"); |
| 18 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
19 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
| 19 | 20 | ||
| 20 | echo "<tr>"; |
21 | $first = true; |
| 21 | echo "<td><a href='./networks.php?net=".$info_nets['id']."'>".$info_nets['network']."</a></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>"; |
- | |
| 29 | - | ||
| 30 | echo "<td>"; |
- | |
| 31 | $res =& $db->query("SELECT * |
22 | $res =& $db->query("SELECT * |
| 32 | FROM res_net_stat
|
23 | FROM res_net_stat
|
| 33 | JOIN resources ON resources.id = res_net_stat.resource_id
|
24 | JOIN resources ON resources.id = res_net_stat.resource_id
|
| 34 | WHERE res_net_stat.network_id=".$info_nets['id']); |
25 | WHERE res_net_stat.network_id=".$info_nets['id']); |
| 35 | while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
26 | while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
| - | 27 | echo "<tr>\n"; |
|
| - | 28 | ||
| - | 29 | if ($first) { |
|
| - | 30 | echo " <td rowspan='".$res->numRows()."'><a href='./networks.php?net=".$info_nets['id']."'>".$info_nets['network']."</a></td>\n"; |
|
| - | 31 | echo " <td rowspan='".$res->numRows()."'>"; |
|
| - | 32 | $snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$info_nets['id']); |
|
| - | 33 | if ($snets->numRows()==0) echo "Нет данных."; |
|
| - | 34 | while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
|
| - | 35 | echo $info_snets['subnet']."<br>"; |
|
| - | 36 | }
|
|
| - | 37 | echo " </td>\n"; |
|
| - | 38 | $first = false; |
|
| - | 39 | }
|
|
| - | 40 | ||
| 36 | echo "<img src='".$info_res['picture']."' alt='logo'><a href='./details.php?res=".$info_res['id']."'>".$info_res['resource']."</a><br>"; |
41 | echo " <td><img src='".$info_res['picture']."' alt='logo'></td>\n<td><a href='./details.php?res=".$info_res['id']."'>".$info_res['resource']."</a></td>\n"; |
| - | 42 | echo "</tr>\n"; |
|
| 37 | }
|
43 | }
|
| 38 | echo "</td>"; |
- | |
| 39 | echo "</tr>"; |
- | |
| 40 | }
|
44 | }
|
| 41 | echo "</table>"; |
45 | echo "</table>"; |
| 42 | }
|
46 | }
|
| 43 | else { |
47 | else { |
| 44 | $nets =& $db->query("SELECT * FROM networks WHERE id=".$net); |
48 | $nets =& $db->query("SELECT * FROM networks WHERE id=".$net); |
| 45 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
49 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
| 46 | echo "<h1>niX-FILES в ".$info_nets['network']."</h1>"; |
50 | echo "<h1>niX-FILES в ".$info_nets['network']."</h1>"; |
| 47 | echo "Сайт: <a href='".$info_nets['link']."'>".$info_nets['link']."</a>"; |
51 | echo "Сайт: <a href='".$info_nets['link']."'>".$info_nets['link']."</a>"; |
| 48 | 52 | ||
| 49 | echo "<br><br>Проекты:<br> | "; |
53 | echo "<br><br>Проекты:<br> | "; |
| 50 | $ress =& $db->query("SELECT * FROM res_net_stat JOIN resources ON resources.id=res_net_stat.resource_id WHERE network_id=".$net); |
54 | $ress =& $db->query("SELECT * FROM res_net_stat JOIN resources ON resources.id=res_net_stat.resource_id WHERE network_id=".$net); |
| 51 | while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) { |
55 | while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) { |
| 52 | echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress['id']."'>".$info_ress['resource']."</a> | "; |
56 | echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress['id']."'>".$info_ress['resource']."</a> | "; |
| 53 | }
|
57 | }
|
| 54 | 58 | ||
| 55 | echo "<br><br>В подсетях:"; |
59 | echo "<br><br>В подсетях:"; |
| 56 | echo "<table>"; |
60 | echo "<table>"; |
| 57 | $snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$net); |
61 | $snets =& $db->query("SELECT * FROM subnets WHERE network_id=".$net); |
| 58 | while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
62 | while ($snets->fetchInto($info_snets, DB_FETCHMODE_ASSOC)) { |
| 59 | echo "<tr><td>".$info_snets['subnet']."</td></tr>"; |
63 | echo "<tr><td>".$info_snets['subnet']."</td></tr>"; |
| 60 | }
|
64 | }
|
| 61 | echo "</table>"; |
65 | echo "</table>"; |
| 62 | 66 | ||
| 63 | }
|
67 | }
|
| 64 | }
|
68 | }
|
| 65 | 69 | ||
| 66 | include "./inc/footer.htm"; |
70 | include "./inc/footer.htm"; |
| 67 | ?>
|
71 | ?>
|
| 68 | 72 | ||