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