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

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

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

/trunk/custom/apt/apt.php
1,12 → 1,28
<?php
$mirs =& $db->query("SELECT * FROM apt_mirrors");
$mirs =& $db->query("SELECT * FROM apt_reps");
echo "<h2>Зеркалируемые репозитории</h2>\n";
echo "<table>\n";
echo "<tr>";
echo "<th>№</th><th>Источник</th><th>Описание</th>\n";
echo "<th>№</th><th>Источник</th><th>Описание</th><th>Дистрибутивы</th>\n";
$n = 0;
while ($mirs->fetchInto($info_mirs, DB_FETCHMODE_ASSOC)) {
echo "<tr><td>".++$n."</td><td><a href='".$info_mirs['src_url']."'>".$info_mirs['src_name']."</a></td><td>".$info_mirs['description']."</td></tr>\n";
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";
?>