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