Хранилища Subversion www_nix-files

Редакция

Редакция 4 | Редакция 13 | К новейшей редакции | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | RSS

Редакция Автор № строки Строка
2 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 diffor 9 
 
10 
$mod = abs(intval($_GET["mod"]));
11 
 
12 
switch($mod) {
13 
    case 0:
2 diffor 14 
	// table header
15 
	$nets =& $db->query("SELECT * FROM networks");
16 
	echo "<table>";
17 
	echo "<tr>";
18 
	echo "<th>&nbsp;</th><th>&nbsp;</th><th>Ресурс</th>";
19 
 
20 
	$netlist = array();
21 
	$netcount = $nets->numRows();
22 
	$n = 0;
23 
	while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) {
24 
	    // network name & link
25 
	    if ($info_nets['link']=="") { echo "<th>".$info_nets['network']."</th>"; }
26 
	    else { echo "<th><a href='".$info_nets['link']."'>".$info_nets['network']."</a></th>"; }
27 
	    // netlist
28 
	    $netlist[$n] = $info_nets['id'];
29 
	    $n++;
30 
	}
31 
 
32 
	echo "</tr>";
33 
	// table body
34 
	$cats =& $db->query("SELECT * FROM categories");
35 
	while ($cats->fetchInto($info_cats, DB_FETCHMODE_ASSOC)) {
36 
	    $res =& $db->query("SELECT * FROM resources WHERE category_id=".$info_cats['id']);
37 
	    $first = true;
38 
	    while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) {
39 
		echo "<tr>";
40 
 
41 
		// add rowspan on first resource on category
42 
		if ($first) {
43 
		    echo "<td rowspan='".$res->numRows()."'>".$info_cats['category']."</td>";
44 
		    $first = false;
45 
		}
46 
 
47 
		// resource picture
48 
		echo "<td><img src='".$info_res['picture']."' alt='".$info_res['resource']."'></td>";
49 
 
50 
		// resource name & link
3 diffor 51 
		if ($info_res['link_talk']=="") { echo "<td>".$info_res['resource']."</td>"; }
52 
		else { echo "<td><a href='".$info_res['link_talk']."'>".$info_res['resource']."</a></td>"; }
2 diffor 53 
 
54 
		// resource state by network
55 
		for ($i=0;$i<$netcount;$i++) {
56 
		    $curstate =& $db->getOne("SELECT state_id FROM res_net_stat WHERE resource_id=".$info_res['id']." AND network_id=".$netlist[$i]);
57 
		    $curimg = "./img/state/unknown.png";
58 
		    if ($curstate == null) {
59 
			echo "<td>&mdash;</td>";
60 
		    }
61 
		    else {
62 
			// !replace in future!
63 
			switch ($curstate) {
64 
			    case '1':
65 
				$curimg = "./img/state/main.png";
66 
			    break;
67 
			    case '2':
68 
				$curimg = "./img/state/mirror.png";
69 
			    break;
70 
			    case '3':
71 
				$curimg = "./img/state/access.png";
72 
			    break;
73 
			    case '4':
74 
				$curimg = "./img/state/freeze.png";
75 
			    break;
76 
			}
3 diffor 77 
			echo "<td><a href='".$info_res['link_res']."'><img src='".$curimg."' alt='nop'></a></td>";
2 diffor 78 
		    }
79 
		}
80 
		echo "</tr>";
81 
	    }
82 
	}
83 
	// table footer
84 
	echo "</table>";
9 diffor 85 
	include "./inc/legend.htm";
86 
    break;
87 
    case 1:
88 
	$nets =& $db->query("SELECT * FROM networks");
89 
	echo "<table>";
90 
	echo "<tr>";
91 
	echo "<th>Сеть</th><th>Описание</th><th>Подсети</th><th>Ресурсы</th>";
92 
	while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) {
93 
	    $res =& $db->query("SELECT *
94 
	    FROM res_net_stat
95 
	    JOIN resources ON resources.id = res_net_stat.resource_id
96 
	    WHERE res_net_stat.network_id=".$info_nets['id']);
97 
	    $reslist = "";
98 
	    while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) {
99 
		$reslist .= $info_res['resource']."<br>";
100 
	    }
101 
	    echo "<tr><td>".$info_nets['network']."</td><td></td><td></td><td>".$reslist."</td></tr>";
102 
	}
103 
	echo "</table>";
104 
    break;
105 
    case 2:
106 
	$mems =& $db->query("SELECT * FROM members");
107 
	echo "<table>";
108 
	echo "<tr>";
109 
	echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>";
110 
	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
111 
	    $ranks =& $db->query("SELECT *
112 
	    FROM res_mem_rank
113 
	    JOIN resources ON resources.id = res_mem_rank.resource_id
114 
	    JOIN networks ON networks.id = res_mem_rank.network_id
115 
	    JOIN members ON members.id = res_mem_rank.member_id
116 
	    WHERE member_id=".$info_mems['id']);
117 
	    $ranklist = "";
118 
	    while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) {
119 
		$ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>";
120 
	    }
121 
	    echo "<tr><td>".$info_mems['nick']."</td><td><img src='".$info_mems['avatar']."'</td><td>".$info_mems['jabber']."</td><td>".$ranklist."</td></tr>";
122 
	}
123 
	echo "</table>";
124 
    break;
125 
}
4 diffor 126 
 
2 diffor 127 
	include "./inc/footer.htm";
128 
?>