Авторство | Последнее изменение | Открыть журнал | Скачать | RSS
<?php
require_once dirname(__FILE__)."/lib/init.php";
include "./inc/header.htm";
$act = $_GET["act"];
$resource_id = $_GET["res"];
$network_id = $_GET["net"];
switch ($act) {
case 0:
// table header
$nets =& $db->query("SELECT * FROM networks");
echo "<table>";
echo "<tr>";
echo "<th> </th><th> </th><th>Ресурс</th>";
$netlist = array();
$netcount = $nets->numRows();
$n = 0;
while ($nets->fetchInto($info_nets, DB_FETCHMODE_ASSOC)) {
// network name & link
if ($info_nets['link']=="") { echo "<th>".$info_nets['network']."</th>"; }
else { echo "<th><a href='".$info_nets['link']."'>".$info_nets['network']."</a></th>"; }
// netlist
$netlist[$n] = $info_nets['id'];
$n++;
}
echo "</tr>";
// table body
$cats =& $db->query("SELECT * FROM categories");
while ($cats->fetchInto($info_cats, DB_FETCHMODE_ASSOC)) {
$res =& $db->query("SELECT * FROM resources WHERE category_id=".$info_cats['id']);
$first = true;
while ($res->fetchInto($info_res, DB_FETCHMODE_ASSOC)) {
echo "<tr>";
// add rowspan on first resource on category
if ($first) {
echo "<td rowspan='".$res->numRows()."'>".$info_cats['category']."</td>";
$first = false;
}
// resource picture
echo "<td><img src='".$info_res['picture']."' alt='".$info_res['resource']."'></td>";
// resource name & link
if ($info_res['link_talk']=="") { echo "<td>".$info_res['resource']."</td>"; }
else { echo "<td><a href='".$info_res['link_talk']."'>".$info_res['resource']."</a></td>"; }
// 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]);
echo "<td>";
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
echo $info_mems['nick'];
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><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>";
/////////////////////
}
echo "</tr>";
}
}
// table footer
echo "</table>";
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'>";
while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {
echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>";
};
echo "</select><br>\n";
echo "<input type='submit' value='Добавить'></form>\n";
break;
case 2:
break;
case 3:
break;
}
?>