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

<?php

	require_once dirname(__FILE__)."/lib/init.php";

	include "./inc/header.htm";

$act = $_GET["act"];

$resource_id = $_GET["res"];

$network_id = $_GET["net"];

$member_id = $_GET["mid"];

$uid = $_GET["id"];

switch ($act) {

    case 0:

	// table header

	$nets =& $db->query("SELECT * FROM networks");

	echo "<table>";

	echo "<tr>";

	echo "<th>&nbsp;</th><th>&nbsp;</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:

	// Изменение участника

	$rmrs =& $db->query("SELECT * FROM res_mem_rank WHERE id='$uid'");

	$rmrs->fetchInto($info_rmrs, DB_FETCHMODE_ASSOC);

	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");

	while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) {

	    if ($info_mems['id']==$info_rmrs['member_id']) {

		echo "<option value='".$info_mems['id']."' selected>".$info_mems['nick']."</option>";

	    } else {

		echo "<option value='".$info_mems['id']."'>".$info_mems['nick']."</option>";

	    }

	};

	echo "</select><br>\n";

	echo "<input type='submit' value='Править'></form>\n";

    break;

    case 3:

	// Снятие участника

	echo "<form action='./members_admin_p.php' method='POST'>\n";

	echo "<input type='hidden' name='act' value='".$act."'>\n";

	echo "<input type='hidden' name='uid' value='$uid'>\n";

	echo "<input type='submit' value='Удалить'></form>\n";

    break;

}

?>