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

Сравнить редакции

Не учитывать пробелы Редакция 23 → Редакция 24

/trunk/members_admin_p.php
6,10 → 6,10
 
switch($act) {
case 1:
$res =& $db->query("INSERT INTO res_mem_rank SET resource_id='".$_POST['resource_id']."', network_id='".$_POST['network_id']."', member_id='".$_POST['member_id']."'");
$res =& $db->query("INSERT INTO res_mem_rank SET resource_id='".$_POST['resource_id']."', network_id='".$_POST['network_id']."', member_id='".$_POST['member_id']."', rank_id='".$_POST['rank_id']."'");
break;
case 2:
$res =& $db->query("UPDATE res_mem_rank SET member_id='".$_POST['member_id']."' WHERE id='".$_POST['uid']."'");
$res =& $db->query("UPDATE res_mem_rank SET member_id='".$_POST['member_id']."', rank_id='".$_POST['rank_id']."' WHERE id='".$_POST['uid']."'");
break;
case 3:
$res =& $db->query("DELETE FROM res_mem_rank WHERE id='".$_POST['uid']."'");
/trunk/members_admin.php
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:
/trunk/details.php
10,10 → 10,11
$res = abs(intval($_GET["res"]));
 
$ress =& $db->query("SELECT * FROM resources WHERE id=".$res);
$ress =& $db->query("SELECT * FROM resources JOIN members ON resources.member_id=members.id WHERE resources.id=".$res);
while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {
echo "<h1>".$info_ress['resource'].".niX-FILES</h1>";
echo $info_ress['description']."<br>";
echo "<br>Куратор: ".$info_ress['nick']."<br>";
echo "Ссылка: <a href='".$info_ress['link_res']."'>".$info_ress['link_res']."</a><br>";
echo "Обсуждение: <a href='".$info_ress['link_talk']."'>".$info_ress['link_talk']."</a>";
if ($info_ress['custom']!=null) {