Редакция 5 | Содержимое файла | Сравнить с предыдущей | Последнее изменение | Открыть журнал | 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 | ///////////////////// |
||
56 | $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]); |
||
57 | echo "<td>"; |
||
58 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
||
59 | echo $info_mems['nick']; |
||
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>"; |
||
62 | } |
||
63 | 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>"; |
||
64 | echo "</td>"; |
||
65 | ///////////////////// |
||
66 | } |
||
67 | echo "</tr>"; |
||
68 | } |
||
69 | } |
||
70 | // table footer |
||
71 | echo "</table>"; |
||
72 | break; |
||
73 | case 1: |
||
6 | diffor | 74 | // Установка участника |
5 | diffor | 75 | $mems =& $db->query("SELECT * FROM members"); |
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"; |
||
80 | echo "Ник: "; |
||
81 | echo "<select name='member_id'>"; |
||
82 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
||
83 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
||
84 | }; |
||
85 | echo "</select><br>\n"; |
||
86 | echo "<input type='submit' value='Добавить'></form>\n"; |
||
87 | break; |
||
88 | case 2: |
||
6 | diffor | 89 | // Изменение участника |
90 | $rmrs =& $db->query("SELECT * FROM res_mem_rank WHERE id='$uid'"); |
||
91 | $rmrs->fetchInto($info_rmrs, DB_FETCHMODE_ASSOC); |
||
92 | echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
||
93 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
||
94 | echo "<input type='hidden' name='uid' value='".$uid."'>\n"; |
||
95 | echo "Ник: "; |
||
96 | echo "<select name='member_id'>"; |
||
97 | $mems =& $db->query("SELECT * FROM members"); |
||
98 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
||
99 | if ($info_mems['id']==$info_rmrs['member_id']) { |
||
100 | echo "<option value='".$info_mems['id']."' selected>".$info_mems['nick']."</option>"; |
||
101 | } else { |
||
102 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
||
103 | } |
||
104 | }; |
||
105 | echo "</select><br>\n"; |
||
106 | echo "<input type='submit' value='Править'></form>\n"; |
||
5 | diffor | 107 | break; |
108 | case 3: |
||
6 | diffor | 109 | // Снятие участника |
110 | echo "<form action='./members_admin_p.php' method='POST'>\n"; |
||
111 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
||
112 | echo "<input type='hidden' name='uid' value='$uid'>\n"; |
||
113 | echo "<input type='submit' value='Удалить'></form>\n"; |
||
5 | diffor | 114 | break; |
115 | } |
||
116 | |||
117 | ?> |