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

<?php

	$mirs =& $db->query("SELECT * FROM apt_reps");

	echo "<h2>Зеркалируемые репозитории</h2>\n";

	echo "<table>\n";

	echo "<tr>";

	echo "<th>№</th><th>Источник</th><th>Описание</th><th>Дистрибутивы</th>\n";

	$n = 0;

	while ($mirs->fetchInto($info_mirs, DB_FETCHMODE_ASSOC)) {

	    echo "<tr>\n";

	    echo " <td>".++$n."</td><td><a href='".$info_mirs['src_url']."'>".$info_mirs['src_name']."</a></td><td>".$info_mirs['description']."</td>\n";

	    $distrs =& $db->query("SELECT * FROM apt_distrs");

	    echo "<td>";

	    while ($distrs->fetchInto($info_distrs, DB_FETCHMODE_ASSOC)) {

		echo $info_distrs['distr'].": ";

		$vers =& $db->query("SELECT * FROM apt_vers JOIN apt_reps2vers ON apt_vers.id=apt_reps2vers.ver_id WHERE distr_id=".$info_distrs['id']." AND rep_id=".$info_mirs['id']);

		while ($vers->fetchInto($info_vers, DB_FETCHMODE_ASSOC)) {

		    echo $info_vers['codename']." ";

		}

		echo "<br>";

	    }

	    echo "</td>";

	    echo "</tr>";

	}

	echo "</table>\n";

?>