Редакция 6 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 6 | Редакция 24 | ||
---|---|---|---|
Строка 51... | Строка 51... | ||
51 | else { echo "<td><a href='".$info_res['link_talk']."'>".$info_res['resource']."</a></td>"; } |
51 | else { echo "<td><a href='".$info_res['link_talk']."'>".$info_res['resource']."</a></td>"; } |
52 | 52 | ||
53 | // resource state by network
|
53 | // resource state by network
|
54 | for ($i=0;$i<$netcount;$i++) { |
54 | for ($i=0;$i<$netcount;$i++) { |
55 | /////////////////////
|
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]); |
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]); |
57 | echo "<td>"; |
57 | echo "<td>"; |
58 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
58 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
59 | echo $info_mems['nick']; |
59 | echo $info_mems['nick']." (".$info_mems['rank'].")"; |
60 | echo "<a href='./members_admin.php?act=2&id=".$info_mems['id']."'><img src='./img/act/edit.png' alt='edit'></a>"; |
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>"; |
61 | echo "<a href='./members_admin.php?act=3&id=".$info_mems['id']."'><img src='./img/act/delete.png' alt='delete'></a>"; |
- | 62 | echo "<br>"; |
|
62 | }
|
63 | }
|
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 "<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 | echo "</td>"; |
65 | /////////////////////
|
66 | /////////////////////
|
66 | }
|
67 | }
|
67 | echo "</tr>"; |
68 | echo "</tr>"; |
68 | }
|
69 | }
|
Строка 70... | Строка 71... | ||
70 | // table footer
|
71 | // table footer
|
71 | echo "</table>"; |
72 | echo "</table>"; |
72 | break; |
73 | break; |
73 | case 1: |
74 | case 1: |
74 | // Установка участника
|
75 | // Установка участника
|
75 | $mems =& $db->query("SELECT * FROM members"); |
- | |
76 | echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
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"; |
77 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
78 | echo "<input type='hidden' name='resource_id' value='".$resource_id."'>\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"; |
79 | echo "<input type='hidden' name='network_id' value='".$network_id."'>\n"; |
- | 80 | ||
80 | echo "Ник: "; |
81 | echo "Ник: "; |
81 | echo "<select name='member_id'>"; |
82 | echo "<select name='member_id'>"; |
- | 83 | $mems =& $db->query("SELECT * FROM members"); |
|
82 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
84 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
83 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
85 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
84 | }; |
86 | }; |
85 | echo "</select><br>\n"; |
87 | echo "</select><br>\n"; |
- | 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 | ||
86 | echo "<input type='submit' value='Добавить'></form>\n"; |
97 | echo "<input type='submit' value='Добавить'></form>\n"; |
87 | break; |
98 | break; |
88 | case 2: |
99 | case 2: |
89 | // Изменение участника
|
100 | // Изменение участника
|
90 | $rmrs =& $db->query("SELECT * FROM res_mem_rank WHERE id='$uid'"); |
101 | $rmrs =& $db->query("SELECT * FROM res_mem_rank WHERE id='$uid'"); |
91 | $rmrs->fetchInto($info_rmrs, DB_FETCHMODE_ASSOC); |
102 | $rmrs->fetchInto($info_rmrs, DB_FETCHMODE_ASSOC); |
92 | echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
103 | echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
93 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
104 | echo "<input type='hidden' name='act' value='".$act."'>\n"; |
94 | echo "<input type='hidden' name='uid' value='".$uid."'>\n"; |
105 | echo "<input type='hidden' name='uid' value='".$uid."'>\n"; |
- | 106 | ||
95 | echo "Ник: "; |
107 | echo "Ник: "; |
96 | echo "<select name='member_id'>"; |
108 | echo "<select name='member_id'>"; |
97 | $mems =& $db->query("SELECT * FROM members"); |
109 | $mems =& $db->query("SELECT * FROM members"); |
98 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
110 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
99 | if ($info_mems['id']==$info_rmrs['member_id']) { |
111 | if ($info_mems['id']==$info_rmrs['member_id']) { |
Строка 101... | Строка 113... | ||
101 | } else { |
113 | } else { |
102 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
114 | echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
103 | }
|
115 | }
|
104 | }; |
116 | }; |
105 | echo "</select><br>\n"; |
117 | echo "</select><br>\n"; |
- | 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 | ||
106 | echo "<input type='submit' value='Править'></form>\n"; |
131 | echo "<input type='submit' value='Править'></form>\n"; |
107 | break; |
132 | break; |
108 | case 3: |
133 | case 3: |
109 | // Снятие участника
|
134 | // Снятие участника
|
110 | echo "<form action='./members_admin_p.php' method='POST'>\n"; |
135 | echo "<form action='./members_admin_p.php' method='POST'>\n"; |