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

Редакция

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

Редакция Автор № строки Строка
5 diffor 1 
<?php
2 
	require_once dirname(__FILE__)."/lib/init.php";
3 
	include "./inc/header.htm";
4 
 
5 
$act = $_GET["act"];
6 
$resource_id = $_GET["res"];
7 
$network_id = $_GET["net"];
8 
 
9 
switch ($act) {
10 
    case 0:
11 
	// table header
12 
	$nets =& $db->query("SELECT * FROM networks");
13 
	echo "<table>";
14 
	echo "<tr>";
15 
	echo "<th>&nbsp;</th><th>&nbsp;</th><th>Ресурс</th>";
16 
 
17 
	$netlist = array();
18 
	$netcount = $nets->numRows();
19 
	$n = 0;
20 
	while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) {
21 
	    // network name & link
22 
	    if ($info_nets['link']=="") { echo "<th>".$info_nets['network']."</th>"; }
23 
	    else { echo "<th><a href='".$info_nets['link']."'>".$info_nets['network']."</a></th>"; }
24 
	    // netlist
25 
	    $netlist[$n] = $info_nets['id'];
26 
	    $n++;
27 
	}
28 
 
29 
	echo "</tr>";
30 
	// table body
31 
	$cats =& $db->query("SELECT * FROM categories");
32 
	while ($cats->fetchInto($info_cats, DB_FETCHMODE_ASSOC)) {
33 
	    $res =& $db->query("SELECT * FROM resources WHERE category_id=".$info_cats['id']);
34 
	    $first = true;
35 
	    while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) {
36 
		echo "<tr>";
37 
 
38 
		// add rowspan on first resource on category
39 
		if ($first) {
40 
		    echo "<td rowspan='".$res->numRows()."'>".$info_cats['category']."</td>";
41 
		    $first = false;
42 
		}
43 
 
44 
		// resource picture
45 
		echo "<td><img src='".$info_res['picture']."' alt='".$info_res['resource']."'></td>";
46 
 
47 
		// resource name & link
48 
		if ($info_res['link_talk']=="") { echo "<td>".$info_res['resource']."</td>"; }
49 
		else { echo "<td><a href='".$info_res['link_talk']."'>".$info_res['resource']."</a></td>"; }
50 
 
51 
		// resource state by network
52 
		for ($i=0;$i<$netcount;$i++) {
53 
/////////////////////
54 
	$mems =& $db->query("SELECT * FROM members JOIN res_mem_rank ON res_mem_rank.member_id=members.id WHERE resource_id=".$info_res['id']." AND network_id=".$netlist[$i]);
55 
	echo "<td>";
56 
	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
57 
	    echo $info_mems['nick'];
58 
	    echo "<a href='./members_admin.php?act=2&id=".$info_mems['id']."'><img src='./img/act/edit.png' alt='edit'></a>";
59 
	    echo "<a href='./members_admin.php?act=3&id=".$info_mems['id']."'><img src='./img/act/delete.png' alt='delete'></a>";
60 
	}
61 
	echo "<br><a href='./members_admin.php?act=1&res=".$info_res['id']."&net=".$netlist[$i]."'><img src='./img/act/add.png' alt='add'></a>";
62 
	echo "</td>";
63 
/////////////////////
64 
		}
65 
		echo "</tr>";
66 
	    }
67 
	}
68 
	// table footer
69 
	echo "</table>";
70 
    break;
71 
    case 1:
72 
	// Добавление нового дистрибутива
73 
	$mems =& $db->query("SELECT * FROM members");
74 
	echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n";
75 
	echo "<input type='hidden' name='act' value='".$act."'>\n";
76 
	echo "<input type='hidden' name='resource_id' value='".$resource_id."'>\n";
77 
	echo "<input type='hidden' name='network_id' value='".$network_id."'>\n";
78 
	echo "Ник: ";
79 
	echo "<select name='member_id'>";
80 
	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
81 
	    echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>";
82 
	};
83 
	echo "</select><br>\n";
84 
	echo "<input type='submit' value='Добавить'></form>\n";
85 
    break;
86 
    case 2:
87 
    break;
88 
    case 3:
89 
    break;
90 
}
91 
 
92 
?>