53,14 → 53,15 |
// resource state by network |
for ($i=0;$i<$netcount;$i++) { |
///////////////////// |
$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]); |
$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]); |
echo "<td>"; |
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
echo $info_mems['nick']; |
echo $info_mems['nick']." (".$info_mems['rank'].")"; |
echo "<a href='./members_admin.php?act=2&id=".$info_mems['id']."'><img src='./img/act/edit.png' alt='edit'></a>"; |
echo "<a href='./members_admin.php?act=3&id=".$info_mems['id']."'><img src='./img/act/delete.png' alt='delete'></a>"; |
echo "<br>"; |
} |
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>"; |
echo "<a href='./members_admin.php?act=1&res=".$info_res['id']."&net=".$netlist[$i]."'><img src='./img/act/add.png' alt='add'></a>"; |
echo "</td>"; |
///////////////////// |
} |
72,17 → 73,27 |
break; |
case 1: |
// Установка участника |
$mems =& $db->query("SELECT * FROM members"); |
echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
echo "<input type='hidden' name='act' value='".$act."'>\n"; |
echo "<input type='hidden' name='resource_id' value='".$resource_id."'>\n"; |
echo "<input type='hidden' name='network_id' value='".$network_id."'>\n"; |
|
echo "Ник: "; |
echo "<select name='member_id'>"; |
$mems =& $db->query("SELECT * FROM members"); |
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>"; |
}; |
echo "</select><br>\n"; |
|
echo "Роль: "; |
echo "<select name='rank_id'>"; |
$ranks =& $db->query("SELECT * FROM ranks"); |
while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
echo "<option value='".$info_ranks['id']."'>".$info_ranks['rank']."</option>"; |
}; |
echo "</select><br>\n"; |
|
echo "<input type='submit' value='Добавить'></form>\n"; |
break; |
case 2: |
92,6 → 103,7 |
echo "<form action='./members_admin_p.php' method='POST' enctype='multipart/form-data'>\n"; |
echo "<input type='hidden' name='act' value='".$act."'>\n"; |
echo "<input type='hidden' name='uid' value='".$uid."'>\n"; |
|
echo "Ник: "; |
echo "<select name='member_id'>"; |
$mems =& $db->query("SELECT * FROM members"); |
103,6 → 115,19 |
} |
}; |
echo "</select><br>\n"; |
|
echo "Роль: "; |
echo "<select name='rank_id'>"; |
$ranks =& $db->query("SELECT * FROM ranks"); |
while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
if ($info_ranks['id']==$info_rmrs['rank_id']) { |
echo "<option value='".$info_ranks['id']."' selected>".$info_ranks['rank']."</option>"; |
} else { |
echo "<option value='".$info_ranks['id']."'>".$info_ranks['rank']."</option>"; |
} |
}; |
echo "</select><br>\n"; |
|
echo "<input type='submit' value='Править'></form>\n"; |
break; |
case 3: |