Редакция 6 | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | 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"]; |
||
6 | diffor | 8 | $member_id = $_GET["mid"]; |
9 | $uid = $_GET["id"]; |
||
5 | diffor | 10 | |
11 | switch ($act) { |
||
12 | case 0: |
||
13 | // table header |
||
14 | $nets =& $db->query("SELECT * FROM networks"); |
||
15 | echo "<table>"; |
||
16 | echo "<tr>"; |
||
17 | echo "<th> </th><th> </th><th>Ресурс</th>"; |
||
18 | |||
19 | $netlist = array(); |
||
20 | $netcount = $nets->numRows(); |
||
21 | $n = 0; |
||
22 | while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) { |
||
23 | // network name & link |
||
24 | if ($info_nets['link']=="") { echo "<th>".$info_nets['network']."</th>"; } |
||
25 | else { echo "<th><a href='".$info_nets['link']."'>".$info_nets['network']."</a></th>"; } |
||
26 | // netlist |
||
27 | $netlist[$n] = $info_nets['id']; |
||
28 | $n++; |
||
29 | } |
||
30 | |||
31 | echo "</tr>"; |
||
32 | // table body |
||
33 | $cats =& $db->query("SELECT * FROM categories"); |
||
34 | while ($cats->fetchInto($info_cats, DB_FETCHMODE_ASSOC)) { |
||
35 | $res =& $db->query("SELECT * FROM resources WHERE category_id=".$info_cats['id']); |
||
36 | $first = true; |
||
37 | while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) { |
||
38 | echo "<tr>"; |
||
39 | |||
40 | // add rowspan on first resource on category |
||
41 | if ($first) { |
||
42 | echo "<td rowspan='".$res->numRows()."'>".$info_cats['category']."</td>"; |
||
43 | $first = false; |
||
44 | } |
||
45 | |||
46 | // resource picture |
||
47 | echo "<td><img src='".$info_res['picture']."' alt='".$info_res['resource']."'></td>"; |
||
48 | |||
49 | // resource name & link |
||
50 | if ($info_res['link_talk']=="") { echo "<td>".$info_res['resource']."</td>"; } |
||
51 | else { echo "<td><a href='".$info_res['link_talk']."'>".$info_res['resource']."</a></td>"; } |
||
52 | |||
53 | // resource state by network |
||
54 | for ($i=0;$i<$netcount;$i++) { |
||
55 | ///////////////////// |
||
24 | diffor | 56 | $mems =& $db->query("SELECT res_mem_rank.*, members.nick, ranks.rank FROM res_mem_rank JOIN members ON res_mem_rank.member_id=members.id JOIN ranks ON res_mem_rank.rank_id=ranks.id WHERE resource_id=".$info_res['id']." AND network_id=".$netlist[$i]); |
5 | diffor | 57 | echo "<td>"; |
58 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
||
24 | diffor | 59 | echo $info_mems['nick']." (".$info_mems['rank'].")"; |
5 | diffor | 60 | echo "<a href='./members_admin.php?act=2&id=".$info_mems['id']."'><img src='./img/act/edit.png' alt='edit'></a>"; |
61 | echo "<a href='./members_admin.php?act=3&id=".$info_mems['id']."'><img src='./img/act/delete.png' alt='delete'></a>"; |
||
24 | diffor | 62 | echo "<br>"; |
5 | diffor | 63 | } |
24 | diffor | 64 | echo "<a href='./members_admin.php?act=1&res=".$info_res['id']."&net=".$netlist[$i]."'><img src='./img/act/add.png' alt='add'></a>"; |
5 | diffor | 65 | echo "</td>"; |
66 | ///////////////////// |
||
67 | } |
||
68 | echo "</tr>"; |
||
69 | } |
||
70 | } |
||
71 | // table footer |
||
72 | echo "</table>"; |
||
73 | break; |
||
74 | case 1: |
||
6 | diffor | 75 | // Установка участника |
5 | diffor | 76 | echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
77 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
||
78 | echo "<input type='hidden' name='resource_id' value='".$resource_id."'>\n"; |
||
79 | echo "<input type='hidden' name='network_id' value='".$network_id."'>\n"; |
||
24 | diffor | 80 | |
5 | diffor | 81 | echo "Ник: "; |
82 | echo "<select name='member_id'>"; |
||
24 | diffor | 83 | $mems =& $db->query("SELECT * FROM members"); |
5 | diffor | 84 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
85 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
||
86 | }; |
||
87 | echo "</select><br>\n"; |
||
24 | diffor | 88 | |
89 | echo "Роль: "; |
||
90 | echo "<select name='rank_id'>"; |
||
91 | $ranks =& $db->query("SELECT * FROM ranks"); |
||
92 | while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
||
93 | echo "<option value='".$info_ranks['id']."'>".$info_ranks['rank']."</option>"; |
||
94 | }; |
||
95 | echo "</select><br>\n"; |
||
96 | |||
5 | diffor | 97 | echo "<input type='submit' value='Добавить'></form>\n"; |
98 | break; |
||
99 | case 2: |
||
6 | diffor | 100 | // Изменение участника |
101 | $rmrs =& $db->query("SELECT * FROM res_mem_rank WHERE id='$uid'"); |
||
102 | $rmrs->fetchInto($info_rmrs, DB_FETCHMODE_ASSOC); |
||
103 | echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
||
104 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
||
105 | echo "<input type='hidden' name='uid' value='".$uid."'>\n"; |
||
24 | diffor | 106 | |
6 | diffor | 107 | echo "Ник: "; |
108 | echo "<select name='member_id'>"; |
||
109 | $mems =& $db->query("SELECT * FROM members"); |
||
110 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
||
111 | if ($info_mems['id']==$info_rmrs['member_id']) { |
||
112 | echo "<option value='".$info_mems['id']."' selected>".$info_mems['nick']."</option>"; |
||
113 | } else { |
||
114 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
||
115 | } |
||
116 | }; |
||
117 | echo "</select><br>\n"; |
||
24 | diffor | 118 | |
119 | echo "Роль: "; |
||
120 | echo "<select name='rank_id'>"; |
||
121 | $ranks =& $db->query("SELECT * FROM ranks"); |
||
122 | while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
||
123 | if ($info_ranks['id']==$info_rmrs['rank_id']) { |
||
124 | echo "<option value='".$info_ranks['id']."' selected>".$info_ranks['rank']."</option>"; |
||
125 | } else { |
||
126 | echo "<option value='".$info_ranks['id']."'>".$info_ranks['rank']."</option>"; |
||
127 | } |
||
128 | }; |
||
129 | echo "</select><br>\n"; |
||
130 | |||
6 | diffor | 131 | echo "<input type='submit' value='Править'></form>\n"; |
5 | diffor | 132 | break; |
133 | case 3: |
||
6 | diffor | 134 | // Снятие участника |
135 | echo "<form action='./members_admin_p.php' method='POST'>\n"; |
||
136 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
||
137 | echo "<input type='hidden' name='uid' value='$uid'>\n"; |
||
138 | echo "<input type='submit' value='Удалить'></form>\n"; |
||
5 | diffor | 139 | break; |
140 | } |
||
141 | |||
142 | ?> |