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

<?php

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

	include "./inc/header.htm";

?>

 <h2>niX-FILES</h2>

 <h1>любые файлы *nix тематики в локальных сетях Барнаула</h1>

 <h3><i>изучай/пользуй/обновляй линукс вместе с nix-files.org.ru</i></h3>

<?php

$memb = abs(intval($_GET["memb"]));

if($memb==0) {

	$mems =& $db->query("SELECT * FROM members");

	echo "<table>";

	echo "<tr>";

	echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Куратор</th><th>Админ</th>\n";

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

	    echo "<tr><td><a href='./members.php?memb=".$info_mems['id']."'>".$info_mems['nick']."</a></td>\n";

	    echo "<td><img src='".$info_mems['avatar']."' alt='avatar'></td><td><img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."</td>\n";

	    echo "<td>";

	    $ress =& $db->query("SELECT * FROM resources WHERE member_id=".$info_mems['id']);

	    while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {

		echo "<img src='".$info_ress['picture']."' alt='".$info_ress['resource']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a><br>";

	    }

	    echo "</td>";

	    echo "<td>";

	    $srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$info_mems['id']);

	    if ($srvs->numRows()==0)

		 echo "&mdash";

	    else

		while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {

		    echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a>";

	    }

	    echo "</td>\n";

	    echo "</tr>\n";

	}

	echo "</table>";

}

else {

	$mems =& $db->query("SELECT * FROM members WHERE id=".$memb);

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

	    echo "<h1>".$info_mems['nick']."</h1>\n";

	    echo "<img src='".$info_mems['avatar']."' alt='avatar'><br>\n";

	    echo "<img src='./img/contact/jabber_protocol.png' alt='Jabber' title='Jabber'>".$info_mems['jabber']."<br>\n";

	    echo "<br>Курирует:<br> | ";

	    $ress =& $db->query("SELECT * FROM resources WHERE member_id=".$memb);

	    while ($ress->fetchInto($info_ress, DB_FETCHMODE_ASSOC)) {

		echo "<img src='".$info_ress['picture']."'> <a href='./details.php?res=".$info_ress["id"]."'>".$info_ress['resource']."</a> | ";

	    }

	    echo "<br>";

	    echo "<br>Администрирует:<br> | ";

	    $srvs =& $db->query("SELECT * FROM servers WHERE member_id=".$memb);

	    while ($srvs->fetchInto($info_srvs, DB_FETCHMODE_ASSOC)) {

		echo "<a href='./servers.php?srv=".$info_srvs['id']."'>".$info_srvs['server']."</a> |<br>";

	    }

	}

}

	include "./inc/footer.htm";

?>